PART A Provide the following information, include the formula, FY 2019, and...
70.2K
Verified Solution
Link Copied!
Question
Accounting
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
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
