Commercial Real Estate (CRE) Loan Sizing (DSCR / LTV / Debt Yield) & Maturity Refi Gap Workpaper — Calculator, Excel Workpaper & API (BI-19)
Evaluates CREFC IRP v8.0+ OSAR Stabilized NOI & Verified NCF Waterfall; Triple-Constraint Senior Mortgage Sizing (LTV, DSCR & Debt-Yield Gate); Rent-Weighted WALT, 24-Month Rollover Exposure & Upfront TI/LC Escrow; Maturing Note Refinance Rescue Gap & OCC Current-Pay Blended DSCR Test. Submit: Gross Potential Revenue (USD), Vacancy Concession Loss (USD), Crefc Operating Expenses (USD), Annual Ti Lc Reserve (USD). Excel Tabs: CREFC OSAR Operating Statement, CREFC Commercial Rent Roll, WALT Rollover And TI LC Schedule, Debt Yield And DSCR Sizing Matrix. Calibrated across all 57 US States, Washington, D.C., US Territories, and Federal IRC § 11 baselines in sub-millisecond deterministic Python & NumPy CPU execution.
Official Statutory & Regulatory Workpaper Title: CREFC IRP OSAR Stabilized NOI/NCF Underwriting, Triple-Constraint Debt Sizing & Refinance Rescue Schedule
Official Agency Form / Workpaper Standard: CREFC Investor Reporting Package (IRP) OSAR & Rent-Roll Underwriting Schedule
Governing Accounting, Tax & Statutory Authorities: CREFC Investor Reporting Package (IRP) Standards; OCC CRE Lending Interagency Guidance on Prudent CRE Loan Accommodations; AICPA CS Section 100 Non-USPAP Direct Income Capitalization Financial Underwriting
Common Practitioner & Search Aliases: CRE Loan Sizing Calculator, Debt Yield DSCR LTV Constraint, CREFC OSAR NOI Underwriting, Commercial Mortgage Refinance Gap, WALT Tenant Rollover TI/LC Reserve
Interactive Commercial Real Estate (CRE) Loan Sizing (DSCR / LTV / Debt Yield) & Maturity Refi Gap Workpaper Calculator (BI-19)
Enter your trial-balance, schedule, or contract numbers below to verify headline statutory outputs in real time across 57 US jurisdictions (zero data stored).
Optional: Paste Advanced Custom Schedule / Array Overrides (JSON)
Computed Headline Statutory & Financial KPIs
Download 5-Tab Formula-Linked Excel Workpaper (.xlsx) — $19.00
Includes 5 formatted CPA/analyst tabs compiled from your exact inputs: 01_Executive_Summary, 02_Statutory_Rules (4 rules), 03_Workpaper_Schedule (5 rows + =SUM/=AVERAGE formulas), 04_Scenario_Sensitivity (=C-B variance formulas), and 05_Compliance_Audit_Flags (3 threshold gates).
1. Deterministic Statutory & Regulatory Laws Executed
Unlike prompt-only LLM skills that approximate multi-period schedules in token space, BI-19 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) CREFC IRP v8.0+ OSAR Stabilized NOI & Verified NCF Waterfall [CREFC Investor Reporting Package (IRP) Version 8.0+ OSAR Standard]
- (2) Triple-Constraint Senior Mortgage Sizing (LTV, DSCR & Debt-Yield Gate) [OCC Commercial Real Estate Lending Comptroller's Handbook Sizing Standards]
- (3) Rent-Weighted WALT, 24-Month Rollover Exposure & Upfront TI/LC Escrow [CREFC Rent Roll & Reserve Escrow Underwriting Standards]
- (4) Maturing Note Refinance Rescue Gap & OCC Current-Pay Blended DSCR Test [OCC / FDIC / Federal Reserve 2023 Policy Statement on Prudent CRE Loan Workouts]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | Current Certified Rent Roll (Suite, Tenant, SF, Lease Start/End, Base Rent, Escalations, TI/LC & Recovery Type) | Structured JSON object/array or CSV text |
FILE-2 | 36-Month Historical Property Operating Statements (T-12 / T-36 Income & Expense) & Real Estate Tax Bills | Structured JSON object/array or CSV text |
FILE-3 | Executed Senior Mortgage / CMBS Loan Documents, Promissory Note, Cash-Management Agreement & Reserve Balances | Structured JSON object/array or CSV text |
FILE-4 | Client-Supplied Historical Third-Party Property Valuation / Appraisal (Intake Input Only), CapEx Budget & Rescue Term Sheets | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | CREFC OSAR Operating Statement |
| Schedule 2 | CREFC Commercial Rent Roll |
| Schedule 3 | WALT Rollover and TI LC Schedule |
| Schedule 4 | Debt Yield and DSCR Sizing Matrix |
| Schedule 5 | AB Note Restructure Waterfall |
| Schedule 6 | Cap Rate Valuation Sensitivity |
3. Quick Integration — REST API (cURL) & AI Agent MCP
A. Direct HTTP / REST API Call
curl -X POST "https://quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com/v1/cre/commercial-real-estate-dscr-and-debt-yield" \
-H "Content-Type: application/json" \
-H "X-RapidAPI-Key: YOUR_RAPIDAPI_KEY" \
-H "X-RapidAPI-Host: quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com" \
-d '{
"jurisdiction": "NY",
"naics_or_sic": "541211",
"structured_inputs": {}
}'
B. Model Context Protocol (MCP) Tool Call
// Tool call inside Claude Desktop, Cursor, VS Code Copilot, LangGraph, or CrewAI:
execute_institutional_math_engine({
"engine_code": "BI-19",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})