How do I calculate CAGR in Excel?

[David Biddulph]

CAGR = ((FV/PV)^(1/n)) - 1
where FV is the future value, PV is the present value, and n is the number
of years.

(and next time, please ask your question in the body of the message, not
just in the subject line)

 

[joeu2004]

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.