WACC Calculations: If the long-term debt for the firm is $13.693 Billion, the total equity for the firm is $3.014 Billion, the cost of debt is 0.0570, the tax rate is 0.35, there is no preferred equity, what is the WACC utilizing the CAPM rs and then utilizing the DCF rs? Note that two WACCs need to be calculated.

Please show all calculations in Excel. No credit will be earned unless you show your calculations.