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
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)
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-20 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) 16 CFR Sec. 436.5(s) FDD Item 19 Mean, Median & Attainment Substantiation [16 CFR Sec. 436.5(s)(3) FTC Franchise Rule Item 19 & NASAA FPR Commentary]
- (2) Store-Level Four-Wall EBITDA & ASC 606-10-55-65 Sales-Based Royalty Reconciliation [FASB ASC 606-10-55-65 Sales-Based IP Royalty Exception & 16 CFR Sec. 436.5(f)]
- (3) FASB ASC 606-10-55 Pre-Opening Distinct Services SSP vs. License Deferral [FASB ASC 606-10-55-58A Practical Expedient & Pre-Opening Performance Obligations]
- (4) 16 CFR Sec. 436.5(h),(l) Item 8/12 Credits & Franchisee Debt Coverage Gate [16 CFR Sec. 436.5(h) Supplier Rebates, Sec. 436.5(l) Territory & Lender FCCR Covenants]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | Current & 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-2 | 36-Month Unit-Level Store Profit & Loss Statements and POS Gross Sales Ledger Across System Outlets | Structured JSON object/array or CSV text |
FILE-3 | Store Geolocation Coordinates (Lat/Long), Trade-Area Customer ZIP/Loyalty Logs & New-Unit Opening Dates | Structured JSON object/array or CSV text |
FILE-4 | Executed Franchise Agreements, Area Development Schedules & Required Vendor/Commissary Rebate Disclosures | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | 00 Exec Franchise Dashboard |
| Schedule 2 | 01 FDD Item19 Substantiation |
| Schedule 3 | 02 Four Wall Unit Economics |
| Schedule 4 | 03 Huff Gravity Cannibalization |
| Schedule 5 | 04 ASC606 Franchise Fee Rec |
| Schedule 6 | 05 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": {}
})