In: Finance
MACRS table required You have been asked by the president of your company to evaluate the proposed acquisition of a new special-purpose truck. The truck's basic price is $50,000, and it will cost another $10,000 to modify it for special use by your firm. The truck falls into the MACRS three-year class, and it will be sold after three years for $20,000. Use of the trick will require an increase in net working capital (spare parts inventory) of $2,000. The truck will have no effect on revenues, but it is expected to save the firm $20,000 per year in before-tax operating costs, mainly labor. The firm's marginal tax rate is 40 percent. The truck's cost of capital is 10%. What is its NPV?
| 
 -$1,547  | 
||
| 
 -$562  | 
||
| 
 $0  | 
||
| 
 $562  | 
||
| 
 $1,034  | 
| Time line | 0 | 1 | 2 | 3 | ||
| Cost of new machine | -60000 | |||||
| Initial working capital | -2000 | |||||
| =Initial Investment outlay | -62000 | |||||
| 3 years MACR rate | 33.00% | 45.00% | 15.00% | 7.00% | ||
| Savings | 20000 | 20000 | 20000 | |||
| -Depreciation | =Cost of machine*MACR% | -19800 | -27000 | -9000 | 4200 | |
| =Pretax cash flows | 200 | -7000 | 11000 | |||
| -taxes | =(Pretax cash flows)*(1-tax) | 120 | -4200 | 6600 | ||
| +Depreciation | 19800 | 27000 | 9000 | |||
| =after tax operating cash flow | 19920 | 22800 | 15600 | |||
| reversal of working capital | 2000 | |||||
| +Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 12000 | ||||
| +Tax shield on salvage book value | =Salvage value * tax rate | 1680 | ||||
| =Terminal year after tax cash flows | 15680 | |||||
| Total Cash flow for the period | -62000 | 19920 | 22800 | 31280 | ||
| Discount factor= | (1+discount rate)^corresponding period | 1 | 1.1 | 1.21 | 1.331 | |
| Discounted CF= | Cashflow/discount factor | -62000 | 18109.09091 | 18842.9752 | 23501.127 | |
| NPV= | Sum of discounted CF= | -1546.806912 |