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 2-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, Forecast_incst, inc_st actuals, WACC, Comcast coorporation cash-flows, 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 one-page 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 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!