Washington Tower Case Study
REE4204 Real Estate Finance
CASE STUDY: WASHINGTON TOWER Property/Analysis Data Washington Tower is a 60,000 SF office building located at 140 Washington Avenue, Houston, TX. The subject property was constructed in 1985. You are to perform a five-year holding period investment analysis of the subject property. The analysis start date is December 1, 2008. The overall rate of inflation is expected to be 3% annually. Reimbursement calculations will be performed on a calendar basis while other revenues and expenses will be inflated on a fiscal basis. Operating expenses are 100% fixed unless noted otherwise. The purchase price of the property is $7.8M. Miscellaneous Revenues In addition to base rent, revenue is derived from roof antennae fees and from parking. Roof antennae fees are expected to be $45,000 for year one and are expected to increase 2.5% per year. The building has 250 parking spaces to rent at $25/month. Projected Recoverable Expenses Real estate taxes are estimated at $1.75 per square foot in year 1. Thereafter, the tax liability is expected to increase at the overall rate of inflation. Insurance coverage includes fires, extended coverage, liability and other space coverage required by this property type. This expense is estimated at $0.18 per square foot initially and is expected to increase at the overall rate of inflation over the expected holding period. Maintenance & Repairs are $1.85 per square foot for year 1 and are expected to increase at the overall rate of inflation during the holding period. These expenses include all interior and exterior maintenance and repairs, contracts pertaining to repairs such as elevator repairs, mechanical equipment, etc. Janitorial expenses are estimated at $95,000 for year 1. These expenses are expected to increase 4% per year. Utilities include electricity, water and sewer. The current cost is $0.95/SF at 100% occupancy. It is estimated that 35% of the first year's utility cost would still be incurred by the property if it were totally vacant. Utility costs are expected to increase at the overall rate of inflation. Roads, Grounds and Security typically includes all salary related items for grounds (including landscaping), maintenance, and security as well as outside contract services. The roads/grounds/security expense is currently $0.45/SF and is expected to increase at the overall rate of inflation over the expected holding period. Projected Non-Recoverable Expenses Management and Administrative Expenses are projected at 4% of effective gross revenue (equal to historical amounts). Analysis of this expense consisted of interviews with representatives of major office building management companies. Capital Expenditures The subject property's roof is partially defective and will need major repairs in October 2010. Current estimates from contractors indicate the expense will total approximately $195,000 in current dollars. This expense is expected to increase 5% per year.
2
Vacancy and Credit Loss To account for vacancy loss, a 7% allowance is applied to the property's potential gross revenue. This allowance will be taken only if the deduction made for vacant periods occurring between leases is less than this amount. The Credit and Collection Loss is expected to be 2% of potential gross income. Rent Roll Suite Tenant SF From To Rent per SF Other terms 100 Around the World
Travel 3,750 6/05 5/10 $17.75 Expense Stop of
$5.25 per SF 125 Management
Group 1,040 1/04 12/08 $19.50 Expense Stop of
$5.90 per SF 140 First National Corp. 6,200 8/06
8/07 8/08 8/09 8/10
7/07 7/08 7/09 7/10 7/11
$19.50 5% increase 5% increase 4% increase 4% increase
Expense Stop of $6.10 per SF
200 Temp 2 Perm Agency
5,400 9/07 8/10 $21.00
Base year Expense Stop
250 E-Z Credit Union 5,610 7/03 6/09 $12.50
Net Lease
Floors 3 & 5
Buy a House Realtor
23,000 12/06 12/08 12/10 12/12
11/08 11/10 11/12 11/14
$22.00 $23.00 $24.00 $25.00
Expense Stop of $5.70 per SF 25% rental abatement for months 27-38
400 Proposed Tenant 3,000 12/07 11/10 100% of market rent Base Year Expense Stop Notes for Rent Roll: Management Group has notified management that they are vacating at the end of their current lease. Absorption Given the recent leasing of Suite 200, Temp 2 Perm Agency, the property is 75% occupied. Currently, 12,000 SF is unfinished (slab) and vacant. This space is not included in the rent roll. Additionally, another 3,000 SF (already shown on the rent roll) is second-generation space, which is currently vacant. The building has an excellent location and is a very good quality Class B office building.
In the analysis of the subject property, an absorption rate of 2,000 SF per quarter is reasonable for the unfinished areas considering the amount and location of the space at the subject property. The unfinished area is available at the beginning of the analysis with absorption projected to begin July 2009. To prepare this currently vacant first generation space for occupancy, a $20.00/SF tenant improvement allowance is assumed. Also, a 5% leasing commission is assigned to each 2,000 SF office. Lease terms will be 5 years and rent will be 100% of current market rent.
3
Market Data Quoted rates and actual recent lease terms at comparable office buildings were analyzed to determine current market rent. The building has two classifications of office space. One is for offices of less than 20,000 SF and the other is for offices of more than 20,000 SF. For offices less than 20,000SF:
Renewal Probability: 70% Market Rent: $23.00/SF for new tenants $20.00/SF for renewing tenants Months Vacant: 4 months downtime between leases Tenant Improvements: A $10.00/SF tenant improvement allowance for renewing tenants and $12.00/SF allowance for new tenants occupying previously fitted out space. Leasing Commissions: Initial/new leasing commissions are estimated at 4%. Renewing tenants require a 2% leasing commission Reimbursements: Base Year Stop Term Lengths: 5 Years
For offices more than 20,000SF:
Renewal Probability: 85% Market Rent: $21.00/SF for new tenants $19.00/SF for renewing tenants Months Vacant: 6 months downtime between leases Tenant Improvements: An $8.00/SF tenant improvement allowance for renewing tenants and $11.00/SF allowance for new tenants occupying previously fitted out space. Leasing Commissions: Initial/new leasing commissions are estimated at 4%. Renewing tenants require a 2% leasing commission Reimbursements: Base Year Stop Term Lengths: 10 Years
Terminal Value The reversion value (expected future sales price) is estimated by capitalizing the year eight net operating income, after adjusting for tenant improvements and leasing commissions. The terminal capitalization rate is expected to be in the 7.5% to 8.5% range. The subject property is in a good location and is one of the better quality office buildings in the area. The property is currently 22 years old. Selling expenses, including commissions and closing costs, are estimated to be 3% of the gross sales and proceeds. This estimate is reasonable considering the size and value of the subject property. Discounted Cash Flow Analysis The subject property is a modern office building constructed of very good quality materials and is well maintained. In addition, it is located in close proximity to major roadways. Further, future construction of office buildings is expected to be minimal and new generation buildings are experiencing high occupancies (91%+). The subject property is currently below stabilized occupancy because of the unfinished space. Given these considerations, an annual end-point property (e.g. unlevered) discount rate of 12.0% is considered appropriate.
4
Questions: 1. Ignoring financing alternatives, is this property a good investment? 2. What purchase price provides the owner with the 12.0% unlevered required rate of return? 3. You have three financing alternatives.
a. A 70% loan/value ratio loan with a 6.25% annual interest rate with monthly payments, a 30 year amortization schedule with one discount point, 2% other financing costs, and a 3% prepayment penalty.
The market required rate of return on after debt, before tax equity for 70% L/V ratio loans is 14%. b. A 75% loan/value ratio loan with an 6.5% annual interest rate with monthly interest only payments for
five years, one discount point, 2% other financing costs, and a 3% prepayment penalty. The loan begins to amortize after the initial five-year period. The amortization period is 25 years. The market required rate of return on after debt, before tax equity for 75% L/V ratio loans is 16%.
c. An 80% loan/value ratio loan with monthly payments of $41,500 and a balloon payment of $6M at the
end of the five-year holding period. The loan also has two discount points and 2% other financing costs. The market required rate of return on after debt, before tax equity for 80% L/V ratio loans of this type is 18%. Which financing alternative, if any, should you use?
4. You are planning to structure the acquisition as a partnership with two other investors using the most favorable financing option. You are the general partner and plan to contribute 20% of the required equity. The remaining equity will be divided equally between the two limited partners—Bill Jones and Mary Smith. The distributions will be structured differently. Bill wants current income while Mary wants capital appreciation. You propose to give Bill a 9% cumulative preferred return on all operating year cash flows plus 60% of any excess cash. Any unpaid return will accumulate at 10% per year. Mr. Jones will receive 20% of the BTCF from the sale of the property. Mary Smith is willing to forego current income in exchange for 50% before tax cash flow from the sale of the property. The general partner must cover any assessments and receives all residual distributions. What are the expected partnership returns? Is this structure appropriate for the three equity positions? Why or why not? If not, suggest a more equitably structured partnership agreement.