Illustrative scenarios

Nine deals that never happened

Commercial lenders announce closings on tombstones. This one has none, so these are worked examples instead — chosen so that each shows a different constraint doing the binding. The arithmetic balances; the transactions are invented.

None of these transactions occurred. No sponsor, address, lender, broker or closing date appears on this page, because there isn't one. The figures are internally consistent arithmetic, nothing more.

S-01 — illustrativeMultifamily

112-unit garden acquisition

$12,190,000

Purpose
Acquisition
Property
112 units
Market
Charlotte submarket
Value or cost
$18,400,000
Underwritten NOI
$1,104,000
Rate
6.35%
Amortisation
30 yr
Term
10 yr, 2 yr IO
Annual debt service
$910,206
LTV / LTC
66.3%
DSCR
1.21×
Debt yield
9.06%

DSCR is the binding test

At a 1.25× floor the coverage test caps the loan at 66.2% LTV — below the 70% the LTV test would have allowed. Two years of interest-only lifts early cash flow without changing the sizing, because the coverage test was run on the amortising constant.

Multifamily programme

S-02 — illustrativeRetail

Unanchored neighbourhood strip

$4,960,000

Purpose
Refinance
Property
31,400 SF, 9 tenants
Market
Piedmont Triad
Value or cost
$6,200,000
Underwritten NOI
$496,000
Rate
6.85%
Amortisation
25 yr
Term
7 yr
Annual debt service
$414,997
LTV / LTC
80.0%
DSCR
1.20×
Debt yield
10.00%

Debt yield is the binding test

A 10% debt yield floor sets the loan at exactly ten times NOI. LTV would have permitted 70% and coverage 1.30× would have permitted more still; the floor is what binds, and it binds first.

Retail & mixed-use programme

S-03 — illustrativeIndustrial

Single-tenant distribution, 11 years remaining

$8,260,000

Purpose
Acquisition
Property
104,000 SF, 32ft clear
Market
Upstate South Carolina
Value or cost
$11,800,000
Underwritten NOI
$767,000
Rate
6.10%
Amortisation
25 yr
Term
10 yr, 1 yr IO
Annual debt service
$644,704
LTV / LTC
70.0%
DSCR
1.19×
Debt yield
9.29%

LTV is the binding test

Lease term running eleven years past a ten-year maturity is what allows LTV to be the binding constraint. Coverage lands at 1.34× and debt yield at 9.3%, both clear of their floors.

Industrial & flex programme

S-04 — illustrativeOffice

Medical office, three practices

$4,933,000

Purpose
Refinance
Property
24,600 SF
Market
Raleigh suburban
Value or cost
$7,400,000
Underwritten NOI
$592,000
Rate
7.15%
Amortisation
25 yr
Term
5 yr
Annual debt service
$424,066
LTV / LTC
66.7%
DSCR
1.40×
Debt yield
12.00%

Debt yield is the binding test

A 12% debt yield floor holds the loan to 66.7% of value even though the coverage test would have supported more. This is the single clearest illustration of why office leverage sits where it does.

Office & medical programme

S-05 — illustrativeMultifamily

68-unit value-add, 24-month plan

$6,360,000

Purpose
Bridge
Property
68 units, 54 to renovate
Market
Knoxville
Value or cost
$7,950,000
Underwritten NOI
$318,000
Rate
9.25%
Amortisation
interest-only
Term
2 yr, 2 yr IO
Annual debt service
$588,300
LTV / LTC
80.0%
DSCR
0.54×
Debt yield
5.00%

Loan-to-cost is the binding test

80% of a $7.95M total cost including a $1.35M capital budget. Interest is reserved for the full term plus one six-month extension. The exit test at a 5.75% cap and a 1.25× floor retires the bridge with roughly $900K to spare.

Bridge & value-add programme

S-06 — illustrativeConstruction

Ground-up flex, two buildings

$6,720,000

Purpose
Construction
Property
48,000 SF across two buildings
Market
Greenville
Value or cost
$9,600,000
Underwritten NOI
$720,000
Rate
8.40%
Amortisation
interest-only
Term
2 yr, 2 yr IO
Annual debt service
$564,480
LTV / LTC
70.0%
DSCR
1.28×
Debt yield
10.71%

Loan-to-cost is the binding test

70% of an $9.6M budget carrying 7% contingency on hard cost. Interest accrues only on drawn funds; on an S-curve draw the capitalised interest lands near $340K against a face amount ten times that.

Ground-up construction programme

S-07 — illustrativeOwner-occupied

SBA 504 for a fabrication shop

$3,690,000

Purpose
Owner-occupied acquisition
Property
31,000 SF, 78% occupied by the business
Market
Richmond
Value or cost
$4,100,000
Underwritten NOI
n/a — owner-occupied
Rate
6.90%
Amortisation
25 yr
Term
10 yr
Annual debt service
$310,143
LTV / LTC
90.0%
DSCR
Debt yield

DSCR is the binding test

Sized on business cash flow, not rent — NOI is shown as zero because the operating company occupies 78% and pays no rent to itself. A 50/40/10 structure puts $410K of injection against a $4.1M project.

SBA 504 & 7(a) programme

S-08 — illustrativeSelf-storage

Two-site storage portfolio

$4,792,000

Purpose
Refinance
Property
742 units across two sites
Market
Coastal Carolina
Value or cost
$8,900,000
Underwritten NOI
$623,000
Rate
6.95%
Amortisation
25 yr
Term
7 yr
Annual debt service
$404,594
LTV / LTC
53.8%
DSCR
1.54×
Debt yield
13.00%

Debt yield is the binding test

A 13% floor holds this to 53.8% LTV. Storage income reprices monthly, and the floor exists precisely because it can.

Specialty assets programme

S-09 — illustrativeMixed-use

Ground-floor retail beneath 22 apartments

$3,640,000

Purpose
Acquisition
Property
22 units + 6,800 SF retail
Market
Asheville
Value or cost
$5,600,000
Underwritten NOI
$364,000
Rate
6.60%
Amortisation
30 yr
Term
7 yr, 1 yr IO
Annual debt service
$278,966
LTV / LTC
65.0%
DSCR
1.30×
Debt yield
10.00%

Debt yield is the binding test

Blended assets get blended floors. The residential income supports a 8.5% floor and the retail a 10%; weighted by NOI the file underwrites at 10% and sizes at ten times income.

Retail & mixed-use programme

Run one of these yourself

Type any of the figures above into the sizing calculator and the same binding constraint falls out. That is the only claim this page makes.

Loan sizing Bridge exit test Construction draw