How do you spend your money?
Go to the following website: The Mint (http://www.themint.org/teachers/budgeting.php)
·
Click
on the links for the sample budget, read, and review.
·
Click
on the link for starting salaries and decide which job categories best matches
your interests.
·
Click
on the link for making a budget. Follow
the steps indicated. Print out your
final result.
Create an Excel spreadsheet listing your income (revenues) and your expenses. Use formulas and have the spreadsheet calculate whether you have a net income or net loss. Show the spreadsheet to your teacher before going on to the next step.
Create a pie chart showing the percentage of your income that is spent for each expense.
Print the spreadsheet twice (with and without formulas) and the chart.
EXAMPLES
My Personal
Budget
|
||||
|
|
|
|
|
|
|
Revenues: |
|
|
|
|
|
Gross Monthly Salary |
|
|
|
|
|
Less: |
|
|
|
|
|
Taxes (per month) |
|
|
|
|
|
Net Monthly Salary |
(use a formula) |
|
|
|
|
|
|
|
|
|
|
Expenses (per month): |
|
|
|
|
|
Apartment |
|
|
|
|
|
Transportation |
|
|
|
|
|
Food |
|
|
|
|
|
Clothing |
|
|
|
|
|
Savings |
|
|
|
|
|
Entertainment |
|
|
|
|
|
Total Expenses |
(use a formula) |
|
|
|
|
|
|
|
|
|
|
Net Income (Loss) |
HINT:(B7-B16) |
|
|
|
