HOMEWORK
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:
- Ignoring financing alternatives, is this property a good investment?
- What purchase price provides the owner with the 12.0% unlevered required rate of return?
- 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? - 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.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
