this is only 6 and 7 questions, the rest question are:

1. Calculate the couple's emergency fund ratio in months. Round to three decimal places.

2. Calculate the couple's housing 1 ratio.

3. Calculate the couple's housing ratio 2.

4. Calculate the couple's debt-to-total assets ratio.

5. Calculate the couple's net worth to total assets ratio

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