Skip to content
Calcapedia
Money

Amortization Schedule Calculator

See where every payment on a fixed-rate loan goes, payment by payment or by year, with dates, interest paid so far and your payoff date.

Level: Grades 11–12

  • Common Core standard HSA.SSE.B.4Derive the formula for the sum of a finite geometric series (when the common ratio is not 1), and use the formula to solve problems.
Printable worksheet

Amortization Schedule Calculator

Know the answer you need? Pick an input to work backward.

Inputs

Optional. The first payment is due one month later. Used to date each row.

Schedule view

Result

Monthly payment

$1,498.88

Each of the 360 payments is $1,498.88. Over the life of the loan you pay $289,595.47 in interest, the balance falls below half the original amount at payment 252, and the last payment is in 30 years from the start.

Total interest
$289,595.47
Total of all payments
$539,595.47
Number of payments
360
Interest in the first payment
$1,250.00
Payment when half the loan is repaid
252
First payment that is mostly principal
223
Payoff date (last payment)
30 years from the start
Loan balance and interest paid over time
$0$100K$200K$300K0612182430

Year

  • Balance
  • Interest paid to date

See the step-by-step solution ↓

Amortization schedule by year
Amortization schedule by year
YearYear endsPrincipal paidInterest paidInterest to dateBalance at year end
1$3,070.03$14,916.49$14,916.49$246,929.97
2$3,259.38$14,727.13$29,643.62$243,670.59
3$3,460.41$14,526.10$44,169.72$240,210.18
4$3,673.84$14,312.67$58,482.39$236,536.33
5$3,900.44$14,086.08$72,568.47$232,635.89
6$4,141.01$13,845.51$86,413.98$228,494.88
7$4,396.42$13,590.10$100,004.08$224,098.46
8$4,667.58$13,318.94$113,323.01$219,430.89
9$4,955.47$13,031.05$126,354.06$214,475.42
10$5,261.11$12,725.41$139,079.47$209,214.31
11$5,585.60$12,400.91$151,480.38$203,628.71
12$5,930.11$12,056.41$163,536.79$197,698.60
13$6,295.87$11,690.65$175,227.44$191,402.74
14$6,684.18$11,302.34$186,529.78$184,718.56
15$7,096.45$10,890.07$197,419.85$177,622.11
16$7,534.14$10,452.38$207,872.22$170,087.97
17$7,998.83$9,987.69$217,859.91$162,089.14
18$8,492.18$9,494.34$227,354.25$153,596.97
19$9,015.96$8,970.56$236,324.81$144,581.01
20$9,572.04$8,414.47$244,739.28$135,008.97
21$10,162.42$7,824.09$252,563.37$124,846.54
22$10,789.22$7,197.29$259,760.67$114,057.32
23$11,454.68$6,531.84$266,292.51$102,602.64
24$12,161.18$5,825.34$272,117.85$90,441.47
25$12,911.25$5,075.27$277,193.11$77,530.22
26$13,707.59$4,278.93$281,472.04$63,822.63
27$14,553.04$3,433.47$284,905.51$49,269.59
28$15,450.64$2,535.87$287,441.39$33,818.95
29$16,403.60$1,582.91$289,024.30$17,415.34
30$17,415.34$571.17$289,595.47$0.00

Step-by-step solution

  1. Count the monthly payments (n): years × 12, since you pay once a month

    n=30×12=360
  2. Turn the yearly rate into a monthly rate (i) by dividing by 12, because interest is charged every month

    i=6%12=0.005
  3. Find the monthly payment. A standard formula gives the one amount that pays off the loan, with interest, in n months

    $250,000.00×0.0051−(1+0.005)−360=$1,498.88
  4. Split the first payment: interest is what you owe times the monthly rate, and the rest pays down the loan

    $1,498.88−$250,000.00×0.005=$248.88
  5. Each later row does the same on the smaller balance. Total interest is everything you pay minus what you borrowed

    $539,595.47−$250,000.00=$289,595.47

Test yourself

20 quick questions built from this calculator's formula: work out results, predict what happens when an input changes, and work backward from an answer. Every answer comes with the working.

Please note: Results are estimates for planning and comparison. Lenders, banks, and tax authorities may round differently or include fees not modeled here, so confirm figures with your provider before deciding.

What this calculator does

See exactly where every loan payment goes, from the first one to the last. For a fixed-rate loan, this calculator builds the full payment plan, called an amortization schedule. It shows your monthly payment and how much of each one goes to interest versus paying down the loan. It also shows what you still owe after every payment, the interest you've paid so far and the month of your final payment.

Every payment on this kind of loan is the same size, but what it pays for changes over time. Early on, most of it covers interest. Toward the end, most of it pays down what you owe. You can view the schedule year by year. Or switch to every payment to see the exact split, the month and what you owe after each one.

Where it's used

Why this math matters outside the classroom:

  • Splitting a payment. On a $200,000 loan at 6% for 30 years, the first $1,199.10 payment is $1,000 of interest and $199.10 of principal.
  • Tracking the balance. Borrowers read an amortization table to see what they would still owe after 5 or 10 years of regular payments.
  • Year-end statements. Homeowners add up the interest column for a calendar year to match the interest shown on a lender's annual statement.
  • Algebra 2 projects. Students build a month-by-month table in a spreadsheet and check that the last row brings the balance to zero.
  • Comparing loan terms. Lenders show how a 15-year schedule pays principal down far faster in the early years than a 30-year schedule.

Grade level and standards: Grades 11–12; Common Core State Standards for Mathematics HSA.SSE.B.4. © Copyright 2010. National Governors Association Center for Best Practices and Council of Chief State School Officers. All rights reserved.

How to use it

  1. Enter how much you borrowed and the yearly interest rate.
  2. Enter the length of the loan in years or months, and set the date it starts.
  3. Choose a yearly summary or every payment. Then read your payment, total interest, payoff date and the schedule table.

What the inputs mean

Loan amount
How much you owe when the schedule starts, also called the principal. For a mortgage, that's the price minus your down payment.
Annual interest rate
Your loan's yearly interest rate. Each month's interest is what you still owe times this rate ÷ 12.
Loan term
Up to 50 years or 600 months. If you enter years, the calculator turns them into whole months.
Loan start date
The date your loan begins. The first payment is a month later. So row 1 of a loan starting in October 2026 is November 2026.
Schedule view
Every payment shows one row per month. For a long mortgage, that can be several hundred rows.

Formula and method

i = rate ÷ 100 ÷ 12;  n = number of monthly payments
payment = P × i ÷ (1 − (1 + i)^(−n));  at 0%: payment = P ÷ n
interest for a month = balance × i
principal for a month = payment − interest
new balance = balance − principal
principal first exceeds interest at the first payment k with (1 + i)^(n − k + 1) < 2

In the formulas, P is the amount you borrow, i is the monthly interest rate and n is the number of monthly payments. The balance is what you still owe, and k is a payment's number in the schedule.

The payment formula finds the one monthly amount that pays off the loan, with interest, in exactly n months. The schedule then works through it one month at a time. Each month, interest is charged on what you still owe. The rest of the payment pays down the loan.

Because you owe a little less each month, each month's interest is a little smaller than the last. So more of each payment goes to the loan itself. The last payment is set to clear what's left exactly. The last formula finds the crossover: the first payment where more goes to the loan than to interest.

Worked example

A $250,000 loan at 6% for 30 years.

  1. Monthly rate: 6% ÷ 12 = 0.005; payments: 30 × 12 = 360.
  2. Payment: $250,000 × 0.005 ÷ (1 − 1.005^(−360)) ≈ $1,498.88.
  3. First month: interest = $250,000 × 0.005 = $1,250.00, so principal = $1,498.88 − $1,250.00 = $248.88.
  4. After year 1 you have paid $14,916.49 of interest and $3,070.03 of principal, leaving $246,929.97.

Result: Total interest over 30 years is about $289,595.47. Payment 223 is the first where more goes to the loan than to interest. You don't owe less than half the original amount until payment 252. A loan starting on October 18, 2026 makes its last payment in October 2056.

Understanding the result

If your balance falls slowly at first, don't worry: that's normal for long loans. It's why extra payments made early save the most interest. It's also why, if you sell or refinance in the first few years, you'll still owe most of what you borrowed.

The interest-to-date column shows what borrowing has cost you so far. That's handy when you're weighing a refinance or paying extra.

Assumptions and limitations

  • The rate stays the same for the whole loan, and interest is charged each month at the yearly rate ÷ 12.
  • You pay once a month, at the end of each month, starting one month after the loan begins.
  • Payments aren't rounded to the cent. The last payment clears whatever is left.
  • Escrow costs, such as property tax and insurance your lender collects, aren't part of this schedule.
  • It doesn't handle changing rates, skipped payments, interest-only periods or balloon payments (a big lump sum due at the end).
  • Lenders that charge interest daily or round each payment will show small differences.
  • Rows show the month only. Your actual due day depends on your loan agreement.

Frequently asked questions

Why does so little of my early payment go to the loan itself?

Interest is charged on what you still owe, and that's largest at the start. On a $250,000 loan at 6% for 30 years, the first payment is $1,498.88. Of that, $1,250.00 is interest.

When will I have repaid half the loan?

On most loans, later than halfway through. The result called 'Payment when half the loan is repaid' shows the exact payment number for your numbers.

Is this the same as my mortgage statement?

For a fixed-rate loan, it should be very close. Your statement may differ by a few cents because of rounding. It often includes escrow amounts too, which this schedule leaves out.

When does more of my payment go to the loan than to interest?

At the crossover point, shown as 'First payment that is mostly principal'. On a 30-year loan at 6%, it's payment 223, a little past year 18. Higher rates push it later and shorter loans bring it sooner. On a 15-year loan at 6%, it's payment 43.

What does it mean for a loan to be fully amortizing?

It means your regular payments alone bring what you owe to exactly zero by the end, with no lump sum left over. Interest-only and balloon loans aren't fully amortizing. With those, some or all of the loan is still owed when the regular payments stop.

How do extra payments change the schedule?

Paying extra toward the loan lowers what you owe sooner. That cuts the interest in every later month and ends the loan early. Use the extra payment calculator to compare the two schedules.

How this calculator is checked

Method: Standard level-payment (annuity) formula with monthly rate = yearly rate ÷ 12, applied month by month. The calculation is covered by automated tests with known reference values and edge cases. Last updated 2026-10-18. Found a problem? Tell us.

Embed this calculator

Put this Amortization Schedule Calculator on your own website or blog for free. Paste this code where you want it to appear: