CashFlowPart1.xlsx
Sheet1
| Cash Flow Statement |
| | | Monthly | Outflows | Inflows | Totals |
| INFLOWS |
| Gross salaries | $ | | | 122,500 |
| Dividend income | | | | 800 |
| Interest income | | | | 50 |
| Other Income | | | | 0 |
| TOTAL INFLOWS | $ | | | 123,350 | 123,350 |
| OUTFLOWS |
| Savings and Investments | $ | | | | 11,300 | 9.2% |
| Fixed Outflows |
| Housing | $ | 1700 | 20,400 |
| Property Taxes | | | 4,000 |
| Student Loan | | 600 | 7,200 |
| Auto loan payments | | 500 | 6,000 |
| Insurance premiums | | | 2,900 |
| Total Fixed Outflows | $ | | | | 40,500 |
| Variable Outflows |
| Taxes | $ | | 26,950 |
| Food | | 700 | 8,400 |
| Transportation | | 500 | 6,000 |
| Clothing/personal | | 400 | 4,800 |
| Entertainment/vacation | | 500 | 6,000 |
| Medical/dental care | | 350 | 4,200 |
| Utilities/household | | 250 | 3,000 |
| Credit card payments | | 600 | 7,200 |
| Miscellaneous | | | 5,000 | | 71,550 |
| Total Variable Outflows | $ |
| TOTAL OUTFLOWS | | | | | 112,050 |
p98929892
