b. Create hyperlinks to the FINRA bond quote website and the SEC EDGAR database and find the information for the company's bonds. Create a table that calculates the cost of debt for the company. Assume the tax rate is 35 percent. l structure equals to the market value weight) Quoted Price Market Value Weight Weighted cost Maturity YTM Book Value Market Value of debt 2018 2019 2019 2020 2021 2023 2025 12 12 1. 500% 1.200% 2.000% 2.700% 3.100% 3. 200% 3. 200% 99.840 99.420 97.530 99.880 100.100 100.130 99.550 Total market value 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 14 10 0 Cost of debt- lax rate: 35% Aftertax cost of debt: Cost of equity: Market value of equity: Aftertax cost of debt: Market value of debt: c. Finally, calculate the market value weights for debt and equity. What is the WACC for the company? Weight of debt: Weight of equity: WACC: Case Stud You want to calculate the WACC for General Electric Company (GE) Complete the following steps to construct a spreadsheet that can be updated a. State the company that you chose. Find out the company's ticker symbol, create hyperlinks to the web pages that you will need to find all of the information necessary to calculate the cost of equity. Use a market risk premium of seven percent when using CAPM. Ticker symbol GE Stock quote link Stock price Dividend ://finance.yahoo.com/quote/GE?D-GE&.tsrc=fin-srch 7.47 0.37 Key statistics link Beta: Shares outstanding ://finance.vahoo.com/quote/GE/ke tistics?p GE 0.60 8,700,000,000 Bond center link Risk-free rate: //finance.vahoo.com/bonds/ 0.07% Market risk premium Market value of equity: Cost of equity 700% 6498900000000.00% CAPM: 4.27% b. Create hyperlinks to the FINRA bond quote website and the SEC EDGAR database and find the information for the company's bonds. Create a table that calculates the cost of debt for the company. Assume the tax rate is 35 percent. l structure equals to the market value weight) Quoted Price Market Value Weight Weighted cost Maturity YTM Book Value Market Value of debt 2018 2019 2019 2020 2021 2023 2025 12 12 1. 500% 1.200% 2.000% 2.700% 3.100% 3. 200% 3. 200% 99.840 99.420 97.530 99.880 100.100 100.130 99.550 Total market value 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 14 10 0 Cost of debt- lax rate: 35% Aftertax cost of debt: Cost of equity: Market value of equity: Aftertax cost of debt: Market value of debt: c. Finally, calculate the market value weights for debt and equity. What is the WACC for the company? Weight of debt: Weight of equity: WACC: Case Stud You want to calculate the WACC for General Electric Company (GE) Complete the following steps to construct a spreadsheet that can be updated a. State the company that you chose. Find out the company's ticker symbol, create hyperlinks to the web pages that you will need to find all of the information necessary to calculate the cost of equity. Use a market risk premium of seven percent when using CAPM. Ticker symbol GE Stock quote link Stock price Dividend ://finance.yahoo.com/quote/GE?D-GE&.tsrc=fin-srch 7.47 0.37 Key statistics link Beta: Shares outstanding ://finance.vahoo.com/quote/GE/ke tistics?p GE 0.60 8,700,000,000 Bond center link Risk-free rate: //finance.vahoo.com/bonds/ 0.07% Market risk premium Market value of equity: Cost of equity 700% 6498900000000.00% CAPM: 4.27%