Adding Percentages from year to year

[Donna Bradshaw]

Hi All,

Looking for a formula that calculates the price with percentage increase year on year.

So when year 1 price is 10.00 in year 2 this goes up 1% so becomes 11.00, then year 3 goes up 1% so the price becomes 12.10 and so on.

If you can help on this that would be great.

Cheers

Donna

 

[Marc L]

Hi !

Welcome Donna to this forum !​

So when year 1 price is 10.00 in year 2 this goes up 1% so becomes 11.00

Wrong ‼ 10 + 1% = 10.1 …

Formula for example ={cell address}*1.01
​

 

[Chihiro]

Is it consistent rate or variable?

 

[Hui]

Assuming:



C6: =-FV(C3,C4,0,C2)