BI-67 · Technical FASB GAAP, ERISA, U.S. Customs & Cyber Loss Suite

Asset-Based Lending (ABL) Field-Exam Collateral, AR Ineligibles & NOLV Borrowing Base — Calculator, Excel Workpaper & API (BI-67)

Evaluates OCC ABL Handbook & UCC Art. 9 Net-Eligible Accounts Receivable Waterfall; OCC ABL Field-Exam 2-for-1 Non-Cash AR Dilution Advance Haircut; OCC ABL Lesser-of-65%-Cost-or-85%-NOLV Inventory Cap & PACA/Landlord Reserves; UCC Sec. 9-104 Deposit-Account Control (DACA) & Springing Cash-Dominion Gate. Submit: Gross Accounts Receivable, Trailing 12m AR Dilution (%), Appraised Nolv (%). Excel Tabs: Summary Budget Bridge, AR 85Pct Ineligible Matrix, Dynamic Dilution Reserve, Inventory NOLV GMROI Cap. 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 ABL Comptroller's Handbook AR Ineligible Waterfall, Dynamic Dilution & Inventory NOLV Cap Schedule

Official Agency Form / Workpaper Standard: OCC Asset-Based Lending Field-Examination & UCC Article 9 Borrowing-Base Cert

Governing Accounting, Tax & Statutory Authorities: OCC Comptroller's Handbook: Asset-Based Lending; Uniform Commercial Code (UCC) Article 9 Secured Transactions; AICPA CS Section 100

Common Practitioner & Search Aliases: ABL Field Exam Borrowing Base Calculator, AR Past Due and Cross-Aging Cut, 85% Inventory Net Orderly Liquidation NOLV, Dynamic Dilution Reserve Formula, Springing Cash Dominion FCCR Trigger

Live Zero-Code Statutory Calculator & .xlsx Builder

Interactive Asset-Based Lending (ABL) Field-Exam Collateral, AR Ineligibles & NOLV Borrowing Base Calculator (BI-67)

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

Study Id
BI-67
Total Borrowing Base (USD)
$30,118,807.30
Dilution Adjusted AR Advance (%)
82.20%
Net Excess Availability (USD)
$5,918,807.30
Springing Cash Dominion Triggered
NO
Abl FCCR X
1.80x

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-67 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-1Invoice-Level Open Accounts Receivable Aging & 12-Month Monthly Gross Billings / Collections / Credit-Memo LogStructured JSON object/array or CSV text
FILE-2SKU-Level Perpetual Inventory Subledger (Raw, WIP, Finished, In-Transit) & Latest Hilco/Gordon Bros. NOLV AppraisalStructured JSON object/array or CSV text
FILE-312-Month Trial Balances, AP Aging, Lockbox Bank Statements & Prior Borrowing-Base CertificatesStructured JSON object/array or CSV text
FILE-4ABL Credit Agreement, UCC-1 Lien Search Results, DACA Lockbox Agreements & Landlord Collateral WaiversStructured JSON object/array or CSV text

Deterministic Output Workpaper Schedules

Workpaper ScheduleComputed Output Schedule & Tie-Out
Schedule 101 Summary Budget Bridge
Schedule 202 AR 85Pct Ineligible Matrix
Schedule 303 Dynamic Dilution Reserve
Schedule 404 Inventory NOLV GMROI Cap
Schedule 505 Springing Dominion FCCR
Schedule 606 Tainted AR Cure Action Plan

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/suites/BI-67/compute" \
  -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-67",
  "jurisdiction": "DE",
  "naics_or_sic": "541211",
  "structured_inputs": {}
})

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