Software
SBA
Guides

Industry Guides

CPA Firm GuideDental Practice Guide409A Valuation GuideHVAC GuideLegal Firm GuideManufacturing GuideMedical Practice GuideOptometry GuideOrthodontist GuidePlumbing GuideVeterinary Guide

Financing Guides

A/R Aging Report Guide1031 Exchange GuideLOC GuideSBA 7(a) GuideSBA 504 GuideSection 179 Guide
Articles

Selling a Business

Setting an Asking PriceUsing a Business BrokerSelling a Business During DivorceSelling a Failing BusinessTransferring Intellectual PropertyPreparing an Online Business for SalePreparing for Sale, Two Years OutSelling a Business QuicklyWriting a Selling MemorandumSelling a Business Step by StepSelling a Business With DebtChanges Worth Making Before Selling

Valuation

What Is Enterprise ValueSeller's Discretionary EarningsValuing a Business Accurately

Buying & Financing

Financing an AcquisitionWriting a Financial Plan

Modelling & Operations

Building a Business ModelRisk Management for a Small Business
Templates

Business Templates

Client Service AgreementIndependent Contractor AgreementNon-Disclosure Agreement (NDA)LLC Operating AgreementEmployment AgreementProfessional Invoice TemplateBusiness Loan AgreementBuy-Sell AgreementLetter of Intent (LOI)Partnership Agreement
Sign in
Commercial Mortgage Calculator
Discount Rate →1031 Exchange →
Calculator
Commercial Real Estate Finance

Every metric a CRE lender
will ask for, computed.

A commercial mortgage is underwritten on a different set of metrics than a residential loan. Set the property income once, then model three loan structures side by side — each with its own LTV, rate, term and amortization — and compare them on the figures a credit committee actually tests.

✓NOI and cap rate — shared across all three structures, so the comparison isolates the financing rather than the asset.
✓DSCR and debt yield — coverage computed against NOI and flagged against the 1.25× minimum, with debt yield alongside since many lenders size on it instead.
✓LTV, balloon and true cost — interest-only and amortizing structures, with the balloon at maturity carried into total cost rather than left out of it.
✓Break-even occupancy — operating expenses plus debt service against gross potential rent — how empty the building can get before it stops covering itself.
DSCRLTVDebt yieldCap rateBalloonAmortizationIO period
What lenders test
1.25×Minimum DSCR
65–75%Typical LTV
9–11%Debt yield floor
3Structures compared
Sized on whichever binds first
LTVLoan capped as a share of appraised value
DSCRPayment capped by the income the property produces
YieldLoan capped so NOI clears the lender's debt yield

Property value

$5.00M

$500K$50M

Annual NOI

$280K

$10K$3M

Vacancy rate

5%

0%40%

Cap rate

5.60%

NOI ÷ value

Implied gross rent

$295K

NOI ÷ (1 − vacancy) · not EGI

Property type

Tranche A
★ Best
Loan type
Loan-to-Value (LTV)65% · $3.25M
30%90%
Interest rate6.50%
2%18%
Loan term10 yr
1 yr30 yr
Amortization

Capital Stack

Equity 35%
Debt 65% LTV
0%50%100%
DSCR1.14×
⚠ Below preferred 1.25× threshold — renegotiate terms

Loan Summary

Loan amount$3.25M
Equity required$1.75M
Monthly payment$20,542
Annual debt service$246,507
Total interest cost$1.97M
Balloon at maturity$2.76M
Debt yield8.62%
Break-even occupancy88.0%
Tranche B
Loan type
Loan-to-Value (LTV)75% · $3.75M
30%90%
Interest rate8.50%
2%18%
Loan term5 yr
1 yr30 yr
Amortization

Capital Stack

Equity 25%
Debt 75% LTV
0%50%100%
DSCR0.88×
✗ Cash flow negative — debt service exceeds NOI

Loan Summary

Loan amount$3.75M
Equity required$1.25M
Monthly payment$26,563
Annual debt service$318,750
Total interest cost$1.59M
Balloon at maturity$3.75M
Debt yield7.47%
Break-even occupancy99.0%
Tranche C
Loan type
Loan-to-Value (LTV)80% · $4.00M
30%90%
Interest rate9.25%
2%18%
Loan term3 yr
1 yr30 yr
Amortization

Capital Stack

Equity 20%
Debt 80% LTV
0%50%100%
DSCR0.71×
✗ Cash flow negative — debt service exceeds NOI

Loan Summary

Loan amount$4.00M
Equity required$1.00M
Monthly payment$32,907
Annual debt service$394,884
Total interest cost$1.10M
Balloon at maturity$3.91M
Debt yield7.00%
Break-even occupancy99.0%