How did this person get the values in the purple excel cells? 1996 Russia production 222,900 1997

How did this person get the values in the purple excel cells?

Transcribed Image Text:

1996 Russia production 222,900 1997 1998 252,700 323,000 1999 2000 2001 363,700 348,000 363,700 Ice-Fili production 15,000 26,000 27,500 22.000 20,000 19.000 Ice-Fili market share 6.7% 10.3% 8.5% 6.0% 5.7% 5.2% Nestle production Nestle market share 9.500 4% 13,000 4% 15,467 4.3% 16,000 5% 19,036 5.2% Notes. 1. Compound Annual Growth Rate (CAGR) = (value year y/value year x)^(1/(y-x)) -1 2. Russia and Ice-Fili CAGR (1997-2001). Nestle CAGR based on data available (1997- 3. Production figures given in thousands of tons. 1996 Russia production 222,900 1997 1998 252,700 323,000 1999 2000 2001 363,700 348,000 363,700 Ice-Fili production 15,000 26,000 27,500 22.000 20,000 19.000 Ice-Fili market share 6.7% 10.3% 8.5% 6.0% 5.7% 5.2% Nestle production Nestle market share 9.500 4% 13,000 4% 15,467 4.3% 16,000 5% 19,036 5.2% Notes. 1. Compound Annual Growth Rate (CAGR) = (value year y/value year x)^(1/(y-x)) -1 2. Russia and Ice-Fili CAGR (1997-2001). Nestle CAGR based on data available (1997- 3. Production figures given in thousands of tons.