Respuesta :
Answer:
present value 15.826 million
r = 10.42 % = IRR
Explanation:
The problem requires a long solution. I have to use microsoft word for the solution. and its so explanatory on it.
Answer:
the NPV = -$1,616,741
the IRR = 6.45%
Explanation:
initial investment = $2,000,000 + (80,000 x $180) = $16,400,000
monthly net lease year 1 = 80,000 x $2.10 = $168,000 x 12 = $2,016,000
then it will increase by 4% every year starting year 2
operating costs = $40,000 x 12 = $480,000
then it will increase by 3% every year starting year 2
at the end of year 10, the property should be sold at $20,000,000
in the attached spreadsheet I prepared the yearly cash flows:
the present value of the rental income after taxes = $8,930,394
the present value of the sales proceeds after taxes = $5,852,865
the NPV of the project = -$16,400,000 + $8,930,394 + $5,852,865 = -$1,616,741
the IRR of the project = 6.45%