Question: please perform an Enterprise Value valuation ( or equivalently Share Valuation ) exercise, akin to Merck & Co . Statement. Find your current best estimate
please perform an Enterprise Value valuation or equivalently Share Valuation exercise, akin to Merck & Co Statement. Find your current best estimate for the EV and share value using a proforma model for Comcast corporation company. The main expectation is to use the ideas and make forecasts about the future Free Cash Flows and WACC and use them to estimate EV After estimating the EV or share value you are expected to perform a D sensitivity analysis for the EV or share value by varying key assumptions in your model say WACC and FCFF long term growth rate, or WACC and sales growth growth, etc. Provide Company's income statement, Tax rate of those four years, OPCostAnalysis, PFBS Balance sheet, Forecast, Forecastincst, incst actuals, WACC, Comcast coorporation cashflows, YoY sales growth with graph in details with with reallife data. And please submit a An excel file with several sheets that show your work, and, b a onepage summary in word doc or pdf of your analysis comment on whether you think the stock is undervalued or overvalued, on whether the assumptions in your model are robust etc Can you please show the work in excel with formulas?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
