work in excel please

ANCHOR Industry 3.5 1.1 11.2 32.0 6.0 3.8 12.1 0.41 18.0% 13.3% 28.0% 40.0% Using the 2020 income statement and balance sheet data given, calculate the specified ratios for Anchor Company and analyze and comment on the 4 firm's position versus the provided industry averages. 5 6 INCOME STATEMENT Actual 2020 7 1 Salos $ 9,600.00 Current ratio 8 2 COGS $ 7,100.00 Quick Ratio 3 Depreciation expense $ 425.00 Inventory Turnover 10 4 Total operating costs $ 7,525.00 Days Sales Outstanding 1 5 EBIT $ 2,075.00 Fixed Asset Tumover 12 6 Less interest $ 130.00 Total Asset Turnover 13 7 Earnings before taxes (EBT) $ 1,945.00 Times Interest Eamed 8 Taxes (25%) $ 486.25 Long term debt/Equity 15 11 Net Income $ 1,458.75 Operating margin 16 12 Shares of common equity $ 260.00 Profit margin 17 Dividends per share 3.00 ROA B 14 Dividends to common $ 780.00 ROE 19 15 Additions to retained eamings $ 678.75 20 21 2 BALANCE SHEET Actual 2020 Comments: 3 ASSETS 84 1 Cash $ 35.00 25 2 Short-term investments $ 6 3 Accounts receivable $ 800.00 27 4 Inventories $ 1,020.00 8 5 Total Current Assets $ 1,855.00 09 6 Net plant & equipment $ 1,650.00 10 7 Total Assets $ 3,505.00 31 LIABILITIES & EQUITY 12 Accounts payable $ 215.00 3 Accruals $ 400.00 34 10 Notes payable $ 230.00 5 11 Total current liabilities $ 845.00 56 12 Long-term bonds $ 510.00 7 13 Total liabilities $ 1,355.00 8 15 Common stock $ 1,150.00 9 16 Retained earnings $ 1,000.00 0 17 Total common equity $ 2,150.00 -1 18 Total liabilities & equity $ 3,505.00