Better Mousetraps has developed a new trap. The company has already conducted a feasibility study at a cost of $100,000 to ensure that the new trap would work, and it has indicated no problem. It can go into production for an initial investment in equipment of $6 million. The equipment will be depreciated straight-line over 5 years to a book value of zero. The firm estimates variable costs equal to $1.50 per trap and believes that the traps can be sold for $4 each. The fixed costs are $300,000 per year. Financing costs for the project are $250,000 per year. Sales are expected to be 1 million traps per year. The project will come to an end in 5 years, when the equipment is expected to have a market value of $1 million. The project requires an immediate increase in inventory of $500,000, an increase in accounts receivable of $300,000, and an increase in accounts payable of $600,000. This investment in net working capital will be recovered at the end of the five years. The firm’s tax bracket is 35%, and the cost of capital on the project is 12%.
- Please calculate the project’s NPV and IRR.
- Conduct the scenario analysis of NPV to variable costs and unit sales, letting variable cost vary from $1.2 to $1.9 per trap in increments of $0.1 per trap and letting unit sales vary from 800,000 to 1,200,000 per year in increments of 100,000 units at the same time.
- At least how many traps need to be sold if the project breaks even on the NPV basis? In other words, at least how many traps need to be sold that makes the NPV of the project turns positive?