State Unitary Combined Water's-Edge Apportionment & Corporate Franchise Tax Return Workpaper — Calculator, Excel Workpaper & API (BI-46)
Evaluates D.C. Form D-20 Finnigan Single-Sales-Factor Apportionment Rule; Water's-Edge Unitary Combined Taxable Income & Intercompany Elimination; FASB ASC 740-10-35 State Apportionment Deferred Tax Remeasurement; D.C. OTR Sec. 47-4201 Daily Compounded Underpayment Interest & Sec. 47-4213 Penalty. Submit: Sales Dc Finnigan, Sales Everywhere, Sales Excluded Treasury, Ti Fed Sum. Excel Tabs: Summary Budget Bridge, Form D20 Unitary Group Roster, Schedule 1A Interco Elim, Market Sourcing Sales Factor. 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: Unitary Combined Group Intercompany Elimination, Single-Sales-Factor Apportionment & ASC 740 DTA Schedule
Official Agency Form / Workpaper Standard: Unitary Combined Franchise Tax Return (Form D-20 / Finnegan Sales Factor)
Governing Accounting, Tax & Statutory Authorities: D.C. Official Code §§ 47-1805.02a, 47-1810.02, 47-1810.07 (Unitary Combined & Market Sourcing); D.C. Code § 47-1817.01 (QHTC); 9 DCMR § 156 & FASB ASC 740
Common Practitioner & Search Aliases: Unitary Combined Apportionment Calculator, Single Sales Factor Finnegan Throwback, Water's Edge Intercompany Elimination, State Rate Change ASC 740 DTA Revaluation, Corporate Franchise Tax Workpaper
Interactive State Unitary Combined Water's-Edge Apportionment & Corporate Franchise Tax Return Workpaper Calculator (BI-46)
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-46 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) D.C. Form D-20 Finnigan Single-Sales-Factor Apportionment Rule [D.C. Official Code Sec. 47-1810.02(g)(3) & 9 DCMR Sec. 156.9]
- (2) Water's-Edge Unitary Combined Taxable Income & Intercompany Elimination [D.C. Official Code Sec. 47-1805.02a & 9 DCMR Sec. 156.11]
- (3) FASB ASC 740-10-35 State Apportionment Deferred Tax Remeasurement [FASB ASC 740-10-35 & D.C. Official Code Sec. 47-1810.04(c)(2)]
- (4) D.C. OTR Sec. 47-4201 Daily Compounded Underpayment Interest & Sec. 47-4213 Penalty [D.C. Official Code Secs. 47-4201, 47-4213 & 47-4221]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | 3-Year Signed Federal Form 1120 Consolidating Returns, D.C. Form D-20 Filings & Affiliate Org Chart | Structured JSON object/array or CSV text |
FILE-2 | Consolidating Trial Balances & Intercompany Revenue/Royalty/Management-Fee Elimination Ledgers | Structured JSON object/array or CSV text |
FILE-3 | Customer-Level Revenue by Market-Sourcing Destination (D.C. vs. Everywhere) & High-Tech Activity Codes | Structured JSON object/array or CSV text |
FILE-4 | D.C. Employee W-2 Headcount/Hire Dates & Prior ASC 740 State Deferred Tax Workpapers | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | Summary Budget Bridge |
| Schedule 2 | FormD20 Unitary Group Roster |
| Schedule 3 | Schedule 1A Interco Elim |
| Schedule 4 | Market Sourcing Sales Factor |
| Schedule 5 | QHTC 47 1817 Qualification |
| Schedule 6 | ASC740 Deferred Tax Remeas |
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-46/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-46",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})