Spreadsheet: 328277d1403852309-rental-expense-multiple-years-lease-commitment-disclosure-net
Sheet: Lease Template

Lease Commitments Database
Number | [NAME] | Lease Address | Occupant | Start Date | End Date | SQM | Rate per m2 | Escalation | Basic Rent | Op Costs | Gross Rent | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | ENQUIRIES:
1 | A |  |  | 2014-07-01 00:00:00 | 2016-06-01 00:00:00 | 78 |  | 0.075 | 14823.9 | 0
2 | B |  |  | 2014-07-01 00:00:00 | 2016-06-01 00:00:00 | 43 |  | 0.08 | 6880 | 0
3 | C |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 181 |  | 0.08 | 28960 | 0
4 | D |  |  | 2009-08-01 00:00:00 | 2014-07-01 00:00:00 | 72 |  | 0.075 | 15749.28 | 0
5 | E |  |  | 2013-10-01 00:00:00 | 2016-09-01 00:00:00 | 93 |  | 0.08 | 17484 | 0
6 | F |  |  | 2012-12-01 00:00:00 | 2017-11-01 00:00:00 | 732 |  | 0.08 | 74992.52 | 0
7 | A |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 530.933333333333 |  | 0.0803333333333333 | 58426.0546666667 | 0
8 | B |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 625.533333333333 |  | 0.0809047619047619 | 67553.0369523809 | 0
9 | C |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 720.133333333333 |  | 0.0814761904761905 | 76680.0192380953 | 0
10 | D |  |  | 2009-08-01 00:00:00 | 2014-07-01 00:00:00 | 814.733333333333 |  | 0.0820476190476191 | 85807.0015238096 | 0
11 | E |  |  | 2013-10-01 00:00:00 | 2016-09-01 00:00:00 | 909.333333333333 |  | 0.0826190476190476 | 94933.9838095239 | 0
12 | F |  |  | 2012-12-01 00:00:00 | 2017-11-01 00:00:00 | 1003.93333333333 |  | 0.0831904761904762 | 104060.966095238 | 0
13 | A |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 1098.53333333333 |  | 0.0837619047619048 | 113187.948380952 | 0
14 | B |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 1193.13333333333 |  | 0.0843333333333333 | 122314.930666667 | 0
15 | C |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 1287.73333333333 |  | 0.0849047619047619 | 131441.912952381 | 0
16 | D |  |  | 2009-08-01 00:00:00 | 2014-07-01 00:00:00 | 1382.33333333333 |  | 0.0854761904761905 | 140568.895238095 | 0
17 | E |  |  | 2013-10-01 00:00:00 | 2016-09-01 00:00:00 | 1476.93333333333 |  | 0.0860476190476191 | 149695.87752381 | 0
18 | F |  |  | 2012-12-01 00:00:00 | 2017-11-01 00:00:00 | 1571.53333333333 |  | 0.0866190476190476 | 158822.859809524 | 0
19 | A |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 1666.13333333333 |  | 0.0871904761904762 | 167949.842095238 | 0
20 | B |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 1760.73333333333 |  | 0.0877619047619048 | 177076.824380952 | 0
21 | C |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 1855.33333333333 |  | 0.0883333333333333 | 186203.806666667 | 0
22 | D |  |  | 2009-08-01 00:00:00 | 2014-07-01 00:00:00 | 1949.93333333333 |  | 0.0889047619047619 | 195330.788952381 | 0
23 | E |  |  | 2013-10-01 00:00:00 | 2016-09-01 00:00:00 | 2044.53333333333 |  | 0.0894761904761905 | 204457.771238095 | 0
24 | F |  |  | 2012-12-01 00:00:00 | 2017-11-01 00:00:00 | 2139.13333333333 |  | 0.0900476190476191 | 213584.75352381 | 0
25 | A |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 2233.73333333333 |  | 0.0906190476190476 | 222711.735809524 | 0
26 | B |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 2328.33333333333 |  | 0.0911904761904762 | 231838.718095238 | 0
27 | C |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 2422.93333333333 |  | 0.0917619047619048 | 240965.700380952 | 0
28 | D |  |  | 2009-08-01 00:00:00 | 2014-07-01 00:00:00 | 2517.53333333333 |  | 0.0923333333333333 | 250092.682666667 | 0
29 | E |  |  | 2013-10-01 00:00:00 | 2016-09-01 00:00:00 | 2612.13333333333 |  | 0.0929047619047619 | 259219.664952381 | 0
30 | F |  |  | 2012-12-01 00:00:00 | 2017-11-01 00:00:00 | 2706.73333333333 |  | 0.0934761904761905 | 268346.647238095 | 0
31 | A |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 2801.33333333333 |  | 0.0940476190476191 | 277473.62952381 | 0
32 | B |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 2895.93333333333 |  | 0.0946190476190476 | 286600.611809524 | 0
33 | C |  |  | 2013-07-01 00:00:00 | 2016-06-01 00:00:00 | 2990.53333333333 |  | 0.0951904761904762 | 295727.594095238 | 0
34 | D |  |  | 2009-08-01 00:00:00 | 2014-07-01 00:00:00 | 3085.13333333333 |  | 0.0957619047619048 | 304854.576380952 | 0
35 | E |  |  | 2013-10-01 00:00:00 | 2016-09-01 00:00:00 | 3179.73333333333 |  | 0.0963333333333334 | 313981.558666667 | 0
36 | F |  |  | 2015-12-01 00:00:00 | 2017-11-01 00:00:00 | 3274.33333333333 |  | 0.0969047619047619 | 323108.540952381 | 0