A payment schedule shows when loan payments are due and how each payment is divided between principal and interest. Use this calculator to estimate a fixed-rate loan’s monthly payment and total interest from the amount borrowed, APR, and term; it does not generate a dated, payment-by-payment amortization table.
Formula
This calculator estimates the level monthly payment on a fully amortizing loan with a fixed annual percentage rate. The payment formula is:
Payment = P × r ÷ [1 − (1 + r)−n]
- P is the loan principal, in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 1,200. For an 8% APR, r = 0.08 ÷ 12.
- n is the number of monthly payments: loan term in years × 12.
The schedule’s total interest is estimated as monthly payment × n − P. The payment is displayed to the nearest cent, and the total uses that rounded payment. The formula assumes a regular payment amount and monthly periods; it is not a quote or a lender’s official amortization schedule.
Worked Example
Using the calculator’s default inputs—$20,000 principal, 8% APR, and a five-year term:
- Convert APR to a monthly decimal rate:
r = 8 ÷ 1,200 = 0.0066667. - Find the number of payments:
n = 5 × 12 = 60. - Apply the payment formula:
20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] ≈ $405.53. - Calculate total interest using the displayed monthly payment:
$405.53 × 60 − $20,000 = $4,331.80.
For these inputs, the estimated monthly payment is $405.53, and estimated total interest is $4,331.80. A lender’s figures can differ because of its payment dates, rounding, fees, or other loan terms.
Assumptions
- The interest rate stays fixed throughout the term.
- Payments are equal, made monthly, and treated as occurring at the end of each monthly period.
- Interest is modelled monthly at APR ÷ 12.
- The calculation excludes fees, taxes, insurance, PMI, escrow, and any charges not entered as an input.
What a Payment Schedule Shows
In an amortizing loan schedule, each row typically lists a payment date, the amount due, the interest portion, the principal portion, and the balance remaining afterward. At the beginning of a standard fixed-payment loan, the outstanding balance is larger, so more of the payment generally goes toward interest. As principal is repaid, the interest portion tends to shrink and the principal portion tends to grow. The scheduled payment itself remains level if the rate and loan terms remain unchanged.
For example, a $405.53 payment is not necessarily $405.53 of principal reduction. Interest accrues on the unpaid balance, and the period’s interest is accounted for before the remaining payment reduces principal. Over the full modeled term, the principal portions add up to the original $20,000; interest is additional. The calculator reports the payment and aggregate interest, not the individual rows or exact due dates.
When to Use This Estimate
A payment estimate can help you understand how loan size, APR, and term affect the regular payment and total interest. To explore a different scenario, change one input at a time. A larger principal generally increases the payment; a longer term usually lowers the required monthly payment but means more payments are made. The total interest depends on all three inputs and can rise when the repayment period is extended.
Use the actual figures in a lender’s disclosure or loan agreement for planning around a specific loan. In particular, confirm whether the quoted amount financed includes fees, whether the rate is fixed, how often payments are due, and whether the first payment period differs from a standard month. If the loan has variable rates, irregular payments, a balloon payment, or interest-only periods, this basic formula does not describe its full schedule.
Common Mistakes and Limits
- Entering APR as a decimal: Enter 8 for 8%, not 0.08. The calculator converts the percentage to a monthly rate.
- Confusing payment with total cost: The monthly payment is one installment. Total interest is the modeled interest across the term, and principal repayment is separate.
- Assuming every loan follows this formula: The calculation is for equal monthly payments on a fixed-rate, fully amortizing loan. Fees, payment holidays, rate changes, and unusual schedules can change the actual amounts.
- Rounding too early: Small rounding differences can add up across many installments. The estimate uses a monthly payment rounded to cents, so a lender’s schedule may show slightly different totals.
APR is the rate input, not a complete description of every charge or the exact annual cost under every lender’s calculation method. Get the applicable rate, fees, and payment schedule from the lender rather than treating the example defaults as market figures.
Frequently Asked Questions
What does “payment schedule” mean?
A payment schedule is a timeline or table showing required payments and, for an amortizing loan, how each payment is split between principal and interest and what balance remains.
Does this calculator show every payment date?
No. It estimates the level monthly payment and total interest. Exact dates and a row-by-row schedule depend on the lender’s loan terms and payment calendar.
Why does the interest portion change if the payment stays the same?
For a typical amortizing loan, interest is calculated on the remaining principal. As that balance falls, less interest accrues for a period, leaving more of a level payment to reduce principal.
Does a longer loan term reduce total interest?
It may reduce the required monthly payment, but it generally means interest accrues over more monthly periods. Compare the payment and total interest estimates together; actual terms and charges may differ.
Why is my lender’s payment different?
The amount may include fees or other financed charges, or use different payment dates, rounding, or terms. Check the lender’s disclosure for the exact principal, APR, payment amount, and schedule.
This result is an estimate for educational purposes, 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