Free tool

The payment, and the day the loan comes due

Commercial loans amortize on one schedule and mature on another: a 25-year payment, due in full at year ten. Enter the loan, the rate, the amortization and the term — the monthly payment, the balloon at maturity and the loan constant recompute as you type.

The loan

$
%
yrs
yrs
Monthly payment
Balloon at maturity
Interest paid by maturity
Loan constant

How a commercial mortgage differs from the one on your house

A residential loan amortizes to zero over its own life; a commercial one usually does not. The lender prices the payment on a long schedule — twenty or twenty-five years — but ends the loan on a short one, commonly five, seven or ten. The result is the "25 due in 10": a payment sized as if the loan ran a quarter century, and a maturity in year ten at which the entire remaining balance — the balloon — comes due at once. On the default above, that is a $7,068 payment for 120 months and then roughly $786,000 due on month 121. Nobody plans to write that check; the plan is to refinance into the next loan, and the balloon is the size of that bet.

How the numbers are computed

The payment is the standard level-payment formula on the amortization period: payment = P·r(1+r)ⁿ ⁄ ((1+r)ⁿ−1), with P the loan, r the monthly rate and n the amortization in months. The balance then walks forward month by month — each payment's interest is the rate on what is still owed, the rest retires principal — and the balloon is simply the balance standing when the term ends. Interest paid by maturity totals the interest portion of every payment made to that point. Set the term equal to the amortization and the balloon collapses to zero: a fully-amortizing loan, the higher-payment-no-maturity-risk end of the same trade.

The loan constant, and why underwriters quote it

The fourth figure — annual debt service divided by the loan amount — is the loan constant, and it is the debt's true carrying cost with rate and amortization collapsed into one number. It is built to compare against the cap rate: buy at a 6.5% cap with money at an 8.5% constant and every borrowed dollar consumes more cash than it produces, whatever the interest rate alone implies. Positive leverage begins where the cap rate clears the constant. The constant also exposes what amortization does to cash flow — the same 7% money costs about 8.5% a year to carry on a 25-year schedule and about 9.3% on a 20 — which is exactly the trade a term sheet is asking you to price.

Common mistakes

The expensive ones cluster at the maturity. Treating the balloon as a formality assumes year-ten rates, values and coverage requirements cooperate; 2022–23 taught a generation of owners that they sometimes do not, and a DSCR that clears today's test can fail the refinance's. Assuming a 30-year amortization because the house loan had one overstates cash flow on day one. Comparing loans by interest rate alone hides what a shorter amortization does to the payment — the constant is the honest comparison. And after closing, the schedule is only as true as the records: rate resets, recasts and the refinance itself all move the balance, which is what a proper loan history keeps straight.

The balloon is one loan's cliff; a lender sizing the refinance will read your whole position. The free Schedule of Real Estate Owned generator assembles it — every property, balance and payment — in the format the application asks for.

Questions people ask

Why do commercial loans have balloon payments?
Lenders will price a payment over 25 years but not the risk of one rate for 25 years, so the loan amortizes on the long schedule and matures on a short one — commonly five, seven or ten years. At maturity the remaining balance comes due at once: the balloon. In practice it is refinanced rather than paid, which is exactly the risk to plan for — you will be re-qualifying at whatever rates, values and coverage ratios exist that year, not this one.
What is the difference between the amortization period and the term?
The amortization period sets the payment — the years over which the balance would reach zero at that payment. The term is when the loan actually ends. A "25 due in 10" pays like a 25-year loan and stops in year ten with the balance still owed. The longer the amortization relative to the term, the lower the payment and the larger the balloon; matching the two (a fully-amortizing loan) trades a higher payment for no maturity risk at all.
What is a loan constant and why do lenders use it?
Annual debt service divided by the loan amount — the all-in cost of carrying the debt, principal and interest together, as a percentage. It compares directly against the cap rate: a property bought at a 6.5% cap with money at an 8.5% constant loses cash on every borrowed dollar, whatever the interest rate alone suggests. Underwriters quote it because it collapses rate and amortization into the one number cash flow actually feels.

Loans that keep their own history

Prism computes this automatically for every asset you own — residential, commercial, or business. Record the real terms once and the balance, the payment and the maturity stay tracked through every refinance and rate change.