Personal Budget Planning Project
OBJECTIVE
The objective of this project is for you to set up a budget that would allow you to live the type of life you would like, as well as to understand what skills and/or education you need to get there. This will include finding a house, finding a car, developing a budget, and finding a career that would match your income needs. This project does involve doing some calculations and setting up a budget on Excel, but it's main purpose is to allow you to have fun dreaming of the future while realizing what these dreams may cost. I also hope you observe certain iron realities about work and what it takes to be a successful adult in the world today. It is not easy. It takes lots of money!
During this project you will need to fill out and then print this worksheet. You will also have a master spreadsheet that will show all your calculations and contain a working budget. Your expenses must fall within your income! Be advised!
During this project you will need to fill out and then print this worksheet. You will also have a master spreadsheet that will show all your calculations and contain a working budget. Your expenses must fall within your income! Be advised!
TASKS
You will need to have a partner to complete this project. Essentially, each of you will be required to set up a monthly budget. You will be required to set up your budget on Excel, and then get your information off the internet, noting the sites that you used. The preparing of the budget will include you finding out what type of careers will provide you with the necessary income, and how much education is needed for such a career. This project consists of two steps:
No matter what job you have you must first deal with your housing. You will need to find a house or apartment that you can afford. You can have roommates, if you need help in covering the monthly rent or mortgage. Next, you must find a car or other type of transportation, and then set up a budget. Then you must fill out the worksheet, print it out, then and discuss it with your teacher.
After completing the preliminary budget, you will exchange your budget with your partner. At this point your partner will review the project, looking for calculation errors and commenting on how realistic the budget is.
To complete the project, you will need to make revisions to your original budget, explaining your reasons for doing so.
Each part of the project is detailed below.
- You will - within limits and with teacher approval - select your own career. No matter what your job might be, you must construct a working budget with costs less than expenses.
- You will construct a budget according to the job that you have discussed and chosen with your teacher.
No matter what job you have you must first deal with your housing. You will need to find a house or apartment that you can afford. You can have roommates, if you need help in covering the monthly rent or mortgage. Next, you must find a car or other type of transportation, and then set up a budget. Then you must fill out the worksheet, print it out, then and discuss it with your teacher.
After completing the preliminary budget, you will exchange your budget with your partner. At this point your partner will review the project, looking for calculation errors and commenting on how realistic the budget is.
To complete the project, you will need to make revisions to your original budget, explaining your reasons for doing so.
Each part of the project is detailed below.
FINDING A CAREER
Now it's time to find a career. Using this link to the U.S. Government's Occupational Outlook Handbook, find a career that you are interested in and that will give you the needed income to afford the lifestyle you want. Include the amount of education needed for your career. Use the website above to get your median yearly income.
As soon as you have found a career, come and talk to Mrs. Denning to approve your career choice. You will need to have your project worksheet filled in for her to check. Then find out your net earnings, after taking out federal income tax and state income tax. Your social security tax will be 6.2% of your gross income is you are employed by someone else, 12.4% if you are self-employed.
Enter all this into your budget spreadsheet. You will then have your net yearly income. Use the budget sheet that we set up for the activity Janna's Budget. You will need to add the remaining months to make a budget for a full year. You will need to make a copy of this by saving as a new file. Do not copy over the existing file!!!
NOTE: Be sure that you have copied the necessary information into your project worksheet and your budget spreadsheet.
***You may not choose to be an actress, actor, singer, entertainer or major league sports figure.***
As soon as you have found a career, come and talk to Mrs. Denning to approve your career choice. You will need to have your project worksheet filled in for her to check. Then find out your net earnings, after taking out federal income tax and state income tax. Your social security tax will be 6.2% of your gross income is you are employed by someone else, 12.4% if you are self-employed.
Enter all this into your budget spreadsheet. You will then have your net yearly income. Use the budget sheet that we set up for the activity Janna's Budget. You will need to add the remaining months to make a budget for a full year. You will need to make a copy of this by saving as a new file. Do not copy over the existing file!!!
NOTE: Be sure that you have copied the necessary information into your project worksheet and your budget spreadsheet.
***You may not choose to be an actress, actor, singer, entertainer or major league sports figure.***
FINDING A HOUSE
After you have a career and an income, you need to try and get a house to live in. Almost everyone has an idea of where they would like to live, and what type of house they would like to own. It's your job to search for your dream house. After you do so, make sure to note where the house is located, and what the selling price is. Also make sure to note the URL that you used.
Here are some rsources to help you in your search:
When you find the house you want, come talk to Mrs. Denning and get approval for a loan from the bank.
If you cannot afford to buy a house, search for an apartment here.
NOTE: Be sure that you have copied the necessary information into your project worksheet and your budget spreadsheet.
Here are some rsources to help you in your search:
When you find the house you want, come talk to Mrs. Denning and get approval for a loan from the bank.
If you cannot afford to buy a house, search for an apartment here.
NOTE: Be sure that you have copied the necessary information into your project worksheet and your budget spreadsheet.
FINDING A CAR
Most people also have ideas on what type of car they would like to own. Use the links below to find your dream car. Make sure to note the price of the car. Also make sure to note the URL that you used.
NOTE: Be sure that you have copied the necessary information into your project worksheet and your budget spreadsheet.
NOTE: Be sure that you have copied the necessary information into your project worksheet and your budget spreadsheet.
SETTING UP YOUR BUDGET
The next step is to set up your budget. This will entail the following steps:
- Figure out your monthly mortgage payment and your monthly car payment. Assume that you only have a 5% down payment for your mortgage. Mortgage Calculator
- Some budget experts recommend that a house payment should be no more than 28% of your gross monthly income, and that a car payment should be no more than 12% of your gross monthly income. Decide if your net income will make it possible for you to afford your house and car. If not, go and find a car and house that you can afford. Car Payment Calculator
- Examine your spreadsheet to see how much money you should budget for the remainder of your household expenses. Make sure to double check your calculations. Then enter those household expenses into your spreadsheet. NOTE: Look at your project worksheet to help you with your budget categories and amounts.
REVIEWING THE BUDGET
Time for a reality check. At this point, change worksheets with your partner. Once you have your partner's worksheet, you need to do two things:
- double check the calculations (example 1, example 2), and
- check with Mrs. Denning to see how realistic the budget is.
COMPLETING THE PROJECT
To complete the project, make any changes to your budget THAT YOU CONSIDER NECESSARY (not necessarily the changes your partner recommended). Write a summary of the changes you made, and why you made them.
Make sure you heed Mrs. Denning's comments!
The completed project should contain the following:
Use the dropbox on the class website too turn all information in at one time.
The final step of this project, is to create seven slides using some type of presentation software about your budget and lifestyle. Your presentation should have the following:
After I receive and view all your work, Mrs. Denning will evaluate it according to this rubric.
Make sure you heed Mrs. Denning's comments!
The completed project should contain the following:
- Spreadsheet submitted electronically
- Project Worksheet submitted electronically
- Recommendations that you made to your partner, submitted electronically
- Summary of the changes you made submitted electronically
Use the dropbox on the class website too turn all information in at one time.
The final step of this project, is to create seven slides using some type of presentation software about your budget and lifestyle. Your presentation should have the following:
- Title Slide
- An opening slide which includes your name and the basics of your career, education, and family (life)
- a slide that shows the yearly income you earn and the various taxes you pay (income and taxes)
- a slide that shows the chosen vehicle and specific information about your automobile (color, year, maker, radio, airbags, financing, etc.) (vehicle info.)
- a slide that has the information about your car (monthly payment)
- a slide that shows all the details about house, where it is located, other miscellaneous information, etc (house info.)
- a slide that shows your house/apartment and where you obtained your mortgage, what interest you pay, number of months of loan, etc. (house payment)
- Your monthly budget, including all expenses balanced against your net pay (monthly budget)
- A graph, created in Excel and exported to PowerPoint, that helps explain outflows vs. inflows, with the money left over (graph)
- and lastly, a slide that explains what you learned in this project (learned)
After I receive and view all your work, Mrs. Denning will evaluate it according to this rubric.