ROUND function: Allows you to round a number or result of a formula calculation to a specific number of digits. The syntax of the ROUND function is =ROUND(number,num_digits) and returns the result of your formula rounded to a particular number of digits. The number argument can be a cell reference to a number or a formula itself that results in a number. The num_digits argument is the number of digits you want to round. The num_digits value rounds based on basis mathematical rounding rules, where anything below 5 will round down and anything 5 and above rounds up. Also, the num_digits value should be a positive value to round to any number of decimal places, while a negative value would round to the left of the decimal place, and a zero would round to the nearest whole number. If the value 1,253.5693 was entered in cell A1, it can be used in the ROUND function as the number reference. In this example, if the value in cell A1 should be rounded to 2 decimal places, in a new cell the function would be written as =ROUND(A1,2) and would result in as 1,253.57 in this example. If the number in cell A1 should be rounded to the nearest hundred place, in a new cell the function would be written as =ROUND(A1,-2) and would result in 1,300 in this example.

Please use formulas

Selected Financial Ratios Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA A REVIEW VIEW Calibri Paste B I U A Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Clipboard Font | | Recent financial statements for Zimmer, Inc. are as follows: 1 Recent financial statements for Zim mer, Inc. are as follows Zimmer Com Zimmer Com Comparative Balance Sheet Income Statement This Year Last Year This Year 5 Assets Curre nt assets 7 Cash 360,000 310,000 Sales (all on account 220,000 775,000 925,000 $4,980,000 80,000 Cost of goods sold 700,000 Gross margin 50,000 Selling and administrative expenses Marketable securities Accounts receivable, net 10 Inventory 11 Other current assets 12 Total current assets 13 Plant and equipment, net 14 Other assets 15 Total assets 16 Liabilities and Stockholders' Equity 17 Current Liabilities: 18 Accounts payable 19 Short-term bank loans 20 Accrued payables 21 Other current liabilities 22 Total current liabilities 23 Bonds payable 10% 24 Total liabilities 25 Stockholders' equity 26 Common stock 27 Retained e amings 28 Total stockholders' equity 29 Total liabilities and stockholde requity S 4685.0003.935.000 30 31 Required 2 Compute the following ratios for the curre nt year only 33 Gross margin percentage 54 Curre nt ratio (rounded to two decimal places 35 Acid-test ratio (roundedto two decimal places 36 Accounts receivable turnover (rounded to two decimal places 37 Average colle ction period (rounded to the nearest whole day) 38 Inve ntory turnover ratio (rounded to two decimal place s) 39 Average sales period (rounded to the ne are st whole 40 Debt-to-equity ratio (rounded to two de cimal places) 41 Times intere st earned (roundedtotwo decimal places) 42 Book value per share (rounded to two decimalplaces) 43 Earnings per share (rounde d to two decimal places) 44 Dividend payout ratio (rounded to three decimal places) 45 Dividend yie ld ratio (rounded to three decimal places 46 Price-earnings ratio (rounded to two decimal places) 985,500 Operating expenses Depreciation and amortization General and administrative expenses 2,635,000 2,035,000 410,500 1,975,000 1,800,000 Total se lling and adm inist rative expenses $ 3935.00Net ope rating income 446,000 Interest expense Net income before taxes 386,000 250,000 225,000 Income taxes 750,000 550,000 600,000 Net income 395,000 Additional information: 1,825,000 443,400 Dividend per share paid in current year Market price of shares at year end Par value of common stock per share 42.00 20.00 1,150,000 1,150,000 Number of share outstanding Sheetl ... t