BTHE BARATELLI INSTITUTE · Mentoring at Scale
FOR DEVELOPMENT DIRECTORS · GRANT WRITERS · EXECUTIVE DIRECTORS · BOARD FINANCE COMMITTEES

A grant pipeline isn't a list. It's an expected-value forecast — and most teams report the list.

The board asks "what's the pipeline worth?" and gets a sum of ask amounts. That number is wrong by 4-8x. This tool does what a sales team would call basic discipline: stage-weighted probability on every prospect, time-to-decision modeled by funder type, coverage ratio against your annual grant target, and an honest capacity check against the 30-relationship-per-grant-writer reality. The version the board should be asking for.

Weighted $
Pipeline EV
Coverage
vs target
Cash timing
When it hits
Capacity
Per-FTE load
YOUR PIPELINE
1
Setup & target
2
Stage entry
3
Time to decision
4
Capacity & coverage
5
Recommendations
STAGE 1 OF 5

Pipeline setup & annual target

The target on the audited financials and the body count on the development team. Two numbers most pipelines get wrong before a single prospect is named.

What you raise grants for. Shapes funder fit, not the math.
The line on the board-approved budget labeled "Foundation & Corporate Grants." Not total contributed revenue — just grants.
$
Full-time equivalent staff whose primary job is grants. Two halftime people = 1.0. A development director who also runs the gala = ~0.4 if you're honest.
Industry-realistic load for foundation/corporate work: 25-35. Above 40 and quality declines (missed deadlines, generic LOIs, no cultivation visits).
Used as a sanity check against target. If you raised $280K last year and the target is $700K, the pipeline math has to justify the leap.
$
Used for cash-timing forecast. How long the current pipeline has to close before fiscal year end.
What this tool actually measures. Most grant pipeline reports sum ask amounts and call it pipeline value. That number is structurally inflated by 4-8x because it assumes 100% close rates. This tool applies stage-weighted probability (industry-standard CRM math), checks coverage ratio against target (healthy = 2-3×), models when the cash actually arrives by funder type, and flags whether you have enough grant-writer capacity to manage the prospects you've identified. Run it once with your real pipeline and you'll have a different conversation at the next board meeting.
STAGE 2 OF 5

Pipeline by stage

For each stage, enter how many prospects you have there and the total ask amount across them. Probability weights are industry-standard for foundation and corporate grants — adjust the count and dollar fields, not the probabilities. The math is shown at the bottom.

1 · Identified / Researched
10% Probability
Name on a prospect list. Research file built. No contact attempted yet. The most common pipeline-inflation trap: counting these at face value.
Prospects in stage
Total ask amount
$
Avg ask per prospect
$
2 · Contacted / Inquiry submitted
20% Probability
Letter of inquiry sent, program officer phone call, or a substantive intro. They know you exist.
Prospects in stage
Total ask amount
$
Avg ask per prospect
$
3 · Application invited / submitted
35% Probability
Full proposal in their hands. Either invited after LOI or submitted to an open RFP. Real commitment of writing capacity made.
Prospects in stage
Total ask amount
$
Avg ask per prospect
$
4 · Site visit / interview
60% Probability
Funder has engaged at the next level — site visit scheduled, interview held, or pre-decision diligence underway. The cultivation visit before the LOI is the single biggest predictor of getting here.
Prospects in stage
Total ask amount
$
Avg ask per prospect
$
5 · Board review pending
80% Probability
Recommended by program officer. Awaiting funder's board approval. Most funders honor program officer recommendations 85-90% of the time, but board surprises happen.
Prospects in stage
Total ask amount
$
Avg ask per prospect
$
6 · Awarded — awaiting check
100% Probability
Award letter received. Money committed. Check in the mail (or wire pending). The only stage that's actually cash.
Prospects in stage
Total ask amount
$
Avg ask per prospect
$
STAGE 3 OF 5

Time-to-decision & funder mix

What share of your pipeline sits with each funder type? Decision timelines vary by an order of magnitude — corporate is fast, federal is glacial. This is how you forecast when the weighted-pipeline cash actually hits the bank account.

Industry decision timelines. Family foundations: 60-180 days. Community foundations: 90-180 days (quarterly board cycles). Corporate giving: 30-90 days for local, 6-12 months for headquarters/national programs. Federal: 12-24 months. Most private foundations review quarterly or biannually — miss a cycle and you've added 90 days to "when the cash arrives."

Enter % of your total weighted pipeline value by funder type. Should sum to 100% (or close). The default mix is typical for a mid-size human-services nonprofit.

Avg cycle: 120 days. Often the warmest pipeline — relationship-driven.
%
Avg cycle: 135 days. Quarterly board cycles common.
%
Avg cycle: 60 days. Local store / region budgets, fast turnarounds.
%
Avg cycle: 270 days. Headquarters CSR programs, larger asks, slower committees.
%
Avg cycle: 540 days. NIH, HRSA, SAMHSA, etc. Long, technical, large.
%
DAFs, donor-circles, faith-based, professional associations. Default cycle: 120 days.
%
Time between award letter and first check landing. Foundation average: 30-45 days. Federal: 60-90 days (reimbursement model). This pushes cash-arrival even further right.
% of weighted pipeline that is multi-year (2-3yr) grants. Only Year 1 hits the current fiscal year — the rest is restricted future revenue. Industry typical: 20-35%.
%
STAGE 4 OF 5

Restriction mix & rejection-reactivation

Two practitioner adjustments most pipelines skip. (1) What share of the pipeline is general-operating vs. project-restricted? Both are real, but only one keeps the lights on. (2) Last year's rejections — the cheapest pipeline you have, if you cultivate them.

RESTRICTION HIERARCHY
Capacity-building → project → operating
Funders generally fund most-restrictive first — capacity-building (one-time, specific) is easier than project (multi-year, defined scope) which is easier than general operating (unrestricted, ongoing). Asking for the right type is often more important than asking for the right amount.
CULTIVATION VISIT
Pre-LOI site visit = biggest predictor
The single best-correlated input with eventual award is whether a cultivation visit happened before the LOI was submitted. The visit lets the funder edit your ask before the writing starts — and gives the program officer skin in the game.
REJECTION RE-ENGAGEMENT
First "no" often becomes 2nd / 3rd "yes"
Most funders that decline the first ask will fund on the 2nd or 3rd application if cultivation continues. Treat the rejection letter as the start of cultivation, not the end. The pipeline you already paid to build is the cheapest pipeline you'll ever have.
RESPECT THE GATE
"By invitation only" means it
Do not submit unsolicited proposals to foundations that publish "by invitation only." It wastes your writing capacity, signals naivete to the program officer, and almost always closes the door for the warm path you might have built in 18 months.
Unrestricted — the dollars that keep the lights on. Industry typical for foundation/corporate: 15-30%. Higher is rare and a sign of strong funder relationships.
%
Project-restricted with named scope. Industry typical: 55-70%. The majority of foundation funding lives here.
%
One-time, infrastructure, technology, planning. Often the fastest-to-fund category. Industry typical: 10-20%.
%
Funders that declined in the past 24 months but remain a fit. These should be in cultivation, not removed from the file.
% of those declined prospects you're still touching (thank-you, program update, re-invite to event). Best-practice teams hit 60-80%. If under 30%, you're leaving the cheapest pipeline on the table.
%
Pre-LOI program-officer visits scheduled in the next 90 days. The single best leading indicator of pipeline health 6-12 months out.
STAGE 5 OF 5

Pipeline value & recommendations

The weighted expected value, the coverage ratio against target, the cash-timing forecast, and the honest capacity check. Then the action items.

HERE, TRY THESE. THEY MAY HELP.

The grant pipeline is one of 16 development workflows.

The Family Office Guide and Estate Planning Decoded cover the funder-side mechanics: family-foundation governance, donor-advised fund engagement, board-level grant decision cycles, the 990-PF data that tells you a foundation's real giving pattern, and the planned-giving conversations that often live alongside an institutional grant. The grant pipeline is one chapter — the relationship operating model is the rest.

Read the Family Office Guide Estate Planning Decoded All free tools
Practitioner reference. Outputs are estimates based on user inputs. Probability weights are industry-standard stage-conversion rates for foundation and corporate giving; your funder's specific patterns may differ. Time-to-decision averages are typical, not guaranteed. Run with your actual pipeline; cross-check with your development director and CFO before reporting to the board. This is not financial, tax, or legal advice.
WANT THE METHODOLOGY BEHIND THIS TOOL?
This calculator pairs with Family Office Guide and Estate Planning Decoded.
The tool gives you weighted pipeline math. The guides give you the surrounding workflow — family-foundation governance, donor-advised fund engagement, 990-PF data interpretation, the board-side of grant decisions, and the planned-giving conversations that often live alongside an institutional grant. Pipeline math is one workflow; understanding the funder side of the table is what turns probability into a check.
Methodology references: FO Guide Ch 9 (Philanthropy operating model) and EPD Ch 7 (Charitable structures & planned giving).
Read the Family Office Guide → Browse all tools
PROFESSIONAL DISCLAIMER · PLEASE READ

Educational and informational purposes only. This calculator and any output it produces are intended solely for general educational and decision-support purposes. They do not constitute investment, tax, legal, accounting, fundraising-counsel, or any other professional advice, and they do not create a fiduciary, attorney-client, accountant-client, or advisor-client relationship of any kind.

Estimates based on your inputs. All results are estimates derived from the data and assumptions you provide. Stage-conversion probabilities are industry-standard practitioner benchmarks; your funder mix and historical patterns may differ materially. Time-to-decision averages reflect typical foundation and corporate review cycles and are not guaranteed. Tax law, accounting standards (including FASB ASC 958 and IRS Form 990), and the specific facts of your situation can materially change the answer. The Baratelli Institute, its affiliates, and any co-branding professional make no warranty of accuracy, completeness, currency, or fitness for any particular purpose, and disclaim all liability for decisions made in reliance on the output.

Consult your own qualified professionals. Before acting on anything calculated here, consult your own attorney, CPA, financial advisor, fundraising counsel, or other qualified professional licensed in your jurisdiction who has reviewed your specific facts and applicable current law. The Baratelli Institute is a publisher of practitioner reference material. It is not a registered investment adviser, broker-dealer, law firm, accounting firm, appraisal firm, or fundraising counsel.

Co-branded versions: If a professional advisor's name and contact information appear on this tool, that advisor has elected to make the tool available to clients as a courtesy. Inclusion of an advisor's name does not constitute the advisor's endorsement of any specific result, nor does it transfer professional responsibility for the underlying methodology to that advisor. The disclaimer above applies regardless of co-branding.

Educational references and tools — not legal, tax, accounting, or investment advice, and not a recommendation to buy or sell any security. Consult a qualified professional about your specific situation. © 2026 The Baratelli Institute.