Question

In: Finance

Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $92,000. The equipment...

Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $92,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $41,800. A new piece of equipment will cost $300,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods.

Year Cash Savings
1 $ 68,000
2 58,000
3 56,000
4 54,000
5 51,000
6 40,000


The firm’s tax rate is 30 percent and the cost of capital is 13 percent.



e. What is the net cost of the new equipment? (Include the inflow from the sale of the old equipment.) (Do not round intermediate calculations and round your answer to the nearest whole dollar.)
  



f. Determine the depreciation schedule for the new equipment. (Round the depreciation base and annual depreciation answers to the nearest whole dollar. Round the percentage depreciation factors to 3 decimal places.)
  



g. Determine the depreciation schedule for the remaining years of the old equipment. (Round the depreciation base and annual depreciation answers to the nearest whole dollar. Round the percentage depreciation factors to 3 decimal places.)
  



h. Determine the incremental depreciation between the old and new equipment and the related tax shield benefits. (Enter the tax rate as a decimal rounded to 2 decimal places. Round all other answers to the nearest whole dollar.)
  



i. Compute the aftertax benefits of the cost savings. (Enter the aftertax factor as a decimal rounded to 2 decimal places. Round all other answers to the nearest whole dollar.)
  



j-1. Add the depreciation tax shield benefits and the aftertax cost savings to determine the total annual benefits. (Do not round intermediate calculations and round your answers to the nearest whole dollar.)
  



j-2. Compute the present value of the total annual benefits. (Do not round intermediate calculations and round your answer to the nearest whole dollar.)
  



k-1. Compare the present value of the incremental benefits (j) to the net cost of the new equipment (e). (Do not round intermediate calculations. Negative amount should be indicated by a minus sign. Round your answer to the nearest whole dollar.)
  



k-2. Should the replacement be undertaken?
  

No
Yes

Solutions

Expert Solution

Answer f
Answer e The depreciation schedule for the new equipment using 5 year MACRS
The net cost of the new equipment Year Depreciable value Depreciation rates Depreciation
Cost of new equipment $300,000.00 1 $300,000 20% $60,000
Less : cash inflow from sale of old equipment $42,508.00 2 $300,000 32% $96,000
The net cost of the new equipment $257,492.00 3 $300,000 19.20% $57,600
4 $300,000 11.52% $34,560
Answer k-1 Compare the present value of the incremental benefits (j) 5 $300,000 11.52% $34,560
to the net cost of the new equipment (e). 6 $300,000 5.76% $17,280
Present value of annual benefits $211,673.86
Less : Net cost of new equipment $257,492.00 Answer g
Net Present Value -$45,818.14 The depreciation schedule for the remaining years of the old equipment.
Year Depreciable value Depreciation rates Depreciation
Answer k-2 1 $92,000 19.20% $17,664
The answer is No. 2 $92,000 11.52% $10,598
The replacement of equipment should not be undertaken as the 3 $92,000 11.52% $10,598
net present value of new equipment is nagative amount. 4 $92,000 5.76% $5,299
Answer h
Determine the incremental depreciation between the old and new equipment
and the related tax shield benefits.
Year Depreciation (New equipment) Depreciation (Old equipment) Difference Tax shield @ 30% of difference
Working 1 $60,000 $17,664 $42,336 $12,701
Calculation of after tax sale value of old equipment 2 $96,000 $10,598 $85,402 $25,620
Cost of old equipment $92,000.00 3 $57,600 $10,598 $47,002 $14,100
Less : Depreciation for Year 1 [$92000 x 20%] $18,400.00 4 $34,560 $5,299 $29,261 $8,778
Less : Depreciation for Year 2 [$92000 x 32%] $29,440.00 5 $34,560 $34,560 $10,368
Book value of old equipment at the time of sale $44,160.00 6 $17,280 $17,280 $5,184
Less : Sale value $41,800.00
Loss on sale $2,360.00 Answer i
Tax benefit @ 30% of loss $708.00 The aftertax benefits of the cost savings
After tax sale value [Sale value + Tax benefit] $42,508.00 Year Cash savings Tax @ 30% of cash savings After tax benefits from cost savings
1 $68,000 $20,400 $47,600
2 $58,000 $17,400 $40,600
3 $56,000 $16,800 $39,200
4 $54,000 $16,200 $37,800
5 $51,000 $15,300 $35,700
6 $40,000 $12,000 $28,000
Answer j-1 Determine the total annual benefits.
Year After tax benefits from cost savings Depreciation Tax shield Total Annual benefits
1 $47,600 $12,701 $60,301
2 $40,600 $25,620 $66,220
3 $39,200 $14,100 $53,300
4 $37,800 $8,778 $46,578
5 $35,700 $10,368 $46,068
6 $28,000 $5,184 $33,184
Answer j-2 Compute the present value of the total annual benefits.
Year Total Annual benefits Discount factor @ 13% Present value of total annual benefits
1 $60,301 0.884955752 $53,364
2 $66,220 0.783146683 $51,860
3 $53,300 0.693050162 $36,940
4 $46,578 0.613318728 $28,567
5 $46,068 0.542759936 $25,004
6 $33,184 0.480318527 $15,939
Total $211,674

Related Solutions

Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $92,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $92,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $41,800. A new piece of equipment will cost $245,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. calculate your final answer using the formula and financial calculator methods. Year Cash...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $70,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $70,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $30,800. A new piece of equipment will cost $160,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $78,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $78,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $34,800. A new piece of equipment will cost $230,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $78,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $78,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $34,800. A new piece of equipment will cost $230,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $86,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $86,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $38,800.      A new piece of equipment will cost $270,000. It also falls into the five-year category for MACRS depreciation.      Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $88,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $88,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $39,800. A new piece of equipment will cost $280,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $56,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $56,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $23,800. A new piece of equipment will cost $146,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $62,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $62,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $26,800. A new piece of equipment will cost $152,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $72,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $72,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $31,800. A new piece of equipment will cost $200,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Year Cash Savings 1 $69,000     2 61,000     3 59,000     4 57,000     5 54,000    ...
Hercules Exercise Equipment Co. purchased a computerizedmeasuring device two years ago for $56,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $56,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $23,800. A new piece of equipment will cost $146,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT