Does anyone know how to use thinkscript to calculate compound annual growth rates?
on excel, the formula is something like this
=RRI(A7,B2,B7)
where A7 = how many years
B2 = start value
B7 = end value
so for example, lets say i want to calculate the 5 year CAGR rate for aapl. lets say aapl 5 years ago was 50, and the current price is 100.
if you plugged into this formula, it says that AAPL had an annual compounded growth rate of 14.87% each year for 5 years
thanks
eugene
CAGR formula in Excel: https://www.excel-easy.com/examples/cagr.html
on excel, the formula is something like this
=RRI(A7,B2,B7)
where A7 = how many years
B2 = start value
B7 = end value
so for example, lets say i want to calculate the 5 year CAGR rate for aapl. lets say aapl 5 years ago was 50, and the current price is 100.
if you plugged into this formula, it says that AAPL had an annual compounded growth rate of 14.87% each year for 5 years
thanks
eugene
CAGR formula in Excel: https://www.excel-easy.com/examples/cagr.html