Please be more specific about the formulaexcelyou use.

3. BMT has developed a new product. It can go into production for an initial investment of $6,000,000. The equipment will be depreciated using straight-line depreciation over 5 years to a value of zero. The firm believes that net working capital at each date will equal 30 percent of next year's forecast sales. The firm estimates that variable costs are equal to 40% of sales and fixed costs are $900,000 per year. Sales forecasts in dollars are below. The project will come to an end after 5 years, when the product becomes obsolete. The firm's tax rate is 35 percent, and the discount rate is 9 percent. Calculate the NPV. Year 0 4 Sales forecast (in $): 0 3,700,000 4,900,000 5,300,000 5,400,000 4,500,000 4. In problem 3, perform sensitivity analysis on the following assumptions and find the revised NPV (a) variable costs are equal to 45% of sales (b) the discount rate is 10%