Question: I need help with this project that I have attached. I am using The Walt Disney Company for this project and am having trouble locating
I need help with this project that I have attached. I am using The Walt Disney Company for this project and am having trouble locating all the required information. I need to submit this project no later than Sunday. Are you able to help me with this?

The Module 6 course project assignment let's you explore the company-level valuation, combining many aspects of the entire course into one activity. The requirements of the assignment are as follows: 1. Calculate the Intrinsic Value of Your Company: You will use the Discounted Cash Flow (DCF) valuation model to calculate the intrinsic value of your chosen company. This model involves three primary steps: i) calculating the company's cost of capital, ii) calculating the free cash flows to the firm, and ii) applying the time-value-ofmoney concept to discount your projected cash flow values back to the present using the company's cost of capital as the discount rate. a. Calculating the Cost of Capital: i. The company's cost of capital can be calculated using the Weighted Average Cost of Capital (WACC) formula: WACC = D/V * eD *(1-Tc) + E/V * rE i. b Using the website, ThatsWACC (www.thatswacc.com), enter your company's "ticker symbol", identify the relevant terms from above and calculate the WACC (please show your calculations). Calculating Free Cash Flow to the Firm: i. Estimate the free cash flows available to the firm ("FCFF"). To do this we can use the below formula: FCFF = Cash Flow from Operations - Capital Expenditures + Interest * (1 - Tax Rate) The Cash Flow from Operations and Capital Expenditures can be found on the Statement of Cash Flows in Yahoo! Finance. The Interest expense (if any exists) is on the Income Statement. The Tax Rate is the one you used to calculate the WACC, above. For additional details on these calculations please refer to this external resource. c. Calculating Firm Value: i. You can now combine the two items above to estimate a present value of the firm. To simplify this calculation you should assume a constant growth rate of 3% in the Free Cash Flows to the Firm and apply the constant growth model: Firm Value = FCFF * (1+g) / (WACC - g) 2. Comparison to Market Capitalization: a. On the Key Statistics page in Yahoo! Finance identify and indicate the Market Capitalization ("market cap"). What does this value represent? b. Compare the market cap to your calculated value. i. To compare the market cap from Yahoo! Finance to the firm value you calculated in the previous section above you need to first subtract the value of the debt from your firm value calculation. ii. How does your intrinsic value (less debt) compare to the market cap of the company on Yahoo! Finance? iii. What might account for any differences between these two values? 3. Paper Mechanics should be as follows: a. There is no minimum page length requirement for this paper. b. The paper should be in APA format (i.e. cover page, double-spaced, 12 pt font, reference section at end, etc.). c. The paper should include at least 1 source, such as the annual report, Yahoo! Finance or Google Finance, the company's web site, etc. d. The paper should be divided into the sections indicated above (label each section clearly). Submit your completed assignment to the drop box below. Please check the Course Calendar for specific due dates. Save your assignment as a Microsoft Word document. (Mac users, please remember to append the ".docx" extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below: Jstudent_exampleproblem_101504
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
