In: Finance
X Company is considering a new processor that costs $150,000. Shipping and setup costs for the new processor are estimated to be $15,000. X’s working capital requirement is expected to increase by $17,000 when the new processor begins operation and is expected to be fully recoverable at the end of the project. The new processor’s useful life is expected to be 5 years and its salvage value at that point is estimated to be $60,000. The new processor is being depreciated using a 5-year ACRS life. Assume a tax rate of 35% and a cost of capital of 12%. Estimated incremental revenues and incremental cash operating expenses for the new processor before tax for each year are shown in the table below. Year Revenues Operating Expenses 1: $87,000 $23,000 2: $82,000 $25,000 3: $93,000 $30,000 4: $87,000 $23,000 5: $88,000 $29,000 The processor will be depreciated to a zero book value using the following annual depreciation rates that are applied to the original installed cost. Year Depreciation % 1: 15 2: 22 3 - 5: 21 A) What is the book value of the new processor at the end of Year 3? B) What is the incremental after-tax cash flows in Year 4? C) What is the total after-tax cash flows in Year 5? Total means incremental cash flows plus terminal cash flows.
| Processor Capitalized Cost | |
| Processor cost | $ 150,000 |
| Shipping & Set up cost | $ 15,000 |
| Total Captalized cost | $ 165,000 |
| Depreciation details | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| Depreciation Rates | 15% | 22% | 21% | 21% | 21% | |
| Annual Depreciation expense | $ 24,750 | $ 36,300 | $ 34,650 | $ 34,650 | $ 34,650 |
| Book Value after 5 years | $ - |
| Salvage value after 5 years | $ 60,000 |
| Capital Gain | $ 60,000 |
| Tax on Capital Gain @35% = | $ 21,000 |
| After Tax salvage value | $ 39,000 |
| Ans A. | |
| Total Captalized cost of Processor | $ 165,000 |
| Accumulated depreciation upto year 3 | $ 95,700 |
| Book Value of Processor at the end of year 3 | $ 69,300 |
| Cash flow details | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Capitalized cost of Processor | $ (165,000) | ||||||
| Investment in NWC | $ (17,000) | ||||||
| a | Total Initial Investment | $ (182,000) | |||||
| Cash flow from operations | |||||||
| b | Incremental sales revenue | $ 87,000 | $ 82,000 | $ 93,000 | $ 87,000 | $ 88,000 | |
| c | Less Incremental cash operating expense | $ 23,000 | $ 25,000 | $ 30,000 | $ 23,000 | $ 29,000 | |
| d | Less Depreciation expense | $ 24,750 | $ 36,300 | $ 34,650 | $ 34,650 | $ 34,650 | |
| e | Taxable Income=b-c-d | $ 39,250 | $ 20,700 | $ 28,350 | $ 29,350 | $ 24,350 | |
| f | Tax @ 35% | $ 13,737.50 | $ 7,245.00 | $ 9,922.50 | $ 10,272.50 | $ 8,522.50 | |
| g | After Tax incremental income | $ 25,512.50 | $ 13,455.00 | $ 18,427.50 | $ 19,077.50 | $ 15,827.50 | |
| h | Add back depreciation | $ 24,750 | $ 36,300 | $ 34,650 | $ 34,650 | $ 34,650 | |
| i | Net Incremental Cash flow from operations=g+h= | $ 50,262.50 | $ 49,755.00 | $ 53,077.50 | $ 53,727.50 | $ 50,477.50 | |
| j | Terminal Cash flow: | ||||||
| k | After Tax salvage value | $ 39,000 | |||||
| l | Return of NWC | $ 17,000 | |||||
| m | Total after Tax Terminal Cash flow | $ 56,000 | |||||
| n | Total Cash flow from project=a+i+m | $ (182,000) | $ 50,263 | $ 49,755 | $ 53,078 | $ 53,728 | $ 106,478 |
| Ans C. | |
| Total After Tax cash flows in year 4= | $ 53,728 |
| Ans D. | |
| Total After Tax cash flows in year 5= | $ 106,478 |