In: Finance
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 0 1 2 3 4 Project S -$1,000 $896.74 $240 $10 $10 Project L -$1,000 $0 $240 $400 $792.04 The company's WACC is 10.5%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places.
Better is the one that has higher NPV
NPV of project S = Present value of cash inflows - present value of cash outflows
NPV of project S = -1,000 + 896.74 / (1 + 0.105)1 + 240 / (1 + 0.105)2 + 10 / (1 + 0.105)3 + 10 / (1 + 0.105)4
NPV of project S = $22.20
NPV of project L = Present value of cash inflows - present value of cash outflows
NPV of project L = -1,000 + 0 / (1 + 0.105)1 + 240 / (1 + 0.105)2 + 400 / (1 + 0.105)3 + 792.04 / (1 + 0.105)4
NPV of project L = $24.27
Better project is project L as it has the higher NPV
IRR is the rate of return that makes NPV equal to 0
NPV of project L = -1,000 + 0 / (1 + R)1 + 240 / (1 + R)2 + 400 / (1 + R)3 + 792.04 / (1 + R)4
Using trial and error method, i.e., after trying various values for R, lets try R as 11.30%
NPV of project L = -1,000 + 0 / (1 + 0.113)1 + 240 / (1 + 0.113)2 + 400 / (1 + 0.113)3 + 792.04 / (1 + 0.113)4
NPV of project L = 0
Therefore, IRR of better project is 11.30%