Calculate the weighted average of interest rates in Microsoft Excel to compute the most accurate average interest rate among a group of lenders who received different rates.

Weighted averages are used often in investing, especially in how we measure the performance of our portfolios. Here's the WACC formula.

Here's the general formula for calculating weighted average cost of capital and why it's a useful metric for investors to understand.