Using the fiscal year end 2019 annual report for General Mills, Inc. and the figures from the 2017 annual report as noted below, calculate the financial ratios for 2019 and 2018 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 2017 = $21,812.6 Total stockholders’ equity 2017 = $4,327.9 Total current liabilities 2017 = $5,330.8 Accounts receivable 2017 = $1,430.1 Inventory 2017 = $1,483.6 Year-end closing stock price May 2019 = $50.93 Year-end closing stock price May 2018 = $39.37 Perform a comparative analysis of the data between the two years. Comment briefly on the changes from fiscal 2018 to 2019. Identify trends and explain the implications of each trend.
Using the fiscal year end 2019 annual report for General Mills, Inc. and the figures from the 2017 annual report as noted below, calculate the financial ratios for 2019 and 2018 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 2017 = $21,812.6
Total stockholders’ equity 2017 = $4,327.9
Total current liabilities 2017 = $5,330.8
Accounts receivable 2017 = $1,430.1
Inventory 2017 = $1,483.6
Year-end closing stock price May 2019 = $50.93
Year-end closing stock price May 2018 = $39.37
Perform a comparative analysis of the data between the two years. Comment briefly on the changes from fiscal 2018 to 2019. Identify trends and explain the implications of each trend.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images