Question

1 Approved Answer

Posted on Sep 12, 2024

need help with filling in the yellow highlighted cells in the excel sim. the answer cannot be entered as a number, but must be entered

need help with filling in the yellow highlighted cells in the excel sim. the answer cannot be entered as a number, but must be entered as a formula. please show the formulas you used when entering the answer. image text in transcribed

Saved Help Excel SIM: Selected Financial Ratios 1 1. Computer and interpret financial ratios that managers use to assess quidity 2. Compute and interpret financial ratios that managers use for asset management purposes 3. Compute and interpret financial ratios that managers use for det management purposes. 33.33 points 3 Selected Financial Ratio - Excel FORMULAS DATA REVIEW 7 book FILE HOME INSERT Pdl LAYOUT VIEW Sign In Cabo 10 Paste Cipboard MAA M - Alignment Number Conditional Format Call Cal Editing Formatting Table Styles Styr Recent financial statements for Zimmer, Inc. are as follows Font 2 References A1 . This Year 11 1 Rides for Zimmer, Inc. we follow 2 Company C Compte Balance Sheet Income The Year Last Year 5 A 6 C 7 CAN MOMO 110000 Sales Call Marketable sur 320,00 0 000 Cror good 0 Acable.net 795.000 O Cross 10 Inventory 925.000 750000 Sling and IL Other current 955/MO 1950 Opening 12 Total 265.00 2005-200 Depreciation and more 13 Plant and equipment 195.000 1 MON Generalni Other 75 000 100.000 Thalaimed dine experts 15 Tatil 3 66505 395 Nettiin 54 96,300 410.500 ISO100 1546200 46 MC SAW Hin Prov 1 of 3 Next > eztomheducation.com excel 13 Through COM C Help E 10 GA 1 Puste BIU Coboard Font - Alignment Number Conditional Format as Cell Gels diting Formatting The Styles Styles Recent financial statements for Zimmer, Inc. are as follows: X 3.33 pints 115.100 book 5 Print 1.00 42.00 20.00 References 8 18 Accounts payable $ 250.000 5 225.000 cotas 19 Short-term besko 750.000 600.000 Net income 20 Accrued payables 550.000 21 Other current abilities 275.000 223400 Aditional information 22 Totalcar labilities 1225 DCO 1423400 Divides per here paid is one year 23 Boode payable 10% 375.000 600 000 Market price of shares a year and 24 Total liabilities 2 AO DOO 18400 Par ve o como vock per she 25 Stockholders alty 26 Cocok 1.350.000 1.150.000 Number of the Ratsineering 1.115.000 041600 28 Toalhidos equity 2245.000 2091.600 29 Tool abilities and sockholders equity $ 448560 3935.000 30 31 Required: 32 Compare the following rates for the current year only 33 Gross margin percentage 14 Current (rounded to two decimal place) 14 35 Add test ratio onded to two decimal place 0.14 36 Accounts receivable amover onded to be places 37 Average collection period od to the whole day) 38 Ivory over tired to decimal places) 39 Average ate period odd the whole day! 40 Dette equity to Craded so we decimal pas) Sheet1 RIELADY Altempo) 100 M Excel 13 Saved Help HOME UNSER RELATUUR UKMUUS LU REVIEW VIEW Cuba 10 H 1 be Paste BTU -A A 8.A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font AI + X Recent financial statements for Zimmer, Inc. are as follows: 33.33 points E ebook Print References B c 29 Total liabilities and stockholders equity S 4685.000 1.935 30 31 Required: 32 Compute the following ratios for the current year only 33 Gross martin percentage 40% 34 Current ratio (rounded to two decimal places) 144 35 Acid-test ratio Croanded to two decimal places) O T4 36 Accounts receivable tumover crounded to two decimal places) 37 Average collection period (rounded to the nearest whole day) 38. Inventory burnover ratio crounded to two decimal places 39 Average salespersed rounded to the nearest whole day) 40 Debt-to-equity ratio (rounded to two decimal places) 41 Times interest earned (roceded to two decimal places) 42 Book value per share (rounded to two decimal places) 43 Earnings per share (rounded to two decimal place) 44 Dividend payout ratio (rounded to three decimal places) 45 Dividend yield ratio (rounded to three decimal places) 46 Price caring ratio (rounded to two decimal places 47 48 49 50 Sheet1 READY 100% Saved Help Excel SIM: Selected Financial Ratios 1 1. Computer and interpret financial ratios that managers use to assess quidity 2. Compute and interpret financial ratios that managers use for asset management purposes 3. Compute and interpret financial ratios that managers use for det management purposes. 33.33 points 3 Selected Financial Ratio - Excel FORMULAS DATA REVIEW 7 book FILE HOME INSERT Pdl LAYOUT VIEW Sign In Cabo 10 Paste Cipboard MAA M - Alignment Number Conditional Format Call Cal Editing Formatting Table Styles Styr Recent financial statements for Zimmer, Inc. are as follows Font 2 References A1 . This Year 11 1 Rides for Zimmer, Inc. we follow 2 Company C Compte Balance Sheet Income The Year Last Year 5 A 6 C 7 CAN MOMO 110000 Sales Call Marketable sur 320,00 0 000 Cror good 0 Acable.net 795.000 O Cross 10 Inventory 925.000 750000 Sling and IL Other current 955/MO 1950 Opening 12 Total 265.00 2005-200 Depreciation and more 13 Plant and equipment 195.000 1 MON Generalni Other 75 000 100.000 Thalaimed dine experts 15 Tatil 3 66505 395 Nettiin 54 96,300 410.500 ISO100 1546200 46 MC SAW Hin Prov 1 of 3 Next > eztomheducation.com excel 13 Through COM C Help E 10 GA 1 Puste BIU Coboard Font - Alignment Number Conditional Format as Cell Gels diting Formatting The Styles Styles Recent financial statements for Zimmer, Inc. are as follows: X 3.33 pints 115.100 book 5 Print 1.00 42.00 20.00 References 8 18 Accounts payable $ 250.000 5 225.000 cotas 19 Short-term besko 750.000 600.000 Net income 20 Accrued payables 550.000 21 Other current abilities 275.000 223400 Aditional information 22 Totalcar labilities 1225 DCO 1423400 Divides per here paid is one year 23 Boode payable 10% 375.000 600 000 Market price of shares a year and 24 Total liabilities 2 AO DOO 18400 Par ve o como vock per she 25 Stockholders alty 26 Cocok 1.350.000 1.150.000 Number of the Ratsineering 1.115.000 041600 28 Toalhidos equity 2245.000 2091.600 29 Tool abilities and sockholders equity $ 448560 3935.000 30 31 Required: 32 Compare the following rates for the current year only 33 Gross margin percentage 14 Current (rounded to two decimal place) 14 35 Add test ratio onded to two decimal place 0.14 36 Accounts receivable amover onded to be places 37 Average collection period od to the whole day) 38 Ivory over tired to decimal places) 39 Average ate period odd the whole day! 40 Dette equity to Craded so we decimal pas) Sheet1 RIELADY Altempo) 100 M Excel 13 Saved Help HOME UNSER RELATUUR UKMUUS LU REVIEW VIEW Cuba 10 H 1 be Paste BTU -A A 8.A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font AI + X Recent financial statements for Zimmer, Inc. are as follows: 33.33 points E ebook Print References B c 29 Total liabilities and stockholders equity S 4685.000 1.935 30 31 Required: 32 Compute the following ratios for the current year only 33 Gross martin percentage 40% 34 Current ratio (rounded to two decimal places) 144 35 Acid-test ratio Croanded to two decimal places) O T4 36 Accounts receivable tumover crounded to two decimal places) 37 Average collection period (rounded to the nearest whole day) 38. Inventory burnover ratio crounded to two decimal places 39 Average salespersed rounded to the nearest whole day) 40 Debt-to-equity ratio (rounded to two decimal places) 41 Times interest earned (roceded to two decimal places) 42 Book value per share (rounded to two decimal places) 43 Earnings per share (rounded to two decimal place) 44 Dividend payout ratio (rounded to three decimal places) 45 Dividend yield ratio (rounded to three decimal places) 46 Price caring ratio (rounded to two decimal places 47 48 49 50 Sheet1 READY 100%