Reference no: EM131438710
Assignment: Real Estate Finance
An investor is interested in purchasing a multi-tenant office building in Miami, which has an asking price of $110 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 renting 24,156 SF for $25/SF/year. The lease will expire in 2 years.
· The second tenant is renting 10,266.3 SF for $23.5/SF/year. The lease will expire in 4 years and has an annual rent increase of 3%.
· The third tenant is 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 2nd and 4th year.
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/SF/year and is expected to decrease by 4% each year for the next 3 years and then increase again at 2.25% each year for the next 4 years.
Operating expenses for all leases are $8.5/SF/year and will increase annually by 2% (i.e. with inflation). All three leases are leases with operating expense recovery, which amounts to a recovery of 75% of the operating expenses. The landlord covers the remaining 25% of operating expenses and an additional $2/SF/year in non-operating expenses. Non-operating expenses are expected to remain the same. You may assume different lease terms with regard to operating expenses for new leases. Please state your assumptions in the Excel spreadsheet if they differ from the old leases. A capital expenses reserve of $3/SF/year is furthermore required.
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.80% 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 15%. For simplicity, you can use the capital gains tax for the entire capital gain (i.e. don't tax the depreciation recapture and the pure capital gain differently).
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% (compounded monthly) with a loan to value ratio (LTV) of 70%. 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?
How to benefit from negative emotions in customer service
: Choosing your field of research might be a fairly straightforward affair; on the other hand, you may need to learn more about different areas of researchto find the best fit for your interests and career goals. For example, you might find your int..
|
Primary components that should be verified prior
: When reviewing a DoD award, what are the primary components that should be verified prior to signing/releasing the award?
|
How to benefit from negative emotions in customer service
: Choosing your field of research might be a fairly straightforward affair; on the other hand, you may need to learn more about different areas of researchto find the best fit for your interests and career goals. For example, you might find your int..
|
Investment in placo stock
: The common stock of Placo Enterprises had a market price of $8.34 on the day you purchased it just one year ago. During the past year, the stock had paid a dividend of $0.54 and closed at a price of $10.47. What rate of return did you earn on your..
|
What are the after-tax npv and irr
: Assuming that the investor wants to hold the property for 5 years, Considering this FRM, what are the after-tax NPV and IRR? Is this investment worth undertaking?
|
What is the expected value and standard deviation
: A major application of analytics in marketing is determining the attrition of customers. Suppose that the probability of a long-distance carrier's customer leaving for another carrier from one month to the next is 0.12.
|
Explain what are the consequences faced by firms
: What are the sustainable growth rates for your subject company over the period that you studied? What are the consequences faced by firms that grow at a rate that is not consistent with their sustainable rate?
|
What is the firms before-tax cost of debt
: What is the firm's before-tax cost of debt? What is the firm's after-tax cost of debt? What is the firm's cost of preferred stock? What is the firm's cost of a new issue of common stock?
|
Macro environmental analysis of a non-profit addiction
: Please provide a Macro environmental analysis of a non-profit addiction center that treats drug addiction and mental health issues. The analysis examines 4 areas 1) Political and Legal 2) Economic Conditions 3) Socio-Cultural and Demographics 4) Tech..
|