Question

In: Accounting

Pepsi 2013 2014 2015 2016 2017 Sales/Revenue 66.42B 66.68B 63.05B 62.8B 63.53B Coca-Cola 2013 2014 2015...

Pepsi

2013

2014

2015

2016

2017

Sales/Revenue

66.42B

66.68B

63.05B

62.8B

63.53B

Coca-Cola

2013

2014

2015

2016

2017

Sales/Revenue

46.76B

46B

43.7B

41.38B

35.02B

Using the year 2013-2017 financial data of Coca-Cola and PepsiCo companies, determine their 5-year average growth rates related to net sales and income from continuing operations. Coca Cola: Net Sales: 7.86% Increase. PepsiCo: Net Sales: 3.11% Increase. And what data to use to calculate.

Solutions

Expert Solution

Pepsi

All amounts are in $ Billion

Year

2013

                        66.42

2014

                        66.68

2015

                        63.05

2016

                        62.80

2017

                        63.53

                     322.48

Average sales (322.48/5)

                        64.50

Changes in sales from 2013 (64.496 - 66.42)

                        (1.92)

Growth in sales {(1.924) x 100/66.42}

                        (2.90)

Decrease in net sales of Pepsi by 2.90% from 2013 in average sales.

Coca-Cola

All amounts are in $ Billion

Year

       2013

                   46.76

       2014

                   46.00

       2015

                   43.70

       2016

                   41.38

       2017

                   35.02

                 

                 212.86

Average sales (322.48/5)

                   42.57

Changes in sales from 2013 (64.496 - 66.42)

                   (4.19)

Growth in sales {(1.924) x 100/66.42}

                   (8.96)

Decrease in net sales of Coca cola by 8.96% from 2013 in average sales.


Related Solutions

2017 2016 2015 2014 2013 Sales $ 699,332 $ 466,221 $ 368,554 $ 252,434 $ 189,800...
2017 2016 2015 2014 2013 Sales $ 699,332 $ 466,221 $ 368,554 $ 252,434 $ 189,800 Cost of goods sold 352,166 234,761 187,327 128,167 94,900 Accounts receivable 33,918 27,227 25,283 14,767 13,001 Compute trend percents for the above accounts, using 2013 as the base year. Trend Percent for Net Sales: Choose Numerator: / Choose Denominator: / = Sales 2017: / = % 2016: / = % 2015: / = % 2014: / = % Trend Percent for Cost of Goods...
Innovative Components, Inc. reported the following income statement data for 2013-2017.    2017 2016 2015 2014 2013...
Innovative Components, Inc. reported the following income statement data for 2013-2017.    2017 2016 2015 2014 2013 Net Sales $3,144.6 $2,993.1 $2,790.5 $2,654.0 $2,478.9 What would be an appropriate sales growth rate based on the historical data?
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Revenue 4,500 6,860 8,409 9,082...
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Revenue 4,500 6,860 8,409 9,082 9,808 10,593 11,440 12,355 13,344 14,411 Revenue Growth 52.4% 22.6% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% Production Costs Fixed Production Expense (excl depreciation) 575 575 587 598 610 622 635 648 660 674 Variable Production Costs 2,035 3,404 4,291 4,669 5,078 5,521 6,000 6,519 7,079 7,685 Depreciation 152 152 152 152 164 178 192 207 224 242 Total Production Costs 0 2,762 4,131...
Exercise 17-3 Computation and analysis of trend percents LO P1 2017 2016 2015 2014 2013 Sales...
Exercise 17-3 Computation and analysis of trend percents LO P1 2017 2016 2015 2014 2013 Sales $ 441,811 $ 292,590 $ 239,828 $ 168,300 $ 127,500 Cost of goods sold 232,292 153,697 128,061 89,366 66,300 Accounts receivable 21,339 17,146 16,428 9,829 8,708
Years 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Retail Sales 5.2% 0.3%...
Years 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Retail Sales 5.2% 0.3% -3.3% 3.0% 4.9% 3.9% 3.1% 4.2% 3.8% 3.9% 3.6% e-commerce Sales 19% 4.1% 2.8% 17.1% 17.5% 14.9% 13.0% 14.6% 14.7% 14.0% 16.0% Does Retail Stores Growth Reduced by E-commerce Growth? Null Hypothesis: Ho: Retail stores growth doesn’t reduce by E-commerce growth. Alternative Hypothesis: Ha: Retail stores growth does reduce by E-commerce growth Do the chi-square test for goodness of fit. with the level of...
In the soda market we know that Pepsi Cola and Coca Cola are substitutes; suppose that...
In the soda market we know that Pepsi Cola and Coca Cola are substitutes; suppose that the demand for Pepsi Cola increases and, at the same time, the supply of the Coca Cola decreases significantly. Other things being equal, what would be the expectation of change in the Coca Cola market, if any? Question 15 options: The equilibrium quantity is expected to increase while the direction of the change in the equilibrium price is ambiguous. The equilibrium quantity is expected...
2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000...
2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000 Cost of goods sold 72,600 53,400 45,600 33,300 30,000 Dollar amounts stated above are in thousands. a. Compute trend percentages for the above items taken from the financial statements of Lopez Plumbing over a five-year period. Treat 2014 as the base year. b. State whether the trends are favorable or unfavorable. Required A Required B Compute trend percentages for the above items taken from...
2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200...
2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200 Cost of goods sold 332,087 214,419 173,535 120,176 88,788 Accounts receivable 32,560 25,434 23,715 14,180 12,376 Compute trend percents for the above accounts, using 2014 as the base year. (Round the percents to whole numbers.)
In 2013, TCCC introduced “Coca-Cola Life” to the family of Coca-Cola brands (i.e., Classic, Diet, and...
In 2013, TCCC introduced “Coca-Cola Life” to the family of Coca-Cola brands (i.e., Classic, Diet, and Zero). While Coke Life is available in the U.S., it has been gradually rebranded into “Coca-Cola Stevia” in some markets, including Australia (since 2017), New Zealand (since 2018), and Singapore (since 2018). Compare these two (2) branding strategies in terms of their potential to achieve stronger brand equity.
Time series is given: Year 2012 2013 2014 2015 2016 2017 2018 2019 Amount 65 61...
Time series is given: Year 2012 2013 2014 2015 2016 2017 2018 2019 Amount 65 61 73 68 67 72 75 70 Calculate and interpret the characteristics of it; Make the time series next value forecast by using any method.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT