please fill out chart based on information in picture one along with b.

sorry about that

a. 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. Current 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 tumover (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. 6:02 PM 10/15/202 hp 19 to >> + insert Dr EYK 14-5- General Mills NOTES: to calculate averages use (current year balance + prior year balance)/2) round percentages to 1 decimal place; round other answers to 2 decimal places FY 2019 FY 2018 insert the formula here Gross profit percentage Return on sales Asset turnover 1 Return on assets 2 Return on common stockholders' equity Current ratio 4 Quick ratio EYK 14-5 Type here to search RI C D 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 Operating cash flow to capital expenditures ratio Earnings per share Price-earnings ratio Dividend yield EYK 14-5 Type here to search ORE mp Operating cash flow to capital expenditures ratio Earnings per share Price-earnings ratio Dividend yield Dividend payout ratio b Provide a detailed analysis based on Parta EYK 14-5 Type here to search O BI (hp) Fiscal 2019 Financial Highlights 52 weeks ended May 26, 2019 52 weeks ended May 27, 2018 $15,740 % Change 7% Change on a constant- currency basis 9% $16,865 Flat $2,516 $2,420 4% 14.9% 15.4% -50 bps $2,858 $2,613 9% 10% In millions, except per share and profit margin data Net Sales Organic Net Sales Operating Profit Operating Profit Margin Adjusted Operating Profit Adjusted Operating Profit Margin Net Earnings Attributable to General Mills Diluted Earnings per Share (EPS) Adjusted Diluted EPS Average Diluted Shares Outstanding Dividends per Share 16.9% 16.6% +30 bps $1.753 $2.131 -18% $2.90 $3.64 -20% $3.22 $3.11 4% 4% 605 586 3% $1.96 $1.96 Flat Net Sales Dollars in millions Adjusted Operating Profit Dollars in millions Adjusted Diluted Earnings per Share* Dollars Free Cash Flow Dollars in millions $17.630 $16,563 $15,620 $16,865 $15,740 $2,764 $2.775 $2,750 $2,858 $2,613 $2.86 $2.92 IT'S $3.22 $3.08 $1,936 $2,035 $2,218 $2,269 $1,731 d 8. uchard/ dl4UIV Fiscal Year In Millions, Except Per Share Data, 2019 (a) 2018 2017 2016 Percentages and Ratios 2015 (6) Operating data: Net sales $ 16,865.2 S 15,740.4 S 15,619,8 $ 16,563.1 $ 17,6303 Gross margin (c) (d) 5,756.8 5,435.6 5,567.8 5,843.3 5.967.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 expense 601.6 575.9 623.8 754.4 823.1 Research and development expense 221.9 219.1 2182 222.1 229.4 Average shares outstanding: Diluted 605.4 585.7 598.0 611.9 6188 Earnings per share: Diluted S 2.90 s 3.64 $ 2.77 $ 2.77 $ 1.97 Adjusted diluted (c) (e) S 3.22 $ 3.11 $ 3.08 $ 2.92 s 2.86 Operating ratios: Gross margin as a percentage of net sales (d) 34.1% 34.5% 35.6% 35.3% 33.8% Selling, general, and administrative 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 (c) (d) (e) 16.9% 16,6% 17.6% 16.8% Effective income tax rate 15.7% 17.7% 2.7% 28.8% 31.4% 33.3% Balance sheet data: Land, buildings, and equipment S 3,787.2 S 4,047.2 s 3.687.7 s 3,743.6 $ 3,783.3 Total assets 30.111.2 30.624.0 21,812.6 21,712.3 Long-term debt, excluding current 21,832.0 portion 11,624.8 12,668.7 7,642.9 7,057.7 Total debt (c) 7.575.3 14,490.0 15,818.6 9,481.7 Cash flow data: 8,430.9 9.1915 Net cash provided by operating activities (1) s 2,807.0 S 2,841.0 S 2,415.2 s 2,764.2 S Capital expenditures 537.6 2,648,5 622.7 684.4 7293 712.4 Free cash flow (c) 2,269.4 2,218.3 Share data: 1.730.8 2,034.9 1,936.1 Cash dividends per common share 1.96 S S 1.92 s 1.78 S (a) In fiscal 2018, we acquired Blue Buffalo. Please see Note 3 to the Consolidated Financial Statements in Item 8 of this report 1.67 th Fiscal 2015 november O BI 1.96