Debt Consolidation Savings Calculator Formula
Understand the math behind the debt consolidation savings calculator. Each variable explained with a worked example.
Formulas Used
New Monthly Payment
new_payment = new_monthly_rate > 0 ? current_balance * new_monthly_rate * pow(1 + new_monthly_rate, num_payments) / (pow(1 + new_monthly_rate, num_payments) - 1) : current_balance / num_paymentsTotal Interest (Consolidation)
new_total_interest = new_monthly_rate > 0 ? (current_balance * new_monthly_rate * pow(1 + new_monthly_rate, num_payments) / (pow(1 + new_monthly_rate, num_payments) - 1)) * num_payments - current_balance : 0Total Interest (Current Path)
old_total_interest = old_monthly_rate > 0 ? (current_balance * old_monthly_rate * pow(1 + old_monthly_rate, num_payments) / (pow(1 + old_monthly_rate, num_payments) - 1)) * num_payments - current_balance : 0Interest Savings
savings = (old_monthly_rate > 0 ? (current_balance * old_monthly_rate * pow(1 + old_monthly_rate, num_payments) / (pow(1 + old_monthly_rate, num_payments) - 1)) * num_payments - current_balance : 0) - (new_monthly_rate > 0 ? (current_balance * new_monthly_rate * pow(1 + new_monthly_rate, num_payments) / (pow(1 + new_monthly_rate, num_payments) - 1)) * num_payments - current_balance : 0)Variables
| Variable | Description | Default |
|---|---|---|
current_balance | Total Current Debt(USD) | 25000 |
current_rate | Current Weighted Avg Rate(%) | 22 |
new_rate | Consolidation Loan Rate(%) | 10 |
loan_term | Consolidation Loan Term(years) | 5 |
old_monthly_rate | Derived value= current_rate / 12 / 100 | calculated |
new_monthly_rate | Derived value= new_rate / 12 / 100 | calculated |
num_payments | Derived value= loan_term * 12 | calculated |
How It Works
Debt Consolidation
Consolidation replaces multiple high-rate debts with a single lower-rate loan.
When It Makes Sense
Formula
Both scenarios use the standard loan payment formula:
M = P x r x (1+r)^n / [(1+r)^n - 1]
The difference in total interest between old and new rates is your savings.
Worked Example
$25,000 at 22% average vs consolidation at 10% for 5 years.
current_balance = 25000current_rate = 22new_rate = 10loan_term = 5
- 01New payment = $25,000 at 10% for 60 months = $531
- 02New total interest = $531 x 60 - $25,000 = $6,874
- 03Old total interest at 22% = $707 x 60 - $25,000 = $17,418
- 04Interest savings = $17,418 - $6,874 = $10,544
Ready to run the numbers?
Open Debt Consolidation Savings Calculator