Most churches budget one year at a time. That's understandable — annual budgets match annual fiscal years, annual congregational votes, and annual stewardship campaigns. But a one-year budget has a significant blind spot: it tells you where the church is financially right now, not where it's going. A 5-year projection fixes that.
This guide covers why multi-year projections matter, how to estimate realistic growth rates for income and expense categories, a step-by-step walkthrough of using the GuideLedger 5-year spreadsheet, and the common mistakes that make projections worthless. At the end, there's a free downloadable spreadsheet you can open in Excel or Google Sheets and start using today.
Why Project 5 Years Instead of 1?
A one-year budget answers: "Can we afford to operate next year?" A 5-year projection answers a set of harder, more useful questions:
- Is giving growing fast enough to keep up with expenses? If personnel costs are rising 4% annually but giving is growing 2%, you have a structural gap that will take years to show up in any single annual budget — but it's visible in a 5-year projection immediately.
- Can the church afford a new hire? Adding a staff position isn't a one-year decision. It changes the cost structure permanently. A projection shows you what that hire looks like at Year 5, not just Year 1.
- When will the building fund be funded? Capital campaigns, reserve fund targets, and major repair reserves are inherently multi-year plans. You can't evaluate them in a 12-month window.
- What does the elder board need to approve? Many elder boards and finance committees think strategically about where the church will be in 3–5 years. A projection gives them a financial picture to match that strategic thinking — and it's a much more compelling document than a single-year spreadsheet.
Churches that project forward are more likely to catch problems before they become crises, and more likely to make strategic investments — staff, facilities, missions — with confidence instead of anxiety.
How to Estimate Year-Over-Year Growth Rates
The most important input in any projection is the growth rate assumption. Get this wrong and the projection is useless, regardless of how detailed the rest of it is.
Giving Growth: 3–5% Is the Benchmark
For a healthy, growing church, general giving typically increases 3–5% per year in nominal terms. This accounts for membership growth, increased giving from existing members, and modest new-member giving. A few important caveats:
Start with your history. If your church has averaged 2% giving growth over the past 5 years, don't project 5% without a specific reason (a new outreach initiative, a capital campaign, a major demographic shift). Historical giving growth is the most reliable predictor of future giving growth. Pull 5 years of annual giving totals from your accounting system and calculate the compound annual growth rate before you set a projection number.
Giving is lumpy, not linear. Most churches see giving spike in December (year-end tax planning), dip in summer (vacations, lower attendance), and occasionally spike or drop around major church events. A 5-year projection smooths these bumps into annual totals, which is appropriate — but don't mistake annual smoothness for monthly predictability. Keep a separate monthly cash flow model for that.
Capital campaigns distort the baseline. If your church ran a capital campaign in Year 2 and raised $500,000 above the normal giving baseline, that's a one-time event. Don't carry it forward as if giving permanently increased. Use a baseline that excludes capital campaign receipts when setting your annual giving growth rate.
Expense Growth: 2–4% for Most Categories
Operating expenses grow for two primary reasons: inflation and organizational expansion (more staff, more programs, more building). For a stable church not planning major growth, 2–4% is a reasonable expense growth assumption for most categories:
Staff and Personnel (2–4%). Modest cost-of-living adjustments for existing staff, plus potential new hires. If you're planning to add a position, model it explicitly as a step change in the year it happens — don't try to hide a new hire inside a growth rate. Personnel is typically 45–55% of a church's total expenses, so errors here compound significantly over 5 years.
Facilities (2–3%). Utility costs tend to track inflation. Maintenance can be modeled as a percentage of building value (typically 1–2% annually for routine maintenance). Major capital items (roof, HVAC, parking lot) should be modeled separately in a capital plan, not buried in the annual operating projection.
Ministry Programs (3–4%). Program costs grow with participation. If you're adding new ministries, model the incremental cost explicitly. If programs are stable, 3% is a reasonable placeholder for material costs, licensing, and event expenses.
Missions (2–3%). If your church has committed to a fixed percentage of giving for missions (a tithe of the church's giving, for example), the missions budget grows in lockstep with giving. If missions is a fixed dollar allocation, inflation will erode its real value over 5 years — factor that in.
Administration (2%). Software subscriptions, office costs, insurance premiums. These tend to track inflation fairly closely. A growing church may see per-capita administrative costs decrease as overhead gets spread across more members.
Contingency (2–3%). If you model contingency as a percentage of total expenses, it grows automatically. If it's a fixed dollar amount, grow it explicitly — the unexpected expenses that contingency covers get more expensive over time too.
Step-by-Step: Using the GuideLedger 5-Year Projection Spreadsheet
The free spreadsheet has two sheets: Income Projections and Expense Projections. Here's how to work through it:
Step 1: Open the spreadsheet in Excel or Google Sheets. Both work. If you use Google Sheets, upload the .xlsx file directly — all the formulas transfer without modification.
Step 2: Enter your Year 1 income figures. On the Income Projections sheet, find the "Year 1 (2027)" column and enter your projected income for each line item: General Giving, Designated Giving, Facility Rental, Special Events, and Other Income. These are the only cells you need to type actual numbers into for the income side. The Year 2–5 columns calculate automatically based on the growth rate in the "Growth %" column.
Step 3: Set income growth rates. In the "Growth %" column (column G) of the Income Projections sheet, enter a growth rate for each income line. You can — and should — use different rates for different lines. General giving from established members might grow 4% while facility rental is flat (0%). The spreadsheet will apply the growth rate you enter to each year's projection independently.
Step 4: Enter your Year 1 expense figures. Switch to the Expense Projections sheet and enter Year 1 amounts for each expense category: Staff & Personnel, Facilities, Ministry Programs, Missions, Administration, and Contingency. Same pattern as income: Year 1 is the only column you type into directly.
Step 5: Set expense growth rates. Enter a growth rate in column G for each expense line. Personnel might be 3.5%, facilities 3%, missions 2.5%. Review the benchmarks in the section above as a starting point, then adjust for your church's specific trajectory.
Step 6: Read the Net Surplus row. At the bottom of the Expense Projections sheet, the "Net Surplus / (Deficit)" row shows the projected gap between total income and total expenses for each year. A positive number means income exceeds expenses — a healthy surplus that can build reserves or fund investments. A negative number means expenses outpace income — a structural deficit that requires attention before Year 5 arrives.
Step 7: Stress-test your assumptions. The projection is only as good as the growth rates you enter. Before presenting to your board, run at least two scenarios: an optimistic case (giving grows at the high end, expenses at the low end) and a conservative case (giving flat or slightly down, expenses at the high end). If the conservative scenario shows a structural deficit by Year 3, that's a strategic conversation to have now — not in Year 3 when options are limited.
Using the Projection for Board and Strategic Planning
A 5-year projection becomes most valuable when it's used as a planning input, not just a reporting output. Specifically:
New hire decisions. Before adding a staff position, run the projection with the added cost. Does the Net Surplus remain positive in Years 3–5? If not, what growth rate in giving would be required to sustain the hire? That number gives the board a concrete metric to evaluate against the church's realistic growth trajectory.
Facility decisions. A major capital project — expansion, renovation, new building — has operating cost implications that extend well beyond the construction period. Model the incremental utilities, maintenance, and debt service in the projection to see the full impact on the annual operating budget.
Mission and ministry expansion. If leadership wants to double the missions budget over 5 years, the projection shows exactly how much giving growth is required to do so without cutting other categories. It turns an aspirational goal into a concrete financial question.
Annual budget context. When presenting the annual budget to the congregation, a 5-year projection provides context: "Here's where we are this year, and here's the trajectory we're on." That context helps members understand not just what the church is spending, but whether the financial path is sustainable.
Common Mistakes That Make Projections Unreliable
A 5-year projection is only useful if it's built on realistic assumptions. The most common mistakes:
Using a single growth rate for all line items. Applying the same 4% growth rate to General Giving, Facility Rental, and Contingency produces a misleading projection. These categories have different drivers and should be modeled independently. Facility rental might be flat (you have one tenant and no plans to expand). General giving might be growing faster than 4% because you're in a growth season. Use the data you actually have for each line.
Projecting linear growth on lumpy giving. Giving doesn't grow smoothly year over year — it tends to plateau, then jump, then plateau again as the church grows through successive attendance and membership levels. A linear 4% growth assumption will be wrong in some years and roughly right on average. Acknowledge this limitation when presenting to the board, and review the projection annually against actuals.
Ignoring inflation on personnel. Staff salaries need cost-of-living adjustments to remain competitive. If you project flat personnel costs while inflation runs at 3–4%, you're implicitly planning to reduce staff compensation in real terms over 5 years — which is unsustainable. Build at least inflation-rate increases into personnel projections, and add incremental amounts for merit increases and any planned new positions.
Mixing capital and operating expenses. A $200,000 roof replacement is not an operating expense — it's a capital expenditure. Including it in the annual operating projection distorts the picture. Keep capital expenditures in a separate capital plan and model them as draws on reserves or as debt service if financed. The operating projection should reflect the true cost of running the church week to week, not the cost of major capital investments.
Building the projection and never updating it. A projection that isn't reviewed annually is a document, not a planning tool. Build the habit of comparing Year 1 actuals against the projection each January, and adjust Years 2–5 accordingly. If giving grew faster than projected, update the growth rate. If a new staff position was added in Year 2, update the personnel line. A living projection is exponentially more useful than a static one.
Download the Free Spreadsheet
The GuideLedger 5-year church budget projection spreadsheet includes all of the above in a ready-to-use format: Income Projections sheet, Expense Projections sheet, per-row growth % column, auto-calculated Net Surplus row, and pre-filled example values you can replace with your church's actual numbers.
Download the free 5-year church budget projection spreadsheet →
If you want help interpreting the results or building a multi-year financial plan for your specific situation, GuideLedger's consulting services include budget reviews, 5-year financial modeling, and board presentation support. Most church finance teams use the spreadsheet as a starting point and then work with a consultant to pressure-test the assumptions before presenting to the elder board.