You can make a table like:
select B3 and fill down. You can, then, use these yearly numbers any way you like.
You can also use another method:
In this case I am using the first column to indicate the year after some starting year, cell B1 to be the starting profit (in year 0), and cell C1 to be the yearly increase:
select D1 and fill down
"^" means "to the power of". so 10^0 = 1, 10^1 = 10, 10^2 = 100
From the demonstrations I provided what is it you need to use the formulas in your table (which you have not shown)? Conceptually the 2nd method demonstrates computing the profit based on:
- an initial amount
- a yearly increase percentage, and
- the year
The only thing that that changes when you fill down in the formula is the year (in column A). I did this so you could see how the result changes with year.