In: Finance
You are considering adding a new item to your company’s line of products. The machine required to manufacture the item costs $600,000. The shipping costs are $2,000 and the installation costs are $28,000. It falls into the three-year MACRS classification. The MACRS three-year depreciation rates are 33%, 45%, 15%, and 7%. The new item would immediately require an investment in NWC of $55,000. You plan to market the items for three years and then sell the machine for $90,000. You expect to sell 25,000 items per year at a price of $22. You expect variable manufacturing costs to be $20 per item and NO fixed costs will be incurred. If the tax rate is 40% and your weighted average cost of capital is 14% per year, what is the net present value of selling the new item? What should you do?
| Time line | 0 | 1 | 2 | 3 | |||
| Cost of new machine | -630000 | ||||||
| Initial working capital | -55000 | ||||||
| =Initial Investment outlay | -685000 | ||||||
| 3 years MACR rate | 33.00% | 45.00% | 15.00% | 7.00% | |||
| Unit sales | 25000 | 25000 | 25000 | ||||
| Profits | =no. of units sold * (sales price - variable cost) | 50000 | 50000 | 50000 | |||
| -Depreciation | =Cost of machine*MACR% | -207900 | -283500 | -94500 | 44100 | =Salvage Value | |
| =Pretax cash flows | -157900 | -233500 | -44500 | ||||
| -taxes | =(Pretax cash flows)*(1-tax) | -94740 | -140100 | -26700 | |||
| +Depreciation | 207900 | 283500 | 94500 | ||||
| =after tax operating cash flow | 113160 | 143400 | 67800 | ||||
| reversal of working capital | 55000 | ||||||
| +Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | -54000 | |||||
| +Tax shield on salvage book value | =Salvage value * tax rate | 17640 | |||||
| =Terminal year after tax cash flows | 18640 | ||||||
| Total Cash flow for the period | -685000 | 113160 | 143400 | 86440 | |||
| Discount factor= | (1+discount rate)^corresponding period | 1 | 1.14 | 1.2996 | 1.481544 | ||
| Discounted CF= | Cashflow/discount factor | -685000 | 99263.16 | 110341.6 | 58344.538 | ||
| NPV= | Sum of discounted CF= | -417050.6607 | |||||
Donot make the investment as NPV is negative