5 16 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: 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 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 - 550.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. EYK 14 5 - General Mills NOTS to altroverages use frentyrar bolonce prior yor boloncel/ round percentages to 1 decimal place, round other answers to decimal places Insert Formule Here FY 2010 Answer FY 2018 Answer Gross profit percentage Return on sales Asstturnover 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 over Dwys sales in inventory Debt to equity into Timsinstearned Operating cash row to Capital expenditures ratio Price-creatie Dividend veld Dividend you to a. EYK14-5. Accounting Research Problem: General Mills, Inc. The fiscal year 2017 annual report of Gen- eral Mills, Inc. is available on this book's web site. Required Calculate (or identify the following financial ratios for 2016 and 2017: 1. Gross profit percentage 2. Return on sales 3. Asset turnover (2015, total assets = $21,832.0 million) 4. Return on assets (2015, total assets = $21,832.0 million) 5. Return on common stockholders' equity (2015, total stockholders' equity = $4.996.7 million) 6. Curre ratio 7. Quick ratio 8. Operating-cash-flow-to-current-liabilities ratio (2015, current liabilities = $4,890.1 million) 9. Accounts receivable turnover (2015, accounts receivable = $1,386.7 million) 10. Average collection period 11. Inventory turnover (2015, inventory = $1,540.9 million) 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 (Use year-end adjusted closing stock price of $57.32 for 2017 and $63.69 for 2016.) 18. Dividend yield 19. Dividend payout ratio b. Comment briefly on the changes from fiscal 2016 to fiscal 2017 in the ratios computed above. aunting Web-Version-1.pdf - Mozilla Firefox Q Search WFY19 General Mills-Annual Report-10 K-Web Version ** - Robinhood + Automatic Zoom argin as a percentage of net (d) 34.1% 34.5% 35,6% 35.3% 33.8% general, and administrative nses as a percentage of net (d) 17.4% 18.1% 18.5% 19.0% 19.2% ing profit as a percentage of net (d) 14.9% 15.494 16,0% 16.4% 11.8% med operating profit as a percentage ct sales (c) (d) (c) 16.9% 16.6% 17.6% 16.8% 15.7% tive income tax rate 17.7% 2.7% 28.8% 31.4% 33.3% ance sheet data: buildings, and equipment 5 3,787.2 $ 4,047.2 S 3,687.7 s 3,743.6 s 3,783.3 assets 30.111.2 30.624.0 21,812.6 21,712.3 21.832.0 -term debt, excluding current ortion 11.624.8 12,668.7 7,642.0 7,057.7 7,5753 al debt (c) 14.490.0 15.818.6 9.481.7 8,430.9 9.1915 show data: cash provided by operating activities in 5 2.807.0 S 2,841.0 s 2.4152 5 2.764.2 s 2.6ERS pital'expenditures 537.6 6227 6844 729.3 712.4 Tee cash flow ic) 2.260.4 2.2183 1.730,8 2,0349 1.936.1 Share data: Cash dividends per common share 1.96 5 S 1.92 5 178 S In 2011, quand Huffalo Please see to the Conto Financial Statement Items of this report 15wock yuarately were 5 wocks YE) Palary in mor his part for definition (det for at of 2009, poively doplnocourqine to the point of net pe datino et piepriemones not propostemployment law of this report - To this post to our comment del molly 5 16 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: 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 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 - 550.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. EYK 14 5 - General Mills NOTS to altroverages use frentyrar bolonce prior yor boloncel/ round percentages to 1 decimal place, round other answers to decimal places Insert Formule Here FY 2010 Answer FY 2018 Answer Gross profit percentage Return on sales Asstturnover 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 over Dwys sales in inventory Debt to equity into Timsinstearned Operating cash row to Capital expenditures ratio Price-creatie Dividend veld Dividend you to a. EYK14-5. Accounting Research Problem: General Mills, Inc. The fiscal year 2017 annual report of Gen- eral Mills, Inc. is available on this book's web site. Required Calculate (or identify the following financial ratios for 2016 and 2017: 1. Gross profit percentage 2. Return on sales 3. Asset turnover (2015, total assets = $21,832.0 million) 4. Return on assets (2015, total assets = $21,832.0 million) 5. Return on common stockholders' equity (2015, total stockholders' equity = $4.996.7 million) 6. Curre ratio 7. Quick ratio 8. Operating-cash-flow-to-current-liabilities ratio (2015, current liabilities = $4,890.1 million) 9. Accounts receivable turnover (2015, accounts receivable = $1,386.7 million) 10. Average collection period 11. Inventory turnover (2015, inventory = $1,540.9 million) 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 (Use year-end adjusted closing stock price of $57.32 for 2017 and $63.69 for 2016.) 18. Dividend yield 19. Dividend payout ratio b. Comment briefly on the changes from fiscal 2016 to fiscal 2017 in the ratios computed above. aunting Web-Version-1.pdf - Mozilla Firefox Q Search WFY19 General Mills-Annual Report-10 K-Web Version ** - Robinhood + Automatic Zoom argin as a percentage of net (d) 34.1% 34.5% 35,6% 35.3% 33.8% general, and administrative nses as a percentage of net (d) 17.4% 18.1% 18.5% 19.0% 19.2% ing profit as a percentage of net (d) 14.9% 15.494 16,0% 16.4% 11.8% med operating profit as a percentage ct sales (c) (d) (c) 16.9% 16.6% 17.6% 16.8% 15.7% tive income tax rate 17.7% 2.7% 28.8% 31.4% 33.3% ance sheet data: buildings, and equipment 5 3,787.2 $ 4,047.2 S 3,687.7 s 3,743.6 s 3,783.3 assets 30.111.2 30.624.0 21,812.6 21,712.3 21.832.0 -term debt, excluding current ortion 11.624.8 12,668.7 7,642.0 7,057.7 7,5753 al debt (c) 14.490.0 15.818.6 9.481.7 8,430.9 9.1915 show data: cash provided by operating activities in 5 2.807.0 S 2,841.0 s 2.4152 5 2.764.2 s 2.6ERS pital'expenditures 537.6 6227 6844 729.3 712.4 Tee cash flow ic) 2.260.4 2.2183 1.730,8 2,0349 1.936.1 Share data: Cash dividends per common share 1.96 5 S 1.92 5 178 S In 2011, quand Huffalo Please see to the Conto Financial Statement Items of this report 15wock yuarately were 5 wocks YE) Palary in mor his part for definition (det for at of 2009, poively doplnocourqine to the point of net pe datino et piepriemones not propostemployment law of this report - To this post to our comment del molly