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

PART A

Provide the following information, include the formula, FY 2019, and FY 2018

PART B

Please include an analysis of the information.

Our operating segment results were as follows: Net sales for our North America Retail operating units were as follows: Net sales by class of similar products were as follows: During the first quarter of fiscal 2020, we made certain changes in the classification of products and updated fiscal 2019 and fiscal 2018 net sales figures to match the current-year presentation. The following tables provide financial information by geographic area: NOTE I8. SUPPLEMENTAL. INFORMATHON The components of certain Consolidated Balance Shect accounts are as follows: May 26, 2019, were valued at LIFO. The difference between replacement cost and the stated LIFO inventory value is not materially different from the reserve for the LIFO valuation method. Certain Consolidated Statements of Earnings amounts are as follows: The components of interest, net are as follows: Certain Consolidated Statements of Cash Flows amounts are as follows