Answered step by step
Verified Expert Solution
Question
1 Approved Answer
what kind of information? Unit 2 Homework : Part 1 Attached Files: Homework Unit 2.xlsx (8.942 KB) You are going to do an analysis of
what kind of information?
Unit 2 Homework : Part 1 Attached Files: Homework Unit 2.xlsx (8.942 KB) You are going to do an analysis of the fast food industry. You will be comparing McDonald's, Wendy's, and YUM Brands. YUM brands owns Pizza Hut, KFC, and Taco Bell. Download the attached Excel file. Use yahoo finance to find the items listed for each of the three companies for the year ending date that is listed in the file. Once you have the data, calculate the ratios listed for each company. Use two decimal places for the ratios. Submit the completed Excel file.I will not accept any other file type. This MUST be submitted as the attached Excel file. B 12/31/2019 Wendy's 12/31/2019 Yum Brands A K$ 12/31/2019 2 McDonalds 3 Sales 4. Net Income 5 Interest expense 6 EBIT (use operating income or loss) 7 Inventory 8. Current Assets 9 Current Liabilities 10 Total Assets 11 Total Liabilities 12 Receivables 13 Equity 14 15 Current Ratio 16 Quick Ratio 17 Days Sales outstanding 18 Total asset turnover ratio 19 Times interest earned ratio 20 Profit margin 21 ROA 22 ROE 23 24 Unit 2 Homework : Part 1 Attached Files: Homework Unit 2.xlsx (8.942 KB) You are going to do an analysis of the fast food industry. You will be comparing McDonald's, Wendy's, and YUM Brands. YUM brands owns Pizza Hut, KFC, and Taco Bell. Download the attached Excel file. Use yahoo finance to find the items listed for each of the three companies for the year ending date that is listed in the file. Once you have the data, calculate the ratios listed for each company. Use two decimal places for the ratios. Submit the completed Excel file.I will not accept any other file type. This MUST be submitted as the attached Excel file. B 12/31/2019 Wendy's 12/31/2019 Yum Brands A K$ 12/31/2019 2 McDonalds 3 Sales 4. Net Income 5 Interest expense 6 EBIT (use operating income or loss) 7 Inventory 8. Current Assets 9 Current Liabilities 10 Total Assets 11 Total Liabilities 12 Receivables 13 Equity 14 15 Current Ratio 16 Quick Ratio 17 Days Sales outstanding 18 Total asset turnover ratio 19 Times interest earned ratio 20 Profit margin 21 ROA 22 ROE 23 24Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started