cagr

Hi Everyone! Recently I received some very great assistance in realizing I was trying to calculate the compounded annual growth rate (CAGR) of two values. What I'd appreciate help with now is...how do you calculate CAGR without counting deposits? This is what I mean: Month #1 : starting bal...

Hi all, I have extracted a few tables from a large set of data into a new workbook with VBA. Next, I wrote a macro to copy/paste these tables into new sheets on the workbook. I know how to copy/paste ranges with macros but now I would want to figure out a way to calculate CAGR in a new column...

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...

Hi, I'm looking to calculate the CAGR of funds. The base sheet has multiple funds and I need an output which gives the CAGR of all invidually as well as cumulatively.Base File <colgroup><col><col><col><col><col><col><col></colgroup><tbody> Date FundName Number of Units NAV Total Investment...

Hi all. Can someone please tell me whether an excel formula exists to calculate a compound annual growth rate from a series of annual growth rates. For example, I have annual growth rates for ten years of the following: 3.0% 2.9% 2.7% 2.7% 2.7%2.6% 2.4% 2.5% 2.7% 2.8% If I calculate this...