Spreadsheet: 139955d1328557731-finding-cagr-compounded-annual-growth-rate-cagr-sample
Sheet: Sheet1

Compound growth (%) | [NAME] listed (20) | 2011FYE | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 | 1998 | 1997 | 1996 | 1995 | 1994 | 1993 | 1992 | 1991 | 1990
#[NAME]? | 21 | 26478 | 19618 | 13029 | 27678 | 18075 | 13995 | 10700 | 8708 | 8782 | 7237 | 19436 | 59373 | 6112 | 17602 | 13765 | 11125 | 10113 | 9781 | 6218 | 5289 | 3600
#[NAME]! | 21 | 10332 | 8196 | 10423 | 10608 | 9900 | 11368 | 8614 | 7687 | 7104 | 7257 | 5768 | 8329 | 8138 | 5774 | 4836 | 5674 | 4206 | 3552 | 3173 | 2848 | 2322
#REF! | 21 | 5584.8 | 5275.1 | 4302.5 | 9269.6 | 5862.6 | 5281.4 | 3286.8 | 3050.8999 | 3047.7 | 3182.7 | 3131 | 2898.5 | 2655.8999 | 2283.3 | 1946.1 | 1635.5 | 1367.9 | 1135.6 | 936.1 | 778.7 | 648.2
#REF! | 21 | 35750 | 19256 | 6247 | 13143 | 10757 | 13888 | 12677 | 3043 | 2259 | 2519 | 2494 | 3511 | 1871 | 1882.7 | 2238.5 | 3604.8 | 3100.6001 | 2725.7 | 2051.3999 | 1480 | 1415.2
#REF! | 21 | 7194 | 6697 | 8029 | 7448 | 6842 | 8562 | 6256 | 6057 | 6624 | 6507 | 5535 | 5286 | 4967 | 4709 | 4154 | 4186 | 3848 | 3380 | 3050 | 2342 | 1930
#REF! | 13 | -56.17 | -49.84 | -15.261 | 28.891 | 11.315 | 13.845 | 45.684 | -42.731 | -73.404 | 34.116 | 42.614 | 9.073 | 26.013
#REF! | 18 | 1926 | 1506 | 1272 | 1503 | 1252 | 1595 | 1556 | -6100 | -7762 | 1343 | -129297 | 346.805 | -62.038 | -5.021 | 12.813 | 20.403 | 26.758 | 15.394
#REF! | 13 | 54.796 | 6.368 | -216.317 | -40.067 | 1.673 | -18.619 | -56.269 | 0.551 | -7.503 | 41.148 | 25.955 | 20.947 | 14.189
#REF! | 22 | 3529 | 13139 | 2637.9 | 7516.3 | 4785.9 | 2832.6 | 4643.7 | 2543.6 | 387.2 | 691.8 | 744.5 | 873.1 | 1265.4 | 1029.1 | 2520 | 2275.2 | 2160.3999 | 1952.1 | 1561.8 | 1302.9 | 1115 | 770
#REF! | 19 | 14917 | 13138 | 14099 | 18242 | 12038 | 11342 | 11364 | 9539 | 9920 | 10114 | 10014 | 8307 | 6788 | 9363 | 8487 | 7984 | 7415 | 6702.2002 | 5697.6001
#REF! | 21 | 15820 | 5541 | 15473 | 9817.7 | 13548.7 | 10852.8 | 6173.343 | 2032.573 | 2153.1489 | 4394.0098 | 5829.3472 | 5422.9771 | 4925.3271 | 9616.1328 | 8361.5518 | 7028.0791 | 6038.002 | 4006.821 | 2436.96 | 2003.106 | 1744.021
#REF! | 21 | 20038 | 13631 | 12681 | 30600 | 20030 | 14343 | 12978 | 11677 | 14362 | 11980 | 34118 | 117345 | 8706 | 12266 | 12020 | 9567 | 8021 | 6304 | 3052 | 4340 | 4370
#REF! | 21 | 3844 | 2914 | 1594 | 3949 | 3098.789 | 4120.555 | 608.642 | 535.792 | 533.445 | 600.343 | 850.173 | 1203.958 | 1139.271 | 1178.291 | 1349.037 | 1225.024 | 1063.78 | 1501.719 | 980.203 | 710.503 | 595.794
#REF! | 14 | 284.336 | 192.169 | -79.249 | 76.098 | 37.14 | 41.817 | 40.529 | 39.02 | 9.578 | -9.178 | 33.115 | 35.901 | 28.874 | 10.436
#REF! | 22 | 48097 | 30039 | 10356 | 27602 | 21226 | 19850 | 17900 | 6923 | 6370 | 8519 | 8330 | 10822 | 9278 | 7260 | 14159.9961 | 11039 | 10363 | 8819 | 6692 | 4681 | 3350 | 2465
#REF! | 22 | 9153.9 | 12398.6 | 2083.5 | 9685.7 | 4312.9 | 1059.8 | 2702.7 | -976.2 | -4707.7002 | 1275.4 | 46.4 | 215 | 1328.4 | 2142.8999 | 5312 | 4157.7002 | 3410.8999 | 4296.2998 | 3461.7 | 2363.0271 | 1168.189 | 1093.183
#REF! | 22 | 291.277 | 307.492 | 379.972 | 311.586 | 123.068 | 126.583 | 302.222 | 438.797 | 343.548 | 303.328 | 268.998 | 42.816 | -138.15 | 228.303 | 208.61 | 25.078 | 404.962 | 471.905 | 420.221 | 203.8 | 201.462 | 205.559
#REF! | 21 | 38252 | 21893 | 5853 | 26260 | 22566 | 18757 | 18818 | 4922 | 5377 | 4118 | 3893 | 4435 | 1763 | 6678 | 7654 | 6454 | 5561 | 4658 | 4418.6001 | 3079.7 | 2449.6001
#REF! | 21 | 20194 | 10459 | 3432 | 6310 | 10316 | 8337.4 | 2302.6 | 34.7 | 546.6 | 523.3 | 864.4 | 657.4 | 1449 | 2535.5 | 2459.2 | 2306 | 2204.6001 | 1468.3 | 976.5 | 1142.6 | 1028.4
#REF! | 16 | -5.182 | -2.763 | -13.026 | -5.721 | -326.8 | -78.7 | -249.7 | -21.2 | -5.4 | 29.6 | 9 | 32 | 31.7 | 58.2 | 52.3 | 15.4
#REF! | 19 | 3.231 | 1.713 | 14.066 | -11.619 | -92.304 | -108.876 | -132.625 | -12.403 | -129.549 | -183.458 | -274.743 | 83.465 | -533.215 | 122.864 | 244.186 | 170.355 | 279.184 | 236.905 | 58.719
#REF! | 18 | 4224 | 2604 | 39 | 4143.604 | 3434.511 | 2748.725 | 2347.709 | 1921.714 | 1269.786 | 1599.806 | 1887.078 | 1488.889 | 819.856 | 2083.103 | 1879.53 | 1641.24 | 1542.28 | 1112.355
#REF! | 19 | 549.444 | -4.646 | -148.808 | 86.307 | 149.38 | 72.745 | 34.991 | -89.71 | 76.851 | 30.133 | 5.474 | 82.196 | 10.321 | 57.51 | 75.313 | 130.417 | 180.516 | 72.239 | 34.722