Calculate your weighted average interest rate across multiple loans instantly. Enter loan balances and APR rates to get your true blended rate, estimated annual interest cost, and federal student loan consolidation rate.
Type the current outstanding balance for each loan into the “Loan Balance” column. Use the actual current balance, not the original loan amount. Accurate balances are essential for a correct weighted average.
Enter the annual interest rate (APR) for each loan. Find this on your loan statement or account dashboard. Make sure to use the annual rate, not the monthly rate.
Click “Add Loan” to add more loan entries. Include all loans you want to compare — student loans, mortgages, auto loans, credit cards, and personal loans.
Results compute instantly as you type. The calculator multiplies each balance by its rate, sums the products, and divides by total balance automatically.
Review the weighted average interest rate, total loan balance, weighted interest amount, estimated annual interest cost, and the federal student loan consolidation rate. Use Copy or Download to save your results.
A weighted average interest rate is the average of multiple interest rates, where each rate is weighted (multiplied) by the outstanding loan balance it applies to. It produces a single rate that accurately represents your overall borrowing cost across all loans, giving more influence to larger balances.
The weighted average interest rate works by multiplying each loan's interest rate by its balance, summing those products, then dividing by the total of all balances. This ensures that a $200,000 mortgage at 4% has much more impact on your overall rate than a $5,000 personal loan at 12%.
A simple average adds all rates and divides by count, treating all loans equally. A weighted average accounts for loan sizes. With a $200,000 loan at 4% and a $10,000 loan at 15%, the simple average is 9.5% but the weighted average is 4.52%. The weighted average is far more accurate.
The terms “weighted average interest rate” and “blended interest rate” are generally used interchangeably. Both refer to a single rate that represents the combined effect of multiple rates weighted by their balances. “Weighted average” is the precise mathematical term; “blended rate” is more common in marketing.
A simple average of 3% and 18% is 10.5%. But if the 3% applies to a $200,000 mortgage and the 18% applies to a $5,000 credit card, your true cost is 3.37%. The weighted average reflects reality: the mortgage dominates your interest cost because its balance is 40x larger.
Knowing your weighted average interest rate is essential for evaluating debt consolidation offers, comparing refinancing opportunities, planning debt repayment strategies, and understanding your true overall borrowing cost. It's the single most important number for managing multiple debts.
The formula multiplies each loan's balance by its interest rate, producing a “weighted interest” for each loan. Then it sums all weighted interests (numerator) and divides by the total balance across all loans (denominator). The result is the true overall interest rate that reflects each loan's proportional impact.
Example: ($679.50 + $1,161.60 + $2,478.00) ÷ $72,000 = $4,319.10 ÷ $72,000 = 5.999%
This calculator automatically performs all five steps in real time as you type. It multiplies each loan balance by its APR, sums those products, divides by total balance, and also computes the Federal Student Loan Consolidation Rate by rounding up to the nearest ⅛%. Results include visual distribution charts and step-by-step calculation breakdowns.
Balance × Rate for each loan
Sum all weighted interest amounts
Weighted interest ÷ total balance
5.999% Weighted Average Interest Rate
The larger auto loan at 4.9% pulls the weighted average below the 6.70% simple average.
Federal consolidation rate rounds to 6.000% (nearest ⅛%). Annual interest cost: $4,319.10.
The first mortgage dominates. A refinance offer below 4.23% would lower your overall interest cost.
A balance transfer card at 0% intro APR could save $2,823 in annual interest.
The larger bank loan at 7.5% dominates, pulling the weighted rate below the 8.35% simple average.
The SBA loan's $150K balance dominates. A new loan below 7.00% would reduce overall cost of debt.
Adjust the loan balances to see how the simple average stays the same while the weighted average changes dramatically.
Treats both rates equally regardless of balance size
Accounts for loan size — larger balance has more influence
The $200,000 loan at 4% accounts for 95.2% of total debt, so it dominates the weighted average. The simple average misleadingly suggests your rate is 9.5%.
Your weighted average interest rate is the single number that represents the true overall cost of all your loans combined. It accounts for both the interest rate and the balance of each loan, giving more weight to larger loans.
A lower weighted average rate means you're paying less in total interest relative to your debt. This is the target when refinancing or consolidating. Any consolidation offer below your current weighted average rate would reduce your interest costs.
A higher weighted average rate indicates your larger loans carry higher rates. Consider refinancing your largest high-rate loans first, as they have the most impact on your overall rate.
Compare your weighted average to: consolidation loan offers, refinancing rates, the current federal student loan consolidation rate, or a new loan's APR. If the offered rate is below your weighted average, consolidating would save money.
Recalculate your weighted average whenever: you make a significant payment on any loan, you take on new debt, a variable rate changes, you refinance or consolidate any loan, or at least once per quarter to track progress.
Calculate your weighted average rate across federal and private student loans. Compare it to the federal Direct Consolidation Loan rate to decide whether consolidation makes financial sense.
When you have a first mortgage and a second mortgage or HELOC, find your true combined rate to evaluate whether a single refinance would save money.
Find your weighted average across all debts. Any consolidation loan offered below this rate will reduce your total interest cost.
Calculate the weighted average APR across multiple cards to compare against balance transfer or personal loan consolidation offers.
Compare blended rates across multiple personal loans to decide which to pay off first or whether to refinance.
Track your cost of debt across SBA loans, equipment financing, lines of credit, and other business borrowing to optimize your capital structure.
Calculate the weighted average yield on a bond portfolio or interest-bearing investments to compare against benchmarks and alternative investments.
Compare your total borrowing cost as a single number instead of juggling multiple rates. Instantly see whether a consolidation or refinancing offer would actually save you money.
Understand the true cost of your debt portfolio to create an informed payoff strategy. Know which loans to target first for maximum interest savings.
Compare refinancing offers against your current weighted average rate. If the new rate is below your weighted average, refinancing saves money. If above, it doesn't.
Use your weighted average rate to forecast total interest costs over time, plan monthly budgets, and set realistic debt-free target dates.
Get an instant snapshot of your entire loan portfolio's health. See distribution charts, identify high-interest outliers, and track your weighted average over time.
Larger loans have more influence on your weighted average. A $300,000 mortgage at 4% will dominate over a $5,000 credit card at 22%. As you pay down specific loans, the balance distribution shifts and your weighted average changes.
Higher rates on larger balances push your weighted average up significantly. Conversely, if your largest loans have the lowest rates, your weighted average will be closer to those low rates.
Taking on a new loan changes your weighted average. A new low-rate loan (like a 0% promotional balance transfer) can lower your weighted average, while a new high-rate loan will increase it.
Paying off a high-interest loan reduces your weighted average, while paying off a low-interest loan can actually increase it. The before/after calculator below shows this effect.
Refinancing a loan at a lower rate reduces your weighted average. The impact is larger when the refinanced loan has a large balance. Refinancing a small loan has minimal effect on the overall average.
Loans with variable rates cause your weighted average to fluctuate when rates change. In a rising rate environment, variable-rate loans can push your weighted average higher over time.
The avalanche method targets the highest-rate loan first. Eliminating loans above your weighted average reduces the overall rate. The larger the high-rate loan, the bigger the impact on your weighted average.
Look for refinancing opportunities on your highest-rate loans. Even a 1% reduction on a large loan can significantly lower your weighted average. Check rates quarterly with multiple lenders.
If a consolidation loan offers a rate below your current weighted average, consolidating reduces your overall interest cost. Use this calculator to verify before applying.
A higher credit score qualifies you for lower rates on new loans and refinancing. Even improving from “good” to “excellent” credit can save 1-3% on loan APRs.
Every new high-APR loan (credit cards, payday loans) pushes your weighted average up. Avoid high-rate borrowing and use lower-rate alternatives like personal loans or credit union financing.
Select a loan to “pay off” and see how your weighted average interest rate changes instantly.
Select a loan above to see how paying it off changes your weighted average interest rate and annual interest cost.
Column A: Loan Name, Column B: Loan Balance, Column C: Interest Rate (%)
=SUMPRODUCT(B2:B10,C2:C10)/SUM(B2:B10)SUMPRODUCT multiplies each balance by its rate and sums the results. Dividing by SUM of balances gives the weighted average interest rate.
SUMPRODUCT(35000,0.0708)= 679.5 + 1161.6 + 2478.0 = 4319.1SUM(35000) = 720004319.1 / 72000 = 5.999% (≈ 6.00%)Note: Enter rates as decimals (0.0453, not 4.53) or divide the result by 100.
The same SUMPRODUCT formula works identically in Google Sheets:
=SUMPRODUCT(B2:B10,C2:C10)/SUM(B2:B10)Where column B contains loan balances and column C contains interest rates (as decimals). Google Sheets also supports ARRAYFORMULA for more complex calculations.
Set up your Google Sheet with these columns:
Adding rates and dividing by count ignores loan sizes. A $200K mortgage at 4% and a $5K credit card at 22% have a simple average of 13% — but your true cost is 4.43%. Always weight by balance.
Using original loan amounts instead of current outstanding balances produces inaccurate results. Always enter your current balance — the amount you still owe today, not the original amount borrowed.
Some statements show monthly rates (e.g., 1.5%) while APR is annual (18%). Make sure all rates are annual APR. Multiply monthly rates by 12 to convert to annual before entering them.
APR (Annual Percentage Rate) and APY (Annual Percentage Yield) are different. APR doesn't include compounding; APY does. For loan comparisons, use APR consistently across all entries.
Including a paid-off loan with zero balance doesn't affect the calculation (zero weight), but it can cause confusion. Remove paid-off loans from your analysis for clarity.
Loan balances change with every payment. Use current balances from your latest statements for accurate results. Set a reminder to recalculate monthly as you pay down debt.
This calculator uses the loan balances you enter, which should be your current outstanding balances. As you make payments, balances decrease and the weighted average changes. Results reflect a point-in-time snapshot.
The calculator treats all entered rates as fixed. If you have variable-rate loans, your actual weighted average will change as rates adjust. Recalculate periodically to account for rate changes.
The weighted average interest rate does not factor in origination fees, closing costs, or other charges. The total cost of a loan includes more than just the interest rate. For total cost comparison, use the APR figure which includes some fees.
This calculator uses simple interest rate weighting (APR). It does not account for different compounding frequencies (daily, monthly, quarterly). For precise interest cost projections, consider each loan's compounding method separately.
The weighted average interest rate provides a useful benchmark for comparison purposes. It is not a guaranteed rate, loan offer, or financial advice. Consult a financial advisor for specific lending decisions.
Annual Percentage Rate — the yearly interest rate charged on a loan, not including compounding. This is the standard rate used for comparing loan costs and is the rate you should enter into this calculator.
The outstanding balance of a loan — the amount you still owe. In weighted average calculations, principal (balance) serves as the weight that determines each rate's influence on the overall average.
A calculation method where each value (rate) is multiplied by its corresponding weight (balance) before averaging. This produces a more accurate average than a simple arithmetic mean when inputs have different magnitudes.
The total dollar amount you pay in interest over a period. Annual interest cost = Balance × Annual Rate. Your weighted average rate lets you estimate total annual interest across all loans.
Another term for weighted average interest rate. “Blended” refers to combining multiple rates into a single representative rate. Often used by lenders when describing a consolidated loan rate.
The actual interest rate after accounting for compounding. Also called APY (Annual Percentage Yield). Higher compounding frequency means the effective rate exceeds the nominal APR. Important for savings accounts.
A weighted average interest rate is the average of multiple interest rates, where each rate is weighted by the outstanding loan balance it applies to. Unlike a simple average, it accounts for the fact that larger loans contribute more to your overall interest cost. For example, a $200,000 mortgage at 4% has far more impact on your true borrowing cost than a $5,000 personal loan at 12%.
Multiply each loan's balance by its interest rate. Add all these products together. Add all loan balances together. Divide the total weighted interest by the total balance. For example: ($100,000 × 4.5% + $25,000 × 6.8%) ÷ $125,000 = $6,200 ÷ $125,000 = 4.96%.
The formula is: Weighted Average Interest Rate = Σ(Balance × Rate) ÷ Σ(Balance). Sum the product of each loan balance multiplied by its interest rate, then divide by the sum of all loan balances.
A simple average treats all rates equally regardless of loan size. A weighted average multiplies each rate by its loan balance, giving more influence to larger loans. With a $200,000 loan at 4% and a $10,000 loan at 15%, simple average = 9.5%, weighted average = 4.52%.
They are generally used interchangeably. Both refer to a single rate representing the combined effect of multiple rates weighted by their balances. “Weighted average” is the mathematical term; “blended rate” is more common in lending marketing.
It gives you the true overall cost of all your debt in a single number. Essential for evaluating consolidation offers, comparing refinancing options, understanding real borrowing cost, and planning debt repayment strategies.
Use it when you have multiple loans and want to find your true overall rate, evaluate consolidation offers, compare refinancing options, analyze student loan consolidation, plan a debt payoff strategy, or need a single number representing all your borrowing costs.
Yes. List each loan with its balance and rate. Multiply each balance by its rate. Sum all products. Sum all balances. Divide. However, manual calculations are error-prone with many loans — this calculator does it instantly with visual breakdowns.
Use =SUMPRODUCT(BalanceRange, RateRange)/SUM(BalanceRange). For example: =SUMPRODUCT(B2:B10,C2:C10)/SUM(B2:B10) where B contains balances and C contains rates as decimals.
SUMPRODUCT is the best formula. It handles multiplication and summation in one step: =SUMPRODUCT(balances, rates)/SUM(balances). Avoid manually creating helper columns.
Yes, Google Sheets supports the same SUMPRODUCT formula: =SUMPRODUCT(B2:B10,C2:C10)/SUM(B2:B10). It works identically to Excel.
Yes, this calculator is ideal for student loans. It computes your weighted average rate and also shows the Federal Student Loan Consolidation Rate, which rounds up to the nearest ⅛% — exactly how the Department of Education calculates Direct Consolidation Loan rates.
Yes. Enter each mortgage with its current balance and APR. The weighted average shows your true combined mortgage cost, essential for evaluating refinancing offers.
Yes. Enter each card's balance and APR. The weighted average shows your true credit card borrowing cost — useful for evaluating balance transfer or personal loan consolidation offers.
Yes. Enter each business loan, line of credit, or equipment financing. The weighted average shows your overall cost of debt, useful for business planning and WACC calculations.
Yes. If the refinanced rate is lower than the weighted average of the loans being refinanced, your overall weighted average will decrease. The impact depends on the balance of the refinanced loan relative to total debt.
Only if you pay off a loan with a rate above your weighted average. Paying off a below-average rate loan actually increases your weighted average. Use the interactive before/after tool on this page to see the exact impact.
Enter the current rate for variable-rate loans. Recalculate whenever your variable rates adjust. The calculator computes based on the rates entered at this moment.
The most common mistakes: (1) using simple average instead of weighting by balance, (2) entering incorrect balances, (3) mixing monthly and annual rates, (4) confusing APR with APY, (5) including zero-balance loans, (6) not updating to current balances.
Specialized purpose-built weighted average calculators — each tailored to a specific domain with unique inputs, outputs, and interactive visualizations.