in excel format and show formula please

3. (25 pts.) The financial statements for SunDry Food Services, Inc. are given below: SenDry Food Services, Inc. Balance Sheet 12/31/17 Aucts Cament asst Cash 21.000 260000 Accounts receivable, net Iavennory Prepaid expenses 6000 Tetal current assets 677,000 Property and equipment, net 900 000 bLS77000 Total asets Liabities and Steekhelders Equity Liabilities Cument labilitics Bends payable, 11% 220000 400000 Total labilities Steckheldes oquity Common stockS10 par value, 20,000 shases oustandings 620000 200,000 757 000 Retained eanings Tetal stockholders' equity 957.000 L.S77000 Total Biabilities and eqsity SanDry Feed Services, Inc. Income Stanement For the Year Eaded December 31 KE150.000 Sales 1,250,000 Cost of goods old Gross margin Selling and admisisative expenses 900,000 S80,000 320,000 Net operaing incemes Interes expense Net inceme before tases 44.000 276.000 Income tases (30%) 193.20 Net income Account balances at the beginning of the year were: accounts receivable, $200,000; and inventory, $330,000. All sales were on account. Assume that SunDry Food Services, Inc., paid dividends of S2.25 per share during the year. Also assume that the company's common stock had a market price of $53 at the end of the year and there was no change in the number of outstanding shares of common stock during the year. Given the financial statements and related information above, calculate the following financial ratios: 1. Earnings per share 2. Dividend payout ratio 3. Dividend yield 4. Price-earnings ratio 5. Book value per share