Question

A client has requested advice on a potential investment opportunity involving an income-producing property. She would like you to determine the internal rate of return of the investment opportunity based on the following information: expected holding period: years; end of first year NOI estimate: $113,900; NOI estimates in subsequent years will grow by 5% per year; price at which the property is expected to be sold at the end of year 5: $1,615,205.22; current market price of the property: $1,475,667.71.
A. -15.30%
B. 8.60%
C. 9.86%
D. 10.00%

Answer 1

Answer:

The correct answer is D. 10.00%

Explanation:

To get internal rate of return we use excel or a spreadsheet.  See document attached.

Make the cash flow to solve this problem.  At moment 0 we have the investment cost , in this case $1.475.668 (negative) From period 1 to period 5, we have different incomes o benefits.  Salvage value is 1.615.205, we are going to get it at moment 5 (positive).

Then, we calculate the Net cash flow that is the difference between benefits and cost.

We use all the result (positive and negative) in Net cash flow to get the IRR.

Net Present Value (NPV) 768907

Internal Rate of Return (IRR) 10,00%

Download xlsx