Alabama Math MM.FPM.A.6
The Standard
- MM.FPM.A
- Mathematical models involving growth and decay are useful in solving real-world problems involving borrowing and investing; spreadsheets are a frequently-used and powerful tool to assist with modeling financial situations.
Investigate growth and reduction of credit card debt using spreadsheets, including variables such as beginning balance, payment structures, credits, interest rates, new purchases, finance charges, and fees.
2019 Alabama Course of Study: Mathematics
Teacher's field guide
What This Standard Means
What Students Need to Do
- Students build a month-by-month spreadsheet that tracks purchases, credits, interest, fees, payments, and the balance left. They change the interest rate or payment amount to see when debt grows or gets paid off.
What Mastery Looks Like
- Students use formulas to carry each ending balance into the next month and convert an annual interest rate to a monthly rate. They can compare two payment plans and explain which costs more in interest.
Common Misconceptions
- Students may use the annual rate as the monthly rate or subtract a purchase instead of adding it. They may also assume a payment always lowers the balance, even when purchases, interest, and fees exceed it.
How to Assess It
- Exit ticket: Enter a $500 starting balance, 24% annual interest, $30 purchase, $10 fee, $20 credit, and $50 payment in a spreadsheet. Charge one month's interest on the starting balance, then report the interest and ending balance.
Lesson moves
Ways to Teach It
Build a 12-month spreadsheet for $600 debt at 24% annual interest, tracking purchases, credits, fees, interest, and ending balance; compare $40 and $80 payments.
Ask: On a $600 balance at 24% annual interest, why does a $40 payment fail to reduce debt after $60 in new purchases?
Give pairs four spreadsheet rows with one missing entry each; have them race to calculate the missing purchase, credit, interest charge, or payment.
Use a mock credit card statement with a $25 late fee; enter the fee in a payoff spreadsheet and compare total repayment.
Free download
Printable MM.FPM.A.6 Worksheet

A ready-to-print activity worksheet aligned to MM.FPM.A.6, with an answer key for the teacher on its own page. No account needed.
PDF, US Letter, prints cleanly in black and white.
Download the worksheetKeep exploring
Related Standards
- MM.FPM.A
Mathematical models involving growth and decay are useful in solving real-world problems involving borrowing and investing; spreadsheets are a frequently-used a...
- MM.FPM.A.4
Organize and display financial information using geometric sequences to represent compound interest and proportional depreciation, including periodic (yearly, m...
- MM.FPM.A.2
Use elements of the Mathematical Modeling Cycle to solve real-world problems involving finances.
- MM.FPM.A.7.b
Compare monthly mortgage payments for different terms, interest rates, and down payments.
Turn this exact standard into a lesson
Grade, subject, topic, and the complete standard are prefilled. Create one free, no account needed.
Also for this standard:Make a WorksheetMake a QuizMake a Sub Lesson