Financial Statement Analysis: General Mills, Inc. REQUIRED: Using the fiscal year end 2020 annual report for General Mills, Inc. and the figures from the 2020 annual report as noted below, calculate the financial ratios for 2020 and 2019 indicated using the EXCEL template provided: 1. Gross profit percentage 2. Return on sales 3. Asset turnover 4. Return on assets 5. Return on common stockholders' equity 6. Current ratio 7. Quick ratio 8. Operating-cash-flow-to-current-liabilities ratio 9. Accounts receivable tumover 10. Average collection period 11. Inventory turnover 12. Days' sales in inventory 13. Debt-to-equity ratio 14. Times-interest-earned ratio 15. Operating-cash-flow-to-capital-expenditures ratio 16. Earnings per share 17. Price-earnings ratio 18. Dividend yield 19. Dividend payout ratio Total assets 2020=$30,806.7 Total stockholders' equity 2020=$8,349.5 Total current liabilities 2020=$7,491.5 Accounts receivable 2020=$1,615.1 Inventory 2020=$1,426.3 Year-end closing stock price May 2020=$58.80 Year-end closing stock price May 2019=$53.56 ACC 1020 Principles of Accounting I NOTES: General Mills to calculate averages use ((current yesr balance + prior year balance)/2) roand percentages to 1 decimal place; round other answers to 2 decimal places b Analysis Financial Statement Analysis: General Mills, Inc. REQUIRED: Using the fiscal year end 2020 annual report for General Mills, Inc. and the figures from the 2020 annual report as noted below, calculate the financial ratios for 2020 and 2019 indicated using the EXCEL template provided: 1. Gross profit percentage 2. Return on sales 3. Asset turnover 4. Return on assets 5. Return on common stockholders' equity 6. Current ratio 7. Quick ratio 8. Operating-cash-flow-to-current-liabilities ratio 9. Accounts receivable tumover 10. Average collection period 11. Inventory turnover 12. Days' sales in inventory 13. Debt-to-equity ratio 14. Times-interest-earned ratio 15. Operating-cash-flow-to-capital-expenditures ratio 16. Earnings per share 17. Price-earnings ratio 18. Dividend yield 19. Dividend payout ratio Total assets 2020=$30,806.7 Total stockholders' equity 2020=$8,349.5 Total current liabilities 2020=$7,491.5 Accounts receivable 2020=$1,615.1 Inventory 2020=$1,426.3 Year-end closing stock price May 2020=$58.80 Year-end closing stock price May 2019=$53.56 ACC 1020 Principles of Accounting I NOTES: General Mills to calculate averages use ((current yesr balance + prior year balance)/2) roand percentages to 1 decimal place; round other answers to 2 decimal places b Analysis