Better Mousetraps has developed a new trap. The company has already conducted a
ID: 2759057 • Letter: B
Question
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%. 1.Please calculate the project's NPV and IRR. 2.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. 3.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?Explanation / Answer
Particulars Year -0 Year-1 Year - 2 Year-3 Year-4 Year-5 Intial Investment 6,000,000 Sales in units 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 Sales @ $ 4 4 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 Variable cost 1.5 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 Gross Margin 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 Fixed Cost 300,000 300,000 300,000 300,000 300,000 Profit before interest tax and depn 2,200,000 2,200,000 2,200,000 2,200,000 2,200,000 Finance cost 250,000 250,000 250,000 250,000 250,000 Profit before tax and deprecation 1,950,000 1,950,000 1,950,000 1,950,000 1,950,000 Depreciation 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 Profit before tax 750,000 750,000 750,000 750,000 750,000 tax @35% 262,500 262,500 262,500 262,500 262,500 PAT 487,500 487,500 487,500 487,500 487,500 CASH FLOW From operation 1,687,500 1,687,500 1,687,500 1,687,500 1,687,500 Intital Investment (6,000,000) working capital (200,000) 200,000 value of machinery at end of project 1,000,000 Net cash flow (6,200,000) 1,687,500 1,687,500 1,687,500 1,687,500 2,887,500 Discount factor at 12% 1.000 0.893 0.797 0.712 0.636 0.567 1.254 1.405 1.574 1.762 Discounted cash flow (6,200,000) 1,506,696 1,345,265 1,201,129 1,072,437 1,638,445 NPV 563,972 IRR 9,637,500 1.554 6,200,000 9.22% 0.20 1.092231105
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.