Hello, please help with showing me how to get total market value of KO's debt and how to find weighted debt, equity KO's WACC. I have been searching for four day and am stuck. I don't understand the instructions and what values to use. I am thankful for any help and explaination provided.

Callable Coupon Yield Yes 3.440 0.804 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes 5 Issuer Name 6 Coca Cola Co. 7 Coca Cola Co. 8 Coca Cola Co. 9 Coca Cola Co. 10 Coca Cola Co. 11 Coca Cola Co. 12 Coca Cola Co. 13 Coca Cola Co. 14 Coca Cola Co. 15 Coca Cola Co. 16 Coca Cola Co. 17 Coca Cola Co. 18 Coca Cola Co. 19 Coca Cola Co. 20 Coca Cola Co. 21 Coca Cola Co. 22 Coca Cola Co. 23 Coca Cola Co. 24 Coca Cola Co. 25 Coca Cola Co. 26 Coca Cola Co. 27 Coca Cola Co. 28 Coca Cola Co. 29 Coca Cola Co. 30 Coca Cola Co. 31 Coca Cola Co. 32 Coca Cola Co. 33 Bond Symbol k0 GC KO GO KO.GP KOGU KO3976546 KO4066196 KO4066189 K04303885 K04303881 KO4368385 KO4399369 KO4399370 KO4499432 K04499433 K04880708 K04880709 KO4969576 KO4969568 KO4969570 KO4969566 KO4909667 KO4982990 K04962991 KO4902889 KO4982800 KO4082891 KO.GQ Yes Maturity 7.375 20 year 3.150 20 year 3.300 20 year 3.300 20 year 2.500 20 year 2.450 20 year 3.200 20 year 1.875 20 year 2.875 20 year 2.550 20 year 1.550 20 year 2.250 20 year 2 200 20 year 2.900 20 year 1.750 20 year 2.125 20 year 2.950 20 year 3.375 20 year 3.450 20 year 4.125 20 year 4.200 20 year 1.450 20 year 1.650 20 year 2.500 20 year 2.600 20 year 2.750 20 year 3.300 20 year Amount Outstanding Market Value of Issue 95,835.00 $204.952 1,000,000.00 $100.720 350.00 - 1,324,080.00 $103.332 750,000.00 $105.956 1,250,000.00 $100.352 1,500,000.00 $109.373 1,500,000.00 $100.413 1,750,000.00 $111.440 500,000.00 $110.487 1,000,000.00 $101.617 1,000,000.00 $109.684 500,000.00 $103.761 500,000.00 $113.153 1,000,000.00 $105.122 1,000,000.00 $108.379 1,000,000.00 $110.804 1,000,000.00 $116.013 1,250,000.00 $120.440 500,000.00 $132.474 1,250,000.00 $139.758 1,500,000.00 $104.130 1,500,000.00 $104.606 1,000,000.00 $107.902 1,500,000.00 $106.720 1,000,000.00 $108.774 $102.370 0.272 0.273 1.132 0.316 0.291 0.658 0.717 0.083 0.630 0.148 0.911 0.487 1.154 0.600 0.896 1.204 2.101 2.335 0.829 1.154 2.015 2.288 2.406 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes KO's Market Capitalization: Number of Shares Outstanding KO's Current Stock Price KO's Market Capitalization 4.29 48.48 207.98 Ko's Cost of Equity Calcultion Market Risk Premium (Given in the instructions) KO Beta KO's cost of equity using CAPM 10% 0.54 0.0600 E(RI) = Rf + [E(RM) - Rf]* Bi KO's cost of debt: Coca Colas Longet Maturity Bond: Current Price Offer Price Why is there such a difference? 8 nn 100 year bond 95,835.000 98.93 Total market value of KO's debt: Remember to use the information of only Coca Cola Company bonds Weight of debt: Weight of equity: KO's weighted cost of equity: KO's WACC: KO's effective cost of debt: KO's Cash: Net debt: Weight of debt: Weight of equity: KO's WACC with net debt: Assume that Coca Cola Co's policy is to use the yield to maturity of 20 year obligations as its cost of debt. Find the yield to maturity for your chosen bond issue (it is in the column titled "Yield") and enter that yield as your pretax cost of debt into your spreadsheet. Next, you will calculate the market value of the debt. To simplify the project, you will only be required to copy and paste the data of Coca Cola Co into an Excel table. You now have the price for each bond issue, so now you need to know the size of each issue. Noting that the amount outstanding is quoted in thousands of dollars (eg $60,000 means 60 million) record the issue amount in the appropriate row of your spreadsheet. Repeat this step for all of the bond issues. The price for each bond issue in your spreadsheet is reported as a percentage of the bond's par value. For example, 104.50 means that the bond issue is trading at 104.5% of its par value. You can calculate the market value of each bond issue by multiplying the amount outstanding by Price /100. Do so for each issue and then calculate the total of all the bond issues. This is the market value of Coca Cola's debt. Compute the weights for Coca Cola's equity and debt based on the market value of equity (Market Capitalization) and Coca Cola's market value of debt. Callable Coupon Yield Yes 3.440 0.804 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes 5 Issuer Name 6 Coca Cola Co. 7 Coca Cola Co. 8 Coca Cola Co. 9 Coca Cola Co. 10 Coca Cola Co. 11 Coca Cola Co. 12 Coca Cola Co. 13 Coca Cola Co. 14 Coca Cola Co. 15 Coca Cola Co. 16 Coca Cola Co. 17 Coca Cola Co. 18 Coca Cola Co. 19 Coca Cola Co. 20 Coca Cola Co. 21 Coca Cola Co. 22 Coca Cola Co. 23 Coca Cola Co. 24 Coca Cola Co. 25 Coca Cola Co. 26 Coca Cola Co. 27 Coca Cola Co. 28 Coca Cola Co. 29 Coca Cola Co. 30 Coca Cola Co. 31 Coca Cola Co. 32 Coca Cola Co. 33 Bond Symbol k0 GC KO GO KO.GP KOGU KO3976546 KO4066196 KO4066189 K04303885 K04303881 KO4368385 KO4399369 KO4399370 KO4499432 K04499433 K04880708 K04880709 KO4969576 KO4969568 KO4969570 KO4969566 KO4909667 KO4982990 K04962991 KO4902889 KO4982800 KO4082891 KO.GQ Yes Maturity 7.375 20 year 3.150 20 year 3.300 20 year 3.300 20 year 2.500 20 year 2.450 20 year 3.200 20 year 1.875 20 year 2.875 20 year 2.550 20 year 1.550 20 year 2.250 20 year 2 200 20 year 2.900 20 year 1.750 20 year 2.125 20 year 2.950 20 year 3.375 20 year 3.450 20 year 4.125 20 year 4.200 20 year 1.450 20 year 1.650 20 year 2.500 20 year 2.600 20 year 2.750 20 year 3.300 20 year Amount Outstanding Market Value of Issue 95,835.00 $204.952 1,000,000.00 $100.720 350.00 - 1,324,080.00 $103.332 750,000.00 $105.956 1,250,000.00 $100.352 1,500,000.00 $109.373 1,500,000.00 $100.413 1,750,000.00 $111.440 500,000.00 $110.487 1,000,000.00 $101.617 1,000,000.00 $109.684 500,000.00 $103.761 500,000.00 $113.153 1,000,000.00 $105.122 1,000,000.00 $108.379 1,000,000.00 $110.804 1,000,000.00 $116.013 1,250,000.00 $120.440 500,000.00 $132.474 1,250,000.00 $139.758 1,500,000.00 $104.130 1,500,000.00 $104.606 1,000,000.00 $107.902 1,500,000.00 $106.720 1,000,000.00 $108.774 $102.370 0.272 0.273 1.132 0.316 0.291 0.658 0.717 0.083 0.630 0.148 0.911 0.487 1.154 0.600 0.896 1.204 2.101 2.335 0.829 1.154 2.015 2.288 2.406 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes KO's Market Capitalization: Number of Shares Outstanding KO's Current Stock Price KO's Market Capitalization 4.29 48.48 207.98 Ko's Cost of Equity Calcultion Market Risk Premium (Given in the instructions) KO Beta KO's cost of equity using CAPM 10% 0.54 0.0600 E(RI) = Rf + [E(RM) - Rf]* Bi KO's cost of debt: Coca Colas Longet Maturity Bond: Current Price Offer Price Why is there such a difference? 8 nn 100 year bond 95,835.000 98.93 Total market value of KO's debt: Remember to use the information of only Coca Cola Company bonds Weight of debt: Weight of equity: KO's weighted cost of equity: KO's WACC: KO's effective cost of debt: KO's Cash: Net debt: Weight of debt: Weight of equity: KO's WACC with net debt: Assume that Coca Cola Co's policy is to use the yield to maturity of 20 year obligations as its cost of debt. Find the yield to maturity for your chosen bond issue (it is in the column titled "Yield") and enter that yield as your pretax cost of debt into your spreadsheet. Next, you will calculate the market value of the debt. To simplify the project, you will only be required to copy and paste the data of Coca Cola Co into an Excel table. You now have the price for each bond issue, so now you need to know the size of each issue. Noting that the amount outstanding is quoted in thousands of dollars (eg $60,000 means 60 million) record the issue amount in the appropriate row of your spreadsheet. Repeat this step for all of the bond issues. The price for each bond issue in your spreadsheet is reported as a percentage of the bond's par value. For example, 104.50 means that the bond issue is trading at 104.5% of its par value. You can calculate the market value of each bond issue by multiplying the amount outstanding by Price /100. Do so for each issue and then calculate the total of all the bond issues. This is the market value of Coca Cola's debt. Compute the weights for Coca Cola's equity and debt based on the market value of equity (Market Capitalization) and Coca Cola's market value of debt