Budget the Plan, Model the Range

Why Colorado charter schools need scenario planning more than they need a perfect budget number

Every spring, charter school leaders sit down to build a budget for a year they cannot see. Enrollment is a projection. Per-pupil funding is a bill still moving through the legislature. Health insurance renewal is a rumor. And yet the board needs a number in June.

The instinct is to find the right number the single, defensible, carefully split-the-difference figure that will hold up through October. We would argue the opposite. In an uncertain environment, a single number is the most fragile thing you can hand your board. What holds up is a model.

That is the heart of our session at the CLCS Annual Finance Seminar, Budget Development & Scenario Planning in an Uncertain Environment. Here is a preview of where we are headed.

Part 1: Name the uncertainty before you open the spreadsheet

You cannot manage variance you have not named. In our experience, four forces do the vast majority of the damage to a charter school budget.

Enrollment

Enrollment drives most of a charter school's revenue, which makes it the single largest lever in the building. Colorado's statewide base per pupil funding is set at $8,900.40 for 2026-27 (Colorado General Assembly, SB26-023). Twenty-five students below plan are roughly $222,500 of base funding enough to freeze a teacher hire or delay a facility project.

Two disciplines matter here. First, model enrollment from the bottom up: entry-grade demand, cohort progression, attrition, waitlist conversion, and re-enrollment rates. A single school-wide growth percentage hides exactly where the risk sits. If your historical kindergarten yield is 92% of accepted offers, model 92% and 85%.

Second, understand how the count is actually funded. For 2026-27 and beyond, a district's funded pupil count is the greater of the current-year count or a multi-year average (Colorado General Assembly, HB25-1320). That averaging is a cushion when you dip and a delayed cliff if the decline continues. A school that falls from 420 to 380 may still be funded near 400 for a while. That is time to act, not permission to relax.

Then test the miss, not just the plan. Budget the realistic count, then model 95% and 90% of it. Know the dollar value of one student before the October count.

Funding

State funding depends on a formula, an economy, and a legislature, none of which you control. The School Finance Act resets base per pupil funding annually, inside roughly $10.2 billion of total program funding, while the new formula continues phasing in (Colorado General Assembly, SB26-023).

So, treat these as assumptions, not facts: inflationary increases, formula factors, mill levy override pass-through, categorical and special education revenue, and the timing of federal and grant awards. A district can raise an override and still change the allocation formula mid-cycle. A Title I or IDEA award can arrive at the same annual amount but three months later, creating a cash-flow gap that never appeared in your annual budget.

The structural fix is simple and easy to skip, make every per-pupil rate and pass-through percentage an input cell on an assumptions tab. When a number changes outside your building, you re-run the model instead of rebuilding the budget.

Costs

Costs rise on their own schedule, not yours. Salary schedules and market adjustments, health insurance renewals, PERA contributions, property and liability premiums, utilities, special education and transportation, facility lease escalators, technology refresh cycles none of them are indexed to your revenue growth. A renewal at 18% against 3% revenue growth is not a rare event.

Build cost drivers as rates rather than totals: compensation as schedule plus a percentage increase, benefits as a rate per FTE, contracts at their stated escalator. Then testing 2%, 4%, or 6% is one keystroke, not a rebuild.

And watch the ratios, not just the totals. Track compensation as a percent of revenue and cost per pupil over time. If salaries and benefits drift from 68% to 74% of revenue over three years while enrollment is flat, the model is flashing a warning even though every one of those budgets technically balanced.

Leadership change

This is the force most often left out of the risk conversation, and it belongs in it. Turnover in the executive director, business manager, or board treasurer seat is a financial risk, not only a staffing one. A new leader inherits the numbers without inheriting the reasoning behind them and spends the first months of the year reverse-engineering why last year's miscellaneous line was $87,000.

Three practices help. Put institutional memory in the model, not in a person document enrollment logic, staffing ratios, rate sources, and why each was chosen, so the model becomes the handoff document. Build shared fluency before you need it by walking the board and leadership team through the same model every cycle. And plan for the transition year itself: search costs, interim or overlap pay, and slower decision cycles belong as explicit line items in at least one scenario.

Part 2: Models, models, models

If you take one idea from our session, take this one: build models, not single-point budgets.

A static budget PDF tells the board what you hope will happen. A model lets the board ask, "what if enrollment is 5% lower?" and get an answer in the meeting. That difference compounds in five ways variable analysis, documented assumptions, easy replication next cycle, a historical baseline that shows which assumptions were reliable, and the stakeholder confidence that comes from a school able to show its work to boards, authorizers, and lenders.

We walk through three models that earn their keep:

The budget model. Enrollment by grade, per-pupil rates and pass-through, staffing FTE and class-size ratios, salary schedule and percentage increase, benefit and PERA rates all become switches. Out come the numbers a board actually needs bottom line by scenario, change in fund balance, days of cash, compensation as a percent of revenue, and cost per pupil. Keep it usable with one assumptions tab, no hard-coded numbers inside formulas, and dated versions for proposed, adopted, mid-year, and supplemental budgets.

The five-year forecast. Today's decision has a five-year shadow. A lease that looks affordable in year one can push you below your reserve policy in year four once salary steps and escalators layer in. A 5% raise that is sustainable now may require either enrollment growth or a mid-cycle freeze by year three. Tie year one to the adopted budget and run the same scenarios all the way through the horizon.

The utilities model. Cost equals rate times consumption, and you should forecast them separately using the 12 to 24 months of billing history you already have. When an electricity rate jumps 15% mid-year, you can quantify the full-year impact immediately and decide whether to accelerate an efficiency project. The same logic applies to insurance, where premium equals rate times exposure.

Three scenarios, one structure

We recommend the same three every cycle. Same model, same tabs, different assumption sets never change the formulas between scenarios.

·       Base case (plan of record). Most likely enrollment, funding as adopted, known cost increases. This is the budget you present and manage to.

·       Conservative case (planning discipline). Roughly 95% of planned enrollment, no new discretionary revenue, cost increases at the high end. The point is to name, in advance, what you would defer: the instructional coach hire, non-essential travel, the technology refresh.

·       Downside case (stress test). Near 90% of plan, plus a funding reduction or delayed payment, plus one unbudgeted cost event. The only question that matters: do we stay solvent and above our reserve floor?

From scenarios to decisions

Scenarios that never become decisions are just spreadsheets. Three things convert them.

Decide the trigger before you need it. Write down the enrollment or revenue level that activates each contingency and exactly what happens when it is reached. "If confirmed enrollment on August 15 is below 410, we freeze the third specials position and move to a shared model" approved by the board in June, not debated in September.

Sequence to the calendar. Spring staffing commitments, summer re-enrollment confirmation, the October count, mid-year revision, and the supplemental budget each have their own decision window. The October count arrives far too late to unwind most personnel commitments, which is precisely why the conservative scenario must shape your March and April offers.

Anchor to reserve policy and communicate cleanly. State the fund-balance floor and days of cash your board expects, test every scenario against it, and present the three cases side by side on a single dashboard. Then spend the meeting discussing decisions rather than arithmetic.

The takeaway

Budget the plan, model the range.

Three disciplines carry most of the weight: make every major assumption an input and document its source, define at least one formal trigger point before the October count, and keep the model  not a person as your institutional memory.

The schools that weather uncertainty best are the ones that already had the hard conversation with their boards about what happens if enrollment comes in 5 to 10% light. Have that conversation while the sun is still shining.

Kim McClelland and Glenn Gustafson of LeadJoy Education Solutions present "Budget Development & Scenario Planning in an Uncertain Environment" at the Colorado League of Charter Schools Annual Finance Seminar.