{"product_id":"debt-payoff-spreadsheet-lab-grades-9-12","title":"Debt Payoff Spreadsheet Lab | Financial Literacy Unit | Grades 9–12","description":"\u003cp\u003eThe \u003cstrong\u003eDebt Payoff Spreadsheet Lab\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003ch2\u003eWhat students work on\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eDebt 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.\u003c\/li\u003e\n\u003cli\u003eMonth 2 using the highest-rate-first order, with interest rounded to the cent.\u003c\/li\u003e\n\u003cli\u003eDebts C and D at $100 and $240 after interest, with $15 and $20 minimums and a $70 budget.\u003c\/li\u003e\n\u003cli\u003eA round where C is down to $5 and D to $65, so the payment cap matters.\u003c\/li\u003e\n\u003cli\u003eA 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.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch2\u003eLesson sequence (4 × 90 minutes)\u003c\/h2\u003e\u003col\u003e\n\u003cli\u003e\n\u003cstrong\u003eFrom first reading to a model.\u003c\/strong\u003e Students lay out month 1 for both payoff orders and write the first spreadsheet rules.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eA revised case and a new context.\u003c\/strong\u003e Month 2 and a new pair of debts test whether the rules work beyond the first example.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTesting evidence and transferring a method.\u003c\/strong\u003e Students handle a nearly paid-off balance and a minimum-payment constraint, checking that no payment exceeds what is owed.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eLearning check and feedback.\u003c\/strong\u003e The learning check gives balances of $12 and $180 with a $100 budget, followed by scored feedback and revision.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003ch2\u003eWhat's included\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTeaching 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\u003c\/li\u003e\n\u003cli\u003e16 classroom slides (PPTX) with teacher notes\u003c\/li\u003e\n\u003cli\u003eAnswer keys and model responses for every worksheet and the learning check\u003c\/li\u003e\n\u003cli\u003eSupport and extension cards for differentiation\u003c\/li\u003e\n\u003cli\u003eA4 format that prints on US Letter with \"fit to page\"\u003c\/li\u003e\n\u003cli\u003eDigital download – no physical item is shipped\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch2\u003eWho it's for\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eUS grades 9–12\u003c\/li\u003e\n\u003cli\u003eUK Years 10–13\u003c\/li\u003e\n\u003cli\u003eAustralia Years 9–12\u003c\/li\u003e\n\u003cli\u003ePersonal finance, economics and consumer math classes\u003c\/li\u003e\n\u003cli\u003eHomeschool families teaching money skills\u003c\/li\u003e\n\u003cli\u003eAdvisory or life-skills blocks where students need practical money practice\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch2\u003eBefore you start\u003c\/h2\u003e\u003cp\u003eStudents 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.\u003c\/p\u003e\n\u003cp\u003eEvery resource is built around the curriculum you teach – and if something doesn't fit your standards, the \u003ca href=\"\/pages\/teachlessons-guarantee\"\u003eTeachLessons Guarantee\u003c\/a\u003e applies: we adapt it for you.\u003c\/p\u003e\n\u003cp\u003e\u003cem\u003eCreated with AI assistance. Texts and illustrations were developed with ChatGPT (OpenAI) and Claude (Anthropic) and edited for classroom use.\u003c\/em\u003e\u003c\/p\u003e\n\u003ch2\u003eFrequently Asked Questions\u003c\/h2\u003e\u003cp\u003e\u003cstrong\u003eWhich grades is Debt Payoff Spreadsheet Lab for?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eIt 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat's included and how long does it take?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eYou 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eDo students need computers?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eNot 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.\u003c\/p\u003e\n\u003cscript type=\"application\/ld+json\"\u003e{\"@context\": \"https:\/\/schema.org\", \"@type\": \"FAQPage\", \"mainEntity\": [{\"@type\": \"Question\", \"name\": \"Which grades is Debt Payoff Spreadsheet Lab for?\", \"acceptedAnswer\": {\"@type\": \"Answer\", \"text\": \"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.\"}}, {\"@type\": \"Question\", \"name\": \"What's included and how long does it take?\", \"acceptedAnswer\": {\"@type\": \"Answer\", \"text\": \"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.\"}}, {\"@type\": \"Question\", \"name\": \"Do students need computers?\", \"acceptedAnswer\": {\"@type\": \"Answer\", \"text\": \"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.\"}}]}\u003c\/script\u003e","brand":"Teach Lessons","offers":[{"title":"Default Title","offer_id":59157559345496,"sku":"TL-U140-007","price":24.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0882\/5667\/6184\/files\/007-debt-payoff-spreadsheet-lab-01-thumbnail-a4.jpg?v=1794901270","url":"https:\/\/teachlessons.us\/products\/debt-payoff-spreadsheet-lab-grades-9-12","provider":"Teach Lessons","version":"1.0","type":"link"}