Nonprofit Endowment Spending Rate Calculator
Calculates your annual endowment spending amount using a 3-year rolling average of market value — the standard method for smoothing market volatility — then checks that rate against the common UPMIFA prudence threshold, tests whether your fund is "underwater," and shows how much of this year's actual spending is being funded by real investment growth versus drawn from the corpus itself. Built for nonprofit finance committees and boards setting or reviewing an endowment spending policy, who want to see the real dollar consequences of their spending rate before the fiscal year, not after.
Download This Calculator
Get the Excel spreadsheet behind this calculator to use offline, customize for your needs, and publish as a web tool using Sheetflow.
3-Year Rolling-Average Spending
Applies your spending rate to a 3-year rolling average of market value instead of a single day's balance, smoothing out market volatility the way real endowment policies are designed to.
Automatic UPMIFA Prudence Check
Flags spending rates above the commonly cited 7% UPMIFA threshold, so a board considering a higher rate knows it needs a documented prudence rationale rather than a routine approval.
Underwater Test & Principal Erosion
Compares current market value against historic dollar value to test whether the fund is underwater, and shows how much of this year's spending is coming from real growth versus the corpus itself.
Frequently Asked Questions
Why do endowment spending policies use a rolling average instead of the current market value?
Because applying a spending rate directly to whatever the endowment happens to be worth on a single date makes annual program funding swing with the stock market — a bad year forces a budget cut exactly when donors and beneficiaries need stability most, and a great year tempts a board into spending increases that aren't sustainable long-term. A rolling average (commonly 3 to 5 years) smooths that volatility out.
Using the calculator's defaults: market values of $4,200,000 (most recent), $4,000,000 (one year prior), and $3,700,000 (two years prior) average to $3,966,667. A 5% spending rate applied to that rolling average gives $198,333 — a more stable number than 5% of whatever the endowment is worth on the specific day the budget gets set, which could have been meaningfully higher or lower depending on market timing alone.
What spending rate is considered "prudent" under UPMIFA?
The Uniform Prudent Management of Institutional Funds Act (UPMIFA), adopted by most states, doesn't set a hard legal cap, but spending above roughly 7% of the endowment in any given year is widely considered imprudent by courts, attorneys general, and nonprofit accounting practitioners. Most nonprofit spending policies cluster in the 4-5.5% range specifically to stay well clear of that line.
Using the calculator's defaults, a 5.0% spending rate falls comfortably within the commonly accepted range. The calculator flags this automatically — if your board is considering a rate above 7%, that's worth a specific, documented justification (UPMIFA does allow boards to spend above the threshold if they can show why it's prudent under the circumstances), not a routine budget decision.
What does it mean for an endowment fund to be "underwater," and does it change what I can spend?
A fund is underwater when its current market value has fallen below its historic dollar value — generally the original gift amount plus any subsequent contributions to that same fund. Historically, underwater funds triggered strict spending restrictions in some states, but UPMIFA relaxed this: a board can generally still spend from an underwater fund if it determines that doing so is prudent, considering the purposes of the fund and the organization's overall financial situation — though many boards choose to pause discretionary spending from underwater funds as a matter of policy caution, even where not strictly required.
Using the calculator's defaults, a $3,500,000 historic dollar value against a $4,200,000 current market value means this fund is not underwater — there's a $700,000 cushion above the original gift value. If the current value had fallen below $3,500,000, the calculator would flag the fund as underwater and the board's spending decision would warrant additional documentation of its prudence rationale, even if spending isn't legally prohibited.
How do I know if my endowment spending is actually sustainable long-term?
Compare your suggested spending rate (target real return + expected inflation) against your actual adopted rate, and separately check whether your actual investment return each year is keeping pace with what you're spending. Using the calculator's defaults, a 3% real return target plus 2.5% expected inflation suggests a 5.5% spending rate — slightly above the 5.0% the board actually adopted, meaning the adopted policy is conservative relative to the standard framework, a reasonable and common choice.
But policy sustainability and any single year's result are different questions. This year's actual investment return came in at 4% — below the 5% rate applied to the rolling average — so $30,333 of the $198,333 spent this year is effectively coming out of the endowment's principal rather than being funded by growth, even though the underlying policy is sound. That's not a crisis in a single year (it's exactly what the rolling-average method is built to absorb), but a board that sees this every year for several years running should treat it as an early signal to revisit the spending rate or investment strategy, rather than waiting for the fund to become visibly underwater before acting.
Should I factor inflation into my endowment spending rate?
Most nonprofit finance committees do, because failing to account for inflation slowly erodes the endowment's real purchasing power even if the dollar value looks stable or growing. The common approach — used in the calculator's "Suggested Spending Rate" — starts with a conservative, inflation-free expected real return, then adds your expected inflation rate to get a nominal spending rate that should preserve purchasing power over time.
Using the calculator's defaults, a 3% real return target plus 2.5% expected inflation gives a 5.5% suggested rate. If your adopted spending rate sits meaningfully below that suggested figure over a sustained period, the endowment's real (inflation-adjusted) value should grow over time, assuming actual investment returns track the target. If your adopted rate sits meaningfully above the suggested figure for multiple years running, you're likely spending down the endowment's real value even if the nominal dollar figure appears stable — a distinction that becomes very visible in the Principal Erosion figure over a multi-year run of this calculator, but can be easy to miss looking at any single year's balance sheet alone.
Transform Your Excel Models into Web Tools
Turn your complex Excel calculations into online calculators, web forms, and APIs. No coding required — upload your spreadsheet and publish your calculations instantly.
Calculations are for estimation and planning purposes. Users should verify important results for their specific situations. No signup required. Calculations performed securely.