% yearly formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

S - 20 Mar 2008 08:31 GMT

I am looking to work out a % increase (for rent) formula over a few years.

eg rent today is £40 per week currently
At 5% increase each year
What will rent be in say 10 years time?

Rather than a seperate post I also want to work out the interest on a loan
from say 7 years ago
£7500 at average say 5% per year
What interest was paid?

I assume this will be a similar formula but just change some figures?

thanks

Reply to this Message

Bernard Liengme - 20 Mar 2008 13:01 GMT

Q1 can be answered with the future value FV function (use 0 for PMT, and -40
for PV)
Q2 with the IPMT function

But Q1 can be done with simple math
Year 0 £40
Year 1 =last year plus 5% = £40(1+5%)
Year 2 = (£40(1+5%))(1+5%) = £40(1+5%)^2
and so on
At year 5 I get £51.05 which when I lived in UK was written as £51/1/0
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

>I am looking to work out a % increase (for rent) formula over a few years.
>
[quoted text clipped - 10 lines]
>
> thanks

Reply to this Message

Rate this thread: