156k views
3 votes
Consider a 100,000 square foot office building with one tenant and an additional "lease in hand". The current tenant leases 50,000 square feet at market rent, which is $12/ft./yr. fixed, and the lease has a remaining term of 4 years. The lease in hand is a binding commitment to lease 35,000 square feet at $14/ft./yr. fixed for 5 years with the lease starting in exactly 2 years (first rent payment at the end of year 3). Average (market) rent is currently 13/ft./yr., and historically has increased at 2% per year. A) Ignoring operating and capital costs and assuming that rent is paid at the end of the year, use DCF over a 5 year investment window to find the value of the property. Assume that the property currently under lease is re-let at the same rent at the end of the current lease, the discount rate is 9% and the expected cap rate for the property at the end of 5 years is the current stabilized cap rate of 7%. Using the price you derive from DCF, what is the property’s current cap rate? Why isn’t it the current market cap rate of 7%? B) Now suppose that the leases in part a) are "triple nets" under which operating costs (CAM, insurance, and property taxes) are reimbursed by the tenant on a pro rata basis. (Each tenant’s share of the expenses is the % of the total leasable space that it leases.) CAM, real estate taxes, and insurance are estimated to be $1.50/ft./yr., $2.50/ft./yr., and $.15/ft./yr., respectively. As the owner you pay all capital costs, which are estimated as a reserve of $.25/ft./yr. You also pay $5/ft. in tenant improvement at the start of the second lease (end of year 2), $2/ft. in TI when the first lease rolls over, and you pay lease commissions of 6% of all base rent revenue over the life of the second lease at the end of year 2. Find the value of the property using DCF. Discount at 9% as above. (Best to do this in a spreadsheet.)

User Ronathan
by
7.0k points

1 Answer

6 votes

Answer:

the answer is 90.2 becasue i had it on my test and got it right

User Michael Rovinsky
by
8.7k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.