Re: How to Calculate Compound annual growth rate* (CAGR) with negative ending RRI does not work when the return is in the negative, use the formula as per Ali's links.
Hi, Is there a function in excel 2007 to calculate CAGR, the Compound Annual Growth Rate? I know the formula to calculate it, and I can do it, but in my case it's messy. I can't find a function to do it neatly. The number of years is not an integer. Any ideas ? Is there a way of defining my own functions in excel 2007 ? Thx as always K Register ...
Formula to calculate the compound discount rate Evening all, This may well be a simple solution that I kick myself over, but how can I calculate the compound discount rate from a range of annual savings %'s?
calculating CAGR from two inputs; cumulative returns and years Hello, I'm looking for a quick way to calculate the compound annual growth rate by plugging one value (cumulative returns) into one cell and one other value (years) into another.
How can you calculate the CAGR (Compounded Annual Growth Rate)? Say I have 2 numbers and corresponding dates as follows; 1999 - $10000 2003 - $25000 How can I determine the compounded growth from just this information?
Re: Calculate the CAGR It's the final number divided by the earlier number raised to the power of 1 over the number of annual periods. Subtract 1 from that result to get the CAGR. In your case, assuming that both the amounts are beginning of period, the formula would be =25000/19000^ (1/4) - 1 "Bruce" <[email protected]> wrote in ...
Re: Calculate implied CAGR from group of total (cumulative) cash flows. Thanks Alan, This appears to be a standard CAGR formula, but the problem there is to do that CAGR will only consider the Year 0 and Year 3 cash flows, and not the cash flows in Years 1 and 2....
RE: How to calculate CAGR for mutual fund performance using XIRR In my subject line I stated that I was using XIRR, which is supposed to calculate CAGR. I am not good at math and don't know how to do it as you suggest (the ^ (1/3) ) part of the calculation. "bpeltzer" wrote: > )You didn't indcate what formula you used that generated the 46.82%.
