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
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)
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 (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:
- (1) 13-Week Reconciled Direct Cash-Flow Bridge & Minimum Liquidity Floor Test [OCC Comptroller's Handbook: Rating Credit Risk & Cash Dominion DACA Standards]
- (2) OCC Borrowing-Base AR Eligibility (>90d Past-Due & 25% Cross-Age Taint + Capped WIP) [OCC Comptroller's Handbook: Asset-Based Lending & UCC Article 9 Perfection Rules]
- (3) Credit-Agreement Fixed-Charge Coverage Ratio (Strict 5% EBITDA Add-Back Cap) [OCC Leveraged & Commercial Credit Examination Guidelines (Contractual FCCR >= 1.15x)]
- (4) FASB ASC 205-40-50 12-Month Unadjusted Going-Concern Cash-Sufficiency Test [FASB ASC 205-40-50-1 through 50-11 (Presentation of Financial Statements — Going Concern)]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | 12-Month Native PDF Bank & DACA Lockbox Statements (All Operating & Sweep Accounts) | Structured JSON object/array or CSV text |
FILE-2 | 24-Month Monthly Accrual Trial Balance & Cash-Receipt General Ledger Export | Structured JSON object/array or CSV text |
FILE-3 | Open Accounts Receivable & Accounts Payable Invoice-Level Aging Schedules | Structured JSON object/array or CSV text |
FILE-4 | Executed Senior Credit Agreement, Borrowing-Base Certificates & Bi-Weekly Payroll Register | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | 01 Exec Liquidity Bridge |
| Schedule 2 | 02 13Wk Direct Cash Model |
| Schedule 3 | 03 Vendor Sequencing Queue |
| Schedule 4 | 04 Actual vs Forecast Var |
| Schedule 5 | 05 FCCR Covenant Headroom |
| Schedule 6 | 06 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": {}
})