Spreadsheet: 386077d1427572771-6-real-estate-analysis-questions-homework-real-estate-analysis
Sheet: Rent Roll Summary

 |  |  |  |  |  |  |  |  |  |  |  | Software: ARGUS Ver. 15.0.1.26
 |  |  |  |  |  |  |  |  |  |  |  | Property Type: Office & Retail
 |  |  |  |  |  |  |  |  |  |  |  | Portfolio:
 |  |  |  |  |  |  |  |  |  |  |  | Date: 11/19/14
 |  |  |  |  |  |  |  |  |  |  |  | Time: 8:10 am
 |  |  |  |  |  |  |  |  |  |  |  | Ref#: ATU
 |  |  |  |  |  |  |  |  |  |  |  | Page: 2
 |  |  | Presentation Rent Roll & Current Term Tenant Summary
 |  |  | As of [NAME] for 49,464 Square Feet
 | [NAME] | Floor | Rate & Amount |  |  | CPI & Current | Months | Pcnt | Description of | Imprvmnts | Commssns | Assumption about
 | Type & Suite Number | SqFt | per Year | Changes | Changes | Porters' Wage | to | to | Operating Expense | Rate | Rate | subsequent terms
 | Lease Dates & Term | Bldg Share | per Month | on | to | Miscellaneous | Abate | Abate | Reimbursements | Amount | Amount | for this tenant
 | _____________________ | ___________ | _____________ | _________ | ______ | ________________ | _______ | _____ | __________________ | _________ | _________ | ________________
1 | CECO Concrete |  | 19.5 | Nov-2014 | 20 | - | - | - | See method: 2013 | - | - | Market
 | Office, [NAME]: 103 | 7314 | 142623 | [NAME] | 20.5 |  |  |  | BY - 95% GU + 15% |  |  | See assumption:
 | Jun-2013 to Oct-2019 | 0.1479 | 1.63 | Nov-2016 | 21 |  |  |  | Adm |  |  | 21.00 Base Year
 | 77 Months |  | 11885 | Nov-2017 | 21.5
 |  |  |  | Nov-2018 | 22
2 | Great Wall Semiconduc |  | 20 | Mar-2015 | 20.5 | - | - | - | See method: 2011 | - | - | Market
 | Office, [NAME]: 110 | 2648 | 52960 |  |  |  |  |  | BY - 95% GU + 15% |  |  | See assumption:
 | Feb-2003 to [NAME] | 0.0535 | 1.67 |  |  |  |  |  | Adm |  |  | 21.00 Base Year
 | 151 Months |  | 4413
3 | Cypress Semiconductor |  | 19 | Sep-2015 | 19.5 | - | - | - | See method: 2013 | - | - | Market
 | Office, [NAME]: 111 | 2390 | 45410 |  |  |  |  |  | BY - 95% GU + 5% |  |  | See assumption:
 | [NAME] to Aug-2016 | 0.0483 | 1.58 |  |  |  |  |  | Adm |  |  | 21.00 Base Year
 | 80 Months |  | 3784
4 | Creative Marketing |  | 18.5 | [NAME] | 19 | - | - | - | See method: 2014 | - | - | Market
 | Office, [NAME]: 114 | 1729 | 31987 | [NAME] | 19.5 |  |  |  | BY - 95% GU |  |  | See assumption:
 | Feb-2014 to May-2017 | 0.035 | 1.54 |  |  |  |  |  |  |  |  | 21.00 Base Year
 | 40 Months |  | 2666
5 | CECO Concrete |  | 19.5 | Oct-2015 | 20 | - | - | - | See method: 2013 | - | - | Market
 | Office, [NAME]: 115 | 4094 | 79833 | Oct-2016 | 20.5 |  |  |  | BY - 95% GU + 15% |  |  | See assumption:
 | May-2013 to Sep-2018 | 0.0828 | 1.63 | Oct-2017 | 21 |  |  |  | Adm |  |  | 21.00 Base Year
 | 65 Months |  | 6653
6 | [NAME] |  | 19 | Jan-2015 | 20 | - | - | - | See method: 2012 | - | - | Market
 | Office, [NAME]: 205 | 5094 | 96786 |  |  |  |  |  | BY - 95% GU |  |  | See assumption:
 | Sep-2012 to Dec-2015 | 0.103 | 1.58 |  |  |  |  |  |  |  |  | 21.00 Base Year
 | 40 Months |  | 8066
7 | Elster Solutions |  | 19 | Jul-2015 | 19.5 | - | - | - | See method: 2013 | - | - | Market
 | Office, [NAME]: 206 | 2809 | 53371 |  |  |  |  |  | BY - 95% GU |  |  | See assumption:
 | Jun-2013 to [NAME] | 0.0568 | 1.58 |  |  |  |  |  |  |  |  | 21.00 Base Year
 | 37 Months |  | 4448
8 | Foresite Consultant S |  | 19 | Jan-2015 | 19.5 | - | - | - | See method: 2014 | - | - | Market
 | Office, [NAME]: 210 | 2525 | 47975 | Jan-2016 | 20 |  |  |  | BY - 95% GU |  |  | See assumption:
 | Oct-2013 to Dec-2016 | 0.051 | 1.58 |  |  |  |  |  |  |  |  | 21.00 Base Year
 | 39 Months |  | 3998
9 | A Red Cable Company |  | 18 | Jan-2015 | 18.5 | - | - | - | See method: 2013 | - | - | Market
 | Office, [NAME]: 211 | 2020 | 36360 | Jan-2016 | 19 |  |  |  | BY - 95% GU |  |  | See assumption:
 | Nov-2013 to Dec-2016 | 0.0408 | 1.5 |  |  |  |  |  |  |  |  | 21.00 Base Year
 | 38 Months |  | 3030
10 | ASE | PENDING | 20 | Feb-2016 | 20.5 | - | - | - | See method: 2014 | - | - | Market
 | Office, [NAME]: 212 | 4808 | 96160 | Feb-2017 | 21 |  |  |  | BY - 95% GU |  |  | See assumption:
 | [NAME] to [NAME] | 0.0972 | 1.67 | Feb-2018 | 21.5 |  |  |  |  |  |  | 21.00 Base Year
 | 113 Months |  | 8013 | Feb-2019 | 22
11 | Texas Instruments |  | 21.5 | - | - | - | - | - | See method: 2007 | - | - | ReAbsorb
 | Office, [NAME]: 222 | 6520 | 140180 |  |  |  |  |  | BY - 95% GU |  |  | See assumption:
 | Dec-2009 to Mar-2015 | 0.1318 | 1.79 |  |  |  |  |  |  |  |  | 21.00 Base Year
 | 64 Months |  | 11682
S1 | VACANT 116 |  | 23.5 | [NAME] | 24 | - | 1-5 | 1 | See method: New | 25 | 9.02 | Market
 | Office, [NAME]: Mo 21 | 3274 | 76939 | Sep-2018 | 24.5 |  |  |  | Base Year - 95% |  | 0.08 | See assumption:
 | Sep-2016 to Aug-2021 | 0.0662 | 1.96 | [NAME] | 25 |  |  |  | GU | 81850 | 29521 | 21.00 Base Year
 | 60 Months |  | 6412 | Sep-2020 | 25.5
S2 | VACANT 222 ([NAME]. |  | 22 | Jul-2016 | 22.5 | - | 1-5 | 1 | See method: New | 25 | 8.47 | Market
 | Office, [NAME]: Mo 7 | 6520 | 143440 | Jul-2017 | 23 |  |  |  | Base Year - 95% |  | 0.08 | See assumption:
 | Jul-2015 to Jun-2020 | 0.1318 | 1.83 | Jul-2018 | 23.5 |  |  |  | GU | 163000 | 55203 | 21.00 Base Year
 | 60 Months |  | 11953 | [NAME] | 24
S3 | VACANT 121 |  | 23.5 | Mar-2017 | 24 | - | 1-5 | 1 | See method: New | 35 | 9.02 | Market
 | Office, [NAME]: Mo 15 | 1643 | 38611 | Mar-2018 | 24.5 |  |  |  | Base Year - 95% |  | 0.08 | See assumption:
 | Mar-2016 to Feb-2021 | 0.0332 | 1.96 | Mar-2019 | 25 |  |  |  | GU | 57505 | 14814 | 21.00 Base Year
 | 60 Months |  | 3218 | Mar-2020 | 25.5
S4 | VACANT 203 |  | 25 | Jan-2018 | 25.5 | - | 1-5 | 1 | See method: New | 30 | 9.57 | Market
 | Office, [NAME]: Mo 25 | 2596 | 64900 | [NAME] | 26 |  |  |  | Base Year - 95% |  | 0.08 | See assumption:
 | Jan-2017 to Dec-2021 | 0.0525 | 2.08 | Jan-2020 | 26.5 |  |  |  | GU | 77880 | 24835 | 21.00 Base Year
 | 60 Months |  | 5408 | Jan-2021 | 27
 | Total Occupied SqFt | 41951
 | Total Available SqFt | 7513