Gift Range Chart Calculator
Enter your campaign goal and the pyramid recalculates: gift sizes, gifts needed, prospects to identify, cumulative share of goal. The number to look at is total prospects. If it exceeds the people you could name, the goal is wrong, and finding that out before announcing costs nothing.
Enter your campaign goal in one cell and the whole pyramid recalculates: gift sizes at each level, how many gifts you need, how many prospects you must identify, and the running total as a share of goal.
Free Excel download. Every published gift range chart we could find is a static example built around somebody else’s number, which is not much use, because the entire point is the arithmetic against yours.
What it calculates
| Column | What it does |
|---|---|
| Gift size | A share of your goal, from a lead gift at 20 percent down through seven levels |
| Gifts needed | How many at that level, editable |
| Prospects needed | Gifts multiplied by a prospect ratio, four to one at the top and two to one at the base |
| Subtotal and cumulative | What each level contributes and where you stand running down the chart |
| Cumulative share of goal | The number that shows whether the top of the chart carries the campaign |
Four summary figures underneath: top gift as a share of goal, top three levels as a share of goal, total prospects you must identify, and total gifts needed.
The number to look at
Total prospects. Everything else on the sheet is arithmetic; that figure is a judgement about your organization.
If a $1m campaign tells you to identify around 250 qualified prospects, and your entire donor file is 400 people of whom 30 have ever given more than $500, the goal is not achievable as structured. That is worth knowing before a board votes on a number and announces it publicly.
The chart is the cheapest reality check available in campaign planning, and its value is almost entirely in being built before the goal is fixed rather than after.
The percentages are convention, not research
The default shape uses a lead gift at 20 percent of goal. Published guidance ranges from 10 to 25 percent, and sources disagree with one another substantially. These are generalised consulting experience rather than measured findings.
Column B is editable for that reason. If your organization has one obvious lead donor capable of carrying a third of the goal, model that. If your giving is unusually broad, flatten the top and add levels at the base. The structure is a starting point to argue with.
What does not change is the underlying logic: campaigns are top-heavy, the top ten gifts usually carry at least half the goal, and no amount of enthusiasm at the base compensates for an empty top.
Why campaigns are top-heavy
The shape of the chart is not a stylistic choice, and understanding why it looks like this stops people flattening it when the top feels uncomfortable.
Wealth is distributed unevenly, and philanthropic capacity more unevenly still. In any donor file, a small number of people can give amounts that the majority cannot approach at any level of enthusiasm. A campaign that tries to reach its goal through breadth is attempting to overcome that distribution with volume, and the arithmetic does not permit it.
Consider what flattening actually requires. Replacing a single $100,000 lead gift with gifts of $2,500 means finding forty additional donors at a level most organizations have only a handful of, and then finding roughly eighty prospects to yield them. That is not a harder version of the same plan. It is a different and much larger organization’s plan.
This is also why the top of the chart is solicited first. Those gifts are the campaign, and everything below them is confirmation that the campaign is real. Organizations that begin with the base tend to raise a respectable amount of money and then stall, because the remaining gap is one that only major gifts can close and the momentum to ask for them has gone.
Setting the goal honestly
Most goals arrive from the wrong direction. Someone costs a building, adds a contingency, and that number becomes the campaign. The chart is then built to justify it.
Reverse the order. Build charts at three goals, look at the prospect counts each demands, and pick the one you can actually name people against. If the project genuinely costs more than your file can support, that is a real finding and it has real answers: phase the project, extend the timeline, seek institutional funding for a portion, or reduce scope.
None of those are comfortable, and all of them are better than announcing a number and missing it publicly. A campaign that closes at 70 percent of a goal it should never have set does more damage to donor confidence than a smaller campaign that succeeds, and the damage lasts into everything you ask for afterwards.
The chart’s discipline is that it turns an aspiration into a list of people. Aspirations survive scrutiny. Lists of people do not, and that is exactly what you want from a planning document.
How to use it properly
Build it before you set the goal. Not after. Try three goals and see which one produces a prospect count you can actually name people against.
Write real names against the top three levels. Not categories, not “local businesses”. If you cannot name them, you do not have a campaign yet, you have an intention.
Apply the prospect ratio honestly. Three or four qualified prospects per gift means people who could plausibly give at that level and have some existing relationship with you. A name on a wealth screening list is not a qualified prospect.
Keep it visible. Track actual gifts against the chart as they come in. Levels that fill slowly are early warning, and the top filling slowly is the only warning that really matters.
Worked example at $500,000
The default structure applied to a half million dollar goal, to show what the sheet produces.
| Level | Gift size | Gifts | Prospects | Subtotal | Cumulative |
|---|---|---|---|---|---|
| 1 | $100,000 | 1 | 4 | $100,000 | 20% |
| 2 | $50,000 | 2 | 8 | $100,000 | 40% |
| 3 | $25,000 | 4 | 12 | $100,000 | 60% |
| 4 | $12,500 | 8 | 24 | $100,000 | 80% |
| 5 | $5,000 | 16 | 48 | $80,000 | 96% |
| 6 | $2,500 | 30 | 60 | $75,000 | 111% |
| 7 | $1,250 | 60 | 120 | $75,000 | 126% |
Two things to notice, and both are the point of building it.
The chart overshoots. That is deliberate and normal: you plan for more than the goal because not every gift lands. If your chart totals exactly 100 percent, it is too tight.
And the prospect column totals 276. For a $500,000 campaign you need to identify, qualify and cultivate around 276 people, of whom 24 must be capable of $12,500 or more. If your file cannot support that, adjust the goal now rather than discovering it in month eighteen.
What it does not tell you
Whether those people will actually give. The chart is capacity arithmetic, and capacity is only half of it. A prospect with the means and no relationship is not a prospect, they are a name.
That gap is what cultivation is for, and it is why the chart belongs alongside a working pipeline rather than instead of one. See moves management and our free tracker.
It also says nothing about timing. A chart showing 40 gifts needed does not tell you they arrive evenly, and campaigns are usually slow for far longer than anyone expects before the top gifts land. Judge progress against the top of the chart rather than against the calendar.
The full argument about phases, feasibility studies and pledges is in our guide to capital campaigns.
Download this template
Free, no email address, no signup. The full text is on this page as well, so you can read it before you download it.
Questions people ask
What is a gift range chart?
A table that works backwards from a campaign goal to show how many gifts you need at each size and how many prospects you must identify to secure them. Also called a gift table or a gift pyramid.
A typical structure has a lead gift at 10 to 25 percent of the goal, then descending levels with progressively more gifts at each, and three or more qualified prospects identified per gift needed.
Its purpose is not presentation. It is to test whether the goal is achievable with the donors you actually have, before anyone commits to a number publicly.
How do you calculate a gift range chart?
Start with the goal. Set the lead gift as a share of it, commonly between 10 and 25 percent. Then build descending levels, roughly halving the gift size and doubling the number of gifts at each step, until the cumulative total reaches the goal.
For each level, multiply gifts needed by a prospect ratio: four or five prospects per gift at the top, three in the middle, two at the base. Sum that column to get the total number of qualified prospects the campaign requires.
Our free calculator does all of this from a single goal input, and the levels remain editable.
How many gift levels should a chart have?
Eight to twelve for a large campaign, five or six for a small one. Our template uses seven, which suits campaigns in the hundreds of thousands to low millions.
Too few levels and the jump between them is so large that donors fall into gaps. Too many and the chart becomes unreadable and implies a precision the planning does not have.
The count matters less than the shape. What matters is that the top few levels carry most of the goal, because that is how campaigns actually behave.
How many prospects do you need per gift?
Three as a general convention, and four to five for the top levels where the loss of a single prospect matters most.
The ratio exists because not every ask succeeds, some prospects turn out to lack the capacity attributed to them, and circumstances change over the years a campaign runs.
Apply it honestly. A qualified prospect is someone who could plausibly give at that level and has an existing relationship with your organization. A name from a wealth screen with no connection to you does not count, and counting them is how charts end up describing campaigns that never happen.
What is the rule of thirds in fundraising?
An older convention holding that the top gifts produce roughly a third of a campaign goal, the middle band the next third, and the broad base of small gifts the final third.
It is now generally regarded as too flat. Modern campaigns are considerably more top-heavy, with the top ten to fifteen gifts frequently delivering more than half the total.
Treat it as a historical rule rather than a planning basis. If your chart looks like the rule of thirds, the top is probably too thin and the campaign will stall waiting for volume that never arrives.
Should you show the gift range chart to donors?
Yes, selectively, and it is more persuasive than most campaign material.
Showing a prospect the chart makes the ask concrete. It demonstrates that the goal is planned rather than invented, and it shows exactly where their gift would sit and what it makes possible. Some donors respond directly to seeing an empty slot at a level they could fill.
Use judgement about which version. A chart showing an unfilled lead gift can read as an organization in trouble, so lead gift conversations usually work better before that becomes visible.
What if we cannot fill the top of the chart?
Lower the goal, extend the timeline, or do not run the campaign yet. Those are the three honest options and organizations routinely choose a fourth, which is to proceed and hope, and that is how campaigns stall publicly.
An empty top cannot be compensated for at the base. If the top three levels represent half the goal and you can name one plausible prospect for them, no amount of community fundraising closes that gap.
Discovering this while planning is the chart working correctly. It is doing its job precisely when it delivers the answer nobody wanted.
Does this work for non-capital campaigns?
Yes. The arithmetic applies to any goal-driven effort with a defined target: an endowment campaign, a major expansion, a large restricted project, even an ambitious annual fund year.
What changes is the shape. Annual fund giving is flatter than capital giving, so the top will carry a smaller share and the base more, and the prospect ratios can be looser because you are working with a known file rather than seeking new major donors.
Edit the percentages in column B accordingly. The structure holds; the distribution is yours to set.
This is reference information, not legal or tax advice. Rules vary by state and change over time. For a decision that carries real consequences, check the current text at irs.gov or your state registry, and talk to a nonprofit attorney or CPA.