What this Donor Pyramid Gift Distribution Calculator does
The Donor Pyramid Gift Distribution Calculator estimates the total gift value represented by three donor levels in a fundraising plan. Enter a number of donors and an average gift for each level. The result adds the estimated contributions from top-tier, middle-tier, and community donors into one projected gift total.
A donor pyramid is a planning model that groups prospective or actual contributors by gift size or relationship to a campaign. Fundraisers often use a pyramid to think through how a campaign goal might be supported by a smaller group of larger gifts and a broader group of more modest gifts. The shape and labels vary by organization, so this calculator uses three practical tiers that can be adapted to your own terminology.
The tool calculates a gross modeled total from the counts and average gifts you enter. It does not predict which people will give, whether a pledge will be fulfilled, or how much a campaign will ultimately raise. Treat the output as a worksheet result for discussion and planning.
How to use the Donor Pyramid Gift Distribution Calculator
Set a donor count and average gift for each tier. Counts are whole people, while gift amounts are entered in dollars. If you are building an initial plan, use estimates your team can explain and revise them when you have better information.
- Top-tier donors are the number of people assigned to your highest gift level.
- Top-tier average gift is the typical planned or observed contribution for that group.
- Middle-tier donors and gift represent the next group in your campaign structure.
- Community donors and gift represent the broadest group included in this simple model.
Check that each average gift reflects the same campaign and currency. If some gifts are already confirmed, you may include them in the relevant count and use an average that reflects those known commitments alongside your remaining assumptions. Avoid counting the same donor in more than one tier.
For example, imagine a volunteer-led campaign plans for 5 top-tier donors averaging $10,000, 25 middle-tier donors averaging $2,000, and 100 community donors averaging $100. The formula is (5 × $10,000) + (25 × $2,000) + (100 × $100). That is $50,000 + $50,000 + $10,000, for a projected gift total of $110,000. The result describes the entered plan. It is not a guarantee that those gifts will be received.
How the Donor Pyramid Gift Distribution Calculator formula works
The formula multiplies the donor count in each tier by that tier’s average gift, then adds the three subtotals. In compact form, it is top-tier donors × top-tier average gift + middle-tier donors × middle-tier average gift + community donors × community average gift.
Each multiplication estimates the dollars associated with one group. Adding the subtotals gives a combined amount. Because every input has a clear role, you can see which assumptions contribute most to the modeled total and change them to explore a different scenario.
The calculator does not derive a gift ladder from a campaign goal or calculate how many prospects are needed to secure a certain number of gifts. Those tasks need additional assumptions, such as the number of asks per expected gift and the likelihood that a prospect will respond. This tool keeps its scope to the arithmetic of the three entered donor groups.
Use cases for the Donor Pyramid Gift Distribution Calculator
Fundraising teams can use the estimate as a starting point for conversations about campaign structure. A small nonprofit may compare a community event plan with one that includes a concentrated group of larger gifts. A volunteer coordinator may review whether the proposed levels feel understandable to the people making asks. Board members can see how donor counts and average gifts combine into an overall target.
It can also support scenario planning. For example, you might keep the middle and community assumptions fixed while changing the top-tier count to see how dependent the plan is on a few large gifts. Or you might test a wider community base with a lower average contribution. These comparisons do not reveal which scenario is most likely. They clarify how the arithmetic responds to your assumptions.
When reviewing scenarios, consider recording the source and date of each estimate. Counts might come from a prospect list, an event audience, or prior campaign records. Average gift assumptions may come from prior giving patterns or from a team’s proposed ask amounts. Keeping the basis visible makes it easier to update the plan and explain changes to staff, volunteers, and supporters.
Other factors to consider when calculating a donor pyramid
A pyramid is a simplification of relationships. Donors may give more than once, pledge over time, contribute in kind, or change their plans. Some campaigns count commitments while others count received funds. Decide what the modeled amount represents before sharing it, and use a consistent definition throughout the worksheet.
Also consider whether tiers fit your community. A campaign with many small gifts may need different group labels or more levels than this calculator offers. If you have several groups, you can calculate subtotals separately and combine them in a spreadsheet, taking care to avoid duplicate donors and inconsistent gift periods.
Useful checks before relying on a scenario include:
- Confirm that the donor counts are plausible for the people your team can reach.
- Make clear whether average gifts are goals, historical averages, or confirmed amounts.
- Review whether any large gifts are counted in more than one tier.
- Keep a separate record of pledges, received gifts, and unconfirmed expectations.
- Revisit assumptions as conversations and campaign results provide new information.
Campaign expenses, payment timing, restrictions on gifts, and donor retention are outside this formula. If you need a net amount after expenses, a cash-flow schedule, or a forecast based on response likelihood, use a model that explicitly includes those inputs. The projected gift total here should remain labeled as a simple scenario estimate.
Frequently asked questions
What does a donor pyramid show?
It organizes a fundraising plan into donor groups, often by gift size or campaign role. A pyramid can help a team discuss how different groups contribute to a target, but it does not determine whether donors will make the proposed gifts.
Can I change the tier names?
Yes. The labels are general. You can interpret top-tier, middle-tier, and community donors using terminology that makes sense for your organization, as long as each donor is assigned to one group and the inputs remain clear.
Does the result include fundraising costs?
No. The result adds the gift amounts implied by the entered counts and averages. It does not subtract event costs, payment processing charges, staff time, or other expenses.
Can this calculator tell me how many people to ask?
No. It uses donor counts as inputs. Estimating how many people to approach would require a separate assumption about how often an ask leads to a gift, plus a defined campaign goal and approach.
Should I enter pledges or received gifts?
Use a consistent basis for every tier. You may model expected pledges or gifts already received, but label the scenario clearly and do not mix categories without explaining what the total represents.