I've created a pair of tables to calculate the CAGR (Compound Annual Growth Rate) over a period of time.
The way I've done it is by doing a first table that uses the actual annual returns to figure out what the compounded dollar value would be based on the actual historic annual returns. A second table matches the last entry which gives me the CAGR percentage it would have taken to achieve that end dollar value. Do you know how I could get excel to automatically match the dollar value in the first table by automatically adjusting the percentage cell until the 2 numbers are a match rather than manually adjusting the percentage cell MANY times manually. (It might be helpful if you saw the tables let me know if you would like to see them).
Thanks
The way I've done it is by doing a first table that uses the actual annual returns to figure out what the compounded dollar value would be based on the actual historic annual returns. A second table matches the last entry which gives me the CAGR percentage it would have taken to achieve that end dollar value. Do you know how I could get excel to automatically match the dollar value in the first table by automatically adjusting the percentage cell until the 2 numbers are a match rather than manually adjusting the percentage cell MANY times manually. (It might be helpful if you saw the tables let me know if you would like to see them).
Thanks
Last edited:
