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 turnover
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