I would think it's easiest to just take the two rows you have and paste them
down the column. So, base cost would be = previous row's total. Total
=total*(1+escalator) If it was 3 years per escalator, just enter the
escalator at the 3rd month and copy/paste the 3 rows all the way down the
column...

HTH

"Steve Hickman" wrote:

I am setting up the following as inputs to forecast rental costs across a
range of property:

Annual rental
Rent review frequency
Rent increase at review
Life of lease

I am struggling to put together a formula that will include the rent review
frequency. e.g. in the below example the rent review is after two years and
is 2.0%. However I need to include a formula so that x years after 2009 (and
x years after that etc with all x's the same length of period) the rent
increase escalator figure will be included based upon the rent review
frequency included in the inputs.

Year Base cost Escalator Total
2009 500,000 500,000
2010 500,000 500,000
2011 500,000 2.0% 510,000

Using Excel 2007