Evaluate the purchase of an existing 850 unit apartment complex for $4200000, the building is assumed to have a 20 year functional life. Treat the rents as being collected at the end of each year, along with associated variable and fixed costs. Assume rent controls will prohibit the rent from being raised over the life of the building. Assume that the underlying property reverts to the original owners at the end of twenty years, and that you will also be responsible for demolition and clean-up costs, to be incurred at the end of the building’s life.
- Rentals are estimated at 765 units per year
- Each unit will be rented for a cumulative monthly amount of $6100 per year
- Cost per unit when rented $4300 per year
- Fixed costs $250000 per year for the building, other than the initial investment
- Demolition/Clean up $3400000 after-tax
- Depreciation is to be straight-line
- Assume the project can be financed at 12% (before-tax) using debt
- Tax Rate is 40%
Having studied market downturns, you estimate that a worst case scenario would entail rental of about 75% of the apartments at 80% of the normal rent. Also estimate a maximum value for the project assuming the building can maintain a rental rate of 95%, at a 20% premium over the currently planned rent. Assume before tax required return at 12%.
(everything above is the question)
a) What is the NPV of the worst case scenario?
A <-$3500000 B -$2500000-$1500000 C >-$500000 D -$1500000-$500000 E -$3500000-$2500000
b) What is the NPV of the best case scenario?
A $10500000-$11500000 B <$9500000 C >$12500000 D $11500000-$12500000 E $9500000-$10500000
c) If P is the rental price, which is the equation for EBIT in terms of P?
A 765P-3749500 B 459P-3539500 C none of them D 765P-3539500 E 459P-3749500