In: Accounting
Sanghai Corporation is planning to purchase a cost efficient fully automated machine which will reduce acitivties perfomed manually to a great extent. Two alternative models are MA1 and MA2 are available The details of the models are as follows:
MA1 |
MA2 |
|
$ |
$ |
|
Cost of Machine |
2,000,000 |
3,000,000 |
Estimate Life of Machine |
5 years |
5 years |
Savings due to reduction of waste per year |
120,000 |
200,000 |
Savings due to reduced Direct Wages per year |
1,400,000 |
1,800,000 |
Indirect Expenses per year |
80,000 |
100,000 |
Cost of Spares per year |
600,000 |
800,000 |
Repairs and Maintenance Costs per year |
90,000 |
170,000 |
Depreciation is to be provided on straight line basis. The company pays tax at the rate of 30%.
i. Calculate the Annual CFAT for both the machines.
ii. Evaluate both the machines based on NPV and give your recommendations. (The discounting
rate 12%)
I. Calculation of annual cash flow after tax:
Particulars | MA 1 | MA 2 | |
Inflows: | |||
Savings due to reduction of waste per year | 120,000 | 200,000 | |
Savings due to reduced Direct Wages per year | 1,400,000 | 1,800,000 | |
Outflows: | |||
Indirect Expenses per year | 80,000 | 100,000 | |
Cost of Spares per year | 600,000 | 800,000 | |
Repairs and Maintenance Costs per year | 90,000 | 170,000 | |
A | Annual CFAT before tax [Inflows - Outflows] | 750,000 | 930,000 |
B | Annual Depreciation [2000000/5] and [3000000/5] | 400,000 | 600,000 |
C | Annual profit before tax (A-B) | 350,000 | 330,000 |
D | Tax @ 30% | 105,000 | 99,000 |
E | Profit after tax (C-D) | 245,000 | 231,000 |
F | Cash flows after tax = Profit after tax + Depreciation - since it is a non cash charge | 645,000 | 831,000 |
ii. Calculation of NPV:
Present value of annual cash flows - Initial investment
Particulars | MA 1 | MA 2 | |
Annual cash flows | 645,000 | 831,000 | |
Present value | |||
Year 1 | 0.893 | 575,893 | 741,964 |
Year 2 | 0.797 | 514,190 | 662,468 |
Year 3 | 0.712 | 459,098 | 591,489 |
Year 4 | 0.636 | 409,909 | 528,116 |
Year 5 | 0.567 | 365,990 | 471,532 |
Total present value of cash flows | 2,325,081 | 2,995,569 | |
Initial investment | 2000000 | 3000000 | |
NPV = PV of cash flows - Initial investment | 325,081 | -4,431 |
Recommendation: Since NPV of Machine 1 is positive, Sanghai corporation should purchase Machine 1.
If you found the above answer useful, please take a moment to up-vote the same. It will help me serve you better in future!