Question

In: Finance

Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost...

Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $420,000. If the equipment is purchased, the following earnings before depreciation and taxes will be generated 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.

Earnings before Depreciation
Year 1 $ 135,000
Year 2 182,000
Year 3 125,000
Year 4 68,000
Year 5 69,000
Year 6 39,000


The firm is in a 35 percent tax bracket and has a 12 percent cost of capital.


a. Calculate the net present value. (A negative amount should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places.)
  



b. Under the net present value method, should Oregon Forest Products purchase the equipment asset?
  

Yes
No

rev:

Solutions

Expert Solution

a

Time line 0 1 2 3 4 5 6
Cost of new machine -420000
=Initial Investment outlay -420000
5 years MACR rate 20.00% 32.00% 19.20% 11.52% 11.52% 5.76%
Profits 135000 182000 125000 68000 69000 39000
-Depreciation =Cost of machine*MACR% -84000 -134400 -80640 -48384 -48384 -24192
=Pretax cash flows 51000 47600 44360 19616 20616 14808
-taxes =(Pretax cash flows)*(1-tax) 33150 30940 28834 12750.4 13400.4 9625.2
+Depreciation 84000 134400 80640 48384 48384 24192
=after tax operating cash flow 117150 165340 109474 61134.4 61784.4 33817.2
+Tax shield on salvage book value =Salvage value * tax rate 0
=Terminal year after tax cash flows 0
Total Cash flow for the period -420000 117150.00 165340.0000 109474.00 61134.4 61784.4 33817.2
Discount factor= (1+discount rate)^corresponding period 1 1.12 1.2544 1.404928 1.5735194 1.7623417 1.9738227
Discounted CF= Cashflow/discount factor -420000 104598.2143 131808.0357 77921.43085 38852.016 35058.128 17132.846
NPV= Sum of discounted CF= -14629.33

b

No as NPV is negative


Related Solutions

Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $300,000. If the equipment is purchased, the following earnings before depreciation and taxes will be generated 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. Earnings before Depreciation Year 1 $ 110,000 Year 2 120,000 Year 3 75,000 Year 4 50,000 Year 5 56,000 Year...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $300,000. If the equipment is purchased, the following earnings before depreciation and taxes will be generated 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. Earnings before Depreciation Year 1 $ 82,000 Year 2 110,000 Year 3 80,000 Year 4 51,000 Year 5 45,000 Year...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $330,000. If the equipment is purchased, the following earnings before depreciation and taxes will be generated 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. Earnings before Depreciation Year 1 $ 111,000 Year 2 130,000 Year 3 95,000 Year 4 57,000 Year 5 48,000 Year...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $220,000. If the equipment is purchased, the following earnings before depreciation and taxes will be generated 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. Earnings before Depreciation Year 1 $ 76,000 Year 2 73,000 Year 3 56,000 Year 4 38,000 Year 5 27,000 Year...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $360,000. If the equipment is purchased, the following earnings before depreciation and taxes will be generated 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. Earnings before Depreciation Year 1 $ 115,000 Year 2 162,000 Year 3 110,000 Year 4 59,000 Year 5 59,000 Year...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $300,000. If the equipment is purchased, the following earnings before depreciation and taxes will be generated 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. Earnings before Depreciation Year 1 $ 110,000 Year 2 120,000 Year 3 75,000 Year 4 50,000 Year 5 56,000 Year...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $500,000. If the equipment is purchased, the following earnings before depreciation and taxes will be generated 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. Earnings before Depreciation Year 1 $ 150,000 Year 2 200,000 Year 3 110,000 Year 4 92,000 Year 5 82,000 Year...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $300,000. If the equipment is purchased, the following earnings before depreciation and taxes will be generated 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. Earnings before Depreciation Year 1 $ 80,000 Year 2 98,000 Year 3 70,000 Year 4 45,000 Year 5 36,000 Year...
1. Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The...
1. Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $300,000. If the equipment is purchased, the following earnings before depreciation and taxes will be generated 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. Earnings before Depreciation Year 1 $ 82,000 Year 2 110,000 Year 3 80,000 Year 4 51,000 Year 5 45,000...
The company is evaluating new equipment that will cost $2,000,000. The equipment is in the MACRS...
The company is evaluating new equipment that will cost $2,000,000. The equipment is in the MACRS 3-year class and will be sold after 3 years for $150,000. Use of the equipment will increase net working capital by 200,000.    The equipment will save $850,000 in operating costs each year for 3 years. The company's tax rate is 25 percent and its cost of capital is 12%. Please show formulas in Excel.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT