In: Finance
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
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