CAPITAL MARKETS BENCHMARKS:
SOFR (30D)4.82%-2 bps/10Y UST4.38%+4 bps/Wall St Prime7.75%/Commercial Spread Avg245 bps
Federal Reserve H.15 • Real-time Yield MonitorTerminal Direct
DETERMINISTIC FINANCIAL ENGINE

Underwriting Methodology & Mathematical Specifications

Formulaic definitions, regulatory underwriting guidelines, and covenant risk protocols calibrated to Fannie Mae DUS, Freddie Mac SBL, CMBS conduit, and SBA 504 standards.

SPECIFICATION 01DEBT SIZING SOLVER

Simultaneous Tri-Constraint Maximum Loan Solver

Commercial lenders do not size debt using a single debt-to-income or loan-to-value ratio. DSCR Sizing Desk executes a simultaneous deterministic resolution across three independent constraints and determines the binding bottleneck:

1. Maximum Loan by LTV Cap:L_max_ltv = (Purchase Basis + CapEx Budget) × LTV_max
2. Maximum Loan by DSCR Floor:L_max_dscr = (Underwritten NOI) / (DSCR_min × K_amort)
3. Maximum Loan by Debt Yield:L_max_dy = (Underwritten NOI) / (Debt Yield_min)
Binding Governing Loan:L_actual = min(L_max_ltv, L_max_dscr, L_max_dy)

Where K_amort represents the annualized mortgage constant. Sizing proceeds to the lowest constraint prevents technical covenant defaults at loan closing.

SPECIFICATION 02AMORTIZATION CONSTANT

Annual Mortgage Amortization Constant ($K_{amort}$)

The mortgage constant expresses the total annual debt service (principal and interest) as a percentage of the original loan balance, derived from monthly compounding:

Monthly Periodic Rate:i = r / 12
Total Monthly Periods:n = Amortization Years × 12
Annual Mortgage Constant:K_amort = 12 × [ (i × (1 + i)^n) / ((1 + i)^n - 1) ]

For Interest-Only (I/O) tranches, K_amort = r during the interest-only period, reducing annual debt service and expanding DSCR-constrained borrowing capacity.

SPECIFICATION 03PRO-FORMA AUDITING

T-12 Operating Statement Forensic Haircut Standards

Offering memorandums commonly state pro-forma figures with 0% vacancy or omitted third-party management. Institutional credit committees enforce non-negotiable underwriting floors:

Underwriting ParameterInstitutional StandardHaircut Logic
Physical Vacancy Floor5.00% - 8.00%Applied on Gross Potential Rent even if asset is 100% occupied to account for turnover.
Management Fee Floor3.50% - 5.00%Imputed on Effective Gross Income (EGI) regardless of self-management to reflect third-party servicing costs.
Capital Replacement Reserves$250 - $350 / unit / yrDeducted directly from Net Operating Income to derive Net Cash Flow (NCF) for Agency debt sizing.
Ad-Valorem Property TaxPost-Sale Millage RateReassessed based on new purchase acquisition basis rather than historical seller assessed value.
SPECIFICATION 04MULTI-TRANCHE SOLVER

SBA 504 Dual-Tranche Blended Constant Specification

The statutory SBA 504 loan structure provides up to 90% financing for owner-occupied business properties via a three-part capital stack:

Tranche 1 (50% Senior Bank 1st Lien):Debt_1 = Total Basis × 0.50 (25-Year Amortization @ Bank Rate)
Tranche 2 (40% SBA CDC Debenture 2nd Lien):Debt_2 = Total Basis × 0.40 (25-Year Fixed @ 10Y UST + Debenture Spread)
Tranche 3 (10% Borrower Equity Injection):Equity = Total Basis × 0.10 (Minimum Cash Down Payment)
Blended Annual Debt Constant:K_blended = [ (Debt_1 × K_1) + (Debt_2 × K_2) ] / (Debt_1 + Debt_2)
SPECIFICATION 05MACRO SENSITIVITY

2D 5x5 Sensitivity Matrix Classification Protocol

DSCR Sizing Desk subjects each deal to 25 simultaneous interest rate and Net Operating Income shocks, classifying every cell into regulatory covenant survival zones:

ZONE 1: COMPLIANT (≥ DSCR_min)

Asset generates sufficient net cash flow after debt service. LP distributions remain authorized without lender escrow sweeps.

ZONE 2: COVENANT WATCHLIST (1.05x - DSCR_min)

Cash flow sweeps into lender lockbox accounts. Sponsor distributions halted until DSCR recovers for two consecutive quarters.

ZONE 3: TECHNICAL DEFAULT (< 1.05x)

Debt service exceeds in-place property cash flow. Lender reserves right to declare Event of Default or demand cash equity cure.

SPECIFICATION 06CONTRACTUAL RISK PROTOCOL

Deterministic Debt Sizing for Waiving Financing Contingencies

In competitive acquisitions, sponsors submit non-contingent purchase offers to beat competing bids. However, waiving a financing contingency puts hard Earnest Money Deposits (EMD) at risk if lender proceeds come back short. DSCR Sizing Desk establishes the mathematical condition under which a sponsor can safely waive or shorten contract financing contingencies:

Safe Non-Contingent Loan Ceiling:L_safe = min( (Purchase Basis + CapEx) × LTV_floor, Y_underwritten / (DSCR_target × K_amort), Y_underwritten / DY_min )
Required Equity Escrow Buffer:Equity_escrow = (Purchase Basis + Closing Costs) - L_safe + EMD_at_risk

Where Y_underwritten is strictly audited for lender replacement reserve floors ($250-$350/unit) and management fee imputations (3.5%-5.0%), and DSCR_target includes a +100 bps interest rate buffer.

SPECIFICATION 07FEE DISINTERMEDIATION PROTOCOL

Direct-to-Lender Underwriting: Eliminating 100–200 bps Intermediation Fees

Traditional commercial mortgage brokers charge a contingency success fee (F_broker) ranging from 1.0% to 2.0% of gross loan proceeds upon closing. DSCR Sizing Desk’s institutional export packages allow sponsors to self-underwrite and submit directly to agency and bank lenders, eliminating intermediation fees:

Contingency Fee Avoidance Formula:Savings = L_actual × β_broker (where β_broker ∈ [0.010, 0.020])
Example on $12,000,000 Senior Debt:Savings = $12,000,000 × 1.25% = $150,000 in Capital Saved
SPECIFICATION 08PRIMARY REGULATORY CITATIONS

Statutory Authorities & Official Regulatory Guidelines

To ensure complete institutional compliance and mathematical validity, every algorithmic constraint, minimum DSCR threshold, and pro-forma haircut in DSCR Sizing Desk is calibrated against authoritative primary sources:

Regulatory AuthorityPrimary Guideline / ManualCore Implementation in DSCR Sizing Desk
Fannie MaeMultifamily Selling & Servicing Guide (Form 4660)Tier 2 (1.25x / 75% LTV), Tier 3 (1.30x / 65% LTV), 5.0% economic vacancy floor, and $250–$350/unit replacement reserves.
Freddie MacMultifamily Seller/Servicer Guide (Topic 4)Small Balance Loan (SBL) amortization tables, standardized underwriting adjustments, and Debt Yield hurdles.
U.S. SBAStandard Operating Procedure (SOP 50 10 7.1)50/40/10 dual-tranche debt sizing, bank senior lien amortizations, and CDC 25-year debenture blended constant derivations.
Federal ReserveStatistical Release H.15 (Selected Interest Rates)Daily ingestion of 10-Year Constant Maturity Treasury (DGS10), SOFR 30-day average, and Wall Street Prime bank index.
CRE Finance CouncilCMBS Conduit Underwriting Standards & LexiconStandardized 8.0%–10.0% Debt Yield tests and lender pro-forma net cash flow (NCF) adjustment schedules.
Launch Underwriting Terminal with Deterministic Specs →