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

SaaS ARR Snowball Roll-Forward, Net Dollar Retention (NDR) & ASC 606 SSP Revenue Audit — Calculator, Excel Workpaper & API (BI-23)

Evaluates FASB ASC 606-10-32 Relative Standalone Selling Price (SSP) Allocation; Contracted ARR Roll-Forward & Recurring-Revenue Borrowing-Base Sizing; Cohort Gross Dollar Retention (GDR <= 100%) & Net Dollar Retention (NDR); FASB ASC 340-40 Incremental Commission Capitalization & CAC Payback Months. Submit: Bundled Contract Tcv (USD), Observable Ssp Saas (USD), Observable Ssp Proserv (USD), Stated Proserv Invoice (USD). Excel Tabs: Exec Saa S KPI Dashboard, ARR Snowball Roll Forward, Customer Cohort Layer Cake, ASC606 Rev Rec Deferred. 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: FASB ASC 606 Standalone Selling Price Allocation, Contracted ARR Roll-Forward & ASC 340-40 CAC Workpaper

Official Agency Form / Workpaper Standard: FASB ASC 606-10-32 SSP / ASC 340-40 Commission / SaaS ARR Cohort Schedule

Governing Accounting, Tax & Statutory Authorities: FASB ASC 606 (Contract Identification, Performance Obligations & Variable Consideration); SEC Non-GAAP Financial Measures C&DI Guidance; SaaS Capital / Bessemer Institutional SaaS Metrics Standard

Common Practitioner & Search Aliases: SaaS ARR Roll-Forward Snowball, Net Dollar Retention NDR Calculator, ASC 606 Standalone Selling Price SSP, ASC 340-40 Deferred Commission Amortization, CAC Payback and LTV Ratio

Live Zero-Code Statutory Calculator & .xlsx Builder

Interactive SaaS ARR Snowball Roll-Forward, Net Dollar Retention (NDR) & ASC 606 SSP Revenue Audit Calculator (BI-23)

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

Verified Eligible Closing Arr (USD)
$26,400,000.00
Ineligible Arr Haircut (USD)
$6,100,000.00
Gross Dollar Retention (%)
87.85%
Net Dollar Retention (%)
100.66%
Arr Borrowing Base Limit (USD)
$66,000,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-23 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 Customer-by-Month Subscription Billing & ARR/MRR Waterfall Export (Signup Date, Tier, Contraction, Expansion, Churn)Structured JSON object/array or CSV text
FILE-2Executed Multi-Year Customer Contracts, Order Forms & Deferred Revenue / Unbilled Contract Asset Sub-LedgerStructured JSON object/array or CSV text
FILE-336-Month Sales & Marketing Expense Ledger, Sales Commission Amortization Schedule (ASC 340-40) & Hosting COGSStructured JSON object/array or CSV text
FILE-424-Month Monthly Trial Balance & Stripe / Billing-Gateway / Bank Settlement StatementsStructured JSON object/array or CSV text

Deterministic Output Workpaper Schedules

Workpaper ScheduleComputed Output Schedule & Tie-Out
Schedule 100 Exec SaaS KPI Dashboard
Schedule 201 ARR Snowball RollForward
Schedule 302 Customer Cohort LayerCake
Schedule 403 ASC606 RevRec Deferred
Schedule 504 LTV CAC Payback UnitEcon
Schedule 605 Churn Pricing Action 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/gaap/asc606-saas-ndr-and-cohort-economics" \
  -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-23",
  "jurisdiction": "DE",
  "naics_or_sic": "541211",
  "structured_inputs": {}
})

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