Blended Interest Rate & Debt Consolidation Calculator
A lower blended rate or monthly payment does not tell the whole consolidation story. Compare up to twelve current fixed-rate installment loans with up to three offers. Choose which balances to replace and keep unselected loans in every comparison. See balance weights, initial payment relief, closing fees, remaining debt, interest plus fees and whether early savings survive through payoff. Inspect monthly checkpoints, individual amortization schedules and a complete CSV. All terms are your editable assumptions, not current lender quotes. This planner does not model revolving minimum-payment rules, promotional or variable rates, federal consolidation benefits, tax effects or approval.
Blend the rates. Compare the whole debt.
Choose which loans to replace. Compare payment relief, fees and remaining debt—and see whether early savings last.
Three-year offer: USD 297.92 financing-cost advantage at month 24. Positive favors consolidation.
Edit current loans and offers
Select the loans an offer would replace. Unselected loans keep their current repayment schedule in every comparison. Use fixed-rate monthly installment loans; this does not model revolving minimum payments, promotional rates or federal consolidation benefits.
Current loans
Enter outstanding principal and remaining terms. Monthly payments are recalculated from these inputs; compare the modeled amounts with your statements. Select at least one loan to consolidate.
Consolidation offers
Each offer replaces the same selected balances. Compare alternatives separately; they are not added together. Prices and terms are your inputs, not live offers.
Planning convention: regular payments round upward to cents; monthly interest rounds half-up, and the final scheduled payment clears any remainder. Actual lender billing may differ. A lower payment or blended rate alone does not establish savings or suitability.
Savings begin in month 10 and remain positive through the horizon. After all loans are paid, cost advantage is USD 317.18.
Cash-payment advantage at month 24: USD 3,056.11. Remaining debt: USD 7,243.93 with this offer versus USD 4,485.74 keeping current loans. Cash retained today is not the same as debt eliminated.
Follow the comparison through time
Month 0 is closing; later checkpoints follow payment. Lines connect monthly checkpoints; between-month values are not modeled. Payment steps show each monthly amount. A missing rate means no remaining balance, not a zero-interest loan.
Same month. All obligations.
| Strategy | Initial payment | Closing cash fees | Cost to checkpoint | Debt at checkpoint | Full-horizon cost | Payoff month |
|---|---|---|---|---|---|---|
| Keep current loans | USD 960.40 | USD 0.00 | USD 2,735.29 | USD 4,485.74 | USD 3,032.16 | 36 |
| Three-year offer | USD 826.81 | USD 150.00 | USD 2,437.37 | USD 7,243.93 | USD 2,714.98 | 36 |
| Five-year offer | USD 598.26 | USD 50.00 | USD 2,699.19 | USD 13,090.95 | USD 3,945.31 | 60 |
Financing cost is interest plus upfront, exit and financed fees. Principal repayments are not a financing cost. Full-horizon cost includes every payment through payoff; no time-value discounting is applied.
- Three-year offer: Savings begin in month 10 and remain positive through the horizon.
- Five-year offer: First savings in month 14; that advantage is lost before the horizon ends.
Which balances drive the rate?
Each bar shows that loan’s share of current principal. Rate contribution equals balance weight × note rate; contributions sum to the current blended rate.
| Loan | Treatment | Principal | Weight | Note rate | Contribution |
|---|---|---|---|---|---|
| Personal loan | Consolidate | USD 12,000.00 | 50.0000% | 12% | 6.0000 percentage points |
| Installment loan | Consolidate | USD 8,000.00 | 33.3333% | 8% | 2.6667 percentage points |
| Interest-free loan | Keep separately | USD 4,000.00 | 16.6667% | 0% | 0.0000 percentage points |
Complete monthly comparison ledger
Individual loan amortization ledgers
Take the full comparison with you
Includes assumptions, original and new loan schedules, portfolio totals and every monthly comparison. Result money is exported as integer cents for exact reconciliation.
How to use this calculator
- Open Edit current loans and offers. Enter the currency label and month to compare. Month 0 is closing; later months are after payment.
- Add each loan’s outstanding principal, fixed annual note rate, remaining monthly term and exit fee. Select the loans that each offer would replace; unselected loans remain in the portfolio.
- Enter each offer’s note rate, new term, fees paid upfront and fees added to principal. Keep selected loan exit fees separate so they are not counted twice.
- Select an offer and inspect the cost advantage, cash-payment advantage and remaining debt at the same month. Change the timeline measure and month slider; read whether savings are temporary or sustained.
- Expand the portfolio or individual-loan ledgers to inspect payments and interest. Download the complete CSV or show its selectable text; reconcile cents and fee assumptions before using a real quote.
The Formula
The mathematical logic powering this calculation is:
For current principal balances Bᵢ and fixed annual note rates Rᵢ expressed as percentages, blended note rate = Σ(Bᵢ × Rᵢ) / ΣBᵢ. Each balance weight is Bᵢ / ΣBᵢ × 100%; its rate contribution is Bᵢ × Rᵢ / ΣBᵢ percentage points. Contributions sum to the blended rate. Compute this separately for all current loans and only the selected loans. This weighted note rate is not APR, a quoted consolidation rate or a guarantee of lower lifetime cost.
Each current loan is amortized from its outstanding principal, fixed note rate and remaining whole months. Monthly rate r = annual note rate / 1200. For principal P and n months, exact level payment = P × r / [1 − (1+r)^−n], or P/n at zero rate. The regular modeled payment rounds upward to cents. Each month, interest = opening balance × r rounded half-up to cents; payment is the lesser of the regular payment and balance plus interest. Principal paid = payment − interest. The final scheduled month clears any remaining balance plus interest. Actual billing, daily accrual and rounding may differ. A small balance can pay off earlier because of the cent ceiling.
Every offer replaces the same selected balances. New principal = sum of selected current principal + offer financed fees. Unselected loans keep their original modeled schedules. Closing cash fees = offer upfront fees + exit fees on selected loans; exit fees on retained loans are not charged. Financed fees are added on top of the balances, not withheld from loan proceeds. There is no new cash advance, accrued-interest adjustment or automatic payoff penalty.
At month H, after that month’s payment, cash paid = cumulative payments + closing cash fees. Financing cost = cumulative interest + closing cash fees + financed fees. Positive cost advantage = keeping-current-loans financing cost − offer financing cost. Equivalently, cost advantage = current cash paid + current debt remaining − offer cash paid − offer debt remaining. Cash-payment advantage compares cash paid only and excludes remaining debt. Principal repayment is not a financing cost. No discounting, investment return or payment rollover is applied.
The full horizon extends through all original and new loan terms and the selected comparison month. First savings month is the first month with strictly positive cost advantage. Sustained savings begins after the last nonpositive month only if advantage remains positive through the full horizon. A temporary advantage that is later lost is not labeled sustained savings; a tie is not positive savings. After payoff, periodic payments and interest are zero and cumulative totals remain unchanged.
The remaining balance-weighted rate is recomputed at every month-end using outstanding balances. It can change as different loans pay down despite each note rate being fixed. It is unavailable when no balance remains; an outstanding zero-rate loan has a valid zero rate. Charts connect monthly checkpoints without modeling between-month values. The payment chart uses steps.
Arithmetic uses exact rational rates and integer-cent money. Displayed rate fractions round half away from zero; if rounding would erase a nonzero value, the fraction remains visible. CSV input money uses the labeled currency; result money uses integer cents and rates use percentage fractions. Original loan schedules are exported once; retained schedules are referenced by debt ID for each offer.
Supported inputs: 1–12 current loans, at least one selected; 1–3 offers; comparison month 0–600; remaining/new terms 1–600 whole months. Each current balance is 0.01–1000000000 currency units; each exit, upfront and financed fee is 0–1000000000 with at most two decimal places. Fixed annual note rates allow 0–50% with at most six decimal places. Plain unsigned decimal text is required, with no blank active assumptions or silent zeros. All loans share one currency label; changing it does not convert amounts.
The model excludes revolving credit minimums, rate resets, introductory rates, arrears, payment holidays, balloons, extra payments, federal consolidation rate rounding, forgiveness or benefit rules, tax and collateral consequences, lender eligibility and credit scoring. A refinance can change legal protections or security; numerical savings do not establish suitability. The RBI source is a historical 2018 weighting illustration, not a claim about current lending regulation. CFPB sources explain amortization and the distinction between note rate and APR; the cent-rounding convention is explicitly this planner’s assumption.Method sources
Worked Example
If you input:
- Comparison: USD; after month 24
- Selected personal loan: 12000 balance; 12% annual note rate; 36 months remaining; no exit fee
- Selected installment loan: 8000 balance; 8% note rate; 24 months remaining; 50 exit fee
- Retained interest-free loan: 4000 balance; 0%; 20 months remaining; no exit fee
- Three-year offer: 7% note rate; 36 months; 100 upfront fees + 300 financed fees
- Five-year offer: 6% note rate; 60 months; no upfront offer fee + 600 financed fees
Result:
Current principal is USD 24,000; USD 20,000 is selected. The current blended note rate is 26/3% (8.6667%), and the selected loans’ rate is 10.4%. Keeping all loans initially costs USD 960.40/month. The three-year offer’s new principal is USD 20,300 and closing cash fees are USD 150 including the selected exit fee. Its initial portfolio payment is USD 826.81, a reduction of USD 133.59. At month 24, its financing cost is USD 2,437.37 versus USD 2,735.29 keeping current loans, giving USD 297.92 advantage. Remaining debt is USD 7,243.93 versus USD 4,485.74. Savings begin in month 10 and remain positive; the full-horizon advantage is USD 317.18. The five-year offer initially reduces payments to USD 598.26 and first saves on cost in month 14, but ultimately costs USD 913.15 more. These are illustrative modeled terms, not available credit offers.
Frequently Asked Questions
Is the blended note rate an APR?
No. It weights each contractual note rate by its principal balance. APR can include fees. This planner calculates monthly interest from note rates and includes fees separately; entering an APR as the note rate can double-count fees.
Can I consolidate only some of my loans?
Yes. Select the balances each offer would replace. Unselected loans retain their current modeled terms and payments in every portfolio comparison. Exit fees apply only to selected loans.
Why can a lower payment cost more?
A longer term can leave debt outstanding for longer and accumulate more interest. Compare financing cost and remaining debt at the same month, then check the cost after every loan is paid. Initial payment reduction is a cash-flow measure, not proof of savings.
What is the difference between first and sustained savings?
First savings is the first strictly positive financing-cost advantage. The advantage may disappear later. Sustained savings is the first point after which advantage remains positive through the full comparison horizon. If the final advantage is nonpositive, no sustained-savings month is reported.
Why does the blended rate change even when my rates are fixed?
The loan balances change at different speeds. As higher- or lower-rate loans pay down, their weights change. After all balances reach zero there is no remaining blended rate; this is different from an outstanding loan that charges zero interest.
Does this reproduce my existing statement payment?
It calculates payments from the balance, rate and remaining term you enter. Regular payments ceil to cents; monthly interest rounds half-up and the final scheduled month clears the remainder. Daily interest, lender rounding, accrued interest, payment dates or special terms can cause differences.
Does it calculate a federal student-loan consolidation rate or benefits?
No. It compares fixed-rate installment scenarios using entered offer terms. It does not round rates under federal consolidation rules, assess forgiveness, preserve or price borrower protections, or determine eligibility. Use official program and servicer information for those decisions.
What does the CSV contain and how are amounts represented?
It includes every input, balance weight, original loan schedule, new consolidated loan schedule, portfolio month and comparison. Result money is integer cents; rates are percentage fractions. Retained loans refer to the original schedule by ID instead of duplicating it. A selectable text fallback is available if downloading is unavailable.
Similar Calculators
Debt Payoff Planner
Plan avalanche or snowball debt payoff across multiple debts with extra payment rollover, payoff date, total interest, and time saved.
Auto Loan Refinance Calculator
Compare auto refinance offers using note interest rates, upfront or financed fees, monthly loan schedules and the cash paid plus debt remaining at your chosen month.
Home Equity Loan Calculator
Compare a home equity loan with cash-out refinancing at the same net cash. Calculate maximum cash out, monthly payments, fees and remaining mortgage debt.
Student Loan Repayment Calculator
Compare student loan repayment scenarios with grace periods, standard terms, custom payments, extra payments, and affordability context.
