NewMeet Cai — Your AI Asset Management & Analyst TeamLearn more
BubbleGum BI Logo
Financing Metrics

How to Calculate Average Interest Rate (Portfolio)

Learn how to calculate weighted average interest rate across a debt portfolio, understand aggregate debt costs, and identify refinance opportunities.

Last updated March 2026

📊 Definition

Average Interest Rate (Portfolio) is the weighted average interest rate across all loans in a real estate portfolio. It shows the blended cost of debt across multiple properties and loan structures.

The Formula

Avg Rate = (Σ Loan Balance × Interest Rate) ÷ Total Loan Balance × 100

Weighted by loan balances, expressed as percentage

Example Calculation

A portfolio with three properties:

Property A: $30M loan at 3.5% = $1,050,000 interest
Property B: $20M loan at 4.2% = $840,000 interest
Property C: $15M loan at 5.0% = $750,000 interest
Total Debt: $65M | Total Interest: $2,640,000
Avg Interest Rate: ($2,640,000 ÷ $65,000,000) × 100 = 4.06%
Simple average (3.5+4.2+5.0)÷3 = 4.23% (incorrect—must weight by loan size)

Where Does the Data Come From?

Calculate portfolio average rate from loan data:

  • Loan Balances: From monthly loan statements
  • Interest Rates: From loan documents (note rate, not APR)
  • Variable Rates: Track current rate including spread (SOFR + 2.5%)
  • Total Interest Expense: From annual financial statements

Update monthly as rates change on floating-rate debt.

Who Uses This Metric?

Portfolio Managers

Track overall cost of debt and identify refinancing opportunities. If portfolio average is 4.5% and current market is 4.0%, prioritize refinancing higher-rate loans to reduce blended cost.

CFOs & Treasury

Forecast interest expense for budgeting and cash flow planning. On $200M portfolio at 4.3% average rate, expect $8.6M annual interest expense. Rate increases to 4.8% = $1M additional cost.

Investment Committees

Compare new acquisition financing costs to portfolio average. Acquiring at 5.5% when portfolio is 4.0% will drag up blended rate—evaluate if returns justify higher cost of capital.

Why This Metric Matters

1. Interest Rate Risk Exposure

Rising rates hurt floating-rate debt portfolios. If 60% of debt is floating and rates rise 1%, portfolio rate increases 0.6% (60% × 1.0%). On $200M debt, that's $1.2M additional annual cost.

2. Refinancing Prioritization

Identify which loans to refinance first, keeping DSCR requirements in mind. If portfolio average is 4.3% and you have loans at 3.0%, 4.5%, and 6.0%, target the 6.0% loan—largest rate reduction opportunity.

3. Performance Benchmarking

Compare portfolio cost of debt to market benchmarks. If your average is 4.8% and peers are at 4.2%, you're paying $12M extra annually on $200M debt—work to refinance legacy high-rate loans. Also monitor maturity risk exposure for upcoming refi timing.

💡 Pro Tip

Track fixed vs. floating rate mix alongside average rate. A 4% average rate with 80% floating is riskier than 4.5% with 80% fixed. Model interest expense scenarios at +100, +200, and +300 basis points to stress-test rising rate environments.

Frequently Asked Questions

Should I use simple or weighted average?

Always weighted by loan balance. Simple average treats $10M and $50M loans equally (wrong). Weighted average reflects true economic impact—large loans affect portfolio cost more than small loans. Weighting provides accurate picture of debt service burden. Track this via your financial dashboard.

How do I handle variable-rate loans?

Use current rate (SOFR/LIBOR + spread) for today's calculation. Track monthly as base rate changes. Model scenarios at +100, +200, +300 bps to understand exposure. Consider hedging (caps, swaps) if floating rate portion exceeds 50% of total debt.

What's a good portfolio average rate?

Depends on market conditions. In 2021: 3.0-3.5% was good. In 2023: 5.0-5.5% is market. Compare to current 10-year treasury + 200-250 bps spread for agency debt. If your rate is >50 bps above market, prioritize refinancing.

How can I lower my portfolio average rate?

Refinance highest-rate loans first. Negotiate rate reductions on existing loans (if performance improved). Replace floating-rate with fixed-rate debt to lock in low rates. Pay down highest-rate debt first with excess cash flow. Acquire properties with assumable low-rate debt.

Should I include fees in the rate calculation?

Use note rate for standard calculation (comparable across portfolio). Use effective rate (including origination fees amortized over loan term) for true cost analysis. Note rate: 4.5%. Effective rate with 1% origination on 10-year loan: 4.6%. Both useful for different purposes.

Track Portfolio Interest Rate Risk

BubbleGum BI monitors your weighted average interest rate via our financial dashboard and identifies refinancing opportunities—helping you minimize your cost of capital.

Schedule Your Demo Today