How to Calculate an Average (Weighted) Interest Rate

If you have several debts, such as a student loan, a car loan and a credit card, you probably know each rate but not what you’re paying overall. The weighted average interest rate gives you that single number. It is the key figure for deciding whether a consolidation loan or balance transfer would actually save money. This guide shows the formula, a worked example, how to do it in Excel, and the common ways it is misread.

Simple average vs. weighted average

A simple average adds the rates and divides by the number of loans. It ignores how much you owe on each one, so a small, high-rate balance pulls the average far too high, or a large, low-rate balance gets too little weight.

A weighted average counts each rate in proportion to its balance:

weighted average rate = Σ (balance × rate) ÷ Σ balance

In words, multiply each balance by its rate, add those up to get your total yearly interest, then divide by your total balance.

Worked example: three debts

Debt	Balance	Rate	Balance × rate (yearly interest)
Student loan	$12,000	6.8%	$816
Credit card	$5,000	22%	$1,100
Car loan	$8,000	9%	$720
Total	$25,000		$2,636

1. Total yearly interest: 816 + 1,100 + 720 = $2,636.
2. Total balance: $25,000.
3. Weighted average rate: 2,636 ÷ 25,000 = 10.544%.

The simple average, (6.8 + 22 + 9) ÷ 3 = 12.6%, overstates the real figure by more than 2 points.

What the 10.544% means: a single loan of $25,000 at 10.544% would charge about the same interest this year as all three debts together. That is the number a consolidation offer has to beat.

How to calculate it in Excel or Google Sheets

Put the balances in column A and the rates in column B:

=SUMPRODUCT(A2:A4, B2:B4) / SUM(A2:A4)

SUMPRODUCT multiplies each balance by its rate and adds the results. Dividing by the total balance gives the weighted average. Add rows for more debts and extend the ranges.

Using the average to make decisions

Debt consolidation

A consolidation loan only saves interest if its rate is below your weighted average and the term isn’t much longer. A personal loan at 11% wouldn’t help in the example, but one at 8% would. Check the full payoff with the loan calculator and the amortization calculator.

Federal student loan consolidation

A federal Direct Consolidation Loan uses the weighted average of the loans being combined, rounded up to the nearest 1/8%. If the average were 10.544%, the new rate would be 10.625%. Consolidation simplifies payments, but it doesn’t lower the rate.

Which debt to pay first

The weighted average is a summary, not a payoff plan. To save the most interest, put extra money on the highest-rate debt first (the avalanche method). In the example, every dollar on the 22% card saves more than twice as much as a dollar on the car loan. The loan payoff calculator shows how much faster each debt clears with extra payments.

When a rate changes during the year

If a single loan’s rate changes, for example a variable-rate loan or a promotional rate that ends, weight each rate by time instead of balance:

average rate = Σ (rate × months at that rate) ÷ 12

A loan at 6% for 4 months and then 9% for 8 months averages (6 × 4 + 9 × 8) ÷ 12 = 8% for the year, assuming the balance stayed roughly the same. If the balance changed a lot, weight by both: add up the actual interest charged and divide by the average balance.

A step-by-step routine for your own debts

1. List every debt with its current balance and APR. Your statements or lender apps have both.
2. Multiply each balance by its rate to get the yearly interest at today’s balance.
3. Add the yearly interest and the balances.
4. Divide total interest by total balance. That is your weighted average rate.
5. Sort the debts by rate. Anything above your average is pulling it up and is the first target for extra payments or refinancing.
6. Recalculate every few months. As high-rate debts shrink, your average falls, which is a satisfying way to track progress.

Using the example debts, paying the $5,000 credit card down to zero would remove $1,100 of yearly interest and drop the weighted average on the remaining $20,000 to (816 + 720) ÷ 20,000 = 7.68%. That shows in one number how much the card was costing you.

Is a lower average rate always better?

A lower weighted average means less interest per year on the same balances, but two other things decide what you actually pay:

• The term. Moving $25,000 of debt from a 10.5% average to an 8% consolidation loan saves interest only if the new loan isn’t much longer. A five-year loan at 8% can cost more in total than paying the original debts off over three years at 10.5%.
• The payment. Consolidation often lowers the monthly payment by stretching the term. That eases cash flow, but you should compare total interest, not the payment.

A good rule: if you consolidate, keep paying at least what you paid before. Your average rate falls, your payoff date moves closer, and the total interest drops on both counts.

Other places weighted averages appear

• Savings and investments: a $10,000 CD at 4.5% and $2,000 in checking at 0.5% earn a weighted 3.83%, not the simple average of 2.5%.
• Mortgages with two loans: a first mortgage and a home equity line can be combined into one blended rate for comparison with a cash-out refinance.
• Implied rates from payments: if you only know a payment, find each loan’s rate first with the interest rate calculator.

Common mistakes

• Averaging rates without weighting. It gives the wrong figure whenever balances differ.
• Using original loan amounts. Weight by today’s balances.
• Mixing APR and APY. Use the same type of rate for every debt.
• Ignoring promotional rates. A 0% balance transfer that ends in six months shouldn’t be averaged as 0% for the year. Use the rate it reverts to for any balance you won’t clear in time.
• Treating the average as the whole story. Fees, terms and payoff order matter as much as the rate.

Frequently asked questions

What is a weighted average interest rate?

It is the average of several interest rates where each rate counts in proportion to its balance. It tells you the single rate that would charge the same total yearly interest as all your loans combined.

Why not just average the rates?

A simple average treats a $500 balance and a $50,000 balance as equally important. With debts of $12,000 at 6.8%, $5,000 at 22% and $8,000 at 9%, the simple average is 12.6%, but the true weighted average is 10.544%.

How is the federal Direct Consolidation Loan rate calculated?

It is the weighted average of the loans being consolidated, rounded up to the nearest one-eighth of a percent. A weighted average of 10.544% would become 10.625%.

How do I calculate a weighted average interest rate in Excel?

Put balances in column A and rates in column B, then use =SUMPRODUCT(A2:A4,B2:B4)/SUM(A2:A4). Format the result as a percentage.

Does a lower average rate mean I should consolidate?

Not by itself. Consolidation can lower the rate on some debts but raise it on others, may add fees, and often extends the term, which can increase total interest. Compare the total cost, not just the average rate.