calculate-loan

01 Loan payments

Home Amortization Schedule Calculator: How It Works

Calculator No. 01-20853 · 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 your monthly mortgage payment and generates a full amortization schedule, showing how much of each payment goes to interest versus principal over the life of the loan. Enter your loan amount, interest rate (APR), and loan term in years, and you’ll get the monthly payment, total interest paid, and a year-by-year breakdown of balances.

Formula

The monthly payment for a fixed-rate loan is calculated using the standard amortization formula:

M = P × (r × (1 + r)^n) / ((1 + r)^n – 1)

Where:

  • M = monthly payment (in dollars)
  • P = principal loan amount (in dollars)
  • r = monthly interest rate = APR / 1200 (as a decimal, e.g., 8% APR → r = 0.08/12 = 0.0066667)
  • n = total number of monthly payments = loan term in years × 12

This formula assumes a fixed interest rate for the entire term and that payments are made at the end of each month (ordinary annuity). The total interest is simply the monthly payment times the number of payments minus the principal: Total Interest = M × n – P.

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. Calculate number of payments: n = 5 × 12 = 60
  3. Compute (1 + r)^n = (1.0066667)^60 ≈ 1.4898457
  4. Plug into formula: M = 20000 × (0.0066667 × 1.4898457) / (1.4898457 – 1)
  5. Numerator: 20000 × 0.0099323 = 198.646
  6. Denominator: 0.4898457
  7. M = 198.646 / 0.4898457 ≈ 405.53

So the monthly payment is $405.53 (rounded to cents). Total paid over 60 months = 405.53 × 60 = $24,331.80. Total interest = $24,331.80 – $20,000 = $4,331.80, which matches the calculator’s output.

Assumptions

  • Fixed interest rate for the entire loan term (no rate adjustments).
  • Payments are made at the end of each month.
  • Interest compounds monthly at APR / 12.
  • No fees, taxes, insurance, PMI, or escrow are included.
  • The payment is rounded to the nearest cent; the calculator uses the rounded payment for totals.

How to Read an Amortization Schedule

An amortization schedule is a table that breaks down every payment into two parts: interest and principal. In the early months, a large share of your payment goes toward interest, with only a small amount reducing the principal. As the balance decreases, the interest portion shrinks and the principal portion grows. By the end of the term, the final payment clears the remaining balance.

For example, with a $200,000 loan at 6% APR for 30 years, the first payment might be $1,199.10, with $1,000 going to interest and $199.10 to principal. After 15 years, the interest portion drops to about $600, and the principal portion rises to about $600. This front-loading of interest is why paying extra early can save significant interest over time.

Common Mistakes and Misconceptions

  • Using the nominal APR instead of the monthly rate: Always divide APR by 12 to get the monthly rate. Forgetting this can overstate the payment.
  • Ignoring rounding: Lenders round payments to the nearest cent; the last payment may differ slightly. Most calculators, including this one, round the monthly payment and then compute totals from that rounded value.
  • Assuming the schedule is linear: Many people think principal is paid down evenly each month. In reality, interest is charged on the remaining balance, so the schedule is curved.
  • Confusing APR with the note rate: APR includes certain fees and costs, so it can be slightly higher than the interest rate quoted. This calculator uses the APR as the effective annual rate, which is a good approximation for most loans.
  • Not accounting for extra payments: If you make extra principal payments, the schedule changes. The calculator here does not model extra payments; you would need a more advanced tool for that.

When to Use This Calculator

Use this calculator when you want a quick estimate of the monthly payment for a fixed-rate mortgage. It’s useful for comparing different loan amounts, interest rates, or terms. For example, you can see how a 15-year term compares to a 30-year term in terms of monthly payment and total interest. You can also use it to estimate the payment for a refinance or a home equity loan.

However, this calculator does not include property taxes, homeowners insurance, PMI (if your down payment is less than 20%), or HOA fees. Those are typically added to your monthly payment through an escrow account. To get your true monthly housing cost, add those amounts to the calculator’s result.

How to Choose a Loan Term

Loan term is one of the most important choices you’ll make. A shorter term (e.g., 15 years) usually has a higher monthly payment but much lower total interest. A longer term (e.g., 30 years) has a lower monthly payment but more interest over time. For instance, a $250,000 loan at 6% APR:

  • 15-year term: monthly payment ≈ $2,109.64, total interest ≈ $129,735
  • 30-year term: monthly payment ≈ $1,498.88, total interest ≈ $289,596

The 30-year payment is about $611 less per month, but you pay an extra $159,861 in interest. Use this calculator to run your own numbers and see the trade-off. There is no universally “best” term; it depends on your budget and financial goals.

Limitations of the Formula

The amortization formula assumes a fixed rate and level payments. It does not apply to adjustable-rate mortgages (ARMs), interest-only loans, or balloon loans. For those, the payment can change over time or have a large final payment. Additionally, the formula does not account for prepayment penalties or other fees that might affect the true cost. Always check your loan documents for the exact terms.

Frequently Asked Questions

How do I calculate the amortization schedule for a home loan?

To create a schedule, start with your loan balance. For each month, multiply the balance by the monthly interest rate (APR/12) to get the interest for that month. Subtract that interest from your fixed monthly payment to get the principal portion. Subtract the principal from the balance to get the new balance. Repeat for each month until the balance reaches zero.

What is the difference between APR and interest rate?

The interest rate is the cost of borrowing the principal, expressed as a yearly percentage. APR (Annual Percentage Rate) includes the interest rate plus certain lender fees and closing costs, spread over the loan term. APR is generally higher than the interest rate and gives a more complete picture of the loan’s cost.

Can I use this calculator for an adjustable-rate mortgage?

No. This calculator assumes a fixed rate for the entire term. For an ARM, the rate changes after an initial period, and the payment can go up or down. You would need a more complex calculator that models rate adjustments.

How does making extra payments affect my amortization schedule?

Extra principal payments reduce your balance faster, which means less interest accrues in future months. This can shorten your loan term and reduce total interest. To see the effect, you would need a calculator that allows extra payments, as this one does not.

Why is my first payment mostly interest?

Because interest is calculated on the full loan balance at the start. Since the balance is highest at the beginning, the interest portion is largest. As you pay down principal, the interest portion decreases over time.

What is PMI and why isn’t it included?

PMI (Private Mortgage Insurance) is required by lenders when your down payment is less than 20%. It protects the lender if you default. This calculator does not include PMI because it varies by lender and loan type. You would need to add it separately to your monthly cost estimate.

This calculator provides an estimate for educational purposes; your lender’s official disclosure will show the exact payment and amortization schedule.

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 →