Loan Amortization

Loan amortization is the process of repaying a debt over time through regular, scheduled payments that cover both the principal and the interest. Most amortized loans—such as mortgages, car loans, and personal loans—are structured so that the borrower pays a fixed amount periodically, with the composition of each payment changing over time.

In amortized loans, your monthly payment stays the same, but what you’re paying for shifts—less interest, more principal.

Understanding loan amortization helps borrowers evaluate total interest cost, optimize prepayments, and compare loan products.

Key Concepts

Principal: The original amount borrowed
Interest: The cost of borrowing money, expressed as an annual percentage rate (APR)
Term: The total length of the loan (e.g., 15 years, 30 years)
Installment: Each periodic payment made (usually monthly)

Amortized Loan Types

Mortgages
Auto loans
Personal loans
Student loans
Small business loans

These differ from interest-only or balloon loans, where payments do not fully pay down principal during the term.

How Loan Amortization Works

Each payment includes:

Interest payment: Calculated on the remaining loan balance
Principal repayment: The portion that reduces the outstanding balance

Over time:

Interest portion decreases
Principal portion increases

This progression is documented in an amortization schedule.

Loan Amortization Formula

To calculate the monthly payment (P) on an amortized loan:

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

Where:

P = Monthly payment
PV = Present value of loan (loan amount)
r = Monthly interest rate = annual rate ÷ 12
n = Total number of payments (loan term in months)

Example

Loan amount: $20,000
Interest rate: 6% annually (0.005 monthly)
Term: 5 years (60 months)

P = [0.005 × 20,000] / [1 − (1 + 0.005)^−60]  
P ≈ $386.66

Total payments over 5 years = 386.66 × 60 = $23,199.60
Total interest = $3,199.60

Amortization Schedule Breakdown

Payment #	Interest	Principal	Remaining Balance
1	$100.00	$286.66	$19,713.34
2	$98.57	$288.09	$19,425.25
…	…	…	…
60	$1.91	$384.75	$0.00

The schedule changes every month due to the declining balance.

Prepayment and Early Payoff

Borrowers can reduce interest costs by prepaying principal. Prepayments:

Lower total interest paid
Shorten loan term (if extra applied to principal)
Often subject to prepayment penalties in some loan contracts

Types of Amortization Structures

Type	Description
Fully Amortized	Loan paid to $0 at end of term via regular payments
Partially Amortized	Periodic payments + large balloon payment at maturity
Negative Amortization	Payments don’t cover interest, increasing balance
Accelerated Amortization	Larger or more frequent payments reduce loan faster

Benefits of Amortized Loans

Predictable payments
Progressive equity building (in mortgages)
Interest savings with early payments
Transparency via amortization schedules

Loan Comparison Using Amortization

When choosing between loan offers, consider:

Monthly payment size
Total interest paid over life of loan
Time to full amortization
Flexibility to prepay

Online calculators and spreadsheet models make this comparison simple.

Excel Formula for Loan Amortization

Use Excel’s PMT function to calculate fixed monthly payments:

=PMT(rate, nper, -pv)

Example:

=PMT(0.06/12, 60, -20000) → $386.66

Use PPMT and IPMT to extract principal and interest per period.

Final Thoughts

Loan amortization brings structure and transparency to debt repayment. Understanding how interest and principal interact over time empowers borrowers to manage loans strategically—whether through refinancing, prepaying, or simply budgeting with confidence.