Question

Suppose an investor is interested in purchasing the following income producing property at a current market price of $450,000. The prospective buyer has estimated the expected cash flows over the next four years to be as follows: Year 1 = $40,000, Year 2 = $45,000, Year 3 = $50,000, Year 4 = $55,000. Assuming that the required rate of return is 12% and the estimated proceeds from selling the property at the end of year four is $500,000, what is the NPV of the project?

Answer 1

Answer:

Net Present value of Project is $9,890

Explanation:

Net present value is the Net value all cash inflows and outflows in present value term. All the cash flows are discounted using a required rate of return.

Net Present Value of Property is $9,890

Workings are made in an MS Excel file, which is attached with this answer. please find it.

Download xlsx