Endowment Payout Projection
Adjust inputs to model gift distributions across a multi-year payment timeline.
Inputs
Q1 Jan–Mar · Q2 Apr–Jun · Q3 Jul–Sep · Q4 Oct–Dec
Summary
Year-by-Year Projection
11 Years| Yr | First Quarter Earnings Available | Payment Received | Endowment Market Value | Annual Distribution | Assessment | Net After Assessment | Quarterly Payout | Supplement Needed |
|---|
Look up an endowment
Enter an endowment account number to fill in its market value, payout and balances from the G&I dashboard exports.
Add or replace the dashboard exports
Exports added here are shared with everyone who uses this site, so one person can keep them current. Only the columns the lookup needs are kept. A newer export of the same report replaces the older one; campus and foundation exports of the same report are both kept.
New donor scenario
- 1 · Fund
- 2 · Balances
- 3 · Gifts
- 4 · Timing
- 5 · Award
- 6 · Review
Which fund is this?
Name the scenario the way you'd want to find it later. If you're comparing options for the same donor, add the variant to the name.
What are the balances today?
Use the fund's own accounts, not a consolidated dashboard balance. Check "not sure" for anything estimated; it will be listed as an item to confirm.
Any gifts already committed? (optional)
Working out what's needed? Skip this step. Set the payout you want on the next steps and the result shows the endowed gift needed to reach it. Only add gifts here if they're already promised, like a pledge schedule or a match.
| Date | Account | Type | Amount | Status | Note |
|---|
When do distributions start?
These rules were discussed inconsistently, so they stay editable and can be flagged for confirmation.
What should it fund?
Leave the target blank to show only the amounts available to award.
Review
Check the inputs and the preview. You can change anything later in the Inputs panel.
How much more does the endowment need?
Enter the endowment and the annual payout the donor wants. You'll get the additional endowed gift needed to get there.
The endowment
More settings
The answer
When can the endowment fully fund the award?
Quarterly, dated projections that keep historical gift value, market value, the spend account, and the non-endowed spend-down account separate. Every timing rule is an editable assumption, and items that still need confirmation are listed with each scenario.
Scenario
Inputs
Fund & starting balances
Threshold & distribution timing
Assessment
Award
Reporting
Summary
Items to confirm before this is donor-ready
Contributions & transactions
| Use | Date | Account | Type | Amount | Status | Note |
|---|
Gift structures: what the donor could give
| Structure | Endowed gift | Gift date | Cash per year | Years | First FY |
|---|