Final-voted General Fund
Budget scope · FY2027Wilbraham Finance Committee · working framework
Trace the decision.
Test the whole picture.
A committee workbench for turning source records into independent, explainable advice—without hiding missing evidence, mixing scopes, or treating affordability as a single number.
ArtifactPortable working report v0.3.0
Data stateGoverned worked example
DatabaseNot connected · read-only extracts only
PublicationNot approved for current decision use
How to use this page
One proposal. One sequence. One reviewable record.
- Walk through all eight gates.Define the decision before testing the numbers.
- Use the case workbench.Identify the evidence chain and the important unknowns.
- Test affordability only when every input is known.An empty field stays unknown; it never becomes zero.
- Preserve the recommendation.Record the reason, strongest counterpoint, conditions, and review trigger.
Governed worked example
A snapshot that shows its seams
FY2027 figures illustrate the method. They are not live data and must be refreshed, reconciled, and approved before a current decision.
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 gates before advice
Move in order. Later precision cannot repair an undefined decision or an unreliable baseline.
Macroeconomic and external-force register
Name what can move the budget without a new local promise.
External conditions can change cash costs, accounting measurements, or legal revenue constraints. Those are different mechanisms and must not be blended into one “economic impact” number.
01Cash-flow change
Prices, wages, benefits, borrowing costs, or receipts actually change.
02Measurement change
A present-value or actuarial number changes even when promised benefits 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 promise.
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 complete downside case should not stop with 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.
Affordability lab
Missing is not zero.
Enter annual amounts to create a first-pass recurring stress test. The lab 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
One method, different evidence chains
Select a case to see what the framework asks before the committee ranks options or makes a motion.
Database-to-decision map
Promote evidence, not tables
The source catalog may be broad; the report should expose only the evidence chain needed for the decision.
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
Make the judgment reviewable.
A strong recommendation is not a verdict alone. It preserves the reasoning, dissenting considerations, conditions, evidence limits, and follow-up obligations.
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 promise
Every recommendation should show its evidence, tradeoffs, affordability, uncertainty, and accountability.
Copyright and source boundary
Independent framework. Public facts remain public.
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.