Property & Acquisition
TX
$0
$
$0
$
Debt Sizing Basis
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 MULTIFAMILY5.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 Schedule | Seller Stated (T-12) | Lender Underwritten | Audit Note |
|---|---|---|---|
| I. Gross Scheduled Revenues | |||
Gross Potential Rent (GPR) Contract scheduled annualized base rent | $0 | Base | |
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%) | -$0 | 5% Floor |
| EFFECTIVE GROSS INCOME (EGI) | $0 | $0 | Reconstructed |
| II. Operating Expenses (OpEx) | |||
Real Estate Property Taxes Adjusted for acquisition reassessment | $0 | County Tax | |
Property & Casualty Insurance Commercial habitational hazard & liability | $0 | P&C | |
Property Management Fee User stated: 0% of EGI | Lender floor: 4% | $0 | $0 | 4% 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 | $0 | 0% Ratio |
| NET OPERATING INCOME (NOI) | $0 | $0 | NOI |
Capital Replacement Reserves $250/unit/year mandatory deduction | $0 (Stated) | -$0 | Reserve Cap |
| UNDERWRITTEN CASH FLOW (NCF) Institutional Net Cash Flow used by GSE/CMBS credit committee | $0 | $0 | Sized 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
Principal Paid Down
—
Maturity Balloon Balance
—
Projected Exit NOI
—
Exit Debt Yield
—