need help! can you show excel fuctions as well! thankyou so much!

c. Now conduct a scenario analysis. Assume that there is a 25% probability that best-case conditions, with each of the variables discussed in Part b being 20% better than its base-case value, will occur. There is a 25% probability of worst- case conditions, with the variables 20% worse than base, and a 50% probability of base-case conditions. (Hint: Use Scenario Manager. Go to the Data menu, choose What+f-Analyis, the choose Scenario Manager. After you create the Scenario's, you can pick a scenario and type in the resulting NPV (but be sure to return the Scenario to the base-case afterward). Or you can create a Scenario Summary and use a cell reference to the Scenario Summary worksheet to show the NPV for each scenario.) Variable Costs per Unit Scenario Probability Unit Sales NPV Sales Price per Unit $28.80 $24.00 $19.20 Best Case Base Case Worst Case 25% 50% 25% 1,200 1,000 800 $14.40 $18.00 $21.60 Expected NPV = Standard Deviation = Coefficient of Variation = Std Dev / Expected NPV = 0.8 to 1.2 d. If the project appears to be more or less risky than an average project, find its risk-adjusted NPV, IRR, and payback. CV range of firm's average-risk project: Low-risk WACC 8% WACC = High-risk WACC = 13% Risk-adjusted WACC = Risk adjusted NPV = 10% IRR = Payback e. On the basis of information in the problem, would you recommend that the project be accepted? c. Now conduct a scenario analysis. Assume that there is a 25% probability that best-case conditions, with each of the variables discussed in Part b being 20% better than its base-case value, will occur. There is a 25% probability of worst- case conditions, with the variables 20% worse than base, and a 50% probability of base-case conditions. (Hint: Use Scenario Manager. Go to the Data menu, choose What+f-Analyis, the choose Scenario Manager. After you create the Scenario's, you can pick a scenario and type in the resulting NPV (but be sure to return the Scenario to the base-case afterward). Or you can create a Scenario Summary and use a cell reference to the Scenario Summary worksheet to show the NPV for each scenario.) Variable Costs per Unit Scenario Probability Unit Sales NPV Sales Price per Unit $28.80 $24.00 $19.20 Best Case Base Case Worst Case 25% 50% 25% 1,200 1,000 800 $14.40 $18.00 $21.60 Expected NPV = Standard Deviation = Coefficient of Variation = Std Dev / Expected NPV = 0.8 to 1.2 d. If the project appears to be more or less risky than an average project, find its risk-adjusted NPV, IRR, and payback. CV range of firm's average-risk project: Low-risk WACC 8% WACC = High-risk WACC = 13% Risk-adjusted WACC = Risk adjusted NPV = 10% IRR = Payback e. On the basis of information in the problem, would you recommend that the project be accepted