You expect to receive the annual property Net Operating Income (NOI) from a cert
ID: 2617008 • Letter: Y
Question
You expect to receive the annual property Net Operating Income (NOI) from a certain property as follows Year 1 Year 2 Year 3 Year 4 Year 5 $20,000 22,000 $30,000 31,000 40,000 In addition, you expect that you can sell the property at the end of the 5th year for 10 times its expected NOI of that year. A. If your opportunity cost of capital (OCC) is 10%, 1) What is the Present Value of the Property Income over the 5 years? 2) What is the Present Value of the Net Sales Proceeds received in Year 5 3) What is the Total Present Value of the property given the 5 year holding period? 4) Ifyou offer to pay the amount you calculate in Ques A3) above to purchase the property, what would be your total return on the investment? 5) If you offer to pay the amount you calculate in Ques A3) to purchase the property, what do you forecast to be the appreciation in value on the property If you pay $350,000 for the property at Year 0, what is the net present value (NPV) of a deal? B. C. In the situation given in the previous question, what is the IRR?Explanation / Answer
A)
1) Statement showing PV of income
2) Present value of sales price at end of year 5
PV = FV/(1+r)^n
=400,000/(1.1)^5
=400,000*0.6209
=2,48,368.53$
3) Total present value of cash inflow = 104913.35+248368.53
=353281.88$
4) Total return = Total of NOI + capital apprecaition / Investment value
= 1,43,000+(400000-353281.88) /353281.88
=189718.12/353281.88
=53.7016%
5) Appreciation in value of propoerty = 400,000-353281.88/353281.88
=46718.12/353281.88
=13.22%
b) NPV = PV of cash inflow less PV of cash outflow
=3,53,281.88 - 3,50,000
=3281.88$
C) IRR is rate where NPV is 0, At 10.2309%, NPV comes to 0, hence IRR = 10.2309%
Year Income PVIF @ 10% Present value 1 20000 0.9091 18181.82 2 22000 0.8264 18181.82 3 30000 0.7513 22539.44 4 31000 0.6830 21173.42 5 40000 0.6209 24836.85 Total 104913.35Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.