Increasing by 1, with different start times

[jlucky44]

Hi Everyone,

I'm working on a Rent Roll for a Real Estate Underwriting Model. In included growth rates in my model, which have different start dates depending on when a lease is rolling over. Since I'm multiplying my base rent with a rate and want to increase the base rent with the same growth rate by period I need to use some sort of power function (^1,^2,^3 etc.). Does anyone know a way to increase (^1 by one for each period, the challenge is that the start date of the growth rate is different so that it should start counting periods whenever a date was triggered, I thought about the counta function, but not really sure how to apply it.

 

[oldbrewer]

not sure what you mean - try and explain it more clearly, eg assume rents go up 5% per year so if somebody rents half way through year 1 should their rent be fixed for 6 months and then raised by 5% or fixed for 12 months then increased by 5% or even 5% plus a factor..............