The Walt Disney Company Valuation: This section of the report focuses on calculating current value, outlining assumptions, and estimating the future value of the corporation through forecasting the cash flows. Specifically, you must address:

Using the corporation$$s three$-$year history, calculate the current market value of equity for your corporation using the provided Excel template. In your written report, explain what it means for the corporation.

Please note: This is the same Excel template you used in Milestone One, but this time you will complete the $$Valuation$$ tab. You will enter data in the yellow highlighted cells only.

You will submit the Excel template along with your written report. You may embed pieces of the Excel template into your written report to help support your work in this section.

In your written report, outline any assumptions you have made in calculating the current value and estimating the future value of the corporation. Explain why you made these assumptions and why they are important. $($Hint: assumptions can include growth rates, margins, trends, etc.$)$

Using the provided Excel template, estimate the current value of your corporation by forecasting the cash flows over five years. Calculate EVA, NPV$,$ IRR, and MIRR. Explain your findings.