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

Hotel USALI 12th Ed. Operating Statement, Net RevPAR / GOPPAR & Mortgage Debt-Yield Schedule — Calculator, Excel Workpaper & API (BI-18)

Evaluates USALI 12th Ed. Schedule 1 Rooms RevPAR, Net RevPAR & Departmental Margin; USALI Schedule 2 Food & Beverage Margin & Banquet Admin-Fee Flow-Through; Undistributed Operating Expenses, Gross Operating Profit (GOPPAR) & Management Fees; 4.0% FF&E Reserve, Stabilized EBITDAre & CMBS Debt-Yield / DSCR Covenant Gate. Submit: Hotel Keys, Operating Days, Occupancy (%), Adr (USD). Excel Tabs: Summary Operating Statement, Schedule 1 Rooms, Schedule 2 Food And Beverage, Schedule 3 Other Operated Depts. 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: USALI 12th Revised Edition Departmental Schedules 1-14, FF&E Reserve & Hospitality Debt-Yield Covenant Filing

Official Agency Form / Workpaper Standard: USALI 12th Revised Edition Summary Operating Statement (Schedules 1-14)

Governing Accounting, Tax & Statutory Authorities: Uniform System of Accounts for the Lodging Industry (USALI 12th Revised Edition — effective Jan 1, 2026); STR Benchmarking Standards

Common Practitioner & Search Aliases: USALI Hotel P&L Calculator, RevPAR and GOPPAR Calculator, Net RevPAR OTA Commission Waterfall, Hotel Management Incentive Fee, Hospitality Loan Debt Yield

Live Zero-Code Statutory Calculator & .xlsx Builder

Interactive Hotel USALI 12th Ed. Operating Statement, Net RevPAR / GOPPAR & Mortgage Debt-Yield Schedule Calculator (BI-18)

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

Gross Revpar (USD)
$212.77
Net Revpar After Ota (USD)
$192.56
Usali Goppar (USD)
$107.45
Stabilized EBITDA Re (USD)
$27,050,235.67
Cmbs Senior Debt Yield (%)
11.22%

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-18 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-124-Month Monthly Hotel Operating Statements & General Ledger Mapped to USALI 12th Revised EditionStructured JSON object/array or CSV text
FILE-212-Month Property Management System (PMS) Segmentation Report & STR Competitive Set Benchmark ReportStructured JSON object/array or CSV text
FILE-3OTA Commission Invoices (Expedia, Booking.com), GDS Fees, Franchise Royalty Bills & Loyalty AssessmentsStructured JSON object/array or CSV text
FILE-4Departmental Daily Labor-Hour & Overtime Register (Housekeeping Minutes-Per-Occupied-Room & Banquet Staffing)Structured JSON object/array or CSV text

Deterministic Output Workpaper Schedules

Workpaper ScheduleComputed Output Schedule & Tie-Out
Schedule 1Summary Operating Statement
Schedule 2Schedule 1 Rooms
Schedule 3Schedule 2 Food and Beverage
Schedule 4Schedule 3 Other Operated Depts
Schedule 5Schedule 5 Admin and General
Schedule 6Schedule 6 Info and Telecom

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/suites/BI-18/compute" \
  -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-18",
  "jurisdiction": "DE",
  "naics_or_sic": "541211",
  "structured_inputs": {}
})

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