Question: how to calculate the weighted average cost of capital in excel?
Answer: w = the respective weight of debt, preferred stock/equity, and equity in the total capital structure. t = tax rate. D = cost of debt. P = cost of preferred stock/equity. E = cost of equity.