advertisement
Ad horizontal-1

Most people are probably aware that if they make "extra" payments when paying back a loan that they'll reduce the loan's interest charges and the debt will be paid back earlier than it would have otherwise been.

In some cases, usually for longer-term loans such as mortgages, the savings in interest charges can be quite substantial. If the borrower starts making the extra payments early enough, and for an amount that's not exceptionally large, it is possible to save tens of thousands of dollars on a $200,000 mortgage (the average size new mortgage balance as of 2017, according to the Consumer Financial Protection Bureau was $260,386).

Specifically, with an average mortgage, by making $200 a month extra payments, the borrower will save over $50,000 assuming a 30-year loan and a 4.25% interest rate.

How is this possible? What sleight of hand is taking place?

There's no sleight of hand. The future savings are a mathematical certainty. It all has to do with the way loans, and mortgages work. The periodic interest amount is calculated using the loan's current balance and multiplying it by the periodic interest rate - the lower the balance, the lower the interest amount due.

Thus when you prepay principal (make extra payments), you are lowering the loan balance used for calculating the interest due.

As I said, this is a mathematical certainty, and this calculator will show you just how much interest you'll save on any loan, and when the loan will be paid off.

Imagine what it would be like being free of a 30-year mortgage in 20 years! More below

×

Info...

  Original Size  

Sounds pretty good, right?

Of course it does!

But, what if I told you, "How much will I save if I make extra principal payments?", isn't the question you should be asking?

"What If I Invested the Money Rather than Make Extra Payments?"

Ahh, that's the more important question!

Rather than reducing interest costs via prepaying principal, what if you saved and invested the money? Would you be further ahead?

That's that critical question to be asking.

If you have $200 and you use it to make a prepayment toward a loan, you can't also use the same $200 for investing. Economists say, not being able to invest is a foregone opportunity. The opportunity to do something else with that same $200 won't come back. The chance is gone.

How then do you know which is the better decision?

advertisement
Ad horizontal-2

Use this calculator!

The calculator uses "Your Investment Rate-of-Return," and calculates the future value of all the projected extra payments. It then calculates the investment gain and subtracts it from the "Total Interest Saved" to arrive at the net gain from the extra payments (the "Interest Saved Less Investment Gain" shown).

Let's look at an example.

When you come to this page, you'll find the calculator preloaded with a $260,386 loan/mortgage, and $200 a month is the default prepayment amount.

For the investment rate-of-return, the calculator uses as a default 7.2%, which is the approximate average rate-of-return for the S&P 500 according to this (somewhat dated) analysis. (Dated, yes. But considering what the stock market has done since this study, my 7% assumption for deciding whether or not to make extra payments on a loan is conservative.)

You, of course, are free to use whatever rate-of-return you like.

Using these defaults, here are the results:

Savings from making extra payments
Extra payment calculator results. In this case, investing is more advantageous.

$52,829 in interest savings and the mortgage that would have usually taken 360 payments to pay off, will be paid off after 276 payments.

But, here's the real story.

If the borrower takes the $200 a month and invests it, after the 276 months, their investment GAIN will be $81,238! (Total value of the investment account will be $55,000 in extra payments invested plus the $81,238 gain equals $136,238.)

Now it should be apparent that while a $52,000 savings is terrific, an $81,000 gain is better.

Just how much better?

$28,409 better, as the final result "Interest Saved less Investment Gain" ($52,929 - $81,239) shows you.

If, after plugging in your numbers, you get a negative result too, then YOU SHOULD CONSIDER NOT MAKING EXTRA PAYMENTS!. You'll, at least hypothetically make more money from your investments than you save in interest charges.

Want to confirm the results?

Then make sure you click on the "Supporting Schedules" button. There you'll find all the supporting number that went into the above analysis. There's a detail amortization schedule showing the periodic payment and interest charges as well as the extra payments coming off the principal balance.

After the loan payment schedule, you'll find a future value or investment schedule. This schedule documents the capital gain from the invested extra payments.

Amortization schedule with extra payments
The amortization schedule with extra payments followed by the investment schedule

When might you want to continue to make extra principal payments even when the calculator indicates investing might be the more prudent course to follow?

There are at least two reasons I can think of when you might not want to invest the prepayment funds.

I can express one reason with a single word - Risk!

Remember when I was discussing why making prepaid principal payments saves the borrower money, I used the phrase "mathematical certainty?" If the borrower makes the extra payments as anticipated, then the interest savings is a sure thing. The lender can only charge the periodic interest on the outstanding balance of the loan.

But, if you invest, and even if you invest per the anticipated schedule, for the full amount and on the scheduled day, the return on the investment is likely not to be guaranteed (though true, some investment instruments might offer a guaranteed profit). In that case, at the end of the term, when the loan would have been paid off, you might not have the capital gains that you had anticipated. Of course, you might also have a more significant gain than what you had anticipated.

That's the risk.

The second reason why you might not want to invest is that you want to live debt free. I understand how when someone takes out a 30-year mortgage, they might dream of living without any mortgage debt in say 20 years. I get that. The fact is, that's how I felt, and that's what I did - but I did it before I created this calculator!

For here's the thing. It is possible to be both free of debt early and to implement an investment strategy for your funds rather than a principal prepayment strategy. They are not mutually exclusive!

Let me walk you through this, step-by-step:

Debt free date with extra payments
Debt free date with extra payments.
Balance on debt free date
You'll have a $92,929 loan balance on the debt free date when no extra payments are made.
Investment account's value as of debt free date
But there's over $136,000 in the investment account as of debt free date. You can still pay off the loan!
  1. Look at our example again - the one the calculator preloads when you first come to this page (click on your browser's refresh button if you want it back). At the time of this writing, the analysis shows the final payment scheduled for March 1, 2042. Make a note - that's the debt-free date with extra payments.
  2. Now set the extra payments to 0 and look at the schedule. This is the schedule without any additional payments. Find the balance as of the debt-free date. Again, as of this writing (these illustrations are time sensitive), the balance will be $92,929.
  3. Now, one more time, reenter the extra $200 payment amount and recheck the investment schedule located after the loan schedule. (The calculator prepares an investment schedule only if you have entered an extra payment amount AND if the option "Include the Investment Schedule?:" is set to "Yes.")
    • As shown, when making prepaid principal payments, the loan is paid off in 276 payments - or 23 years.
    • On March 1, 2042, the balance in the investment account will be $136,238.
    • You can easily pay off the mortgage using the funds in the investment account, live debt free as of the date planned, and still have nearly $40,000 remaining!

Of course, there is a rub.

This analysis overlooks the impact of taxes. If you live in the US, all or part of the interest may be deductible from your income taxes (though after the 2017 tax law changes, this is not as much of a certainty as it had been in the past). One the investment side, income taxes will frequently have to be paid on any investment gain, thus reducing the illustrated gain.

But even taxes on the gain are not a foregone conclusion. If you were to invest in tax-free bonds, then there is no tax on the income (but the illustration probably won't be as favorable). Or if you invest and don't sell along the way, the gain will compound tax-free. You'll only pay income taxes on the gain when you sell. And generally, income taxes on long term capital gains are very favorable to investors.

No doubt these points about taxes are something you need to consider. If I were to program the various tax considerations as options for this calculator, I think it would leave users very frustrated - not to mention me!

The Calculator's Features

Of course, your situation is likely different than this hypothetical example. So you'll want to use this Extra Payment Calculator to see just what you can save and when your loans will be paid off.

Let me take a few moments to go over some the other features this calculator supports.

If you don't plan to make extra payments monthly, that's okay. The calculator will let you make additional payments using any one of 11 payment frequencies set independently from when the scheduled payments are due.

For example, do you get an annual bonus? Do you want to use that bonus to prepay principal? This calculator will still calculate your saving under such a scenario. You can easily set it to make one or two extra payments a year.

Or do you want to make a one-time extra payment? That's no problem either. The calculator supports making a single extra payment on any date during the term of the loan. Perhaps you've received a one-time inheritance, and you are considering using it to reduce your loan's principal balance. The Extra Payment Calculator will tell you the amount of interest you'll save and when the pay off will be.

(Perhaps I should also point out that the loan itself does not need to follow a monthly payment schedule. The last option on the Extra Payment tab allows the user to select any payment frequency.)

This Calculator is Not Just for New Loans.

advertisement
Ad horizontal-3

Up until now, I've been implying that the calculator is only for analyzing new loans. That's not the case. Perhaps you've been making loan payments for a few years, and you've recently received a raise. If you want to see the impact of making extra payments on an existing loan then there are no unknowns for the calculator to calculate (other than the effect of making the prepaid principal payments of course), so enter the following for the first four inputs:

  • The loan's balance as of the last payment due date.
  • The number of payments remaining.
  • The loan's interest rate.
  • The regular payment amount.

The calculator will use the terms of your loan for the analysis.

There is also one other setting to be aware of. On the "Extra Payments/Investment Rate" tab, please see "Is a Regular Payment Due Today?:" This setting impacts the analysis. It is set to "No" by default. However, if for the loan balance, you enter the balance as of the date a payment is due, then you should set this to "Yes." This prevents the calculator from adding the accrued interest since the last payment due date.

If you don't follow the above, please don't stress out. It won't make that big of a difference!

Don't Forget the Charts

No doubt if you spend time going over the schedules, you may find your eyes glazing over. (For sure, there are a lot of numbers!) If you find that happening to you, or if you aren't a detailed "numbers person," make sure you check out the nine charts that the calculator automatically creates.

Chart showing extra principal payments
Top chart showing extra principal payments. Bottom chart showing investment gain.
  • Annual Totals without Extra Payments
  • Annual Totals with Extra Payments
  • Annual Investment Plus the Annual Gain
  • Accumulated Totals without Extra Payments - running totals since the loan's origination
  • Accumulated Totals with Extra Payments
  • Accumulated Investments Plus the Total Gain - show year-over-year growth and final value
  • Pie Chart Loan Payment Total Allocated to Principal and Interest
  • Pie Chart Loan Payment Total Allocated to Principal and Interest with Extra Payments
  • Pie Chart Showing Breakout of Investments and the Gain on the Investments

Wrapping Up

When you were searching for an extra payment calculator, you probably just wanted to see how much interest you could save if you were to start making additional loan payments. You probably didn't expect there to be so many things to consider.

Don't feel as if you need to digest all of this in one sitting. Come back and try different scenarios. Make different assumptions.

But remember, the point is, no matter what decision you make, the calculator will help you to make an informed one.

When you make that decision, I would love to hear from you about what course of action you plan to take. And did you find this calculator to be a useful tool? Should I make any changes in the way it works?

You can let me know in the comments below.

79 Comments on “Extra Payment Calculator”

financial online calculator Join the conversation. Tell me what you think.
  • Jim Weaver says:

    Hi,
    I find your extra payment calculator very helpful, but would like two changes:

    1. Allow the extra payment amount to begin on the very first payment (chart shows it starting on second payment whether I enter 1 or 0 in the set up)

    2. Allow entry of date of first payment.

    Thanks again!

    • Glad to hear that you find this calculator useful and thank you for taking the time to comment.

      As to point #1, that’s a bug. I’ll have to get it fixed. And as to point #2, this calculator is not a auditor’s tool. The intent is to give users a quick way to calculate the impact of making extra payments on a loan. Requiring users to enter a date slows things down and it further increases the size of the calculator which makes it less useful on small devices.

      But, we do have a tool that will allow you to do what you want (and will work around the bug too). Please see:

      time value of money calculator

      and these 2 tutorials:

      Random Extra Principal Payment

      Series of Extra Principal Payments

      The TVM Calculator is our most flexible financial calculator and I think, well worth spending some time with.

    • Jim, item #1 has now been fixed. If you enters 0, for "Increase Starts at Month? (#):", the extra payment starts on the loan date. Of course if you enter 1, then the extra payment starts with the first payment.

      Did you by any chance try the TVM calculator? If so, how did that work for you?

  • thoughts:

    1. I’d like to be able to see total interest (rather than just interest saved) in the first set of numbers after calculation. After all that is what you want to know — how much it costs rather than just how much you save. You do see this in the second page after you look at the chart, but you can’t print the first set of conclusions with the actual amount of total interest you pay as it stands.

    2. I’d like to be able to set the start date of the loan myself. Your chart just chooses it.

    3. I’d like to be able to print the conclusions of the chart (the summary) rather than the whole chart with all its numbers.

    4. I’d like to be able to add in a big payment to the principal, let’s say one year after I begin the loan. So “What if I was able not only to make extra payments but also a lump payment 12 months into an 84 month loan?”

    Thank you for the charts and the ability to make comments. Both appreciated.

    • Thank you for your “thoughts”. These are constructive ideas and in fact they are so good that is why you’ll find many of them implemented in another calculator! 🙂

      Please see the time value of money calculator.

      Scroll down the page and checkout these tutorials:

      9. Random Extra Principal Payment
      How to prepay principal on any date

      10. Loan with Series of Extra Principal Payments
      How to calculate loan or mortgage with extra payments

      The calculator supports both within the same schedule.

      You’ll also be able to set the dates (for each payment if you wish).

      About the printing of the summary, I’ve got a list of changes for this site already. Once those are completed, I’ll look at making the changes to the summary that you’ve suggested.

  • Hi! This is the closest we have found to. What we are looking for… but do you have a way to figure a fixed principal pmt of say 25000 for a 4000000 loan at 10% interest? I find all sorts of “extra pmts” but nothing that shows basically a principal reduction pmt of 25k. And the interest doesn’t really add to the principal, rather the principal lowers by the 25k each month???

    • Hi Kerri. A couple of my calculators will create an amortization schedule with fixed principal payments. I suggest you try this Loan Calculator as one option.

      Note, to create a loan as you describe, set this calculator’s “Amortization Method” to “Fixed Principal“. Once you try it, and if you have any issues or questions, please ask again.

  • Chart issue.
    set up for 134444.00,348 months(29 years), 3.99,0, 630.00extra and months payoff =130. Schedule looks great, but charts show payoff in 19 years instead of 10.8. Values in charts don’t make sense. starts extra in year 3 and so on. good info except for the charts. thanks

    • Glad the schedule worked for you. And of course, I want to get any software bugs fixed. But what number did you enter for “Increase Starts at Month? (#):”? If I enter 36, the chart shows the extra payments starting in year 4, which is correct.

      But now, I just saw if I switch to the extra payments starting at period #1, the chart does not consider that change. I’ll let you know when I post a fix. Thanks for taking the time to report it.

  • I love that I can see what I’ll be saving by increasing my principle payment each month. It would be great if in addition to what you currently have, you could calculate the impact of additional monthly principle payments AND a one time additional principle payment annually. So adding $100 a month each month, but also an additional $500 principle payment 1or 2 times per year.

    I had found a calculator that let me do that once – but I can’t find it anymore.

    Thanks

    • Thanks for your comment.

      You can do what you want with the Ultimate Financial Calculator! 🙂

      Take note of the tutorials further down the page. Everyone should read tutorial #1 to get an overview. Then the tutorials that will be most interesting to you will be:

      9. Random Extra Principal Payment
      How to prepay principal on any date
      10. Loan with Series of Extra Principal Payments
      How to calculate loan or mortgage with extra payments

      And these are NOT mutually exclusive. That is you can have a series of extra payments and a single or multiple extra payments on random days.

      To see what you’ll save, run an amortization before entering the extra payments.

      Hope this helps.

  • Here is how my loan is suppose to work, but I dont think they are doing it right. We are suppose to have a daily compund interest with bi weekely payments on a 30 year note. They can not give me an amortization schdule. Not liking this would like a caculator that shows me what is going on.

  • I’m not sure how to calculate my payment hx. 28 yr/$296,000.
    My current monthly payment is $1394.06 & making $205.94 principal payment. Total of $1600 and I making bi weekly payments of $800. So I’m making extra principal payment & the 13th payment of $1394.06 goes to principal. With this payment schedule how much sooner with I get my mortgage paid off? I’m having a hard time finding a calculate to estimate it.

    • Since the payments are being adjusted with an extra amount and you have biweekly payments as well for another perspective loan, I think the best calculator to use is the Ultimate Financial Calculator on this site. If you try it, scroll down the page, and you find a number of tutorials. I think what you are going to need to do is to calculate each loan separately and compare the schedules.

      If after looking at that calculator, you have more questions, please ask them on that page.

  • Very nice tool. Recommended improvement: allow the extra payment to be at a different frequency. E.g., a loan with a payment of $1000/month. Wife has job that pays bi-weekly, so allow an additional payment of $300 every two weeks.

    • Thanks, James. I appreciate that. Sorry not to have gotten back to you earlier today, but while this calculator will not do what you want, there is a calculator on the site that will. If you still have the need, please try the Ultimate Financial Calculator. It works with payment "Series" and you can insert a series of extra payments starting on any date and repeated with any frequency you want.

      Scroll down the calculator’s page and check out:

      9. Random Extra Principal Payment
      How to prepay principal on any date

      10. Loan with Series of Extra Principal Payments
      How to calculate loan or mortgage with extra payments

      I also suggest all users check out tutorial #1 to get started.

      Let me know if you have any questions. I’m happy to answer them.

    • Hi James, your requested feature of allowing for a different frequency for the extra payments has now been added. Hope it meets your needs.

  • Thanks, very helpful simple calculator. I suggest following additional features to add to the calculator:
    1) Please add date, the loan started (as a variable)
    2) Amortization spreadsheet

    • For item #1, there is already a calculator that accepts extra payments and lets you set the dates. Please see the Ultimate Financial Calculator. Once there, scroll down the page and look at the tutorials. There are a couple for extra payment options. Read #1 to get an overview of how this calculator works.

      For #2, do you want to export to Excel or another spreadsheet program?

  • Do you offer a service where I tell you what I need an amortization schedule to do and you plug it in and do it and then I pay you and send it to me?

    • No. That’s not a service I offer. Why? All the calculators are here. Tell me the details. I’ll tell you what calculator, and you can easily create an amortization schedule for free anytime you need one.

  • Really great tool! I knew the extra payments would help, but it’s nice to see exactly what the difference is. Thank you for making this available.

Comments, suggestions & questions welcomed...