Question

Coca-Colas worldwide sales as of December 31, 2011, was 26.7 billion cases. Assume the following sales distribution Unit Case Volume Eastern Europe Germany Spain Great Britain Italy France Other 20% 16% 14% 12% 9% 8% 21% If Coca-Colas worldwide growth were to continue at the same growth rate as it did in Germany between 1939 and 2008, when sales grew at the rate of 10.26%, its hypothetical sales in Spain in 2053 (42 years from 2011) would be approximately billion cases. (Note: For this question, ignore other factors that affect sales.)

Dropdown options:

Growth rate for

1934-1936: 105.7%, 45.89%, 102.86%, 79.28%

1936-1939: 85.92%, 65.10%, 102.86%, 311.5%

1934-1939: 79.28%, 65.10%, 205.7%, 108.54%

Next drop down: 313 mill, 149.42 mill, 5.41 mil, 2.62 billion

Next: 226.0, 203.4, 180.8, 271.2

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text aCopy в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard CS154 CQ Alignment Number Cells Edting CR CS CT CU CV CX CY cZ DA DB 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 44M C coca cola germany 1934 1936 243000 1000000 EXCEL FUNCTION USED years 1 rate 102.86% RATE(CT141,,-CT139,CT140) 1936 1939 1000000 4500000 years 2 rate 65. 1096 RATE(CT146,,-CT144,CT145) 1934 1939 243000 4500000 years 3 rate 79.28% RATE(CT151,,-CT149,CT150) CALCULATOR LOAN OP TIONS pv, fv, annuity CAP STRU VALUE BOX DILUTION DOLLAR CoST AVGMORTGAGE EXPO Sheeti Sheet2 ShelI rences: x261 07:52 16-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E ゴWrap Text ta copy ▼ в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard CT168 CQ Alignment Number Cells Edting CR CS CT CU CV cW CX CY cZ DA DB 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 4 sales in 1939 4500000 79.28% 6 S 1494,18,226 EXCEL FUNCTION USED rate years sales in 1945- answer FV(79.28%,6,,-CT154) 149.42 million 26.7 10.26% 5 sales in 2011 rate years sales in 2053 sales in spain 42 (2053-2011) $ 1,614.61 FV(CT161,CT162,,-CT160) $ 226.0 (14%* 1614.61) 44M C CALCULATOR LOAN OP TIONS pv, fv, annuity CAP STRU VALUE BOX DILUTION DOLLAR CoST AVGMORTGAGE EXPO Sheeti Sheet2 ShelI rences: x261 福 130% 07:53 16-01-2019

Add a comment
Know the answer?
Add Answer to:
Dropdown options: Growth rate for 1934-1936: 105.7%, 45.89%, 102.86%, 79.28% 1936-1939: 85.92%, 65.10%, 102.86%, 311.5% 1934-1939:...
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
  • Please help this is worth 25% of my final grade and is timed. Thank you!! 109...

    Please help this is worth 25% of my final grade and is timed. Thank you!! 109 IU Future value and present value concepts are applied in various ways, such as calculating growth rates, earnings per share, expected sales and revenues in the future, and so forth. Consider the following case: Pharmacist John S. Pemberton invented a soft drink in 1886 that eventually became not only an integral part of everyday life in the United States but also a symbol of...

  • 5. Companies and growth rates Aa Aa Future value and present value concepts are applied in...

    5. Companies and growth rates Aa Aa Future value and present value concepts are applied in various ways, such as calculating growth rates, earnings per share, expected sales and revenues in the future, and so forth. Consider the following case: Pharmacist John S. Pemberton invented a soft drink Germany was a growing market for Coca-Cola, along in 1886 that eventually became not only an integral with other countries in Europe, before world war 1. part of everyday life in the...

  • 6. Companies and growth rates Future value and present value concepts are applied in various ways,...

    6. Companies and growth rates Future value and present value concepts are applied in various ways, such as calculating growth rates, earnings per share, expected sales and revenues in the future, and so forth. Consider the following case: Pharmacist John S. Pemberton Invented a soft drink in 1886 that eventually became not only an integral part of everyday life in the United States but also a symbol of consumerism worldwide. In 1929 the first Coca-Cola vending machines were installed in...

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