Commercial Loan Amortization and a Five-Year Balloon

Separate two different periods in the loan terms

A commercial-property loan can have one period used to calculate regular amortizing payments and a shorter contractual maturity at which the remaining balance becomes due. The amortization period answers how the scheduled payment is sized; the maturity determines when the actual obligation ends. Do not treat a quoted twenty-year amortization and five-year maturity as contradictory. They can describe a loan with smaller regular payments followed by a balloon. This article illustrates that arithmetic and does not apply consumer-mortgage eligibility rules to a commercial transaction.

Calculate the scheduled monthly payment

Assume principal of 1,000,000, a fixed nominal annual rate of 6%, monthly payments and a twenty-year amortization period. The periodic rate is 0.005 and the payment calculation uses 240 months. The formula A=P×i/[1−(1+i)^(-n)] gives approximately 7,164.310585 per month. Enter principal 1000000, annual rate 6 and term 20 in the Loan Amortization Calculator to check that payment. Here the entered term represents the amortization period used for payment sizing, not a claim that the loan contract matures after twenty years.

Find the remaining balance after five years

If contractual maturity follows the sixtieth regular monthly payment, use k=60 in the remaining-balance formula Bk=P×(1+i)^k−A×[((1+i)^k−1)/i]. Under the stated assumptions, the balance immediately after that payment is approximately 848,995.984467, or 848,995.98. That is the additional principal amount due at maturity in this illustration. If a contract combines the final scheduled payment and balloon into one amount, identify whether its quoted balloon includes that scheduled payment. Timing labels prevent adding or subtracting the same last payment twice.

Check the five-year cash-flow totals

Sixty unrounded regular payments total approximately 429,858.635087. The principal repaid through those payments is 1,000,000−848,995.984467=151,004.015533. The remaining approximately 278,854.619554 is interest over those five years under the model. Adding regular payments and the remaining principal gives approximately 1,278,854.62 of total payments through maturity, before excluded charges. These totals are distinct from the tool's displayed total over all 240 months. That twenty-year total assumes the amortization schedule continues for the full period and is not the five-year contract total.

Understand the calculator's display limits

The local amortization tool calculates a fixed-rate schedule and displays its first twelve monthly rows, along with full-amortization totals. It has no separate maturity, balloon, interest-only period, rate-reset or fee field. The sixtieth-payment balance therefore requires the explicit formula or a complete schedule outside the visible first-year table. Entering five years instead of twenty changes the regular payment to a fully amortizing five-year amount; it does not tell the tool to preserve twenty-year payments and add a balloon after five years.

Keep contract-specific costs and repayment conditions separate

Origination costs, servicing charges, prepayment terms and interest conventions can change the actual cash flows. Some loans calculate interest using daily counts or a basis other than the nominal annual rate divided by twelve. Others have floating rates or periods during which only interest is paid. The example includes none of those features. Use the loan documents to establish the correct schedule before adapting the formula. A calculation of debt service also does not determine the property's operating income, debt-service coverage, value or eligibility for financing.

Treat refinancing as a separate scenario

A large remaining balance does not establish that refinancing will be available on acceptable terms at maturity. To examine that possibility, first calculate the actual maturity balance, then model a new loan with its own rate, term and costs. Do not erase the balloon from a cash-flow plan merely because refinancing is intended. Preserve the principal, amortization period, maturity date, payment timing and rate convention with the result. The arithmetic identifies the modeled obligation at the stated date; it does not forecast future financing conditions or property-sale proceeds.

Related guides

Loan Balance Formula After a Stated Number of Payments

Calculate the remaining balance after k equal payments, verify it against a schedule, and distinguish principal balance from a dated payoff quote.

Balloon Loan Formula and Remaining Balance

Calculate a balloon payment from principal, rate and regular payments, then distinguish the maturity date from the amortization schedule.

Estimate Business Loan Capacity from Payment Cash Flow

Estimate a loan principal from an affordable payment, compare term and rate scenarios, and distinguish repayment arithmetic from lender approval.