please help with excel work thanks

Clybiad A1 Fogo Accessibility tab summary Students please use the information below to complete the question completing the required cells. Given B D F G H 1 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 feed costs are all accurate to within +10 2. percent. Calculate the best-case and worst-case NPV figures 3 Input area: 4 5 6 initial cost 7 Project life 8 Units sales 9 Price per unit 10 Variable cost per unit 11 Fixed costs 12 Tax rate 13 Required return 14 Price uncertainty 15 Quantity uncertainty 16 Variable cost uncertainty 17 Fixed cost uncertainty 18 5845,000 8 51.000 $53 $27 $950,000 223 10% 10% 10% 10% 10 las dirightyear lite, and has no salvage value. Assume D E F G C 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: 5 6 Initial cost 5845,000 7 Project life 8 8 Units sales 51.000 9 Price per unit S53 10 Variable cost per unit $27 11 Fixed costs $950,000 12 Tax rate 22 13 Required return 10 14 Price uncertainty 10% 15 Quantity uncertainty 1094 16 Variable cost uncertainty 10% 17 Fixed cost uncertainty 10% 18 Graded Worksheet + Calculation Mode: Automatic Workbook Statistics Clipboard Font H36 B D E F G 15 Quantity uncertainty 10% 16 Variable cost uncertainty 1046 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 20 question. The OCF must be calculated using the depreciation tax shield approach.) 21 22 Output area: 23 24 Scenario Unit sales Unit price Unit variable cost Fixed costs 25 Best-case 26 Worst-case 27 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 Graded Worksheet H B F G 16 Variable cost uncertainty 10% 17 Fixed cost uncertainty 10% 18 19 (Use cells A6 to 317 from the given information to complete this question. You must use the built-in Excel function to answer this 20 question. The OCF must be calculated using the depreciation tax shield approach.) 21 22 Output area: 23 24 Scenario Unit sales Unit price Unit variable cost Fixed costs 25 Best-case 26 Worst-case 27 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 I will be submitted with your asslenment NSROM Clybiad A1 Fogo Accessibility tab summary Students please use the information below to complete the question completing the required cells. Given B D F G H 1 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 feed costs are all accurate to within +10 2. percent. Calculate the best-case and worst-case NPV figures 3 Input area: 4 5 6 initial cost 7 Project life 8 Units sales 9 Price per unit 10 Variable cost per unit 11 Fixed costs 12 Tax rate 13 Required return 14 Price uncertainty 15 Quantity uncertainty 16 Variable cost uncertainty 17 Fixed cost uncertainty 18 5845,000 8 51.000 $53 $27 $950,000 223 10% 10% 10% 10% 10 las dirightyear lite, and has no salvage value. Assume D E F G C 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: 5 6 Initial cost 5845,000 7 Project life 8 8 Units sales 51.000 9 Price per unit S53 10 Variable cost per unit $27 11 Fixed costs $950,000 12 Tax rate 22 13 Required return 10 14 Price uncertainty 10% 15 Quantity uncertainty 1094 16 Variable cost uncertainty 10% 17 Fixed cost uncertainty 10% 18 Graded Worksheet + Calculation Mode: Automatic Workbook Statistics Clipboard Font H36 B D E F G 15 Quantity uncertainty 10% 16 Variable cost uncertainty 1046 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 20 question. The OCF must be calculated using the depreciation tax shield approach.) 21 22 Output area: 23 24 Scenario Unit sales Unit price Unit variable cost Fixed costs 25 Best-case 26 Worst-case 27 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 Graded Worksheet H B F G 16 Variable cost uncertainty 10% 17 Fixed cost uncertainty 10% 18 19 (Use cells A6 to 317 from the given information to complete this question. You must use the built-in Excel function to answer this 20 question. The OCF must be calculated using the depreciation tax shield approach.) 21 22 Output area: 23 24 Scenario Unit sales Unit price Unit variable cost Fixed costs 25 Best-case 26 Worst-case 27 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 I will be submitted with your asslenment NSROM