Calculating Compounding Rent Increases

You don't use 'Rent Roll'!$H5 in your calucluations.

Is that problem? because there is no increasing.. Just 12/12 multiplying

Yes, I have only used the H column in my "desired outcome" table. The problem with the "desired outcome" table is that it does not calculate the increases automatically...I put them all in manually, which is not feasible on a much bigger and complicated model.

I have figured out the way for the rent to be placed in the proper month in the cash flow. What I have not figured out is how to then show the rent increasing in the Cash Flow (based upon the amount in Column H of the Rent Roll) on each anniversary of the commencement of the lease (or twelve cells later).

Does this make sense?

I ran into the same issue and created a 12 month rent roll I then tied the CF into the rent roll based on month. You could also integrate a formula which would allow you to enter lease start and/or end dates for the current year. This is helpful to model concessions or mid year move-ins, or move outs if you don't expect to lease up the space.

Could you please elaborate...I am not sure I understand what you are describing.

Thank you,

Add an additional 13 columns to your rent roll. The 1st column would be a number from 1-12 to indicate when your increase would occur. The next 12 would be representative of the months in a year. You'd then write an IF statement to determine whether or not to perform the increase calculation.

See attached