Please tell a friend about us. Thank you.
Enter a "0" (zero) for one unknown value above.

©2016, all rights reserved
$ : mm/dd/yyyy
  Original Size  

25 thoughts on “extra-payment-calculator

  1. 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 Calculators

      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?

  2. How do I calculate the impact of dividing my mortgage into weekly payments, rather than a monthly payment?

  3. 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.

  4. 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.

  5. 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.

  6. 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 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.

  7. How can I convert this info into an amortization schedule?

  8. 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.

  9. how do you figure in insurance as part of mortgage

  10. 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.

  11. Please can I get the plugin for Extra payment calculator

  12. 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.

Comments, suggestions & questions welcomed...

* Required