For company Z, you have the financial statement (f.01) for the end of round 3 shown above.

Replicate Zs ratios in the financial statement spreadsheet provided. Open the spreadsheet and move to the right. Dont alter the column or row labels in the range of J1 to N25. Follow the example shown for the Gross Margin and describe the formula in words then show the numerator and denominator values. The ratio value will appear (replacing #DIV/0) when you enter the cell reference for the numerator and denominator values. Use cell reference formulas For example: Enter a cell reference such as =E28, do NOT type in the literal value, such as 21,238,784.1.

To figure out the formulas use a finance or accounting textbook or simple search on the Internet. Be sure to match exactly the ratios shown above, including values to the right of the decimal point. Use the minus sign or ABS() function, if needed, to make the ratio value shown.

In the shaded green area, provide a short explanation of what this financial ratio tells about the companys financial standing (an example explanation is given for the marketing-to-sales ratio). You must complete: net margin, return on equity, return on assets, debt to equity and marketing to sales.

J4 Thi s ratio. Financial Statements-ERPsim vancial Ratlo Ledg OL Numerator value Gro53 Marp Careecy type Company codecurnency Anounts in turogean Duro Reporting periads Corpardon perieds | 201701-2017 16 8 2016.01 201616 Net Margin Ths rato Retuen on Equity a Balance Sheet This radio 0 Current Assets Retam on Assets 0 Bank Cash Account 2853,776.96 2,853,77696 0 499 839.41 0 110,644.00 0189523.69 3,053.754.06 140000 Custoners-Domestk Recevables L0 aad00 Rawuterials LO 792000 Finished geeds 10 Total Current Assets 11 Long-Term Assits 11 001000 Land 1 002000 Buildings 11 002010 Accumulated Depreciution iing 11 011000 Machinery and equipment 11 011010 Accumulatad depreciation-achnary andim 1 Total LenTem Assests This rato 110,644.00 Debt to Equity DMO! 150000000 15,000.00 16,000,000.00 -39999996 17585,000.04 21.238.784.10 Moriketing to Sale 6,000 000.00 -399,999 96 7585 000.04 1,238.73410 Ths rato is in ERPso to highight how much money 8spent on maketng for each earo of evense generated Total 04sets G Labitles and Owrers Equity 2 Laia 4 Cuerent Liab es: 14 16000d Accounts payable-Domestk 4 Total Cuit Labiii 396.932 00 306,93200 396 932.00 0396,93200 396932.00 Tota Lab me 13 Equity L6 Shareholdes Equity G 070000 Comnon stack 6 Total Shaolde Equity 17 Retained Eaing 0 -20,000,000.00 0-20,000,00.0 20,00a.dco.o0 5 Add:Net Ihcome 7 Total Retained Earninga 13 Total tauty 541852.10 841852 10 20 941852 10 21,238784.10 0-841552.0 841852.10 Tota Libltis and Outers Equity 0 -21238,784.10