Less: Vacancy and Collection Losses (51,000)
Effective Gross Income 289,000
Net Operating Income $148,950
14. Compute the after-tax cash flows and after-tax equity reversion for the holding
period.
Solution:
Year 1 Year 2 Year 3 Year 4 Year 5
PGI $50,000 $52,500 $55,125 $57,881 $60,775
EGI 50,000 52,500 55,125 57,881 60,775
Less: Operating Expenses (10,000) (10,500) (11,025) (11,576) (12,155)
Net Operating Income 40,000 42,000 44,100 46,305 48,620
Add: Capital Expenditures 0 0 0 0 0
Less: Interest (24,929) (24,310) (23,646) (22,934) (22,171)
Taxable Income 4,723 7,342 10,106 13,023 8,002
Net Operating Income 40,000 42,000 44,100 46,305 48,620
Before-Tax Cash Flow 6,507 8,507 10,607 12,812 15,127
After-tax Cash Flow $5,090 $6,305 $7,575 $8,905 $12,727
* includes amortization of remaining up-front financing costs
15. Assuming a two-year holding period, should the investor make this investment
given a required levered, after-tax, rate of return of 14 percent?
Solution: The after- tax cash flows are calculated below:
Year 1 Year 2 Year 3
PGI $105,100 $113,508 $122,589
EGI 97,700 105,562 114,007
Net Operating Income 46,170 51,971 58,273