Nonprofit ASC 958 Liquidity Footnote & UPMIFA 12-Quarter Endowment Spending Schedule — Calculator, Excel Workpaper & API (BI-33)
Evaluates FASB ASC 958-210-45-7 Financial Assets Available for General Expenditure Within 12 Months; Unrestricted Operating-Reserve Months-of-Cash-Expense Coverage Ratio; UPMIFA Sec. 4(d) 7% Prudence Presumption & 12-Quarter Rolling Endowment Appropriation; FASB ASC 958-205-45-28 Underwater Endowment Donor-Principal Deficit Footnote. Submit: Endowment Nav, Board Reserve Floor Months, Target Spending Rate. Excel Tabs: Exec Reserve Endowment Sum, ASC958 210 Liquidity Note, DC UPMIFA 44 1634 Spending, Hybrid Yale Tobin Rule. 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 958-210-45-7 12-Month Liquidity Disclosure & UPMIFA Rolling Endowment Spending Workpaper
Official Agency Form / Workpaper Standard: FASB ASC 958-210 Liquidity Note / UPMIFA Sec. 4 Endowment Spending Schedule
Governing Accounting, Tax & Statutory Authorities: D.C. Official Code §§ 44-1631 to 44-1639 (Uniform Prudent Management of Institutional Funds Act — UPMIFA); FASB ASC 958-210-45-7 (Quantitative & Qualitative Liquidity & Availability Footnote Disclosure)
Common Practitioner & Search Aliases: ASC 958 Nonprofit Liquidity Footnote, UPMIFA 7% Endowment Spending Rule, 12-Quarter Moving Average Endowment, Underwater Endowment Deficit ASC 958, Months of Unrestricted Cash Reserve
Interactive Nonprofit ASC 958 Liquidity Footnote & UPMIFA 12-Quarter Endowment Spending Schedule Calculator (BI-33)
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-33 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) FASB ASC 958-210-45-7 Financial Assets Available for General Expenditure Within 12 Months [FASB ASU 2016-14 & ASC 958-210-45-7 / 50-1 Quantitative Liquidity Disclosure]
- (2) Unrestricted Operating-Reserve Months-of-Cash-Expense Coverage Ratio [FASB ASC 958-210-50-1 Qualitative Liquidity Policy & Board Reserve Governance Floor]
- (3) UPMIFA Sec. 4(d) 7% Prudence Presumption & 12-Quarter Rolling Endowment Appropriation [Uniform Prudent Management of Institutional Funds Act (UPMIFA) Sec. 4(a) & Optional Sec. 4(d)]
- (4) FASB ASC 958-205-45-28 Underwater Endowment Donor-Principal Deficit Footnote [FASB ASU 2016-14 & ASC 958-205-45-28 / 50-2 Underwater Endowment Disclosure]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | 36-Month Statement of Financial Position, Statement of Activities Trial Balance & Operating Cash-Flow Ledger | Structured JSON object/array or CSV text |
FILE-2 | 36-Month Custodial Investment & Endowment Statements (Asset Allocation, Market Value, Returns, Fees & Liquidity Tiers) | Structured JSON object/array or CSV text |
FILE-3 | Donor Endowment Gift Instruments, Board-Designated Reserve Resolutions & Current Investment Policy Statement (IPS) | Structured JSON object/array or CSV text |
FILE-4 | 24-Month Grant & Conference Cash-Inflow Schedule + Unfunded Private-Equity / Alternative Capital-Call Commitments | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | 01 Exec Reserve Endowment Sum |
| Schedule 2 | 02 ASC958 210 Liquidity Note |
| Schedule 3 | 03 DC UPMIFA 44 1634 Spending |
| Schedule 4 | 04 Hybrid Yale Tobin Rule |
| Schedule 5 | 05 Regime Drawdown Stress |
| Schedule 6 | 06 Custodian NetAsset 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-33/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-33",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})