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. When you take a ...

Assume you want to calculate Bank A's capital-to-risk weighted assets ratio in Excel. Before beginning the calculation, you should first label your data. Enter "Variables" in A1 and "Values" in B1.