Calculating Select Financial Ratios using Excel's ROUND and Basic Math Functions Zimmer, Inc. has provided its recent financial statements. The Controller has asked you to use this information to compute and interpred financial ratios that managers are going us to assassiquidity and use for asset and debt management purposes. Use the information included in the Exoal Simulation and the Excel functions described below to complete the task . Cell Reference: Allows you to refer to data from another cell in the worst Front Ece Simulation below in a bank cal"BT was nared the formula Output the new tromol 7. or 100.000 in this simple Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following key: (plus sign to add- ins into subtract). asterisk sign to land forward to divide. From the Excel Simion below in a blank col 13 CM was entered the formule would add the values from those and put there 500.000 in this example using the other thi s the result would output an appropriate answer for its function ROUND Allows you to round a number or of a forma c o nto a specific number of dig . The syntax of the ROUND function is ROUNDumbernum d y and returns the rest of your formula rounded to a particular number of digits. The number argument can be a reference b a rumberora Tomise that n umber. The w ants to be as you want to round The nom de vele rounds based on basis mathematical rounding where anything below w ound down thing and Movers An, the value should be a positive value to found to any number of decimal places, while a negative a r ound the of the decimal place and a zo would round to the newest whole the 1251 559) was and in cel M1, can be used in the ROUND on the red in this e ven calAlwhould be rounded to 2 decimales in newalthe function would be written as ROUNDAT A 3.5 S t einel At should be founded to the nearest hundred place in a men hatunction would be wr R OUND A d wortis 1.300 in this example Q5 MOMENT YOU TOUS 1 1 2 3 4 5 6 QWERTYUIO SDF OHJKL 1 2 1 1 1 TV control option command Clipboard Font STREETSEEEEEE Styles A1 Recent financial statements for Zimmer, Inc. are as follows: Zimmer Company Income Statement Last Year This Year $ 4,980,000 2,988,000 1,992,000 1 Recent financial statements for Zimmer, Inc. are as follows: Zimmer Company Comparative Balance Sheet This Year Assets 6 Current assets: 7 Cash 360,000 $ 8 Marketable securities 220,000 9 Accounts receivable, net 775,000 10 tnventory 925,000 11 Other current assets 355,000 12 Total current assets 2,635,000 13 Plant and equipment, net 1,975,000 14 Other assets 75,000 15 Total assets 4,685,000 $ 16 Liabilities and Stockholders' Equity 17 Current abilities: 18 Accounts payable 250,000 $ 19 Short-term bank loans 750,000 20 Accrued payables 550,000 21 Other current l es 275,000 22 Total current abilities 1.825.000 23 Bonds payable, 10% 575,000 Sheeti 310,000 Sales (all on account) 80,000 Cost of goods sold 700,000 Gross margin 750,000 Selling and administrative expenses 195,000 Operating expenses 2,035,000 Depreciation and amortization 1,800,000 General and administrative expenses 100,000 Total selling and administrative expenses 3.925.000 Net operating income Interest expense Net income before taxes 225,000 Income taxes 600,000 Net income 395,000 22.400 Additional information: 1.443.400 Dividend per share paid in current year 400,000 Market price of shares at year end 985,500 410,500 150,000 1,546,000 446,000 60,000 386,000 135.100 $250.900 $ 1.00 READY + 100% Attempte) Banner AB MacBook Pro Calculating Select Financial Ratios using Excel's ROUND and Basic Math Functions Zimmer, Inc. has provided its recent financial statements. The Controller has asked you to use this information to compute and interpred financial ratios that managers are going us to assassiquidity and use for asset and debt management purposes. Use the information included in the Exoal Simulation and the Excel functions described below to complete the task . Cell Reference: Allows you to refer to data from another cell in the worst Front Ece Simulation below in a bank cal"BT was nared the formula Output the new tromol 7. or 100.000 in this simple Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following key: (plus sign to add- ins into subtract). asterisk sign to land forward to divide. From the Excel Simion below in a blank col 13 CM was entered the formule would add the values from those and put there 500.000 in this example using the other thi s the result would output an appropriate answer for its function ROUND Allows you to round a number or of a forma c o nto a specific number of dig . The syntax of the ROUND function is ROUNDumbernum d y and returns the rest of your formula rounded to a particular number of digits. The number argument can be a reference b a rumberora Tomise that n umber. The w ants to be as you want to round The nom de vele rounds based on basis mathematical rounding where anything below w ound down thing and Movers An, the value should be a positive value to found to any number of decimal places, while a negative a r ound the of the decimal place and a zo would round to the newest whole the 1251 559) was and in cel M1, can be used in the ROUND on the red in this e ven calAlwhould be rounded to 2 decimales in newalthe function would be written as ROUNDAT A 3.5 S t einel At should be founded to the nearest hundred place in a men hatunction would be wr R OUND A d wortis 1.300 in this example Q5 MOMENT YOU TOUS 1 1 2 3 4 5 6 QWERTYUIO SDF OHJKL 1 2 1 1 1 TV control option command Clipboard Font STREETSEEEEEE Styles A1 Recent financial statements for Zimmer, Inc. are as follows: Zimmer Company Income Statement Last Year This Year $ 4,980,000 2,988,000 1,992,000 1 Recent financial statements for Zimmer, Inc. are as follows: Zimmer Company Comparative Balance Sheet This Year Assets 6 Current assets: 7 Cash 360,000 $ 8 Marketable securities 220,000 9 Accounts receivable, net 775,000 10 tnventory 925,000 11 Other current assets 355,000 12 Total current assets 2,635,000 13 Plant and equipment, net 1,975,000 14 Other assets 75,000 15 Total assets 4,685,000 $ 16 Liabilities and Stockholders' Equity 17 Current abilities: 18 Accounts payable 250,000 $ 19 Short-term bank loans 750,000 20 Accrued payables 550,000 21 Other current l es 275,000 22 Total current abilities 1.825.000 23 Bonds payable, 10% 575,000 Sheeti 310,000 Sales (all on account) 80,000 Cost of goods sold 700,000 Gross margin 750,000 Selling and administrative expenses 195,000 Operating expenses 2,035,000 Depreciation and amortization 1,800,000 General and administrative expenses 100,000 Total selling and administrative expenses 3.925.000 Net operating income Interest expense Net income before taxes 225,000 Income taxes 600,000 Net income 395,000 22.400 Additional information: 1.443.400 Dividend per share paid in current year 400,000 Market price of shares at year end 985,500 410,500 150,000 1,546,000 446,000 60,000 386,000 135.100 $250.900 $ 1.00 READY + 100% Attempte) Banner AB MacBook Pro