90.2K

Verified Solution

Link Copied!

Not Graded Please assist *please provide calculations and label 1. 2. 3. etc so I can follow your explanations and answers. Attention: See attached picture for numbers given to use.

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

Percentages and Ratios 2019 (a) 2018 2017 2016 2015 (6) Operating data: Net sales $ 16,865.2 $ 15,740.4 S 15,619.8 $ 16,563.1 $ 17,630.3 Gross margin (c) (d) 5,756.8 5,435.6 5,567.8 5,843.3 5,867.8 Selling, general, and administrative expenses (d) 2,935.8 2,850.1 2.888.8 3,141.4 3,389.9 Operating profit (d) 2,515.9 2,419.9 2.492.1 2,719.1 2,071.8 Net earnings attributable to General Mills 1,752.7 2.131.0 1.657.5 1,697.4 1.221.3 Advertising and media exponse 601.6 575.9 623.8 754.4 823.1 Research and development expense 221.9 219.1 218.2 222.1 229.4 Average shares outstanding Diluted 605.4 585.7 598.0 611.9 618.8 Earnings per share: Diluted S 2.90 s 3.64 s 2.77 $ 2.77 1.97 Adjusted diluted (c)(0) s 3.22 S 3.11 S 3.08 $ 2.92 2.86 Operating ration: Gross margin as a percentage of not sales (d) 34.1% 34.5% 35.6% 35.3% 33.8% Selling, general, and administrativo expenses as a percentage of net sales (d) 17.4% 18.1% 18.5% 19.0% 19.2% Operating profit as a percentage of net sales (d) 14.9% 15.4% 16,0% 16.4% 11.8% Adjusted operating profit as a percentage of net sales (e) (d) (0) 16.9% 16.6% 17.6% 16.8% 15.7% Effective income tax rate 17.7% 2.7% 28.8% 31.4% 33.3% Balance sheet data: Land, buildings, and equipment $ 3,787.2 s 4,047.2 S 3,687.7 $ 3,743.6 $ 3,783.3 Total assets 30.111.2 30,624.0 21.812.6 21,712.3 21,832.0 Long-term debt, excluding current portion 11,624.8 12,668.7 7.642.9 7,057.7 7,5753 Total debt (c) 14,490.0 15,8186 9.481.7 8,430.9 9,191.5 Cash flow data: Net cash provided by operating activities (1) s 2,807.0 s 2,841.0 s 2.415.2 2,764.2 s 2.648.5 Capital expenditures 537.6 622.7 6844 729.3 712.4 Free cash flow (0) 2,269.4 2,218.3 1.730.8 2,034.9 1,936.1 Share data: Cash dividends per common share 1.96 s s 1.92 $ 1.78 s 1.67 (a) Infiscal 2018, we acquired Blue Buffalo. Please see Note 3 to the Consolidated Financial Statements in Item 8 of this report (b) Fiscal 2015 was a 53-week year, all other fiscal years were 52 weeks. (c) Please see "Glossary" in ltem 8 of this report for definition (d) In the first quarter of fiscal 2019, we retrospectively adopted new accounting requirements related to the presentation of net periodic defined benefit pension expense, net periodic postretirement benefit expense, and net periodic postemployment benefit expense. Please see Note 2 to the Consolidated Financial Statements in Item 8 of this report (e) Please see "Non-GAAP Measures" in Item 7 of this report for our discussion of this measure not defined by generally accepted accounting 1.96 a a S

Answer & Explanation Solved by verified expert

See Answer