****Please show answers in formulas like the instructions show****
Selected Financial Ratios Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Paste .AAlignment Number Conditional Format as Ce Cells Editing FormattingTable Styles Clipboard Font es C36 4 5 Assets 6 Current assets: 7 Cash 8 Marketable securities This Year Last Year This Year 4,980,000 360,000 220,000 775,000 925,000 55,000 2,635,000 1,975,000 75,000 310,000 Sales (all on account 80,000 700,000 750,000 95,000 2,035,000 1,800,000 100,000 Cost of goods sold Gross margin Selling and administrative expenses Operating expenses 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 Acnts 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: 1,992,000 985,500 410,500 Depreciation and amortization General and administrative expenses Total selling and administrative expenses Net operating income Interest expense Net income before taxes 1,546,000 446,000 60,000 386,000 135,100 250,000 $ 225,000 Income taxes 750,000 550,000 275,000 600,000 Net income 395,000 223,400 Additional information: Dividend per share paid in current year$1.00 42.00 20.00 1,825,000 1,443,400 400 Market price of shares at year end 2,400,0001.843.400 1,843,400 r value of common stock per share on stock Selected Financial Ratios - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 10A A Paste - AAlignment Number Conditional Format as Ce Cells Editin Formatting Table Styles' Clipboard Font es C36 25 Stockholders' equit 26Common stock 27 28 Total stockholders' equity 29 Total liabilities and stockholders' equity 30 31 Required 32 Compute the following ratios for the current year only 33 Gross margin percentage 4 Current ratio (rounded to two decimal places) 5 Acid-test ratio (rounded to two decimal places 1,150,000 Number of share outstanding 1,150,000 941,600 2,091,600 Retained earnings 2,285,000 40% 1.44 0.74 Accounts receivable turnover (rounded to two decimal places) 37 Average collection period (rounded to the nearest whole day) 38 Inventory turnover ratio (rounded to two decimal places 39 Average sales period (rounded to the nearest whole day 40 Debt-to-equity ratio (rounded to two decimal places 41 Times interest earned (rounded to two decimal places) 42 Book value per share (rounded to two decimal places 43 Earnings per share (rounded to two decimal places 44 Dividend payout ratio (rounded to three decimal places) 45 Dividend yield ratio (rounded to three decimal places 46 47 Price-earnings ratio (rounded to two decimal places) Sheet1 t)
