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
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)
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-67 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) OCC ABL Handbook & UCC Art. 9 Net-Eligible Accounts Receivable Waterfall [OCC Comptroller's Handbook: Asset-Based Lending & UCC Sec. 9-404]
- (2) OCC ABL Field-Exam 2-for-1 Non-Cash AR Dilution Advance Haircut [OCC Comptroller's Handbook: ABL Field-Examination Dilution Formula]
- (3) OCC ABL Lesser-of-65%-Cost-or-85%-NOLV Inventory Cap & PACA/Landlord Reserves [OCC ABL Inventory Valuation Guidelines & 7 U.S.C. Sec. 499e(c) Priority]
- (4) UCC Sec. 9-104 Deposit-Account Control (DACA) & Springing Cash-Dominion Gate [UCC Sec. 9-104 Deposit-Account Control & OCC ABL Covenant Standards]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | Invoice-Level Open Accounts Receivable Aging & 12-Month Monthly Gross Billings / Collections / Credit-Memo Log | Structured JSON object/array or CSV text |
FILE-2 | SKU-Level Perpetual Inventory Subledger (Raw, WIP, Finished, In-Transit) & Latest Hilco/Gordon Bros. NOLV Appraisal | Structured JSON object/array or CSV text |
FILE-3 | 12-Month Trial Balances, AP Aging, Lockbox Bank Statements & Prior Borrowing-Base Certificates | Structured JSON object/array or CSV text |
FILE-4 | ABL Credit Agreement, UCC-1 Lien Search Results, DACA Lockbox Agreements & Landlord Collateral Waivers | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | 01 Summary Budget Bridge |
| Schedule 2 | 02 AR 85Pct Ineligible Matrix |
| Schedule 3 | 03 Dynamic Dilution Reserve |
| Schedule 4 | 04 Inventory NOLV GMROI Cap |
| Schedule 5 | 05 Springing Dominion FCCR |
| Schedule 6 | 06 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": {}
})