Probection actumptike Ahefyeliz Use Sheet " 8 " for this assignment. After completing DCF valuation and sensitivity analysis as shown in the video lecture, do a scenario analysis for Cooper Dental's DCF valuation, using scenario manager under What-if Analysis. - Optimistic: sales growth 18%, COGS/Sales 0.4, WACC 12%, FCF growth rate 8% - Pessimistici sales growth 5%, COGS/Sales 0.55, WACC 16%, FCF growth rate 3% Generate a summary report showing the results of estimated value per share (from both normal method and mid-year discounting method). Clearly label the variable names in the summary report. Probection actumptike Ahefyeliz Use Sheet " 8 " for this assignment. After completing DCF valuation and sensitivity analysis as shown in the video lecture, do a scenario analysis for Cooper Dental's DCF valuation, using scenario manager under What-if Analysis. - Optimistic: sales growth 18%, COGS/Sales 0.4, WACC 12%, FCF growth rate 8% - Pessimistici sales growth 5%, COGS/Sales 0.55, WACC 16%, FCF growth rate 3% Generate a summary report showing the results of estimated value per share (from both normal method and mid-year discounting method). Clearly label the variable names in the summary report