Church Pro Forma Template

Start in the Assumptions sheet. Enter your current weekly attendance, average weekly giving per attender, and the annual growth rate you're planning toward. If you're modeling a capital campaign, add your pledge goal and expected fulfillment rate. These inputs drive every projection in the template, so spend 15–20 minutes getting them right — use your last 12 months of actual giving data as a baseline rather than guessing. Most finance committees find it helpful to set up three versions: a 0% growth conservative case, a 3–5% growth moderate case, and a campaign-fueled optimistic case.

Once your assumptions are in, review the Revenue and Expense Projections sheets together. The revenue sheet will show you whether projected giving keeps pace with expense growth — and if not, which year the gap starts to open. Pay particular attention to the personnel cost row: churches that hire ahead of giving growth often hit cash flow trouble in year 2 or 3. The Capital Campaign sheet is where you model the construction timeline and loan draw schedule if you're planning a building project. Enter your contractor's draw schedule by month and the sheet calculates exactly when you need cash and how much debt you'll carry.

Bring the Summary Dashboard to your next board or elder meeting. It presents the full 5-year picture in a format that non-finance leaders can read in five minutes — giving trajectory, expense trends, and the cash position after any debt is factored in. If you're going to a bank or denominational lender, export the Cash Flow sheet and the Dashboard together; lenders want to see monthly cash timing, not just annual projections. Update the pro forma each year by plugging in actual results and rolling the assumptions forward — it takes about an hour and keeps your long-range planning anchored to reality.

A church pro forma is most commonly needed in two situations: when a congregation is considering a capital campaign or building project, and when a new campus or church plant needs to present financial projections to denominational leadership or a lender. In both cases, the core challenge is the same — giving income is driven by people and habits, not contracts, which makes projecting it harder than forecasting revenue for a business. A realistic pro forma acknowledges that variability and builds in conservative assumptions rather than straight-line growth.

Churches that approach a building loan without a multi-year cash flow projection often discover the debt service problem after they've committed to a construction budget. A well-built pro forma shows you the answer before you're in the room with a banker: given your current giving levels, growth assumptions, and expense structure, can you service the debt while maintaining ministry programs? Personnel costs are usually the biggest variable — churches that staff up during a campaign period sometimes find that giving-per-attender doesn't grow fast enough to sustain the payroll once the campaign excitement fades. The projection makes that risk visible so leadership can make an informed decision.

The most useful pro formas aren't just for lenders — they become the church's internal planning tool. Finance committees that update their projections annually, compare to actuals, and adjust assumptions based on real giving trends make better decisions about hiring, programming, and facility investment. The pro forma shifts the conversation from 'can we afford this?' to 'what does the data say, and what assumptions would need to hold for this to work?' That's a healthier framing for elder boards and finance committees navigating decisions that affect the whole congregation.