Question

Complete a common size income statement (vertical analysis) for each of the following companies Yum! Brands, Inc Panera Bread Starbucks The common size income statement is for the three most recent years using the following information Complete the assignment using Excel (show formulas please) Yum! Brands, Inc. IN BILLIONS Net sales Gross profit Net income 2015 6.44B 3.44B 1.29B 2016 6.36B 2.67B 1.64B 2017 5.88B 2.69B 1.34B Panera bread IN MILLIONS Net sales Gross profit Net income 2015 691.77M 69.88M 43.16M 2016 727.11M 70.68M 44.01M 2017 727.63M 247.56M 42.49M Starbucks IN BILLIONS Net sales Gross profit Net income 2015 19.15B 4.56B 2.76B 2016 21.31B 5.27B 2.82B 2017 22.38B 5.34B 2.88B

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Yum! Brands, Inc (In Billions) Common Size Income Statement
2015 2016 2017 2015 2016 2017
Net Sales 6.44 6.36 5.88 (Net sales / Net Sales) 100.00% 100.00% 100.00%
Gross Profit 3.44 2.67 2.69 (Gross Profit / Net Sales) 53.42% 41.98% 45.75%
Net Income 1.29 1.64 1.34 (Net Income / Net Sales) 20.03% 25.79% 22.79%
Panera Bread (In Millions)
2015 2016 2017 2015 2016 2017
Net Sales 691.77 727.11 727.63 (Net sales / Net Sales) 100.00% 100.00% 100.00%
Gross Profit 69.88 70.68 247.56 (Gross Profit / Net Sales) 10.10% 9.72% 34.02%
Net Income 43.16 44.01 42.49 (Net Income / Net Sales) 6.24% 6.05% 5.84%
Starbucks (In Billions)
2015 2016 2017 2015 2016 2017
Net Sales 19.15 21.31 22.38 (Net sales / Net Sales) 100.00% 100.00% 100.00%
Gross Profit 4.56 5.27 5.34 (Gross Profit / Net Sales) 23.81% 24.73% 23.86%
Net Income 2.76 2.82 2.88 (Net Income / Net Sales) 14.41% 13.23% 12.87%

Statement showing excel formulas :-

1 Yum! Brands, Inc (In Billic Common Size Income Statement 2015 6.44 3.44 1.29 2016 6.36 2.67 1.64 2017 5.88 2.69 1.34 2015 2016 2017 4 Net Sales 5 Gross Profit 6 Net Income (Net sales/Net Sales B4/B4 (Gross Profit/ Net Sales B5/B4 (Net Income / Net Sales) B6/B4 C5/C4 -c6/C4 D5/D4 -D6/D4 9 Panera Bread (In Million:s 10 2015 691.77 69.88 43.16 2016 727.11 70.68 44.01 2017 727.63 247.56 42.49 2015 2016 2017 (Net sales/Net Sales) Gross Profit / Net Sales) (Net Income/Net Sales B12/B12 B13/B12 B14/B12 C12/C12 -D12/D12 D13/D12 D14/D12 12 Net Sales 13 Gross Profit 14 Net Income 15 16 17 Starbucks (In Billions) 18 19 20 Net Sales 21 Gross Profit 22 Net Income -c13/C12 C14/C12 2015 19.15 4.56 2.76 2016 21.31 5.27 2.82 2017 22.38 5.34 2.88 2015 (Net sales/Net Sales B20/B20-C20/C20 D20/D20 (Gross Profit/ Net Sales B21/B20 C21/C20 D21/D20 (Net Income/Net Sales B22/B20 -C22/C20 D22/D20 2016 2017

Add a comment
Know the answer?
Add Answer to:
Complete a common size income statement (vertical analysis) for each of the following companies Yum! Brands,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Research further into the following companies using the school research databases, such as Hoovers database, or...

    Research further into the following companies using the school research databases, such as Hoovers database, or the company’s own website. Yum! Brands, Inc. Sales/Revenue: $5.88B Gross profit: $2.69B Net income: $1.34B Panera Bread Sales/Revenue: $2,8B Gross profit: $949.57M Net income: $145.57M Starbucks Sales/Revenue: 22.38B Gross profit: 5.34B Net income: 2.88B Answer the following: Are there any discontinued operations? If yes, what figures are reported? Write a short paper clearly identifying each of the required numbers and your explanation.

  • Research further into the following companies using the school research databases, such as Hoovers database, or...

    Research further into the following companies using the school research databases, such as Hoovers database, or the company’s own website. Yum! Brands, Inc. Sales/Revenue: $5.88B Gross profit: $2.69B Net income: $1.34B Panera Bread Sales/Revenue: $2,8B Gross profit: $949.57M Net income: $145.57M Starbucks Sales/Revenue: 22.38B Gross profit: 5.34B Net income: 2.88B Answer the following: Are there any discontinued operations? If yes, what figures are reported? Write a short paper clearly identifying each of the required numbers and your explanation.

  • Prepare a comparative common-size income statement for Jubilee Corporation. To an investor, how does 2017 compare...

    Prepare a comparative common-size income statement for Jubilee Corporation. To an investor, how does 2017 compare with 2016? Explain your reasoning. E (Click the icon to view the comparative income statement.) Data Table Start by calculating the percentages. (Round the percentages to two decimal places, X.XX.) Jubilee Corporation Comparative Common-Size Income Statement Income Statement For the Years Ended December 31, 2017 and 2016 For the Years Ended December 31, 2017 and 2016 2017 2016 (amounts in thousands) Sales revenues 100.00...

  • Common-Size Income Statements and Horizontal Analysis Income statements for Mariners Corp. for the past two years...

    Common-Size Income Statements and Horizontal Analysis Income statements for Mariners Corp. for the past two years are as follows: Sales revenue Cost of goods sold Gross profit Selling and administrative expense Operating income Interest expense Income before tax Income tax expense Net income (amounts in thousands of dollars) 2017 2016 $59,510 $49,980 41,940 30,320 $17,570 $19,660 9,430 4,900 $8,140 $14,760 1,760 1,760 $6,380 $13,000 2,190 4,250 $4,190 $8,750 Required: 1. Using the format in Example 13-5, prepare common-site comparative Income...

  • YUM! Brands, Inc., reports the following footnote relating to its capital and operating leases in its...

    YUM! Brands, Inc., reports the following footnote relating to its capital and operating leases in its 2015 10-K report ($ millions). Future minimum commitments under noncancelable leases are set forth below. At December 26, 2015, the present value of minimum payments under capital leases was $169 million. Commitments ($ millions) Capital Operating 2016 $20 $672 2017 20 620 2018 20 569 2019 20 516 2020 19 457 Thereafter 188 2,123 $287 $4,957 Confirm that the implicit rate on YUM!'s capital...

  • Common-Size Income Statements Following is the income statement for Target Corporation. Prepare Target's common-size income statement...

    Common-Size Income Statements Following is the income statement for Target Corporation. Prepare Target's common-size income statement for the fiscal year ended January 31, 2015 (Round your answers to one decimal place.) Fiscal year ended (5 millions) January 31, 2015 Sales revenue $72,618 Cost of sales 51,278 Selling, general and administrative expenses 14,676 Depreciation and amortization 2,129 Earnings from continuing operations before interest and income taxes 4,535 Net interest expense 882 3,653 Earnings from continuing operations before income taxes 1.204 Provision...

  • Required Information Problem 13-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 The following...

    Required Information Problem 13-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 The following information applies to the questions displayed below.) Selected comparative financial statements of Korbin Company follow KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2017, 2016, and 2015 2017 2016 2015 Sales $ 494,327 378,695 $ 262,800 Cost of goods sold 297,585 237,820 168,192 Gross profit 196,742 148,875 94,608 Selling expenses 70,194 52,260 34,690 Administrative expenses 44,489 33,325 21,812 Total expenses 114,683 85.585...

  • 133 CHAPTER 3 Financial Statements and Ratio Analysis Common-size statement analysis A common-size income statement for...

    133 CHAPTER 3 Financial Statements and Ratio Analysis Common-size statement analysis A common-size income statement for Enterprises' 2018 operations follows. Using the firm's 2019 income stater Creek ment P3-19 em 3-16, develop the 2019 common-size income statement and compare it with the 2018 statement. Which areas require further analysis and investigation? Creek Enterprises Common-Size Income Statement for the Year Ended December 31, 2018 100.0% 65.9 34.1 % Sales revenue ($35,000,000) Less: Cost of goods sold Gross profits Less: Operating expenses...

  • Requirements: - Complete the common-size for 2018 and 2017 for both the balance sheets and income...

    Requirements: - Complete the common-size for 2018 and 2017 for both the balance sheets and income statements (orange shaded areas). - Required; Round each answer to one decimal place (i.e. 46.3%) Rocky Road Bicycles, Inc. Comparative Balance Sheets December 31, 2018 and 2017 Rocky Road Bicycles, Inc. Income Statements For the Years Ended December 31, 2018 and 2017 2018 Common Size 2017 Common Size 2018 Common Size 2017 Common Size $ Assets Cash Account receivable Inventory Prepaid rent Plant assets...

  • Express the following comparative income statements in common-size percents. Using the common-size percentages, which item is...

    Express the following comparative income statements in common-size percents. Using the common-size percentages, which item is most responsible for the decline in net income? Complete this question by entering your answers in the tabs below. Income Reason for Statement Decline in Net Income Express the following comparative income statements in common-size percents. (Round your percentage answers to 1 decimal place.) GOMEZ CORPORATION Comparative Income Statements For Years Ended December 31 Current Year Prior Year $ % $ % Sales $...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT