In: Finance
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $160,000, and it would cost another $32,000 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $72,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a $6,000 increase in net operating working capital (spare parts inventory). The project would have no effect on revenues, but it should save the firm $37,000 per year in before-tax labor costs. The firm's marginal federal-plus-state tax rate is 40%.
What are the project's annual cash flows in Years 1, 2, and 3? Round your answers to the nearest cent.
In Year 1 $
In Year 2 $
In Year 3 $
| a.Initial Investment Outlay = Base Price + Modification cost + Increase in Working Capital | |||
| =-160,000-32000-6000 | |||
| (198,000) | since outflow | ||
| b.Annual Cash Flows: | |||
| Year 1 | 2 | 3 | |
| Savings in Cost | 37,000 | 37,000 | 37,000 |
| Less: Depreciation | 63,360 | 86,400 | 28,800 |
| Net Savings | -26,360 | -49,400 | 8,200 |
| Less: Tax @40% | -10,544.00 | -19,760.00 | 3,280.00 |
| Income after Tax | -15,816.00 | -29,640.00 | 4,920.00 |
| Add: Depreciation | 63,360 | 86,400 | 28,800 |
| Operating Cash Flow | 47,544.00 | 56,760.00 | 33,720.00 |
| Add: After tax salvage value | 48,576.00 | ||
| Recovery of Working capital | 6,000 | ||
| Additional cash flows | 54,576 | ||
| Annual Cash Flows | 47,544.00 | 56,760.00 | 88,296.00 |
| Written down value | 13,440 | ||
| Sale price | 72000 | ||
| Gain on sale | 58,560 | ||
| Tax | 23424 | ||
| After tax salvage value | 48576 |