In: Finance
A pencil company currently produces 200,000 units a year. It buys pencil tops from an outside supplier at a price of $2 per top. The plant manager believes that it would be cheaper to make these tops rather than buy them. Direct production costs are estimated to be only $1.50 per top. The necessary machinery would cost $150,000. This investment could be written off for tax purposes using straight-line depreciation over 8 years with no salvage value. The plant manager estimates that the operation would require an additional working capital investment of $30,000 that is recoverable at the end of the 10 years. If the company pays tax at a rate of 35% and the cost of capital is 15%, would you support the plant manager’s proposal? Assume the machinery can last for at least 10 years and all operating cash flows occur at the end of the year.
| Cash Flows and NPV | |||||||||||
| If NPV of cash flow saved from producing inhouse is positive, we should go for it | |||||||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Production | 0 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 |
| Price | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Cost per unit | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | |
| Savings | 400000.00 | 400000.00 | 400000.00 | 400000.00 | 400000.00 | 400000.00 | 400000.00 | 400000.00 | 400000.00 | 400000.00 | |
| Cost | 300000.00 | 300000.00 | 300000.00 | 300000.00 | 300000.00 | 300000.00 | 300000.00 | 300000.00 | 300000.00 | 300000.00 | |
| Depreciation | 18750.00 | 18750.00 | 18750.00 | 18750.00 | 18750.00 | 18750.00 | 18750.00 | 18750.00 | |||
| EBT | 81250.00 | 81250.00 | 81250.00 | 81250.00 | 81250.00 | 81250.00 | 81250.00 | 81250.00 | 100000.00 | 100000.00 | |
| Tax @ 35% | 28437.50 | 28437.50 | 28437.50 | 28437.50 | 28437.50 | 28437.50 | 28437.50 | 28437.50 | 35000.00 | 35000.00 | |
| PAT | 52812.50 | 52812.50 | 52812.50 | 52812.50 | 52812.50 | 52812.50 | 52812.50 | 52812.50 | 65000.00 | 65000.00 | |
| Add: depreciation | 18750.00 | 18750.00 | 18750.00 | 18750.00 | 18750.00 | 18750.00 | 18750.00 | 18750.00 | 0.00 | 0.00 | |
| Less: investment | 150000.00 | ||||||||||
| Less: working capital | 30000.00 | -30000.00 | |||||||||
| Net Cash Flow | -180000.00 | 71562.50 | 71562.50 | 71562.50 | 71562.50 | 71562.50 | 71562.50 | 71562.50 | 71562.50 | 65000.00 | 95000.00 |
| NPV @ 15% | 183083.55 | ||||||||||
| Since NPV is positive, so inhouse production can be undertaken | |||||||||||