Wendy and Wayne are evaluating a project that requires an initial investment of $824,000 in fixed assets. The project will last for thirteen years, and the assets have no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 121,000 units per year. Price per unit is $37, variable cost per unit is $28, and fixed costs are $831,416 per year. The tax rate is 30 percent, and the required annual return on this project is 20 percent. The projections given for price, quantity, variable costs, and fixed costs are all accurate to within +/- 16 percent.

Required:

(a) Calculate the best-case NPV. (Do not round your intermediate calculations.)

(b) Calculate the worst-case NPV. (Do not round your intermediate calculations.)

Please show the breakdown of the problem in chart form with formulas in Excel.