Use Sheet $"7"$ for this assignment. After completing DCF valuation and sensitivity analysis, do a scenario analysis for Cooper Dental's DCF valuation, using scenario manager under What$-$if Analysis.

Optimistic: sales growth BK$,$ COGS$/$Sales $0\mathrm{.}35.$ WACC $12\%.$ FCF growth rate $5\%$

Pessimistic: sales growth $2\%,$ COGS$/$Sales $0\mathrm{.}55,$ WACC $16\%,$ FCF growth rate $1\%$

Generate a summary report showing the results of estimated value per share from both normal method and mid$-$year discounting method. Clearly label the varlablie names in the summary report.