CCalclabhub

Finance · 103 calculations

Loans

How To Calculate A Balloon Payment

A balloon loan makes small payments for a few years and then demands the rest in one lump. The size of that lump is just the outstanding balance of an ordinary amortising loan on the balloon date.

Quick Answer

B = P x (1 + i)^n - PMT x ((1 + i)^n - 1) / i

B
The balloon payment, the balance still owed on the balloon date
P
The original loan amount
i
The interest rate per payment period, the annual rate divided by 12
n
The number of payments made before the balloon falls due
PMT
The regular payment, sized as if the loan ran its full term

Grow the original loan by compound interest for the number of payments made, then subtract the future value of those payments. A 250,000 loan at 6 percent amortised over 30 years still owes 232,635.89 after 60 months of 1,498.88 payments.

What Is A Balloon Payment?

A balloon payment is the unpaid principal left on a loan when it comes due early. The borrower makes regular payments for a set period, and at the end of that period the entire remaining balance is due at once.

The arithmetic is the same arithmetic as any amortising loan, only stopped early. Each month interest accrues on the balance, the payment covers that interest and a little principal, and whatever principal has not been covered by the balloon date is the balloon.

The regular payment is sized as though the loan ran its full amortisation schedule. A 30 year schedule on a 5 year balloon means the payments are the small 30 year ones, which is exactly why so little principal gets repaid and why the balloon is so large.

Two clocks run at once and confusing them is the classic error. The amortisation term sets how big each payment is. The balloon term sets how many of those payments you actually make. They are independent inputs.

The formula has two halves. The first, the original principal grown by compound interest, is what you would owe if you never paid anything. The second is the future value of the payments you did make. The difference is what is left.

Because the payment is calculated on the long schedule, early payments are almost entirely interest. On the example loan, 60 payments of 1,498.88 come to 89,932.80 in cash, but only 17,364.11 of principal has been retired.

That ratio is the whole point of the structure. A borrower gets low monthly outlay for years and then has to refinance, sell, or find cash. The lender's risk is concentrated in that one date.

Balloon loans are common in commercial real estate, where the property is expected to be refinanced or sold well before a 25 or 30 year schedule would run out. They are also used in car finance as a way to advertise a low monthly figure.

A balloon mortgage for an owner occupier is a different animal. Regulators in several countries restrict them precisely because a borrower can reach the balloon date unable to refinance, and the result is forced sale or default.

The alternative framing is to ask what payment would fully repay the loan over the balloon term instead. On the same 250,000 at 6 percent, paying it off in 60 months rather than 360 needs a very different monthly figure, and comparing the two is the honest way to judge the structure.

Interest rates matter more here than on a fully amortising loan, because almost nothing is being repaid. Raising the rate both raises the payment and slows principal reduction, so the balloon grows from both directions at once.

The outstanding balance can also be read off directly as the present value of the payments you have not yet made. That is the same number computed from the other end, and it is a useful way to check your arithmetic.

Some balloon structures include a balloon note with a reset option, letting the borrower extend at a new rate if certain conditions are met. Those conditions are a contractual matter, not an arithmetic one, and they belong in the loan documents rather than in any calculator.

For the example used throughout this page, 250,000 at 6 percent on a 30 year schedule with the balloon at month 60, the payment is 1,498.88, the balloon is 232,635.89, and the total paid across the life of the loan is 322,568.47.

That total is the number to compare against. A borrower who only looks at the monthly payment sees 1,498.88 and misses that 72,568.47 of interest has been paid for the privilege of retiring only 17,364.11 of principal.

Formula

PMT = P x i / (1 - (1 + i)^-N)

Formula page →

The ordinary level payment for the full schedule, even though only n of them will be made.

SymbolMeaning
PMTPayment
PPrincipal
iPeriod rate
NAmortisation term

B = P x (1 + i)^n - PMT x ((1 + i)^n - 1) / i

Formula page →

Compound interest on the balance, less the future value of payments already made.

SymbolMeaning
BBalloon payment
nPayments made
iPeriod rate

Principal repaid = P - B

Formula page →

The gap between what was borrowed and what is still owed, which is usually shockingly small.

SymbolMeaning
PPrincipal
BBalloon payment

How To Calculate A Balloon Payment

  1. 1

    Convert the annual rate to a period rate

    Divide the quoted annual rate by twelve for a monthly schedule. A 6 percent loan gives 0.005 per month. Use the period rate everywhere; mixing the annual rate with a monthly count is the single most common source of wrong answers.

  2. 2

    Size the payment on the full amortisation term

    Work out the level payment as though the loan ran to the end of its schedule. On 250,000 at 0.005 monthly over 360 months that is 1,498.88. This is the payment the borrower actually makes, even though the loan stops early.

  3. 3

    Compound the original principal to the balloon date

    Multiply the principal by one plus the period rate raised to the number of payments made. After 60 months that factor is 1.348850, so 250,000 grows to 337,212.53 on paper.

  4. 4

    Work out the future value of the payments made

    An annuity of 60 payments of 1,498.88 at 0.005 per month accumulates to 104,576.64. Subtract that from the compounded principal and the remainder is the balloon.

  5. 5

    Read the result and sanity check it

    The balloon is 232,635.89. Check it two ways: sixty payments totalling 89,932.80 retired only 17,364.11 of principal, and 17,364.11 added to 232,635.89 returns the original 250,000.

Examples

Example 1: Commercial property with a five year balloon

loanAmount
250000
annualRate
6
amortizationMonths
360
balloonMonths
60
StepCalculationResult
Period rate0.06 / 120.005
Payment on the 30 year schedule250000 x 0.005 / (1 - 1.005^-360)1498.88
Principal grown for 60 months250000 x 1.005^60337212.53
Future value of 60 payments1498.88 x (1.005^60 - 1) / 0.005104576.64
Balloon payment337212.53 - 104576.64232635.89

Result: The balloon is 232635.89. Across the five years the borrower has paid 89,932.80 in instalments and still owes 232,635.89, for a total of 322,568.47 against a 250,000 advance.

Example 2: The same loan with a ten year balloon

loanAmount
250000
annualRate
6
amortizationMonths
360
balloonMonths
120
StepCalculationResult
Period rate0.06 / 120.005
Payment, unchanged250000 x 0.005 / (1 - 1.005^-360)1498.88
Principal grown for 120 months250000 x 1.005^120454837.16
Future value of 120 payments1498.88 x (1.005^120 - 1) / 0.005245622.85
Balloon payment454837.16 - 245622.85209214.31

Result: Doubling the term to ten years cuts the balloon to 209214.31, but only 40,785.69 of principal has been retired against 179,865.60 of payments made.

Calculator

Monthly payment

$1,498.88

Balloon payment
$232,635.89
Principal repaid
$17,364.11
Total interest paid
$72,568.47
Share of the loan still owed
93.05%

Values update as you type. This calculator covers the single scenario its formula assumes — see Common Mistakes for what it leaves out.

Prefer a full-width tool? Open the A Balloon Payment calculator page.

Common Mistakes

  • Using the annual rate with a monthly payment count

    The 6 percent has to become 0.005 per month before it touches a monthly exponent.

  • Sizing the payment on the balloon term instead of the amortisation term

    That produces the wrong payment and therefore the wrong balloon, even though the formula is right.

  • Assuming the balloon is the original principal

    It is always less, because some principal has been retired, but never by as much as borrowers imagine.

  • Forgetting that the payment count in both halves of the formula is n, the number of payments actually made, not N the full schedule.

    Forgetting that the payment count in both halves of the formula is n, the number of payments actually made, not N the full schedule.

  • Rounding the payment before using it

    A payment rounded to the dollar and then compounded through sixty periods can shift the balloon by hundreds.

  • Ignoring that lenders often round the payment up or down to the cent, which changes the final balance slightly in the borrower's favour or against it.

    Ignoring that lenders often round the payment up or down to the cent, which changes the final balance slightly in the borrower's favour or against it.

  • Treating a balloon as a penalty

    It is not a fee, it is simply the unpaid balance falling due, and refinancing it is a separate transaction with its own costs.

FAQ

Is a balloon payment the same as the loan balance?

Yes. The balloon is exactly the outstanding principal on the balloon date. There is no separate charge or premium built into it, unless the loan documents add a fee for exercising an extension option.

Why is the balloon so large when I have paid for five years?

Because the payment was sized on the long schedule. On a 30 year amortisation almost all of an early payment is interest, so five years of payments retire less than a tenth of the principal.

Can I avoid the balloon by paying more each month?

Extra principal payments reduce the balance directly, so yes, the balloon shrinks by the extra amount plus the interest it would have earned. Check whether the loan permits prepayment without a charge.

What happens if I cannot refinance at the balloon date?

That is the central risk of the structure. If the loan has no extension option and refinancing is unavailable, the lender can demand the full balance, which in practice means selling the asset or defaulting.

Does a balloon loan cost more interest overall?

Over the period you hold it, yes, relative to the principal repaid, because so little principal is retired. Compared with a fully amortising loan of the same balloon term, the monthly payment is lower but the balance at the end is far higher.

How do I check a lender's balloon figure?

Ask for the payment, the rate, the amortisation term and the balloon term, then recompute. The two figures should agree to within a few dollars; a large gap usually means the payment was sized on the wrong term.

References

  1. [1]Consumer Financial Protection Bureau, What is a balloon payment? — https://www.consumerfinance.gov/ask-cfpb/what-is-a-balloon-payment-en-141/
  2. [2]Wikipedia, Balloon loan — https://en.wikipedia.org/wiki/Balloon_loan
  3. [3]Wikipedia, Amortization calculator — https://en.wikipedia.org/wiki/Amortization_calculator