Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations Of Finance

Authors: Arthur J. Keown, John H. Martin, J. William Petty

10th Edition

0135160618, 978-0135160619

More Books

Students also viewed these Finance questions