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 $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 6 26,000 The firm is in a 30 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

Solutions

Expert Solution

NPV is $ -386182.96

No

(Since NPV is negative, do not purchase the equipment)

Step 1:

OCF Calculation
Year Depreciation rate OCF MACRS 5 year
1 20% Year EBD Depreciation EBIT Tax PAT OCF
2 32% 1 80000 60000 20000 6000 14000 74000
3 19.20% 2 98000 96000 2000 600 1400 -94600
4 11.52% 3 70000 57600 12400 3720 8680 -48920
5 11.52% 4 45000 34560 10440 3132 7308 -27252
6 5.76% 5 36000 34560 1440 432 1008 -33552
6 26000 17280 8720 2616 6104 -11176

Step 2:

NPV Calculation
Year Cash flows
0 -300000
1 74000 NPV -386182.96
2 -94600
3 -48920
4 -27252
5 -33552
6 -11176

WORKINGS


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 $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...
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...
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