# Balloon Payment Calculator

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, but 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 lower the periodic payment even further? Then select interest-only payments.
- 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...

### Recent Updates to this Calculator:

- Added support for either a lump sum or a series of extra payments.
- Ability to create a loan schedule when the final payment is not a balloon payment. Why? You'll soon see.
- Now the periodic payment can be interest-only payments.
- The user can optionally set "loan date" and "first payment date."

## Using the Balloon Loan Calculator

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 |

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!

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.

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

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.

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

What do you think? Is a balloon loan a useful financial product? Or are you an issuer of these loans? If so, do you have anything to add to the above?

You can leave your comments and questions below.

## Balloon Loan Calculation Help

You can calculate one of any five possible unknowns with this calculator. Just enter a zero for one of the following: "amount of loan," "annual rate," "balloon due at payment number," "periodic payment" or "final/balloon payment."

Therefore, it is easy to solve for a periodic payment amount that will result in a particular balloon payment. Or you can solve for the balloon payment amount given a regular payment amount that you provide.

If you are solving for the balloon payment, and the periodic payment decreases as well, that indicates the periodic payment was larger than necessary given the other loan details.

Take this extreme example:

What if the loan amount is $100,000 and the balloon is due at period 48, and the periodic payment is $10,000? There no need for a 48th payment, much less a balloon payment. In this case, the loan would be paid off in 10 periods (not accounting for interest).

The calculator handles this scenario by recalculating and lowering the regular payment.

If you enter non-zero values for all five inputs, the calculator will recalculate the balloon amount provided.

NOTE: A balloon payment is NOT the remaining balance of a loan. See "Remaining Balance Calculator" if you need to calculate the loan balance after making a payment.

## Erica Osborne says:

I need an amortization schedule with the due date is 10 years but fully amortized over 20 years.

## Karl says:

Not sure if you’re just telling me how you are using this calculator, or if you have a question how to calculate what you need? This calculator will handle that calculation. If you need to know how, please give me some example numbers and I’ll explain how it’s done.

## Erica says:

Hi there!!

The loan amount is $120,813.87 with interest of 7% starting 12/28. First payment 1/28 payable monthly until 10 years. Fully amortized over 20 years.

## Karl says:

Okay, that’s helpful.

Since the payment amount for a 20 year amortization is currently not known, you’ll have to do this calculation in 2 steps.

Step 1:

Step 2:

If you want a balloon schedule where you have control over the dates, you can use this amortization schedule, or this loan calculator or this financial calculator. For the 1st two calculator, enter the values as calculated and they will create a schedule with the dates you set. For the last calculator, scroll down the page to the tutorials.

🙂

## Anne says:

how do you set the date on the payment schedule?

## Karl says:

With this balloon calculator, you can’t. However, this amortization schedule will create a balloon payment schedule and you can set both the loan date and first payment date. To use for a balloon schedule, enter all 4 values (loan amount, number of payments [payment number balloon is due], interest rate and normal payment amount) and calculator will show final balloon payment.

If you don’t know all 4 values, then solve for the one unknown, and then rerun setting the number of periods to when the balloon is due. If you have any questions, just ask.

## Mandy says:

We have financed a balloon loan for a 10 year and set it up on a 15 year note. How do you figure the interest paid and final payment if the borrowers pay monthly 2,000 and the. monthly payment is 1595.95. Loan amount 180,830.00 at 6%.

## Karl says:

If they paid $2,000 monthly, then don’t use $1,595.95 as the payment, use $2,000. The calculator will accept anything for the payment amount that you enter. You’ll want to set the balloon payment to unknown and let the calculator calculate it, using the $2,000 payment.

Does that answer your question?

You might want to also check out this financial calculator. It lets the user enter payment as they are made on the date they are made. If you go to this calculator’s page, scroll down to the tutorials. #25 deals specifically with tracking loan payments.