# Endowment Fund Model Model an endowment asset allocation, investment returns, annual spending, and perpetual sustainability to ensure spending grows with inflation. Stress-test the spending policy against multi-decade bear markets and model alternative allocations to reach return targets. - Canonical: https://finamodel.com/templates/endowment-model - Excel download: https://finamodel.com/templates/endowment.xlsx - Category: Capital Markets - Model type: Portfolio - Difficulty: Intermediate - Audiences: Fund managers, Public sector, Endowment managers, University finance, Investment committees, Institutional investors - Tags: endowment, allocation, spending-policy, perpetual, sustainability ## Overview An endowment fund financial model projects the growth and sustainability of a perpetual investment portfolio funding annual distributions to operating budgets. For a university or foundation with $1 billion in assets, the model allocates capital across public equities (40%), fixed income (20%), private equity (18%), real assets (10%), hedge funds (10%), and cash (2%), applies multi-asset-class return assumptions (7.5% equities, 4.5% bonds, 11% private equity), and compounds the portfolio year-over-year. Against this growing asset base, a spending policy (typically 4–5% of a trailing three-year average) funds annual distributions to the institution's operating budget, with inflation adjustments to preserve real purchasing power. The model validates that the endowment's real corpus (inflation-adjusted value) is preserved or grows over the projection horizon. Key risks include sequence-of-returns (a bad market early in a spending cycle can force forced selling at low prices), high fees in private assets (which drag net returns), and the temptation to increase spending when markets are strong. The workbook shows how different spending rates and return assumptions affect long-term sustainability, making it clear that a 3% spending rate on a poorly-allocated portfolio is more sustainable than 5% spending on a well-diversified one. This template is standard for institutional wealth managers, university treasurers, and foundation boards evaluating endowment policy and asset allocation targets. ## What's included - Multi-asset allocation: equities, fixed income, real estate, hedge funds, and private equity - Return assumptions by asset class with correlation and rebalancing logic - Annual spending policy based on rolling average value - Inflation adjustment and real purchasing power preservation - Long-term asset growth, solvency stress testing, and payout sustainability - Multi-asset allocation: equities, fixed income, real estate, hedge funds, private equity - Annual spending policy (typically 4–5% of rolling average value) - Long-term asset growth and solvency stress testing - Payout sustainability and capital needs scenarios ## Endowment Fund Model: A Guide to Perpetual Spending and Portfolio Sustainability An endowment fund model is a structured financial tool for evaluating how a perpetual pool of donated capital can fund annual operating distributions while preserving intergenerational equity. This guide outlines the core mechanics: diversified asset returns, fee structures, smoothing-based spending rules, donation inflows, and validation checks that together test whether spending grows with inflation over a ten-year horizon. ### Key Operating Drivers: Allocation, Returns, and Fees The model's operating drivers begin with a diversified asset allocation across public equities, fixed income, private equity, real assets, hedge funds, and cash. Each class carries its own expected return and fee rate, so portfolio outcomes depend on both the weight mix and class-level performance. - Investment returns accrue as yield plus appreciation, and fees include base management charges, performance fees for private equity above a hurdle, and internal operating costs. Donations add a philanthropic inflow, typically growing annually, while spending distributions represent the primary outflow. - Together, these drivers determine whether the endowment grows in real terms or erodes over time. ### Calculation Flow: From Assumptions to AUM Rollforward The calculation flow moves from assumptions to asset allocation, then to gross returns and fee schedules. The core engine is the AUM rollforward: beginning assets plus donations, minus spending payout, fees, and internal opex, plus gross investment return, yielding ending assets. - Spending uses a trailing three-year average AUM, which smooths market volatility rather than applying the rate to current-year assets. Fees are calculated on beginning AUM to avoid circularity, and private equity performance fees reference gross returns above a hurdle. - Ending AUM feeds the next year's allocation, and rebalancing realigns weights to targets, creating a multi-year cycle. ### Outputs: Performance Metrics and Sustainability Checks Key outputs include nominal and real returns, the total expense ratio, spending as a percentage of AUM, and the real corpus preservation ratio. - The real corpus preservation check divides ending AUM by the beginning AUM inflated over the projection period, requiring a result of at least 1.0 by the final year to confirm the endowment has not shrunk in purchasing power. - Additional checks verify that allocation weights sum to 100%, the AUM rollforward balances, cash never goes negative, and the spending rule is correctly applied. - These metrics help users assess whether the spending policy and portfolio strategy are sustainable across a multi-decade horizon. ### Practical Use: Stress-Testing and Decision Support In practice, this model supports stress-testing spending policies against adverse market sequences and comparing alternative asset allocations to meet return targets. - By adjusting inputs such as spending rate, smoothing period, expected returns, and donation growth, users can explore trade-offs between current distributions and long-term corpus preservation. - The structure separates realised and unrealised cash flows, tracks restricted versus unrestricted net assets, and includes liquidity tiers to manage private capital calls. - Validation checks flag issues like weight drift, cash shortfalls, or spending above sustainable levels, making the model a useful tool for fiduciary deliberation and policy design. ## Inflation-adjusted spending policy Model real spending targets that maintain purchasing power for beneficiaries across decades, using a rolling average value as the spending base. ## Rebalancing and allocation drift management Calculate periodic rebalancing to maintain target allocation, manage return volatility, and avoid concentration in outperforming asset classes. ## Long-term solvency stress testing Test endowment survival across recession scenarios and multi-decade bear markets to confirm the spending policy is sustainable through adverse cycles. ## Inflation-adjusted spending policy Model real spending targets that maintain purchasing power for beneficiaries across decades, using a rolling average value as the spending base. ## Rebalancing and allocation drift management Calculate periodic rebalancing to maintain target allocation, manage return volatility, and avoid concentration in outperforming asset classes. ## Long-term solvency stress testing Test endowment survival across recession scenarios and multi-decade bear markets to confirm the spending policy is sustainable through adverse cycles. ## Features - **Inflation-adjusted spending policy:** Model real (inflation-adjusted) spending to maintain purchasing power for beneficiaries across decades. - **Rebalancing and drift management:** Calculate periodic rebalancing to maintain target allocation and manage return volatility. - **Long-term solvency stress testing:** Test endowment survival across recession and multi-decade bear market scenarios. ## Use cases - **Spending policy review:** Test current spending rate against endowment returns and inflation to confirm policy is sustainable. - **Asset allocation review:** Evaluate whether current allocation meets return targets and risk tolerance over 20+ year horizon. - **Succession and capital campaign planning:** Project future endowment value and available payout to support strategic planning. ## Frequently asked questions ### What is an endowment fund model? It is a model that forecasts a perpetual fund asset growth, investment returns, and annual spending to confirm the fund can maintain purchasing power indefinitely. ### What is a sustainable endowment spending rate? Most endowments target 4 to 5 percent of a rolling 3-year average value annually, calibrated to preserve real purchasing power after inflation and fees. ### Why does endowment allocation differ from personal portfolios? Endowments have perpetual time horizons, so they can hold illiquid assets such as private equity and real estate and tolerate volatility in pursuit of long-term real returns. ### How do I model alternative asset returns? Use realistic net-of-fee returns, typically 6 to 9 percent for private equity and 5 to 7 percent for hedge funds, and apply a lock-up period to model illiquidity. ### Who uses endowment fund models? Endowment managers, university finance teams, investment committees, and institutional investors use them for spending policy review, asset allocation decisions, and capital campaign planning. ## Related templates - [Pension Fund Asset Allocation Model](https://finamodel.com/templates/pension-fund-model) - [Sovereign Wealth Fund Portfolio Model](https://finamodel.com/templates/sovereign-wealth-model) - [Multi-Asset Portfolio Allocation](https://finamodel.com/templates/multi-asset-allocation-model)