Spreadsheet: 386077d1427572771-6-real-estate-analysis-questions-homework-real-estate-analysis
Sheet: Expense Reimbursement Revenue

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Software: ARGUS Ver. 15.0.1.26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Property Type: Office & Retail
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Portfolio:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: 11/19/14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time: 8:10 am
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ref#: ATU
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page: 6
 |  |  | Supporting Schedule -- Expense Reimbursement 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 | 6260 | 8219 | 11590 | 14419 | 13651 |  | 1498 | 3474 | 6136 | 7901 | 73148
Great Wall Semiconducto | 110 | 2648 | 2003-02-01 00:00:00 | 2015-08-31 00:00:00 |  |  | 1061 | 1952 | 2570 | 3224 |  | 716 | 1680 | 2319 | 13522
Cypress Semiconductor | 111 | 2390 | 2010-01-01 00:00:00 | 2016-08-31 00:00:00 | 336 | 615 |  | 802 | 1362 | 1954 | 2440 |  | 870 | 1446 | 9825
Creative Marketing | 114 | 1729 | 2014-02-01 00:00:00 | 2017-05-31 00:00:00 |  | 403 | 457 | 581 | 983 | 1412 | 1766 | 1674 |  | 419 | 7695
CECO Concrete | 115 | 4094 | 2013-05-01 00:00:00 | 2018-09-30 00:00:00 | 3504 | 4600 | 6488 | 6053 |  | 1013 | 1852 | 2957 | 4446 | 454 | 31367
Quantenna Communication | 205 | 5094 | 2012-09-01 00:00:00 | 2015-12-31 00:00:00 |  |  | 2043 | 3755 | 4944 | 6205 | 2416 | 1377 | 3231 | 4459 | 28430
Elster Solutions | 206 | 2809 | 2013-06-01 00:00:00 | 2016-06-30 00:00:00 |  | 21 | 1128 | 2070 | 2726 | 3421 | 3330 |  | 1022 | 1701 | 15419
Foresite Consultant Ser | 210 | 2525 | 2013-10-01 00:00:00 | 2016-12-31 00:00:00 |  | 588 |  | 848 | 1439 | 2062 | 2578 | 1087 | 921 | 1528 | 11051
A Red Cable Company | 211 | 2020 | 2013-11-01 00:00:00 | 2016-12-31 00:00:00 |  | 33 |  | 680 | 1150 | 1650 | 2061 | 873 | 735 | 1223 | 8405
ASE | 212 | 4808 | 2010-04-01 00:00:00 | 2019-08-31 00:00:00 |  | 1121 | 3048 | 4662 | 3857 |  | 984 | 2283 | 4033 | 5193 | 25181
Texas Instruments | 222 | 6520 | 2009-12-01 00:00:00 | 2015-03-31 00:00:00
VACANT 116 | Mo 21 |  | 2016-09-01 00:00:00 | 2021-08-31 00:00:00 |  |  | 1312 | 2411 | 3177 | 3987 | 3105 |  | 1190 | 1982 | 17164
VACANT 222 ([NAME].) | Mo 7 |  | 2015-07-01 00:00:00 | 2020-06-30 00:00:00 |  | 1520 | 4131 | 6326 | 7846 | 4729 | 1333 | 3098 | 5469 | 7044 | 41496
VACANT 121 | Mo 15 |  | 2016-03-01 00:00:00 | 2021-02-28 00:00:00 |  |  | 659 | 1211 | 1594 | 2001 | 391 | 445 | 1042 | 1440 | 8783
VACANT 203 | Mo 25 |  | 2017-01-01 00:00:00 | 2021-12-31 00:00:00 |  |  |  | 872 | 1479 | 2123 | 2653 |  | 946 | 1571 | 9644
 |  | ___________ |  |  | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________
Total Amount Per Year |  | 41951 |  |  | 10100 | 17120 | 31917 | 46642 | 46778 | 33781 | 26407 | 17984 | 31721 | 38680 | 301130
 |  |  |  |  | =========== | =========== | =========== | =========== | =========== | =========== | =========== | =========== | =========== | =========== | ===========
Weighted Average Per SqFt |  |  |  |  | 0.2 | 0.35 | 0.65 | 0.94 | 0.95 | 0.68 | 0.53 | 0.36 | 0.64 | 0.78
 |  |  |  |  | =========== | =========== | =========== | =========== | =========== | =========== | =========== | =========== | =========== | =========== | ===========