Commercial Mortgage Calculator

Most commercial real estate loans are amortized over 20 to 30 years but come due in 5, 7 or 10 years, when the remaining balance is paid in one balloon payment. Enter the property value, loan amount, rate, amortization period and term to see the monthly payment, the balloon, the loan-to-value ratio, the debt service coverage ratio lenders check, and the APR including the origination fee.

$
Purchase price or appraised value. Used for the loan-to-value ratio.
$
%
The schedule the payment is based on.
When the remaining balance is due in one payment.
%
Points as a percent of the loan amount.
$
Appraisal, environmental report, legal and other lender fees.
$
Rents and other income minus operating expenses, before debt payments. Enter 0 to skip DSCR.
Monthly payment$9,894.9125-year amortization, 120 payments before the balloon
Balloon payment due at year 10
$1,100,867.33
Loan-to-value (LTV)
70.00%
Debt service coverage (DSCR)
1.26
Yearly debt service
$118,738.92
APR over the term (includes fees)
7.15%
Fees and closing costs
$14,000.00
Interest paid over 10 years
$888,256.53
Total of payments, including the balloon
$2,288,256.53

The payment is based on a 25-year schedule, but the loan is due after 10 years. Plan to repay the 79% of the loan still owed by refinancing, selling the property or paying cash. Prepayment penalties or yield maintenance can apply before then.

Balance over time
$0.0$700.0K$1.4MStart5 years10 years

The balance starts at $1,400,000; after 10 years, $1,100,867 is still owed and due as a balloon payment.

Amortization schedule
YearPaymentPrincipalInterestBalance
1$118,738.92$21,417.38$97,321.54$1,378,582.62
2$118,738.92$22,965.67$95,773.25$1,355,616.95
3$118,738.92$24,625.86$94,113.06$1,330,991.09
4$118,738.92$26,406.07$92,332.85$1,304,585.02
5$118,738.92$28,314.96$90,423.96$1,276,270.06
6$118,738.92$30,361.86$88,377.06$1,245,908.20
7$118,738.92$32,556.72$86,182.20$1,213,351.48
8$118,738.92$34,910.23$83,828.69$1,178,441.25
9$118,738.92$37,433.91$81,305.01$1,141,007.34
10$1,219,606.25$1,141,007.34$78,598.91$0.00

How the payment and balloon are calculated

Payment = loan amount × r ÷ (1 − (1 + r)−n), where r = annual rate ÷ 12 and n = 12 × amortization years

Balloon = loan balance after 12 × term years of payments

LTV = loan amount ÷ property value  ·  DSCR = net operating income ÷ (12 × payment)

The APR is the yearly rate at which the monthly payments and the balloon repay the loan amount minus points and closing costs. Payments are rounded to the cent and interest is rounded each month.

Example

A $1,400,000 loan on a $2,000,000 property (70% LTV) at 7%, amortized over 25 years with a 10-year term, costs $9,894.91 a month. After 120 payments a balloon of $1,100,867.33 is due, about 79% of the original loan. Interest over the 10 years totals $888,256.53. With a 1% origination fee ($14,000) the APR is 7.15%. Yearly debt service is $118,738.92, so $150,000 of net operating income gives a DSCR of 1.26.

With a 5-year term the payment is the same but the balloon is $1,276,270.06 and the APR is 7.25%, because the fee is spread over fewer years. Amortizing over 30 years instead lowers the payment to $9,314.23 and raises the DSCR to 1.34, but leaves a larger balloon of $1,201,374.31 at year 10. Borrowing $1,600,000 (80% LTV) costs $11,308.47 a month and drops the DSCR to 1.11, below what most lenders accept.

What commercial lenders look at

Loan-to-value. Commercial lenders usually lend up to 65–75% of the property's value, so expect a down payment of 25–35%. Debt service coverage. The property's net operating income (rents and other income minus operating expenses such as taxes, insurance, repairs and management, before loan payments) should cover the yearly payments with room to spare; a DSCR of 1.20–1.25 is a common minimum. Balloon risk. When the term ends you must refinance, sell or pay the balance in cash, at whatever rates and property values exist then. Many commercial loans also charge a prepayment penalty, defeasance or yield maintenance if you pay off early, so read the loan terms before planning an early refinance. Rate. Fixed commercial mortgage rates are usually quoted as a spread over the Treasury yield for a similar term, such as the 10-year Treasury for a 10-year loan. The Federal Reserve publishes those yields each business day in its H.15 release, so you can see how the benchmark under a quote has moved.

Worked scenario: refinancing the balloon in year 10

Take the example loan: $1,400,000 at 7%, 25-year amortization, 10-year term. In year 10 the $1,100,867.33 balloon has to be refinanced. What that takes depends less on today's rate than on the property's value, its income and rates then.

If the property holds up. Suppose rates are 2 points higher (9%), the property is still worth $2,000,000 and net operating income is still $150,000. A new 25-year loan for the balloon costs $9,238.44 a month, less than today's payment because the balance is smaller. LTV is 55% and DSCR is 1.35, so it passes both tests comfortably.

If income and value slip. Now suppose net operating income falls to $120,000 and the property appraises at $1,400,000. At 9% the same refinance has a DSCR of 1.08 and an LTV of 78.6%, so it fails both. Most lenders size the new loan by whichever test binds first. Here that's DSCR: at 1.25 the most you could borrow over 25 years is about $953,000 ($7,997.54 a month, 68% LTV). That leaves about $147,867 of the balloon to pay in cash, plus the new loan's closing costs. A 30-year amortization raises the loan to about $994,000 ($7,997.95 a month, 71% LTV), but that still leaves about $106,867 to cover.

To test your own loan, run the calculator a second time with the balloon as the loan amount, a higher rate and a lower value and income. If the refinance only works when nothing changes, plan for a cash reserve, a lower starting LTV or a longer term.

Points or no points?

Lenders often offer a lower rate for an upfront fee. On the $1,400,000 loan, 7% with a 1% fee ($14,000) costs $9,894.91 a month. A no-fee loan at 7.25% costs $10,119.30, which is $224.39 more. If you keep the loan for the full 10 years, paying the point saves $20,581.89 (payments, balloon and fee combined) and the APR is 7.15% vs. 7.25%. Over a 5-year term the saving shrinks to $3,507.26 and the APRs are nearly equal. Selling or refinancing early cuts the saving further, and a prepayment penalty can wipe it out. The higher payment matters too: at 7.25% the DSCR falls from 1.26 to 1.24, below the 1.25 many lenders want, so the no-fee loan might have to be smaller.

What this calculator does and doesn't model

Common mistakes

Frequently asked questions

What is a balloon payment on a commercial mortgage?

It is the remaining loan balance, due in one payment when the loan term ends. The monthly payment is figured as if the loan ran for the full amortization period (often 25 years), but the loan matures sooner (often 5, 7 or 10 years), so most of the principal is still owed at maturity.

What is the difference between the term and the amortization period?

The amortization period sets the size of the payment; the term is when the loan is due. A 10/25 loan has a 10-year term and a 25-year amortization. If the term equals the amortization period, the loan pays off fully and there is no balloon.

What DSCR do lenders require?

Many commercial lenders want a debt service coverage ratio of at least 1.20 to 1.25, meaning net operating income is 20–25% more than the yearly loan payments. Requirements vary by lender and property type. A DSCR below 1.0 means the property does not earn enough to make the payments.

Why is the APR higher with a shorter term?

Points and closing costs are paid once. On a 5-year loan they are spread over 5 years instead of 10, so they add more to the yearly cost. The APR here assumes you pay the balloon when it is due rather than refinancing.

What happens if I can't refinance the balloon?

You would have to pay the difference in cash, sell the property, or negotiate an extension with the lender, often for a fee and at a higher rate. If the balloon goes unpaid at maturity, the loan is in default. Run the calculator on the balloon amount with a higher rate and lower income to see how much a refinance could raise.

How do lenders decide how much to lend on a refinance?

They usually figure the largest loan allowed by each test (LTV on the new appraisal, DSCR on current net operating income at the new rate, sometimes a debt yield) and lend the smallest of them. If income has fallen, DSCR usually binds first.

Are commercial mortgages covered by Truth in Lending?

Loans primarily for business or commercial purposes are generally exempt from Regulation Z, so there is no required APR or Loan Estimate. Ask each lender for the rate, every fee, the amortization, the term, the prepayment terms and the balloon amount so you can compare them here.

Sources

Last reviewed . How we review and test pages.

PmtCalc provides estimates for education and planning only. Results are not an offer of credit, a loan approval, or financial, tax or legal advice. Actual terms depend on the lender and your situation. How we calculate and test these results.