Statement showing depreciation
Year | Opening balance | Depreciation Rates | Depreciation (Purchase price x Depreciation rates) |
Closing Balance |
1 | 300000 | 20% | 60000 | 240000 |
2 | 240000 | 32% | 96000 | 144000 |
3 | 144000 | 19% | 57600 | 86400 |
4 | 86400 | 12% | 34560 | 51840 |
5 | 51840 | 12% | 34560 | 17280 |
6 | 17280 | 6% | 17280 | 0 |
Statement showing NPV
Particulars | 0 | 1 | 2 | 3 | 4 | 5 | 6 | NPV = sum of PV |
Cost of new equipment | -300000 | |||||||
Earnings before depreciation | 112000 | 105000 | 82000 | 53000 | 37000 | 32000 | ||
Depreciation | -60000 | -96000 | -57600 | -34560 | -34560 | -17280 | ||
PBT | 52,000 | 9,000 | 24,400 | 18,440 | 2,440 | 14,720 | ||
Tax @ 30% | 15,600 | 2,700 | 7,320 | 5,532 | 732 | 4,416 | ||
PAT | 36,400 | 6,300 | 17,080 | 12,908 | 1,708 | 10,304 | ||
Add: Depreciation | 60,000 | 96,000 | 57,600 | 34,560 | 34,560 | 17,280 | ||
Annual cash flow | 96,400 | 1,02,300 | 74,680 | 47,468 | 36,268 | 27,584 | ||
Total cash flow | -300000 | 96,400 | 1,02,300 | 74,680 | 47,468 | 36,268 | 27,584 | |
PVIF @ 14% | 1.0000 | 0.8772 | 0.7695 | 0.6750 | 0.5921 | 0.5194 | 0.4556 | |
PV | -300000.00 | 84561.40 | 78716.53 | 50406.87 | 28104.87 | 18836.46 | 12566.90 | -26,806.97 |
Thus NPV = -26806.97$
NO, equipment should not be purchased as NPV is negative
Oregon Forest Products will acquire new equipment that falls under the five year MACRS category. The...
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 earings before depreciation and taxes will be generated for the next six years. Use Table 12.12. Use Appendix for an approximate answer but calculate your final answer using the formula and financial calculator methods Laming before Depreciation $112.000 105.000 37.000 32.000 The firm is in a 30 percent tax bracket and has a 14 percent...
Oregon Forest Products wil 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 Apendix 3 for an approximate answer but calculate your final answer using the formula and financial calculator methods Depreciation $112.000 105.000 2009 The firm is in a 30 percent tax bracket and has a 14 percent cost of...
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $320,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. Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $320,000. If the...
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. Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Earnings before Depreciation $150,000 200,000 110,000 92,000 82,000 45,000 The firm is in a 25 percent tax bracket and has a 12 percent cost of capital...
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 is $340,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. Earnings before Depreciation Year 1 $ 121,000 Year 2 140,000 Year 3 100,000 Year 4 60,000 Year 5 55,000 Year 6 32,000 The firm is in a 25 percent tax bracket and has a 12 percent cost of capital....
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $400,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: $119,000 Year 2: 175,000 Year 3: 120,000 Year 4: 65,000 Year 5: 68,000 Year 6: 38,000 The firm is in...
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...
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 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 6...
Comey Products has decided to acquire some new equipment having a $260,000 purchase price. The equipment will last 4 years and is in the MACRS 3-year class. (The depreciation rates for Year 1 through Year 4 are equal to 0.3333, 0.4445, 0.1481, and 0.0741.) The firm can borrow at a 10% rate and pays a 25% federal-plus-state tax rate. Comey is considering leasing the property but wishes to know the cost of borrowing that it should use when comparing purchasing...