Fill This Form To Receive Instant Help
Homework answers / question archive / You must evaluate the purchase of a proposed spectrometer for the R&D department
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $100,000, and it would cost another $15,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 $30,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a $12,000 increase in net operating working capital (spare parts inventory). The project would have no effect on revenues, but it should save the firm $35,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 $
Answer :(a.) -127000
Annaul cash Inflow 1 = 36180
Annaul cash Inflow 2 = 41700
Annaul cash Inflow 3 =27900
c.) No
Year 0 | Year 1 | Year 2 | Year 3 | |
Base Price | -100000 | |||
Modification Cost | -15000 | |||
NOWC | -12000 | |||
Before tax Labour Cost saving | 35000 | 35000 | 35000 | |
Less : Depreciation (Working Note) | 37950 | 51750 | 17250 | |
Operating Income | -2950 | -16750 | 17750 | |
Less :Taxes @ 40% | -1180 | -6700 | 7100 | |
After Tax Operating Income | -1770 | -10050 | 10650 | |
Add : Depreciation | 37950 | 51750 | 17250 | |
Operating Cash Flows | 36180 | 41700 | 27900 | |
Termination Cash Flows | ||||
Before Tax salvage Proceeds | 30000 | |||
Less : Tax on Sale | 8780 | |||
Recapture of Net Working Capital | 12000 | |||
Projects Cash Flows | -127000 (a.) | 36180 | 41700 | 61120 |
PV Factor @ 11% | 1 | 0.900901 | 0.811622 | 0.731191 |
PV of Net Cash flows (Inflow) | 32594.59 | 33844.66 | 44690.42 | |
PV of Net Cash flows (Outflow) | -127000 | |||
The net present value (NPV) of this project is | = $ - 15870.33 | |||
Project Acceptance | NO | |||
NPV = PV of cash inflow - PV of cash outflow | ||||
= 111129.67- 127000 | ||||
= $ - 15870.33 | ||||
Working Note : | ||||
Calculation of Depreciation | ||||
Year 1 = (100000+15000) * 33% = 37950 | ||||
Year 2 = (100000+15000) * 45% = 51750 | ||||
Year 3 = (100000+15000) * 15% = 17250 | ||||
Book Value at the end of year 3 = 115000 - 37950 - 51750 - 17250 = 8050 | ||||
Gain on Sale = 30000 - 8050 = 21950 | ||||
Tax on Gain on sale = 21950 * 40% = 8780 |