Spreadsheet: 386077d1427572771-6-real-estate-analysis-questions-homework-real-estate-analysis
Sheet: Scheduled Base Rental Revenue

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Software: ARGUS Ver. 15.0.1.26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Property Type: Office & Retail
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Portfolio:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: 11/19/14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time: 8:10 am
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ref#: ATU
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page: 5
 |  |  | Supporting Schedule -- Scheduled Base Rental Revenue
 |  | Month One | Lease | First | Year  1 | Year  2 | Year  3 | Year  4 | Year  5 | Year  6 | Year  7 | Year  8 | Year  9 | Year 10
For the Years Ending |  | Occupied Area | Start | Expiration | Dec-2015 | Dec-2016 | Dec-2017 | Dec-2018 | Dec-2019 | Dec-2020 | Dec-2021 | Dec-2022 | Dec-2023 | Dec-2024 | Total
 |  |  |  |  | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________
Tenant | Suite
CECO Concrete | 103 | 7314 | 2013-06-01 00:00:00 | 2019-10-31 00:00:00 | 146890 | 150547 | 154204 | 157861 | 134090 | 156672 | 196869 | 200526 | 204182 | 207839 | 1709680
Great Wall Semiconducto | 110 | 2648 | 2003-02-01 00:00:00 | 2015-08-31 00:00:00 | 35969 | 45115 | 63552 | 64876 | 66200 | 67524 | 47664 | 72379 | 73703 | 75027 | 612009
Cypress Semiconductor | 111 | 2390 | 2010-01-01 00:00:00 | 2016-08-31 00:00:00 | 45808 | 31070 | 48298 | 60945 | 62140 | 63335 | 64530 | 43817 | 66522 | 67717 | 554182
Creative Marketing | 114 | 1729 | 2014-02-01 00:00:00 | 2017-05-31 00:00:00 | 32491 | 33355 | 16570 | 43441 | 44306 | 45170 | 46035 | 35012 | 44378 | 49204 | 389962
CECO Concrete | 115 | 4094 | 2013-05-01 00:00:00 | 2018-09-30 00:00:00 | 80345 | 82392 | 84439 | 64481 | 94913 | 108320 | 110367 | 112414 | 114461 | 77615 | 929747
Quantenna Communication | 205 | 5094 | 2012-09-01 00:00:00 | 2015-12-31 00:00:00 | 101880 | 46886 | 121407 | 123954 | 126501 | 129048 | 89145 | 138387 | 140934 | 143481 | 1161623
Elster Solutions | 206 | 2809 | 2013-06-01 00:00:00 | 2016-06-30 00:00:00 | 54073 | 27388 | 59094 | 67650 | 69055 | 70459 | 59691 | 64373 | 78418 | 79822 | 630023
Foresite Consultant Ser | 210 | 2525 | 2013-10-01 00:00:00 | 2016-12-31 00:00:00 | 49238 | 50500 | 29984 | 63967 | 65229 | 66492 | 67754 | 45871 | 69858 | 71121 | 580014
A Red Cable Company | 211 | 2020 | 2013-11-01 00:00:00 | 2016-12-31 00:00:00 | 37370 | 38380 | 23988 | 51173 | 52183 | 53193 | 54203 | 36697 | 55887 | 56897 | 459971
ASE | 212 | 4808 | 2010-04-01 00:00:00 | 2019-08-31 00:00:00 | 96160 | 98364 | 100768 | 103172 | 70317 | 124227 | 129816 | 132220 | 134624 | 137028 | 1126696
Texas Instruments | 222 | 6520 | 2009-12-01 00:00:00 | 2015-03-31 00:00:00 | 35045 |  |  |  |  |  |  |  |  |  | 35045
VACANT 116 | Mo 21 |  | 2016-09-01 00:00:00 | 2021-08-31 00:00:00 |  |  | 71073 | 79122 | 80759 | 82396 | 55658 | 90035 | 91672 | 93309 | 644024
VACANT 222 ([NAME].) | Mo 7 |  | 2015-07-01 00:00:00 | 2020-06-30 00:00:00 | 11953 | 145070 | 148330 | 151590 | 154850 | 102717 | 173323 | 176583 | 179843 | 183103 | 1427362
VACANT 121 | Mo 15 |  | 2016-03-01 00:00:00 | 2021-02-28 00:00:00 |  | 16088 | 39295 | 40117 | 40938 | 41760 | 29163 | 44772 | 45593 | 46415 | 344141
VACANT 203 | Mo 25 |  | 2017-01-01 00:00:00 | 2021-12-31 00:00:00 |  |  | 37858 | 66198 | 67496 | 68794 | 70092 | 47593 | 72255 | 73553 | 503839
 |  | ___________ |  |  | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________
Total Amount Per Year |  | 41951 |  |  | 727222 | 765155 | 998860 | 1138547 | 1128977 | 1180107 | 1194310 | 1240679 | 1372330 | 1362131 | 11108318
 |  |  |  |  | =========== | =========== | =========== | =========== | =========== | =========== | =========== | =========== | =========== | =========== | ===========
Weighted Average Per SqFt |  |  |  |  | 14.7 | 15.47 | 20.19 | 23.02 | 22.82 | 23.86 | 24.15 | 25.08 | 27.74 | 27.54
 |  |  |  |  | =========== | =========== | =========== | =========== | =========== | =========== | =========== | =========== | =========== | =========== | ===========