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.