In: Finance
Problem 11-7
New-Project Analysis
The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm’s R&D department The equipment's basic price is $120,000, and it would cost another $30,000 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $42,000. Use of the equipment would require an increase in net working capital (spare parts inventory) of $4,800. The machine would have no effect on revenues, but it is expected to save the firm $36,000 per year in before-tax operating costs, mainly labor. The firm's marginal federal-plus-state tax rate is 30%.
| Year 1 | $ |
| Year 2 | $ |
| Year 3 | $ |
Please show work. Thank you!
| Time line | 0 | 1 | 2 | 3 | |||
| Cost of new machine | -150000 | ||||||
| Initial working capital | -4800 | ||||||
| =Initial Investment outlay | -154800 | ||||||
| 3 years MACR rate | 33.33% | 44.45% | 14.81% | 7.41% | 0.0000% | ||
| Profits | 36000 | 36000 | 36000 | ||||
| -Depreciation | =Cost of machine*MACR% | -49995 | -66675 | -22215 | 11115 | =Salvage Value | |
| =Pretax cash flows | -13995 | -30675 | 13785 | ||||
| -taxes | =(Pretax cash flows)*(1-tax) | -9796.5 | -21472.5 | 9649.5 | |||
| +Depreciation | 49995 | 66675 | 22215 | ||||
| =after tax operating cash flow | 40198.5 | 45202.5 | 31864.5 | ||||
| reversal of working capital | 4800 | ||||||
| +Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 29400 | |||||
| +Tax shield on salvage book value | =Salvage value * tax rate | 3334.5 | |||||
| =Terminal year after tax cash flows | 37534.5 | ||||||
| Total Cash flow for the period | -154800 | 40198.5 | 45202.5 | 69399 | |||
| Discount factor= | (1+discount rate)^corresponding period | 1 | 1.12 | 1.2544 | 1.404928 | ||
| Discounted CF= | Cashflow/discount factor | -154800 | 35891.518 | 36035.1563 | 49396.837 | ||
| NPV= | Sum of discounted CF= | -33476.488 | |||||