pls use excel

3. BMT has developed a new product. It can go into production for an initial investment of $4,000,000. The equipment will be depreciated using straight-line depreciation over 5 25 percent of next year's forecast sales. The firm estimates that variable costs are equal to 50% of sales and fixed costs are $700,000 per year. Sales forecasts in dollars are below. firm's tax rate is 35 percent, and the discount rate is 10 percent. Calculate the NPV. Year 0 Sales forecast (in $): 0 1 3,400,000 2 3,900,000 3 4,300,000 4 5 4,400,000 4,500,000