Amortization Calculator

Each payment on an amortized loan covers that month's interest first and puts the rest toward principal: on a $200,000, 30-year loan at 6%, the payment is $1,199.10, and the first one is $1,000.00 interest and $199.10 principal. The schedule shows every payment and what extra payments save.

By the Calculators With Steps team · Updated November 10, 2026 · How we check our math

Optional. Added to every monthly payment, starting with the first.

Monthly payment
$1,199.10
360 payments, paid off Oct 2056
Total interest
$231,676
Total of payments
$431,676
Number of payments
36030 years
Payoff date
Oct 2056
First payment: interest
$1,000.0083.4% of the regular payment
Principal vs. interest paid each calendar year
  • Principal
  • Interest
$0
$5,000
$10K
$15K
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
2044
2045
2046
2047
2048
2049
2050
2051
2052
2053
2054
2055
2056
Step-by-step working
  1. Monthly rate r = 6% ÷ 12 = 0.005; number of payments n = 360
  2. Payment M = P × r(1 + r)^n ÷ ((1 + r)^n − 1) = $1,199.10
  3. Month 1 interest = balance × r = $200,000 × 0.005 = $1,000.00
  4. Month 1 principal = $1,199.10 − $1,000.00 = $199.10
  5. New balance = $200,000 − $199.10 = $199,801; repeat each month until the balance reaches zero
Show yearly amortization summary
YearPrincipal paidInterest paidBalance at year end
2026$399.20$1,999.00$199,601
2027$2,480.65$11,908.57$197,120
2028$2,633.65$11,755.57$194,487
2029$2,796.08$11,593.13$191,690
2030$2,968.54$11,420.67$188,722
2031$3,151.63$11,237.58$185,570
2032$3,346.02$11,043.19$182,224
2033$3,552.39$10,836.82$178,672
2034$3,771.50$10,617.72$174,900
2035$4,004.12$10,385.10$170,896
2036$4,251.08$10,138.13$166,645
2037$4,513.28$9,875.94$162,132
2038$4,791.65$9,597.57$157,340
2039$5,087.18$9,302.03$152,253
2040$5,400.95$8,988.26$146,852
2041$5,734.07$8,655.14$141,118
2042$6,087.74$8,301.48$135,030
2043$6,463.21$7,926.00$128,567
2044$6,861.85$7,527.36$121,705
2045$7,285.07$7,104.14$114,420
2046$7,734.40$6,654.81$106,686
2047$8,211.44$6,177.77$98,474.30
2048$8,717.91$5,671.31$89,756.40
2049$9,255.61$5,133.61$80,500.79
2050$9,826.47$4,562.74$70,674.32
2051$10,432.55$3,956.66$60,241.77
2052$11,076.01$3,313.21$49,165.76
2053$11,759.15$2,630.06$37,406.61
2054$12,484.43$1,904.78$24,922.19
2055$13,254.44$1,134.77$11,667.75
2056$11,667.75$323.26$0.00
Show monthly amortization schedule
#DatePaymentPrincipalInterestBalance
1Nov 2026$1,199.10$199.10$1,000.00$199,801
2Dec 2026$1,199.10$200.10$999.00$199,601
3Jan 2027$1,199.10$201.10$998.00$199,400
4Feb 2027$1,199.10$202.10$997.00$199,198
5Mar 2027$1,199.10$203.11$995.99$198,994
6Apr 2027$1,199.10$204.13$994.97$198,790
7May 2027$1,199.10$205.15$993.95$198,585
8Jun 2027$1,199.10$206.17$992.93$198,379
9Jul 2027$1,199.10$207.21$991.90$198,172
10Aug 2027$1,199.10$208.24$990.86$197,964
11Sep 2027$1,199.10$209.28$989.82$197,754
12Oct 2027$1,199.10$210.33$988.77$197,544
Showing the first 12 of 360 rows. The full table loads with the calculator.

Fixed-rate loan with equal monthly payments. Escrow for taxes and insurance is not included. The final payment is adjusted so the balance ends at exactly zero.

How to use the amortization calculator

  1. Enter the loan amount, the interest rate (APR) and the term in years.
  2. Pick the first payment date so the schedule shows real months and calendar years.
  3. Optionally add an extra payment toward principal every month.

You get the monthly payment, total interest, payoff date, a chart of principal and interest by calendar year, a yearly summary and the full monthly schedule. The calendar-year view is handy at tax time, because it shows the interest paid in each year.

The amortization formula

The fixed monthly payment comes from the standard formula:

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

  • M = monthly payment
  • P = loan amount
  • r = monthly interest rate (APR ÷ 12 ÷ 100)
  • n = number of monthly payments (years × 12)

Each row of the schedule then follows three steps:

  1. Interest = current balance × r
  2. Principal = M − interest (plus any extra payment)
  3. New balance = current balance − principal

Because interest is always charged on the remaining balance, the interest portion shrinks every month and the principal portion grows by the same amount.

Worked example: $200,000 at 6% for 30 years

The payment is $1,199.10 a month for 360 months, and total interest comes to about $231,676.

Payment Interest Principal Balance after
1 $1,000.00 $199.10 $199,800.90
60 (end of year 5) – – $186,108.71
120 (end of year 10) – – $167,371.45
180 (end of year 15) – – $142,097.69

In the first 12 months you pay $11,933.19 of interest and only $2,456.02 of principal. Halfway through the term, more than 70% of the original balance is still owed. Principal finally overtakes interest at payment 223.

How extra payments change the schedule

Every extra dollar goes straight to principal, so it stops collecting interest for the rest of the loan. On the same loan:

Extra each month Interest saved Time saved
$100 $49,138 5 years 5 months
$200 $79,801 9 years

Extra payments made early save the most, because the balance they remove would otherwise have collected interest for decades. Before paying extra, confirm that your loan has no prepayment penalty and ask your servicer to apply the money to principal, not to future payments.

Amortization in accounting

The word has a second meaning. In accounting, amortization is spreading the cost of an intangible asset, such as a patent, software license or franchise right, over its useful life. Most companies use the straight-line method: annual amortization expense = cost ÷ useful life. A $50,000 patent with a 10-year useful life is expensed at $5,000 a year. Amortization is the intangible-asset version of depreciation, which applies to physical assets like machinery and buildings, and both are added back in EBITDA. This calculator covers loan amortization, the repayment of debt through scheduled payments.

Amortization schedule tips

  • Compare terms side by side. A 15-year schedule on the same $200,000 at 6% costs $1,687.71 a month but saves about $127,888 in interest compared with 30 years.
  • Use it for any fixed-rate installment loan. Mortgages, car loans and personal loans all amortize the same way. For a car purchase with tax and a trade-in, start with the auto loan calculator.
  • Remember escrow. A mortgage payment usually also includes property tax and insurance. The mortgage calculator adds those so you see the full monthly bill.
  • Biweekly plans. Paying half the payment every two weeks adds up to 13 monthly payments a year. You can model that here by entering one-twelfth of your payment as the extra amount.
  • Check what you can afford first. The home affordability calculator works backward from your income to a loan size that fits.

Amortization Calculator: frequently asked questions

What is amortization?

Amortization is paying off a loan with equal, scheduled payments that cover the interest due and a slice of the principal. Early payments are mostly interest; later payments are mostly principal, and the last one brings the balance to zero.

How do you calculate an amortization schedule?

Find the payment with M = P × r(1 + r)^n ÷ ((1 + r)^n − 1). Then, for each month, interest = balance × r, principal = payment − interest, and new balance = old balance − principal. On $200,000 at 6%, month one is $1,000.00 interest and $199.10 principal.

How do I make an amortization schedule in Excel?

Use =PMT(0.06/12, 360, -200000) for the payment ($1,199.10), =IPMT(0.06/12, 1, 360, -200000) for the first month's interest ($1,000.00) and =PPMT with the same arguments for the principal. Copy the formulas down 360 rows, changing the period number each row.

How much do extra payments save?

On a $200,000 loan at 6% for 30 years, an extra $100 a month saves about $49,138 in interest and ends the loan 5 years 5 months early. An extra $200 a month saves about $79,801 and takes 9 years off.

When do you start paying more principal than interest?

On a 30-year loan at 6%, principal first exceeds interest in payment 223, during year 19. Higher rates push that point later; shorter terms bring it much earlier.

Is a 15-year loan cheaper than a 30-year loan?

Yes, in total interest. On $200,000 at 6%, a 15-year term costs $1,687.71 a month and about $103,788 in interest, compared with $1,199.10 a month and about $231,676 over 30 years. Lenders usually offer a lower rate on 15-year loans too.

What is negative amortization?

Negative amortization happens when a payment is smaller than the interest due, so the unpaid interest is added to the balance and the debt grows. Standard fixed-rate loans like the ones this calculator models do not negatively amortize.

Disclaimer: This calculator gives estimates for planning and education only. Actual rates, fees and terms vary by lender and provider. It is not financial advice, so check the figures with your bank or a qualified adviser before you make a decision.

How we checked this page: every figure in the examples and FAQs above is produced by this calculator and verified by automated tests against known answers, and the rules and rates come from the sources below. Last updated . Spotted a problem? Tell us.

Browse all financial calculators →