Formula
For each debt with a balance and payment above zero: run the balance forward month by month, adding interest = balance × rate ÷ 12 and subtracting the payment, until it reaches zero; Current remaining cost (interest) = total of all payments made − total of all balances; Months to debt-free now = the longest payoff among the debts. If a payment does not cover a month's interest, that debt never repays and the cost shows as infinite.
Weighted average current rate = Σ(balance × rate) ÷ Σ(balance)
Consolidation principal = Σ(balances) × (1 + Consolidation fee ÷ 100); New single payment = principal × r ÷ (1 − (1 + r)^−n), with r = Consolidation loan rate ÷ 12 and n = Consolidation term (months)
Consolidation total cost (interest + fee) = New payment × n − Σ(balances); Lifetime saving = Current remaining cost − Consolidation total cost; Monthly payment change = New payment − current combined payment
Worked examples
Example 1: three debts of $125,000 at a 26.6 percent weighted rate into a 48-month loan at 13 percent
Use the defaults: Debt 1 $60,000 at 22 percent paying $2,800 a month; Debt 2 $25,000 at 24 percent paying $1,100; Debt 3 $40,000 at 35 percent paying $4,200 (an advance entered at its effective APR); Debt 4 empty; Consolidation rate 13 percent, term 48 months, fee 2 percent. Current combined payment = $2,800 + $1,100 + $4,200 = $8,100. Balances = $125,000. Weighted average rate = ($60,000 × 22 + $25,000 × 24 + $40,000 × 35) ÷ $125,000 = ($1,320,000 + $600,000 + $1,400,000) ÷ $125,000 = 26.6 percent. Running each debt forward: the three repay in 26, 31 and 11 months respectively, so Months to debt-free now = 31, and the interest paid along the way totals $37,900. Consolidation: principal = $125,000 × 1.02 = $127,500; r = 0.13 ÷ 12 = 0.010833; New payment = $127,500 × 0.010833 ÷ (1 − 1.010833^−48) = $3,420.51; total of payments = $164,184; Consolidation total cost = $164,184 − $125,000 = $39,184. Monthly payment change = $3,420.51 − $8,100 = −$4,679.49. Lifetime saving = $37,900 − $39,184 = −$1,284, shown as an extra cost. The rate halves and the payment falls by more than half, but the term stretches from 31 months to 48, so the borrower pays slightly more in total. Whether that is a good trade depends on what $4,679 a month of freed cash is worth to the business.
Example 2: two expensive debts into a 36-month loan at 15 percent: a clear saving
Enter Debt 1 $45,000 at 29.9 percent paying $2,100; Debt 2 $30,000 at 40 percent paying $3,600; Debts 3 and 4 empty; Consolidation rate 15 percent, term 36 months, fee 3 percent. Current combined payment = $5,700. Balances = $75,000. Weighted average rate = ($45,000 × 29.9 + $30,000 × 40) ÷ $75,000 = ($1,345,500 + $1,200,000) ÷ $75,000 = 33.9 percent. Running forward, Debt 1 takes 32 months and Debt 2 takes 10, so Months to debt-free now = 32, with $28,200 of interest paid. Consolidation: principal = $75,000 × 1.03 = $77,250; r = 0.0125; New payment = $77,250 × 0.0125 ÷ (1 − 1.0125^−36) = $2,677.90; total of payments = $96,404; Consolidation total cost = $96,404 − $75,000 = $21,404. Monthly payment change = −$3,022.10. Lifetime saving = $28,200 − $21,404 = $6,796. Months to debt-free: 32 → 36. Here both tests pass: the new rate is less than half the weighted average, and the term is only four months longer than the current payoff, so the saving in interest outruns the fee and the extra months. This is the profile consolidation is designed for.
Example 3: two moderate debts into a long 60-month loan at 16 percent: a lower payment that costs more
Enter Debt 1 $50,000 at 18 percent paying $1,800; Debt 2 $20,000 at 22 percent paying $900; Debts 3 and 4 empty; Consolidation rate 16 percent, term 60 months, fee 2 percent. Current combined payment = $2,700. Balances = $70,000. Weighted average rate = ($50,000 × 18 + $20,000 × 22) ÷ $70,000 = ($900,000 + $440,000) ÷ $70,000 = 19.1 percent. Running forward, the debts take 37 and 28 months, so Months to debt-free now = 37, with $22,700 of interest. Consolidation: principal = $70,000 × 1.02 = $71,400; r = 0.013333; New payment = $71,400 × 0.013333 ÷ (1 − 1.013333^−60) = $1,736.31; total = $104,179; Consolidation total cost = $104,179 − $70,000 = $34,179. Monthly payment change = −$963.69. Lifetime saving = $22,700 − $34,179 = −$11,479, an extra cost. The new rate is only three points below the weighted average and the term is 23 months longer, so the borrower pays $11,479 more for a $964 lower payment. That is a cash-flow loan, not a saving, and should be presented as one.