CalcTrace

Debt Consolidation Calculator

Consolidating means replacing several debts with one new loan. Whether that helps depends on three things that pull in different directions: the new rate, the new term and the fees. Enter your debts as they are now and the loan you are considering to see the two side by side.

Last updated .

Your debts now

“Repayment” is what you actually pay on each debt every month.

The new loan

Result

New monthly repayment

–

NowNew loanChange

–Owing now
–Average rate now
–New loan amount
–Break-even new rate

Your debts as they stand

DebtRepaymentCleared inInterest
Show the working

    What is compared, and how

    Before. Each existing debt is carried forward on its own, at its own rate and the repayment you make now, until it is cleared. The number of months and the interest come from the fixed-repayment formula, with a smaller final repayment for whatever is left:

    n = −ln(1 − B × r ÷ PMT) ÷ ln(1 + r)

    The “before” interest is the sum across the debts, and the “before” payoff time is that of the slowest debt. Each repayment is assumed to stop when its own debt is cleared.

    After. The new loan pays out all the balances. Its repayment comes from the standard loan formula:

    PMT = L × r ÷ (1 − (1 + r)−n)

    B is a debt’s balance and L is the new loan amount: the balances added together, plus the upfront fee if it is added to the loan. r is the monthly rate as a decimal (yearly rate ÷ 12 ÷ 100), n the number of monthly repayments, PMT the monthly repayment and ln the natural logarithm.

    Total cost of the new loan = interest + upfront fee + monthly fee × n

    The comparison that matters is total cost against the interest you would otherwise pay, not repayment against repayment.

    Worked example: three debts into one 11% loan

    DebtBalanceRateRepaymentCleared inInterest
    Credit card 1$6,00020%$18050 months$2,830.91
    Credit card 2$3,00018%$9047 months$1,190.16
    Personal loan$8,00013%$26038 months$1,784.10

    Before: $17,000 owing, $530 a month, 50 months until the last debt is cleared and $5,805.18 of interest. The average rate, weighted by balance, is 16.35%.

    The new loan is at 11% over 5 years with a $300 upfront fee added to the loan:

    1. L = $17,000 + $300 = $17,300. r = 11% ÷ 12 = 0.0091667, and n = 60.
    2. 1.0091667−60 = 0.578397, and 1 − 0.578397 = 0.421603.
    3. PMT = $17,300 × 0.0091667 ÷ 0.421603 = $158.58 ÷ 0.421603 = $376.14 a month.
    4. Interest = 60 × $376.14 − $17,300 = $5,268.64 (using the unrounded repayment). Total cost = $5,268.64 + $300 = $5,568.64.

    After: $376.14 a month, which is $153.86 less; 60 months, which is 10 longer; and a total cost of $5,568.64, which is $236.55 less than the $5,805.18 of interest before. A rate more than five points lower produces only a small saving, because the debt is being carried for ten more months.

    A lower repayment is not the same as a lower cost

    Stretch the same loan to 7 years and the repayment drops to $296.22, which is $233.78 a month less than now. But the interest rises to $7,582.32 and the total cost to $7,882.32, which is $2,077.14 more than leaving the debts as they are. The rate fell; the cost rose, because the balance is outstanding for 84 months rather than 50. The calculator flags this case whenever the new repayment is lower and the total cost is higher.

    The reverse also holds. Over 3 years the repayment is $566.38, slightly more than now, and the total cost is $3,389.67, a saving of $2,415.51.

    A fair test separates the effect of the rate from the effect of the term: keep paying what you pay now. Putting the current $530 a month into the 11% loan clears it in 39 months and costs $3,651.56 including the fee, $2,153.62 less than before and 11 months sooner. The calculator shows this line under the comparison.

    The break-even rate is the new-loan rate at which, over the chosen term and with the fees entered, the total cost equals what you would pay now. For the 5-year loan it is 11.46%; for the 7-year loan it is 8.21%. A quoted rate above the break-even figure costs more overall.

    What is and is not included