📝 My First Budget — Interactive Budgeting Simulation (Excel)

Make personal finance click for your students with this hands-on, real-world budgeting project!

Students step into the shoes of a 22-year-old college graduate starting their first job as a Marketing Associate earning $42,000/year. They'll calculate their take-home pay, build a monthly budget from scratch, face a surprise financial emergency, and reflect on what it all means — all inside one interactive Excel workbook.

🔢 What's Included (7 Tabs in One Excel Workbook)

1. Instructions — Full teacher guide with learning objectives, pacing suggestions, common student mistakes to watch for, and a clear explanation of the 50/30/20 budgeting rule
2. Your Life Scenario — A realistic life profile: job details, student loans, credit card debt, housing options, and transportation choices that drive every budget decision
3. Paycheck Calculator — Step-by-step walkthrough from gross salary → deductions (federal/state tax, Social Security, Medicare, health insurance, 401k) → monthly take-home pay
4. Monthly Budget — The core worksheet! Students allocate spending across Needs, Wants, and Savings/Debt categories. Yellow cells = student input, gray cells = auto-calculated formulas. Includes a built-in 50/30/20 comparison tracker
5. Emergency Challenge — Three curveballs hit at once: a $1,350 car repair, reduced work hours, and a roommate moving out. Students must problem-solve and revise their budget under pressure
6. Budget Reflection — 7 assessment questions (including a bonus question) covering emergency funds, credit card interest, 401(k) employer matching, and loan payoff strategies
7. Answer Guide — Complete sample budget with worked-out paycheck calculations, teacher notes for every reflection question, and key discussion points (hide before distributing!)

✅ Learning Objectives

• Calculate monthly take-home pay from an annual salary after taxes and deductions
• Categorize expenses into needs, wants, and savings/debt payments
• Apply and evaluate the 50/30/20 budgeting guideline
• Make tradeoff decisions when expenses exceed income
• Build and defend an emergency fund strategy
• Respond to unexpected expenses and adjust a budget accordingly

💡 Why Students Love It

• "Choose your own adventure" format — Students pick their housing, transportation, and spending, so no two budgets are the same
• Realistic scenario — Real tax rates, real rent ranges, real student loan numbers — not made-up textbook figures
• Built-in drama — The Emergency Challenge tab is a game-changer for class discussion (their emergency fund barely covers the car repair — every time!)

🍎 Why Teachers Love It

• No prep needed — Just distribute the Excel file and go
• Auto-calculating formulas — Gray cells do the math so you can focus on the learning, not troubleshooting spreadsheets
• Complete answer key — Sample budget, paycheck calculations, and reflection answer notes included
• Flexible pacing — Works in 2–3 block periods or 3–4 standard periods
• Pairs discussion built in — Students naturally compare budgets and debate choices

📚 Perfect For

• Personal Finance
• Business / Intro to Business
• Accounting
• FACS / Life Skills
• Math (real-world applications)
• Grades 9–12

📋 Format

• Microsoft Excel workbook (.xlsx)
• Works in Excel desktop, Excel Online, and Google Sheets (with minor formatting differences)
• No macros, no add-ins — just formulas and formatting

⭐ Tip: After distributing, have students share their budgets on the board. The class comparison is where the deepest learning happens!