Question: show formulas/ excel work pls! Better Mousetraps has developed a new trap. It can go into production for an initial investment in equipment of $5.7

show formulas/ excel work pls! Better Mousetraps has developed a new trap.show formulas/ excel work pls!

Better Mousetraps has developed a new trap. It can go into production for an initial investment in equipment of $5.7 million. The equipment will be depreciated straight line over 6 years to a value of zero, but in fact it can be sold after 6 years for $671,000. The firm believes that working capital at each date must be maintained at a level of 10% of next year's forecast sales. The firm estimates production costs equal to $1.80 per trap and believes that the traps can be sold for $8 each. Sales forecasts are given in the following table. The project will come to an end in 6 years, when the trap becomes technologically obsolete. The firm's tax bracket is 35%, and the required rate of return on the project is 11%. Use the MACRS depreciation schedule. 0 1 Year: Sales (millions of traps) 2 0.5 3 0.7 4 0.7 5 0.5 6 0.3 Thereafter 0 0 0.4 a. What is project NPV? (Do not round intermediate calculations. Enter your answer in millions rounded to 4 decimal places.) NPV million b. By how much would NPV increase if the firm depreciated its investment using the 5-year MACRS schedule? (Do not round intermediate calculations. Enter your answer in whole dollars not in millions.) The NPV increases by

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!