Business Finance Homework Help

DCF VALUATION 

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%
• Pessimistic: 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.