In this video, I walk you through an example in Excel that shows how you can calculate the weighted average cost of capital using data on bonds, equity and other market information on risk-free rate, equity beta and expected market risk premium.
Reference: Corporate Finance (13e) by Ross et al., Problem 13-11
Link to Google Sheet: docs.google.co...