CAGR Compound Annual Growth Rate


 CAGR = (END_VALUE / BEGIN_VALUE)^(1/n) - 1

ref http://www.12manage.com/methods_cagr_ko.html

in Excel

 =RATE(A3,,-A1,A2) 

 where A1 contains the starting amount, A2 the ending amount and A3 the number of years.

from : http://www.mrexcel.com/archive2/68400/79239.htm
powered by MoniWiki Powered by FreeBSD DNS Powered by DNSEver.com
last modified 2006-11-03 18:10:51
Processing time 0.0515 sec