Calculators

Donor Pyramid Gift Mix Planner

Estimate a hypothetical fundraising gift mix across donor tiers. Enter a total goal, the number of gifts planned at each tier, and the average gift for each tier. The model multiplies counts by average gifts and adds the tier totals. It assumes every planned gift is received at its stated average, with no pledges, fees, timing, or donor behavior modeled.

Loading calculator...

What this Donor Pyramid Gift Mix Planner does

The Donor Pyramid Gift Mix Planner estimates the combined value of planned gifts across three fundraising tiers. It multiplies the number of gifts in each tier by that tier’s average gift, then adds the three subtotals. Its result, Projected Gift Total ($), is a simple planning figure for a campaign worksheet.

The model uses six inputs: Lead gifts (count), Lead tier average gift ($), Mid-level gifts (count), Mid-level average gift ($), Community gifts (count), and Community average gift ($). The description states the assumptions clearly. It treats each planned gift as received at the stated average. It does not account for timing, pledges that go unpaid, fees, donor behavior, or the likelihood that a gift will be secured.

A donor pyramid is a way to organize a fundraising goal into gift levels. The labels here are broad planning categories. Each organization should define its tiers in a way that fits its campaign, donor community, and past records. The tool does not prescribe giving levels or establish a universal pyramid shape.

How to use the Donor Pyramid Gift Mix Planner

Start with a fundraising goal or draft gift table. Enter a whole number for each planned gift count and an average dollar amount for the corresponding tier. The defaults are examples for exploring the arithmetic. Replace them with assumptions that your team can explain and review.

  • Lead gifts: enter the number of gifts planned in the lead tier and the average dollar value assumed for each.
  • Mid-level gifts: enter the planned count and average for that segment.
  • Community gifts: enter the count and average for the broader community tier.

For example, suppose a volunteer committee models 2 lead gifts averaging $5,000, 20 mid-level gifts averaging $1,000, and 100 community gifts averaging $100. The formula gives (2 × $5,000) + (20 × $1,000) + (100 × $100), or $10,000 + $20,000 + $10,000. The projected gift total is $40,000. This is the output of the assumptions, not a forecast that those gifts will arrive.

Counts can be set to zero if a tier is not part of the plan, and average gifts may also be zero. Because the formula only multiplies and adds, zero values are valid and do not create a division-by-zero issue. Inputs have maximum limits, so if your campaign is larger than those limits, calculate separate segments or use a spreadsheet with an appropriately reviewed model.

How the Donor Pyramid Gift Mix Planner formula works

The formula is (lead_gifts × lead_average) + (mid_gifts × mid_average) + (community_gifts × community_average). Each pair represents a gift count multiplied by its average gift amount. The three tier subtotals are then added. Counts are dimensionless, and each average is in dollars, so each multiplication produces dollars and the sum remains in dollars.

This formula is a basic gift table calculation. It does not use a multiplier, probability, inflation adjustment, or a conversion rate. That simplicity makes the arithmetic easy to check: write each tier as “number of gifts × average amount,” calculate the subtotal, and add the subtotals.

If a team instead has a total amount and wants to estimate how many gifts are needed at an average size, that is a different calculation involving division. This planner does not answer that question because it asks for gift counts and averages directly. Keeping the input and output relationship visible helps prevent a planning worksheet from implying more certainty than its inputs support.

Use cases for the Donor Pyramid Gift Mix Planner

Fundraising teams and volunteer groups can use the calculation while drafting a campaign gift table. It can help compare scenarios, such as a plan with more smaller gifts versus one with several larger gifts, while showing the arithmetic behind each total. It can also support a meeting discussion by making the assumptions explicit instead of leaving a target as a single unexplained number.

For instance, a community organization coordinating a benefit event might create one scenario based on sponsorship conversations and another based on individual donor outreach. The model can total each scenario, provided the counts and averages are understood as planning assumptions. A volunteer coordinator could also use it to illustrate how several tiers contribute to a shared campaign goal.

Useful ways to apply the result include:

  • Drafting a gift table for an annual appeal or event.
  • Comparing alternative mixes of gift counts and averages.
  • Communicating how a proposed total is built from tiers.
  • Spotting which assumptions need follow-up or supporting evidence.

Use separate, clearly named scenarios when comparing plans. Record the source of the assumptions, such as past campaign results, documented commitments, or a planning discussion. Avoid presenting a hypothetical total as pledged revenue or guaranteed income.

Other factors to consider when calculating a donor pyramid

A gift mix is only one part of campaign planning. Teams may need to distinguish confirmed gifts from targets, expected gifts from possible gifts, and one-time contributions from recurring commitments. Those distinctions matter because this calculator treats all entered gifts equally and adds their full average amounts.

Consider documenting these points alongside the output:

  • Whether each count refers to prospective, requested, pledged, or received gifts.
  • How the average for each tier was chosen and what period it represents.
  • Whether repeat donors or overlapping categories could be counted twice.
  • Which campaign costs or restrictions are outside the gross gift total.
  • How often assumptions will be reviewed as new information becomes available.

The displayed total is gross planned giving under the entered assumptions. It does not subtract fundraising expenses or restricted funds, and it does not measure campaign readiness. A realistic plan should be checked against the organization’s own records and reviewed as circumstances change. Treat the model as a transparent worksheet, then use judgment and appropriate organizational review when setting goals or communicating progress.

FAQ

What does a donor pyramid show?

A donor pyramid groups a fundraising plan into giving tiers. This calculator uses lead, mid-level, and community labels as a simple structure. Teams can define their own tier names and criteria to suit their campaign.

Does the projected gift total predict fundraising results?

No. It totals the counts and average gifts entered. It does not estimate whether donors will give, when funds will arrive, or whether pledged gifts will be completed. Use it as a scenario calculation rather than a prediction.

How should I choose average gift amounts?

Use a documented basis that makes sense for your campaign, such as relevant past results or clearly identified planning assumptions. The calculator does not supply benchmarks, so the team should explain where its figures came from.

Can one tier have no gifts?

Yes. Set its gift count to zero. Its subtotal becomes zero, and the other tiers still contribute to the total. The same arithmetic applies if an average gift is entered as zero.

Why is the result different from net funds raised?

The result adds the full modeled gifts. It does not subtract event or fundraising costs, account for restrictions, or adjust for collection timing. A separate financial review is needed to understand net proceeds and how funds may be used.

Written by

commongroundarlington.com Editorial Team

Editorial team

commongroundarlington.com publishes practical how-to guides and educational articles with clear steps and useful context.