|
Assignment 5
Monthly Budget
-
Open your MS Excel Header Format file
-
Save to filename: monthly_budget_lastname
- Type the budget categories listed below. All numbers will come from the other Independent Living Unit assignments.
| Monthly Budget |
|
|
|
|
|
|
|
|
|
| INCOME |
|
|
|
|
| Employment |
|
|
Highlighted fields will contain formulas |
| Job: Cost Accounting Manager |
|
|
|
|
Gross Pay
|
|
|
|
|
| Taxes |
20% |
|
|
|
| Check Amount |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
| EXPENSE |
|
|
|
|
| Fixed Expense |
|
|
|
|
Car Payment
|
|
|
|
|
Rent #br, #bath, # sq ft
|
|
|
|
|
Utilities-water,electricity,etc.
|
|
|
|
|
Telephone
|
|
|
|
|
| Total Fixed Expense |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
| Flexible Expense |
|
|
|
|
Food
|
|
|
|
|
Entertainment
|
|
|
|
|
| Total Flexible Expense |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
| Money to spend |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
