I need help with Excel calculation of the WACC for Molson Coors company (weighted average cost of capital) including independent calculations of each of the following variables. Full WACC calculation including weighted average Bond Table for Debt Calculations, Equity from Dividend Growth Model, Equity from CAPM/SML Model, and Preferred Stock (if any) calculated. Cost of Equity using both the SML (aka CAPM) Approach and the Dividend Growth Model Approach with a discussion essay (1 page in APA format) explaining which approach you prefer for WACC and why http://s21.q4cdn.com/334828327/files/doc_financials/2016/annual/cfbd1a46-0f56-4f1d-8338-bb71d674c943.pdf WACC = (E/V)*Re + (P/V)*Rp + (D/V)*Rd * (1-Tc) % of financing that is equity % of financing preferred stock % of financing that is debt Cost of debt Cost of equity Cost of Preferred Stock