Percentage increase

[Guest]

hi just wondering if someone could help?

example todays cost £100 + 5% = £105 + 5% = £110.25 + 5% = £115.76 + 5% =
121.55 and so on is there a formula for doing the above in one cell?

any help appeciated

Paul

 

[Roger Govier]

Hi

The formula would be 100*1.05 to the power of the number of years you
require.

With £100 in A1, 5% in B1, 10 (or number of years) in C1 then in D1
=A1*(1+B1)^C1 will yield your result.

You can then alter the rate or number of years very easily by changing B1
and C1

 

[JE McGimpsey]

One way:

=100*(1+5%)^4

or

=100*1.05^4