In: Finance
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $70,000, and it would cost another $10,500 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 $17,500. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a $7,000 increase in net operating working capital (spare parts inventory). The project would have no effect on revenues, but it should save the firm $36,000 per year in before-tax labor costs. The firm's marginal federal-plus-state tax rate is 40%.
What is the initial investment outlay for the spectrometer, that is, what is the Year 0 project cash flow? Round your answer to the nearest cent. Negative amount should be indicated by a minus sign.
What are the project's annual cash flows in Years 1, 2, and 3?
A)Initial Investment :
| Capital cost of equipment | -(70000+10500)= -80500 | 
| Investment in net operating working capital | - 7000 | 
| Investment at year 0 (cash flow at year0 ) | - 87500 | 
B)
| 1 | 2 | 3 | |
| Saving in Labor cost | 36000 | 36000 | 36000 | 
| less:Depreciation | -26565 (80500*.33) | -36225 (80500*.45) | -12075 (80500*.15) | 
| Income before tax | 9435 | -225 | 23925 | 
| less:Tax | -3774 (9435*.40) | 90 (225*.40) | -9570 (23925*.40) | 
| Net Income | 5661 | -135 | 14355 | 
| Add:Depreciation (non cash) | 26565 | 36225 | 12075 | 
| After tax sale value | 12754 | ||
| Working capital released | 7000 | ||
| Cash Flow | 32226 | 36090 | 46184 | 
**In year 2 ,Tax saving will be available due to loss of 225
**Book Value at year 3 Cost- Accumulated depreciation
= 80500 - (26565+36225+12075)
= 80500- 74865
= 5635
Gain On sale =sale value -Book value
= 17500 -5635
= 11865
Tax on Gain = 11865*.40 = 4746
After tax sale value = sale value -taxes
= 17500 -4746
= 12754