Question: 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

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

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% input two scenarios into scenario manager Year...

do a scenario analysis for Cooper Dental 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...

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...

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...

Please do everything in excel Year 2017 Income statement Sales $ 10,000,000.00 Cost of goods sold $ (5,000,000.00) Depreciation $ (1,000,000.00) Interest payments on debt $ (320,000.00) Interest...

1) You work as an analyst covering a firm called Mernie Badoff Inc. Your boss is concerned about the large investment he has in this firm and wants you to produce a valuation template to help him...

You work as an analyst covering a firm called Mernie Badoff Inc. Your boss is concerned about the large investment he has in this firm and wants you to produce a valuation template to help him decide...

# 1-5: ASSUMPTIONS: #6 -Conduct a scenario analysis showing the value per share under optimistic/pessimistic scenarios. Optimistic: Sales growth 18%, COGS/sales 40%, WACC 12%, FCF growth 8%....

M2.Q1: You work as an analyst covering a firm called Mernie Badoff Inc. Your boss is concerned about the large investment he has in this firm and wants you to produce a valuation template to help him...

State the reason for the rise in the levels of the liquids when air is sucked from the tubes. Explain in detailed.

You have the following data, knowing that it is a total of Baghdad Airport / for a month 7/2020 50,000 shekels local sales 100,000 shekels sales abroad 20,000 shekels Israeli sales 60,000 shekels of...

5 Which of the following resolutions requires the directors of a private company to give a statutory declaration of solvency? A resolution to: A Commence a creditors voluntary winding-up. B Reduce...

facebook in its bid to connect people worldwide primarily follows whichinternational internstional strategy?

Develop a step-by-step plan of actions you would take and the order in which you would undertake them if you were made HR director of the Reynolds subsidiary.

What problems do you see with the incentives for (a) executives, (b) production workers, (c) salespeople, and (d) hourly employees?

What laws were probably being violated?