Grant Pipeline Forecasting Worksheet

Why Grant Forecasting Is Hard

Grant revenue is different from individual donor revenue in ways that make standard forecasting approaches unreliable.

Multi-year awards create false certainty. When a foundation awards a three-year, $150,000 grant, organizations often book all $150,000 as “secured” revenue and plan accordingly. But years two and three of a multi-year grant are usually contingent on satisfactory performance, continued funder interest, and the funder’s own financial situation — none of which is guaranteed. Booking future years at 100% probability is an error that can create a significant budget crisis when a funder doesn’t renew.

Renewal uncertainty compounds over time. An organization’s track record with a funder is the strongest predictor of renewal, but even strong relationships end. Foundation priorities shift. Staff change. Economic conditions affect endowment performance, which affects grantmaking capacity. A grant in year three of a multi-year award is not the same as a grant that has been reliably renewed for seven consecutive years.

Application timing is unpredictable. Grant cycles don’t align with fiscal years. A grant applied for in November may not be decided until March. A prospect identified in January may have a next deadline in October. Managing grant revenue expectations requires translating application timelines into fiscal year projections — which introduces another layer of uncertainty.

The “applied for” problem. Many organizations report “grants applied for” as a meaningful pipeline metric. It isn’t. An application is not a revenue forecast — it is an expression of interest. Without probability weighting, a pipeline of $1.2M in applications tells you almost nothing useful about what you’ll actually receive.

A stage-weighted pipeline model solves all of these problems by making probability explicit, building multi-year discounting into the methodology, and giving your board a number they can actually use.

---

Pipeline Stage Definitions and Probability Weights

The following stage definitions and probability weights reflect the typical grant decision lifecycle. Your organization may need to adjust weights based on your historical win rates — if you have three or more years of pipeline data, compare your actual award rate at each stage to these benchmarks and calibrate accordingly.

Stage	Definition	Probability Weight
Prospect	Funder identified as potential fit; no research completed yet; no relationship established	5%
Research	Funder researched; confirmed alignment with your program areas; grant amount estimated; next deadline identified	15%
Concept / LOI	Concept paper or letter of inquiry submitted; awaiting invitation to apply or feedback	30%
Application Submitted	Full application submitted; awaiting decision	50%
Under Review	Application confirmed as under active review (program officer contact, site visit scheduled, references requested)	70%
Renewal In Progress	Active grant in final year; renewal application submitted or in preparation; prior relationship with funder	80%
Awarded	Grant agreement received and executed	100%
Declined / Dead	Application declined or funder confirmed not a fit; remove from pipeline	0%

Calibrating to your organization’s win rate:

The 50% weight for “Application Submitted” reflects a rough sector average for nonprofits applying to funders with prior relationships and reasonable fit. If your organization’s historical win rate at application stage is 35%, use 35%. If it’s 65% (perhaps because you only apply when you have strong relationships), use 65%. The weights are calibrated anchors, not fixed constants.

Why “Under Review” is higher than “Application Submitted”:

Being under active review — as evidenced by program officer outreach, site visits, or reference checks — is a meaningful positive signal. Funders that request a site visit or check references are investing in the relationship; they accept a minority of applications but site-visit an even smaller percentage. The 70% weight reflects this signal value.

---