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:
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:
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 Parameter | Institutional Standard | Haircut Logic |
|---|
| Physical Vacancy Floor | 5.00% - 8.00% | Applied on Gross Potential Rent even if asset is 100% occupied to account for turnover. |
| Management Fee Floor | 3.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 / yr | Deducted directly from Net Operating Income to derive Net Cash Flow (NCF) for Agency debt sizing. |
| Ad-Valorem Property Tax | Post-Sale Millage Rate | Reassessed 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:
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:
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:
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 Authority | Primary Guideline / Manual | Core Implementation in DSCR Sizing Desk |
|---|
| Fannie Mae | Multifamily 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 Mac | Multifamily Seller/Servicer Guide (Topic 4) | Small Balance Loan (SBL) amortization tables, standardized underwriting adjustments, and Debt Yield hurdles. |
| U.S. SBA | Standard 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 Reserve | Statistical 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 Council | CMBS Conduit Underwriting Standards & Lexicon | Standardized 8.0%–10.0% Debt Yield tests and lender pro-forma net cash flow (NCF) adjustment schedules. |