Debt Yield Calculator

Commercial Mortgage Payment Calculator

Estimate monthly payment, annual debt service, loan constant, and term payments for a commercial mortgage.

Last updated:

  • US DollarUSD ($)
  • EuroEUR (€)
  • British PoundGBP (£)
  • Canadian DollarCAD (CA$)
  • Australian DollarAUD (A$)
  • Indian RupeeINR (₹)
  • Pakistani RupeePKR (Rs)
  • Japanese YenJPY (¥)

Current or proposed commercial mortgage balance.

Use the lender's underwriting rate, not only the quoted coupon.

  • 15 years
  • 20 years
  • 25 years
  • 30 years

The schedule used to size annual debt service.

  • 5 years
  • 7 years
  • 10 years
  • 15 years
  • 30 years

Used to estimate total payments during the loan term.

  • None
  • 1 year
  • 2 years
  • 3 years
  • 4 years
  • 5 years

Years of interest-only payments before amortization begins.

Workflow

How it works

Follow the underwriting path lenders use: input the deal, apply constraints, then read the result.

Step 1

Enter loan amount

Start with the commercial mortgage balance or proposed loan proceeds.

Commercial Mortgage Payment Formula

Commercial mortgage payments are based on loan amount, interest rate, and amortization. The annual payment divided by loan amount is the loan constant. Learn how the loan constant works before comparing payment coverage.

Read the calculation methodology and limitations.

Monthly Payment = P x [r(1+r)^n] / [(1+r)^n - 1]
Loan Constant = Annual Debt Service / Loan Amount
Example

A $10,000,000 loan at 6.50% over 30 years produces annual debt service based on the same amortization math lenders use for DSCR sizing.

⚡ UNDERWRITING BENCHMARKS

See This Calculator in Action

Explore institutional underwriting examples. Load any scenario into the live calculator with one click to customize rates, amortization, and property valuation.

Common commercial mortgage structure

10-year term, 30-year amortization

Requested Senior Debt
$10,000,000Proposed loan financing balance
Interest Rate
6.50%Annual interest rate
Amortization Period
30 yearsPrincipal amortization schedule
Term
10 yearsYears until the balloon is due
SIZING OUTCOMEUnderwriting Benchmark
Monthly payment estimate
Calculated result
Underwriting Math Formula
Monthly Payment = P x [r(1+r)^n] / [(1+r)^n - 1]
💡
Institutional Takeaway

The payment estimate drives annual debt service, which becomes the denominator in DSCR.

Tip: Click “Load into Calculator ↑” to test custom interest rates & property value sizing tests.
LENDER REFERENCE MATRIX

Underwriting Metric Comparison & Lender Sizing Standards

Compare debt yield against DSCR and LTV constraints, and review typical sizing assumptions across lender types.

Payment Inputs and DSCR Impact

3 Core Sizing Tests
Higher rate
Increases debt service

Lowers DSCR

Longer amortization
Lowers debt service

Raises DSCR

Lower loan amount
Lowers debt service

Raises DSCR

Payment Inputs and DSCR Impact
ChangePayment EffectDSCR Effect
Higher rateIncreases debt serviceLowers DSCR
Longer amortizationLowers debt serviceRaises DSCR
Lower loan amountLowers debt serviceRaises DSCR

Worked examples

Sample scenarios and their calculated results
ScenarioCalculationResult
Permanent loan$10,000,000 at 6.50% / 30 yearsMonthly payment and loan constant output
Higher rate stress$10,000,000 at 7.50% / 30 yearsHigher annual debt service and lower DSCR
Shorter amortization$10,000,000 at 6.50% / 25 yearsHigher payment than 30-year amortization

Conversion reference

How payment inputs affect CRE underwriting.
InputEffectMetric Impact
Higher rateRaises paymentLowers DSCR
Shorter amortizationRaises paymentLowers DSCR
Lower loan amountLowers paymentRaises DSCR
Higher NOINo payment changeRaises DSCR

Quick facts

  • Annual debt service is the denominator in DSCR.
  • Loan constant converts loan balance into annual payment percentage.
  • Commercial loan term and amortization are not always the same.
  • Payment estimates are screening outputs, not lender quotes.

Editorial Team

Commercial Real Estate Finance Reviewers

  • Calculations reviewed against standard CRE lending formulas for DSCR, LTV, cap rate, and debt yield
  • Methodology cross-checked against lender-style loan sizing using NOI, value, loan constant, DSCR, LTV, and debt yield

Our editorial team builds and reviews commercial real estate finance calculators around the way lenders actually size debt: property income, collateral value, annual debt service, and lender risk thresholds. Results are educational screening estimates, not loan quotes, tax advice, legal advice, or a commitment to lend.

Methodology: formulas are calculated from borrower-entered inputs using standard CRE underwriting relationships for NOI, debt yield, DSCR, LTV, cap rate, loan constant, and maximum loan proceeds.

Reviewer note: pages are reviewed for formula accuracy and updated when lender benchmarks or site methodology changes.

Disclaimer: results are educational estimates only and are not financial, legal, tax, valuation, or lending advice.

Frequently asked questions