Company-Level Valuation Using the company (Walt Disney) In t

Company-Level Valuation Using the company (Walt Disney) In t

Company-Level Valuation Using the company (Walt Disney) In this assignment you conduct a two-tier DCF company-level valuation analysis and perform a sensitivity analysis. The requirements of the assignment are as follows: 1. Calculate the Intrinsic Value of Your Company: You will use the two-tier company-level Discounted Cash Flow (DCF) valuation model to calculate the intrinsic value of your chosen company. 2. Conduct a Sensitivity Analysis: 3. Paper Mechanics: Please complete your work in Excel. Include all supporting calculations and input data sufficient to follow your valuation model. Your spreadsheet should be professional in its presentation with appropriate formatting and organization.