In: Finance
One year ago, your company purchased a machine used in manufacturing for $95,000.You have learned that a new machine is available that offers many advantages and that you can purchase it for$160,000 today. The CCA rate applicable to both machines is 20%; neither machine will have any long-term salvage value. You expect that the new machine will produce earnings before interest, taxes, depreciation, and amortization (EBITDA) of $55,000 per year for the next ten years. The current machine is expected to produce EBITDA of $25,000 per year. All other expenses of the two machines are identical. The market value today of the current machine is $50,000.Your company's tax rate is 38%, and the opportunity cost of capital for this type of equipment is 11%.
Should your company replace its year-old machine?
| New machine | Old machine | Increment | |
| Cost | 160,000.00 | 50,000.00 | 110,000.00 | 
| EBITDA | 55,000.00 | 25,000.00 | 30,000.00 | 
| Incremental Depreciation | 0.2 | 0.2 | |||
| Year | written down new machine | Depreciation 20% | written down old machine(1year old) | Depreciation 20% | Increment in depreciation | 
| 1 | 160,000.00 | 32,000.00 | 76,000.00 | 15,200.00 | 16,800.00 | 
| 2 | 128,000.00 | 25,600.00 | 60,800.00 | 12,160.00 | 13,440.00 | 
| 3 | 102,400.00 | 20,480.00 | 48,640.00 | 9,728.00 | 10,752.00 | 
| 4 | 81,920.00 | 16,384.00 | 38,912.00 | 7,782.40 | 8,601.60 | 
| 5 | 65,536.00 | 13,107.20 | 31,129.60 | 6,225.92 | 6,881.28 | 
| 6 | 52,428.80 | 10,485.76 | 24,903.68 | 4,980.74 | 5,505.02 | 
| 7 | 41,943.04 | 8,388.61 | 19,922.94 | 3,984.59 | 4,404.02 | 
| 8 | 33,554.43 | 6,710.89 | 15,938.36 | 3,187.67 | 3,523.22 | 
| 9 | 26,843.55 | 5,368.71 | 12,750.68 | 2,550.14 | 2,818.57 | 
| 10 | 21,474.84 | 4,294.97 | 10,200.55 | 2,040.11 | 2,254.86 | 
| Year | PV factor 11% [1/(1+r)^n] | 
| 1 | 0.901 | 
| 2 | 0.812 | 
| 3 | 0.731 | 
| 4 | 0.659 | 
| 5 | 0.593 | 
| 6 | 0.535 | 
| 7 | 0.482 | 
| 8 | 0.434 | 
| 9 | 0.391 | 
| 10 | 0.352 | 
| Incremental cashflow method | ||||||||||
| Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 
| EBITDA | 30,000.00 | 30,000.00 | 30,000.00 | 30,000.00 | 30,000.00 | 30,000.00 | 30,000.00 | 30,000.00 | 30,000.00 | 30,000.00 | 
| Less Depreciation | 16,800.00 | 13,440.00 | 10,752.00 | 8,601.60 | 6,881.28 | 5,505.02 | 4,404.02 | 3,523.22 | 2,818.57 | 2,254.86 | 
| EBIT | 13,200.00 | 16,560.00 | 19,248.00 | 21,398.40 | 23,118.72 | 24,494.98 | 25,595.98 | 26,476.78 | 27,181.43 | 27,745.14 | 
| Tax 38% | 5,016.00 | 6,292.80 | 7,314.24 | 8,131.39 | 8,785.11 | 9,308.09 | 9,726.47 | 10,061.18 | 10,328.94 | 10,543.15 | 
| EAT | 8,184.00 | 10,267.20 | 11,933.76 | 13,267.01 | 14,333.61 | 15,186.89 | 15,869.51 | 16,415.61 | 16,852.49 | 17,201.99 | 
| Add Depreciation | 16,800.00 | 13,440.00 | 10,752.00 | 8,601.60 | 6,881.28 | 5,505.02 | 4,404.02 | 3,523.22 | 2,818.57 | 2,254.86 | 
| Incremental Cashflow (a) | 24,984.00 | 23,707.20 | 22,685.76 | 21,868.61 | 21,214.89 | 20,691.91 | 20,273.53 | 19,938.82 | 19,671.06 | 19,456.85 | 
| Discount factor (b) | 0.901 | 0.812 | 0.731 | 0.659 | 0.593 | 0.535 | 0.482 | 0.434 | 0.391 | 0.352 | 
| Discounted inflow(a*b) | 22,508.11 | 19,241.30 | 16,587.63 | 14,405.53 | 12,590.00 | 11,062.74 | 9,764.91 | 8,651.98 | 7,689.90 | 6,852.40 | 
| Total Discounted inflow | 129,354.51 | |||||||||
| Less: Incremental Initial outflow | 110,000.00 | |||||||||
| NPV of the replacement | 19,354.51 | |||||||||
| Since NPV is positive , it is advisable to purchase the new machine | ||||||||||