In: Finance
You are considering building a shopping mall. The initial investment is $1.33 million. The cash flows are $480,000 for year 1, $250,000 for year 2. $160,000 for year 3, and $170,000 for year 4. What are the net present value (NPV), and profitability index (PI) of the project if the cost of capital is 7%? Compute the internal rate of return (IRR) for the project. What is the NPV of the shopping mall?
1)
Net present value = Present value of cash inflows - present value of cash outflows
Net present value = -1,330,000 + 480,000 / (1 + 0.07)1 + 250,000 / (1 + 0.07)2 + 160,000 / (1 + 0.07)3 + 170,000 / (1 + 0.07)4
Net present value = -1,330,000 + 927,257.6953
Net present value = -402,742.34
2)
Profitability index = Present value / initial investment
Present value = 480,000 / (1 + 0.07)1 + 250,000 / (1 + 0.07)2 + 160,000 / (1 + 0.07)3 + 170,000 / (1 + 0.07)4
Present value = 927,257.6953
Profitability index = 927,257.6953 / 1,330,000
Profitability index = 0.697
3)
IRR is the rate of return that makes NPV equal to 0
Net present value = -1,330,000 + 480,000 / (1 + R)1 + 250,000 / (1 + R)2 + 160,000 / (1 + R)3 + 170,000 / (1 + R)4
Using trial and error method, i.e., after trying various values for R, lets try R as -10.30
Net present value = -1,330,000 + 480,000 / (1 + -0.1030)1 + 250,000 / (1 + -0.1030)2 + 160,000 / (1 + -0.1030)3 + 170,000 / (1 + -0.1030)4
Net present value = 0
Therefore, IRR is -10.30%
Note: Calculating IRR using trial and error method can be time consuming. It is always best to use a financial calculator to calculate IRR