Skip to content
Calculator.hair

Amortization Calculator

$
years
months
%
Monthly payment
$1,687.71
Total of 180 payments
$303,788.46
Total interest
$103,788.46
Payoff date
Oct 2041
Principal 66%Interest 34%
Balance and cumulative interest
$0$50K$100K$150K$200K0246810121415
BalanceInterest paid
Annual schedule
YearInterestPrincipalEnding balance
1 (Nov 2026)$11,769.23$8,483.33$191,516.67
2 (Nov 2027)$11,246.00$9,006.57$182,510.10
3 (Nov 2028)$10,690.49$9,562.07$172,948.02
4 (Nov 2029)$10,100.72$10,151.84$162,796.18
5 (Nov 2030)$9,474.58$10,777.98$152,018.20
6 (Nov 2031)$8,809.82$11,442.75$140,575.45
7 (Nov 2032)$8,104.05$12,148.51$128,426.94
8 (Nov 2033)$7,354.76$12,897.80$115,529.13
9 (Nov 2034)$6,559.25$13,693.31$101,835.82
10 (Nov 2035)$5,714.68$14,537.89$87,297.94
11 (Nov 2036)$4,818.01$15,434.55$71,863.38
12 (Nov 2037)$3,866.04$16,386.52$55,476.86
13 (Nov 2038)$2,855.36$17,397.21$38,079.66
14 (Nov 2039)$1,782.34$18,470.23$19,609.43
15 (Nov 2040)$643.13$19,609.43$0.00
Monthly schedule

This amortization calculator shows the monthly payment on a fixed-rate loan and how each payment splits between interest and principal, with optional extra payments to see how much sooner the loan is repaid.

What is Amortization?

Amortization has two related meanings. In lending, it is the process of paying off a debt with regular, equal payments that cover both interest and principal, so the balance reaches zero at the end of the term. An amortization schedule is the table that lists every payment and shows how much goes to interest, how much to principal and what balance remains. In accounting, amortization means spreading the cost of an intangible asset over the years it is useful, much as depreciation does for physical equipment.

Paying Off a Loan Over Time

With an amortizing loan, the payment stays the same but its makeup changes every month. Interest is charged on the outstanding balance, so early payments are mostly interest. As the balance falls, the interest portion shrinks and more of each payment goes to principal, which in turn speeds up the decline in the balance.

Take a $200,000 loan at 6% for 15 years. The monthly payment is $1,687.71. In the first month, $1,000 of that is interest (0.5% of $200,000) and only $687.71 reduces the balance. Principal does not overtake interest until the 43rd payment, and by the final payment interest is only about $8. Over the full term the borrower pays about $103,788 in interest.

Extra payments go straight to principal, so they cut every future interest charge. Adding just $100 a month to that same loan pays it off 15 months early and saves about $10,000 in interest. Use the extra payment options to test monthly, yearly or one-time amounts, and check your loan terms for any prepayment penalty first.

Common amortizing loans include mortgages, auto loans, student loans and most personal loans. Credit cards and lines of credit are not amortizing in this sense: the required payment changes with the balance and there is no fixed payoff date. Interest-only and balloon loans are also structured differently, deferring principal to later in the term.

Payment = P × r(1 + r)ⁿ ÷ [(1 + r)ⁿ − 1] · Interestₖ = Balanceₖ₋₁ × r

P
loan amount
r
monthly interest rate (annual rate ÷ 12)
n
number of monthly payments

Each month, interest is the previous balance times the monthly rate; the rest of the payment reduces the balance.

Spreading Costs

In business accounting, amortization spreads the cost of an intangible asset over its useful life instead of recording it all as an expense in the year of purchase. Intangible assets include patents, copyrights, trademarks, software, licenses, franchise agreements and customer lists acquired from another company. A patent bought for $100,000 with ten years of remaining protection might be amortized at $10,000 a year, usually on a straight-line basis.

The point is to match costs with the revenue they help produce. Spreading the expense gives a more accurate picture of profit in each year and of the asset's remaining value on the balance sheet. Intangibles with no fixed end date, such as goodwill under US accounting rules for public companies, are generally not amortized but tested each year for impairment instead.

Tax rules follow their own schedules. In the United States, Section 197 of the tax code generally requires certain acquired intangibles, including goodwill, to be amortized evenly over 15 years, and businesses can deduct a limited amount of startup and organizational costs in the first year and amortize the rest over 15 years. Rules differ by country and change over time, so confirm current treatment with a tax professional.

Frequently asked questions

What is an amortization schedule?

It is a table of every loan payment showing the interest, principal and remaining balance after each one. The calculator shows it by month and by year.

Why is most of my early payment interest?

Interest is charged on the outstanding balance, which is largest at the start. As you pay the balance down, less interest accrues and more of each payment goes to principal.

How do extra payments affect amortization?

Extra payments reduce the principal immediately, so every later payment carries less interest. The loan is repaid sooner and total interest falls.

What is the monthly payment on a $200,000 loan?

At 6% for 15 years it is $1,687.71. At 6% for 30 years it is about $1,199.10. Enter your own rate and term to check.

What is the difference between amortization and depreciation?

Both spread an asset's cost over time in accounting. Amortization applies to intangible assets like patents and software; depreciation applies to physical assets like machinery and buildings.

What is the formula for loan amortization?

The payment is P × r(1 + r)ⁿ ÷ [(1 + r)ⁿ − 1], where P is the loan amount, r the monthly rate and n the number of payments. Each month, interest is the previous balance times r, principal is the payment minus that interest, and the new balance is the old one minus the principal. The same steps work for car loans, home loans and any other fixed-rate installment loan.

How do I make an amortization schedule in Excel?

Use =PMT(rate/12, months, -amount) for the payment, =IPMT(rate/12, k, months, -amount) for the interest in payment k and =PPMT(rate/12, k, months, -amount) for the principal. For $200,000 at 6% over 15 years, =PMT(6%/12, 180, -200000) returns $1,687.71, and the first payment's interest is $1,000. Fill the rows down from k = 1 to 180 and subtract each principal amount from the running balance.

Results are estimates for educational purposes and are not financial, tax or legal advice. Confirm figures with a qualified professional or your lender.

Updated by Calculator.hair. How we build and check our calculators

Sources