Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Joe wants to look at his personal cash flow budget over the next three months. January expenses are given bellow. For Feb and March, extrapolate
Joe wants to look at his personal cash flow budget over the next three months. January expenses are given bellow. For Feb and March, extrapolate the Expenses as a % of income and find the cash surplus (or deficit) and cumulative cash balance. (COMPLETE THE GREEN SHADED CELLS)
X 6 Calibri (Body) 11 - ' ' Milli lili Paste BIU BE a. Av Office Update To keep up-to-date with security updates, fixes, and imp H19 D 1 12 Joe wants to look at his personal cash flow budget over the next 3 months 2 January Expenses are ger below 3 For Feb & March, extrapolate the Expenses as all of income 4 and find the cash surplus for deficit ad cumulative cash balance. 5 Complete the green shaded cells) Jan Feb March Income 9 Take home pay $4.900 3500 6000 10 Tipes Percent of Income $1,470 245 490 343 25 147 800 12 Housing 13 Utilities 14 Food 15 Transportation 15 Medical Dental 17 Clothing 18 Property taxes 19 Appliances 20 Personal care 21 Entertainment 22 Savings 23 Other 24 Total expenses 25 24 Cash surplus er (deficit) 27 28 Cumulative cash surplus or deficit) 29 10 3: 49 OR 294 368 245 52.774 SLR SIAP 11 13 50 33 Autive Home Insert Dr Page Layout Formulas bata Review View Tele Calibrity 11 -AA ZE Pula BI -A- Merge Center Office Update Tokep-to-date with ourtypes, and impreschoose Check for HIS fo 1 Martha --- 11 17 114 22995 3 Chow www. MacB- E 1 2 # 3 4 5 0 Q W E lab R T A S D ops lock F F N N V Po www to lose were megebel Por Merch, the persone and find the show be dedes Unh Tube 32 S1410 361 340 Food Trang Medical Clothing VA perty 147 Sip Other Talas Card 25 Cutie cathwick TUIN Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started