Question: how to calculate weighted average cost of capital using excel?
Answer: To find the Weighted Average Cost of Capital, multiply the weight of value for the debt and equity with the cost of the debt and equity. To find the weight of the equity and debt, divide market value of the equity and the market value of the debt by the total market value of the firm's financing.