Spreadsheet: 182754d1348593443-rate-formula-example-1
Sheet: Sheet1

 | CAGR 1998-2011
Australia
Brazil
Canada
Chile
China
France
Germany
India
Indonesia
Italy
Japan
Poland
Spain
U.S.
U.K.
Country/Region | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
Australia | 18.711 | 18.926 | 19.153 | 19.413 | 19.651 | 19.895 | 20.127 | 20.395 | 20.698 | 21.072 | 21.432 | 21.875 | 22.2 | 22.53
Belgium | 10.214 | 10.239 | 10.263 | 10.31 | 10.355 | 10.396 | 10.446 | 10.51 | 10.59 | 10.6 | 10.61 | 10.62 | 10.63 | 10.64
Brazil | 165.6 | 167.7 | 169.799 | 171.9 | 174 | 176.1 | 178.2 | 180.3 | 182.4 | 184.5 | 186.5 | 188.6 | 190.756 | 192.8
Canada | 30.114 | 30.384 | 30.667 | 30.967 | 31.282 | 31.609 | 31.944 | 32.283 | 32.612 | 32.964 | 33.347 | 33.694 | 34.036 | 34.37
Chile | 14.997 | 15.197 | 15.398 | 15.572 | 15.746 | 15.919 | 16.093 | 16.267 | 16.433 | 16.598 | 16.763 | 16.929 | 17.094 | 17.25
China | 1223.313 | 1234.857 | 1245 | 1252 | 1258 | 1263 | 1270 | 1276 | 1283 | 1290 | 1297 | 1305 | 1313 | 1321
Euro Area | 310.7 | 311.6 | 312.8 | 315.1 | 317 | 319 | 320.8 | 322.9 | 324.5 | 326 | 327 | 327.9 | 328.7 | 329.6
France | 58.381 | 58.653 | 59.034 | 59.456 | 59.866 | 60.284 | 60.705 | 61.15 | 61.57 | 61.95 | 62.28 | 62.61 | 62.95 | 63.29
Germany | 82.037 | 82.163 | 82.26 | 82.44 | 82.537 | 82.532 | 82.501 | 82.438 | 82.315 | 82.218 | 82.002 | 81.802 | 81.709 | 81.67
Hong Kong | 6.5446 | 6.5993 | 6.6587 | 6.7134 | 6.7625 | 6.8097 | 6.8551 | 6.8987 | 6.9404 | 6.9804 | 7.0186 | 7.0551 | 7.0897 | 7.1225
India | 969.153 | 986.477 | 1004.124 | 1021.967 | 1039.691 | 1057.504 | 1075.473 | 1093.563 | 1111.714 | 1129.866 | 1148 | 1166 | 1184 | 1202
Indonesia | 207.534 | 210.72 | 213.829 | 216.937 | 220.019 | 223.07 | 226.004 | 228.896 | 231.82 | 234.694 | 237.512 | 240.272 | 242.968 | 245.6
Italy | 56.853 | 56.87 | 56.985 | 57.201 | 57.499 | 57.866 | 58.263 | 58.672 | 59.082 | 59.495 | 59.893 | 60.252 | 60.55 | 60.79
Japan | 126.246 | 126.494 | 126.729 | 126.972 | 127.187 | 127.358 | 127.48 | 127.537 | 127.515 | 127.433 | 127.288 | 127.1 | 126.8 | 126.5
Mexico | 97.325 | 98.617 | 99.927 | 101.247 | 102.48 | 103.718 | 104.96 | 106.203 | 107.45 | 108.701 | 109.955 | 111.212 | 112.469 | 113.824
Netherlands | 15.654 | 15.76 | 15.864 | 15.987 | 16.105 | 16.193 | 16.258 | 16.306 | 16.334 | 16.358 | 16.405 | 16.486 | 16.575 | 16.66
New Zealand | 3.8312 | 3.8509 | 3.873 | 3.9162 | 3.9895 | 4.0616 | 4.1142 | 4.1607 | 4.211 | 4.2559 | 4.301 | 4.344 | 4.388 | 4.434
Poland | 38.374 | 38.331 | 38.293 | 38.251 | 38.23 | 38.205 | 38.183 | 38.166 | 38.141 | 38.121 | 38.112 | 38.164 | 38.206 | 38.18
Singapore | 3.9272 | 3.9587 | 4.0279 | 4.138 | 4.176 | 4.1148 | 4.1667 | 4.2658 | 4.4014 | 4.5886 | 4.8394 | 4.985 | 5.077 | 5.2017
South Korea | 46.287 | 46.617 | 47.008 | 47.389 | 47.64 | 47.874 | 48.03 | 48.14 | 48.439 | 48.643 | 49.006 | 49.195 | 49.424 | 49.757
Spain | 39.639 | 39.803 | 40.05 | 41.117 | 41.838 | 42.717 | 43.198 | 44.109 | 44.709 | 45.2 | 45.53 | 45.76 | 45.92 | 46.13
Taiwan | 21.834 | 22.008 | 22.183 | 22.336 | 22.451 | 22.543 | 22.622 | 22.701 | 22.782 | 22.859 | 22.921 | 22.974 | 23.025 | 23.07
United Kingdom | 58.475 | 58.684 | 58.886 | 59.113 | 59.319 | 59.552 | 59.842 | 60.235 | 60.584 | 60.986 | 61.398 | 61.792 | 62.262 | 62.72
United States of America | 275.854 | 279.04 | 282.172 | 285.082 | 287.804 | 290.326 | 293.046 | 295.753 | 298.593 | 301.58 | 304.375 | 307.007 | 309.4 | 311.8
Vietnam | 77.092 | 78.09 | 79.06 | 79.999 | 80.908 | 81.791 | 82.663 | 83.536 | 84.4 | 85.26 | 86.12 | 86.97 | 87.81 | 88.66