Final-voted General Fund
Budget scope · FY2027Wilbraham Finance Committee · working framework
Start with the decision.
Then test the whole picture.
One proposal enters the room. The committee’s job is to understand what it changes, what it costs over time, who carries the risk, which alternatives are credible, and what evidence is still missing before offering advice.
ArtifactPortable working report v0.5.0
Data stateGoverned worked example
DatabaseNot connected · read-only extracts only
PublicationNot approved for current decision use
Start here
Begin with one proposal and one traceable record
- Name the exact decision.Before testing numbers, be clear about what could actually be authorized.
- Follow the evidence chain.Connect each important claim to its source and keep the unknowns visible.
- Test affordability with complete inputs.If a required input is missing, the result is unknown—not zero.
- Write down the judgment.Preserve the reason, strongest counterpoint, conditions, and trigger for another look.
Governed worked example
Here is the baseline—and where it stops
The FY2027 figures make the method concrete. They are a dated worked example, not a live decision record; each figure must be refreshed and reconciled before current use.
HWRSD assessment + debt
Regional-school obligation · FY2027HWRSD share of final-voted GF
Exact numerator ÷ exact denominatorExpense Control total
Multi-fund scope · not comparable to GFApr / workbook$57,018,471
May 6 anticipated motion$57,041,471temporary +$23,000
Final vote$57,018,4710 of 588 displayed cells changed
The review sequence
Eight questions before a recommendation
Begin with the choice itself, then move through the evidence. A precise forecast cannot rescue a vague decision or a weak baseline.
Macroeconomic and external-force register
What could change the numbers before the Town acts?
Interest rates, property values, inflation, state aid, insurance, construction markets, and the broader economy can move the result even when the local proposal does not change. Each works differently, so they should never disappear into one vague “economic impact” number.
New state-aid baseline: final Wilbraham and HWRSD Cherry Sheet estimates are now controlled for FY2000–FY2027. They can inform the range and refresh trigger, but they remain budget-stage estimates—not actual-payment evidence or a complete funding forecast. See the current figures, history, and limits.
01Cash-flow change
Prices, wages, benefits, borrowing costs, or receipts actually change.
02Measurement change
A present-value or actuarial number changes even when benefit obligations do not.
03Legal-capacity change
Assessed value or state rules change a ceiling, limit, or allowable revenue path.
A · present ↔ future value
Discount and interest rates
A higher discount rate usually lowers the present value of the same future payment stream; a lower rate raises it. Market rates can also change new debt service, note rollover cost, and investment income.
Control: Show future cash flows, the selected rate, and at least one lower- and higher-rate case.B · tax base and ceiling
Assessed property value
The relevant base is taxable real and personal property—not land alone. Appreciation raises the absolute 2.5%-of-value levy ceiling and can lower the tax rate per $1,000 for the same levy.
Control: Never treat appreciation as automatic ordinary levy capacity.C · purchasing power
Inflation and cost escalation
Labor, health care, energy, materials, construction, insurance, and contracted services can rise at different rates. If recurring costs outpace recurring revenue growth, service pressure increases even without expansion.
Control: Keep general inflation, construction escalation, wage growth, and health trend as separate inputs.Wilbraham precedent · FY2025 FinCom presentation
FinCom has already used discount-rate logic in public budget framing.
“OPEB liability decreased significantly due to favorable discount rate that is used as a result of investing the OPEB funds.”
The Town-hosted FY2025 Budget Presentation lists Kevin Hanks, Chair, and Todd Schneider, Vice Chair. The source uses “Vice Chair,” not “co-chair.” The statement appeared in the presentation’s highlights alongside recommendations for $700,000 to Stabilization and $250,000 to OPEB and the decision not to spend to the levy limit.
What was said
A favorable rate helped the reported liability fall.
This is direct evidence that FinCom placed an actuarial present-value result into its FY2025 budget presentation. It is not merely a concept introduced by this model.
What it may have meant
Invested trust assets supported a higher valuation rate.
The FY2024 audit says the OPEB discount rate changed from 6.30% in 2023 to 7.00% in 2024. A higher rate discounts the same projected benefit payments more heavily, producing a lower present value. The presentation itself does not expose the actuarial derivation, so the audited note controls.
Why great caution is required
The rate did not erase the benefit obligation.
A rate change alone did not reduce retiree health benefits, cancel future payments, or create cash. Contributions and investment gains can add real assets, but a higher discount rate mainly changes today’s measurement—and the direction can reverse.
Audited FY2024 OPEB sensitivity
One percentage point in either direction moved the reported net liability materially.
The audit’s Note 22 held the projected benefit framework constant and changed the discount rate. This is the cautionary swing FinCom should expect every scenario model to disclose.
| Discount rate | Net OPEB liability | Change from 7.00% |
|---|---|---|
| 6.00% | $10,402,863 | +$1,656,457 |
| 7.00% | $8,746,406 | Base |
| 8.00% | $7,370,082 | −$1,376,324 |
How to use the precedent in a building scenario
FinCom’s own FY2025 presentation establishes that discount-rate and present-value effects are relevant to local financial analysis. A building model should therefore show nominal cash flows by year, an explicitly named discount rate, present value, and rate sensitivity. It should also keep present value separate from annual affordability: a lower NPV does not pay a peak-year debt bill or operating cost.
Assessed value · the big distinction
The ceiling rose with property value. The annual levy limit did not become the ceiling.
Wilbraham’s taxable assessed value rose from $2.064 billion in FY2022 to $2.793 billion in FY2026—35.4%. The resulting levy ceiling rose from $51.591 million to $69.837 million. But Proposition 2½ still grows the ordinary annual levy limit from the prior limit, the 2.5% increment, certified new growth, and voter-approved changes.
FY2026 ordinary levy limit$48,189,785Before debt and capital exclusions
FY2026 maximum allowable levy$50,069,014Includes $1,879,229 of exclusions
FY2026 actual total tax levy$48,746,259Amount actually raised
Unused levy capacity$1,322,7552.64% of the maximum · legal room, not cash
Direct answer to the valuation question
30.2% decrease
If the FY2026 actual total levy stayed at $48,746,259, aggregate assessed value would have to fall from $2,793,481,911 to about $1,949,850,360 for that levy to equal 2.5% of value.
Legal ceiling test
About 31.0% is the cleaner statutory trigger.
The annual levy limit before exclusions is $48,189,785. The 2.5% ceiling would fall to that amount at assessed value of about $1,927,591,400—a 31.0% decline. Debt and capital exclusions may be raised above the ceiling, so total levy versus ceiling is an intuitive stress comparison, not the complete legal calculation.
Do not say: “Property values rose, so the Town can automatically levy 2.5% of the new value.” Say: “Appreciation raised the absolute ceiling; current annual room is the $1.323 million difference between the DLS maximum allowable levy and the actual levy.”
Source: Massachusetts DLS Excess Levy Capacity and Override Capacity report, Wilbraham FY2022–FY2026, and the DLS Levy Limits Primer. Calculations: $50,069,014 − $48,746,259 = $1,322,755; $48,746,259 ÷ 2.5% = $1,949,850,360; 1 − ($48,746,259 ÷ $69,837,048) = 30.2%.
Other external drivers to keep in the same register
A credible downside case looks beyond three variables
- State aid and the broader economyReceipts can underperform assumptions; state policy can shift local funding burdens.
- Health-care and insurance trendsGroup insurance and OPEB cash costs can rise faster than general inflation.
- Construction and energy marketsBid prices, supply constraints, utilities, and maintenance can change project and operating costs.
- Credit and capital marketsBond, BAN, and reinvestment rates can change timing, carrying cost, and reserve earnings.
- Enrollment and regional assessmentsDistrict cost allocation can change a major Town obligation without a matching local revenue increase.
- Recession, employment, and collectionsLocal receipts, delinquencies, demand for services, and state revenue can move together.
Soon to comeFramework visible · calculation not yet operational
Mandatory FinCom test after macroeconomics
Carry the future obligation into today’s review
This future gate should identify what a proposal really changes after the opening appropriation: cash payments, staffing and benefit commitments, debt, contracts, asset work, regional obligations, risk, or only an accounting measurement.
Why this matters
Do not let the first-year price become the whole story
Before a recommendation, the workbench should test whether a proposal creates, enlarges, accelerates, defers, transfers, or resolves a future obligation and show the effect at five, ten, and twenty years.
What it will not claim yet
Why there is no live obligation total yet
The required proposal, payroll, contract, actuarial, capital, and funding records are not yet connected at a compatible decision level. Missing amounts remain unknown—not zero—and this section cannot support a current recommendation.
Cash-funded or earned improvement
Real assets, funded service capacity, or lower future cash requirements are created.
Structural change
A continuing cost, revenue, staffing level, contract, or service model changes.
Risk reduction
Failure exposure, volatility, backlog, or an unfunded contingency is measurably reduced.
Measurement-only
An actuarial or present-value amount changes without automatically changing the obligation or cash due.
Deferral or cost shift
A cost moves to a later year, another fund, another body, employees, service users, or future taxpayers.
Unresolved
The evidence cannot yet determine which economic effect occurred.
Obligations the gate will cover
- new or expanded staffing, compensation, pension, health, and OPEB effects;
- debt principal, interest, temporary financing, exclusions, and refinancing chains;
- compensated absences and other earned employee obligations;
- leases, subscriptions, service contracts, renewals, and termination costs;
- maintenance, renewal, replacement, decommissioning, and deferred asset work;
- environmental, remediation, permitting, and compliance responsibilities;
- HWRSD assessments, capital allocations, shared contracts, and other regional commitments; and
- grant matches, operating tails, clawbacks, and obligations left when one-time funding ends.
What is missing before real use
- a stable proposal ID, exact decision scope, alternatives, authority, and version date;
- annual nominal cash flows by option, with start, stabilization, expiry, and exit assumptions;
- position/FTE records, salary schedules, bargaining and benefit assumptions, and employer pension/OPEB cash effects;
- executed and proposed contract, lease, subscription, debt, and grant terms;
- current asset condition, utilization, maintenance backlog, lifecycle plan, and current cost estimates;
- future HWRSD member allocations and aligned Town/District operating and capital forecasts;
- recurring and one-time funding sources, legal restrictions, reserve plans, and household effects; and
- source links, evidence states, owners, due dates, actual results, and non-duplication controls.
What a completed gate should show
For each alternative: first-year and stabilized annual cost; five-, ten-, and twenty-year nominal cash; present value with rate sensitivity; recurring-versus-one-time funding match; pension/OPEB and other employee tails; debt and contract schedules; deferral or transfer effects; service and risk consequences; owner; review trigger; and the capacity remaining after the decision.
Affordability lab
If an input is missing, the answer is not zero
The small lab can create a first-pass recurring stress test. It stays blank until every required input is supplied—and it does not replace a debt schedule, parcel model, or scenario forecast.
missing
Supply all four values to calculate. Empty fields remain unknown.
Recurring balance
Do dependable revenues cover continuing services and the proposal?
Cash-flow timing
When do appropriations, borrowing, reimbursements, and payments occur?
Capital sustainability
What does this displace across the complete asset and debt portfolio?
Household + service
Who pays, who benefits, and what service changes if assumptions fail?
Decision workbench
The method stays the same; the evidence changes
Choose a case to see how the same questions lead to different sources before the committee ranks options or makes a motion.
Database-to-decision map
Show the evidence chain, not the database
The database may be enormous. A decision page should show only the evidence chain needed to understand the question, with the deeper record one step away.
Decision authority
What can be authorized?
Operating baseline
What must recur?
Regional schools
What is shared and controlled?
Capital portfolio
What competes over time?
Debt + cash
When does cash leave?
Revenue capacity
What can support it?
Household impact
Who pays and when?
Outcomes + risk
What value changes?
Open the non-substitution guardrails
budget ≠ actual
appropriation ≠ cash
authorization ≠ issued debt
principal ≠ outstanding balance
levy ≠ audit property-tax revenue
fund balance ≠ free cash
assessment total ≠ Wilbraham share
empty / null ≠ zero
Recommendation record
Write the judgment so someone else can follow it
A recommendation should be more than “approve” or “reject.” It should preserve the reasoning, strongest opposing consideration, conditions, evidence limits, and the moment that would trigger another review.
Action Recommend approve / reject / defer / amend…
Because The evidence shows…
Even though The strongest opposing consideration is…
Provided that Approval is conditioned on…
Review when Reconsider if this trigger occurs…
The committee standard
A clear recommendation shows its work
Copyright and source boundary
About this independent framework
Copyright © 2026 Sherie Schaefer. All rights reserved.
This work contains an independently developed civic decision-support framework, including original organization, documentation, terminology, presentation, and implementation materials. Public records, public data, cited source materials, mathematical principles, and third-party content remain subject to their respective legal status and ownership. No transfer of copyright or other intellectual-property rights is intended unless expressly stated in a signed written agreement.
This work was developed under the substantive direction and review of Sherie Schaefer with AI-assisted drafting and/or coding tools. Copyright is claimed only in protectable human-authored expression and in qualifying human selection, coordination, arrangement, and modifications. Public data, source materials, third-party content, and unprotectable AI-generated material are excluded from the claim.