PART A

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

PART B

Please include an analysis of the information.

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:

Gross profit percentage

Return on sales

Asset turnover

Return on assets

Return on common stockholders equity

Current ratio

Quick ratio

Operating-cash-flow-to-current-liabilities ratio

Accounts receivable turnover

Average collection period

Inventory turnover

Days sales in inventory

Debt-to-equity ratio

Times-interest-earned ratio

Operating-cash-flow-to-capital-expenditures ratio

Earnings per share

Price-earnings ratio

Dividend yield

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

to calculate averages use ((current year balance + prior year balance) /2 ) round percentages to 1 decimal place; round other answers to 2 decimal places