Minimum responsible funding
What is required to maintain highly valued services, meet commitments, and avoid creating a more expensive problem later—after dependable recurring revenue.
Affordability decision room
An affordability decision needs more than a legal limit, a tax rate, or an average bill.
The useful question is not “What is the one affordable number?” It is “What range can maintain the services and obligations the community values without creating household pressure or future risk greater than the value of the choice?”
How to read every number
The page tells you where a value came from before asking you to trust it.
Open the six evidence labels used throughout the decision room
Wilbraham historyA certified or officially reported local value with its fiscal year and source.
Current Wilbraham evidenceAn accepted FY2027 value with its stage and reporting object.
Official benchmarkAn external definition or statistical estimate, with period and limitations.
User-entered modelA changeable assumption. It is never silently presented as Town data.
Calculated hereA result with the inputs and formula visible beside it.
Required but unavailableThe calculation stops or remains qualified. Missing never becomes zero.
The affordability range
Two boundaries reveal the real decision space.
A lower levy is not automatically responsible, and legal capacity is not automatically comfortable.
What is worth carrying?
Choices, efficiencies, timing, revenue options, service levels, and alternatives are weighed here.
Household and future capacity
Where bill pressure, structural imbalance, debt, reserve use, or lost flexibility becomes greater than the value received.
Having room on a credit card does not mean a household can comfortably afford another payment. In the same way, having legal levy or borrowing capacity does not establish either boundary.
Where precision improves most
Each missing connection changes a different part of the decision.
Open the full affordability evidence map
| Precision layer | What it lets residents and decision-makers answer | Current state |
|---|---|---|
| Household bill distribution | Which homes receive a $100, $300, $700, or larger increase—not just the average? | Not available |
| Household financial-pressure distribution | Which income, age, tenure, and fixed-income groups have the least room? | Partial ACS evidence |
| Maintenance and committed-cost baseline | What must be funded before expansion or discretionary projects? | Not normalized |
| Dependable funding bridge | How much is supported by recurring revenue versus taxes, reserves, borrowing, grants, or one-time money? | FY2027 unavailable |
| Five- and ten-year runway | Does the choice remain supportable as school, contract, debt, capital, and maintenance costs accumulate? | No accepted integrated forecast |
| Service-value baseline | What residents receive, where efficiency is possible, and what a lower levy would weaken or postpone? | Not available |
| Proposal alternatives | Can the same objective be achieved through another scope, timing, location, funding method, or design? | Proposal-specific |
| Actual-results loop | Did prior costs, savings, service outcomes, and household effects occur as represented? | Process defined; data connection incomplete |
Method basisMassachusetts DLS forecasting guidance treats revenue and expenditure forecasting as a way to evaluate decisions over time; the household-distribution method uses Census/HUD cost-burden concepts.
What can a $49 million levy tell us today?
It can be put in historical scale. It cannot yet receive a current affordability verdict.
Change the candidate levy. Every comparison below keeps the FY2026 value base fixed solely to show scale.
Compared with certified FY2026 levy+$253,741+0.52%
Modeled rate on FY2026 value base$17.54per $1,000 of assessed value
Modeled bill at FY2026 average value$8,229+$43 versus the reported FY2026 average bill
Blue-shaded results recalculate whenever the candidate levy changes. The cream input is the number you control.
FY2026DLS Town tax-summary series; exact value also reconciles to release 0366.
FY2026DLS Town tax-summary series, PRESENT_VALUE.
FY2026Massachusetts DOR/DLS Average Single-Family Tax Bill workbook.
FY2026Same DOR/DLS workbook; Town average, not every home.
FY2026DOR/DLS Excess Levy and Override Capacity workbook.
Historical controlMaximum levy minus certified levy; exact match to DOR reported excess capacity.
Historical-scale result: The candidate is $1,069,014 below the FY2026 maximum levy. That does not establish FY2027 legality or affordability. FY2027 values, new growth, levy forms, exclusions, classification, final levy, and rate are still unavailable.
Candidate inputThe candidate levy is entered by the reader. It is not read from PostgreSQL.
Cannot yet concludeNo accepted FY2027 tax-setting package or household bill distribution.
How the same levy reaches different property values
A Town average cannot show the range of household bill changes.
These values illustrate the arithmetic only. Wilbraham still needs accepted parcel counts by value band, type, exemption, and location.
| Illustrative assessed value | Bill at FY2026 certified levy | Bill at candidate levy | Modeled change | Provenance |
|---|---|---|---|---|
| $300,000 | $5,235 | $5,262 | +$27 | Illustrative value; bills derived |
| $400,000 | $6,980 | $7,016 | +$36 | Illustrative value; bills derived |
| $469,139 · reported FY2026 average value | $8,186 | $8,229 | +$43 | DOR/DLS value; bills derived |
| $600,000 | $10,470 | $10,524 | +$54 | Illustrative value; bills derived |
| $800,000 | $13,960 | $14,033 | +$73 | Illustrative value; bills derived |
FormulaProperty value ÷ 1,000 × modeled uniform rate. Classification shifts, exemptions, relative revaluation, new growth, and parcel distribution are excluded.
Build the lower boundary
What levy would the recurring plan require after dependable recurring revenue?
This is a user-adjustable teaching model because Wilbraham does not yet have an accepted FY2027 maintenance/service baseline or normalized recurring funding bridge.
Recurring requirement$62,000,000$60,000,000 baseline + $2,000,000 choice
−Dependable recurring revenue$15,000,000
=Modeled minimum responsible levy$47,000,000
All four boundary inputsFictional defaults entered in the page; replaceable by the reader.
Calculated hereRecurring requirement minus dependable recurring revenue. One-time support is shown separately and never treated as recurring.
Wilbraham source neededAccepted service catalog and maintenance baseline plus a period-aligned FY2027 recurring/restricted/one-time/reserve funding bridge.
Build the household-pressure boundary
The same bill can be manageable for one household and overwhelming for another.
Edit the three fictional profiles. The page calculates housing-cost pressure before and after the candidate levy on the FY2026 value base.
Modeled housing-cost share33.7% → 33.8%$5,235 → $5,262 property-tax componentCost-burden line
Modeled housing-cost share29.9% → 29.9%$7,852 → $7,893 property-tax componentBelow 30% guide
Modeled housing-cost share42.2% → 42.3%$6,980 → $7,016 property-tax componentCost-burden line
Official local estimate2020–2024 ACS five-year Wilbraham tenure components; point estimates derived from source bands. Ratio margin of error is not yet calculated.
Three household profilesFictional and editable. They are not actual residents and do not estimate how many Wilbraham households cross a line.
FormulaOther annual housing costs + modeled property tax, divided by annual household income.
Precision still neededPrivacy-safe counts by income, tenure, age, property-value band, exemption, type, and location; no person-to-parcel linkage is inferred.
Test the future boundary
A plan that balances in year one can open a structural gap later.
This ten-year teaching model grows recurring service costs, dependable recurring revenue, and taxable value at separately visible rates.
Open the ten-year runway, change the growth rates, and see the calculation
| Year | Recurring requirement with choice | Dependable recurring revenue | Levy without choice | Structurally required levy | Year-one levy after one-time support | Modeled rate | Bill at FY2026 average value |
|---|---|---|---|---|---|---|---|
| Year 1 | $64,170,000 | $15,300,000 | $46,800,000 | $48,870,000 | $45,870,000 | $17.15 | $8,046 |
| Year 2 | $66,415,950 | $15,606,000 | $48,667,500 | $50,809,950 | $50,809,950 | $17.48 | $8,202 |
| Year 3 | $68,740,508 | $15,918,120 | $50,604,952 | $52,822,388 | $52,822,388 | $17.82 | $8,359 |
| Year 4 | $71,146,426 | $16,236,482 | $52,614,898 | $54,909,944 | $54,909,944 | $18.16 | $8,519 |
| Year 5 | $73,636,551 | $16,561,212 | $54,699,966 | $57,075,339 | $57,075,339 | $18.51 | $8,682 |
| Year 6 | $76,213,830 | $16,892,436 | $56,862,883 | $59,321,394 | $59,321,394 | $18.86 | $8,846 |
| Year 7 | $78,881,314 | $17,230,285 | $59,106,471 | $61,651,029 | $61,651,029 | $19.21 | $9,014 |
| Year 8 | $81,642,160 | $17,574,891 | $61,433,652 | $64,067,270 | $64,067,270 | $19.57 | $9,183 |
| Year 9 | $84,499,636 | $17,926,389 | $63,847,453 | $66,573,247 | $66,573,247 | $19.94 | $9,355 |
| Year 10 | $87,457,123 | $18,284,916 | $66,351,009 | $69,172,207 | $69,172,207 | $20.31 | $9,530 |
The future choice becomes visible: if recurring costs grow faster than dependable recurring revenue and taxable value, the required levy and modeled bill continue rising even when the first-year budget was balanced.
Historical anchorFY2026 total assessed value and reported average single-family value.
Forecast assumptionsService baseline, new choice, one-time support, and all three growth rates are user-entered—not Wilbraham forecasts.
Calculated hereRecurring requirement minus recurring revenue; one-time support affects year one only.
Wilbraham source neededAccepted integrated forecast for operating costs, HWRSD, contracts, benefits, debt, capital, maintenance, receipts, state aid, reserves, and downside ranges.
How the conclusion becomes more precise
Each evidence layer answers a different question. None should be silently skipped.
- 01 · Available
Historical scale
How does the candidate compare with FY2026 levy, values, average bill, and legal maximum?
Answers scale—not current affordability. - 02 · Waiting
FY2027 certification
What levy, class allocation, rate, and bill distribution actually result?
Required for current tax outcomes. - 03 · Waiting
Property distribution
How many properties receive increases in each band, type, exemption, and location?
Required to replace one average. - 04 · Partial
Household pressure
Which income, age, tenure, and fixed-income groups have the least room?
ACS starts the story; distribution and MOE work remain. - 05 · Waiting
Service and funding baseline
What must be funded, what can become more efficient, and which revenue is dependable?
Defines the lower boundary. - 06 · Partial
Forecast and choice value
What does the plan require over time, and is the difference worth what it preserves or creates?
Defines future risk and the human decision.
Eight decision parameters
What we know, what remains partial, and what still blocks the judgment.
Open all eight parameters and their current evidence state
Household capacity
PartialACS housing-cost pressure is available in aggregate. Income, tax, and housing-cost distributions are not yet connected by household or property band.
FY2027 levy, rate, and bills
Not availableThe accepted source has not reported the final levy, classification, taxable value, rate, or bill distribution.
Recurring funding bridge
Not availableThe final-voted plan is not yet connected to a complete recurring, restricted, one-time, reserve, enterprise, and levy bridge.
Services residents highly value
Not availableExpense accounts show dollars, but an accepted service catalog, service levels, workload, and outcomes are not connected.
Five-year obligations
PartialDebt and the narrow 2021 CNA projection are available, but there is no accepted integrated operating, school, debt, and capital forecast.
Who carries the change
PartialProperty-class totals are available. Property value bands, parcel types, locations, exemptions, and household incomes are not yet joined.
Choice value and alternatives
Proposal-specificEach proposal still needs its purpose, alternatives, urgency, strategic fit, reversibility, and avoided-risk evidence.
Source confidence and missingness
AvailableCurrent accepted sources retain provenance, period, stage, refresh status, and missing-versus-zero controls.
Status methodCompared with accepted source coverage and the release defect/data-assessment records as of Aug 27, 2026, 1:22 PM ET.
Fictional reverse calculator
Work backward from one household’s housing-cost boundary.
This demonstrates how much room one illustrative household has before crossing a selected line. It does not determine a Town-wide maximum.
Open the reverse calculator and change the household assumptions
Current property-tax bill$6,980$400,000 ÷ 1,000 × $17.45
Complete housing cost$24,98025.0% of household income
Room before selected boundary$5,020Annual housing-cost room for this illustrative household.
Equivalent added Town levy$35,058,198$12.55 additional rate × Town taxable value.
BenchmarkU.S. Census/HUD 30% cost-burden and 50% severe-cost-burden definitions.
Calculator inputsAll household, property, rate, and Town value inputs are entered by the reader.
FormulaSelected housing-cost boundary minus current modeled housing cost, translated through the illustrative property and tax base.
Fictional five-year recurring-choice runway
A first-year increase becomes part of every later starting point.
This simpler view isolates how one recurring levy choice travels forward.
Open the five-year runway and change the recurring-choice assumptions
Year 1$48,350,000
Without new choice: $46,350,000 · With choice: $48,350,000Year 2$49,800,500
Without new choice: $47,740,500 · With choice: $49,800,500Year 3$51,294,515
Without new choice: $49,172,715 · With choice: $51,294,515Year 4$52,833,350
Without new choice: $50,647,896 · With choice: $52,833,350Year 5$54,418,351
Without new choice: $52,167,333 · With choice: $54,418,351| Year | Taxable value | Levy without choice | Levy with choice | Rate with choice | Added bill on fixed $400,000 value |
|---|---|---|---|---|---|
| Year 1 | $2,849,351,549 | $46,350,000 | $48,350,000 | $16.97 | $281 |
| Year 2 | $2,906,338,580 | $47,740,500 | $49,800,500 | $17.14 | $284 |
| Year 3 | $2,964,465,352 | $49,172,715 | $51,294,515 | $17.30 | $286 |
| Year 4 | $3,023,754,659 | $50,647,896 | $52,833,350 | $17.47 | $289 |
| Year 5 | $3,084,229,752 | $52,167,333 | $54,418,351 | $17.64 | $292 |
All runway inputsFictional and adjustable; not a Wilbraham forecast.
Calculated hereThe recurring choice is added in year one and grows with the modeled levy thereafter.
Fictional $3 million capital choice
Four ways to “fit” the same choice create four different kinds of pressure.
Assume $1 million of dependable other funding and a remaining $2 million decision. Borrowing is shown only because this example is capital—not operating spending.
Compare the levy, borrowing, reserve, and offset paths side by side
| Method | Immediate household effect | Duration | Town cost or capacity used | What the first-year bill does not show |
|---|---|---|---|---|
| Raise levy now | $286 in year one | One year for this capital amount | $2,000,000 taxpayer-funded portion | Larger immediate household shock; no interest or future debt payment. |
| Borrow for 10 years at 4.5% | $36 per year initially | 10 years | $2,527,576 total payments, including $527,576 interest | Smaller first-year bill creates a future obligation and reduces later flexibility. |
| Use one-time reserves | $0 immediate levy effect | One-time | $2,000,000 of reserves consumed | No immediate tax increase does not mean no cost; financial protection and future choices lose capacity. |
| Offset or reduce elsewhere | $0 added levy | Depends on the offset | $2,000,000 of another service, project, or cost removed or deferred | The affordability question moves to the service, maintenance, or risk being given up. |
ScenarioFictional $3 million capital cost, $1 million other funding, $2 million net, 10 years, and 4.5% interest.
Household effectAnnual funding amount ÷ modeled Town taxable value × modeled home value.
Why it mattersA proposal is not affordable merely because one funding method makes the first-year tax bill look small. Residents need the full cost, duration, displaced use, and future obligation side by side.
The proposal record
Every choice should carry the same answers from first idea through actual results.
What problem are we solving?
What happens if we do nothing?
What are the first-year and lifecycle costs?
Which costs recur?
How would each funding path affect households?
Which service is gained, protected, reduced, or displaced?
Who receives the value—and who carries the cost?
How does the choice affect debt, reserves, capital, and later budgets?
Which alternatives were tested?
What remains uncertain?
Who owns the next action?
What stage is this: preliminary, proposed, recommended, voted, certified, or actual?
What the choice creates or preserves
Service · safety · access · history · character · control · flexibility · avoided riskWhat the choice asks the community to carry
Household pressure · displaced service · debt · reserve use · future obligation · uncertaintyThis is where the real civic choice becomes visible. The financial, legal, regulatory, and operational work removes false choices and exposes unavoidable risks. What remains is for people to decide whether the difference in cost and risk is worth what a scenario preserves, changes, or gives up.
Illustrative decision-readiness check
A recommendation should not outrun its evidence.
These checkboxes teach process completeness. They are not the current Wilbraham status shown above.
Checklist stateControlled only by the reader’s selections; no Town score is stored or inferred.
Visible provenance ledger
Every value used on this page has a period, status, source, and permitted meaning.
Open the complete data and assumption ledger
| Value used | Current value | Origin | Period / stage | Permitted meaning |
|---|---|---|---|---|
| Candidate levy | $49,000,000 | User-entered model | None | Question to test; not Town evidence |
| Certified levy | $48,746,259 | DLS tax-summary series and release 0366 reconciliation | FY2026 certified history | Historical levy only |
| Total assessed value | $2,793,481,911 | DLS tax-summary series | FY2026 PRESENT_VALUE | Historical scale denominator |
| Average single-family value | $469,139 | DOR/DLS Average Single-Family Tax Bill workbook | FY2026 reported average | Historical average—not a parcel distribution |
| Average single-family bill | $8,186 | DOR/DLS Average Single-Family Tax Bill workbook | FY2026 reported average | Historical average—not every bill |
| Maximum levy and excess capacity | $50,069,014 / $1,322,755 | DOR/DLS Excess Levy and Override Capacity workbook | FY2026 | Historical legal capacity—not household comfort |
| FY2027 General Fund | $57,018,471 | cske.reporting_budget_lifecycle_v1 | FY2027 FINAL_VOTED | Authorized spending; not actual spending, levy, or bill |
| Owner housing-cost burden | 26.7% | ACS five-year Wilbraham source components | ACS5_TOWN_OF_WILBRAHAM_2020_2024 | Point estimate; ratio MOE not calculated |
| Renter housing-cost burden | 53.1% | ACS five-year Wilbraham source components | ACS5_TOWN_OF_WILBRAHAM_2020_2024 | Point estimate; ratio MOE not calculated |
| Service baseline and model assumptions | Reader-adjustable | User-entered model | None | Teaching only; not a Wilbraham forecast |
Still absentFY2027 certified levy, values, classification, rate, bill distribution, service baseline, recurring funding bridge, property bands, and integrated forecast.
Preserve the complete path
The decision is not finished when the budget is voted.
- Starting
Current service, cost, obligations, and household position
- Proposed
Each addition, reduction, funding path, and assumption
- Recommended
FinCom, Select Board, and other recommendations with reasons
- Voted
Town Meeting authority—not actual spending or a household bill
- Certified
Levy, values, classification, rate, and resulting bills
- Actual
Spending, revenue, service, debt, capital, and household outcomes
Then the loop begins again: actual results become the next budget’s starting evidence. A promise, estimate, vote, and actual result must never silently collapse into one number.
Sources, method, and present boundary
The decision room combines accepted evidence with visibly identified teaching models.
Open the sources, refresh state, model boundary, and external methods
Fresh accepted evidence was read Aug 27, 2026, 1:22 PM ET. PostgreSQL-backed values use accepted read-only reporting objects. User-entered models run only in this page and never write to PostgreSQL.