Commercial Mortgage Payment Formula

The commercial mortgage payment formula is the mathematical engine behind every loan amortization schedule. Whether you're evaluating an office building, retail center, or multifamily property, understanding this formula allows you to calculate your monthly payment precisely. The formula is derived from the present value of an annuity and has been used by lenders for centuries. Let's break it down.

The Formula

The standard monthly payment for a fully amortizing commercial mortgage is calculated using the following formula:

Where:

• M = monthly payment
• P = loan principal (property purchase price minus down payment)
• r = monthly interest rate (annual interest rate divided by 12)
• n = total number of monthly payments (amortization period in years × 12)

For example, if you have a $1,000,000 loan at 6% annual interest with a 20-year amortization period, then P = $1,000,000, r = 0.06/12 = 0.005, and n = 20 × 12 = 240. Plugging into the formula gives a monthly payment of about $7,164.31.

Why the Formula Works: Intuition and Origin

The formula computes a payment that, at the monthly interest rate, exactly pays off both the interest accrued each month and the principal over the loan term. Each month, part of your payment covers the interest on the remaining balance, and the rest reduces the principal. As the principal declines, the interest portion shrinks, allowing more of the payment to go toward principal. This is why the formula includes compounding — the (1 + r)^n term represents the growth of the loan if no payments were made.

The formula has its roots in actuarial mathematics and has been used since the 18th century for mortgages, annuities, and bonds. It's a variant of the present value of an annuity formula, which calculates how much a series of future payments is worth today. By rearranging it, we find the payment that makes the present value equal to the loan amount.

Practical Implications for Real Estate Investors

Understanding the formula helps you see how changes in loan terms affect your payment. For example:

• Interest rate: A 1% increase in annual rate raises r by about 0.000833, which can increase M by hundreds of dollars.
• Amortization period: A longer amortization (e.g., 30 years instead of 20) lowers monthly payments but increases total interest paid over time.
• Loan amount: Larger down payments reduce P directly, lowering M.

Investors use the payment to evaluate debt service coverage ratio (DSCR) — the ratio of net operating income to total debt payments. A DSCR above 1.25 is typically required by lenders. The commercial mortgage calculator on this site automatically computes DSCR and other key metrics. If you're new to commercial mortgages, see our guide on what is a commercial mortgage.

For a step-by-step walkthrough of using the formula in practice, visit how to calculate commercial mortgage payments. And to interpret what your calculated payment means for your investment, check commercial mortgage payment ranges.

Edge Cases and Variations

The standard formula assumes a fixed interest rate and a fully amortizing loan (where the loan balance reaches zero at the end of the term). However, many commercial loans have features that alter this:

• Interest-only loans: For a specified period, payments cover only interest, so the formula above gives a different result. The payment is simply P × r (monthly interest only).
• Balloon payments: If the loan term is shorter than the amortization period (e.g., a 10-year term with 25-year amortization), the final payment includes a large principal balance. The standard formula still gives the monthly payment, but a separate calculation is needed for the balloon amount.
• Adjustable-rate mortgages (ARMs): The interest rate changes periodically, so the formula must be reapplied with new rates at each adjustment date.
• Negative amortization: If the payment is less than the interest due (e.g., in some option ARMs), the principal grows. This requires a modified formula.

The commercial mortgage calculator supports most of these scenarios. For example, it allows you to set different loan terms and amortization periods to account for balloon payments. Understanding the underlying math empowers you to make informed decisions and avoid surprises.