Skip to main content
Sign in Create a free account
Varsity Tutors
Sign in
Back to lessons

Finite Mathematics • Mathematics of Finance

Amortization Schedules — Interpret amortization schedules (principal vs interest)

Understand how each loan payment splits between reducing debt and paying the cost of borrowing.

Explore the lesson 16 min read
A finite grid with probability die and proportion chart for finite mathematics
Inside this lesson 10 sections 5 questions 10 figures

SECTION 1

Historical Context & Motivation

The concept of amortization — from the Latin admortire, meaning "to kill" — refers to the systematic process of extinguishing a debt through periodic payments. Long before modern spreadsheets and financial calculators, merchants and moneylenders grappled with a fundamental question: how should periodic payments be structured so that a borrower both compensates the lender for the use of capital (interest) and gradually reduces the outstanding obligation (principal)? The tension between these two components — interest versus principal — lies at the heart of every mortgage, auto loan, and student loan repayment plan in existence today.

~2000 BCE • Ancient Babylonian Lending

Clay tablets from Mesopotamia record interest calculations on grain and silver loans, establishing the earliest known practice of charging interest on borrowed capital. Repayment structures were simple, often lump-sum at harvest.

1494 • Pacioli's Double-Entry Bookkeeping

Luca Pacioli's Summa de Arithmetica formalized accounting methods, providing a framework for tracking how payments reduce liabilities over time — a conceptual precursor to amortization tables.

1700s–1800s • Compound Interest Tables

European mathematicians published extensive compound interest and annuity tables that allowed lenders to compute level payment amounts, making structured loan repayment feasible at scale for banks and governments.

1934 • The Federal Housing Administration

The FHA standardized the long-term, fixed-rate, fully amortizing mortgage in the United States. This replaced the common interest-only loans with balloon payments, making homeownership accessible and amortization schedules a household concept.

1980s–Present • Spreadsheets & Financial Software

Electronic spreadsheets like VisiCalc and Excel democratized amortization schedule generation. Today, any borrower can instantly see the principal-versus-interest breakdown of every payment across the life of a loan.

The central question an amortization schedule answers is deceptively simple: for any given payment, how much goes toward interest and how much actually reduces the balance owed? Understanding this decomposition is essential not only for financial literacy but also for applications in accounting (determining interest expense), tax preparation (mortgage interest deductions), and corporate finance (debt structuring). The remainder of this lesson develops the mathematical framework for constructing and interpreting these schedules in full detail.

SECTION 2

Core Principles & Definitions

Before dissecting an amortization schedule row by row, it is important to establish the foundational concepts that govern how loan payments are allocated. An amortization schedule is a complete table that lists every payment over the life of a loan, decomposing each payment into its interest portion and its principal portion while tracking the remaining balance. The following core principles dictate the structure of every standard (level-payment) amortization schedule.

1

Level Payment (Annuity Structure)

In a standard amortizing loan, the borrower makes a fixed periodic payment (PMT) each period. This payment remains constant throughout the loan's term, which is why the loan is modeled as an ordinary annuity.
2

Interest Computed on Outstanding Balance

Each period, the interest portion of the payment equals the periodic interest rate (i) multiplied by the outstanding balance at the start of that period. As the balance shrinks, so does the interest charge.
3

Principal = Payment − Interest

The principal portion is the residual: whatever part of the fixed payment is not consumed by interest goes directly toward reducing the outstanding balance. Early payments are interest-heavy; later payments are principal-heavy.
4

Balance Updates Recursively

The outstanding balance after each payment equals the previous balance minus the principal portion just paid. This recursive relationship continues until the balance reaches zero after the final payment.
5

Total Interest = Sum of All Interest Portions

The total cost of borrowing is found by summing the interest portions across every payment (or equivalently, total payments minus original principal). This quantity reveals how much the borrower pays beyond the amount originally borrowed.
✦

KEY TAKEAWAY

Think of a level-payment loan like filling a bathtub while the drain is partially open. Each period, the same "bucket" of water (your fixed payment) is poured in, but the drain (interest) siphons off an amount proportional to how full the tub is (the outstanding balance). Early on, most of the water drains away (high interest), so the water level (balance) barely drops. As the tub empties, less water drains out each time, and the level drops faster — this is why principal repayment accelerates toward the end of a loan.

SECTION 3

Visual Explanation — The Payment Split Over Time

The most instructive way to internalize the dynamics of an amortization schedule is through a stacked-area visualization. The diagram below depicts a 12-period loan, showing how the fixed payment is divided between interest (upper region) and principal (lower region) at each payment. Observe the characteristic crossover: early payments allocate the majority of the fixed payment to interest, while later payments allocate most to principal. The balance curve (dashed line) traces the declining outstanding debt.

Payment Allocation: Interest vs. Principal (12-Period Loan)Payment NumberDollar Amount123456789101112PMTInterest PortionPrincipal Portion
Each bar represents the fixed payment (PMT). The pink region is interest, and the cyan region is principal. Notice how the pink region shrinks and the cyan region grows with each successive payment — the hallmark of amortization.

The visual makes the critical insight unmistakable: the payment amount is constant, but its composition shifts dramatically. In period 1, roughly two-thirds of the payment services interest. By period 12, almost the entire payment retires principal. This front-loading of interest has significant practical implications — for instance, a borrower who sells a home after five years of a 30-year mortgage will have repaid far less principal than one might naively expect, since most early payments were consumed by interest charges.

SECTION 4

Mathematical Framework

The mathematics of amortization derives directly from the present-value-of-an-annuity formula. We begin with the computation of the level payment, then develop the recursive formulas that generate each row of the schedule.

PRESENT VALUE OF AN ORDINARY ANNUITY

PV=PMT×[1−(1+i)−n]/iPV = PMT × [ 1 − (1 + i)⁻ⁿ ] / i

PV = present value (loan amount), PMT = level periodic payment, i = periodic interest rate (annual rate ÷ periods per year), n = total number of payments.

SOLVING FOR THE PAYMENT (PMT)

PMT=PV×i/[1−(1+i)−n]PMT = PV × i / [ 1 − (1 + i)⁻ⁿ ]

This is the algebraic rearrangement of the annuity formula. Given the loan amount PV, periodic rate i, and total periods n, this yields the fixed payment that fully amortizes the loan.

Row-by-Row Schedule Formulas

Once PMT is known, each row k (where k = 1, 2, …, n) of the amortization schedule is computed via three recursive equations. Let Bk denote the outstanding balance after payment k, with B0 = PV (the original loan amount).

INTEREST PORTION OF PAYMENT k

Ik=i×Bk−1I_k = i × B_{k−1}

The interest charged in period k equals the periodic rate times the balance at the end of the previous period. This is why interest decreases as the balance shrinks.

PRINCIPAL PORTION OF PAYMENT k

Pk=PMT−IkP_k = PMT − I_k

Whatever remains after interest is subtracted goes toward reducing the principal. As Ik decreases over time, Pk increases correspondingly.

BALANCE UPDATE

Bk=Bk−1−PkB_k = B_{k−1} − P_k

The new outstanding balance is the old balance minus the principal just repaid. After the final payment (k = n), Bn = 0 (the loan is fully retired).

💡

Closed-Form Balance Formula

It is also possible to compute the outstanding balance after payment k without iterating through every row: Bk = PMT × [1 − (1 + i)−(n−k)] / i. This is the present value of the remaining (n − k) payments, a result known as the prospective method of finding the outstanding balance.

SECTION 5

Anatomy of an Amortization Schedule

To make these formulas concrete, consider a $10,000 loan at a nominal annual rate of 6%, compounded monthly, to be repaid in 12 monthly payments. The periodic rate is i = 0.06/12 = 0.005, and n = 12. Applying the payment formula yields PMT ≈ $860.66. The complete amortization schedule appears below.

Payment #Payment (PMT)Interest (Iₖ)Principal (Pₖ)Balance (Bₖ)
0———$10,000.00
1$860.66$50.00$810.66$9,189.34
2$860.66$45.95$814.71$8,374.63
3$860.66$41.87$818.79$7,555.84
4$860.66$37.78$822.88$6,732.96
5$860.66$33.66$827.00$5,905.96
6$860.66$29.53$831.13$5,074.83
7$860.66$25.37$835.29$4,239.54
8$860.66$21.20$839.46$3,400.08
9$860.66$17.00$843.66$2,556.42
10$860.66$12.78$847.88$1,708.54
11$860.66$8.54$852.12$856.42
12$860.70$4.28$856.42$0.00

Full 12-month amortization schedule for a $10,000 loan at 6% annual rate, compounded monthly

Outstanding Balance Decline & Cumulative InterestPayment NumberDollars ($)01234567891011121000080006000400020000 $328Outstanding BalanceCumulative Interest
The solid cyan line shows the outstanding balance declining to zero over 12 payments. The dashed pink line shows cumulative interest paid, which increases at a decreasing rate, reaching a total of approximately $327.97 over the life of the loan.

Several patterns emerge from the schedule and its companion graph. First, the interest portion in payment 1 ($50.00) is almost twelve times larger than the interest in payment 12 ($4.28). Second, the principal portion grows modestly from $810.66 to $856.42 — each principal portion is exactly (1 + i) times the previous one, a fact that follows algebraically from the recursive formulas. Third, the total interest paid ($327.97) represents only about 3.28% of the original principal, reflecting the relatively short loan term and moderate rate. For a 30-year mortgage, total interest can exceed the original loan amount, underscoring how powerfully term length amplifies the front-loading of interest.

SECTION 6

Worked Example — Building and Interpreting a Schedule

A student borrows $5,000 at an annual interest rate of 8%, compounded quarterly, to be repaid in 8 equal quarterly payments. Construct the first three rows and the last row of the amortization schedule, and determine the total interest paid over the life of the loan.

FULL SOLUTION

  1. 1

    Step 1 — Identify the Given Values

    PV = $5,000, annual nominal rate = 8%, compounding frequency = quarterly, so i = 0.08/4 = 0.02 per quarter. Total number of payments: n = 8.
  2. 2

    Step 2 — Compute the Level Payment (PMT)

    Using PMT = PV × i / [1 − (1 + i)⁻ⁿ]: PMT = 5000 × 0.02 / [1 − (1.02)⁻⁸] = 100 / [1 − (1.02)⁻⁸] = 100 / [1 − 0.85349] = 100 / 0.14651
    PMT ≈ $682.55
  3. 3

    Step 3 — Row 1 of the Schedule (k = 1)

    Interest: I₁ = 0.02 × $5,000 = $100.00. Principal: P₁ = $682.55 − $100.00 = $582.55. New balance: B₁ = $5,000 − $582.55 = $4,417.45.
    B₁ = $4,417.45
  4. 4

    Step 4 — Row 2 of the Schedule (k = 2)

    Interest: I₂ = 0.02 × $4,417.45 = $88.35. Principal: P₂ = $682.55 − $88.35 = $594.20. New balance: B₂ = $4,417.45 − $594.20 = $3,823.25.
    B₂ = $3,823.25
  5. 5

    Step 5 — Row 3 of the Schedule (k = 3)

    Interest: I₃ = 0.02 × $3,823.25 = $76.47. Principal: P₃ = $682.55 − $76.47 = $606.08. New balance: B₃ = $3,823.25 − $606.08 = $3,217.17.
    B₃ = $3,217.17
  6. 6

    Step 6 — Verify the Pattern and Compute the Last Row (k = 8)

    Continuing the process through k = 7 yields B₇ ≈ $669.12. For the final payment: I₈ = 0.02 × $669.12 = $13.38. P₈ = $682.55 − $13.38 = $669.17. Due to rounding, the last payment is adjusted to $669.12 + $13.38 = $682.50 so that the balance reaches exactly $0.00. The final row closes the schedule.
    B₈ = $0.00
  7. 7

    Step 7 — Total Interest Paid

    Total of all payments = 8 × $682.55 = $5,460.40 (with minor rounding adjustment). Total interest = $5,460.40 − $5,000 = $460.40. Alternatively, sum each IkI_k from the schedule. This means the borrower pays about 9.2% of the original principal in interest over the 2-year term.
    Total interest ≈ $460.40

SECTION 7

Amortization vs. Other Repayment Structures

Not all loans follow the standard level-payment amortization model. Understanding the alternatives clarifies why amortization schedules are structured the way they are, and when a different structure might be advantageous. The following table compares three common loan repayment designs.

FeatureFully Amortizing (Level PMT)Interest-Only with BalloonConstant Principal (Straight-Line)
Payment PatternFixed every periodSmall, fixed interest-only; large lump sum at endDeclining — fixed principal + decreasing interest
Principal ReductionGradual; accelerates over timeNone until balloon paymentConstant amount each period
Total Interest PaidModerateHighest (balance never declines)Lowest (balance declines fastest)
Cash-Flow PredictabilityHigh — same payment each periodLow — manageable early, massive final paymentModerate — payments decline over time
Common Use CasesMortgages, auto loans, student loansCommercial real estate, bridge financingSome commercial and municipal loans

Comparison of three loan repayment structures

✦

KEY TAKEAWAY

The fully amortizing structure dominates consumer lending because it offers predictable budgeting (equal payments) while guaranteeing the debt is fully retired on schedule. However, this convenience comes at a cost: the front-loading of interest means the borrower builds equity slowly in the early years. In engineering terms, it is a tradeoff between cash-flow smoothness and capital efficiency — analogous to how a constant-speed conveyor is simpler to design than a variable-speed one, even though the variable-speed system can be more efficient.

SECTION 8

Connections to Advanced Theory

The amortization schedule concepts covered in this lesson form the foundation for several more advanced topics in financial mathematics and actuarial science. Understanding the principal-versus-interest decomposition is prerequisite knowledge for bond valuation (where the concept of amortizing a premium or discount is central), adjustable-rate mortgage analysis, and the construction of sinking funds. The table below maps the core ideas of this lesson to their extensions in advanced coursework.

This Lesson (Fundamentals)Advanced Extension
Fixed periodic rate iVariable/adjustable rate iₖ that changes at reset dates (ARM analysis)
Level payment PMTGraduated payment mortgages (GPMs) where PMT increases by a fixed percentage
Prospective balance formulaRetrospective balance formula: BkB_k = PV(1+i)k(1+i)^k − PMT × [(1+i)k(1+i)^k − 1]/i
Single loan amortizationBond amortization of premium/discount using book value method
Total interest = n × PMT − PVAnnual Percentage Rate (APR) calculations incorporating fees and points

From basic amortization to advanced financial mathematics

One particularly elegant result worth noting is the geometric growth of the principal portion. Since Pk = PMT − i × Bk−1 and Bk = Bk−1 − Pk, one can show algebraically that Pk+1 = Pk × (1 + i). In other words, the principal portions form a geometric sequence with common ratio (1 + i). This elegant property allows direct computation of any single principal portion without iterating through the entire schedule: Pk = P₁ × (1 + i)k−1, where P₁ = PMT − i × PV.

SECTION 9

Practice Problems

Question 1: CONCEPTUAL

In a standard fully amortizing loan with level payments, explain why the interest portion of each payment decreases over time while the principal portion increases, even though the total payment remains constant.
Show answer
Because the interest each period is calculated as IkI_k = i × Bk−1B_{k−1}, and the outstanding balance Bk−1B_{k−1} decreases after every payment, the interest charge must decline. Since the total payment PMT is fixed, the remainder PMT − IkI_k (the principal portion) must correspondingly increase. This creates the characteristic "tilt" in the amortization schedule: early payments are interest-heavy because the balance is large, while later payments are principal-heavy because the balance has shrunk. The total payment is essentially a "budget" that first satisfies the interest obligation, with the surplus going to principal.

Question 2: BASIC CALCULATION

A $20,000 loan is amortized over 5 years with monthly payments at a nominal annual interest rate of 6%. Compute the monthly payment, the interest portion of the first payment, and the principal portion of the first payment.
Show answer
The periodic rate is i = 0.06/12 = 0.005, and n = 60 payments. Applying the payment formula: PMT = 20000 × 0.005 / [1 − (1.005)⁻⁶⁰] = 100 / [1 − 0.74137] = 100 / 0.25863 ≈ $386.66. For the first payment: I₁ = 0.005 × $20,000 = $100.00, and P₁ = $386.66 − $100.00 = $286.66. Thus, approximately 25.9% of the first payment services interest, with the remaining 74.1% reducing principal. This ratio shifts further toward principal with each subsequent payment.

Question 3: INTERMEDIATE

Using the loan from Problem 2 ($20,000, 6% nominal, monthly payments, 5-year term), determine the outstanding balance after the 24th payment using the prospective method. How much total interest has been paid through the first 24 payments?
Show answer
The prospective method gives B₂₄ = PMT × [1 − (1+i)−(n−k)(1 + i)^{−(n−k)}] / i = 386.66 × [1 − (1.005)⁻³⁶] / 0.005. Computing (1.005)⁻³⁶ ≈ 0.83564, so B₂₄ = 386.66 × [1 − 0.83564] / 0.005 = 386.66 × 0.16436 / 0.005 = 386.66 × 32.872 ≈ $12,711.58. Total paid through 24 payments = 24 × $386.66 = $9,279.84. Principal repaid = $20,000 − $12,711.58 = $7,288.42. Therefore, total interest = $9,279.84 − $7,288.42 = $1,991.42. Note that after 40% of the loan term (24/60), only about 36.4% of the principal has been repaid, illustrating interest front-loading.

Question 4: APPLIED

A homeowner takes out a $250,000 fixed-rate mortgage at 7.2% annual interest, compounded monthly, for 30 years. After making payments for exactly 10 years, they want to know: (a) the outstanding balance, (b) the total interest paid so far, and (c) the interest portion of the very next (121st) payment. Interpret what these figures mean for the homeowner's equity position.
Show answer
Here i = 0.072/12 = 0.006, n = 360. PMT = 250000 × 0.006 / [1 − (1.006)⁻³⁶⁰] = 1500 / [1 − 0.11591] ≈ 1500/0.88409 ≈ $1,696.56. (a) B₁₂₀ = 1696.56 × [1 − (1.006)⁻²⁴⁰] / 0.006 = 1696.56 × [1 − 0.23686]/0.006 = 1696.56 × 127.19 ≈ $215,749. (b) Total paid in 120 months = 120 × $1,696.56 = $203,587.20. Principal repaid = $250,000 − $215,749 = $34,251. Total interest = $203,587.20 − $34,251 = $169,336.20. (c) I₁₂₁ = 0.006 × $215,749 ≈ $1,294.49. After 10 years (one-third of the term), the homeowner has paid over $169,000 in interest but reduced the principal by only about $34,000. Roughly 83.2% of the money paid so far has been interest. The homeowner's equity from payments alone is only about 13.7% of the original loan. This starkly illustrates the front-loading phenomenon in long-term mortgages.

Question 5: CRITICAL THINKING

Prove that in a level-payment amortization schedule, the principal portions form a geometric sequence with common ratio (1 + i). Then use this result to derive a closed-form expression for the interest portion of payment k in terms of PMT, i, and (1+i)k−1(1 + i)^{k−1}, without referencing the balance.
Show answer
Proof: PkP_k = PMT − i × Bk−1B_{k−1} and Pk+1P_{k+1} = PMT − i × BkB_k. Since BkB_k = Bk−1B_{k−1} − PkP_k, substituting: Pk+1P_{k+1} = PMT − i(Bk−1B_{k−1} − PkP_k) = PMT − iBk−1iB_{k−1} + iP_k = PkP_k + iP_k = PkP_k(1 + i). This shows Pk+1P_{k+1}/PkP_k = (1 + i) for all k, establishing the geometric sequence. Since P₁ = PMT − iPV, the general term is PkP_k = P₁(1+i)k−1(1 + i)^{k−1} = (PMT − iPV)(1+i)k−1(1 + i)^{k−1}. For the interest portion: IkI_k = PMT − PkP_k = PMT − (PMT − iPV)(1+i)k−1(1 + i)^{k−1}. This is fully closed-form — it gives the interest in any period k without computing the balance or iterating through previous rows. This result is especially useful for auditing specific rows of large schedules (e.g., finding the interest in month 200 of a 360-month mortgage) without computing the intervening 199 rows.

SUMMARY

Lesson Summary

Summary

An amortization schedule decomposes each level payment into an interest portion (computed as i × outstanding balance) and a principal portion (the remainder that reduces the debt). Because the outstanding balance shrinks with every payment, the interest charge decreases and the principal repayment accelerates — a phenomenon known as interest front-loading. The payment amount is derived from the present-value-of-an-annuity formula, and each row of the schedule follows three recursive equations: IkI_k = i × Bk−1B_{k−1}, PkP_k = PMT − IkI_k, and BkB_k = Bk−1B_{k−1} − PkP_k.

Key insights include the fact that the principal portions form a geometric sequence with ratio (1 + i), that the total interest equals n × PMT − PV, and that the outstanding balance at any point can be found via the prospective method (present value of remaining payments). Mastery of amortization schedules is foundational for analyzing mortgages, auto loans, bond premium amortization, and virtually any structured debt instrument encountered in financial practice.

Varsity Tutors • Finite Mathematics • Amortization Schedules — Interpret amortization schedules (principal vs interest)