Market Data
Calculators/Loan Payment Calculator
Lending

Loan Payment Calculator

Calculate monthly loan payments, total interest, and amortization details for commercial real estate loans.

$

Principal loan amount

%

Annual interest rate

yrs

Loan term in years

Download Excel Version
Use this calculator offline in Excel with full formulas
.XLSX
Formula
M = P[r(1+r)^n]/[(1+r)^n-1]
Pro Tips
1.The payment is principal and interest on the amount, rate, and term you enter.
2.Taxes and insurance are not included.
Related Calculators
DSCR Calculator→LTV Calculator→Amortization Schedule→

Commercial Loan Payments Explained

The payment is principal and interest on the amount, rate, and term you enter. If the term is shorter than the amortization, principal remains at the end. This page does not publish typical loan-to-value ratios or rate ranges.

Pair the payment with the DSCR calculator if you want NOI divided by that annual debt service. The DSCR page does not label the result pass or fail.

Frequently Asked Questions

What is a typical commercial loan rate for NNN properties?

This page does not publish a rate range. Enter the rate from the quote you are testing.

How much down payment is needed for a commercial property?

This page does not quote a down-payment rule. The loan-to-value calculator uses the loan amount and value you enter.

What is a balloon payment in commercial real estate?

If the loan term is shorter than the amortization, the unpaid principal at the end of the term is the balloon. Enter both numbers to see the payment; the remaining balance is not a figure this page invents.

ScoreOM