please solve with excel and show the steps

B G H 1 2 E 4 5 6 7 C D Calculating Amgen's WACC 8.00% 200% 7.65% 0.60 Calculating Amgen's WACC 760,000,000 157.00 Assume that E6M) - 8% and if- 4%. ure the data provided to calculate the followQuesting 119.996,400,000 Amgen's variables as of year-end 2014 $34 80 a. Calculate Amgen's cost fo debt 26,508,800,000 43 231,000,000 b. Calculate Amgen's cost of equity c. What is Angon's WACC? 163.227.400.000 Tax rate Beta Outstanding shares Market value of stock Market value of equity Book value per share Total book value of equity Argen's debt Debt to equity ratio (book) Amgen's total value 9 10 11 12 13 14 163 Interest paid 2014 Debt, end 2014 Debt end-2013 Average debt 2013-2014 1,071,000,000 43,231,000,000 44,029,000,000 15 16 17 18 19 20 Parta 21 Part b 22 23 Parte 24 25 Amgon's cou of debt Argen's cost of equity Amgen's WACC