Question

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 United States but also a With the previous data given, calculate the symbol of consumerism worldwide. In 1929 the first cmpany's sales growth rate for each time period in Coca-Cola vending machines were installed in Germany, and in 1930, the German branch of the Coca-Cola Co. opened in Essen. the following table Years 1934-1936 1936-1939 1934-1939 Growth Rate Coca-Cola sales in Germany were 243,000 cases in 1934, 1 million cases in 1936, and 4.5 million cases in 1939

Answer 1

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

Home ert Page Layout Formulas Data Review V s Cut ta copy." Add-Ins Σ AutoSum , Fill В า 프. m. a-Δ. Ξミ 迣锂函Merge & Center. $, % , 弼皛 Conditional Format C Formatting Insert Delete Format Format Painter Sort &Find & Filter Select ed as Table* Styles* 2 Clear , , , Clipboard Font Alignment Cells dting CR154 CP CQ CR CS CT CU CX CY 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 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-10% RATE(CT146,-CT144,CT145) 1934 1939 243000 4500000 years 3 rate 79.28% RATE(CT151,,-CT149,CT150) ,1 | CALCULATOR .. LOAN OPTIONS CAP STRU VALUE BOX DILUTION DOLLAR COST AVG MORTGAGE EXPO Sheet1 Sheet2 Shel erences: X261 21-02-2019

Home ert Page Layout Formulas Data Review V 義Cut ta copy." Add-Ins 短 AutoSum Fill В า 프. m. a-Δ. Ξミ 迣锂函Merge & Center. $, % , 弼皛Conditional Format. Cell. Insert Delete Format Sort &Find & Filter Select Format Painter 袖 Formatting ▼ as Table-styles ▼ 2 Clear , ▼ ▼ ▼ Clipboard Font Alignment Cells dting CR167 Formula Ba CP CQ CR CS CT CU CV CY 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168.42) 169 170 4 sales in 1939 4500000 79.28% 6 1494,18,226 rate EXCEL FUNCTION USED years FILL IN THE BLANK sales in 1945 FV(79.28%,6,,-CT154) answer 149.42 million 5 sales in 2011 26.7 10.26% rate years sales in 2053 SALES IN SPAIN 42 (2053-2011) 1,614.61 FV(CT161, CT162,,-CT 160) $ 226.04 (14%* 1614.61) 11 -1 CALCULATOR LOAN OPTIONS | pv, fv BOX DILUTION DOLLAR COST AVG MORTGAGE EXPO Sheet1 Sheet2Shl CAP STRU VALUE erences: X261 21-02-2019