Good day, Portfolio Manager • Zero Broker Gates

Commercial Debt Sizing Terminal

Tri-Constraint Solver Active
Live · US Markets Open
LIVE BENCHMARKSJust now
10-Year U.S. Treasury:4.380%+4 bps
5-Year U.S. Treasury:4.150%-2 bps
1-Month Term SOFR CME:4.820%+1 bps
Wall Street Journal Prime:7.750%0 bps
SBA 504 25Y Debenture:5.820%-6 bps
Property & Acquisition
TX
$0
$
$0
$
Debt Sizing Basis

Institutional Covenant Monitor & KPIs

3 Compliant
Statutory Floors: 1.25x DSCR • 80% LTV
Constrained Max Loan
—
Ready for Acquisition Entry
Senior Lien — Equity —
Debt Service Coverage
— DSCR
Statutory Floor: 1.25x
Net Cash Flow
—
Annual Debt
—
Going-In Cap Rate
—
Benchmark Rate: 5.85%
Debt Yield
—
Cash-on-Cash
—
Covenant Pipeline
Standby (Awaiting Deal)
4 Rules Calibrated Ready to Solve
DSCR Floor (≥ 1.25x)—
Max LTV Cap (≤ 80%)—
Tri-Constraint Maximum Loan Solver
Ready to Solve
1. Max Loan by LTV Cap (80%)—
2. Max Loan by DSCR Floor (1.25x)—
3. Max Loan by Debt Yield Floor (8%)—
Awaiting property purchase price and operating income to size loan proceeds.
Enter acquisition basis and property revenue below to run simultaneous LTV, DSCR, and Debt Yield underwriting constraints.
Debt Structure & Covenants
AGENCY MULTIFAMILY
View Program Rules →
5.850%
%
30 Yrs
10 Yrs
1.5%
%
Auto-Sized by Constraint
$
T-12 Operating Statement & Lender Haircut Audit
Comparing Seller Stated Operating History vs Institutional Underwritten Adjustments
Pro-Forma Operating ScheduleSeller Stated (T-12)Lender UnderwrittenAudit Note
I. Gross Scheduled Revenues
Gross Potential Rent (GPR)
Contract scheduled annualized base rent
$0Base
Ancillary & Other Income
RUBS, parking, storage, laundry, pet fees
$0 -15% Haircut
Vacancy, Concessions & Bad Debt
User stated: 0.0% | Lender floor: 5%
(0.0%) -$05% Floor
EFFECTIVE GROSS INCOME (EGI)$0$0Reconstructed
II. Operating Expenses (OpEx)
Real Estate Property Taxes
Adjusted for acquisition reassessment
$0County Tax
Property & Casualty Insurance
Commercial habitational hazard & liability
$0P&C
Property Management Fee
User stated: 0% of EGI | Lender floor: 4%
$0$04% Floor
Utilities (Water, Sewer, Trash, Gas)$0
Repairs & Maintenance / Unit Turn$0
Payroll, Admin & Contract Services$0
TOTAL OPERATING EXPENSES (OpEx)
Audited Expense Ratio: 0.0% of EGI
$0$00% Ratio
NET OPERATING INCOME (NOI)$0$0NOI
Capital Replacement Reserves
$250/unit/year mandatory deduction
$0 (Stated) -$0Reserve Cap
UNDERWRITTEN CASH FLOW (NCF)
Institutional Net Cash Flow used by GSE/CMBS credit committee
$0$0Sized On
2D Interest Rate & Vacancy Stress-Test Matrix
5 × 5 Covenant Survival Heatmap across Interest Rate & NOI Shocks
≥ 1.25x Compliant≥ 1.05x Watchlist< 1.05x Cash-Trap
Rate \ NOI-15% Shock -10% Shock -5% Shock 0% Shock +5% Shock
-100 bps
4.85%
—
—
—
—
—
—
—
—
—
—
-50 bps
5.35%
—
—
—
—
—
—
—
—
—
—
0 bps
5.85%
—
—
—
—
—
—
—
—
—
—
+50 bps
6.35%
—
—
—
—
—
—
—
—
—
—
+100 bps
6.85%
—
—
—
—
—
—
—
—
—
—
Principal Amortization & Balloon Refinance Risk
Horizon Paydown Curve & Year-10 Exit Refinance Covenant Stress Test
Awaiting Loan Sizing
Yr 0Yr 15Yr 30 Full Payoff
Principal Paid Down
—
Maturity Balloon Balance
—
Projected Exit NOI
—
Exit Debt Yield
—