A payment schedule shows when payments are due, how much is expected, and—on an amortizing loan—how each payment is divided between principal and interest. This calculator estimates a fixed-rate loan’s monthly payment and total interest from the loan amount, annual percentage rate (APR), and term.
Formula
For a fixed-rate loan with equal monthly payments, the monthly payment is calculated as PMT = P × r / [1 − (1 + r)−n]. Here, P is the amount borrowed in dollars, r is the monthly interest rate as a decimal (APR ÷ 12 ÷ 100), and n is the number of monthly payments (loan term in years × 12). Total interest is estimated as I = PMT × n − P, using the monthly payment rounded to cents.
The calculator assumes the APR is a nominal annual rate divided into monthly periods. It does not derive the APR from fees or determine a lender’s actual schedule. The result is a mathematical estimate under these assumptions.
Worked Example
Using the calculator’s default inputs: principal P = $20,000, APR 8%, and term 5 years.
- Convert APR to a monthly decimal rate: r = 8 ÷ 100 ÷ 12 = 0.0066667.
- Convert the term to payments: n = 5 × 12 = 60.
- Apply the payment formula: PMT = 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
- Rounded to cents, the estimated monthly payment is $405.53.
- Using that rounded payment, total scheduled payments are $405.53 × 60 = $24,331.80; estimated total interest is $24,331.80 − $20,000 = $4,331.80.
Assumptions
- The interest rate stays fixed for the full term.
- Payments are equal, made monthly, and applied at regular intervals.
- Interest is modelled monthly at APR divided by 12.
- Fees, taxes, insurance, PMI, escrow, late charges, and extra payments are not included.
What a Payment Schedule Is For
A payment schedule is a calendar and breakdown of the payments expected under an agreement. It helps a borrower see due dates and amounts, track what has been paid, and understand the planned path toward repayment. For a lender or service provider, it sets out the expected collection dates and amounts. The exact format varies: a schedule may be a short list of due dates, a recurring billing plan, or a detailed loan amortization table.
For an amortizing loan, each scheduled payment typically covers interest accrued for the period and pays down some principal. Early in a standard fixed-rate loan, the outstanding balance is larger, so the interest portion tends to be larger. As principal falls, the interest portion generally shrinks and more of each level payment goes toward principal. The payment amount can stay the same even as its components change.
How to Read a Loan Schedule
A detailed schedule commonly lists the payment number or date, opening balance, payment amount, interest charged, principal repaid, and closing balance. For instance, if a monthly payment is $405.53, the schedule does not mean that $405.53 reduces the balance. Part of it pays interest; the remainder reduces principal. The precise split depends on the balance, rate, payment timing, and the lender’s calculation and rounding methods.
Schedules are useful for planning cash flow and checking account records against statements. They can also illustrate how a changed term affects the payment and total interest in a simplified model. A schedule is not necessarily a guarantee that every future amount will remain unchanged: variable rates, missed or delayed payments, fees, payment holidays, and contract-specific rules can alter what is due.
Choosing Inputs and Understanding Limits
Enter the amount financed rather than a purchase price if the loan covers only part of a purchase. Use the APR supplied for the loan you are modelling, and enter the term in years. The calculator converts that term to monthly payments; it supports terms from 0.0833 to 50 years and APRs from 0.01% to 100%.
- Principal: include only the amount borrowed. If fees are financed, they may be part of the actual principal.
- APR: use the relevant disclosed APR, not a monthly rate or a percentage typed as a decimal. The calculator expects, for example, 8 for 8%.
- Term: confirm whether the agreement states years or months before converting. A five-year term corresponds to 60 monthly payments under this model.
The formula assumes level monthly payments and a constant rate. It is not appropriate without adjustment for an interest-only period, a balloon payment, irregular payment dates, a variable rate, or a loan with a different compounding convention. It also excludes charges and insurance, so its payment should not be treated as a complete bill or payoff quote. The lender’s own schedule and disclosures may use particular day-count, rounding, or payment-allocation methods.
Common Schedule Questions and Misconceptions
A payment schedule and an amortization schedule are related but not identical terms. A payment schedule can simply show when payments are due; an amortization schedule goes further by showing how each loan payment is allocated and how the balance changes. Another common misconception is that the total-interest estimate includes every cost of borrowing. Here, it is only the modelled interest implied by the input principal, APR, term, and rounded payment. Fees or other costs are not counted.
Rounding also matters. The calculator rounds the monthly payment to the nearest cent and uses that rounded figure to estimate total interest. Actual schedules can differ by a small amount because a lender may round each period’s interest, use exact dates, or make a final payment adjustment. If a payment is late, extra payments are made, or the rate changes, the original schedule may no longer describe the balance accurately.
Frequently Asked Questions
What is the purpose of a payment schedule?
A payment schedule identifies when payments are due and the amounts expected. For a loan, a detailed version can also show how each payment is split between interest and principal.
Is a payment schedule the same as an amortization schedule?
Not necessarily. A payment schedule may list only dates and amounts, while an amortization schedule shows the interest, principal, and remaining balance for each payment period.
Why does the interest portion change if the payment is fixed?
With a standard amortizing loan, interest is calculated on the outstanding balance. As principal is repaid, the balance falls, so the interest portion generally decreases and more of a level payment goes to principal.
Does this calculator include fees or insurance?
No. It estimates principal-and-interest payments under the stated assumptions. Fees, insurance, taxes, escrow, and other charges are not inputs and are excluded.
Can my actual payment schedule differ from this estimate?
Yes. Variable rates, actual payment dates, fees, rounding practices, extra or missed payments, and contract terms can change the schedule. The result is an estimate and 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
- Closing Costs on a House Loan: What to Expect$405.53
- Secured Loan for Home Refinancing: Payment Calculator$405.53
- Closing Cost House Calculator: Estimate Buyer Costs$8,500.00
- Closing Cost House Estimate Calculator
- Loan Repayment Extension Request Letter: What to Include$405.53
- Refinance Calculator With PMI and Loan Term