In: Finance
You are considering two mutually exclusive projects which can be repeated. A costs $15 million but will provide inflows of $5.5 million per year for 4 years. If Machine A was replaced, its cost would be $18 million and its cash inflows would increase to $7.2 million due to production efficiencies. Machine B costs $16 million and will provide after-tax inflows of $6.5 million per year for 8 years. If the WACC is 9%, which machine should be acquired? Use the EAA method. Kindly show working and formula on every step?
EAA Method |
Given : |
WACC =9% |
We shall consider the NPV for Machine A |
over 8 years , to maintain uniformity . |
Machine A |
Details |
Year=n | Investment | Cash inflow | Net Cash Flow | PV factor @9%=1/1.09^n | PV of Net cash flow |
0 | (15,000,000) | - | (15,000,000) | 1.0000 | (15,000,000) |
1 | 5,500,000 | 5,500,000 | 0.9174 | 5,045,700 | |
2 | 5,500,000 | 5,500,000 | 0.8417 | 4,629,350 | |
3 | 5,500,000 | 5,500,000 | 0.7722 | 4,247,100 | |
4 | (18,000,000) | 5,500,000 | (12,500,000) | 0.7084 | (8,855,000) |
5 | 7,200,000 | 7,200,000 | 0.6499 | 4,679,280 | |
6 | 7,200,000 | 7,200,000 | 0.5963 | 4,293,360 | |
7 | 7,200,000 | 7,200,000 | 0.5470 | 3,938,400 | |
8 | 7,200,000 | 7,200,000 | 0.5019 | 3,613,680 | |
NPV = | 6,591,870.00 |
PV annuity factor at 9% for 8 years =(1-1.09^-8)8%= | 5.53482 |
NPV of Machine A = | 6,591,870 |
EAA =6591870/5.53482= | 1,190,982.0 |
Machine B |
Details |
Year=n | Investment | Cash inflow | Net Cash Flow | PV factor @9%=1/1.09^n | PV of Net cash flow |
0 | (16,000,000) | - | (16,000,000) | 1.0000 | (16,000,000) |
1 | 6,500,000 | 6,500,000 | 0.9174 | 5,963,100 | |
2 | 6,500,000 | 6,500,000 | 0.8417 | 5,471,050 | |
3 | 6,500,000 | 6,500,000 | 0.7722 | 5,019,300 | |
4 | 6,500,000 | 6,500,000 | 0.7084 | 4,604,600 | |
5 | 6,500,000 | 6,500,000 | 0.6499 | 4,224,350 | |
6 | 6,500,000 | 6,500,000 | 0.5963 | 3,875,950 | |
7 | 6,500,000 | 6,500,000 | 0.5470 | 3,555,500 | |
8 | 6,500,000 | 6,500,000 | 0.5019 | 3,262,350 | |
NPV = | 19,976,200.00 |
PV annuity factor at 9% for 8 years =(1-1.09^-8)8%= | 5.53482 |
NPV of Machine A = | 19,976,200 |
EAA =19,976,200/5.53482 | 3,609,187.5 |
As the Equivent Annual annuity of Machine B is higher , Machine B should be acquired. |