Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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)
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Wall Street

Authors: Jeffrey B. Little

5th Edition

0071633227

More Books

Students also viewed these Finance questions

Question

Discuss all branches of science

Answered: 1 week ago