Bauer Industries is considering purchasing a new machine, the XD-750, which would allow it to expand its production capacity. The cost of the XD-750 is $2.75 million. Unfortunately, installing this machine will take several months and will partially disrupt production. The firm has just completed a $50,000 feasibility study to analyze the decision to buy the XD-750, resulting in the following estimates: Marketing: Once the XD-750 is operating next year, the extra capacity is expected to generate $10 million per year in additional sales, which will continue for the 10-year life of the machine. Operations: The disruption caused by the installation will decrease sales by $5 million this year. Once the machine is operating next year, the cost of goods for the products produced by the XD-750 is expecte4d to be 70% of their sales price. The increase production will require additional inventory on hand of $1 million to be added in year 0 and depleted in year 10. Human Resources: The expansion will require additional sales and administrative personnel at a cost of $2 million per year. Accounting: The XD-750 will be depreciated via the straight-line method over the 10-year life of the machine. The firm expects receivables from the new sales to be 15% of revenues and payables to be 10% of the cost of goods sold. Billinghams marginal corporate tax rate is 35%.

e. While the expected sales will be $10 million per year from the expansion, estimates range from $8 million to $12 million. What the NPV in each case? Check all possible values in the given range with the increment of $500. Use Data Table function

please show it in excel and please make sure it is correct

Also show how to do it in excel step by step