I only need help for Questions 11 and 12, but I included the information that is necessary to complete those questions. It needs to be in excel and show me how to do it. Thanks!

1. Risk-free rate

   A.Include a label and input cell for the Risk-free Rate () B. The U.S. Treasury website (Link to U.S. Treasury) provides the Treasury rates. C. To make it easier to look up the Risk-free rate in the future include a hyperlink to the U.S. Treasury website to your model. D. Choose the 10-year rate on May-06-2022 as the risk-free rate to use.

2. Company Name/Ticker

   A. Include a label and input cell for the Company Name. Enter Walt Disney Company as the name. B. Include a label and input cell for the Stock Ticker. Enter the Disney stock ticker as the Stock Ticker.

3. Market Value of Equity (Market Cap)

   A. Include a label and input cell for Market Value of Equity (Market Cap) B. Go to http://finance.yahoo.com to get the Market Cap (market value of equity) for Disney (DIS).

4. Beta

A. Include a label and input cell for Beta ().

B. Go to http://finance.yahoo.com to get the Beta for Disney (DIS).

5. Cost of Equity Capital A. Include a label and input cell for Expected Market Return (() ) .

   B. Assume an Expected Market Return of 7%. C. Include a label for Cost of Equity (rE). D. Calculate Disneys cost of equity capital (rE) using the CAPM:

6. Cost of Debt (Pre-Tax)

   A. Include a label and input cell for the Cost of Debt Pre-tax (rD). B. To get Disneys cost of debt you will need the yield to maturity on the firms existing long- term bonds. The bond data from Morningstar is provided in an excel file on canvas. Assume that Disneys policy is to use the yield to maturity on 10-year obligations as its cost of debt. Find the bond issue that is as close to 10 years from maturity as possible (look at Maturity Date). Hint: Ten years from now is 2032. Find the yield to maturity for your chosen bond issue (it is in the column titled Yield to Maturity %) and enter that yield as your pre-tax cost of debt on your spreadsheet.

7. Cost of Debt (After-Tax)

   A. Create a label and input cell for the Tax-Rate (Tc). B. Assume that Disney has a tax rate of 21%. C. Create a label for the Cost of Debt After-tax (rD After-tax). D. Calculate the after-tax cost of debt capital:

8. Market Value of Debt

A. Include a label and input cell for the Market Value of Debt (MV Debt). B To get Disneys market value of its long-term debt, you will need the price and yield to maturity on the firms existing long-term bonds. The bond data from Morningstar provided in an excel file on canvas includes the price and the amount outstanding of each bond issue. The price for each bond issue in your spreadsheet is reported as a percentage of the bonds par value. For example, 104.50 means that the bond issue is trading at 104.5% of its par value. The current amount outstanding for each bond is in the column Amount $ (Mil). Calculate the market value of each bond issue: C. Calculate the total market value of all bond issues by adding together the market value of each bond issue. This is the market value of Disneys debt. NOTE: the market value of bonds is in millions of dollars. Make sure to put the total market value of bonds in billions of dollars so that it matches the total market value of equity. To get from millions to billions you can divide by 1000. For example, Total Market Value of Debt = sum(Market Value of each Bond) / 1000

9. Weight of Debt (XD) and Weight of Equity (XE)

A. Include a label for Weight of Debt (XD) and Weight of Equity (XE). B.Calculate the weights for Disneys equity (XE) and debt (XD) based on Disneys market value of equity and market value of debt.

10. WACC (Weighted Average Cost of Capital)

A. Include a label for the WACC. b. Calculate the WACC.

11. Calculate WACC for different values of Expected Market Returns.

1. Create a table showing what the WACC will be for the following Expected Market Returns:

   4%, 5%, 6%, 7%, 8%, 9%, 10%.

2. You can build the table yourself OR you can use a data table

12. Use a line graph to show the WACC for different values of Expected Market Returns.

a. Include appropriate title, axis labels and axis values.