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

Franchise FDD Item 19 Unit-Economics Substantiation & ASC 606 Initial Fee Recognition Schedule — Calculator, Excel Workpaper & API (BI-20)

Evaluates 16 CFR Sec. 436.5(s) FDD Item 19 Mean, Median & Attainment Substantiation; Store-Level Four-Wall EBITDA & ASC 606-10-55-65 Sales-Based Royalty Reconciliation; FASB ASC 606-10-55 Pre-Opening Distinct Services SSP vs. License Deferral; 16 CFR Sec. 436.5(h),(l) Item 8/12 Credits & Franchisee Debt Coverage Gate. Submit: Fdd Item19 Claimed Mean (USD), Non Revenue Royalty Exclusions (USD), Contractual Royalty (%), Contractual Ad Fund (%). Excel Tabs: Exec Franchise Dashboard, FDD Item19 Substantiation, Four Wall Unit Economics, Huff Gravity Cannibalization. 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: FTC 16 CFR Part 436.5(s) FDD Item 19 Attainment Proof, Four-Wall EBITDA & ASC 606 Franchise Fee Workpaper

Official Agency Form / Workpaper Standard: FTC 16 CFR Part 436 (FDD Items 7 & 19) / FASB ASC 606-10-55 Schedule

Governing Accounting, Tax & Statutory Authorities: 16 CFR Part 436 (FTC Franchise Rule — Item 7 & Item 19 Financial Performance Representations); FASB ASC 606-10-55-65 (Sales-Based Royalties); Spatial Huff Gravity Model

Common Practitioner & Search Aliases: FDD Item 19 Substantiation Calculator, Franchise Four-Wall EBITDA, ASC 606 Initial Franchise Fee Amortization, Franchise Royalty and Ad-Fund Audit, Multi-Unit Store Breakeven

Live Zero-Code Statutory Calculator & .xlsx Builder

Interactive Franchise FDD Item 19 Unit-Economics Substantiation & ASC 606 Initial Fee Recognition Schedule Calculator (BI-20)

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

Cohort Median Unit Sales (USD)
$2,135,000.00
Item19 Attainment (%)
16.67%
Royalty Base Overcharge Cure (USD)
$267,999.99
Asc606 Deferred Initial Fee (USD)
$396,900.00
Post Remediation Franchisee FCCR X
1.48x

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-20 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 & Prior 3 Years of Franchise Disclosure Documents (FDD Items 5, 6, 7, 12, 19, 20 & CPA-Reviewed Financials)Structured JSON object/array or CSV text
FILE-236-Month Unit-Level Store Profit & Loss Statements and POS Gross Sales Ledger Across System OutletsStructured JSON object/array or CSV text
FILE-3Store Geolocation Coordinates (Lat/Long), Trade-Area Customer ZIP/Loyalty Logs & New-Unit Opening DatesStructured JSON object/array or CSV text
FILE-4Executed Franchise Agreements, Area Development Schedules & Required Vendor/Commissary Rebate DisclosuresStructured JSON object/array or CSV text

Deterministic Output Workpaper Schedules

Workpaper ScheduleComputed Output Schedule & Tie-Out
Schedule 100 Exec Franchise Dashboard
Schedule 201 FDD Item19 Substantiation
Schedule 302 Four Wall Unit Economics
Schedule 403 Huff Gravity Cannibalization
Schedule 504 ASC606 Franchise Fee Rec
Schedule 605 Territory Expansion Queue

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-20/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-20",
  "jurisdiction": "DE",
  "naics_or_sic": "541211",
  "structured_inputs": {}
})

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