BI-21 · M&A Quality of Earnings (QoE), SaaS Cohort & Carve-Out Suite

M&A Quality of Earnings (QoE) Proof of Cash, EBITDA Bridge, NWC Peg & Net-Debt Workpaper — Calculator, Excel Workpaper & API (BI-21)

Evaluates 12-Month Bank-Statement-to-General-Ledger Proof-of-Cash Tie-Out; GAAP-to-Lender Adjusted EBITDA Bridge (Credit-Agreement Add-Back Cap); LTM 12-Month Normalized NWC Peg, Collar & Closing Dollar-for-Dollar True-Up; SPA Indebtedness & Debt-Like Liability Purchase-Price Deduction Schedule. Submit: Deposits Bank 12m, Non Revenue Bank Deposits (USD), Net Accrual Timing Bridge (USD), Receipts Gl 12m. Excel Tabs: Cover And Index, Executive Summary EBITDA Bridge, EBITDA Adjustments Schedule, Monthly Income Statement 36Mo. 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: Senior Lender Proof-of-Cash Reconciliation, Capped Credit-Agreement EBITDA & 12-Month NWC Peg Schedule

Official Agency Form / Workpaper Standard: AICPA M&A QoE Databook (Proof of Cash, EBITDA Bridge, NWC Peg & Net Debt)

Governing Accounting, Tax & Statutory Authorities: AICPA Consulting Services (CS Section 100) & Transaction Advisory QoE Framework; FASB ASC 606 / ASC 842 / ASC 450

Common Practitioner & Search Aliases: Quality of Earnings QoE Calculator, Proof of Cash Bank to GL Tie-Out, Adjusted EBITDA Add-Back Cap, Net Working Capital Peg Calculator, M&A Debt-Like Items Schedule

Live Zero-Code Statutory Calculator & .xlsx Builder

Interactive M&A Quality of Earnings (QoE) Proof of Cash, EBITDA Bridge, NWC Peg & Net-Debt Workpaper Calculator (BI-21)

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

Proof Of Cash Tie Out (%)
100.00%
Lender Verified EBITDA (USD)
$16,240,000.00
Ltm NWC Peg Target (USD)
$13,450,000.00
Spa Closing NWC Trueup (USD)
-$80,000.00
Total Debt Like Deduction (USD)
$4,820,000.00

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-21 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-136-Month Monthly Accrual Trial Balance & Transaction-Level General Ledger Detail ExportStructured JSON object/array or CSV text
FILE-236-Month Native PDF Bank & Merchant Processor Statements + Monthly Bank Reconciliations (All Accounts)Structured JSON object/array or CSV text
FILE-336-Month Customer Revenue by Invoice, Vendor AP Aging, AR Aging & Inventory Valuation Sub-LedgersStructured JSON object/array or CSV text
FILE-43-Year Signed Federal Tax Returns, Payroll Registers, Proposed EBITDA Add-Back Schedule & Draft LOIStructured JSON object/array or CSV text

Deterministic Output Workpaper Schedules

Workpaper ScheduleComputed Output Schedule & Tie-Out
Schedule 1Cover and Index
Schedule 2Executive Summary EBITDA Bridge
Schedule 3EBITDA Adjustments Schedule
Schedule 4Monthly Income Statement 36Mo
Schedule 5Monthly Balance Sheet 36Mo
Schedule 612Mo Bank to Book Proof of Cash

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/mna/quality-of-earnings-ebitda-and-nwc" \
  -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-21",
  "jurisdiction": "DE",
  "naics_or_sic": "541211",
  "structured_inputs": {}
})

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