Computer Science Lab: Excel Budget and What-if Analysis Assignment
Mike_JA
LabExcelBudgetandWhat-ifStarterTemplate.xlsxStarter File
| First Name Last Name Budget | |||||
| Date | |||||
| Revenue (takehome) | Raise | ||||
| Source 1 | |||||
| Source 2 | |||||
| Source 3 | |||||
| Total Revenue | $ - 0 | ï | =SUM(D4:D7) | ||
| Expenses | Live | ||||
| Rent/Mortgage | |||||
| Electricity | |||||
| Personal Entertainment | |||||
| Cable/Internet | |||||
| Water | |||||
| Household Allowance (Food & Such) | |||||
| Insurance | |||||
| Gas (Auto) | |||||
| Employment Expenses | |||||
| Give | Goal | ||||
| Tithing | 10% | ||||
| Charity | 5% | ||||
| Grow | Goal | ||||
| Retirement | |||||
| Emergency Fund | |||||
| Life Insurance | |||||
| Savings | |||||
| Owe Taxes | |||||
| Taxes | n/a | ||||
| Owe Debt | Payoff | ||||
| Student Loans | |||||
| Car Payment | |||||
| Credit Card Payment | |||||
| Total Expenses | $ - 0 | ï | =SUM(D11:D35) | ||
| Net Income/Loss | $ - 0 | ï | =D8-D37 | ||
