Complex Financial Models — AHL 1.9 Complex financial models and amortization schedules (HL extension) - IB Mathematics Applications and Interpretation

SECTION 1

Historical Context & Motivation

Lending and borrowing money is as old as civilization itself, yet the mathematics behind structured repayment evolved slowly over centuries. In ancient Mesopotamia, clay tablets recorded interest charged on grain loans, but borrowers had no systematic way to track how each payment reduced their debt. As trade networks grew, so did the need for fair, predictable repayment plans — the ancestors of what we now call amortization schedules. Understanding this history helps explain why the formulas you will learn in this lesson exist and why they matter in the modern world.

1800 BCE • Babylonian Interest Records

Merchants in ancient Babylon recorded simple interest on clay tablets, charging rates on grain and silver loans. These are the earliest known written financial models.

1494 • Pacioli's Double-Entry Bookkeeping

Luca Pacioli published Summa de Arithmetica, formalizing accounting practices that allowed merchants to track compound interest and outstanding balances systematically.

1613 • Compound Interest Tables

Richard Witt published the first complete tables for compound interest in England, enabling bankers to calculate future values and annuities without repeated manual arithmetic.

1930s • Modern Mortgage Amortization

During the Great Depression, the U.S. government standardized the fully amortizing fixed-rate mortgage to make homeownership more accessible. This structure became the global standard for large consumer loans.

2000s • Digital Financial Modeling

Spreadsheet software and graphing calculators (including the GDC used in IB exams) made it possible for students and professionals to build and analyze complex amortization schedules in seconds.

The central question this lesson addresses is deceptively simple: if you borrow a large sum of money and agree to repay it in equal installments, how much of each payment goes toward reducing the actual debt, and how much is swallowed up by interest? Answering this question precisely is the purpose of complex financial models and amortization schedules.

SECTION 2

Core Principles & Definitions

Before diving into formulas, you need to understand a handful of foundational ideas. These concepts form the building blocks for every loan calculation, annuity formula, and amortization table you will encounter in the HL extension.

Present Value (PV)

The current worth of a future sum of money or stream of payments, discounted at a given interest rate. For a loan, the present value is the amount initially borrowed (the principal).

Future Value (FV)

The value of an investment or debt at a specified date in the future, after interest has been applied over time. For a fully repaid loan, the future value of the outstanding balance is zero.

Annuity

A series of equal payments made at regular intervals. An ordinary annuity has payments at the end of each period, while an annuity-due has payments at the beginning.

Amortization

The process of gradually paying off a debt through a series of scheduled payments. Each payment covers some interest and reduces some principal, with the split changing over time.

Nominal vs Effective Rate

The nominal rate is the quoted annual rate, while the effective rate accounts for compounding frequency. Monthly compounding at 6% nominal gives an effective rate greater than 6%.

✦

KEY TAKEAWAY

Think of amortization like filling a swimming pool with a hose while a drain is open at the bottom. Your monthly payment is the water flowing in, the interest is water leaking out through the drain, and the principal repayment is the water that actually stays in the pool. Early on, the drain is wide open (high interest), so the pool fills slowly. Over time, as the water level (outstanding balance) drops, less leaks out, and the pool fills much faster. That is why the last few payments of a loan go almost entirely toward principal.

SECTION 3

Visualizing an Amortization Schedule

The stacked-bar diagram below shows how each equal monthly payment on a 10-year loan is split between interest and principal over the life of the loan. Notice how the interest portion (pink) shrinks while the principal portion (cyan) grows. The total height of each bar stays the same because the payment amount is fixed.

Each bar represents a single monthly payment of the same total amount. The pink region (interest) shrinks over time while the cyan region (principal) grows, illustrating the core behavior of amortization.

This visual makes a critical point: the bank receives most of its interest revenue in the early years. If you make extra payments early in the loan, you save far more money than if you make extra payments near the end. This is because reducing the outstanding balance early means less interest accumulates in every subsequent period — a powerful insight for personal finance.

SECTION 4

Mathematical Framework

The formulas in this section are central to AHL 1.9. They connect the concepts of present value, future value, and annuities into a coherent mathematical framework. You should be comfortable using these on your GDC (graphing display calculator) as well as by hand for short calculations.

PRESENT VALUE OF AN ORDINARY ANNUITY

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

PV = present value (loan amount), PMT = payment per period, i = interest rate per compounding period (as a decimal), n = total number of payment periods.

PAYMENT FORMULA (REARRANGED)

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

This is the annuity formula solved for the periodic payment. It tells you the fixed amount you must pay each period to fully repay the loan in exactly n periods.

OUTSTANDING BALANCE AFTER k PAYMENTS

B_k = PV × (1 + i)ᵏ − PMT × [ ((1 + i)ᵏ − 1) / i ]

$B_k$ = outstanding balance after k payments. This formula lets you find how much you still owe at any point during the loan without constructing the entire amortization table.

EFFECTIVE ANNUAL RATE

r_eff = (1 + r_nom / k)ᵏ − 1

r_eff = effective annual interest rate, r_nom = nominal annual interest rate, k = number of compounding periods per year. When interest compounds monthly, k = 12.

💡

IB EXAM TIP

On your GDC's finance solver (TVM Solver), enter PV as a positive number when you receive money (borrowing) and PMT as a negative number when you pay money out. Mixing up signs is one of the most common errors on HL Paper 1.

SECTION 5

Building an Amortization Schedule

An amortization schedule is a period-by-period table that tracks the interest charged, principal repaid, and remaining balance for every single payment. Constructing one by hand teaches you exactly how each row feeds into the next. Consider a loan of $10,000 at a nominal annual rate of 6% compounded monthly, repaid over 5 months. The monthly rate is i = 0.06 / 12 = 0.005.

Using the payment formula: PMT = 10 000 × [0.005 / (1 − 1.005⁻⁵)] ≈ $2,030.10. The table below shows every row of this short loan.

Period	Payment ($)	Interest ($)	Principal ($)	Balance ($)
0	—	—	—	10,000.00
1	2,030.10	50.00	1,980.10	8,019.90
2	2,030.10	40.10	1,990.00	6,029.90
3	2,030.10	30.15	1,999.95	4,029.95
4	2,030.10	20.15	2,009.95	2,020.00
5	2,030.10	10.10	2,020.00	0.00

Amortization schedule for a $10,000 loan at 6% nominal rate, compounded monthly, over 5 months.

This flowchart shows the three-step process for computing any row of an amortization table. Each row uses the new balance from the previous row as its starting point, creating a recursive structure.

Notice a crucial pattern in the table: the interest column decreases each period while the principal column increases. This happens because the outstanding balance (on which interest is calculated) shrinks after every payment. The total of all interest paid across the five periods is $50.00 + $40.10 + $30.15 + $20.15 + $10.10 = $150.50. So the borrower repays a total of $10,150.50 for a $10,000 loan — the extra $150.50 is the cost of borrowing.

SECTION 6

Worked Example — Home Loan Analysis

Aisha takes out a home loan of $250,000 at a nominal annual interest rate of 4.8% compounded monthly. She will repay the loan with equal monthly payments over 25 years. Find (a) the monthly payment, (b) the outstanding balance after 10 years, and (c) the total interest paid over the life of the loan.

Home Loan — Full Analysis

1
Step 1 — Identify Given Values

PV = $250,000, nominal annual rate r = 4.8%, compounding monthly so k = 12, loan term = 25 years. The periodic interest rate is i = 0.048 / 12 = 0.004. The total number of payments is n = 25 × 12 = 300.

i = 0.004, n = 300
2
Step 2 — Calculate Monthly Payment (Part a)

Substitute into PMT = PV × [ i / (1 − (1 + i)⁻ⁿ) ]. PMT = 250,000 × [ 0.004 / (1 − (1.004)⁻³⁰⁰) ]. First compute (1.004)⁻³⁰⁰. Using a calculator: (1.004)³⁰⁰ ≈ 3.3102, so (1.004)⁻³⁰⁰ ≈ 0.30210. Then 1 − 0.30210 = 0.69790. So PMT = 250,000 × (0.004 / 0.69790) = 250,000 × 0.0057311 ≈ $1,432.78.

Monthly payment ≈ $1,432.78
3
Step 3 — Outstanding Balance After 10 Years (Part b)

After 10 years, k = 120 payments have been made. Use $B_k$ = PV × (1 + i)ᵏ − PMT × [((1 + i)ᵏ − 1) / i]. B₁₂₀ = 250,000 × (1.004)¹²⁰ − 1,432.78 × [((1.004)¹²⁰ − 1) / 0.004]. Compute (1.004)¹²⁰ ≈ 1.61222. Then B₁₂₀ = 250,000 × 1.61222 − 1,432.78 × [(1.61222 − 1) / 0.004] = 403,055 − 1,432.78 × 153.055 = 403,055 − 219,283 ≈ $183,772.

Outstanding balance after 10 years ≈ $183,772
4
Step 4 — Total Interest Paid (Part c)

Total amount repaid = PMT × n = 1,432.78 × 300 = $429,834. Total interest = total repaid − principal borrowed = 429,834 − 250,000 = $179,834. This means Aisha pays almost 72% of the original loan amount in interest alone — a sobering illustration of long-term borrowing costs.

Total interest paid ≈ $179,834

ℹ

REALITY CHECK

After 10 years (40% of the loan term), Aisha has only paid off about 26.5% of the principal ($66,228 of $250,000). This illustrates how front-loaded interest is in long-term amortized loans. Understanding this pattern is essential for making informed decisions about mortgages, car loans, and student debt.

SECTION 7

Comparing Loan Structures

Not all loans work the same way. Understanding the differences between common repayment structures helps you evaluate which option is most suitable for a given scenario — a skill tested regularly in IB HL exam questions.

Feature	Fully Amortizing Loan	Interest-Only Loan	Reducing-Balance Loan
Payment structure	Equal periodic payments throughout the term	Only interest is paid each period; principal repaid as a lump sum at the end	Equal principal portions plus decreasing interest; total payment decreases over time
Total interest paid	Moderate — interest decreases as principal is repaid	Highest — full principal accrues interest for the entire term	Lowest — principal decreases fastest
Cash-flow predictability	High — same amount every period	High for interest payments, but requires a large final payment	Lower — payments change each period
Common use	Mortgages, car loans, student loans	Investment property loans, corporate bonds	Some business loans in certain countries

Comparison of three common loan repayment structures

✦

KEY TAKEAWAY

Choosing a loan structure is like choosing between three ways to eat a pizza. A fully amortizing loan is like eating one equal-sized slice per hour — predictable and steady. An interest-only loan is like nibbling the toppings for hours, then swallowing the entire crust at the end. A reducing-balance loan is like eating big slices at first and smaller ones later. The total pizza is the same, but the experience (and total cost, via interest) differs significantly depending on how you pace your 'bites' of principal repayment.

SECTION 8

Connections to Advanced Financial Theory

The amortization formulas you have learned are a gateway to more advanced financial concepts encountered in university-level economics and actuarial science. The table below highlights how AHL 1.9 ideas extend into more sophisticated territory.

AHL 1.9 Concept	Advanced Extension
Present value of an annuity (fixed payments)	Net Present Value (NPV) analysis for variable cash flows, used in business investment decisions
Fixed nominal interest rate	Variable / floating interest rates that adjust periodically based on market benchmarks (e.g., adjustable-rate mortgages)
Effective annual rate with discrete compounding	Continuous compounding using FV = PV × $e^{rt}$ , connecting financial math to exponential calculus
Single annuity stream	Annuities with growth (geometric series), modeling salary increases contributing to a pension
Outstanding balance after k periods	Bond pricing and yield-to-maturity calculations, where the 'balance' concept becomes the bond's par value

From AHL 1.9 to university-level financial mathematics

If you pursue studies in economics, business, or actuarial science, you will find that the annuity and amortization formulas from this course reappear in almost every advanced topic. Mastering them now gives you a significant head start. Additionally, IB exam questions may ask you to interpret the financial implications of different models — understanding the underlying mathematics makes those interpretations much more confident and precise.

SECTION 9

Practice Problems

Question 1: CONCEPTUAL

Explain why, in a fully amortizing loan with equal monthly payments, the interest component of the payment is largest in the first month and smallest in the last month.

Show answer

Interest each period is calculated as the outstanding balance multiplied by the periodic rate. In the first month, the outstanding balance is at its maximum (the full loan amount), so the interest charge is the largest. Each payment reduces the principal, which lowers the balance. Because subsequent interest calculations use a smaller balance, the interest component shrinks month after month. By the final payment, the balance is very small, so almost the entire payment goes toward eliminating the remaining principal.

Question 2: BASIC CALCULATION

A student borrows $5,000 at a nominal annual rate of 3.6% compounded monthly, to be repaid in equal monthly installments over 2 years. Calculate the monthly payment.

Show answer

First, find i = 0.036 / 12 = 0.003 and n = 24. Apply the payment formula: PMT = 5,000 × [0.003 / (1 − (1.003)⁻²⁴)]. Compute (1.003)²⁴ ≈ 1.07442, so (1.003)⁻²⁴ ≈ 0.93074. Then 1 − 0.93074 = 0.06926. PMT = 5,000 × (0.003 / 0.06926) = 5,000 × 0.043326 ≈ $216.63 per month. The student will make 24 payments of approximately $216.63.

Question 3: INTERMEDIATE

Carlos takes a loan of $80,000 at 5.4% nominal annual rate compounded monthly, repaid over 15 years. Find the outstanding balance after 5 years and determine what fraction of the original loan has been repaid at that point.

Show answer

Here i = 0.054 / 12 = 0.0045, n = 180, and k = 60. First find PMT = 80,000 × [0.0045 / (1 − (1.0045)⁻¹⁸⁰)]. (1.0045)¹⁸⁰ ≈ 2.2420, so (1.0045)⁻¹⁸⁰ ≈ 0.44603. PMT = 80,000 × (0.0045 / 0.55397) = 80,000 × 0.008124 ≈ $649.95. Now find B₆₀ = 80,000 × (1.0045)⁶⁰ − 649.95 × [((1.0045)⁶⁰ − 1) / 0.0045]. (1.0045)⁶⁰ ≈ 1.30876. B₆₀ = 80,000 × 1.30876 − 649.95 × (0.30876 / 0.0045) = 104,701 − 649.95 × 68.613 ≈ 104,701 − 44,594 ≈ $60,107. The fraction repaid is (80,000 − 60,107) / 80,000 ≈ 0.249 or about 24.9%. After one-third of the loan term, only about one-quarter of the principal has been repaid.

Question 4: APPLIED

A bank advertises a car loan at a nominal rate of 7.2% per year compounded monthly. A competing bank offers 7.3% per year compounded quarterly. Which loan has a lower effective annual rate, and by how much?

Show answer

For Bank A (monthly compounding): r_eff = (1 + 0.072/12)¹² − 1 = (1.006)¹² − 1 ≈ 1.07442 − 1 = 0.07442 or 7.442%. For Bank B (quarterly compounding): r_eff = (1 + 0.073/4)⁴ − 1 = (1.01825)⁴ − 1 ≈ 1.07466 − 1 = 0.07466 or 7.466%. Bank A's effective rate (7.442%) is lower than Bank B's (7.466%) by about 0.024 percentage points. Even though Bank A's nominal rate is lower and it compounds more frequently, the combination still results in a lower effective cost. On a $30,000 car loan over 5 years, this difference would save approximately $20–$25 in total interest — small, but the principle of comparing effective rates is essential.

Question 5: CRITICAL THINKING

Priya borrows $200,000 at 6% nominal annual rate compounded monthly over 30 years. After making exactly 12 years of regular payments, she receives an inheritance and makes a one-time extra payment of $30,000 directly toward the principal. She then continues with the same monthly payment. How many fewer months will it take her to pay off the loan compared to the original schedule? (Assume partial final payment is allowed.)

Show answer

First, i = 0.005, n = 360. PMT = 200,000 × [0.005 / (1 − 1.005⁻³⁶⁰)] ≈ $1,199.10. After 144 payments, B₁₄₄ = 200,000 × 1.005¹⁴⁴ − 1,199.10 × [(1.005¹⁴⁴ − 1)/0.005]. (1.005)¹⁴⁴ ≈ 2.0508. B₁₄₄ ≈ 410,160 − 1,199.10 × 210.16 ≈ 410,160 − 251,996 ≈ $158,164. After the extra payment, new balance = 158,164 − 30,000 = $128,164. Now solve for the new number of remaining payments m: 128,164 = 1,199.10 × [(1 − 1.005⁻ᵐ) / 0.005]. Rearranging: 1 − 1.005⁻ᵐ = 128,164 × 0.005 / 1,199.10 = 0.5343. So 1.005⁻ᵐ = 0.4657, giving −m × ln(1.005) = ln(0.4657), so m = −ln(0.4657)/ln(1.005) ≈ 0.7646/0.004988 ≈ 153.3 months. Without the extra payment, she had 360 − 144 = 216 months remaining. With the extra payment, she has about 154 months remaining (rounding up for the partial final payment). She saves approximately 216 − 154 = 62 months, or roughly 5 years and 2 months. The $30,000 extra payment saves her about 62 × $1,199.10 − $30,000 ≈ $44,344 in avoided interest — a powerful demonstration of the value of lump-sum principal reductions.

SUMMARY

Lesson Summary

Summary

In this lesson you explored complex financial models centered on the present value of an ordinary annuity formula PV = PMT × [(1 − (1 + i)⁻ⁿ) / i] and its rearranged form for finding the periodic payment. You learned to construct amortization schedules row by row — computing the interest charge, principal repaid, and new outstanding balance for each period — and saw how the outstanding balance formula $B_k$ = PV(1+i)ᵏ − PMT × [((1+i)ᵏ − 1)/i] lets you jump to any point in the schedule without filling in every row.

Key insights include the fact that interest is front-loaded in fully amortizing loans, the importance of distinguishing nominal and effective interest rates when comparing offers, and the dramatic savings that result from early lump-sum payments. These tools connect directly to real-world decisions about mortgages, car loans, and student debt, and they form the mathematical foundation for more advanced topics like NPV analysis and bond pricing in university-level finance.