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
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)
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-21 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) 12-Month Bank-Statement-to-General-Ledger Proof-of-Cash Tie-Out [AICPA Consulting Services Sec. 100 Buy-Side Proof-of-Cash Workpaper Standard]
- (2) GAAP-to-Lender Adjusted EBITDA Bridge (Credit-Agreement Add-Back Cap) [Senior Leveraged Credit Agreement Consolidated EBITDA Definition & Cap Clauses]
- (3) LTM 12-Month Normalized NWC Peg, Collar & Closing Dollar-for-Dollar True-Up [SPA Section 2.04 Working Capital Purchase-Price Adjustment Mechanics]
- (4) SPA Indebtedness & Debt-Like Liability Purchase-Price Deduction Schedule [FASB ASC 606 Contract Liabilities, ASC 450 Contingencies & SPA Indebtedness Schedule]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | 36-Month Monthly Accrual Trial Balance & Transaction-Level General Ledger Detail Export | Structured JSON object/array or CSV text |
FILE-2 | 36-Month Native PDF Bank & Merchant Processor Statements + Monthly Bank Reconciliations (All Accounts) | Structured JSON object/array or CSV text |
FILE-3 | 36-Month Customer Revenue by Invoice, Vendor AP Aging, AR Aging & Inventory Valuation Sub-Ledgers | Structured JSON object/array or CSV text |
FILE-4 | 3-Year Signed Federal Tax Returns, Payroll Registers, Proposed EBITDA Add-Back Schedule & Draft LOI | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | Cover and Index |
| Schedule 2 | Executive Summary EBITDA Bridge |
| Schedule 3 | EBITDA Adjustments Schedule |
| Schedule 4 | Monthly Income Statement 36Mo |
| Schedule 5 | Monthly Balance Sheet 36Mo |
| Schedule 6 | 12Mo 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": {}
})