A payment schedule table shows each loan payment, the amount applied to principal and interest, and the balance left afterward. Enter a loan amount, APR and term to calculate the monthly payment and total interest; this calculator also explains how to build a month-by-month schedule.
Formula
The calculator uses the standard fixed-payment amortizing-loan formula. It calculates the monthly payment as:
PMT = P × r ÷ [1 − (1 + r)−n]
- P is the starting 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.
- PMT is the level monthly payment, in dollars.
Total interest over the term is calculated as PMT × n − P. The schedule itself is produced by repeating the monthly interest and balance calculations: interest for a period equals the opening balance × r; principal paid equals the payment − interest; and closing balance equals opening balance − principal paid. The first two outputs here are the monthly payment and total interest, not a complete list of monthly rows.
Worked Example
Using the calculator’s default inputs—$20,000 principal, 8% APR and a five-year term—the schedule has 60 monthly payments. The monthly rate is 0.08 ÷ 12 = 0.0066667.
Monthly payment = 20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60] = $405.53 when rounded to cents. Total interest, using the unrounded formula payment displayed to cents, is $405.53 × 60 − $20,000 = $4,331.80.
For an illustrative first row, interest is $20,000 × 0.0066667 = $133.33. Principal paid is $405.53 − $133.33 = $272.20, leaving an estimated balance of $19,727.80. In the second month, interest is calculated on that lower opening balance, so a larger portion of the same payment generally goes to principal.
How to Read a Payment Schedule
A payment schedule, often called an amortization schedule, lays out the repayment period by period. A typical table includes the payment number or date, opening balance, payment amount, interest, principal and closing balance. For a fixed-rate loan with regular monthly payments, the payment amount stays level under the formula’s assumptions, while its allocation changes over time.
- Opening balance: the amount owed at the start of the period.
- Interest: the period’s finance charge, calculated from the balance and applicable rate.
- Principal: the part of the payment that reduces the amount borrowed.
- Closing balance: the remaining principal after the payment is applied.
Small differences between a calculated schedule and a lender’s statement can result from rounding, payment dates, daily-interest methods, fees or other contract details. Check whether a schedule uses cents rounding for each row or retains extra decimal places until the end.
Making a Schedule Row by Row
To build a simple monthly schedule, start with the loan balance and repeat the same sequence for every payment. Use the lender’s actual payment amount and rate conventions when reconciling the result with an account statement.
- Convert the annual percentage rate to a monthly decimal rate by dividing by 1,200, if the loan uses monthly compounding at APR ÷ 12.
- Multiply the opening balance by that monthly rate to find the period’s interest.
- Subtract interest from the payment to find the principal portion.
- Subtract principal paid from the opening balance to get the closing balance; carry that balance into the next row.
- Continue until the scheduled final payment. The last payment may need adjustment for accumulated rounding or contract-specific calculations.
For example, if a row begins with a $10,000 balance and its interest calculation is $60, a $300 payment contains $60 interest and $240 principal. The next opening balance is $9,760. This is an example of the arithmetic, not a quoted loan offer.
What the Calculator Includes and Omits
The calculation assumes the loan is fully repaid through equal monthly payments, a fixed APR, monthly periods and no changes to the payment schedule. It gives a mathematical estimate from the values entered. The calculator does not generate dated rows, determine a lender’s payoff quote, or model payment holidays, variable rates, skipped payments or irregular payment timing.
It also excludes fees, taxes, insurance, escrow, optional products and any charges added to the balance. If an upfront fee is financed, the actual starting principal may differ from the amount received. The APR and payment terms should come from the lender’s disclosure or loan documents; the 8% default is only an example input, not a current-rate claim or an offer.
Common Errors and Related Questions
A common misconception is that every payment reduces principal by the same amount. In a standard fixed-payment schedule, interest is recalculated from the remaining balance, so the principal share generally grows as the balance falls. Another frequent mistake is entering 8 instead of 0.08 in a formula that expects a decimal rate; this calculator accepts APR as a percentage and performs the conversion internally.
- Confirm the term unit: five years means 60 monthly periods, not five.
- Do not treat total payments as total interest. Total payments include repayment of the original principal; interest is the amount above principal.
- Expect minor discrepancies if payment dates, rounding rules or interest accrual methods differ.
Assumptions
- The rate is fixed for the full term and is entered as annual APR.
- Payments are equal, monthly and made at the end of each period.
- Interest compounds monthly at APR ÷ 12.
- Fees, taxes, insurance, PMI and escrow are not included.
Frequently Asked Questions
What does a payment schedule table show?
A payment schedule shows the amount due for each period and how much goes to interest, principal and the remaining balance. It helps explain how a loan is expected to amortize over time.
How do I calculate the interest in each monthly row?
For this monthly-rate model, multiply the opening balance by APR ÷ 1,200. The result is that period’s interest before rounding; subtract it from the payment to find principal paid.
Why does the principal portion increase over time?
With a fixed payment and rate, the balance usually declines after each payment. Because interest is calculated on that lower balance, less of a later payment is interest and more is principal.
Does this calculator create a full payment schedule?
No. It calculates the level monthly payment and total interest. The row-by-row method above explains how to construct a schedule, but actual lender schedules may use different timing, rounding or contract terms.
Why does my lender’s table show a different final balance?
Differences can arise from payment dates, daily rather than monthly interest accrual, rounding at each step, fees, a different APR convention or payments that were not made exactly as scheduled. Compare the calculation assumptions with the loan documents.
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
- 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