Endowment Spending Policy Analyzer
Analyze endowment spending policies and calculate sustainable distribution rates for trust funds
What You Can Do
You can systematically analyze endowment spending policies against UPMIFA standards and trust document requirements, calculate sustainable annual distributions using total return, formula-based, or percentage-of-market-value methods, and stress-test policy assumptions across historical and projected market scenarios. The skill generates board-ready compliance documentation that demonstrates prudent decision-making and identifies policy conflicts before distributions are executed.
Features
evaluate total return, income-only, percentage-of-market-value, and hybrid approaches against your policy framework
compute compliant annual payouts across restricted and unrestricted endowments with inflation adjustments
project multi-year spending impacts under historical market cycles and adverse scenarios to validate corpus preservation
generate required fiduciary analysis showing prudent decision-making and adherence to trust document restrictions
flag inconsistencies between spending formulas, distribution caps, and corpus preservation targets before execution
consolidate spending analysis across donor-restricted and board-designated funds with different policy requirements
quantify distribution changes and shortfalls for board presentations and donor communications
Example Output
Example 1: Distribution Rate Analysis
Endowment: $50M | Historical Return: 7.2% | Inflation: 2.5% | Current Payout: 5%
✓ Recommended distribution rate: 4.8% ($2.4M) ✓ Real return after payout: 2.4% (sustainable) ✓ Corpus preservation ratio: 98.7% over 10 years ✓ UPMIFA compliance: Met (policy authorizes 5% maximum, actual 4.8% prudent)
Example 2: Spending Policy Stress Test
Market Scenario: 2008-2009 downturn (-38% Year 1, +26% Year 2)
✓ Corpus impact with 5% payout: $50M → $32.3M (Year 1) → $38.1M (Year 2) ✓ Policy sustainability: Policy fails if payout continues at 5% ✓ Recommended adjustment: Reduce to 4.2% or implement spending floor ✓ Board presentation: 10-year Monte Carlo showing 92% probability of corpus maintenance
What's Included
- Endowment Spending Policy Analyzer SKILL.md: structured instruction framework for policy analysis and compliance documentation
- Distribution Rate Calculation Template: formulas for total return, income-based, and percentage-of-market-value methods with inflation adjustments
- UPMIFA Compliance Checklist: fiduciary requirements mapping (prudence, restricted purpose, impartiality, delegation standards)
- Spending Policy Stress Test Workbook: historical scenario analysis framework and Monte Carlo projection template
- Policy Conflict Resolution Matrix: systematic identification and reconciliation of competing policy objectives
Who It's For
- Trust and Endowment Accountants — validating distributions and managing ongoing compliance documentation
- CFOs and Finance Directors — establishing sustainable spending policies and presenting scenarios to boards
- Compliance Officers — ensuring UPMIFA adherence and fiduciary standards across endowment portfolios
- Audit Teams — testing distributions for policy compliance and corpus preservation
- Foundation Program Officers — analyzing spending sustainability for grant-making capacity planning
Best For
- Establishing or updating endowment spending policies with UPMIFA compliance requirements
- Calculating annual distributions across multiple restricted and unrestricted endowments
- Stress-testing policy sustainability under historical market cycles and economic downturns
- Preparing board presentations on spending policy performance and long-term feasibility
- Comparing alternative spending methodologies to optimize distribution consistency while preserving corpus
You might also like
You can systematize your monthly bank and credit card reconciliations, cutting reconciliation time by 40-50% while catching errors before they compound. This skill matches transactions between your accounting software and bank statements, explains variances, identifies outstanding items, and maintains clean financial records across checking accounts, savings accounts, business credit cards, and lines of credit.
by skyremote
This skill structures raw trial balances and transaction logs into consolidated financial statements with documented elimination entries and variance explanations. You submit entity-level data and intercompany transaction records, and Claude identifies reconciliation gaps, flags material variances (>$25K thresholds), and generates audit-defensible consolidation workpapers. It reduces close cycle time by 40-60% while improving control documentation for SOX compliance and external audit reviews.
by skyremote
You can move beyond simple variance reporting to conduct root-cause analysis that separates temporary fluctuations from structural changes in your budget. This skill enables you to rebuild forecasts with documented assumptions, materiality thresholds, and decision logic—ensuring your budget guidance remains credible with leadership while staying responsive to business changes. You'll create audit-ready variance explanations and reforecasting narratives that bridge accounting actuals and operational planning.
by skyremote
You can establish proper fund accounting structures that distinguish between restricted donations (mission trips, building funds, benevolence) and unrestricted giving, then reconcile your church's bank statements against pledge and donation records monthly. Claude generates detailed reconciliation reports, identifies discrepancies between cash received and recorded pledges, and produces financial statements that demonstrate sound stewardship to your church council, donors, and tax authorities.
by skyremote
You can calculate exact financial runway in days and months with confidence ranges, stress-test assumptions across conservative/base/aggressive scenarios, and determine optimal fundraising timing and target amounts. The skill generates monthly cash position forecasts, sensitivity analyses showing impact of key assumption changes, and board-ready financial dashboards that inform both internal strategy and investor communications.
by skyremote
You can efficiently reconcile contractor expense reports against receipts and bank statements, manage reimbursements across multiple clients or project codes, and automate billing workflows that reduce errors and accelerate payment cycles. The system validates documentation for audit readiness, tracks contractor tax obligations, and maintains separate audit trails for each client—protecting you from compliance exposure while streamlining your freelance bookkeeping operations.
by skyremote
You can systematically match payroll system records against W-2/1099 draft forms, validate all critical wage boxes (Box 1, Box 2, Box 5), cross-check quarterly 941 filings against annual totals, and reconcile 1099-MISC/1099-NEC contractor payments. This skill surfaces compliance issues, identifies discrepancies, and creates exception reports with audit trails—ensuring your year-end tax documentation is accurate and IRS-ready before submission.
by skyremote
You can parse complex appropriations language to identify spending authority, time restrictions, and compliance requirements specific to your agency's funds. This skill extracts key constraints from appropriations bills, congressional committee reports, and guidance documents, then maps them to your fund structure to create actionable compliance frameworks. It helps you evaluate whether proposed obligations comply with legislative language and reduces the risk of anti-deficiency violations before funds are committed.
by skyremote