Business Finance Homework Help
Pasco Hernando State College Cooper Dentals DCF Valuation Report
Get Your Custom Essay Written From Scratch
We have worked on a similar problem. If you need help click order now button and submit your assignment instructions.
Just from $13/Page
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.