Please tell a friend about us. Thank you.

If you've come to this page expecting a lecture about the dangers of excessive debt, then you've come to the wrong page.

I designed the Ultimate Debt Calculator so that anyone who has more than one outstanding loan can see for themselves if it would be beneficial to change their payback plan.

If you want a lecture, you can find plenty of blog posts about problems resulting from over-borrowing from a quick web search. For example, consider this post about personal debt or this one about business borrowing.

Instead of lecturing, I'll show you strategies for accelerating your repayment that will save you interest charges. Two such plans, commonly called the debt snowball and the debt avalanche, can possibly save you a bundle. And they don't even require a change in the total monthly payment.

Wouldn't it be sweet to save perhaps thousands of dollars?

Wouldn't it be even better if you could save thousands of dollars and not change your current monthly payment total - either now or ever?

The numbers don't lie.

The multiple debt calculator, will create a single payment schedule that gives you a personalized, step-by-step plan to reduce and then eliminate debt.

And remember, you do not need to be in financial difficulty to benefit from the knowledge you can gain when using this calculator. In fact, if you have multiple outstanding loans, you're a smart consumer if you spend a few minutes with this calculator to learn how various payback strategies can impact your finances.

More below....

Need to audit a cash flow?
The Ultimate Finance Calculator calculates any unknown with regular or irregular cash flow.
Need to calculate interest paid or earned?
This Compound & Simple Interest Calculator calculates interest between any two random dates.
Need to calculate a rate of return on multiple investments?
Check out our Internal Rate of Return (IRR) Calculator. It supports irregular investment dates.
Ron and Amanda
Ron & Amanda — DYI Debt Free Planners
IndexDebt DescriptionDebt BalanceMinimum Payment PctMinimum Payment AmountCurrent PaymentInterest RateDay Due (1-31)CompoundingPriority
DebtNo/YrDatePaymentInterestPrincipalBalance

The total payment amount remains constant until all debts are paid off. As one debt is paid-in-full its payment amount is rolled over to pay off another debt. This process continues until all debts are paid-in-full. Thus the total monthly payment amount remains constant.

This is the easiest reduction method to follow. It requires no change on the debt holder's part. They paid what they paid last month. The only assumption is, if the debtor could pay X amount one month then they can pay the same amount every month.

Note: If you select the "Loan Consolidation Method" or "Meet a Goal Method" then this option will not be available.

Select one refinance option:

This amount is used to pay off the loans with the highest interest rates first. Unpaid balances will continued to be financed at their current interest rates.

If you know either the payment amount or the number of periods you may enter them here:

Note: If you know neither of the above values (enter "0"), the payment amount will be calculated using the average term.

Note: Uncheck the "Rollover Payment Method" to use this option.

In addition to, or instead of, the rollover payment option or the loan consolidation orption, extra payments can be made which decreases the loan balance and reduces the interest paid and shortens the overall term.

Extra payments are applied in debt priority order. After the debt assigned "Priority 1" is paid off, the extra payments rollover to the "Priority 2" debt.

Selecting this option will adjust all payments so that the loans are paid off by the above date in the most efficient way possible. This means that if some loans are paid off before this date using their current payment amount then their payments will be decreased so that they are paid-off on this date too. This results in the lowest possible over all payment required to meet the goal.

Note: If this method is selected then "Rollover Payment", "Loan Consolidation" and "Extra Payment" options are not available.

Note: Uncheck the "Selected Method" to use this option.

After one of the debt reduction methods is applied to the total debt, the loans will be paid off earlier than if just the current payment or minimum payment schedule were followed. Once the loans are paid off, the monies being used to pay the debt can be invested. This option allows you to enter your personal average investment rate of return. It will be used to calculated the gain if the payments were invested for the period of time between the early pay-off date and the pay-off date if just the current payments were made.

Example: If making only the current payments, the debt will be paid off in 48 months while following the loan consolidation method it will be paid off in 28 months, selecting this option will show the total value of the current payments if they were invested at this interest rate between the 28th month and the 48th month. The concept here is that you'll pay down the debt faster AND build wealth by the time the debt would have been paid off under the current payment schedule.

If you enter your annual income, your debt to income ratio will be calculated on the "Analysis" tab.

DebtNo/YrDatePaymentInterestPrincipalBalance
Debt Summary
Normal Payoff Summary
Accelerated Payoff Summary
$ : mm/dd/yyyy
  Original Size  

The webpage preloads the calculator with sample data so you can quickly try it and understand the various options. I suggest you take a few minutes to read the below before entering your loans.

But, if you are the type of person that likes jumping in and learn by trying, then you may want to skip ahead to Pointers on using the Ultimate Debt Calculator.

On the other hand, if you want to make sure you don't miss any features this debt calculator offers, then please keep on reading.

(If you started to enter your information, and now you want to follow along, hit your browser's refresh button to reload the page.)

FACT: Debt is a way of life

The fact is, most folks in western societies will borrow money at some point in their lives, and this is not inherently either good or bad. According to PEW Charitable Trusts, as of 2015, "80% of Americans hold some form of debt, made up of mortgages, car loans, unpaid credit card balances, medical and legal bills, student loans, or a combination of those".

The key is for borrowers to manage their loans and to reduce the cost of borrowing to whatever extent possible.

How can this be done?

Let's look at a not atypical couple; we'll call them Ron and Amanda, who are recent college graduates. Between them, they have college loans, two car payments, and one credit card with a balance resulting from expenses associated with their cross-country move and from buying a few necessities for their new apartment.

Our "not atypical" couple carries student loan debt equal to the average Class of 2016 graduate of $37,172 according to Student Loan Hero, and for this illustration we'll assume they are paying an interest rate equal to the 2017-2018 Stafford PLUS loan rate of 4.45% as reported by U.S.News.

Amanda and Ron both need cars to get to their jobs and they borrowed a little less than $30,000 to purchase two used ones. Again, the interest rates they are paying (10.0% and 5.42%) are within the normal used car interest rate range according to AAACreditGuide.

Finally, the credit card with a $5,500 balance accrues interest at a rate of 18%. This rate is significantly higher than the average credit card rate which is at 14% for cards that have balances as reported by CreditDonkey (as of June 2017.

One other optional detail, both Ron and Amanda started their careers at jobs that paid the average wage for 2017 college graduates, $49,785, according to Money magazine.

The total debt of just under $110,000 should not present a problem for our young couple with this income. In fact, it is well below the US national average as both an absolute number, $204,000 according to Sentier Research as of 2015 and when expressed as a debt to income ratio 370% according to Fortune Magazine. Thus there debt-to-income ratio is slightly above 100%. (More on this later.)

Fortunately, Ron and Amanda should not be stressed out over their debt load.

If that's the case, why should they care about debt management?

In one word, "interest."

What is the cost of debt?

Everything we buy has a cost, and when we take out a loan, we are buying the use of the money for usually a set period (known as the loan's term). Therefore, when we borrow money, we should think of the transaction just like we think about any other purchase we make.

So, what is the cost of that purchase?

The cost is the interest charged.

All things being equal, none of us would usually want to pay more than we have to pay for anything we buy. Purchasing a loan should be no exception.

But here's the great thing. The cost of a loan, unlike almost any other purchase, can be lowered even after you've received the amount borrowed and have signed all the paperwork.

And lowering the cost does not require the approval of the seller, i.e., the lender!

Try lowering the cost of a car after you've bought it!

Further, if you can lower your ongoing borrowing costs, you'll frequently save more than just money - you'll very likely also save time. That is, it won't take as long to pay back the loans as it would when the costs are higher.

Saving time means you'll be able to take your interest savings and either invest it sooner (thus giving your investments more time to grow) or put them toward another purchase.

How do I lower my debt costs even after the loan papers are signed?

At a high level, you'll need to take four steps to lower your loan costs.

  1. Understand your current debt situation fully.
  2. Review the different debt reduction strategies.
  3. Decide on a plan to follow.
  4. Follow the plan.

Fortunately, this debt calculator will make three of the four steps relatively easy. Unfortunately, it can only go a little way in helping to make the fourth step easier. You'll still be responsible for making the payments on the revised plan!

What the calculator can do however is create for you one payment schedule showing all the debts with the payments paid on their respective due dates.

I don't believe there is any other calculator on the net that will do that for you.

Ready to get to the meat?

Good!

Let's take a look at what Amanda and Ron's loans will currently cost them.

1. Understanding Your Debt Situation

Before Ron and Amanda can start using the calculator, they need to gather together information about all their current loans. To do this, they work from the most recent statements provided by each lender. (Of course, you'll need to do the same.)

debt entry screen
Debt entry screen. Use "Previous" and "Next" buttons to navigate and calculate.

Note, for this exercise; it is never necessary to know the original loan amount. This task is all about understanding the present, not the past.

As you can see from the initial entries in the calculator, Ron and Amanda have entered their current debt details on the tab page labeled "Debts."

Please note a few details about the list of debts....

For most loans, the "Minimum Payment Due" and the "Current Payment" will be the same amount. That is typical for student loans, car loans, and mortgages. It's ok not to enter minimum payment amounts. They aren't required. Nonetheless, you may want to do so for reasons we'll discuss later.

Like "Minimum Payment Due," "Minimum Payment Percentage" is not required either. In fact, most loans won't have a "Minimum Payment Percent." The borrower will be expected to pay a specific amount due.

The primary exception, of course, is credit cards. Credit card issuers state a "Minimum Payment Percentage" because credit card balances can, and often do, fluctuate considerably, and therefore, it's not practical to declare an absolute minimum amount.

For other details about the debt list, scroll down and see Pointers on using the Ultimate Debt Calculator.

With the debts entered, Ron and Amanda can see their complete debt picture - all in one place - on the "Current Payback" tab.

The "Print Preview" provides a summary of the details in the report's header. Their total outstanding debt is $108,250, and they are making payments that currently total $1,757 a month.

Following their current payment plan, they will have their debts paid off after 9 years and 2 months (or 110 months).

They will pay a total of $134,855 in principal of which $26,605 will be cumulative interest on all the loans.

current payoff analysis
Current payoff details from analysis page.

Let's see what they can do to lower their loan costs.

That is, can they make their debt purchase cheaper, even though the paperwork is signed and they have received the loan proceeds?

Of course they can. And you can too!

To learn how much Ron and Amanda can save, we'll take a look at multiple debt reduction strategies.

2. Reviewing Debt Elimination Strategies

Even if you decide to make no changes to your current payback plan, I think that you'll agree, the debt calculator will give you a comprehensive understanding of the different payback options.

There are four distinct methods we will present for lowering borrowing costs.

Debt reduction methods
Debt reduction methods.
  1. Extra principal payments
  2. Loan Consolidation
  3. Rollover reduction techniques, including
    • Debt Snowball.
    • Debt Avalanche.
    • Shortest to longest term.
    • Freelance Method.
  4. Meet a Goal

In addition, you can review two more methods:

  1. Rollover with extra payments
  2. Loan consolidation with extra payments

Making extra principal payments perhaps is the most commonly known way to save on interest charges so we'll discuss it first.

A. Making Extra Principal Payments

What are additional payments and why does making them save the borrower money?

Extra payment options
Extra payment options.

Let's look at Ron's auto loan with a balance of just over $12,000 at an annual interest rate of 10%. If Ron decided to pay an additional $100 the $100 is used to reduce the principal balance.

This means the next interest calculation is on a lower balance than it otherwise would have been had the additional $100 not been paid. Thus the interest portion of the payment is less and more is applied toward principal, which lowers the balance even more.

Yes, it is true, that the amount of interest saved is very tiny at first (in this case, less than $1). But by making even one extra payment, the interest owed is reduced for every future payment.

On the other hand, if the borrower keeps making the extra payments, the interest savings continues to increase as the principal gets paid down faster.

The debt calculator supports three ways of making extra payments.

On the "Extra Payment" tab under "Debt Reduction Methods," you can enter an additional payment amount that is applied every month, or you can plan on paying extra amounts in particular months for varying values if you wish.

When you use the options on the "Extra Payment" tab, the extra payments are applied to the debts in "Priority" order as set in the debt list.

The third way to incorporate an extra payment into the debt reduction plan is to increase the "Current Payment" amount. That gives you complete flexibility to apply the extra payment to whatever debt you wish. And it is also a way to apply an extra payment to just one loan - that is, the extra payment does not roll over to another loan when the selected loan for the extra payment is paid off.

The disadvantage to incorporating the extra payment into the results this way, is you'll need to run the calculation first without the additional amount and then again with it. Then you'll need to calculate the interest saved by hand by noting the difference in the total payment on the "Current Payback" tab.

B. Loan Consolidation

Loan consolidation can potentially offer borrowers a large savings.

Loan consolidation is when the borrower takes out a new loan to pay off an existing debt or debts that have a higher interest rate.

loan consolidation options
Loan consolidation options.

The debt calculator supports three consolidation options:

  1. The new loan is for the full amount of all the debts. If you are looking to save the most interest on your debts, you should only select this option IF the consolidation loan's interest rate is lower than all the interest rates for all the debts.
  2. The new loan is for the full amount of all the debts with an interest rate equal to or higher than the consolidation loan. This is normally the best option.
  3. The new loan is for a random amount not equal to any specific debts or sum of debts. The calculator pays off the highest interest rate loan first and continues until the consolidation loan is fully applied to the debts.

For maximum savings, you must continue to pay the same monthly payment you had been paying even though the new lower interest rate loan does not require you to do so.

If your consolidation loan replaces two loans, sum their payments and enter them into the "New Payment Amount" input.

Where can a borrower get a consolidation loan?

There are two conventional sources:

First, if you have equity in a home, one source of funds for loan consolidation with usually a low-interest rate might be a home equity loan. If you consider this option, please understand the risks as it beyond the scope of this post to discuss them here.

A second source is to shop for a credit card with a lower interest rate. Or better yet, check the credit card you already have. Perhaps one has a lower interest rate. If so, you can transfer loan balances to the more economical rate card.

Loan consolidation can save interest charges. However, it does require some work on the borrower's part. First, you have to shop for a new loan, and then you have to apply for the loan which may require filling in a loan application and waiting for loan approval.

Nonetheless, the savings can be substantial and well worth the effort.

Let's look at an interest reduction method that requires absolutely no work by the borrower.

C. Rollover Payment Methods

Rollover payment methods are unquestionably my favorite way to efficiently pay off debt and to save money.

debt rollover methods
Debt rollover methods.

These are the methods that require no change in a borrower current behavior assuming that the borrower pays their loans on time and in full.

The rollover principal is simple. You pay your loans each month as they come due. But, after a loan is paid off, rather than paying less in loan payments the next month, you keep paying the total amount you had been paying by adding the paid off loan's payment amount to another debt's payment.

There are several ways to do this:

Debt Snowball Technique has been popularized by Dave Ramsey. You can read the details here. However, to summarize, the method dictates that the borrower pays the maximum amount they can afford to pay on the lowest balance debt while paying the minimum payment they are allowed to pay on all the other debts.

The lowest balance debt is paid off first, giving the borrower a sense of accomplishment, and the payment is rolled over to the next higher balance. The process repeats until all balances are paid off.

The debt snowball rollover and the resulting savings are automatically calculated for you using the current payment amounts you've entered in the debt list. If you are making payments higher than the minimum amount for any loan aside from the loan with the shortest term, you should adjust the current payment to equal the minimum payment and add the extra you had been paying to the shortest term loan.

That is if you want to follow the snowball method to a tee.

The choice is yours.

Debt Avalanche Technique is like all rollover methods - the borrower pays the same total loan payment month-to-month.

With this method though, the borrower pays the maximum affordable payment to the debt with the highest interest rate first, and the minimum amount to all other debts. If there are loans with shorter terms and lower rates, as they are paid off, their payments will rollover to the loan with the highest interest rate.

Again, the calculator makes the rollover calculation automatically. You can see all the details with exact payment dates and amounts on the "Debt Reduction Results" tab.

Shortest term to longest requires that the maximum amount available be paid to the loan with the fewest number of remaining payments and the minimum payment amount to the other debts.

Freelance method this is where you are in complete control. The calculator rolls the payments over in the priority order that you have set in the debt list.

If you want to get rid of a loan with a small balance first and then pay the most to the loan with the highest interest rate, just set the priority in that order.

The loan with priority one is the highest priority followed by two, three, etc.

D. Meet a goal method

You are entirely in the driver's seat with the "Meet a Goal" method.

Look at your current payment schedule and see when the last payment is due. Then pick a date that you want to be debt free that is earlier than the final payment date.

meet a goal method
Meet a goal debt reduction. Calculates each loan's payment amount so that loans are all paid off on the same date.

The calculator will recalculate all the payments to have all loans paid off by your goal date. When your goal date is earlier than the anticipated payoff date, you'll not be borrowing the money for the length of time initially expected, and thus you'll save interest charges.

Now that you understand the different debt reduction techniques available to you, let's look at Ron and Amanda's current debt and see just how much they can save and which method they should follow.

3. Deciding on which strategy to follow.

Debt Calculator list of current debts
Ron and Amanda's debt list showing their original extra payment allocation.

Ron and Amanda have itemized their debts and reviewed their current payback plan. They have learned that their total debt is just over $108,000 and that they will pay $26,605 in interest charges until the loans are paid off in 2027.

Payment schedule showing current debt free date
Current remaining payoff totals and debt free date (results will vary depending on run date).

Amanda and Ron are intrigued by the various rollover methods.

They decide to compare their current payoff plan to the Debt Snowball method and the Debt Avalanche method.

Notice, however, they are paying extra on both their student loans and their credit card balance (the payments are above the minimum). They had heard that making additional payments on a loan is a good practice and that it will save them interest.

When including these extra payments, all loans will be paid off in 110 months, and the total interest comes to $26,605 (see "Analysis" tab or "Current Payback" tab).

Optimize all extra amounts going to one loan either lowest balance or highest rate

optimized payments
Optimized payments. All set to minimum payment with any extra added to highest interest rate (VISA) loan.

Now that they know the facts, it is time to decide on a plan and to follow it.

4. Following the new plan

The debt avalanche save our borrowers the most money, so that's the plan they decide to follow.

debt avalanche summary
Debt avalanche summary shows nearly $6,000 in interest savings.
This is accomplished with no change to the total payment amount.

Ron and Amanda are highly motivated to adopt this new payment plan. To help keep them on track, and to have a way of checking that the lenders are correctly allocating the payments between interest and principal, Ron uses the calculator to print their personalized debt reduction schedule.

This calculator just may be the only one on the internet that is capable of creating (and allowing users to print) a single schedule, with exact due dates, for multiple loans.

Pointers on using the Ultimate Debt Calculator

  • Loans DO NOT have to be entered in the debt list in priority order.
  • Pay attention to the checkboxes on the "Debt Reduction Methods" tabs! Make sure the method you want active is active.
  • Use the [Next] and [Previous] to move through the steps. Using the buttons rather than the tabs assures that calculations are completed in the correct order.
  • Don't use the [Delete Row] button to delete a debt if you want to do a new analysis less one debt. Rather, set the priority to "0". The calculator ignores all debts with a "0" priority.
  • The extra payments are applied in the debt's priority order. If you entered your debts and numbered them from 1 to 5 (1 is the highest priority and five the lowest priority, and you want to change the order so that four is ahead of 2, renumber debt 4 to 1.5. And a gap between 3 and 5 is ok.
  • Like almost all calculators on this site, this calculator is date sensitive. It is possible to do a calculation one day and get one result and then do a calculation with the same debt details on another day and get a different result. That is NOT a bug. I suggest you print your "Debt Result Schedule" from the print preview to save for reference.
  • If you see a relatively small difference in interest calculations from what the lender calculates, try a different compounding frequency. Otherwise, leave it set to "Monthly."
  • Not that it's likely to make a huge difference, the balance you enter should be the balance immediately after the last payment. Or it should be the balance as of the date one month before the next payment due date. The first payment for any debt will always follow "today."
  • Make sure to include only the portion of the payment amount going toward the loan. If, for example, one debt is a mortgage, do not include the amount that may be going toward insurance or property taxes (escrow).

NOTE:, I consider the current version to be a beta release. Please review the results and question anything that does not seem correct (though I'm not aware of ANY calculation errors).

Wrapping it up

As I mentioned from the outset, anyone with multiple debts can potentially benefit from studying and selecting one of the above debt reduction strategies.

After all, what consumer does not want to save money?

However, if you believe that you have excessive debts or are otherwise in financial trouble, please consider contacting the National Foundation for Credit Counseling and ask about speaking with an NFCC certified credit counselor. The NFCC is a nonprofit organization.

Sometimes, borrowers required help beyond what the Ultimate Debt Calculator and I can offer.

debt analysis page
Comprehensive debt analysis page.

Comments, suggestions & questions welcomed...

* Required