Question
I need help with this question please An investor is interested in purchasing a multi-tenant office building in Miami, which has an asking price of
I need help with this question please
An investor is interested in purchasing a multi-tenant office building in Miami, which has an asking price of $135 per SF. Assume that, apart from 2% purchasing cost, there are no additional acquisition-related costs. The building size is 60,390 SF. It is currently leased to three tenants:
The first tenant is currently renting 24,156 SF for $25/SF/year. The lease will expire in 2 years.
The second tenant is currently renting 10,266 SF for $23.5/SF/year. The lease will expire in 4 years and has an annual rent increase of 2.5%.
The third tena!nt is currently occupying the remaining space for $22/SF/year and the lease will expire in 6 years. Rental increases of $2 per SF will occur at the beginning of the 2ndand 4thyear.
After the first lease expires, assume a V&C of 5% of the PGI each year, which will increase to 10% once the second lease expires. The market rent is currently $19.75/SF/year and is expected to decrease by 3.5% each year for the next 3 years and then increase again at 2.5% each year for the next 4 years.
Operating expenses for all leases are currently $8.5/SF/year and will increase annually by 2.5% (i.e. with inflation). The landlord covers the remaining 25% of operating expenses. In year 4, on elevator will have to be replaced, which will cost $450,000. As a result, a capital expense reserve of $150,000 has to be created for year 1 to 3.
The building is depreciated over 39 years (mid-year convention for first and last year) and the value of improvements (building) is considered to be 80% of the purchasing price. The going out cap rate is 8.5% and the investor requires a return of 10%. Selling costs are 2% of the sales price. The investor expects to hold the building for 5 years. Assume an income tax of 35% and a capital gains tax of 17%. Makes sure you tax the depreciation recapture and the pure capital gain with the appropriate tax rates.
Part 1:Assuming that the investor wants to hold the property for 5 years, conduct a discounted cash flow analysis (DCF) to calculate the after-tax IRR and NPV for this investment. The investor received a lender's offer for a 30year mortgage at 7.5% (compounded monthly) with a loan to value ratio (LTV) of 75%. No financing costs (e.g. origination fees) or discount points occur. Considering this FRM, what are the after-tax NPV and IRR? Is this investment worth undertaking?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started