Using excel, do a scenario analysis for Cooper Dental stock valuation.
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 result of estimated value per share. Clearly label the variable names in the summary report.
Assumptions: Current assets/sales 15% Current liabilities/sales 8% NFA/sales 77% Depreciation rate 10% Interest rate on debt 10% Interest rate on cash 8% Tax rate 40% Dividend payout ratio 40%
Please upload screenshots of step by step on how to build this, since I need to know how to do it myself. Thanks in advance.