Compound annual growth rate [CAGR]

Does anybody have the excel formula for CAGR?

=rate
or
=(EndValue/StartValue)^(1/YearÂ*s)

--
Don Guillett
SalesAid Software
[email protected]
"Paul" <[email protected]> wrote in message
news:[email protected]...
> Does anybody have the excel formula for CAGR?

Don,

If you wanted the CAGR wouldn't you apend a -1 to your formula?
=(EndValue/StartValue)^(1/3)-1
e.g (15000/10000)^(1/3)-1 = 14.47%
otherwise you get 114.47%.

Maybe just another way to look at it?

Best Regard,
Kem

"Don Guillett" wrote:

> =rate
> or
> =(EndValue/StartValue)^(1/YearÂÂ*s)
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Paul" <[email protected]> wrote in message
> news:[email protected]...
> > Does anybody have the excel formula for CAGR?
>
>
>