Teachers.Net
JoinLog in
Teachers.Net

Budgeting For The Future

By Rhonda Sheets

  • Mathematics
  • Technology
  • Senior
Activity Time
3 - 5 days
Materials
Access to the Internet and a spreadsheet program.
Concepts / Topics
Using a spreadsheet and the Internet to figure out a budget for the future.

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:

  1. Develop a monthly budget that will help you manage your repayment obligations and establish a sound credit history.
  2. 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.
  3. 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