Question

In: Accounting

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 6 36,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?

Solutions

Expert Solution

Answer:
a i ii iii=i-ii iv=iii*35% v=iii-iv vi=v+ii
Year Earning before Depreciation Depreciation Earning after Depreciation Tax @ 35% Earning after tax Cashflow from operation Discount @12%
0 $      (360,000.00) 1 $      (360,000.00)
1 $                                             115,000.00 $           72,000.00 $                                    43,000.00 $           15,050.00 $           27,950.00 $           99,950.00 0.892857 $           89,241.07
2 $                                             162,000.00 $        115,200.00 $                                    46,800.00 $           16,380.00 $           30,420.00 $        145,620.00                   0.79719 $        116,087.37
3 $                                             110,000.00 $           69,120.00 $                                    40,880.00 $           14,308.00 $           26,572.00 $           95,692.00                   0.71178 $           68,111.68
4 $                                               59,000.00 $           41,472.00 $                                    17,528.00 $             6,134.80 $           11,393.20 $           52,865.20                   0.63552 $           33,596.79
5 $                                               59,000.00 $           41,472.00 $                                    17,528.00 $             6,134.80 $           11,393.20 $           52,865.20                   0.56743 $           29,997.13
6 $                                               36,000.00 $           20,736.00 $                                    15,264.00 $             5,342.40 $             9,921.60 $           30,657.60                   0.50663 $           15,532.09
$           (7,433.86)
b Under net present value method Oregon Forest Products should not purchase the asset as its Net present value is negative i.e. -$7,433.86
Work Note:
Year Depreciation
1 $                                               72,000.00 =360000*20%
2 $                                             115,200.00 =360000*32%
3 $                                               69,120.00 =360000*19.2%
4 $                                               41,472.00 =360000*11.52%
5 $                                               41,472.00 =360000*11.52%
6 $                                               20,736.00 =360000*5.76%

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