Calculating the sum of rents (with rent growth/decline) over a period of years

sorry..realised it was $1000 per month and if you want the gross rent for the fifth year, in which case

=12000*1.03^5

Or for the sum of all payments

=(12000/.03)*((1+.03)^5-1)

I would have said (because I'm not up on the Financial Formulas):
=E6*12+E6*(1+F6)*12+E6*(1+F6)^2*12+E6*(1+F6)^3*12+E6*(1+F6)^4*12
where E6 holds the original rent amount (1000) and F6 holds the percentage (3%)

This gives the same result as the FV() function

Originally Posted by shahabazik

Hi,

Can someone help with below requirement?

Initial rent - $100,000 per year
Increment after every 3 year - 5% on the current rent (i.e. 1st increment is $100,000*1.05 = $105,000; 2nd increment is $105,000*1.05 = $110,250 and so on)
Number of years 10

How can I get total amount by applying a single formula?

Thanks,

Administrative Note:

Hi and welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

I did supply an answer so when you've started your own thread I'll post it there.