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...
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...
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.)
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.
- 2010 2011 2012 2013 2014 2015 2016 2017 2018 GREECE 129059 135314 153317 160986 168501...
- 2010 2011 2012 2013 2014 2015 2016 2017 2018 GREECE 129059 135314 153317 160986 168501 167036 175100 181261 190523 SPAIN 377095 403834 419865 397462 427672 447048 451255 485805 497812 FRANCE 316137 322254 303269 303031 298203 297880 292160 302840 308629 CROATIA 24329 21862 18972 19366 18603 18930 18551 20798 21573 ITALY 494091 499885 476823 457078 443141 458020 461990 475164 501958 Selected 5 ports. a) Calculate the mean, standard deviation, median, minimum, maximum values of gross weight of goods handled in...
Suppose you invest 70% of your portfolio in Coca Cola and the remainder in Pepsi. The...
Suppose you invest 70% of your portfolio in Coca Cola and the remainder in Pepsi. The expected dollar return on your Coca Cola investment is 14.1% and on Pepsi is 10.0%. The standard deviation of returns was 21% for Coca Cola and 17% for Pepsi. Assume a correlation coefficient of 0.8. Calculate the portfolio standard deviation.
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026...
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 BVPS, start of year 7 7.61 8.51 9.51 10.73 11.77 13.17 14.4 15.91 17.58 19.43 21.47 23.72 25.38 27.16 29.06 EPS 0.81 1.1 1.3 1.52 1.64 2 2.03 2.16 2.39 2.64 2.91 3.22 2.37 2.54 2.72 2.91 ROE 0.116 0.145 0.153 0.16 0.153 0.17 0.154 0.15 0.15 0.15 0.15 0.15 0.1 0.1 0.1 0.1 Payout Ratio 0.247 0.182 0.231 0.197 0.366 0.3 0.394 0.3...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT