Grades 9–12 · Financial Literacy
How do you teach debt payoff strategies in Grades 9–12?
Short answer: Build a transparent monthly model with two debts. Each month, students apply interest first, pay every minimum, then send the rest of a fixed budget to one target debt: the smallest balance or the highest rate. They compare balances after each month and write spreadsheet rules for capping a payment and rolling freed money to the other debt.
- Grades9–12
- Time4 × 90-minute double lessons
- Methods comparedSmallest balance first and highest rate first
- ToolsPaper or any spreadsheet program
Debt payoff advice is full of named methods, and students hear them long before they understand what the methods do. The honest way to teach them is to run both on the same numbers and look at the result month by month. Once students can see where every dollar goes, they can judge the methods themselves.
Debt Payoff Spreadsheet Lab does that with two small fictional debts and a fixed monthly budget. It works on paper, but it is written so that each step becomes a spreadsheet rule, which makes it a strong bridge between personal finance and spreadsheet skills.
Units for this topic
Debt Payoff Spreadsheet Lab
The lead unit: students compare payoff orders with a transparent monthly spreadsheet model.
Compare Credit Card Offers
Card offers introduce APR and fees before students model interest monthly.
Student Loan Repayment Scenarios
Student loan schedules extend the monthly-versus-total-cost trade-off.
Budget on Irregular Income
Budgeting on irregular income shows how a fixed payoff budget can be protected.
Compound Growth Fee Lab
Compound growth with a fee uses the same multiplier thinking for savings.
The order of operations matters
Every month in the model follows the same order. Interest is added first. Each debt then receives its minimum payment. Whatever remains of the budget goes to the target debt. If a payment would be larger than what is owed, it is capped at the balance and the extra rolls to the other debt.
Writing this order on the board before any calculation saves a lot of confusion. Most errors in the unit come from paying before adding interest or from forgetting the cap.
It also helps to name the two methods by what they do rather than by any popular label. Smallest balance first and highest rate first describe the rule, so students can apply them to any set of debts without remembering which nickname goes with which approach.
Month 1 with both methods
The starting case has Debt A at $200 with modeled interest of 1% a month and a $20 minimum, and Debt B at $400 with 2% a month and a $30 minimum. The budget is $100 each month.
After interest, A is $202 and B is $408. Using smallest balance first, A is the target: B gets its $30 minimum and A gets the remaining $70, leaving A at $132 and B at $378. Using highest rate first, B is the target: A gets its $20 minimum and B gets $80, leaving A at $182 and B at $328.
Students now have two different month-end positions from the same budget. The question for discussion is what each method is optimizing. One clears an account sooner; the other cuts the balance with the higher rate. Month 2, rounded to cents, lets students see how that difference grows.
Caps, rollovers and the last payment
Real payoff plans hit a moment where one debt is almost gone. The later cases in the unit are built around that moment. In one, Debt C is down to $5 after interest and D is $65, with a $70 budget, so students must apply the payment cap. In the transfer challenge, interest is zero, A has $35 left, B has $100 and requires $10, and the budget is $40. The most that can go to A is $30.
These cases are where spreadsheet rules earn their place. Students write a rule that pays the smaller of the planned amount and the balance, and another that sends any leftover to the other debt.
- Payment to a debt equals the smaller of the planned payment and the balance after interest
- Leftover budget rolls to the other debt in the same month
- A debt at zero receives no further payments
Connecting payoff to borrowing decisions
The payoff lab works best after students have compared borrowing options. Compare Credit Card Offers uses a simplified yearly model; this unit shows what happens when interest is applied month by month. Student loan schedules then show the same trade-off between monthly payment and total cost in a longer setting.
A five-step sequence
-
Set up the table
Create columns for month, debt, starting balance, interest, balance after interest, payment and ending balance.
-
Apply interest first
Multiply each balance by its monthly rate and add the result before any payment.
-
Pay all minimums
Give each debt its minimum, capped at its balance, and subtract the total from the budget.
-
Send the rest to the target
Choose the target by method, smallest balance or highest rate, and apply the remaining budget with the cap.
-
Compare and explain
After each month, compare total remaining balance and explain which method led and why.
Common mix-ups and what to try
Payments come off the balance before interest.
In this model, interest is applied first each month, so the payment reduces the balance after interest.
You can pay a debt more than it owes and the extra still counts.
Payments are capped at the balance. The extra rolls to the other debt.
One payoff method is always right.
Students compare both on the same numbers and explain what each method optimizes.
More Financial Literacy units
Related teaching guides
Frequently asked questions
Do students need spreadsheet software?
No, but it helps. The worksheets can be done on paper, and the core task asks for spreadsheet rules that students can test if software is available.
Are the interest rates realistic?
They are modeled monthly rates chosen to keep the arithmetic manageable. Students name this as a limit of the model.
How many months does the model run?
The starting case is worked for month 1 with both methods and month 2 with highest rate first. Students who use a spreadsheet can extend the same rules until both debts reach zero.
How is the unit assessed?
The learning check gives balances after interest, a planned payment and a total budget, and asks which payments are possible. It checks the cap and rollover rules directly.
What if the unit does not match my standards?
Every resource is built around the curriculum you teach – and if something doesn't fit your standards, the TeachLessons Guarantee applies: we adapt it for you.
Is this unit appropriate for students with family debt?
The debts are fictional and small, and no student is asked about their own situation, which keeps the lesson focused on the method.
Ready for your next lesson?
Run month 1 both ways on the board and let students argue about which result is better.
View Debt Payoff Spreadsheet LabInstant digital download. Every resource is built around the curriculum you teach – and if something doesn't fit your standards, the TeachLessons Guarantee applies: we adapt it for you.

