View Single Post
  #2   Report Post  
Harlan Grove
 
Posts: n/a
Default

"Ajit Munj" wrote...
What is formula for CAGR (Compounded Annual Growth Rate)? e.g. if I take
a unit of Rs.10/- the price of which increases to Rs.13/- after 3 years,
what is the CAGR? Is there any readymade function to calculate CAGR in
Excel?


=(13/10)^(1/3)-1

Or if you believe you must use a formula,

=RATE(3,0,-10,13)