Updates for 2022: Historical Investment Calculator update to 15 indices through Dec. 2021
Compare different assets, for example, the S&P 500 with gold and housing, and optionally adjust for inflation.
Inflation Calculator U.S. and German historical inflation calculations plus future inflation. Investment Calculator inflation model updated.

Balloon Payment CalculatorAmortization Schedule with Balloon Payment

advertisement

Balloon loan - a whimsical name don't you think for a potentially risky financial product?

What is a balloon loan?

Wikipedia defines a balloon loan or mortgage as a loan "which does not fully amortize over the term of the note, thus leaving a balance due at maturity. The final payment is called a balloon payment because of its large size."

This Balloon Loan Calculator will not only calculate the final balloon payment, it will also help you structure a loan to meet your exact needs.

Check out these additional loan scenarios:

  • Want to know what periodic payment will result in a specific final balloon amount? This calculator will calculate the regular payment.
  • Or do you need to set the regular payment to an agreed upon, but nontraditional amount before calculating the balloon? This calculator is capable of doing that calculation as well.
  • Or do you have a budget for both the periodic payment and the balloon payment and you want to know how much you can borrow? This calculator can use your inputs to calculate the loan amount.
  • Or do you want to calculate the periodic payment using say a 30-year term while the balloon is computed using a 7-year term? Yup, you can do that calculation too. See "Doing the Two-Step" below
×

Info...

  Original Size  

Copy and paste this URL to save your inputs to share them with others.

Click "Calc", "Clear", "Preview." or "Schedule" to update the URL. Paste it into any browser to reload.

Using the Balloon Loan Calculator

advertisement

As mentioned, a balloon loan is a loan that has its regular periodic payment calculated using one term (say 30 years) when the last payment is due sooner (say in 7 years).

If you do not know the amount of the regular loan payment, then we must calculate it before we can calculate the final balloon amount.

Example: Assume you are considering a mortgage for $146,500. You want the monthly payment calculated based on a 30-year loan, but you'll pay the balance after 72 months.

Doing the Two-Step

Step 1: Enter:

Amount of Loan?:$145,500.00
Annual Rate?:4.5000%
Balloon Due at Payment? (#):360
Periodic Payment?:$0.00
Final/Balloon Payment (can be 0)?:$0.00

When you enter "0" for both "Periodic Payment" and "Final/Balloon Payment," you are setting up the calculator to calculate a level payment for the entire term of the loan. That is the final payment will not be a balloon payment.

Click "Calc" and here are the results. $737 is the "regular" payment amount for a 30-year loan. (The final payment gets rounded by less than $2.00 or less than $0.01 per each regular payment.)

Periodic Payment?:$737.23
Final/Balloon Payment (can be 0)?:$735.27

Step 2: Now to calculate the balloon payment amount, with the balloon due after six years, set the calculator as follows:

Amount of Loan?:$145,500.00
Annual Rate?:4.5000%
Balloon Due at Payment? (#):72
Periodic Payment?:$737.23
Final/Balloon Payment (can be 0)?:$0.00

Click "Calc," and this is the balloon that will be due in the final month of the sixth year if the debtor makes payments based on an assumed term of 30 years:

Final/Balloon Payment (can be 0)?:$130,433.50
Amortization schedule
Amortization schedule showing final balloon payment.

If that's what you wanted to know - what the balloon payment amount will be for a loan, then you're finished.

But with this calculator, it's possible to do more. You can structure a loan, just the way you want it.

Other scenarios - very flexible!

advertisement

Example 2: Pick the balloon payment amount and calculate the periodic payment:

Amount of Loan?:$145,500.00
Annual Rate?:4.5000%
Balloon Due at Payment? (#):72
Periodic Payment?:$0.00
Final/Balloon Payment (can be 0)?:$100,000.00
Result:
Periodic Payment?:$1,110.73

Example 3: Pick any periodic payment amount:

Amount of Loan?:$145,500.00
Annual Rate?:4.5000%
Balloon Due at Payment? (#):72
Periodic Payment?:$2,000.00
Final/Balloon Payment (can be 0)?:$0.00
Result:
Final/Balloon Payment (can be 0)?:$27,541.94

Example 4: Pick your payments and see what you can borrow:

Amount of Loan?:$0.00
Annual Rate?:4.5000%
Balloon Due at Payment? (#):72
Periodic Payment?:$1,000.00
Final/Balloon Payment (can be 0)?:$50,000.00
Result:
Amount of Loan?:$84,794.97

Balloon Amortization Schedule with Extra Payments

The calculator's support for extra payment is very flexible. First, you'll notice the calculator prompts you for "Extra Payments Start?" date. You can, therefore, schedule extra payments between the regular due dates if doing so is better for your cash flow.

As mentioned elsewhere, the calculator allows for a one-time extra payment or for multiple extra payments. The multiple extra payments can be for 2 or any number up until the loan is paid-in-full. (In that case, set the number of extra payments to "Unknown.")

When the extra payments are "off-schedule," the calculator prepares an expanded amortization schedule, showing the payment being applied 100% to the principal with interest accruing.

Balloon loan schedule with interest only payments and a lump sum extra payment
Balloon loan schedule with interest only payments and a lump sum extra payment.
Note how the interest-only payment drops from $545 to $526 after the extra payment.

This is the correct way to apply the payment - something that other online calculators don't usually handle properly. That is if they even let you plan for extra payments between regular payments.

The Interest-Only Payment Method is a Special Case

Most frequently, the periodic payments get allocated to both principal and interest. Thus with each payment, the loan balance is being reduced.

But what if the borrower wants to pay even less per period?

If that's the case, the lender may agree to make the balloon loan one where the borrower pays only the interest due on each payment date. Paying only the interest each period reduces the payment amount even more for the borrower.

Interest-only option selected for the regular periodic payments
Interest-only option selected for the regular periodic payments

This calculator supports interest-only payments (select the option under "Amortization Method"). If you select it, however, the calculator works slightly differently.

  • First, the balloon payment will always be equal to the loan amount. Therefore, it isn't possible to solve for the balloon payment.
  • Or looked at in a different way, the user cannot provide a periodic payment amount. The calculator will always calculate the regular payment amount since it is the interest due.
  • When introducing extra payments into the interest-only cash flow, the calculator's main window shows the amount of the first interest-only payment. But after each prepaid principal amount, the subsequent payments will be reduced since prepaying lowers the loan balance which, of course, reduces the interest due.

Given the above, if you select interest only, in almost all cases, to use the calculator, you'll want to set both of these inputs to 0.

Periodic Payment?:$0.00
Final/Balloon Payment (can be 0)?:$0.00

Charts

As the day winds down, I go cross-eyed looking at columns of numbers. That's where cash flow charts come in handy. You can quickly learn the relationship between the principal, interest and optional extra payments.

This calculator creates 3 charts.

Balloon payment chart
Chart depicting regular periodic cash flow with a large final balloon payment.
  • The annual chart compares total interest and principal paid each year.
  • The accumulated chart shows the amounts allocated to the principal and interest since the start of the loan.
  • The pie chart clearly shows the relationship between total interest and principal with calculated percentages.

Bloggers, feel free to use these charts to make your point. Click for several export options.

Should I take out a balloon loan? There's Risk!

Balloon loans have their advantages. The borrower gets to borrow a large amount, for a short period, while making relatively small periodic payments.

However, the borrower should only consider this loan type if they are confident that they'll have the funds available or that they'll be able to refinance the loan in time to make the balloon payment when it comes due. Otherwise, the borrower will most certainly default on the terms of the loan, and they risk ruining their credit rating.

You can leave your comments and questions below.

advertisement

95 Comments on “Balloon Payment Calculator”

Join the conversation. Tell me what you think.
  • Have a 24 month balloon starting on 6/30/2022 amortized over 30 years with the first payment due 08/01/2022. The 23rd payment is due 06/01/2024. Why is the balloon not due until 07/31/2024?

    • The loan date, 6/30/2022, has no impact on when the balloon is due. The balloon (which is a payment, of course) is calculated from the first payment date, 8/01/2022. I assume you entered payment #24 for when you want the balloon due. That would be 7/01/2024.

      But no worries. Did you need a schedule with a balloon payment paid on July 31, 2024? In that case, use the Ultimate Financial Calculator which allows users to set any payment, including a balloon payment, to be due on any date.

      Look for the links to the tutorials. There are 2 tutorials/guides specifically about balloon loans.

      • Everything you stated was correct except the balloon date. It is automatically setting up the balloon payment for 7/31/24 instead of 7/1/24 charging the borrower internet for the entire month of July.

      • Everything you stated was correct except the balloon date. It is automatically setting up the balloon payment for 7/31/24 instead of 7/1/24 charging the borrower interest for the entire month of July.

        • I see now. I can’t duplicate what you are saying. That is, with the balloon being on 7/31/24. All the details are important. I guess the best thing to do if you want me to take a look is to copy and paste all your actual inputs into a reply to this message. To do that, you can select each tab on the calculator and select the text and inputs, and copy. But the schedule that I get, as I mentioned, shows the balloon due on 7/01/24.

          • It will not allow me to copy/paste into this comment box. If the closing date is set for either 6/29 or 6/30/22 it moves the balloon payment(payment #24) to 7/31/24. It should be on 7/1/24 because payment #23 is on 6/1/24. If we move the closing date to 7/1/22 the problem is corrected with the balloon due on 71/24.

          • The calculator on this page does not have a "closing date" option. Earlier, you had said that you had the "First Payment Due" set to August 1, 2022. First payment date is used to determine the balloon payment date.

            I can think of one possible exception, and that is if your calculation also expects extra payments. Perhaps one extra payment goes past the balloon due date to make the balance 0?

          • Using the calculator defaults, I set the dates to this:

            Balloon Due at Payment? (#): 24
            Loan Date?:  06/30/2022
            First Payment Due?: 08/01/2022
            

            The schedule shows the final payment (balloon) on July 1, 2024.

            24:2	07/01/2024	99,999.97	373.60	99,626.37	
            

            But now, I see the problem. When I look at the schedule a second time, the date does change to July 31.

            I’ll let you know when I fix this. In the mean time, for closing/loan dates on 30, 31, please always have a 0 for one unknown when clicking on the "Payment Schedule" button. Then it should produce the correct schedule.

            Sorry that I made this a roundabout problem trying to figure out what is going on.

  • The loan date is the closing date. When set to 6/30/22 the balloon payment is due 7/31/24 instead of 7/1/24. The extra payment box is set to $0 and the balance is also $0 at payment #24. If the loan date is moved back a few days it sets the balloon date as 7/31/24. I have tried every option available to correct this with no luck.

  • Even with setting the number of extra payments to $0 instead of unknown it doesn’t change. Not sure what I should do as I cannot get it to show 71/24 as the balloon date

    • What I had to do to get the correct schedule after the first calculation was set the "Periodic Payment" back to $0.

      Then set the 1st payment date to a date less then the 28th and click on the "Payment Schedule" button

      Then again set the periodic payment to 0 and the 1st payment date to either the 29th or 30th as needed and click on the "Payment Schedule" button.

    • Dan, I fixed the issue with the dates. Thank you for letting me know, and sorry for the hassle.

      If you do not see the fix, you may have to perform a hard refresh of the page:

      Depending on your operating system all you need to do is the following key combination:

      • Windows: ctrl + F5
      • Mac/Apple: Apple + R or command + R
      • Linux: F5

      Above, from Refresh Your Cache.

Comments, suggestions & questions welcomed...

* Required

Scroll
to calculator
to questions/comments
advertisement