Excel File Edit View Insert Format Tools Data Window Help B Tue Sep 15 2:21 PM a Book1 Q- Search Sheet Page Layout Formulas Data Review View + Share a 1 Home Insert Draw Calibri (Body) 4 Paste B I U AutoSum 12 A A 5 Wrap Text General , TX, 49. Qi Fill - H- A Merge & Center $ % ) 4.0 .00 .00 1.0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Clear Sort & Filter Find & Select D21 fx A B D E F G H 1 j K. L 1 2 3 4 5 6 7 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 4. Calculate the couple's debt-to-total assets ratio. 5. Calculate the couple's net worth to total assets ratio Sheet1 + ung Ready B + 134% pdf SEP 90 15 tv w w