Depreciation of old machine pre-critical analysis
(8,000,000 - 0) / 5 = sh. 1,600,000
Current book value of existing machine before contemplation of disposal
8,000,000 (1,600,000 x 2) = shs. 4,800,000
Depreciation of existing machine post critical analysis
(4,800,000 - 1,500,000) / 5 = sh. 660,000 per year
Step 1: Incremental outlay Purchase cost new
machine Add: investment working capital
Less: Disposal value new machine Less: Tax shield benefit disposal loss (0.3 x 800,000)
Step 2: Incremental depreciation
Depreciation new machine (12,560,000 - 4,000,0000.) / 5 Less: Depreciation old machine
Step 3: Incremental salvage value
Salvage value new machine Less: Salvage value old machine
Step 4: Incremental terminal benefit Recovery working capital (Step 1)
Add: Incremental Salvage value(step 3)
|
12,560,000
2,600,000
(4,000,000)
(240,000)
10,920,00
1,712,000
(660,000) 1,052,000
4,000,000
(1,500,000) 2,500,000
2,600,000
2,500,000 5,100,000
|
Step 5: Incremental
operating cash in flows |
Year 1 2 3 4 5 |
EBIT sh.000
New machine
5,400
5,400
5,400
5,400
5,400 |
EBIT sh.000
Old machine
3,200
2,800
3,000
2,400
2,000 |
Change EBIT
sh.000
2,200
2,600
2,400
3,000
3,400 |
Cash flows per year
Cashflows EBDT(1-T)+TxDepreciation
Year 1 = (2,200 x 0.7) + 0.3 x 1052 = 1855.60
Year 2 = (2,600 x 0.7) + 0.3 x 1052 = 2135.60
Year 3 = (2,400 x 0.7) + 0.3 x 1052 = 1995.60
Year 4 = (3,000 x 0.7) + 0.3 x 1052 = 2415.60
Year 5 = (3,400 x 0.7) + 0.3 x 1052 = 2695.60
Year 1 2 3 4 5
|
Cashflows (000)
1855.60
2135.60
1995.60
2415.60
7795.60
|
D.F 13%
0.8850
0.7831
0.6931
0.6133
0.5428
PV of cash inflows
Less: initial outlay (Step 1)
NPV |
PV (000)
1642.206
1672.388
1383.150
1481.487
4231.452
10,410.683
(10.920.000)
(509.317) |
Advice:
Management should not replace existing machine with new machine since doing so will result to a negative NPV
thus destruction of shareholders wealth.