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  

37 thoughts on “balloon-payment-calculator

  1. 1. Can you please make the schedule an Excel file?

    2. Can you please add a field where I can specify the date of the first payment?

    3. Thank you.

    • Please modify so you can specify specific loan dates.

      • For that feature, please use the time value of money calculator. This calculator will support balloon loans and you’ll be able to set origination date, payment dates and balloon date to any date desired.

        If you click on above link, scroll down the page and please see tutorial nos. 7 and 8:

        Balloon Payment Calculation
        Calculate the balloon amount

        Balloon Loan Calculation
        Calculate the periodic payment required to result in a specified balloon

        If you try this calculator, I would be very interested to know how you make out.

  2. #2 – there is already a calculator on this site that will allow you to have a balloon payment and set the 1st payment date (or any payment date for that matter). Please see:

    Ultimate Financial Calculator

    This calculator is our most flexible calculator. However, it may take some getting use to. To that end, there are 25 tutorials listed at the bottom of the page. Please see #7 and #8. (Note, the tutorials still have not been updated to reflect the new look, but the basic functionality between the old calculator and new one is the same. Ask question on that page if something isn’t clear.)

    #1. This is where I get a chance to sell you something. The C-Value! program will create a schedule and export to Excel. If you are using Windows you may want to consider using it. It costs $19.95. (Works in a very similar way to the above calculator.)

    Thanks for the comment.

  3. How can I change the dates on this calculator to reflect a loan schedule that shows a loan to be made 1/1/17 whose repayment starts 2/1/17?

    • Not with this particular calculator. However, this loan payoff calculator will let you set dates (even setting the date individually for all payments should that ever be needed).

      Depending on whether the regular payment is unknown or the balloon payment about is unknown, scroll down the page and see the tutorial #7 or #8 for examples.

      If you have any question about its use, you can ask them on that page.

      (Some calculators on this site do not offer date options so that they are smaller and work better on smaller devices. Additionally, for some requirements, setting dates is an unnecessary hindrance.)

  4. I need to run several payment schedules with fixed payment amounts but I also need to choose the loan date (05/01/16). It seems all your calculators assume a loan date of the first of next month (04/01/16). Can you recommend another calculator?

    • Thanks for asking. I see you found it, but for the benefit of others, the amortization schedule allows the user to select a loan date and first payment date.

      I’ll also point out that since you were looking at the balloon payment calculator, the the amortization schedule won’t support balloon loans. However this calculator, time value of money will allow you to set the loan date and have a final balloon payment. (Note, the tutorial listed at the bottom of the page, still need to be updated. Hopefully they will be completed within the next two weeks.)

  5. How can I change the first payment date. The autocalc started in 6/1/2016 with first pymt due 7/1/2016. I need it to start with 1st pymt 6/1/2016.

    Thank you for any info and assist.

    Gary Spray

  6. Can you please add smart phone support? Tried on both a window phone and android but was able to edit any numerical fields. Only the drop down fields.

    • I’ve got to try to get a hold of an Android device to try this. As far as I know, the site should work well with any modern device – handheld, tablet or desktop. I’ve personally tested with iPhone, iPad and all popular desktop browsers.

      With Android, does it have next/previous buttons? Or tab/shift tab? If so, please try this. Rather than touch the screen and try to edit, use the keys to go to the next input and then try to type. My hunch, that will work.

      In general, for edit to work, the number has to be selected OR type the backspace key to clear first.

      Please let me know of any of these things help.

  7. Using the balloon payment calculator, I am unable to come up with the amount allocated to interest on the first payment made. Would you be able to tell me the exact calculation the program uses to figure the interest amount? (maybe I am not using the correct number of days, etc?)

    • I have to limit the support to questions dealing with either how to use a calculator or what calculator to use to solve an explicit problem. But, unless you are using daily, exact or continuous compounding, the number of days has no part in the formula.

  8. I want to customize the start date.
    i also want to export the amort schedule to excel. How do I do that?

    • Hi, then in that case, please use the Ultimate Financial Calculator. Scroll down the page and see tutorials 7 an 8:

      Balloon Payment Calculation
      Calculate the balloon amount

      Balloon Loan Calculation
      Calculate the periodic payment required to result in a specified balloon

  9. Hi,
    Can one get a widget for the balloon payment calculator?

    • You can do that with a calculator on this site, but not with this calculator. Please use the Ultimate Financial Calculator. Click on the "Settings" button and select "Rounding". Back sure it is set to "Open Balance".

      Are you tracking loan payments? If so, scroll down the page and see tutorial #25.

    • Sorry, but I have a lot of the other projects lined up and I won’t be creating any more plugin or widgets for the time being. I want to work on expanding this site. (Of course, if someone wanted to pay me some big bucks, I guess I could be persuaded to do a custom widget 🙂 )

  10. How can i settle balloon loan? I took a vehicle finance using a balloon loan from a bank and the payment started in August 2016 and will end September 2022. If i want to settle during 2020 financial year what are the disadvantage or any benefis? Please advise me regarding the matter
    Thank you

    • You can settle the loan by paying the balance due at any point.

      As to the advantages or disadvantages, since I’ve not seen the terms of your specific loan, I’m not in a position to say. But, in general, if someone pays back a loan early, they will have (should have) the benefit of some interest savings which then can be used for something else.

      FYI: In general, I limit my replies to either answering questions about either what calculator is best to use for a particular problem; or how to use a particular calculator.

  11. This is a very awkward, complicated, user-unfriendly site. Will not be back. Very frustrating and impossible to understand.

  12. Is there a way to convert this schedule into excel?
    If not, is there a way to have the payments start March 1, 2018 ?????

    • As you’ve discovered, the user can’t override the default dates with this calculator. You can copy/paste the print preview to Excel, but I guess you would want the schedule to update interest when you change the date. That won’t happen.

      For your needs, what I suggest is that you use financial calculator. It will create balloon schedules and you’ll have full control over dates and interest rates as well. If you try is, scroll down the page and see these tutorials:

              7) Balloon Payment Calculation
                 Calculate the balloon amount
              8) Balloon Loan Calculation
                 Calculate the periodic payment required to result in a specified balloon

      I also recommend looking at tutorial #1 to get started.

  13. Not sure if my first request went thru……….

    Can you please make the schedule an Excel file?

    If so, can you please add a field where I can specify the date of the first payment?

  14. How to calculate if there’s additional principal payment made?

    • You can’t with this calculator.

      However, with this calculator you can create a schedule with extra payments for a balloon loan.

      Once on the webpage, scroll down to the tutorials. There are some with examples of both balloon and extra payments. I also suggest that you look at tutorial #1 to get an overview.

  15. We are closing a $39,000 loan on 5/31/2018. Terms are: Interest rate of 2.18% amortized over 30 yrs, with first payment due 7/1/2018 and a balloon payment due 6/1/2021 at the end of 3 years. Interest paid in arrears with each payment. The calculator works great for the balloon, but I can’t get it to show the initial interest payment due at closing. Is there a way to show this? Thank you.

    • This calculator won’t do what you need.

      However, this loan calculator will.

      If you try it, go to the options page to set the dates and set the long period interest option to "with origination" if you want to have the interest collected or due on the day the money is lent.

      For the balloon, you’ll enter the 4 numbers for loan amount, ballon payment due number is number of periods, the interest rate and the payment amount. The calculator will not need to calculate anything, other than the schedule, since you already know these four values.

Comments, suggestions & questions welcomed...

* Required