Spreadsheet: 181902d1348190043-horizontal-extrapolation-of-a-rent-roll-sheet-after-expiry-of-the-actual-rent-horizontal-extrapolation-of-a-rent-roll-sheet-after-expiry-of-the-actual-rent
Sheet: Blad1

Year : |  |  | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013
Month : |  |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00
Period : |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
Tenant1
Rent roll : |  |  | 0 | 0 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Rent rebate : |  |  | 0 | 0 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal : |  |  | 0 | 0 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
how it should work |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500
Tenant1
Rent roll : |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 0 | 0 | 0 | 0 | 0 | 0
Rent rebate : |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal : |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 0 | 0 | 0 | 0 | 0 | 0
how it should work |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500
Tenant1
Rent roll : |  |  | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Rent rebate : |  |  | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal : |  |  | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
how it should work |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500
Rent roll : |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Rent rebate : |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal : |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
how it should work |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
inflation | 0.05
 | the 12.500 should be multiplied with a fixed rate in a fixed cell like in B34