Amortization Schedule With Balloon Payment

An amortization schedule with balloon payment uses the same five columns as any other payment table: payment number, scheduled payment, the portion applied to interest, the portion applied to principal, and the ending balance. Nothing about those columns changes. What changes is where the table stops and what gets appended when it does.

In a conventional schedule, the ending balance column marches to zero on its own. The last row retires the last few dollars, the balance reads $0.00, and the document is finished because the loan is finished. A balloon schedule never gets there. It is truncated — cut off at the maturity date written on the note — while the balance column is still carrying a substantial number. That leftover figure does not vanish. It becomes contractually due in full on the maturity date, and the schedule records it as a final line.

Lenders display that final line two ways, and knowing which convention you are looking at prevents a genuinely alarming misreading. Some schedules add a separate row beneath the last scheduled payment, labeled something like “Balloon payment due” or “Maturity payoff,” showing the balance by itself. Others fold it into the final scheduled row so the payment column displays the regular payment plus the outstanding balance as one combined figure. The second convention is the one that makes people call their loan officer, because the number in the payment column suddenly jumps by a factor of a hundred or more with no explanation on the page.

Two audits are worth running on any schedule handed to you. First, confirm the balloon figure equals the ending balance of the row immediately above it — they should match to the penny, because the balloon is not an extra charge, it is simply the debt that remains. Second, confirm that the schedule's payment was computed on the amortization term stated in your note and not on the maturity term; a payment sized for the shorter term would be far larger and would produce a much smaller final row. If either check fails, you are looking at a different loan than the one you think you are signing.

One more property is worth internalizing before the numbers start: on a balloon structure, the balance column is not merely slow to reach zero, it is mathematically incapable of reaching zero within the loan's actual life. That is not a defect in the paperwork. It is the design.

Every balloon loan carries two separate terms, and confusing them is the single most common source of misread schedules.

• The amortization term is the hypothetical repayment horizon used only to compute the monthly payment. It is usually 30 years, sometimes 20 or 25. The loan will never actually run this long.
• The balloon term — also called the maturity term or the call date — is how long the loan actually exists before the entire remaining balance becomes due. Five and seven years are the common choices.

The table is generated in two moves. First, the payment is solved using the long term. If P is the loan amount, r the monthly rate (the annual rate divided by twelve), and n the number of months in the amortization term:

M = P × [ r(1+r)ⁿ ] / [ (1+r)ⁿ − 1 ]

Second, the schedule is generated month by month using that payment — interest on the outstanding balance, principal as the remainder — but iteration halts at month k, the balloon term in months, rather than at month n. The balance standing at that moment is the balloon. You can get it directly, without building every row, with the closed-form remaining-balance expression:

Bₖ = P(1+r)ᵏ − M × [ ((1+r)ᵏ − 1) / r ]

The intuition behind that second equation is worth a sentence, because it explains the whole shape of the table. The first term is what you would owe if you had made no payments at all and the debt had simply compounded for k months. The second term is the accumulated future value of the payments you did make, compounded forward at the same rate. The balloon is the gap between the debt that grew and the payments that chased it. Because the payment was deliberately sized against a much longer horizon, the chase is not close, and the gap stays wide.

This is also why balloon payments feel affordable right up until they do not. Sizing the payment on 360 months rather than 60 pushes the monthly obligation down by a large multiple, which is precisely the point for the borrower or the commercial owner who wanted the cash flow. The cost of that relief is not spread over the payments; it is deferred, whole, into the last row. If you want the underlying month-by-month mechanics without the balloon complication layered on top, our walkthrough of how mortgage amortization is calculated covers the base engine that this schedule runs on.

Concrete numbers make the truncation visible. Take a $300,000 balance at a 7.0% annual rate, payment amortized across 30 years, with the full remaining balance due at the end of year five — a 30/5 structure.

The monthly rate is 7.0% ÷ 12 = 0.00583333, and n = 360 months. Running the payment formula gives $1,995.91 per month. That is the figure the schedule uses for all sixty rows.

Row one splits as follows: interest of $300,000 × 0.00583333 = $1,750.00, leaving $245.91 of principal, and an ending balance of $299,754.09. Roughly 88 cents of every dollar in that first payment is rent on the money.

Rolling that forward year by year:

Row sixty behaves exactly like the fifty-nine before it: interest of $1,649.32, principal of $346.58, ending balance $282,394.77. Then the schedule appends the maturity line, and the amount due is that same $282,394.77 — in cash, on that date.

Sit with the proportions for a moment. Over five years you paid $119,754.45 in scheduled payments. Of that, $102,149.22 was interest and only $17,605.23 reduced the principal — 5.87% of the original loan. The balance at maturity is 94.13% of what you originally borrowed. And the balloon is 141 times the size of a regular monthly payment, which is why folding it into the final payment column startles people. Counting the sixty payments plus the payoff, the five-year cash requirement is $402,149.22 on a $300,000 loan.

Change one input and the shape changes with it. Push the balloon out to year seven and the payoff falls to $273,442.24; push it to year ten and it is $257,437.15. The direction is intuitive — more payments, smaller leftover — but the magnitude is modest, because in the early years of a 30-year amortization the principal column is barely doing any work. Use the calculator above to substitute your own balance, rate, amortization term, and call date.

Balloon structures are named by the pair of terms that define them. A 30/5 amortizes over 30 years and matures in 5. A 20/5 amortizes over 20 and matures in 5. A 15/5 and a 30/7 follow the same convention. In commercial real estate the shorthand is nearly universal and the shapes are standard: small-balance commercial and multifamily notes very often run 25- or 30-year amortization against a five-, seven-, or ten-year maturity, which is why the balloon schedule is far more familiar to commercial borrowers than to residential ones. On the residential side, federal ability-to-repay rules narrowed the field considerably after 2014, so a consumer-facing balloon today is most often a portfolio, seller-financed, or small-creditor product rather than a mainstream offering.

Here is the same $300,000 at 7.0% run through four different structures, with everything else held constant:

The most instructive column pair is the first and third. A 30/5 balloon and a 30-year fully amortizing loan at the same rate produce identical schedules for sixty rows — identical payment, identical interest, identical principal, identical balance. The tables diverge only because one of them ends. That is worth stating plainly: a balloon does not cost more per month, and it does not build equity any slower. It differs from a conventional fixed-rate loan in exactly one respect, which is that it demands the balance back on a date certain rather than letting the schedule run its course. Every practical difference — every risk, every planning requirement — flows from that one truncation. Our 30-year mortgage amortization schedule page shows what the untruncated version of those same rows looks like when it is allowed to finish.

The 20/5 column shows the lever a borrower can pull if the balloon size worries them. Shortening the amortization term to 20 years raises the payment by $329.99 a month but retires $41,230.12 of principal instead of $17,605.23, cutting the payoff to $258,769.88 — $23,624.89 less to refinance or raise. It is not free, and it does not remove the balloon; it only makes the last row smaller.

An amortization schedule with balloon payment is, functionally, a countdown. The payoff on the bottom line has to be satisfied by one of exactly three things, and it is worth being honest about how each one can fail.

Refinance. The most common plan, and the one that carries the most unexamined assumption. Nothing in a standard balloon note obligates the lender to refinance you, and a new loan is a new underwriting decision made under future conditions: the rate environment on that date, your credit and income at that time, the property's appraised value, and — for investment property — its debt service coverage. In our example the borrower needs roughly $282,395 of new financing against a property that must appraise well enough to support it. If values slipped and the loan-to-value ratio no longer works, the gap is due in cash regardless. Some notes include a conditional reset or extension right, which converts the balance to a new rate rather than demanding payoff — read whether yours does, because it materially changes the risk. Model the replacement loan's own schedule with our refinance amortization calculator before you assume it will be comfortable.

Sale. A clean exit when the timeline is genuinely short and known — a property being repositioned, a bridge situation, a planned relocation. The risk is that sale timing is not fully in your control while the maturity date is fixed. Selling into a slow market on a deadline is a weak negotiating position.

Cash. Rare for a payoff this size, but it is the only option with no counterparty risk. If the plan is partial cash plus a smaller refinance, the earlier the extra principal goes in, the more it compounds in your favor.

If none of the three arrives on time, the loan matures in default, and the lender's remedies — up to and including foreclosure — become available even though every scheduled payment was made on time. The Consumer Financial Protection Bureau's explainer on what a balloon payment is and when it is allowed is the plainest official summary of the consumer protections and disclosure rules that apply here, and it is short enough to read before a closing appointment.

The practical discipline the schedule enables is simple: calendar the maturity date the day you close, and start the refinance or sale conversation twelve to eighteen months ahead rather than sixty days ahead. The table already tells you what the number will be, to the penny, years in advance. There is no version of this loan where the balloon is a surprise — only versions where nobody read row sixty.

Every figure in the amortization schedule with balloon payment above was generated from two standard equations rather than from a rate table or an estimate, so you can reproduce all of them.

The payment comes from the ordinary annuity payment formula, with P as the original balance, r as the annual rate divided by 12, and n as the number of months in the amortization term:

M = P × [ r(1+r)ⁿ ] / [ (1+r)ⁿ − 1 ]

For $300,000 at 7.0% over 360 months, that is $1,995.91. The balloon comes from the remaining-balance formula evaluated at k, the number of months in the maturity term:

Bₖ = P(1+r)ᵏ − M × [ ((1+r)ᵏ − 1) / r ]

At k = 60 that returns $282,394.77, which is identical to what you get by iterating sixty rows of interest-and-principal splits — a useful cross-check when auditing a lender's printout.

Assumptions worth stating: monthly compounding with payments applied on schedule and none early; a fixed rate for the full maturity term; no escrow for taxes or insurance, no mortgage insurance, and no origination or closing costs folded into the balance, all of which raise the real monthly outlay without changing the amortization arithmetic; and rounding to the cent only at display time, with unrounded values carried through intermediate steps, which is why a hand-recomputation may differ by a penny or two. Real notes also vary in day-count and payment-application conventions, and interest-only balloon structures exist in which no principal is retired at all and the payoff equals the original balance exactly.

For the rate context that makes an example realistic, Freddie Mac's Primary Mortgage Market Survey publishes weekly national averages, and the CFPB material linked in the previous section covers the disclosure and ability-to-repay rules that govern when balloon structures may be offered to consumers. If you would rather start from the calculator and work backward to the table, the balloon mortgage amortization calculator page is the calculator-first companion to this one, and every tool on the mortgage amortization calculator homepage runs on the same engine described above. Enter your own balance, rate, amortization term, and call date in the tool at the top of this page, then read the final row first — it is the only one that requires a plan.