Budgeting For The Future
- Mathematics
- Technology
- Senior

- Activity Time
- Materials
- Concepts / Topics
Learners research salary and living expenses, build a spreadsheet budget, and analyze whether their planned lifestyle is affordable.
The Task
You have just graduated from college, moved to the city of your dreams, and been hired for the job you have been preparing for since high school!
Your task is to:
- Develop a monthly budget that will help you manage your repayment obligations and establish a sound credit history.
- Design a personal budget spreadsheet that includes your gross yearly income, gross monthly income, the amount of taxes you will pay, and your net monthly income. It should calculate your total monthly expenses and the amount of discretionary income—fun money—you will have left at the end of each month.
- Evaluate your completed budget to decide if you can afford your style of living. Answer some “what if” questions that will help you make decisions about your future career choice and how you plan to spend your money.
Research and Build Your Budget
First, find out the gross (before taxes) yearly salary you will receive in your dream job. Then determine your net (after taxes) monthly income.
Next, do some additional research to determine your basic living expenses. Once you have collected this information, create a budget using Microsoft Excel and enter the data you have collected.
Analyze Your Budget
After entering the data into the spreadsheet, analyze the results and determine whether changes are needed. Will you be able to make all of your payments, or will you need to increase income or decrease expenses to make ends meet?
You may contact me at Independece High School for the complete lesson plan.
Teachers.Net · https://teachers.net/lessons/745.html