Question: how to calculate weighted average cost of debt 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.