Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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 24

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Statistics For Contemporary Decision Making

Authors: Ken Black

7th Edition

0470931469, 978-0470931462

More Books

Students also viewed these Accounting questions