✓ Added to cart


Debt Payoff Spreadsheet Lab | Financial Literacy Unit | Grades 9–12
Digital download · nothing is shipped
- Instant download: the download link appears right after checkout and is also emailed to you.
- Format: PDF + slides, ready to print or project.
- TeachLessons Guarantee: if it does not fit your standards or pacing, email us within 30 days of purchase and we adapt it at no extra cost. How the guarantee works
Debt Payoff Spreadsheet Lab | Financial Literacy Unit | Grades 9–12
The Debt Payoff Spreadsheet Lab has grades 9–12 students build a month-by-month model for paying off two debts with a fixed budget. They compare smallest-balance-first with highest-rate-first and write spreadsheet rules that cap payments and roll freed money into the next debt.
What students work on
- Debt A at $200 with 1% monthly interest and a $20 minimum, Debt B at $400 with 2% and a $30 minimum, and $100 a month to pay.
- Month 2 using the highest-rate-first order, with interest rounded to the cent.
- Debts C and D at $100 and $240 after interest, with $15 and $20 minimums and a $70 budget.
- A round where C is down to $5 and D to $65, so the payment cap matters.
- A zero-interest round with $35 and $100 balances, a $40 budget and a $10 minimum on B, where students find the most they can put toward A.
Lesson sequence (4 × 90 minutes)
- From first reading to a model. Students lay out month 1 for both payoff orders and write the first spreadsheet rules.
- A revised case and a new context. Month 2 and a new pair of debts test whether the rules work beyond the first example.
- Testing evidence and transferring a method. Students handle a nearly paid-off balance and a minimum-payment constraint, checking that no payment exceeds what is owed.
- Learning check and feedback. The learning check gives balances of $12 and $180 with a $100 budget, followed by scored feedback and revision.
What's included
- Teaching Unit PDF – 42 pages: four 90-minute double lessons, an entry diagnosis, differentiation notes, teacher background, five learner inputs with mini-checks, five ready-to-copy worksheets with answer keys, support and extension cards, a 20-point independent learning check with model responses and a 100-point scoring sheet, plus peer review and revision pages
- 16 classroom slides (PPTX) with teacher notes
- Answer keys and model responses for every worksheet and the learning check
- Support and extension cards for differentiation
- A4 format that prints on US Letter with "fit to page"
- Digital download – no physical item is shipped
Who it's for
- US grades 9–12
- UK Years 10–13
- Australia Years 9–12
- Personal finance, economics and consumer math classes
- Homeschool families teaching money skills
- Advisory or life-skills blocks where students need practical money practice
Before you start
Students should calculate a percentage of a balance and work in rows over time. Basic spreadsheet use (entering a formula, filling down) helps, although the tasks can also be done on paper.
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.
Created with AI assistance. Texts and illustrations were developed with ChatGPT (OpenAI) and Claude (Anthropic) and edited for classroom use.
Frequently Asked Questions
Which grades is Debt Payoff Spreadsheet Lab for?
It is written for US grades 9–12, which matches UK Years 10–13 and Australian Years 9–12. Support and extension cards let you adjust the level within that range.
What's included and how long does it take?
You get a 42-page Teaching Unit PDF and 16 classroom slides with teacher notes. The plan covers four 90-minute double lessons, about six hours of class time, and splits easily into eight shorter periods.
Do students need computers?
Not necessarily. The worksheets work on paper, but the unit is designed so students can rebuild the model in any spreadsheet program if devices are available.
$24.99 – buy now
PDF · instant download
🔒 Secure checkout · ♾️ reuse every yearFAQ about this resource
More Financial Literacy resources for High School
Our summary: Debt Payoff Spreadsheet Lab | Financial Literacy Unit | Grades 9–12
Debt Payoff Spreadsheet Lab | Financial Literacy Unit | Grades 9–12 is a fully worked-out teaching resource for Financial Literacy at High School level (Grades 9–12). Its strength is that it is finished: worksheets, answer keys and teacher notes are all there, so a lesson can start without extra prep.
Teachers covering a topic at short notice, early-career teachers under planning pressure, and anyone picking up a cover lesson — and any situation where a lesson has to be ready today.
An editorial assessment of structure, scope and classroom use. It is not a customer review.

