Jul 20, 2021 · 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.

Mar 19, 2025 · 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 …

Jun 7, 2005 · 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 …

Apr 12, 2024 · 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) …

Dec 7, 2017 · 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 …

Jun 18, 2015 · Similar Threads Calculate the CAGR By [email protected] in forum Excel Formulas & Functions Replies: 0 Last Post: 08-14-2008, 01:10 PM

Sep 6, 2005 · 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 …

Sep 6, 2005 · 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 …

Jan 6, 2006 · 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 …

Jul 17, 2014 · 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 …