M&A Purchase Price Allocation (ASC 805 PPA) & IRS Form 8594 Seven-Class Asset Waterfall — Calculator, Excel Workpaper & API (BI-53)
Evaluates FASB ASC 805-20 Multi-Period Excess Earnings Method (MPEEM) Customer Intangible; IRC Sec. 197 15-Year Tax Amortization Benefit (TAB) & Relief-from-Royalty IP; FASB ASC 805-20-55 With-and-Without Non-Compete & Assembled Workforce CAC; IRS Form 8594 Seven-Class Residual Purchase Price Waterfall. Submit: Purchase Price, NWC Fv, Ppe Fv, Base Customer Revenue. Excel Tabs: Summary Budget Bridge, Form 8594 Seven Class Grid, MPEEM Customer Rel Model, Relief From Royalty IP Tech. 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 805-20 Intangible Valuation (MPEEM / Relief-from-Royalty) & IRC Sec. 1060 Form 8594 Filing
Official Agency Form / Workpaper Standard: IRS Form 8594 (IRC Sec. 1060 & Sec. 197) / FASB ASC 805 PPA Schedule
Governing Accounting, Tax & Statutory Authorities: 26 U.S.C. §§ 1060 & 197 (IRS Form 8594 7-Class Allocation & 15-Yr Amortization); FASB ASC 805 & ASC 820; AICPA Valuation Services VS Section 100
Common Practitioner & Search Aliases: Purchase Price Allocation PPA Calculator, IRS Form 8594 Asset Acquisition Waterfall, MPEEM Customer Relationship Valuation, Section 197 15-Year Tax Amortization Benefit, ASC 805 Goodwill Residual Schedule
Interactive M&A Purchase Price Allocation (ASC 805 PPA) & IRS Form 8594 Seven-Class Asset Waterfall Calculator (BI-53)
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-53 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) FASB ASC 805-20 Multi-Period Excess Earnings Method (MPEEM) Customer Intangible [FASB ASC 805-20, ASC 820 & AICPA Business Combinations Valuation Guide]
- (2) IRC Sec. 197 15-Year Tax Amortization Benefit (TAB) & Relief-from-Royalty IP [26 U.S.C. Secs. 197(a) & 1060]
- (3) FASB ASC 805-20-55 With-and-Without Non-Compete & Assembled Workforce CAC [FASB ASC 805-20-55-6 & AICPA Intangible Asset Practice Aid]
- (4) IRS Form 8594 Seven-Class Residual Purchase Price Waterfall [26 U.S.C. Sec. 1060, Treas. Reg. Sec. 1.1060-1 & FASB ASC 805-30]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | Executed Stock/Asset Purchase Agreement (SPA/APA), Closing Funds-Flow Memo & Deal Investment Model | Structured JSON object/array or CSV text |
FILE-2 | Closing-Date Trial Balance, Fixed-Asset Register, Inventory Aging, Deferred Revenue & Lease Schedule | Structured JSON object/array or CSV text |
FILE-3 | 5-Year Post-Acquisition Financial Projections & Historical 36-Month Customer-by-Customer Revenue Cohort File | Structured JSON object/array or CSV text |
FILE-4 | Employee Roster (Salary/Tenure for Assembled Workforce CAC), IP Licenses & Non-Compete Covenants | 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 Form8594 Seven Class Grid |
| Schedule 3 | 03 MPEEM Customer Rel Model |
| Schedule 4 | 04 ReliefFromRoyalty IP Tech |
| Schedule 5 | 05 WithWithout NonCompete |
| Schedule 6 | 06 WARA WACC IRR Reconcil |
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-53/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-53",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})