ExcelBanter - View Single Post

[email protected]

wrote:
wrote:
I know how to calculate cagr though can someone please let me know if
this seems right for cagr with a six month lag?
((January 1, 1992 Value/July 1, 1991)^2)-1)*100
For some reason this has not been working for me...

Using your notation, try:

( ( (July 1 1992 value) / (January 1 1992 value) )^2 - 1 ) * 100

Note that you do not need "*100" if you are writing an Excel formula.
Simply format as Percentage with 2 decimal places, if you want (Format
Cells Number).

Thanks for the response, Joe, but I didn't have any luck... here is the
series I am working on.. and below it is the correct figures I should
be getting with a 6 mth lagged cagr..I've tried everything and am
becoming desperate..

7/1/91 12.4545
8/1/91 12.5732
9/1/91 12.6147
10/1/91 12.6572
11/1/91 12.8421
12/1/91 13.0317
1/1/92 13.208
2/1/92 13.3711
3/1/92 13.4381
4/1/92 13.6484
5/1/92 13.8817
6/1/92 14.0936
7/1/92 14.3233
***********************

1/1/92 12.90030006
2/1/92 13.01828899
3/1/92 13.09353062
4/1/92 15.52380093
5/1/92 15.84093727
6/1/92 15.45566734
7/1/92 15.58660109