I need to do a spreadsheet to increase for 10 years a 2.5 percentage

Question

I need to do a spreadsheet to increase for 10 years a 2.5 percentage for each amount how to do it please

Example:

1 2 3 4 5 6 7

1500.00 increase 2.5% 2.5% 2.5%

3643.00

Answer 1

I'm interpreting this as a year-over-year increase of 2.5%. For this purpose, you should make a column labeled "Year" starting at 0 and going to 10. In a second column, which you can label something like, "amount," enter your starting value next to year 0. Below your starting value, type: =, then click on the cell containing your starting value, which will give you a blue alpha-numeric character next to the =, then type *1.025. So that second cell in the column "amount" should have something like "=B2*1.025." When you press enter, this will give you your first value + 2.5%. To extend this through year 10, click on the second cell where you typed the formula and place your cursor over the bottom right corner of the cell until you see a black cross. Click and drag down until you reach the year 10 row. This will apply the formula to each year, thereby giving you a value for a 2.5% increase each year and the final value after 10 years. Hope this helps!