Business Interest Limitation (IRS Form 8990 / IRC Sec. 163(j) 30% ATI) & Real-Property Election — Calculator, Excel Workpaper & API (BI-57)
Evaluates IRS Form 8990 Sec. 163(j) 30% ATI Cap; IRC Sec. 163(j)(7)(B) Electing Real Property Trade or Business vs. Sec. 168(g) ADS Switch; Treas. Reg. Sec. 1.163(j)-5 Consolidated Group Single-Entity ATI & SRLY Absorption; IRC Sec. 163(j)(4)(B) Partnership Excess Business Interest Expense (EBIE) & ETI Release. Submit: Debt Principal, Blended Spread, Business Interest Income, Ebit Ati. Excel Tabs: Form 8990 Summary Budget Bridge, RPTOB 163j7 ADS Crossover Model, Consolidated 163j4 Group Alloc, Partnership EBIE Schedule K1. 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: 26 U.S.C. Sec. 163(j) 30% Adjusted Taxable Income Cap, ADS Depreciation Crossover & Form 8990 Workpaper
Official Agency Form / Workpaper Standard: IRS Form 8990 (IRC Sec. 163(j) Limitation & Sec. 163(j)(7)(B) RPTOB Election)
Governing Accounting, Tax & Statutory Authorities: 26 U.S.C. § 163(j) & Treas. Reg. §§ 1.163(j)-1 to -10; IRS Form 8990; IRC § 163(j)(7)(B) Real-Property Election & IRC § 168(g) ADS
Common Practitioner & Search Aliases: Form 8990 Section 163(j) Calculator, 30% Adjusted Taxable Income EBIT Cap, Real Property Trade or Business Election, ADS Depreciation Crossover NPV, Excess Business Interest Carryforward
Interactive Business Interest Limitation (IRS Form 8990 / IRC Sec. 163(j) 30% ATI) & Real-Property Election Calculator (BI-57)
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-57 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) IRS Form 8990 Sec. 163(j) 30% ATI Cap [26 U.S.C. Secs. 163(j)(1), 163(j)(8)(A)(v) & IRS Form 8990]
- (2) IRC Sec. 163(j)(7)(B) Electing Real Property Trade or Business vs. Sec. 168(g) ADS Switch [26 U.S.C. Secs. 163(j)(7)(B) & 168(g)(1)(F), (g)(8)]
- (3) Treas. Reg. Sec. 1.163(j)-5 Consolidated Group Single-Entity ATI & SRLY Absorption [Treas. Reg. Secs. 1.163(j)-4(d) & 1.163(j)-5(b)]
- (4) IRC Sec. 163(j)(4)(B) Partnership Excess Business Interest Expense (EBIE) & ETI Release [26 U.S.C. Sec. 163(j)(4)(B) & Schedule K-1 Rules]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | Prior 3 Years of Federal Tax Returns (Form 1120 / 1065), Prior Forms 8990 & State Tax Workpapers | Structured JSON object/array or CSV text |
FILE-2 | Complete Debt & Derivative Subledger (Principal, Cash Interest, OID, Swaps & Financing Fees) | Structured JSON object/array or CSV text |
FILE-3 | Tax Fixed-Asset Depreciation Register (Residential, Nonresidential, QIP & Personal Property) | Structured JSON object/array or CSV text |
FILE-4 | 5-Year Operating EBITDA, CapEx & Debt-Refinancing Forecast by Legal Entity | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | Form8990 Summary Budget Bridge |
| Schedule 2 | RPTOB 163j7 ADS Crossover Model |
| Schedule 3 | Consolidated 163j4 Group Alloc |
| Schedule 4 | Partnership EBIE Schedule K1 |
| Schedule 5 | Capital Stack Debt Reprice Plan |
| Schedule 6 | GL Interest Form1120 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-57/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-57",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})