Please, I need help showing the step$-$by$-$step how to calculate these in excel: Weighted Average Cost of Capital $-$ Cott Corp. $($COT$)$

Cott Bond Issues

Name Maturity Par Value Price Market Value Weight of Issue YTM

Cott Beverages $6\mathrm{.}75\%1/1/2020625,000,000104\mathrm{.}000\mathrm{.}0571$

Cott Beverages $10\mathrm{.}00\%1/1/2021350,000,0000\mathrm{.}0600$

Cott Beverages $5\mathrm{.}375\%7/1/2022525,000,00098\mathrm{.}000\mathrm{.}0570$

Cott Beverages $5\mathrm{.}5\%1/1/2024474,100,0000\mathrm{.}0600$

Total Market Value of Debt: Pretax Cost of Debt

Settlement Date $8/23/2017$

Cott Equity

Current Price $$15\mathrm{.}21$

Estimated Growth Rate $($g$)8\mathrm{.}58\%$

Next Period's Expected Dividend $$0\mathrm{.}24$

$5-$Year Treasury Yield $1\mathrm{.}76\%$

Beta $0\mathrm{.}82$

Expected Market Risk Premium $5\mathrm{.}30\%$

Number of Shares Outstanding $139,070,000$

Cost of Equity $-$ DDM Approach

Cost of Equity $-$ CAPM Approach

Cost of Equity $-$ Risk PremiumApproach

Cost of Equity $-$ Average

Market Value of Equity

Cott Leases

Book Value Market Value Cost

Capital Lease $5,900,000$

Operating Lease $388,700,000$

Total: