Church Camp Scholarship Fund Sustainability Calculator

Introduction

For many churches, camp is not an optional extra. It is one of the few places where students step away from ordinary routines, hear Scripture in a focused setting, build friendships rooted in faith, and return home changed. That is especially true for rural congregations and small churches that may not have large youth budgets or easy access to regional events. When camp tuition rises, when vans travel long distances, or when several families need help in the same summer, scholarship planning becomes a stewardship question instead of a last-minute scramble. A church that wants to say yes to every student needs to know whether its current mix of offerings, events, and reserve funds can realistically support that goal.

This calculator was built for that planning conversation. It estimates how many campers will likely need scholarships, what those scholarships cost once travel support and administrative overhead are included, how much annual fundraising may cover, and when an endowment draw is required. It then extends the picture across multiple years so leaders can see whether the fund is stable, stretched, or headed toward a future gap. Rather than treating the scholarship account as a vague ministry line item, the tool turns it into a model with clear drivers: campers, need rate, tuition, travel, fundraising, draw policy, investment return, and inflation.

That multi-year view matters because sustainability is rarely determined by one summer alone. A church may meet this year's need with a strong banquet or a generous memorial gift and still face problems later if tuition grows faster than donations or if the endowment is tapped too heavily. On the other hand, a church may discover that its current policy is healthier than expected. If annual events and designated gifts already cover most scholarship costs, the endowment may remain largely untouched and continue growing. The purpose of the calculator is not to replace prayer, discernment, or testimony-driven giving. It is to help finance teams, camp committees, pastors, and donors ask better questions with the numbers in front of them.

How to Use

Start with the size of the ministry. Enter the total number of campers expected from your church or partner churches, then enter the percent who typically need scholarship help. The calculator rounds that result to the nearest whole recipient because real ministries fund actual students, not fractions of a person. Next, enter camp tuition per student and the average travel stipend per student. Tuition represents the direct registration cost charged by the camp. Travel stipend is useful for congregations that cover fuel, van pooling, or a flat transportation grant for families driving long distances.

After the student costs, add the funding side. The number of fundraising events and the average net amount per event represent recurring local efforts such as pancake breakfasts, dinners, auctions, camp Sundays, or special offerings. Designated gifts and mission offerings capture direct donations that are not tied to an event. Those gifts might come from memorials, a missions committee, alumni of the camp, or a few households that consistently sponsor campers. Together, these fields estimate the annual fundraising available before any endowment draw is considered.

The final group of inputs covers policy and projections. Endowment balance is the amount already set aside in a scholarship reserve or endowed fund. Target draw percentage is the maximum share of that balance the ministry is willing to spend in one year. Expected investment return is the assumed annual growth rate of the endowment. Projection horizon sets how many years the table will show. Annual tuition inflation models rising tuition costs, annual fundraising growth estimates whether events and donors are improving over time, and administrative cost rate represents overhead such as bookkeeping, payment processing, scholarship review time, background-check coordination, or other support expenses attached to the program.

Once you submit the form, read the results in order. The summary list gives the immediate story for the current year: recipients, scholarship cost, overhead, total annual need, expected fundraising, recommended draw, and any remaining gap. The projection table then shows how those figures evolve year by year. If the funding gap stays at zero and the ending endowment remains healthy, the fund looks sustainable under your assumptions. If gaps appear or the endowment shrinks sharply, that is a signal to strengthen fundraising, revisit draw policy, or prepare donors for higher camp costs.

1. Enter expected campers, scholarship rate, tuition, and travel support.
2. Add annual fundraising events, average event revenue, and designated gifts.
3. Set reserve assumptions such as endowment balance, draw rate, investment return, and projection years.
4. Review the current-year summary first, then the long-range table, and export the CSV if your committee needs to discuss the numbers offline.

One practical way to use the tool is to run more than one scenario. A conservative scenario might assume slower fundraising growth and higher inflation. An optimistic scenario might assume a stronger donor year or a new regional partnership. A stress-test scenario might hold fundraising flat while scholarship demand rises. Comparing those cases helps leaders move from abstract hope to concrete policy. It also keeps discussions from collapsing into a single emotional question such as whether the church cares enough. Good stewardship is often less about caring more and more about planning well.

Formula

The calculator first estimates the number of scholarship recipients by multiplying total campers by the scholarship rate and rounding to the nearest whole number. It then computes annual scholarship spending from tuition plus travel for each recipient. Administrative costs are calculated as a percentage of that scholarship spending. The result is the total annual need that must be covered through some mix of fundraising and endowment support.

The page preserves the core formula in MathML below. In plain language, total need equals tuition support plus travel support plus administrative costs for the students being helped:

Here, N is total annual need, S is scholarship recipients, T is tuition, V is travel stipend, and A is administrative cost. The administrative component is modeled as scholarship spending multiplied by the admin rate. Annual fundraising is the sum of event revenue and designated gifts. The recommended endowment draw is the smaller of two values: the amount still needed after fundraising and the maximum allowed by your chosen draw policy. This is why the calculator can return a recommended draw of zero even when an endowment exists. If fundraising already covers the need, the prudent draw is simply not to spend the reserve that year.

In the projection table, the model repeats this process for each year. Tuition rises according to the inflation rate you entered. Fundraising grows according to the annual fundraising growth rate. The endowment balance changes by earning investment returns and then subtracting whatever draw is needed in that year. Conceptually, the update works like this: next year's endowment equals the current endowment, plus investment growth, minus the draw used to support scholarships. That rolling calculation is what lets the table reveal whether today's policy can continue for five, seven, or ten more summers.

Because the formula is transparent, the output is easier to explain to a board or donor. If the gap is large, you can usually point to the driver immediately: too many campers for the current fundraising base, tuition growing faster than giving, or a draw policy that is intentionally conservative. If the model is healthy, you can show that the ministry is not succeeding by accident. It is succeeding because the relationship between need, fundraising, and reserve policy is working in a sustainable way.

Example

Using the default values already loaded in the form, suppose a network of churches sends 75 campers and 55% need scholarships. The calculator rounds that to 41 recipients. Tuition is $365 and the travel stipend is $40, so the direct scholarship cost is 41 × ($365 + $40) = $16,605. With a 7% administrative cost rate, overhead adds $1,162.35. That brings the total annual need to $17,767.35. Fundraising revenue is estimated from four events at $2,200 each plus $9,500 in designated gifts, which totals $18,300 for the year.

In this example, expected fundraising already exceeds the year's modeled need, so the recommended endowment draw is $0.00 and the projected funding gap is also $0.00. That is an important lesson: the presence of an endowment does not mean it should always be used. Under these assumptions, the fund can leave the reserve intact for the current year while the endowment continues to grow with investment returns. Because fundraising is also assumed to grow at 4% annually while tuition inflation is 3.5%, the long-range projection remains favorable. If you change the assumptions by lowering event revenue, raising the scholarship rate, or increasing inflation, the table will quickly show when a draw becomes necessary and how large that draw may become.

A useful board discussion often begins here. The question is not just whether the current year is covered. It is whether the church wants to keep the same level of support if demand jumps unexpectedly. Running a second example with more campers or weaker fundraising can help leaders decide whether to recruit new donors now, add another annual event, or preserve a lower draw rate so the endowment is available in leaner years. The calculator makes those tradeoffs visible before they become a crisis in registration season.

Limitations and Assumptions

This tool is a planning model, not a promise. It simplifies reality so leaders can reason clearly about the main drivers. Several assumptions should be kept in mind when interpreting the result. First, scholarship recipients are rounded to a whole person. That makes sense for budgeting, but real ministries may choose to fund partial awards instead of full grants. Second, the calculation assumes the travel stipend stays constant across the projection. If fuel prices are volatile or if your churches are spread farther apart in some years, you may want to update that number manually rather than relying on a static amount.

Third, the endowment projection grows only through investment returns and shrinks only through draws. It does not automatically add extra fundraising above the annual need into the endowment balance. That is a deliberate simplification, but it matters. In real life, a church might bank surplus event proceeds, transfer unused gifts into reserve, or treat excess funds as a separate operating balance. If your ministry does that, remember that this calculator may understate future reserve growth unless you reflect those decisions elsewhere in your planning.

The model also does not account for every ministry nuance. Restricted gifts earmarked for a specific camper, last-minute camp discounts, registration deadlines, taxes or fees connected to investments, major market swings, or a capital campaign to expand camp capacity are outside its scope. Nor does it attempt to quantify the spiritual impact of camp itself, which is often the very reason churches are willing to make sacrifices to fund it. The calculator is best used as one part of a larger stewardship process that also includes testimonies, historical records, donor relationships, and annual review.

Even with those limits, the tool is valuable because it creates a repeatable framework. If committees save their CSV exports each year, compare projections against actual outcomes, and revise assumptions honestly, they build institutional memory. New treasurers can see why a draw policy was chosen. pastors can explain scholarship requests with clarity. donors can understand how their gifts fit into a longer ministry strategy. Over time, that habit of reviewing assumptions may be just as helpful as the numbers themselves, because sustainability depends on both careful math and faithful follow-through.

Finally, remember that sustainability is not only a finance issue. Safe transportation, trained volunteers, pastoral oversight, and thoughtful camp partnerships all matter. A healthy scholarship fund supports ministry, but it cannot replace wise ministry leadership. Use the calculator to strengthen planning, then pair the output with prayer, communication, and regular storytelling about what camp is doing in students' lives. When leaders explain both the mission and the math, churches are often more willing to give generously and consistently.