In: Finance
Consider a project to supply 100 million postage stamps per year to the USPS for the next five years. To pursue the project, you will need to install $4.1 million in new manufacturing plant and equipment. This will be depreciated straight-line to zero over the project’s five years. The equipment can be sold for $540,000 at the end of the project. You will also need $600,000 in initial net working capital for the project and an additional investment of $50,000 in every year thereafter. All net working capital will be recouped at the end of the project. Your production costs are $.005 per stamp and you have fixed costs of $950,000 per year. If your tax rate is 34% and your required return is 12%, what bid price should you submit on the contract?
| Let Bid price be | x | |||||
| Year | 0 | 1 - 5 | 5 | |||
| Fixed Asset | -4100000 | |||||
| Increase in NWC | -600000 | -50000 | ||||
| Sales | 100000000 x | |||||
| Less: Cost | (0.005 x 100m) | 500000 | ||||
| Less Depreciation | 4100000/5 | 820000 | ||||
| Less: Fixed Cost | 950000 | |||||
| Earnings before tax | 100000000x - 2270000 | |||||
| Less; Tax @ 34% | 34000000x-771800 | |||||
| Earnings after tax | 66000000x-1498200 | |||||
| Add: Depeciation | 820000 | |||||
| Cash flow after tax | 66000000x - 678200 | |||||
| Post tax Salvage value of Asset | (540000 x (1 - 0.34)) | 356400 | ||||
| Recovery of Working capital | 350000 | |||||
| Net cashflows | -4700000 | 66000000x - 628200 | 706400 | |||
| PV factors @ 12% | 1 | 3.6048 | 0.567427 | |||
| Pv of Net Cash flows | -4700000 | 237915229x-2264520 | 400830.3 | |||
| Bid Price to breakeven, where NPV becomes 0 | ||||||
| NPV = Sum of PV of net cash flows = | ||||||
| -4700000 + 237915229x -2264520 + 684543.8 = | 0 | |||||
| x = | 6279977/237915229 = | 0.028 | ||||
| Bid price should be 0.028 or more to earn profit. | ||||||