In: Finance
Assume that you are working at a manufacturing company and trying to decide between the following two projects:
Year-End Cash Flows $ thousands) |
|||
Project |
0 |
1 |
2 |
A |
-27 |
16 |
21 |
B |
-77 |
40 |
50 |
Q1. If the cost of capital is 8%, use the incremental IRR rule to make the decision.
Q2. If the cost of capital is the same as the Q1, determine the NPV of each project.
Answer A: Cost of Capital =8%
For Calculating Incremental IRR we have to calculate the difference in project cash flows (B-A) and calculate IRR of that
Year | 0 | 1 | 2 |
Cash Flow | -27 | 16 | 21 |
Cash Flow | -77 | 40 | 50 |
Incremental Cash Flow(B-A) | -50 | 24 | 29 |
IRR | 4% |
To calculate IRR you can use use excel formula
You can also use present value formula = cash flow/(1 + discount rate)^(no of years) to calculate IRR
Discount rate would be such that NPV comes out to be 0
50 = 24/(1+ r)^1 + 29/(1+ r)^2 use trial and error to calculate discount rate here
after putting values you will find Incremental IRR to be around 4%
If the Incremental IRR is higher than required rate of return then project with higher investment rate should be selected but that is not the case here, it is lower than 8% (IRR = 4%) that's why Project A should be chosen i.e. lower investment option
Answer B:
Present value formula = Cash Flow/(1+ Discount rate)^(no of year)
Discount rate = Cost of Capital = 8%
Project A | |||
Year | 0 | 1 | 2 |
Cash Flow | -27 | 16 | 21 |
Present value(Cash Flow/(1+0.08)^(no of year)) | -27.00 | 14.81 | 18.00 |
NPV (Sum of all present values) | 5.82 |
Project B | |||
Year | 0 | 1 | 2 |
Cash Flow | -77 | 40 | 50 |
Present value(Cash Flow/(1+0.08)^(no of year)) | -77.00 | 37.04 | 42.87 |
NPV (Sum of all present value) | 2.90 |