Question: Please use excel to solve this and post the steps. These answers are correct, but I am unsure how to reach them. Thank you! Better

Please use excel to solve this and post the steps. These answers

Please use excel to solve this and post the steps. These answers are correct, but I am unsure how to reach them. Thank you!

Better Mousetraps has developed a new trap. It can go into production for an initial investment in equipment of $6 million. The equipment will be depreciated straight-line over 6 years but, in fact, it can be sold after 6 years for $500,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.50 per trap and believes that the traps can be sold for $4 each. Sales forecasts are given in the following table. The project will come to an end in 5 years, when the trap becomes technologically obsolete. The firm's tax bracket is 40%, and the required rate of return on the project is 12%. Suppose the firm can cut its requirements for working capital in half by using better inventory control systems. By how much will this increase project NPV? Note: Do not round your intermediate calculations. Enter your answer in millions rounded to 4 decimal places

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!