In: Finance
Hit or Miss Sports is introducing a new product this year. It is a see at night soccer ball. If the balls are a hit, the firm expects to be able to sell 50,000 balls at a price of 60$ each. If the new product is a bust, only 30,000 units can be sold at a price of $55. The variable cost of each ball is $30 and fixed costs are zero. The cost of the manufacturing equipment is $6 million and the project life is estimated at 10 years. The firm will use straight line depreciation. The firm’s tax rate is 35% and the discount rate is 12%
A. The NPV computations for the two scenarios is as given below:

Based on the above calculations, the company should not go ahead with the investment.
B. The cash flows assuming sale of equipment after 1 year is given below:
| Years | ||
| Particulars | 0 | 1 |
| Common assumptions | ||
| Variable cost per ball | 30 | |
| Cost of equipment | -60,00,000 | |
| Depreciation per year | -6,00,000 | |
| Hit scenario | ||
| No. of balls sold | 50,000 | |
| Rate per ball | 60 | |
| Revenue | 30,00,000 | |
| Variable cost | -15,00,000 | |
| Gross profit | 15,00,000 | |
| Depreciation | -6,00,000 | |
| Operating profit | 9,00,000 | |
| Tax @ 35% | -3,15,000 | |
| Net profit | 5,85,000 | |
| Add back depreciation | 6,00,000 | |
| Cost of equipment | -60,00,000 | 54,00,000 |
| Net cash flows | -60,00,000 | 65,85,000 |
| Discount factor @ 12% | 100% | 89% |
| Present value of cash flows | -60,00,000 | 58,79,464 |
| Net present value of cash flows | -1,20,536 | |
| Probability of hit scenario | 50% | |
| Probability weighted NPV | -60,268 | (A) |
| Loss scenario | ||
| No. of balls sold | 30,000 | |
| Rate per ball | 55 | |
| Revenue | 16,50,000 | |
| Variable cost | -9,00,000 | |
| Gross profit | 7,50,000 | |
| Depreciation | -6,00,000 | |
| Operating profit | 1,50,000 | |
| Tax @ 35% | -52,500 | |
| Net profit | 97,500 | |
| Add back depreciation | 6,00,000 | |
| Cost of equipment | -60,00,000 | 54,00,000 |
| Net cash flows | -60,00,000 | 60,97,500 |
| Discount factor @ 12% | 100% | 89% |
| Present value of cash flows | -60,00,000 | 54,44,196 |
| Net present value of cash flows | -5,55,804 | |
| Probability of hit scenario | 50% | |
| Probability weighted NPV | -2,77,902 | (B) |
| Sum of probability weighted NPVs | -3,38,170 | (A+B) |
Based on the above, even if the equipment is saleable at USD 5,4 million at the end of one year, the company should still not go ahead with the investment.