A payment schedule is a plan showing when payments are due, how much is due, and how long payments continue. For a fixed-rate loan with equal monthly payments, this calculator estimates the monthly payment and total interest from the loan amount, annual percentage rate (APR), and term.
Formula
For equal monthly payments on a fixed-rate loan, the payment formula is:
Monthly payment = P × r / (1 − (1 + r)−n)
- P is the starting loan principal, in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 1200 when APR is entered as a percentage per year.
- n is the number of monthly payments: loan term in years × 12.
The calculator rounds the monthly payment to the nearest cent. It estimates total interest as the rounded monthly payment multiplied by the number of payments, minus the starting principal. This assumes each scheduled payment is made as calculated and does not adjust the final payment for lender-specific rounding.
Worked Example
Using the defaults—$20,000 principal, 8% APR, and a five-year term—there are 60 monthly payments. The monthly rate is 8 ÷ 1200 = 0.0066667.
Payment = 20,000 × 0.0066667 ÷ (1 − (1 + 0.0066667)−60)
The result before rounding is about $405.53, so the displayed monthly payment is $405.53. Estimated total interest is $405.53 × 60 − $20,000 = $4,331.80. Actual lender schedules can differ by a few cents or more if the payment dates, rate calculation, fees, or final-payment adjustment differ.
Assumptions
- The interest rate stays fixed for the full term.
- Payments are equal, monthly, and made at the end of each monthly period.
- Interest compounds monthly at APR ÷ 12.
- Fees, taxes, insurance, PMI, escrow, late charges, and extra payments are not included.
What a Payment Schedule Includes
In everyday use, a payment schedule can refer to a simple calendar of due dates and amounts, or to a detailed loan amortization schedule. A calendar may show only the amount and due date. An amortization schedule breaks each installment into principal—the amount that reduces what is owed—and interest, the charge for borrowing over that period. It may also show the balance remaining after each payment.
For example, a 12-month installment agreement might list one payment due each month. A loan schedule could additionally show how the first payment is divided between interest and principal, then show how that division changes later. With a standard fully amortizing fixed-rate loan, the payment amount is level, but the interest portion generally declines as the outstanding balance falls; more of each later payment therefore goes toward principal.
How a Loan Schedule Works
A schedule is built from the balance, interest calculation, payment amount, and timing. For a typical fixed-rate loan with level payments, interest for a period is calculated on the balance at the start of that period. The payment covers that interest first, and the remainder reduces principal. The next period’s interest is then calculated on the reduced balance.
- Start with the amount borrowed and the agreed rate and term.
- Determine each payment’s due date and amount.
- For each period, calculate interest on the outstanding balance.
- Apply the payment to interest and principal, then carry the new balance forward.
- Continue until the balance reaches zero, subject to any final-payment adjustment.
The calculator provides a payment and a total-interest estimate, not a dated, period-by-period schedule. A complete schedule also needs the first due date and the lender’s rules for calculating interest between dates, handling rounding, and applying payments.
Payment Schedule Types and Comparisons
Not every schedule has equal payments. The appropriate structure depends on the agreement, so the phrase “payment schedule” alone does not specify a payment amount or repayment method.
- Fixed installment schedule: Payments are planned at regular intervals, often in equal amounts. A fixed-rate amortizing loan is one example.
- Variable-rate schedule: Payments or the share going to interest may change when the rate changes, according to the agreement.
- Interest-only period: Scheduled payments cover interest for a stated period, so they may not reduce principal during that time.
- Balloon schedule: Regular payments are followed by a larger remaining payment at a specified point.
- Milestone or invoice schedule: Amounts are due after particular stages, deliveries, or dates rather than as equal loan installments.
These descriptions are general. The contract determines the actual payment dates, amounts, rate changes, and any balance due at the end.
How to Read and Check a Schedule
Check the amount due, due date, payment frequency, and remaining balance. For a loan amortization table, look for separate principal and interest columns and confirm whether the displayed balance is before or after each payment. Compare the schedule’s total of payments with the amount borrowed: the difference may represent interest, but fees and other charges can affect the total cost shown in a contract.
Common sources of discrepancies include:
- Different APR or term: A small input difference changes the calculated installment.
- Fees or add-ons: An amount financed may differ from the cash price or principal expected.
- Date-based interest: A first period longer or shorter than a month can change interest.
- Rounding: A lender may round each period’s interest separately and adjust the final payment.
- Extra or missed payments: These can change the balance and later entries, depending on how payments are applied.
Use the APR and term specified in the lender’s disclosure when making an estimate. Do not assume the calculator’s result is the amount due on a particular date.
Limits and Common Misconceptions
A payment schedule is not necessarily a guarantee that every future payment will remain unchanged. A variable rate, payment adjustment, late payment, or contract-specific fee can alter the amounts. Likewise, an equal monthly payment does not mean the same amount of principal is repaid every month: with a standard amortizing loan, the principal and interest shares usually shift over time.
This calculator models a fixed rate, monthly periods, equal payments, and no additional charges. It is useful for understanding the basic relationship among principal, rate, term, payment, and interest, but it cannot reproduce every contract’s accounting or predict changes to a variable-rate agreement. Rates and fees are inputs; obtain the actual figures from the lender’s disclosure.
Frequently Asked Questions
What does payment schedule mean?
A payment schedule is a record or plan of the amounts to pay and the dates they are due. For loans, it may also show how payments are divided between principal and interest.
Is a payment schedule the same as an amortization schedule?
Not always. An amortization schedule is a detailed type of loan payment schedule that tracks principal, interest, and the remaining balance over time. A basic payment schedule may list only due dates and amounts.
Does a payment schedule include interest?
A loan schedule may include interest, either as part of each installment or in a separate column. A simple calendar or invoice plan may not break out interest at all; check what the document covers.
Why does the interest portion change if the payment stays the same?
On a typical fixed-rate amortizing loan, interest is calculated on the outstanding balance. As that balance declines, the interest portion tends to fall and a larger share of the level payment reduces principal.
Can a payment schedule change?
It can change if the agreement allows rate or payment adjustments, or if payment timing, extra payments, missed payments, or other charges affect the balance. The contract and updated lender schedule control the actual amounts.
This result is an estimate; the lender’s disclosure gives the exact figures.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int | Total interest | $ | pmt * yrs * 12 - p | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- June Balance Date: What It Means for Loan Balances$405.53
- L&T Finance Gold Loan: How It Works and What to Check
- Journal Entry to Correct a Beginning Balance
- JS Bank Gold Loan: Eligibility, Process and Costs
- Journal Entry for a Bank Loan: Debit and Credit$20,000.00
- Journal Entry to Adjust Beginning Balance