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 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 comprehensively analyze existing endowment and trust spending policies for legal soundness and strategic alignment with organizational goals. The skill evaluates policies against UPMIFA, state law, and fiduciary standards while modeling spending impacts under different market scenarios. You'll document policy rationale, identify compliance gaps, and generate frameworks for new or revised spending policies with supporting calculations for audit and board presentation.
by skillslib
You can quickly organize transaction data, categorize business expenses correctly, calculate estimated quarterly tax payments, and identify deduction opportunities specific to independent bookkeepers. The skill helps you manage the dual burden of tracking multiple client books while maintaining accurate personal finances, flagging tax risks and opportunities before filing season arrives.
by skyremote
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
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 systematically examine financial documents, trace complex transaction schemes, and quantify damages or illicit activity using a repeatable methodology designed for courtroom presentation. The framework embeds legal standards into your analytical process, ensuring your findings remain defensible under cross-examination and maintain the evidentiary chain required in litigation. You'll transform raw financial data into compelling expert witness reports and rebuttal analyses that opposing counsel cannot easily dismantle.
by skyremote
You can develop data-driven fund allocation strategies that honor donor intent while optimizing your program expense ratio and maintaining financial reserves. This skill helps you navigate the complex constraints of restricted vs. unrestricted funds, regulatory compliance, and board-mandated reserve policies to create allocation plans that strengthen stakeholder confidence and improve organizational sustainability.
by skyremote
You can rapidly build comprehensive multi-dimensional financial models spanning multiple business units and geographies, then run parallel scenario analysis (base case, bull case, bear case, regulatory) with automated variance testing. Claude structures complex financial logic, validates model assumptions, identifies formula dependencies, and generates executive summaries that distill strategic insights for board-level decisions—eliminating spreadsheet bottlenecks and manual recalculation errors.
by skyremote