We are evaluating a project that costs $$899,000,$ has a life of fourteen years, and has no salvage value. Assume that depreciation is straight$-$line to zero over the life of the project. Sales are projected at $89,000$ units per year. Price per unit is $$37,$ variable cost per unit is $$26,$ and fixed costs are $$908,889$ per year. The tax rate is $22$ percent, and we require a return of $13$ percent$$on this project. The projections given for price, quantity, variable costs, and fixed costs are all accurate to within $+/-21$ percent. $$ a$.$Calculate the best$-$case NPV$.$ b$.$Calculate the worst$-$case NPV$.$

Could you also show how to solve this in excel? Thank you