calculate-loan

01 Loan payments

Principal Amortization Schedule Calculator: How It Works

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

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

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.

A principal amortization schedule calculator shows you exactly how each loan payment splits between paying down the principal balance and paying interest, month by month, for the entire loan term. You enter the loan amount, interest rate, and term, and it returns a full schedule plus the monthly payment and total interest. This is the same arithmetic lenders use to build your official amortization table, so you can see precisely how much of each payment goes to principal at any point in the loan.

Formula

The calculator uses the standard fixed-rate amortization formula to find the level monthly payment:

M = P × [ r(1 + r)^n ] / [ (1 + r)^n − 1 ]

Where:

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

To build the schedule, for each payment number k (from 1 to n):

  • Interest portion = previous balance × r
  • Principal portion = M − interest portion
  • New balance = previous balance − principal portion

Each payment is rounded to the cent, and the final payment is adjusted slightly so the balance reaches exactly zero.

Worked Example

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

First, compute the monthly rate: r = 8 / 1200 = 0.0066667.

Total payments: n = 5 × 12 = 60.

Monthly payment:

M = 20000 × [ 0.0066667 × (1.0066667)^60 ] / [ (1.0066667)^60 − 1 ]

Calculate (1.0066667)^60 ≈ 1.489846.

Numerator: 0.0066667 × 1.489846 = 0.0099323.

Denominator: 1.489846 − 1 = 0.489846.

M = 20000 × (0.0099323 / 0.489846) = 20000 × 0.020276 = 405.52.

So the monthly payment is $405.52 (rounded to the cent).

Total paid over 60 months: $405.52 × 60 = $24,331.20.

Total interest = $24,331.20 − $20,000 = $4,331.20.

The calculator shows exactly these values: payment $405.52, total interest $4,331.20.

To see the first month’s split: interest = $20,000 × 0.0066667 = $133.33, principal = $405.52 − $133.33 = $272.19, new balance = $20,000 − $272.19 = $19,727.81. The next month uses that new balance, and so on.

Assumptions

  • Fixed interest rate for the entire term (no rate changes).
  • Payments are made monthly at the end of each period.
  • Interest compounds monthly at the APR divided by 12.
  • No fees, taxes, insurance, PMI, or escrow are included.
  • All payments are made on time and in full; missed or extra payments change the schedule.

How to Read the Schedule

In the early months, most of each payment goes to interest. As the balance decreases, the interest portion shrinks and the principal portion grows. This is called front-loaded interest. For a 30-year mortgage, it can take more than half the term before the principal portion exceeds the interest portion. The schedule shows this shift clearly, which helps you understand why paying extra early saves more interest than paying extra later.

Common Mistakes and Misconceptions

  • Using the APR as the monthly rate. Always divide by 12. An 8% APR means a monthly rate of 0.6667%, not 8%.
  • Rounding too early. If you round the payment before computing the schedule, the final balance won’t hit zero. Use the exact payment in calculations, then round only the displayed numbers.
  • Ignoring the final payment adjustment. Due to rounding, the last payment is often a few cents different from the regular payment.
  • Thinking interest is simple. Amortization uses compound interest on the declining balance; the total interest is not simply rate × principal × term.

How to Use It in Real Life

People use this calculator to see how much principal they’ll have paid after a certain number of years, which is useful when considering selling a home or refinancing. It also helps compare different loan terms: a shorter term has a higher payment but much lower total interest. For example, a $20,000 loan at 8% for 3 years has a payment of about $626.73 and total interest of about $2,562.28, while the 5-year term costs $405.52 per month but $4,331.20 in interest. The schedule shows exactly when you’d reach 20% equity or when you’d have paid off half the principal.

Limitations of the Calculator

This calculator assumes a fixed rate and regular payments. Real loans may have adjustable rates, interest-only periods, balloon payments, or prepayment penalties. It does not include property taxes, insurance, or mortgage insurance, which can be significant. It also doesn’t account for the tax deductibility of mortgage interest, which varies by jurisdiction and personal situation. The result is an estimate for education; your lender’s amortization schedule, which includes all fees and exact dates, is the authoritative document.

Frequently Asked Questions

How do I calculate principal and interest for each payment?

Start with the current balance. Multiply it by the monthly interest rate (APR ÷ 12) to get the interest portion. Subtract that from your fixed monthly payment to get the principal portion. Then subtract the principal portion from the balance to get the new balance. Repeat for each month.

Why is interest higher in the early years of a mortgage?

Because the balance is largest at the start. Interest is calculated as a percentage of the remaining balance, so a larger balance generates more interest. As you pay down principal, the interest amount decreases, allowing more of your payment to go to principal.

What happens if I make an extra principal payment?

An extra payment reduces the balance immediately, which reduces the interest charged in all future months. The loan may be paid off early, or you may recast the loan to lower the monthly payment, depending on your lender’s rules. The calculator’s schedule can help you see the effect by inputting a lower balance or a shorter term.

Does the calculator work for auto loans or student loans?

Yes, the same amortization formula applies to any fixed-rate, fully amortizing loan, including auto loans, student loans, and personal loans. Just enter the loan amount, APR, and term in years. If your loan has a different compounding period or fees, the schedule will differ slightly.

What is the difference between amortization and simple interest?

Simple interest is calculated only on the original principal, so the interest amount is the same each month. Amortization calculates interest on the remaining balance, which decreases over time. Most installment loans use amortization, while some short-term loans or credit cards use simple or daily interest.

Can I use this calculator to plan for a mortgage refinance?

Yes, you can compare your current loan’s remaining term and balance with a new loan’s terms. Enter the remaining balance as the loan amount and the new rate and term to see the new payment and total interest. This helps you evaluate the financial impact, but remember to include closing costs and fees, which are not in this calculator.

The result is an estimate for education; your 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

The whole Loan payments section →