Mortgage & home buying · Calculation notebook

Mortgage amortization schedule calculator: formulas, examples and mathematical principles

Learn the inputs, formula and worked example behind the Mortgage amortization schedule calculator, including annuities and the remaining-balance recurrence, result interpretation, assumptions and sources.

Open calculator By Toolify · Updated

Purpose and steps

The Mortgage Amortization Schedule Calculator validates every input, normalizes monthly and annual amounts, and calculates monthly principal, interest, balance, extra payments, and payoff time from one consistent scenario.

  1. Confirm currency and monthly versus annual amounts. U.S. tax and loan models should be used within their stated scope.
  2. Prepare Loan amount, Annual interest rate, Loan term, Extra monthly principal. Defaults demonstrate the model rather than your personal circumstances.
  3. Check the headline result and its components. A key interpretation for this tool is: Interest is largest early because the outstanding balance is largest, not because the rate changes.
  4. Compare the baseline with a changed scenario: Compare total interest and payoff months, not just the larger monthly cash commitment.

Input reference and units

These values reproduce the model’s demonstration. Replace them with your own records or measurements; they are not recommended targets.

On a small screen, swipe the table horizontally to see all columns.

Parameters used by this calculator
ParameterDemonstration valueHow to enter it
Loan amount320000 USDUse actual financed principal, including financed fees only when the tool explicitly models them.
Annual interest rate6.5 %Enter a percentage such as 6.5, not 0.065. The equation converts it to a decimal.
Loan term30 yearsUse years here. The model converts to months when the payment schedule requires it.
Extra monthly principal0 USDUse dollars and the monthly or annual period stated in the field label; do not enter thousands of dollars.

Model-specific method

How this calculator produces its result

Monthly rate r = annual percentage rate / 1200; n = years × 12. Scheduled M = P × r / (1 − (1+r)^−n), or P/n at zero interest. Month t interest = previous balance × r; principal paid = payment − interest; next balance = previous balance − principal paid. Extra principal accelerates this recurrence.

Annuities and the remaining-balance recurrence

A fixed-payment loan is an annuity: the discounted value of all future payments equals the amount borrowed today. Summing that geometric series gives the monthly-payment equation. Match the rate and time unit: monthly payments use an annual nominal rate divided by twelve and a term counted in months.

Each payment is split into interest and principal. Interest uses the opening balance, so paying extra principal now reduces later interest. A zero rate must use P/n rather than the formula’s zero-over-zero form. Keep full precision during the schedule and round only for display; a lender may round each actual posting differently.

P = Σ[t=1…n] M/(1+r)^t
M = Pr / (1 − (1+r)^−n)
Iₜ = Bₜ₋₁r; Bₜ = Bₜ₋₁ + Iₜ − paymentₜ
  • P: principal today
  • r: rate per payment period, not the annual percentage
  • n: number of payment periods
  • M: scheduled payment; B: remaining balance

Worked example

For $320,000 at 6.5% over 30 years, the scheduled payment is about $2,022.62. First-month interest is $1,733.33, leaving $289.29 principal. Adding $250 makes first-month principal about $539.29; the final payment is capped at the remaining balance plus interest.

Reproduce the default scenario

This is a separate example, calculated using the exact engine on the tool page and the defaults in the input reference above. Health examples use metric units. Displayed rounding may differ from intermediate precision.

Monthly payment including extra principal
2,022.62 USD
Scheduled principal-and-interest payment
2,022.62 USD
Estimated payoff time
360 months
Months saved
0 months
Total interest with extra payment
408,142.36 USD
Estimated interest saved
0 USD
Total amount repaid
728,142.36 USD

Reading results without overstating them

  • Interest is largest early because the outstanding balance is largest, not because the rate changes.
  • Compare total interest and payoff months, not just the larger monthly cash commitment.

Assumptions and exclusions

  • Assumes fixed interest, monthly interest calculation and immediate application of extra principal. Taxes, escrow, daily-accrual rules and recasting are excluded.
Test a changed assumption in the calculator

Sources and content notes

Toolify describes the implemented algorithm and its assumptions. Sources below support the topic or applicable rules; they do not endorse this calculator. Examples are illustrative, and published rules take precedence over simplified estimates.

Report a formula, example or translation issue through our contact page. Include the tool name, inputs and expected result so it can be reproduced. Contact Toolify