HW 7 Answer Key
HW 7 Answer Key
HW 7 Answer Key
Answer:
1500000 X .75 = 1125000 Max loan
1125000 X .09 = 101250/yr debt svc
101250 X 1.3 = 131625 Required NOI
131625 + 100000 = 231625 Required EGI
231625 / .95 = 243816 Required PGI
243816 / 40000 = $6.10 / SF Gross rent required.
2. What is the Effective Rent (under 10% discount rate assumption) for a 7-year net
lease with rent fixed at $20/SF, in which the landlord agrees to give the tenant one
year free rent up front and to pay for $10/SF worth of tenant improvements?
Answer:
N=6, I=10, PMT=20, FV=0, PV=87.1052
LPV = 87.1052 – 10 = 77.1052
Or CF0 = -10, CF1 to CF6 = 20, I = 10, NPV = 77.1052
Answer:
Gross lease: Landlord pays the operating expenses. This is also called a full
service lease because the landlord provides such services as electricity, heat,
water, cleaning, maintenance, security and so on, and no expense to the tenant.
Net lease: Tenant is responsible for paying the operating expenses of the building.
In a triple net lease, almost all of the operating expenses are charged to the tenant,
including insurance and property tax. The landlord still have some expenses such
as the property manager’s fees and cost associated with leasing activities.
4. Define and discuss:
a. Graduated rent
b. Revaluated rent
c. Indexed rent
d. Percentage rent
Answer:
Graduated rent: Rent changes over time. The timing and the dollar amount of
each change specified in the lease.
Revaluated rent: Rent changes at times specified in the lease but dollar
amount of each change depends on the market. For example, the lease may
call for appraisal every 5 year, and rent is set at a predetermined percentage of
the appraised value. Or re-evaluate every five years on the new lease signed
by comparable properties.
Indexed rent: Rent based on publicly observable index, ex. CPI or PPI. The
rent adjustment is set at a percentage of the adjustment of the index. For
example, Rent change is set at 50% of the CPI index adjustment means if CPI
index increased 5%, rent will increase 2.5%.
Answer:
See lecture outline.