Endowment Spending Rate Calculator Formula
Understand the math behind the endowment spending rate calculator. Each variable explained with a worked example.
Formulas Used
Annual Spending
annual_spending = endowment_value * spending_rate_pct / 100Sustainable? (spend <= real return)
sustainable = spending_rate_pct <= real_return ? 1 : 0Real Return Rate
real_return_pct = real_returnNet Annual Endowment Growth
endowment_growth = endowment_value * (expected_return_pct - spending_rate_pct - inflation_rate_pct) / 100Variables
| Variable | Description | Default |
|---|---|---|
endowment_value | Endowment Market Value($) | 50000000 |
spending_rate_pct | Annual Spending Rate(%) | 5 |
expected_return_pct | Expected Annual Return(%) | 7 |
inflation_rate_pct | Inflation Rate(%) | 3 |
real_return | Derived value= expected_return_pct - inflation_rate_pct | calculated |
How It Works
How Endowment Spending Works
Endowments are designed to provide perpetual funding. The spending rate must be low enough that investment returns preserve the real (inflation-adjusted) value of the endowment.
Formula
Annual Spending = Endowment Value x Spending Rate
Sustainable if Spending Rate <= Expected Return - Inflation
Common Practice
Worked Example
A $50M endowment with 5% spending rate, 7% expected return, 3% inflation.
endowment_value = 50000000spending_rate_pct = 5expected_return_pct = 7inflation_rate_pct = 3
- 01Annual spending: $50M x 0.05 = $2,500,000
- 02Real return: 7% - 3% = 4%
- 03Spending (5%) > Real return (4%): Not sustainable long-term
- 04Net growth: $50M x (7 - 5 - 3)/100 = -$500,000 per year
Ready to run the numbers?
Open Endowment Spending Rate Calculator