Question

In: Finance

One year? ago, your company purchased a machine used in manufacturing for $115,000. You have learned...

One year? ago, your company purchased a machine used in manufacturing for $115,000. You have learned that a new machine is available that offers many advantages and that you can purchase it for $150,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 $50,000 per year for the next ten years. The current machine is expected to produce EBITDA of $ 23 comma 000$23,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 40%?, and the opportunity cost of capital for this type of equipment is11%. Should your company replace its? year-old machine? What is the NPV of? replacement?

Solutions

Expert Solution

Statement showing Depreciation on old machine

Year Opening balance Depreciation Closing balance
1 103500 20700 82800
2 82800 16560 66240
3 66240 13248 52992
4 52992 10598 42394
5 42394 8479 33915
6 33915 6783 27132
7 27132 5426 21706
8 21706 4341 17364
9 17364 3473 13892
10 13892 2778 11113

Statement showing Depreciation on new machine

Year Opening balance Depreciation Closing balance
1 150000 15000 135000
2 135000 27000 108000
3 108000 21600 86400
4 86400 17280 69120
5 69120 13824 55296
6 55296 11059 44237
7 44237 8847 35389
8 35389 7078 28312
9 28312 5662 22649
10 22649 4530 18119

Statement showing Incremental depreciation

Year Depreciation on old machine Depreciation on new machine Incremental depreciation
1 20700 15000 -5700
2 16560 27000 10440
3 13248 21600 8352
4 10598 17280 6682
5 8479 13824 5345
6 6783 11059 4276
7 5426 8847 3421
8 4341 7078 2737
9 3473 5662 2189
10 2778 4530 1752

Statement showing NPV

Particulars 0 1 2 3 4 5 6 7 8 9 10 NPV
Incremental cost(150000-71400) -78600
Incremental EBITDA(50000-23000) 27000 27000 27000 27000 27000 27000 27000 27000 27000 27000
Incremental depreciation -5700 10440 8352 6682 5345 4276 3421 2737 2189 1752
PBT 32700 16560 18648 20318 21655 22724 23579 24263 24811 25248
Tax @ 40% 13080 6624 7459 8127 8662 9090 9432 9705 9924 10099
PAT 19620 9936 11189 12191 12993 13634 14147 14558 14886 15149
Add: Depreciation -5700 10440 8352 6682 5345 4276 3421 2737 2189 1752
Annual cash flow 13920 20376 19541 18873 18338 17910 17568 17295 17076 16901
Total cash flow -78600 13920 20376 19541 18873 18338 17910 17568 17295 17076 16901
PVIF @ 11% 1 0.9009 0.8116 0.7312 0.6587 0.5935 0.5346 0.4817 0.4339 0.3909 0.3522
Present value -78600 12541 16538 14288 12432 10883 9576 8462 7505 6675 5952 26251

Statement showing Cash flow from sale of equipment

Particulars Amount
Salavage value 50000
Book value(115000-10%) 103500
Loss 53500
Tax @ 40% 21400
Cash inflow 71400

Related Solutions

One year ago your company purchased a machine used in manufacturing for $115,000. You have learned...
One year ago your company purchased a machine used in manufacturing for $115,000. You have learned that q new machine is available that offers many advantages and you can purchase it for $150,000 today. It will be depreciated on a straight-line basis over 10 years and has no salvage value. You expect that the new machine will produce a gross margin revenues minus operating expenses other than depreciation) of $55,000 per year for the next 10 years. The current machine...
One year​ ago, your company purchased a machine used in manufacturing for $ 115,000. You have...
One year​ ago, your company purchased a machine used in manufacturing for $ 115,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 30 %​; 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 $ 45,000 per year for the next 10...
One year​ ago, your company purchased a machine used in manufacturing for $ 115,000 You have...
One year​ ago, your company purchased a machine used in manufacturing for $ 115,000 You have learned that a new machine is available that offers many advantages and you can purchase it for $ 160,000 today. It will be depreciated on a​ straight-line basis over 10 years and has no salvage value. You expect that the new machine will produce a gross margin​ (revenues minus operating expenses other than​ depreciation) of $ 50,000 per year for the next 10 years....
One year​ ago, your company purchased a machine used in manufacturing for $ 115,000. You have...
One year​ ago, your company purchased a machine used in manufacturing for $ 115,000. You have learned that a new machine is available that offers many​ advantages; you can purchase it for $ 150,000 today. It will be depreciated on a​ straight-line basis over ten​ years, after which it has no salvage value. You expect that the new machine will contribute EBITDA​ (earnings before​ interest, taxes,​ depreciation, and​ amortization) of $ 55,000 per year for the next ten years. The...
One year​ ago, your company purchased a machine used in manufacturing for $ 115,000 . You...
One year​ ago, your company purchased a machine used in manufacturing for $ 115,000 . You have learned that a new machine is available that offers many advantages and you can purchase it for $ 170,000 today. It will be depreciated on a​ straight-line basis over 10 years and has no salvage value. You expect that the new machine will produce a gross margin​ (revenues minus operating expenses other than​ depreciation) of $ 35,000 per year for the next 10...
One year​ ago, your company purchased a machine used in manufacturing for$105,000.You have learned that a...
One year​ ago, your company purchased a machine used in manufacturing for$105,000.You have learned that a new machine is available that offers many advantages and you can purchase it for$140,000today. It will be depreciated on a​ straight-line basis over 10 years and has no salvage value. You expect that the new machine will produce a gross margin​ (revenues minus operating expenses other than​ depreciation) of$35,000per year for the next 10 years. The current machine is expected to produce a gross...
One year ago, your company purchased a machine used in manufacturing for $120,000. You have learned...
One year ago, your company purchased a machine used in manufacturing for $120,000. You have learned that a new machine is available that offers many advantages; you can purchase it for $160,000 today. It will be depreciated on a straight-line basis over ten years, after which it has no salvage value. You expect that the new machine will contribute EBITDA (earnings before interest, taxes, depreciation, and amortization) of $40,000 per year for the next ten years. The current machine is...
One year​ ago, your company purchased a machine used in manufacturing for $90,000. You have learned...
One year​ ago, your company purchased a machine used in manufacturing for $90,000. You have learned that a new machine is available that offers many​ advantages; you can purchase it for $150,000 today. It will be depreciated on a​ straight-line basis over ten​ years, after which it has no salvage value. You expect that the new machine will contribute EBITDA​ (earnings before​ interest, taxes,​ depreciation, and​ amortization) of $40,000 per year for the next ten years. The current machine is...
One year? ago, your company purchased a machine used in manufacturing for $90,000. You have learned...
One year? ago, your company purchased a machine used in manufacturing for $90,000. You have learned that a new machine is available that offers many advantages and that you can purchase it for $150,000 today. The CCA rate applicable to both machines is 30%?; 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 $60,000 per year for the next ten years. The current machine...
One year? ago, your company purchased a machine used in manufacturing for $105,000. You have learned...
One year? ago, your company purchased a machine used in manufacturing for $105,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 $50,000 per year for the next ten years. The current machine...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT