Spreadsheet: 162235d1339772273-excel-2007-formula-issue-occupancy-schedule-budget-template-excel-formula-question
Sheet: RentRoll

Rent Roll |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00 | 2013-12-31 00:00:00
Property: 1944 From Date: 06/04/2012 By Property |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Renewal | Renewal |  |  |  |  |  |  |  |  |  |  |  | Yes
Property | Unit(s) | Lease | Lease Type | Area | Lease From | Expiration Date | Term | Monthly | Monthly | Annual |  |  |  |  |  |  | 2012 | 2013 |  |  | Renewal Start |  | 2012/13 [NAME] |  | Start | End |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | Rent | Rent | Rent |  |  |  |  |  |  | Helper | Helper |  |  | Date |  | Assumption |  | Date | Date
 |  |  |  |  |  |  |  |  | Per Area
1944 - Property Name
Current Leases
1844 | 100A | ABC Corp | Office - Net | 807 | 2010-04-01 00:00:00 | 2014-01-31 00:00:00 | 46 | 0 | 0 | 0
1844 | 110 | XXX Inc. | Office - Net | 5222 | 2009-09-01 00:00:00 | 2016-04-30 00:00:00 | 80 | 7941.79 | 1.52 | 95301.48
1844 | 112 | [NAME] | Office - Net | 915 | 2009-10-01 00:00:00 | 2016-09-30 00:00:00 | 84 | 1429.69 | 1.56 | 17156.28
1844 | 118 | Big Corp | Office - Net | 2038 | 2009-04-01 00:00:00 | 2014-03-31 00:00:00 | 60 | 3461.2 | 1.7 | 41534.4
1844 | 120 | Black Fest | Office - Net | 868 | 2010-03-01 00:00:00 | 2013-02-28 00:00:00 | 36 | 1428.58 | 1.65 | 17142.96 |  |  |  |  |  |  |  |  |  |  |  |  | No
1844 | 150 | Manna Money | Office - Net | 1069 | 2009-06-01 00:00:00 | 2014-09-30 00:00:00 | 64 | 1692.58 | 1.58 | 20310.96
1844 | 170 | Tile Source | Office - Net | 3294 | 2007-10-29 00:00:00 | 2013-09-30 00:00:00 | 72 | 5009.63 | 1.52 | 60115.56 |  |  |  |  |  |  |  |  |  |  |  |  | Yes
1844 | 200 | XPC Conference | Office - Net | 2860 | 2010-02-01 00:00:00 | 2013-01-31 00:00:00 | 36 | 4766.67 | 1.67 | 57200.04 |  |  |  |  |  |  |  |  |  |  |  |  | Yes
1844 | 205 | HHH Inc. | Office - Net | 1996 | 2009-11-01 00:00:00 | 2012-12-31 00:00:00 | 38 | 3326.67 | 1.67 | 39920.04 |  |  |  |  |  |  |  |  |  |  |  |  | No
1844 | 210 | YYY Inc. | Office - Net | 1695 | 2006-06-01 00:00:00 | 2015-08-31 00:00:00 | 111 | 2542.5 | 1.5 | 30510
1844 | 220 | ZZZ Inc. | Office - Net | 4097 | 2009-12-01 00:00:00 | 2017-06-30 00:00:00 | 91 | 6290.5 | 1.54 | 75486
1844 | 240 | DBA Corp | Office - Net | 1500 | 2010-06-01 00:00:00 | 2013-09-30 00:00:00 | 39 | 2531.25 | 1.69 | 30375 |  |  |  |  |  |  |  |  |  |  |  |  | No
1844 | 245 | LLL Corp | Office - Net | 2034 | 2009-08-01 00:00:00 | 2014-05-31 00:00:00 | 58 | 3644.25 | 1.79 | 43731
1844 | 250 | PPP Corp |  | 902 |  |  | 0 | 0 | 0 | 0
1844 | 300 | [NAME] | Office - Net | 2001 | 2010-04-01 00:00:00 | 2020-03-31 00:00:00 | 120 | 3626.81 | 1.81 | 43521.72
1844 | 310 | AA | Office - Net | 2050 | 2009-11-01 00:00:00 | 2017-10-31 00:00:00 | 96 | 3630.21 | 1.77 | 43562.52
1844 | 312 | Conference Room | Office - Net | 518 | 2009-11-01 00:00:00 | 2013-12-31 00:00:00 | 50 | 928.08 | 1.79 | 11136.96 |  |  |  |  |  |  |  |  |  |  |  |  | No
1844 | 315 | UUU Inc. | Office - Net | 1495 | 2010-07-01 00:00:00 | 2013-11-30 00:00:00 | 40 | 2429.38 | 1.63 | 29152.56 |  |  |  |  |  |  |  |  |  |  |  |  | Yes
1844 | 320 | Up Inc. | Office - Net | 2006 | 2011-06-20 00:00:00 | 2014-08-31 00:00:00 | 39 | 3092.58 | 1.54 | 37110.96
1844 | 325 | Fake Name Inc. | Office - Net | 907 | 2011-11-01 00:00:00 | 2014-12-31 00:00:00 | 38 | 1738.42 | 1.92 | 20861.04
1844 | 330 | Hungry Hippo | Office - Net | 711 | 2010-02-01 00:00:00 | 2013-01-31 00:00:00 | 36 | 1125.75 | 1.58 | 13509 |  |  |  |  |  |  |  |  |  |  |  |  | Yes
1844 | 340 | Eating Out | Office - Net | 1753 | 2006-09-01 00:00:00 | 2016-12-31 00:00:00 | 124 | 3067.75 | 1.75 | 36813
1844 | 350 | Best Space Inc. | Office - Net | 1456 | 2009-09-01 00:00:00 | 2014-10-31 00:00:00 | 62 | 2669.33 | 1.83 | 32031.96
1844 | 360 | TTT Inc. | Office - Net | 6007 | 2010-02-01 00:00:00 | 2013-01-31 00:00:00 | 36 | 10637.4 | 1.77 | 127648.8 |  |  |  |  |  |  |  |  |  |  |  |  | Yes
1844 | 365 | Pippi Longstocking | Office - Net | 1221 | 2010-07-01 00:00:00 | 2013-09-30 00:00:00 | 39 | 1984.13 | 1.63 | 23809.56 |  |  |  |  |  |  |  |  |  |  |  |  | No
1844 | 400 | Large Large World | Office - Net | 5443 | 2010-03-01 00:00:00 | 2015-12-31 00:00:00 | 70 | 8844.88 | 1.63 | 106138.56
1844 | 440 | Perfect Crime Inc. | Office - Net | 2984 | 2011-05-01 00:00:00 | 2016-04-30 00:00:00 | 60 | 4849 | 1.63 | 58188
1844 | 450, 450A | The Garden Corp | Office - Net | 5412 | 2008-11-01 00:00:00 | 2012-10-31 00:00:00 | 48 | 9716.35 | 1.8 | 116596.2 |  |  |  |  |  |  |  |  |  |  |  |  | Yes
1844 | 460 | You Could Be Mine Inc. | Office - Net | 6985 | 2010-02-01 00:00:00 | 2013-01-31 00:00:00 | 36 | 12805.83 | 1.83 | 153669.96 |  |  |  |  |  |  |  |  |  |  |  |  | Yes
1844 | 500 | Estranaged Inc. | Office - Net | 16538 | 2009-11-01 00:00:00 | 2016-10-31 00:00:00 | 84 | 28252.42 | 1.71 | 339029.04
1844 | 520 | Fire Corp | Office - Net | 3950 | 2009-05-01 00:00:00 | 2014-07-31 00:00:00 | 63 | 6501.04 | 1.65 | 78012.48
1844 | 600 | VACANT |  | 5332 |  |  | 0 | 0 | 0 | 0
1844 | 650 | VACANT |  | 4600 |  |  | 0 | 0 | 0 | 0
1844 | 625 | HAP Inc. | Office - Net | 2739 | 2010-02-01 00:00:00 | 2013-01-31 00:00:00 | 36 | 4850.31 | 1.77 | 58203.72 |  |  |  |  |  |  |  |  |  |  |  |  | Yes
1844 | 660 | Ozz Revolution | Office - Net | 2073 | 2010-01-01 00:00:00 | 2013-12-31 00:00:00 | 48 | 2000 | 0.96 | 24000 |  |  |  |  |  |  |  |  |  |  |  |  | Yes
1844 | 675 | Investment Mgmt Corp | Office - Net | 2383 | 2006-04-01 00:00:00 | 2016-07-31 00:00:00 | 124 | 3971.67 | 1.67 | 47660.04
1844 | 680 | Law Firm | Office - Net | 1497 | 2009-07-01 00:00:00 | 2014-06-30 00:00:00 | 60 | 2744.5 | 1.83 | 32934
1844 | 690 | Computers-R-Us | Office - Net | 1903 | 2010-04-01 00:00:00 | 2015-03-31 00:00:00 | 60 | 3132.02 | 1.65 | 37584.24