"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)
|