Financial planning

profilePhilip88
Order60986-CashFlowAnalysis.xlsx
Home>Business & Finance homework help>Accounting homework help>Financial planning

Revised Cash Flow Statement

Monthly Cash Flow
John Smith
DATE PERIOD
Current Revised
INFLOWS Total Average % of Income Total Average % of Income
Income
Wages & Tips $ 40,200 $ 3,350 100.0% $ 40,200 $ 3,350 100.0%
Total INFLOWS $ 40,200 $ 3,350 $ 40,200 $ 3,350
OUTFLOWS Total Average % of Income Total Average % of Income
Payroll / Income Deductions
CCP $ 1,812 $ 151 4.5% $ 1,812 $ 151 4.5%
EI $ 672 $ 56 1.7% $ 672 $ 56 1.7%
Housing
Apartment rental $ 13,000 $ 1,083 32.3% $ 13,000 $ 1,083 32.3%
Insurance: Home/Rental $ 300 $ 25 0.7% $ 300 $ 25 0.7%
Utilities: Gas / Electricity $ 1,380 $ 115 3.4% $ 1,380 $ 115 3.4%
Utilities: TV / Phone / Internet $ 600 $ 50 1.5% $ 600 $ 50 1.5%
Utilities: Water / Trash $ 360 $ 30 0.9% $ 360 $ 30 0.9%
Supplies $ 276 $ 23 0.7% $ 276 $ 23 0.7%
Debts
Astra Suites - Wedding $ - 0 $ - 0 0.0% $ 1,876 $ 156 4.7%
Credit Card Payments $ 1,440 $ 120 3.6% $ 3,336 $ 278 8.3%
Student Loan Payments $ 5,004 $ 417 12.4% $ 5,004 $ 417 12.4%
Automobile Expenses
Car Payments $ 3,336 $ 278 8.3% $ 3,336 $ 278 8.3%
Insurance: Auto $ 1,200 $ 100 3.0% $ 1,200 $ 100 3.0%
Auto: Fuel $ 1,200 $ 100 3.0% $ 1,200 $ 100 3.0%
Auto: Maintenance $ 300 $ 25 0.7% $ 300 $ 25 0.7%
Food
Food: Eating Out $ 3,105 $ 259 7.7% $ 600 $ 50 1.5%
Food: Groceries $ 2,150 $ 179 5.3% $ 3,348 $ 279 8.3%
Entertainment
Clothing $ 550 $ 46 1.4% $ 550 $ 46 1.4%
Entertainment / Recreation $ 3,065 $ 255 7.6% $ 600 $ 50 1.5%
Gifts Given $ 450 $ 38 1.1% $ 450 $ 38 1.1%
Total OUTFLOWS $ 40,200 $ 3,350 100.0% $ 40,200 $ 3,350 100.0%
NET CASH FLOW $ - 0 $ - 0 $ - 0 $ - 0