an easier way is use the x^y function on any calculatorI don't do it in any fancy way, probably a mathematician who can show something more elegant...
A1 = starting price
B1 = starting price * 1.01
A2 = B1
B2 = fill-down from B1
Fill down... A2 and B2 for as many days as you want.
I stand corrected on the terminology...
View attachment 311182
0.1% = 1.001
Raise 1.001 to the 3,650 power (10 years) = 38.4
OR
raise 1.001 to the 2,500 power (10 years of trading days) = 12.167
multiply by stock price using either 38.4 or 12.167
38.4 * present stock price = ~$13,700 (YeeHaw!!)