In: Finance
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $110,000, and it would cost another $16,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 $33,000. 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? Round your answers to the nearest cent. In Year 1 $ In Year 2 $ In Year 3 $ If the WACC is 13%, should the spectrometer be purchased?
Initial Investment Outlay = Base Price + Modification cost + Increase in Working Capital
= 110,000+16,500 +7,000
= -$133,500 since outflow
b.Annual Cash Flows:
Year 1 |
2 |
3 |
|
Savings in Cost |
36,000 |
36,000 |
36,000 |
Less: Depreciation |
41,745 |
56,925 |
18,975 |
Net Savings |
-5,745 |
-20,925 |
17,025 |
Less: Tax @40% |
-2,298.00 |
-8,370.00 |
6,810 |
Income after Tax |
-3447.00 |
-12,555.00 |
10,215.00 |
Add: Depreciation |
41,745.00 |
56,925.00 |
18,975.00 |
Cash Flow |
38,298.00 |
44,370.00 |
29,190.00 |
Add: After tax salvage value |
23,342.00 |
||
Recovery of Working capital |
7,000 |
||
Cash Flow |
38,298.00 |
44,370.00 |
59,532.00 |
Note: Written down value of machine = 126,500*7% = $8,855
Sale Price = $33,000
Gain on Sale = $24,145
Tax on Gain = $9,658
After tax salvage value = 33,000– 9,658 = $23,342
c.NPV = Present value of cash inflows – present value of cash outflows
= 38,298*PVF(13%, 1 year) + 44,370*PVF(13%, 2 years) + 59,532*PVF(13%, 3 years) – 133,500
= 38,298*0.885 + 44,370*0.773+ 59,532*0.693 – 133,500
= -$23,167.584
No, should not be purchased (since NPV is negative )