A real estate investor is considering the purchase of a four-unit office building. The following information is known:

The purchase price is $975,000 with an additional $8,800 in acquisition costs.

The first year’s rent is $3,000 per unit per month.

Rents are expected to increase at a rate of 5 percent per year.

Vacancy is estimated to be 7.50 percent of gross revenue.

Operating expenses are expected to be 32 percent of EGI.

Of the total cost, 78 percent is depreciable.

The project can be financed with a first mortgage of $720,000 at an interest rate of 6.00 percent for 30 years, monthly payments. Financing costs (discount points, etc.) are estimated at 5 percent of the loan amount.

There is a prepayment penalty of 4 percent of the outstanding balance if the loan is paid off within the first six years of the mortgage life.

The value of the investment is expected to increase at a rate of 5 percent per year.

Selling expenses equal 8 percent of the selling price. The investor’s holding period is three years. T

he investor is considered an active participant in the project and is in a 30 percent marginal tax bracket.

The investor’s required annual after-tax equity yield is 12 percent.

Depreciation recovery is taxed at 25% and long-term capital gains are taxed at 20%.

QUESTIONS

What is the mortgage payment (debt service) for year one?

What is the mortgage payment (total debt service) for year three?

What is the interest expense for year two?

What is the prepayment penalty amount?

What is the total interest expense for year three?

What is the amortized financing cost for year one?

What is the amortized financing cost for year three?

What is the depreciation expense for year one?

What is the depreciation expense for year two?

What is the expected selling price at the end of year three?

What is the adjusted basis when the property is sold?

What is the unpaid mortgage balance at the end of year 3?

What is the depreciation recovery amount?

What is the amount of capital gain?

What is the initial equity investment?

What is the NPV for the equity investor?

What is the IRR for the equity investor?

What is the modified IRR if the cash flows are reinvested at 5% instead of the IRR?