Problem
Evaluate the purchase of an existing 500 unit apartment complex for $20000000, 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 450 units per year. Each unit will be rented for a cumulative monthly amount of $20000 per year. Cost per unit when rented $8000 per year. Fixed costs $3000000 per year for the building, other than the initial investment. Demolition/Clean up $4500000 after-tax. Depreciation is to be straight-line. Assume the project can be financed at 8% (before-tax) using debt. Tax Rate is 21%. Develop a pro forma income statement and compute the after-tax operating cash-flow (OCF). Suppose your firm uses the NPV rule in making investment decisions and your after-tax OCF is $2700000. Assume same full debt funding at 8%, tax rate is 21%, 20-year period, straight-line depreciation, initial investment of $20000000 and after-tax exit cost of $4500000. If the required before-tax return on the investment is 12.5%, what is the NPV and do you make the investment?