finance

cham
Project-StatementofCashFlow.xlsx

Income 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