Exp19_Excel_Ch09_ML1_Expenses_
hollywood479
Amy_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 |
