BI-01 · Commercial Credit, Working Capital & Unit-Economics Suite

Borrowing Base Certificate (BBC), 13-Week Cash Flow & FCCR Covenant Packet — Calculator, Excel Workpaper & API (BI-01)

Evaluates 13-Week Reconciled Direct Cash-Flow Bridge & Minimum Liquidity Floor Test; OCC Borrowing-Base AR Eligibility (>90d Past-Due & 25% Cross-Age Taint + Capped WIP); Credit-Agreement Fixed-Charge Coverage Ratio (Strict 5% EBITDA Add-Back Cap); FASB ASC 205-40-50 12-Month Unadjusted Going-Concern Cash-Sufficiency Test. Submit: Opening Cash, Minimum Liquidity Floor, Revolver Commitment, Drawn Revolver. Excel Tabs: Exec Liquidity Bridge, 13Wk Direct Cash Model, Vendor Sequencing Queue, Actual Vs Forecast Var. 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: OCC Asset-Based Lending Borrowing-Base Certificate & FASB ASC 205-40 12-Month Going-Concern Filing

Official Agency Form / Workpaper Standard: OCC ABL Handbook / FASB ASC 205-40 / UCC Art. 9 BBC

Governing Accounting, Tax & Statutory Authorities: FASB ASC 205-40 (Going Concern Evaluation); OCC Commercial Lending Comptroller's Handbook; ABI 13-Week Cash-Flow Protocol

Common Practitioner & Search Aliases: Borrowing Base Certificate, BBC Calculator, 13-Week Cash Flow Forecast, 25% Cross-Aging Taint, FCCR Covenant Certificate, ASC 205-40 Going Concern

Live Zero-Code Statutory Calculator & .xlsx Builder

Interactive Borrowing Base Certificate (BBC), 13-Week Cash Flow & FCCR Covenant Packet Calculator (BI-01)

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

Net Borrowing Base (USD)
$6,557,000.00
Undrawn Revolver Availability (USD)
$3,087,000.00
Trough 13w Total Liquidity (USD)
$4,957,000.00
Statutory FCCR X
1.31x
Ending 12m Unrestricted Cash (USD)
$5,290,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 (6 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-01 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-112-Month Native PDF Bank & DACA Lockbox Statements (All Operating & Sweep Accounts)Structured JSON object/array or CSV text
FILE-224-Month Monthly Accrual Trial Balance & Cash-Receipt General Ledger ExportStructured JSON object/array or CSV text
FILE-3Open Accounts Receivable & Accounts Payable Invoice-Level Aging SchedulesStructured JSON object/array or CSV text
FILE-4Executed Senior Credit Agreement, Borrowing-Base Certificates & Bi-Weekly Payroll RegisterStructured JSON object/array or CSV text

Deterministic Output Workpaper Schedules

Workpaper ScheduleComputed Output Schedule & Tie-Out
Schedule 101 Exec Liquidity Bridge
Schedule 202 13Wk Direct Cash Model
Schedule 303 Vendor Sequencing Queue
Schedule 404 Actual vs Forecast Var
Schedule 505 FCCR Covenant Headroom
Schedule 606 12Mo Bank Book Proof

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/credit/liquidity-runway-and-altman-z-score" \
  -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-01",
  "jurisdiction": "DE",
  "naics_or_sic": "541211",
  "structured_inputs": {}
})

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