BI-19 · CRE Debt Rescue, Lease CAM/NNN & Hospitality Margin Suite

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

Live Zero-Code Statutory Calculator & .xlsx Builder

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)
Showing verified Washington, D.C. baseline — edit any input and click Recalculate.

Computed Headline Statutory & Financial KPIs

Crefc Verified Ncf (USD)
$15,100,000.00
Concluded Senior A Note (USD)
$91,183,574.88
Refinance Rescue Gap (USD)
$50,816,425.12
Senior A Note Debt Yield (%)
16.56%
Blended Current Pay DSCR X
1.35x

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:

2. Input Schema & Workpaper Output Schedules

Structured Input Datasets (structured_inputs)

Input SlotDataset / Trial-Balance ScheduleAccepted Format
FILE-1Current Certified Rent Roll (Suite, Tenant, SF, Lease Start/End, Base Rent, Escalations, TI/LC & Recovery Type)Structured JSON object/array or CSV text
FILE-236-Month Historical Property Operating Statements (T-12 / T-36 Income & Expense) & Real Estate Tax BillsStructured JSON object/array or CSV text
FILE-3Executed Senior Mortgage / CMBS Loan Documents, Promissory Note, Cash-Management Agreement & Reserve BalancesStructured JSON object/array or CSV text
FILE-4Client-Supplied Historical Third-Party Property Valuation / Appraisal (Intake Input Only), CapEx Budget & Rescue Term SheetsStructured JSON object/array or CSV text

Deterministic Output Workpaper Schedules

Workpaper ScheduleComputed Output Schedule & Tie-Out
Schedule 1CREFC OSAR Operating Statement
Schedule 2CREFC Commercial Rent Roll
Schedule 3WALT Rollover and TI LC Schedule
Schedule 4Debt Yield and DSCR Sizing Matrix
Schedule 5AB Note Restructure Waterfall
Schedule 6Cap 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": {}
})

← Back to All 73 QuantLedger Accounting, Tax & SEC Engines