What Is Amortization?
Amortization is the process of paying off a debt through a series of equal, scheduled payments over a fixed period of time. With a standard fully-amortizing loan, every payment is identical - yet each one is split differently between interest and principal.
Early in the loan, the vast majority of each payment covers interest. Late in the loan, most of each payment reduces principal. This is not a quirk or a trick by lenders — it is a direct mathematical consequence of how compound interest works on a declining balance. The formula ensures the loan reaches exactly zero on the final payment date.
Fixed Payment
Your monthly payment M stays the same for the entire loan term, regardless of how the split between P and I shifts each month.
Declining Balance
Each payment reduces your outstanding principal, which means the next month's interest charge is slightly lower - freeing more of your payment for principal.
Front-Loaded Interest
In early months, most of your payment goes to interest. This flips in later years as the balance - and therefore the interest charge - shrinks.
Exact Zero at End
The formula is derived to guarantee the balance reaches exactly $0.00 on the final payment, with no balloon payment and no shortfall.
The Amortization Formula
The standard fixed-rate amortization formula for a monthly payment is:
This formula was derived by solving for the fixed payment M that satisfies the condition: starting with a balance of P, making n equal payments at a periodic rate of r, the balance reaches exactly zero after the nth payment. The derivation uses the present value of an annuity formula and is standard across all US lending institutions.
Understanding Each Variable
The most frequent error when applying the amortization formula by hand is forgetting to convert the annual interest rate to a monthly rate. If your loan is quoted at 6.5% annually, you must use r = 0.065 ÷ 12 = 0.005417 in the formula — not 0.065. Using the annual rate directly will give a completely wrong result.
Worked Example: 30-Year Mortgage
Let's apply the amortization formula to a real mortgage scenario, working through every step of the calculation.
Example 1 — 30-Year Fixed Mortgage
Calculate the monthly payment on a $300,000 mortgage at 6.5% for 30 years
Divide the annual interest rate by 12.
r = 6.5% ÷ 12 = 0.065 ÷ 12 = 0.0054167
Multiply the loan term in years by 12.
n = 30 years × 12 = 360 monthly payments
This is the core compound factor — raise (1 + monthly rate) to the power of total payments.
(1 + 0.0054167)³⁶⁰ = (1.0054167)³⁶⁰ = 7.0009
$300,000 × 0.0054167 × 7.0009 = $11,384.95
7.0009 − 1 = 6.0009
M = $11,384.95 ÷ 6.0009
✓ Monthly Payment M = $1,896.20
You will pay $1,896.20 every month for 30 years. Over the life of the loan, total payments sum to $1,896.20 × 360 = $682,632, meaning total interest paid is $682,632 − $300,000 = $382,632 — more than the original loan amount itself. This is why understanding the amortization formula matters.
Enter $300,000, 6.5%, and 30 years into our free amortization calculator to confirm this result and see the complete 360-payment schedule, charts and equity milestones instantly.
How Each Payment Is Split: Principal vs. Interest
Once you know the fixed monthly payment M, you can calculate exactly how much of any given payment goes to interest and how much reduces your principal balance. The formulas for month t are:
Interest for month t = Balance(t−1) × r
Principal for month t = M − Interest for month t
Balance(t) = Balance(t−1) − Principal for month t
Let's apply this to the first three months of our $300,000 mortgage example:
First 12 Months — Amortization Schedule Preview
| Month | Payment | Principal | Interest | Balance |
|---|---|---|---|---|
| 1 | $1,896.20 | $271.20 | $1,625.00 | $299,728.80 |
| 2 | $1,896.20 | $272.67 | $1,623.53 | $299,456.13 |
| 3 | $1,896.20 | $274.15 | $1,622.05 | $299,181.98 |
| 4 | $1,896.20 | $275.63 | $1,620.57 | $298,906.35 |
| 5 | $1,896.20 | $277.12 | $1,619.08 | $298,629.23 |
| 6 | $1,896.20 | $278.62 | $1,617.58 | $298,350.61 |
| 7 | $1,896.20 | $280.13 | $1,616.07 | $298,070.48 |
| 8 | $1,896.20 | $281.65 | $1,614.55 | $297,788.83 |
| 9 | $1,896.20 | $283.17 | $1,613.03 | $297,505.66 |
| 10 | $1,896.20 | $284.70 | $1,611.50 | $297,220.96 |
| 11 | $1,896.20 | $286.24 | $1,609.96 | $296,934.72 |
| 12 | $1,896.20 | $287.79 | $1,608.41 | $296,646.93 |
| Year 1 Total | $22,754.40 | $3,353.07 | $19,401.33 | $296,646.93 |
Notice the pattern: every month, the principal portion increases by roughly $1.50 and the interest portion decreases by the same amount. After a full year of payments, you have paid $22,754.40 but reduced your balance by only $3,353.07 — just 14.7% of total payments went to principal. The remaining 85.3% went to interest.
Why Are Mortgages So Interest-Heavy Early On?
This is the most common question borrowers have after seeing their amortization schedule for the first time. The answer is pure math — not a lender policy.
In month 1 of the $300,000 mortgage, the outstanding balance is $300,000. At a monthly rate of 0.5417%, the interest charge is $300,000 × 0.005417 = $1,625.00. Your total payment is $1,896.20, so only $271.20 goes to principal.
By year 15 (the midpoint), your balance has fallen to roughly $231,000. The monthly interest charge is now about $1,250 — still significant, but $375 lower than year 1. More of your fixed payment now goes to principal, and the paydown accelerates.
The chart below shows how the principal/interest split shifts across selected years of the $300,000 mortgage:
Principal vs. Interest Split — $300,000 at 6.5% for 30 Years
The crossover point — where more of each payment goes to principal than to interest — occurs around year 20 on this loan. On a 15-year mortgage at the same rate, the crossover happens around year 11.
Worked Example: 5-Year Car Loan
The same amortization formula applies to any fixed-rate loan. Here's a car loan example - notice how much shorter the term makes the interest-to-principal ratio far less extreme than a mortgage.
Example 2 — Auto Loan
Calculate the monthly payment on a $32,000 car loan at 7.2% for 5 years
r = 7.2% ÷ 12 = 0.072 ÷ 12 = 0.006
n = 5 × 12 = 60
(1.006)⁶⁰ = 1.4320
M = 32,000 × [0.006 × 1.4320] ÷ [1.4320 − 1]
M = 32,000 × 0.008592 ÷ 0.4320
✓ Monthly Payment M = $635.99
Total payments: $635.99 × 60 = $38,159.40. Total interest: $38,159.40 − $32,000 = $6,159.40. Because the term is only 5 years (vs. 30), the total interest burden is 19.2% of the principal - dramatically lower than the mortgage example above, even though the interest rate is higher.
Worked Example: Personal Loan
Example 3 — Personal Loan
Calculate the monthly payment on a $15,000 personal loan at 11.5% for 3 years
r = 11.5% ÷ 12 = 0.115 ÷ 12 = 0.009583
n = 3 × 12 = 36
(1.009583)³⁶ = 1.4054
M = 15,000 × [0.009583 × 1.4054] ÷ [1.4054 − 1]
M = 15,000 × 0.013470 ÷ 0.4054
✓ Monthly Payment M = $498.45
Total interest paid: ($498.45 × 36) − $15,000 = $2,944.20. Despite having the highest rate of our three examples, the short 3-year term keeps total interest reasonable - which is why paying off personal loans quickly is so effective.
Comparing All Three Examples
| Loan Type | Principal | Rate | Term | Monthly Payment | Total Interest | Interest as % of Principal |
|---|---|---|---|---|---|---|
| 30-Yr Mortgage | $300,000 | 6.5% | 30 yrs | $1,896.20 | $382,632 | 127.5% |
| 5-Yr Auto Loan | $32,000 | 7.2% | 5 yrs | $635.99 | $6,159 | 19.2% |
| 3-Yr Personal | $15,000 | 11.5% | 3 yrs | $498.45 | $2,944 | 19.6% |
The personal loan has an 11.5% rate - which is nearly double the mortgage - yet it costs less in total interest as a percentage of principal. The term length has a greater impact on total interest cost than the interest rate does. Shortening your loan term or making extra payments to simulate a shorter term, is often the highest-impact way to reduce total borrowing cost.
How Extra Payments Interact with the Amortization Formula
When you make an extra payment, the amortization formula itself doesn't change - your lender still calculated your regular payment using M = P[r(1+r)ⁿ]/[(1+r)ⁿ−1]. What changes is the outstanding balance going into the next month's calculation - this is the exciting part.
Because interest each month is calculated as Balance × r, a lower balance means a lower interest charge. With less of your fixed payment consumed by interest, more goes to principal - which lowers next month's balance further. This compounding effect is why extra payments save a disproportionately large amount of interest.
Extra Payment Example: $300,000 Mortgage at 6.5%
| Scenario | Monthly Payment | Extra/Month | Payoff Time | Total Interest | Interest Saved |
|---|---|---|---|---|---|
| Standard | $1,896.20 | $0 | 30 years | $382,632 | — |
| +$100/month | $1,896.20 | $100 | 26 yrs 11 mo | $327,480 | $55,152 |
| +$200/month | $1,896.20 | $200 | 24 yrs 4 mo | $283,740 | $98,892 |
| +$300/month | $1,896.20 | $300 | 22 yrs 2 mo | $248,390 | $134,242 |
| +$500/month | $1,896.20 | $500 | 19 yrs 1 mo | $195,920 | $186,712 |
Adding just $300/month to a $300,000 mortgage saves over $134,000 in interest and cuts nearly 8 years off the loan. Use our amortization calculator's extra payment feature to model your own scenario with real numbers.
There is no single closed-form formula for extra payment savings - it must be calculated iteratively, month by month, because each extra payment changes the balance and therefore changes every subsequent interest charge. This is why a calculator (or a spreadsheet) is the right tool for this calculation.
Amortization Formula in Excel (and Google Sheets)
Excel and Google Sheets have built-in financial functions that implement the amortization formula directly. You do not need to type the full M = P[r(1+r)ⁿ]/[(1+r)ⁿ−1] equation — use these instead:
PMT — Calculate Monthly Payment
The PMT function calculates the fixed periodic payment for a loan.
= PMT( rate, nper, pv )
-- For our $300,000 mortgage example:
= PMT( 6.5%/12, 30*12, -300000 )
→ Returns: $1,896.20
-- For the $32,000 auto loan:
= PMT( 7.2%/12, 5*12, -32000 )
→ Returns: $635.99
IPMT — Interest Portion of a Specific Payment
Returns the interest component of payment number per:
= IPMT( rate, per, nper, pv )
-- Interest in payment #1 of the $300,000 mortgage:
= IPMT( 6.5%/12, 1, 30*12, -300000 )
→ Returns: $1,625.00
-- Interest in payment #180 (year 15):
= IPMT( 6.5%/12, 180, 360, -300000 )
→ Returns: $1,248.73
PPMT — Principal Portion of a Specific Payment
= PPMT( rate, per, nper, pv )
-- Principal in payment #1:
= PPMT( 6.5%/12, 1, 360, -300000 )
→ Returns: $271.20
Building a Full Schedule in Excel
To generate a complete amortization table in Excel, set up your inputs in cells and use these formulas row by row. Here's a template structure:
-- Cell setup (row 1 = headers, row 2 = month 1):
A1: Month B1: Payment C1: Principal D1: Interest E1: Balance
-- Row 2 formulas (assuming P=B$1, rate=B$2, term=B$3):
A2: 1
B2: =PMT($B$2/12, $B$3*12, -$B$1)
D2: =$B$1*($B$2/12)
C2: =B2-D2
E2: =$B$1-C2
-- Row 3 onwards (drag down to complete schedule):
D3: =E2*($B$2/12)
C3: =B3-D3
E3: =E2-C3
Lock your input cells (loan amount, rate, term) with $ signs so they don't shift when you drag formulas down through all 360 rows. The balance cell in column E should always reference the previous row's balance, not the original principal - that reference should be relative.
Special Case: 0% Interest Loans
The standard amortization formula breaks down when r = 0, because the denominator [(1+r)ⁿ − 1] becomes [(1+0)ⁿ − 1] = 0, causing a division-by-zero error. This is why calculators — and Excel's PMT function — require a special case for zero-interest loans.
The solution is simple: if the interest rate is 0%, the monthly payment is just the principal divided by the number of payments:
M = P ÷ n (only when r = 0)
A $15,000 car loan at 0% interest for 36 months costs $15,000 ÷ 36 = $416.67/month, with no interest charged at any point. Every dollar of every payment goes straight to principal.
Frequently Asked Questions
=PMT(6.5%/12, 360, -300000) returns $1,896.20. Use =IPMT() to find the interest component of any specific payment, and =PPMT() for the principal component.