Excel File Edit View Insert Format Tools Data Window Help B a (4) Tue Sep 15 2:29 PM Q Search Sheet Book1 Page Layout Formulas Data Review View + Share 1 Home Insert Draw Calibri (Body) 4 Paste B I U 12 A A AutoSum 5 Wrap Text General , TX, 49 Q Fill - H- A, Merge & Center $ 4.0 .00 .00 .0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Clear Sort & Filter Find & Select A22 foc A B D E F G H 1 j K. L 1 2 3 4 5 6 7 8 8 2017 Personal Financial Data for Married couple, Zach and Carly. Note: Data items are from end of year, except where specified otherwise. Zach Carlyl Join Annual income (gross) 111 000 78 000 401 K contribution (annual) 18 000 3 900 401 k maximum employer match ($1 per $1contribution) 4% 5% 401 K balance (including above contribution) 98 000 47 250 401 K balance (beginning of year) 78 000 35 000 Monthly housing costs 2 950 Other monthly debt payment 1 350 9501 Total monthly non-discretionary cash flows 3 000 2 200 2 9501 Cash & cash equivalent 20 000 12 000 Total debt 55 000 35 000 200 000 Total assets 152 000 94 000 275 000 Please calculation, not only answers, Thank you 9 10 11 12 13 14 15 16 17 Questions below: 18 19 20 21 22 23 24 25 26 27 28 8. Calculate Zach's ROI. Sheet1 + ung Ready B + 134% pdf SEP 90 15 tv w w