Exp19_Excel_Ch09_ML1_Expenses
gijack25
Exp19_Excel_Ch09_ML1_Expenses.xlsxApril
| Savings | ||
| Beginning Savings Balance | $ 300.00 | |
| Monthly Savings Added | 100.00 | |
| Ending Savings Balance | ||
| Income | ||
| Salary | $ 2,400.00 | |
| Expenses | ||
| Rent | $ 1,100.00 | |
| Utilities | 127.15 | |
| Savings | 100.00 | |
| Cell Phone | 55.22 | |
| Groceries | 389.75 | |
| Car Payment | 275.00 | |
| Auto Expense | 84.93 | |
| Entertainment | 54.75 | |
| Miscellaneous | 100.00 | |
| Total Expenses | 2,286.80 | |
| Difference | $ 113.20 |
May
| Savings | ||
| Beginning Savings Balance | ||
| Monthly Savings Added | 100.00 | |
| Ending Savings Balance | ||
| Income | ||
| Salary | 2400 | |
| Expenses | ||
| Rent | 1100 | |
| Utilities | 115.64 | |
| Savings | 100 | |
| Cell Phone | 55.22 | |
| Groceries | 384.18 | |
| Car Payment | 275 | |
| Auto Expense | 71.64 | |
| Entertainment | 45.31 | |
| Miscellaneous | 95 | |
| Total Expenses | 2241.99 | |
| Difference | 158.01 |
June
| Savings | ||
| Beginning Savings Balance | ||
| Monthly Savings Added | 100.00 | |
| Ending Savings Balance | ||
| Income | ||
| Salary | 2400 | |
| Expenses | ||
| Rent | 1100 | |
| Utilities | 131.18 | |
| Savings | 100 | |
| Cell Phone | 55.22 | |
| Groceries | 395.31 | |
| Car Payment | 275 | |
| Auto Expense | 104.35 | |
| Entertainment | 45.18 | |
| Miscellaneous | 455 | |
| Total Expenses | 2661.24 | |
| Difference | -261.24 |
Qtr 2
| 2nd Quarter Totals | Monthly Data | ||||
| April | |||||
| Savings | May | ||||
| Ending Savings Balance | June | ||||
| Analysis | |||||
| Month with highest positive difference in cell C23 | |||||
| Income | Month with highest negative difference in cell C23 | ||||
| Salary | Difference after three months in cell C23 in Qtr 2 | ||||
| 1st highest total expense category in Qtr 2 | |||||
| Expenses | 2nd highest total expense category in Qtr 2 | ||||
| Rent | Number of expense categories identical each month | ||||
| Utilities | |||||
| Savings | |||||
| Cell Phone | |||||
| Groceries | |||||
| Car Payment | |||||
| Auto Expense | |||||
| Entertainment | |||||
| Miscellaneous | |||||
| Total Expenses | |||||
| Difference |
