calculate-loan

01 Loan payments

Home Purchase Amortization Schedule Explained

Calculator No. 01-20854 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

This calculator works out the full amortization schedule for a home purchase loan: you enter the loan amount, interest rate (APR), and loan term in years, and it returns your monthly payment, total interest, and a year-by-year breakdown of principal and interest paid. The schedule shows exactly how much of each payment goes to interest versus paying down the balance, which is the core of how a mortgage works.

Formula

The standard amortization formula for a fixed-rate loan is:

Monthly payment = P × (r × (1 + r)^n) / ((1 + r)^n − 1)

Where:

  • P = loan amount (principal) in dollars
  • r = monthly interest rate = annual APR ÷ 12 ÷ 100 (e.g., 8% APR → r = 0.08/12 = 0.0066667)
  • n = total number of monthly payments = years × 12

Each month, the interest portion is calculated as current balance × r, and the rest of the fixed payment reduces the principal. The balance after any number of payments k is:

Balance after k payments = P × (1 + r)^k − pmt × ((1 + r)^k − 1) / r

Worked Example

Using the default values from the calculator: loan amount $20,000, APR 8%, term 5 years.

  1. Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
  2. Total payments: n = 5 × 12 = 60
  3. Plug into the formula:
    pmt = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 − 1)
  4. (1.0066667)^60 ≈ 1.48985
  5. Numerator: 20000 × (0.0066667 × 1.48985) ≈ 20000 × 0.0099323 = 198.646
  6. Denominator: 1.48985 − 1 = 0.48985
  7. pmt = 198.646 / 0.48985 ≈ 405.53
  8. Total paid: 405.53 × 60 = $24,331.80
  9. Total interest: 24,331.80 − 20,000 = $4,331.80

The calculator rounds the monthly payment to $405.53, and the total interest shown is $4,331.80, matching the example exactly.

Assumptions

  • Fixed interest rate for the entire term (no adjustable-rate changes)
  • Payments are made at the end of each month (ordinary annuity)
  • Interest compounds monthly at APR/12
  • No fees, taxes, insurance, PMI, or escrow are included
  • Loan is fully amortized – the balance reaches zero after the last payment

How to Read an Amortization Schedule

An amortization schedule is a table listing each payment, typically with columns for payment number, payment amount, interest paid, principal paid, and remaining balance. Early in the schedule, a large share of each payment goes to interest; as the balance shrinks, the interest portion decreases and more of the payment goes to principal. For the $20,000 loan above, the first payment has about $133.33 in interest and $272.20 in principal. By the last payment, interest is only about $2.68 and principal is $402.85.

Two useful numbers to track: cumulative interest (the total cost of borrowing) and payoff date (when the balance hits zero). You can also see how an extra payment affects the schedule – any extra amount goes directly to principal, shortening the term and reducing total interest.

How to Choose a Loan Term

The term (e.g., 15 vs. 30 years) dramatically changes the payment and total interest. A shorter term has a higher monthly payment but far less interest over the life of the loan. For example, a $200,000 loan at 6% APR:

  • 15-year term: monthly payment ≈ $1,688, total interest ≈ $103,784
  • 30-year term: monthly payment ≈ $1,199, total interest ≈ $231,676

Choosing a term involves weighing the monthly cash flow against the long-term cost. A longer term gives lower payments but costs much more in interest. Some buyers choose a 30-year term for flexibility and make extra principal payments when they can, effectively shortening the term without committing to a higher required payment.

Common Mistakes and Misconceptions

  • Confusing APR with the periodic rate: APR is annual, but payments are monthly. Always divide by 12 before using in the formula.
  • Rounding too early: If you round the monthly payment to cents before computing totals, the final balance may be slightly off. Use the full precision during calculations and round only at the end.
  • Ignoring the effect of extra payments: Even a small extra payment each month can save thousands in interest and cut years off the term, but only if the lender applies it to principal.
  • Assuming the interest rate never changes: For adjustable-rate mortgages (ARMs), the schedule is only accurate until the first rate adjustment.
  • Forgetting that taxes and insurance are not part of the amortization: Your actual monthly housing cost may be higher than the principal and interest payment.

Extra Payments and Refinancing

Making extra principal payments shortens the amortization schedule and reduces total interest. For example, adding $50 per month to the $20,000, 8%, 5-year loan would pay it off about 5 months early and save roughly $200 in interest. The exact savings depend on the loan amount, rate, and timing of the extra payment.

Refinancing replaces the old loan with a new one, starting a new amortization schedule. To compare, you would calculate the new payment and total interest with the new rate and term, then weigh the closing costs against the interest savings. The calculator on this page can help with that math – just enter the new loan amount (the remaining balance) and the new rate and term.

Frequently Asked Questions

What is an amortization schedule?

It is a table that shows each monthly payment over the life of the loan, broken into the interest portion and the principal portion, along with the remaining balance after each payment. It demonstrates how the loan is paid off over time.

How does the amortization formula work?

The formula calculates a level monthly payment that exactly repays the principal plus interest over the term. Each month, interest is computed on the current balance, and the rest of the payment reduces the principal, so the balance declines gradually until it reaches zero.

Why do I pay more interest at the beginning?

Because interest is calculated on the outstanding balance, which is largest at the start. As you pay down principal, the interest charge decreases, allowing more of your fixed payment to go toward principal.

Can I make extra payments to shorten the schedule?

Yes, most lenders allow extra principal payments, which reduce the balance faster and therefore reduce total interest and shorten the term. Check with your lender that the extra payment is applied to principal, not treated as an early payment of the next month’s installment.

What is the difference between APR and the interest rate?

The interest rate is the cost of borrowing the principal, while the APR includes other costs like lender fees and points, expressed as a yearly rate. For amortization calculations, you typically use the interest rate; the APR gives a broader comparison of loan offers.

Does the schedule change if I miss a payment?

Yes, missing a payment can trigger late fees and may cause the lender to add the missed interest to the balance, which resets the schedule. The exact effect depends on the lender’s policies and whether the loan is in forbearance or deferment.

The result from this calculator is an estimate; your lender’s official amortization disclosure will provide the exact figures for your specific loan.

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

The whole Loan payments section →