finance
cham
Project-StatementofCashFlow.xlsxIncome and Expenditures
| Annual Income / Expenditures | ||
| Salary Income | $125,000 | |
| Investment Income | 2,000 | |
| 401(k) Contributions | 3,750 | |
| Insurance premiums | 2,000 | |
| Federal Tax | 7,025 | |
| State Tax | 1,250 | |
| Rent | 27,000 | |
| Food & Meals | 12,500 | |
| Clothing | 5,500 | |
| Entertainment & Travel | 8,750 | |
| Utilities and Phone | 4,000 | |
| Auto Maintenance | 2,000 | |
| Charitable Conurbations | 4,000 | |
| Tuition & Education | 15,000 | |
| Car Payments (Loan & Insurance) | 4,400 | |
| Credit Card Payments | 10,000 | |
Financial Position
| Assets | ||
| Checking Account | 25,000 | |
| Savings Account | 12,000 | |
| Total Liquid Assets | 37,000 | |
| Retirement Savings - 401 (k) | 43,000 | |
| Certificate of Deposits | 10,000 | |
| Total Investments | 53,000 | |
| Automobile | 15,000 | |
| Jewelry | 13,500 | |
| Furniture / Household | 30,000 | |
| Personal Assets | 58,500 | |
| Total Assets | 148,500 | |
| Liabilities and Net Worth | ||
| Credit Cards* | 8,000 | |
| Car Loan | 12,000 | |
| Student Loans | 16,000 | |
| Total Liabilities | 20,000 | |
| Smith Family Net Worth | 128,500 | |
| * Credit Card APR: 28%. Credit Limit $10,000 | ||
