i need excel formulas please

We are evaluating a project that costs $845,000, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 51,000 units per year. Price per unit is $53, variable cost per unit is $27, and fixed costs are $950,000 per year. The tax rate is 22 percent, and we require a return of 10 percent on this project. Suppose the projections given for price, quantity, variable costs, and fixed costs are all accurate to within +10 2 percent. Calculate the best-case and worst-case NPV figures. 3 4 Input area: + 6 Initial cost $845,000 7 Project life 8 8 Units sales 51,000 9 Price per unit $53 10 Variable cost per unit $27 11 Fixed costs $950,000 12 Tax rate 2296 13 Required return 10% 14 Price uncertainty 10% 15 Quantity uncertainty 10% 16 Variable cost uncertainty 10% 17 Fixed cost uncertainty 10% 18 19 (Use cells A6 to 817 from the given information to complete this question. You must use the built-in Excel function to answer this Macron The question. The OCF must be calculated using the depreciation tax shield approach.) Output area: Scenario Unit sales Unit price Unit variable cost Fixed costs Best-case 6 Worst-case 7 Best-case OCF 28 Best-case NPV 29 Worst-case OCF 30 Worst-case NPV 31 32 33 34 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work 35 Nothing in this area will be graded, but it will be submitted with your assignment. 36 37 We are evaluating a project that costs $845,000, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 51,000 units per year. Price per unit is $53, variable cost per unit is $27, and fixed costs are $950,000 per year. The tax rate is 22 percent, and we require a return of 10 percent on this project. Suppose the projections given for price, quantity, variable costs, and fixed costs are all accurate to within +10 2 percent. Calculate the best-case and worst-case NPV figures. 3 4 Input area: + 6 Initial cost $845,000 7 Project life 8 8 Units sales 51,000 9 Price per unit $53 10 Variable cost per unit $27 11 Fixed costs $950,000 12 Tax rate 2296 13 Required return 10% 14 Price uncertainty 10% 15 Quantity uncertainty 10% 16 Variable cost uncertainty 10% 17 Fixed cost uncertainty 10% 18 19 (Use cells A6 to 817 from the given information to complete this question. You must use the built-in Excel function to answer this Macron The question. The OCF must be calculated using the depreciation tax shield approach.) Output area: Scenario Unit sales Unit price Unit variable cost Fixed costs Best-case 6 Worst-case 7 Best-case OCF 28 Best-case NPV 29 Worst-case OCF 30 Worst-case NPV 31 32 33 34 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work 35 Nothing in this area will be graded, but it will be submitted with your assignment. 36 37