In: Finance
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $240,000, and it would cost another $48,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 $9,000 increase in net operating working capital (spare parts inventory). The project would have no effect on revenues, but it should save the firm $61,000 per year in before-tax labor costs. The firm's marginal federal-plus-state tax rate is 40%.
a. 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.
b. 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 $ ________
c. If the WACC is 13%, should the spectrometer be purchased?
a.Initial Investment Outlay = Base Price + Modification cost + Increase in Working Capital
= -240,000-48,000-9,000
= -$297,000
b.Annual Cash Flows:
| 
 Year 1  | 
 2  | 
 3  | 
|
| 
 Savings in Cost  | 
 61,000  | 
 61,000  | 
 61,000  | 
| 
 Less: Depreciation  | 
 95,040  | 
 129,600  | 
 43,200  | 
| 
 Net Savings  | 
 -34,040  | 
 -68,600  | 
 17,800  | 
| 
 Less: Tax @40%  | 
 -13,616  | 
 -27,440  | 
 7,120  | 
| 
 Income after Tax  | 
 -20,424  | 
 -41,160  | 
 10,680  | 
| 
 Add: Depreciation  | 
 95,040  | 
 129,600  | 
 43,200  | 
| 
 Cash Flow  | 
 74,616  | 
 88,440  | 
 53,880  | 
| 
 Add: After tax salvage value  | 
 51,264  | 
||
| 
 Recovery of Working capital  | 
 9,000  | 
||
| 
 Cash Flow  | 
 74,616  | 
 88,440  | 
 114,144  | 
Note: Written down value of machine = 288,000*7% = $20,160
Sale Price = $72,000
Gain on Sale = $51,840
Tax on Gain = $20,736
After tax salvage value = 72,000 – 20,736 = $51,264
c.NPV = Present value of cash inflows – present value of cash outflows
= 74,616*PVF(13%, 1 year) + 88,440*PVF(13%, 2 years) + 114,144*PVF(13%, 3 years) – 297,000
= 74,616*0.885 + 88,440*0.783 + 114,144*0.693 - 297,000
= -$82,614.53
No, should not be purchased (since NPV is negative)