Troubled Debt Restructuring, 10% Debt Modification Test & Covenant Cure Schedule — Calculator, Excel Workpaper & API (BI-05)
Evaluates FASB ASC 470-50-40 Lender-by-Lender 10% Present-Value Cash-Flow Modification Test; Contractual Debt-Service Coverage Ratio (DSCR) & Equity-Cure Resizing Bridge; FASB ASU 2022-02 (ASC 326) Modified Loan Effective-Interest Yield & Concession Test; 11 U.S.C. Sec. 1129(a)(7) Best-Interests Waterfall vs. Sec. 1129(a)(11) Feasibility. Submit: Pre Mod Carrying Debt (USD), Equity Cure Paydown (USD), Original Eir, Modified Coupon Rate. Excel Tabs: Workout Exec Summary, Capital Stack Debt Grid, ASC470 50 10Pct Test, Covenant Cure Bridge. 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: FASB ASC 470-50 10% Cash-Flow Modification Test, ASU 2022-02 Loan Workout & 11 U.S.C. 1129 Feasibility Filing
Official Agency Form / Workpaper Standard: FASB ASC 470-50 / ASU 2022-02 / 11 U.S.C. Sec. 1129 Workout Schedule
Governing Accounting, Tax & Statutory Authorities: OCC Troubled Debt Restructuring / Loan Modification Guidance (ASU 2022-02); 11 U.S.C. § 1129(a)(11) Feasibility Standard
Common Practitioner & Search Aliases: Debt Modification 10% Test, Loan Workout DSCR Resizing, EBITDA Equity Cure Calculator, Chapter 11 Best Interests Liquidation Test, TDR Loan Modification
Interactive Troubled Debt Restructuring, 10% Debt Modification Test & Covenant Cure Schedule Calculator (BI-05)
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-05 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) FASB ASC 470-50-40 Lender-by-Lender 10% Present-Value Cash-Flow Modification Test [FASB ASC 470-50-40-10 & ASC 470-50-40-12 (Debt — Modifications and Extinguishments)]
- (2) Contractual Debt-Service Coverage Ratio (DSCR) & Equity-Cure Resizing Bridge [OCC Comptroller's Handbook: Rating Credit Risk (Pass Commercial DSCR >= 1.25x)]
- (3) FASB ASU 2022-02 (ASC 326) Modified Loan Effective-Interest Yield & Concession Test [FASB ASU 2022-02 (ASC 310-10-50-38 Financial-Difficulty Modifications & ASC 326-20-35-4)]
- (4) 11 U.S.C. Sec. 1129(a)(7) Best-Interests Waterfall vs. Sec. 1129(a)(11) Feasibility [11 U.S.C. Sec. 1129(a)(7) (Best Interests of Creditors), Sec. 1129(a)(11) & Sec. 326]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | Executed Credit Agreements, Amendments, Forbearance Letters & Covenant Default Notices | Structured JSON object/array or CSV text |
FILE-2 | 36-Month Historical Monthly Trial Balance & 12-Month Bank Statements | Structured JSON object/array or CSV text |
FILE-3 | Complete Debt-Service Schedule (Principal, Cash Interest, Swap/Hedging & Lease Obligations) | Structured JSON object/array or CSV text |
FILE-4 | Collateral Appraisals, UCC-1 Lien Search Summary & Management Turnaround Cost Plan | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | 01 Workout Exec Summary |
| Schedule 2 | 02 Capital Stack Debt Grid |
| Schedule 3 | 03 ASC470 50 10Pct Test |
| Schedule 4 | 04 Covenant Cure Bridge |
| Schedule 5 | 05 11USC1129 Liquidation Test |
| Schedule 6 | 06 Loan Stmt 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-05/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-05",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})