Commercial Mortgage Calculator
Test cases replayed : 2 of 2 match · Methodology · No outside source listed
A commercial loan can be paid as if spread over a long amortization period but come due sooner, with a balloon. Enter the loan, rate, amortization and term to see the monthly payment, the balloon and the ratios lenders check.
Result
- Balloon balance due at the end of the term ($)
- Loan-to-value ratio (%)
- Debt service coverage ratio, NOI ÷ debt service (×)
- Debt yield, NOI ÷ loan (%)
- Interest paid during the term ($)
Estimate for planning only, not tax, legal, financial or medical advice. This calculator uses the method explained on this page.
This browser did not allow copying. The sentence is in the box below, already selected: copy it with your keyboard or the menu.
How to use this calculator
Fill in the fields in this order; each step takes you to its field.
- Property value or purchase price, in dollars: enter 1 or more.
- Loan amount, in dollars: enter 0 or more.
- Interest rate, in % / year: enter a number from 0 to 30.
- Amortization period, in years: enter a number from 1 to 40.
- Loan term until the balloon, in years: enter a number from 1 to 40.
- Net operating income of the property, in dollars / year: enter 0 or more.
- Read the result: Monthly payment, principal and interest; the panel also shows Annual debt service ($ per year), Balloon balance due at the end of the term ($), Loan-to-value ratio (%), Debt service coverage ratio, NOI ÷ debt service (×), Debt yield, NOI ÷ loan (%) and Interest paid during the term ($).
How this calculator works
Payment = L × i × (1 + i)ⁿ ÷ ((1 + i)ⁿ − 1), the level-payment amortization formula, with L the loan, i the annual rate ÷ 12 and n the amortization period in months.
Balloon = balance left after the k monthly payments of the term = L × (1 + i)ᵏ − payment × ((1 + i)ᵏ − 1) ÷ i. When the term equals the amortization period, the balance is zero.
LTV = loan ÷ value. DSCR = net operating income ÷ annual debt service. Debt yield = net operating income ÷ loan. Each lender sets its own maximum LTV and minimum DSCR in the term sheet.
Monthly compounding with a 30/360 schedule is assumed. Loans that accrue interest on an actual/360 basis, interest-only periods, fees and prepayment penalties (defeasance, yield maintenance) change the figures; your loan documents govern.
The formula
| Symbol | Meaning | Unit |
|---|---|---|
| Loan amount | $ | |
| Interest rate | % / year | |
| Amortization period | years | |
| Result of step 1 | ||
| Result of step 2 | ||
| Monthly payment, principal and interest | $ | |
pmt(P, r, n) | the payment per period that repays P over n periods at rate r per period, or P ÷ n when r is zero. |
Worked example
| Property value or purchase price | $2,000,000 |
|---|---|
| Loan amount | $1,400,000 |
| Interest rate | 7 % / year |
| Amortization period | 25 years |
| Loan term until the balloon | 10 years |
| Net operating income of the property | $160,000 / year |
| Annual debt service ($ per year) | $118,738.91 |
|---|---|
| Balloon balance due at the end of the term ($) | $1,100,867.55 |
| Loan-to-value ratio (%) | 70% |
| Debt service coverage ratio, NOI ÷ debt service (×) | 1.35 |
| Debt yield, NOI ÷ loan (%) | 11.43% |
| Interest paid during the term ($) | $888,256.60 |
Monthly payment, principal and interest $9,894.91
Each step uses the unrounded value of the step before it; figures on this page are rounded for display.
Frequently asked questions
What is a balloon payment?
The lump sum still owed when the loan term ends before the amortization period does. It is usually refinanced or paid from a sale.
What DSCR do lenders look for?
It varies by lender, property type and loan program; ask for the minimum in the term sheet. A DSCR below 1 means the property's income does not cover the payments.
Is NOI before or after debt service?
Before. Net operating income is rental income minus operating expenses, without the mortgage payment or income taxes.