Hi,

Wondering if anybody knows a way to model this. I'm trying to prepare a rent forecast in 6 monthly splits where rents increase (compound) annually but paid monthly.

An example is we have a 5 yr rental lease with an annual increase of 10% per year and the rent is paid monthly. What would my total rents paid be after years 0.5, 1, 1.5, 2 etc (6 monthly splits)

Initially i was using the FV formula. It works fine for whole years, however it doesnt seem to make sense for any period less then a whole year.

For example i was expecting to see that after the first 6 months that the total rent paid would be $50,000. However the formula shows $48,809.

The formula that im using for the $48,809 is:-

=-FV(0.1,0.5,100000,,0)

Does anybody know what im doing wrong or know an alternative formula?

The results that i'm wanting to see is:-

Year 0.5 = $50,000
Year 1 = $100,000
Year 1.5 = $155,000
Year 2 = $210,000

keep in mind that this a really simple example because with leases, they do start mid month.

Thanks in advance