Better Mousetrap's research laboratories have developed a new trap. The project requires an initial investment in plant and equipment of $$5$ million. This investment will be depreciated straight$-$line over four years to a value of zero, but when the project comes to an end at the end of four years, the equipment will, in fact, be sold for $$600,000.$ The firm believes that working capital at each date must be maintained at $10\%$ of next year's forecasted sales starting immediately. In other words, the investment in working capital in Year $0=2\mathrm{.}0$ Million x $10\%=$$$200,000.$ This means that the CF from the change in working capital will be different for each year. Also, remember that the working capital is assumed to be recouped at the end of the project $($working capital Year$4=0).$ Production costs are estimated at $30\%$ of revenues. There are no marketing expenses. Sales forecasts are given below. The firm pays tax at $25\%$ and the required return on the project is $14\%.$ What is the NPV$?$

Year $0$ : sales $=0$ Million

Year $1$: sales$=2\mathrm{.}0$ Million

Year $2$: sales$=2\mathrm{.}4$ Million

Year $3$: sales$=5\mathrm{.}8$ Million

Year $4$: sales$=3\mathrm{.}6$ Million Solve using excel