Question: how to calculate a weighted average interest rate in excel?
Answer: Multiply each loan amount by its interest rate to obtain the "per loan weight factor." Add the per loan weight factors together. Add the loan amounts together. Divide the "total per loan weight factor" by the "total loan amount," and then multiply by 100 to calculate the weighted average.