To calculate a weighted average interest rate, multiply each loan’s balance by its interest rate, add those products together, and divide the total by the sum of all your balances. The result is a single percentage that reflects what you actually pay per dollar borrowed across every loan you hold. A plain average of your rates treats a $200,000 mortgage the same as a $3,000 credit card, which distorts the picture; weighting by balance fixes that.
What You Need Before You Start
Pull the most recent statement for every outstanding debt: mortgages, auto loans, student loans, personal loans, credit cards, and any lines of credit. From each statement, grab two numbers: the current outstanding balance and the interest rate.
Those figures should already be printed on your statements. Under Regulation Z, creditors on open-end accounts must disclose the account balance, each periodic rate, and the corresponding annual percentage rate on every billing statement.1Consumer Financial Protection Bureau. 12 CFR Part 1026 (Regulation Z) – 1026.7 Periodic Statement Mortgage servicers must also break down each payment into principal, interest, and escrow on every periodic statement.2Consumer Financial Protection Bureau. 12 CFR Part 1026 (Regulation Z) – 1026.41 Periodic Statements for Residential Mortgage Loans
Interest Rate or APR, Not Both
Your statement may show an interest rate and an APR. The interest rate is the cost of borrowing the principal. The APR folds in origination charges and other fees, so it is almost always slightly higher.3Consumer Financial Protection Bureau. What Is the Difference Between a Loan Interest Rate and the APR Pick one and use it for every loan. If you plan to compare your result against a consolidation offer quoted as an APR, use APRs across the board. Mixing the two skews the comparison.
Convert Monthly Credit Card Rates
Some credit card statements show a monthly periodic rate rather than an annual rate. A rate of 1.83% per month works out to roughly 21.99% annually. Multiply by 12 before you plug the number in, or the credit card will sit in the formula at a tiny fraction of its true weight.
Variable Rates Are a Snapshot
Many loans tie their rate to a benchmark like the prime rate or SOFR. The prime rate sat at 7.50% as of early 2025 and changes whenever the Federal Reserve adjusts its target range. If you carry variable-rate debt, record the rate currently in effect and note the date. Your weighted average is a snapshot and shifts every time a variable rate resets.
The Formula
Weighted Average Rate = (Balance₁ × Rate₁ + Balance₂ × Rate₂ + … + Balanceₙ × Rateₙ) ÷ Total of All Balances
The numerator captures how much interest weight each loan contributes. A $150,000 mortgage at 6.5% contributes far more to the numerator than a $4,000 personal loan at 10%, even though the personal loan carries the higher rate. The denominator normalizes the result so the percentage reflects the cost per dollar of total debt.
A Worked Example
Say you have three debts:
- Mortgage: $180,000 at 6.50%
- Auto loan: $22,000 at 5.25%
- Credit card: $8,000 at 21.99%
Step 1. Multiply each balance by its rate.
- Mortgage: $180,000 × 0.065 = $11,700
- Auto loan: $22,000 × 0.0525 = $1,155
- Credit card: $8,000 × 0.2199 = $1,759.20
Step 2. Add the products. $11,700 + $1,155 + $1,759.20 = $14,614.20. That is the total annual interest cost across the three debts.
Step 3. Add the balances. $180,000 + $22,000 + $8,000 = $210,000.
Step 4. Divide. $14,614.20 ÷ $210,000 = 0.0696, or about 6.96%.
Despite the 21.99% credit card, the weighted average lands near 7% because the mortgage dominates the portfolio. A simple average of the three rates would be 11.25%, which overstates the actual borrowing cost by a wide margin.
Doing It in a Spreadsheet
Once you have more than three or four debts, manual math gets tedious. Excel and Google Sheets handle this in one line.
Put loan names in column A, balances in column B, and interest rates in column C. If your debts run from rows 2 through 6, the formula is:
=SUMPRODUCT(B2:B6, C2:C6) / SUM(B2:B6)
SUMPRODUCT multiplies each balance by its rate and adds the results. SUM totals the balances. Format the result cell as a percentage and you are done.
The real advantage is scenario testing. Drop a high-rate balance to zero and the weighted average recalculates instantly, showing how much that payoff would reduce your overall cost. You can also model a variable rate rising by a point or two.
Working Backward With Goal Seek
Sometimes the question runs the other way: what rate would a new loan need to carry to pull your weighted average below a target? Excel’s Goal Seek handles that. Go to Data → What-If Analysis → Goal Seek. Set the weighted average cell as the target, enter your desired percentage in the “To value” box, and point Goal Seek at the cell holding the new loan’s rate.4Microsoft Support. Use Goal Seek to Find the Result You Want by Adjusting an Input Value Goal Seek works one variable at a time, which fits a single-rate question well.
Federal Student Loan Consolidation Rounds Up
The most common real-world use of this formula is federal student loan consolidation, and the government applies one extra step. When you consolidate federal loans into a Direct Consolidation Loan, the new rate is the weighted average of your existing rates, rounded up to the nearest one-eighth of one percent. The rate cannot exceed 8.25%.5GovInfo. Public Law 107-139 – Student Loan Interest Rates
A borrower with $10,000 at 6% and $2,000 at 8% would get a weighted average of about 6.33%, which rounds up to 6.375%.6Federal Student Aid. Federal Consolidation Loans Terms and Conditions If your calculation comes out to 5.31%, the Department of Education rounds it to 5.375%, not 5.25%. On a large balance over a long term, that eighth of a point adds real dollars. Running the formula yourself before applying tells you exactly what rate to expect.
Where the Number Can Mislead
A weighted average is a useful shortcut, but it hides a few things worth keeping in view.
It ignores remaining loan terms. The formula treats a mortgage with 25 years left and a car loan with 18 months left as equally permanent. If most of your high-rate debt is nearly paid off, the weighted average overstates your long-term borrowing cost. Keep remaining terms in mind, especially when deciding whether to consolidate short-lived debts into a new long-term loan.
Amortization shifts the weights. Early payments go mostly toward interest; later ones toward principal. Balances change at different speeds depending on where each loan sits in its schedule. A weighted average calculated today will look different in six months even if no rates change. Recalculate periodically.
Fees can erase the savings. Suppose your weighted average is 7.2% and a lender offers consolidation at 6.8%. That looks like a win, but origination charges, closing costs, or a prepayment penalty on any of the debts you are paying off can offset years of interest savings. Factor those costs in before you compare.
Deductible interest costs less than its stated rate. If you itemize and deduct mortgage interest, the after-tax cost of that debt is lower than the rate on your statement. The formula does not know that. A borrower with a large deductible mortgage and a small non-deductible personal loan may find the effective cost structure differs from what the raw weighted average suggests, which matters before rolling deductible debt into a non-deductible consolidation loan.
Putting the Number to Work
Once you have your weighted average, comparison shopping gets simpler. Any consolidation or refinancing offer below that rate reduces your overall cost of borrowing, assuming comparable terms and no excessive fees. An offer above it makes you worse off.
The number also helps prioritize payoffs. Eliminating a high-rate debt pulls the weighted average down fastest, but only when the balance is large enough to matter. Clearing a $500 balance at 24% barely moves the needle when the rest of your portfolio totals $200,000. The formula itself shows why: removing that $500 loan hardly changes either the numerator or the denominator. Target the debt where balance and rate combine for the largest product.
Recalculate after every major payoff or rate change. The weighted average is most useful as a living metric that tracks whether your debt portfolio is getting cheaper or more expensive over time.