How do I calculate CAGR in Excel?
On Feb 21, 7:40 am, "David Biddulph" wrote:
CAGR = ((FV/PV)^(1/n)) - 1
where FV is the future value, PV is the present value, and n is the number
of years.
Another way, which might be easier to remember:
=rate(n, 0, -pv, fv)
However, sometimes Excel's RATE() function requires a "guess"
argument :-(.
In either case, note that that depends on the information that you
have at hand. For example, that is __not__ how to compute CAGR if all
you have is the annual growth rates for N years -- or 12*N months.
(and next time, please ask your question in the body of the message, not
just in the subject line)
I second that. Invariably, the subject deserves some embellishment
such as more information, as suggested by my comment above.
|