Corporate Treasury Uninsured-Deposit FDIC Sweep, LCR Stress & ASC 815 Swap Effectiveness — Calculator, Excel Workpaper & API (BI-73)
Evaluates FASB ASC 815-20-25 Cash-Flow Hedge Dollar-Offset [80%, 125%] & OLS Effectiveness; 12 CFR Part 330 Uninsured Deposit Concentration (HHI) & Counterparty Credit Loss; FDIC 12 CFR Sec. 330.1 $250,000 ICS/CDARS Allocation & 30-Day Stress LCR Test; 17 CFR Sec. 270.2a-7 (SEC Rule 2a-7) Govt MMF Liquidity & FASB ASC 305-10 <=90d Gate. Submit: Corporate Operating Cash (USD), Uninsured Deposit LGD, ICS CDARS Network Member Banks, Depository ECR Yield Rate. Excel Tabs: Summary Budget Bridge, ASC815 Hedge Effectiveness, Uninsured Deposit HHI CDS, FDIC ICS CDARS Sweep Schedule. 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: 12 CFR Part 330 FDIC $250k Insured Sweep, 30-Day Liquidity Coverage & FASB ASC 815-20 Hedge Workpaper
Official Agency Form / Workpaper Standard: FASB ASC 815-20 Hedge Effectiveness & FDIC 12 CFR Part 330 Treasury Schedule
Governing Accounting, Tax & Statutory Authorities: FASB ASC 815-20 & ASC 815-30 (Derivatives & Hedging); ASC 820 (CVA/DVA Fair Value); 12 CFR Part 330 (FDIC Deposit Coverage); Corporate Treasury Standards
Common Practitioner & Search Aliases: ASC 815 Interest Rate Swap Effectiveness, 80% to 125% Dollar-Offset Hedge Test, FDIC Uninsured Deposit Concentration HHI, ICS CDARS Insured Cash Sweep Allocation, Corporate Treasury 30-Day Liquidity Stress
Interactive Corporate Treasury Uninsured-Deposit FDIC Sweep, LCR Stress & ASC 815 Swap Effectiveness Calculator (BI-73)
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-73 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) FASB ASC 815-20-25 Cash-Flow Hedge Dollar-Offset [80%, 125%] & OLS Effectiveness [FASB ASC 815-20-25-75 & ASC 820-10-35 CVA/DVA Valuation]
- (2) 12 CFR Part 330 Uninsured Deposit Concentration (HHI) & Counterparty Credit Loss [12 CFR Part 330 & 12 U.S.C. Sec. 1821(a)(1)(E) Deposit Insurance Cap]
- (3) FDIC 12 CFR Sec. 330.1 $250,000 ICS/CDARS Allocation & 30-Day Stress LCR Test [12 CFR Sec. 330.1, 12 U.S.C. Sec. 1829b(q) Reciprocal Deposits & 12 CFR Part 249 LCR]
- (4) 17 CFR Sec. 270.2a-7 (SEC Rule 2a-7) Govt MMF Liquidity & FASB ASC 305-10 <=90d Gate [17 CFR Sec. 270.2a-7 (SEC Rule 2a-7) & FASB ASC 305-10-20 Cash Equivalents]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | 12 Months of Commercial Bank, ICS Sweep & Money-Market Custodian Statements + Daily Cash-Balance Ledger | Structured JSON object/array or CSV text |
FILE-2 | Executed ISDA Master Agreements, CSA Schedules, SOFR Swap/Cap/Collar Trade Confirmations & Hedge Inception Memos | Structured JSON object/array or CSV text |
FILE-3 | 36-Month Historical / Hypothetical Derivative Mark-to-Market Valuations & Floating-Rate Debt Schedule | Structured JSON object/array or CSV text |
FILE-4 | Trial Balance Cash/Debt/AOCI Accounts, Treasury Investment Policy & 30-Day Contractual AP/Payroll Outflow Forecast | 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 ASC815 Hedge Effectiveness |
| Schedule 3 | 03 Uninsured Deposit HHI CDS |
| Schedule 4 | 04 FDIC ICS CDARS Sweep Schedule |
| Schedule 5 | 05 30Day Stressed LCR Runway |
| Schedule 6 | 06 Bank ISDA MTM GL TieOut |
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-73/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-73",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})