Minutes 0–10: define the four numbers
Start with principal, annual interest rate, payment frequency, and term. Ask students to predict which changes will raise or lower the payment before doing any math. Keep taxes, insurance, and fees out of the first example so the loan mechanics are clear.
Minutes 10–25: calculate one payment
Use a fixed-payment formula with a manageable example such as $20,000 at 8% for five years. The monthly payment is about $405.53. Have students identify the periodic rate (8% ÷ 12) and the number of payments (5 × 12 = 60).
Minutes 25–40: build the first three rows
For each row, calculate interest from the starting balance, subtract interest from the payment to find principal, and subtract principal from the balance. Students quickly see why interest starts high and principal starts low.
Ask what happens to the next row if an extra $500 of principal is inserted after payment three.
Minutes 40–50: compare one change
Use a calculator to compare the original schedule with an extra-payment scenario, or compare a 15-year and 30-year term. Focus on two outputs: monthly cash flow and total interest. This shows why the “lowest monthly payment” is not the same as the “lowest total cost.”
Minutes 50–60: discussion and audit questions
- Why is the first payment mostly interest?
- Why does principal reduction accelerate?
- What does an extra principal payment change?
- Why might a real lender schedule differ by a few cents?
- What information would you need before comparing two loan offers?
End by having students explain the schedule in words rather than simply reading numbers from a table.
Extension activity: ask students to diagnose a bad schedule
After students understand the basic rows, give them a deliberately incorrect schedule. Change one assumption—such as using 24 payments per year for a biweekly loan, applying the annual rate directly each month, or failing to subtract an extra principal payment. Ask students to identify where the first incorrect row appears.
This turns amortization from a formula exercise into a reasoning exercise. Students have to explain why each input matters and how one mistake propagates through every later balance. It also mirrors the way real loan schedules are audited.
A second extension is to have students write a short recommendation comparing two loan terms. Require them to cite the payment, total interest, and balance after a chosen number of years. The goal is not to declare one loan universally “better,” but to connect the math with cash-flow tradeoffs and the borrower’s expected time horizon.
Build the numbers instead of estimating them
Use the free online schedule calculator for a complete amortization table. If you need to edit individual payment dates, amounts, rates, or notes and save the revised loan, use Amortization Pro for Windows.