Add
Dependable recurring revenue
Property-tax support, dependable local receipts, recurring state aid, and other recurring sources—separated from estimates, transfers, reserves, and one-time receipts.
Supporting layer · affordability evidence v2 · as of August 20, 2026
What financial room can Wilbraham see—and what can’t the current evidence determine?
The new historical tax, levy, revenue, reserve, expenditure, and debt evidence makes the Town's financial position easier to test. A newly accepted property-tax layer now also connects certified tax-base history to a reconciled FY2026 parcel distribution. It does not complete the current forecast needed to declare what Wilbraham can sustainably add.
Short answer: legal levy room, historical patterns, existing Town/HWRSD scheduled payments, a dated debt position, and a controlled way to illustrate how a stated annual levy amount could be distributed are now visible. Dependable remaining recurring capacity is not determinable from current evidence. The loaded records still do not connect a complete FY2027 funding plan, the cost of continuing current services, future borrowing and capital scenarios, and household/service consequences on one compatible basis.
The principal test
Affordability begins with a recurring walk-down—not with one available balance.
The equation is a reporting requirement. A defensible result needs every component on the same entity, period, scope, and recurring/nonrecurring basis.
Subtract
Cost of continuing current services
A same-grain baseline for municipal services, HWRSD obligations, staffing, benefits, utilities, contracts, facilities, and other requirements before adding a proposal.
Subtract
Existing obligations
Debt service, assessments, contracts, recurring program requirements, and other legally, contractually, operationally, or temporally constrained amounts.
Subtract
Prudent capital and reserve requirements
Asset renewal, maintenance, known capital needs, reserve policies, risk buffers, and timing—not merely the balances visible on one date.
Result
Recurring room for additional choices
Current result: not determinable. The new history strengthens four parts of the investigation, but the loaded evidence does not yet complete the compatible forward baseline needed to calculate a dependable residual.
Do not force a residual from unlike records.
Subtracting a prior-year levy, a historical actual, a current appropriation, a reserve balance, and a disclosure-basis debt total would create a number without a valid meaning. Missing inputs remain missing—not zero.
Keep five meanings separate
“Capacity” is not one number.
A choice may fit one category and fail another. Each conclusion should name the category it actually measures.
What the law permits.
Levy limit, levy ceiling, excess capacity, new growth, exclusions, overrides, and borrowing authority.
Now visibleFY2007–FY2026 levy-capacity series; FY2026 unused levy capacity $1,322,755.
What dependable revenue can keep supporting.
Recurring revenue minus the recurring cost of current services and obligations.
Still neededGoverned multi-year operating forecast and same-grain budget-to-actual baseline.
What can be paid, and when.
Cash timing, receivables, payables, payroll, reimbursements, debt service, and reserves.
Still neededMonthly cash-flow history and forecast; fund balance is not automatically available cash.
What the full portfolio can carry.
Issued debt, annual debt service, authorized-but-unissued debt, exclusions, overlapping timelines, and operating tails.
PartialExisting Town/HWRSD payment schedules, historical series, and an issuer-prepared FY2025 position snapshot are visible; future borrowing and a consolidated capital scenario are not.
What residents and services experience.
Assessment distribution, bill mechanics, exclusions, ability to pay, service effects, and the consequences of delay or reduction.
Still neededHousehold bands, service baselines, proposal effects, and locally governed acceptable-risk measures.
Name only the capacity proved.
Legal room does not establish recurring balance. A balance does not establish cash timing. Repayability does not establish household or service affordability.
What the new data adds
Historical evidence is substantially stronger—and its limits are explicit.
The DOR 0301 layer preserves source-distinct metrics instead of silently forcing them into one definition.
14,386 present values and 3,336 controlled missing states.
A reported zero is evidence; an absent value is not converted to zero.
1,422 candidate-review rows and 5,279 mapping-required rows link to 53,597 preserved source records.
Useful, dated facts—not a current August 2026 debt portfolio.
| Evidence family | Coverage visible now | What it can support | Boundary |
|---|---|---|---|
| General Fund revenue | FY2002–FY2026 · 300 present values | Historical revenue direction and source discovery. | Not the complete FY2027 revenue plan. |
| General Fund expenditure | FY2004–FY2026 · 253 present values | Historical expenditure components. | Budgeted, actual, and source-reported bases must not be mixed. |
| Local receipts | FY2017–FY2026 · 680 present values | Receipt-component history. | History is not a current forecast. |
| Operating position and reserves | FY2002–FY2027 · 704 present of 1,092 observations | Free-cash and reported reserve history, with missing states preserved. | A reserve or fund balance is not automatically recurring capacity or cash available for any purpose. |
| Property taxation | FY1988–FY2027 · 1,478 present of 2,280 observations | Levy, assessed value, rate, and burden-proxy history. | Town-wide proxies do not show household distribution. |
| Proposition 2½ levy capacity | FY2007–FY2026 · 200 of 200 observations present | Levy limit, ceiling, actual levy, excess capacity, and new-growth context. | Legal capacity is not sustainable affordability. |
| Debt position and rating | FY1986–FY2026 · 315 present of 697 observations | Historical direction and source discovery. | Authorization, issuance, outstanding principal, and annual debt service remain distinct. |
| HWRSD net school spending | FY2024–FY2026 · 72 present of 144 observations | Selected District-wide history. | Do not infer Wilbraham's member share without allocation evidence. |
Evidence basis: CSKE DOR 0301 loader v0.2.0 and data-use manual v0.1.1, run output timestamp 2026-08-19 02:04:24. Source identity, basis, missingness, zero treatment, and period coverage remain attached. Topic coverage varies by metric; the ranges above summarize the loaded topic inventories, not continuous values for every series.
New in the August 20 evidence baseline
The property-tax base can now be connected to a controlled distribution example.
Accepted loader 0303 links certified DLS class, rate, and levy history with a bounded FY2026 parcel projection. It gives residents a clearer denominator for a stated annual levy scenario without presenting a parcel estimate as a tax bill.
Calculated from the bounded parcel projection; open-space value is zero in the accepted control.
The parcel projection is $133,159 lower, a −0.0049146% difference—inside the accepted 0.01% threshold.
Incomplete shape-only rows stay incomplete; missing values are not converted to zero.
All 512 match the accepted DOR 0301 layer exactly, with zero value differences.
| FY2026 parcel class | Rows | Accepted assessed-value sum | Share of candidate taxable real-property base |
|---|---|---|---|
| Residential | 5,670 | $2,496,548,987 | 92.146% |
| Commercial | 167 | $174,357,200 | 6.435% |
| Industrial | 66 | $38,429,500 | 1.418% |
| Exempt or other | 295 | $324,434,400 | Not included in candidate taxable real-property denominator |
| Unresolved | 9 | Missing | Preserved as incomplete—not zero |
A neutral sensitivity—not a bill
For each $1 million of stated additional annual levy, assessed value determines the illustrative share.
The calculation is assessed value ÷ $2,709,335,687 × $1,000,000. It assumes one uniform allocation across the candidate taxable real-property base.
| Illustrative assessed value | Standardized share of a $1m annual levy | How to use it |
|---|---|---|
| $250,000 | $92.27 | Scale these values by the stated annual levy amount. For debt, use annual debt service by fiscal year—not project cost or principal. |
| $400,000 | $147.64 | |
| $600,000 | $221.46 | |
| $1,000,000 | $369.09 |
This does not predict an actual tax bill.
It is not a certified tax status, classification-policy forecast, Proposition 2½ capacity calculation, issued-debt fact, legal conclusion, or affordability recommendation. A proposal still needs its actual recurring or temporary amount, financing route, service consequences, alternatives, household context, and uncertainty.
Evidence basis: accepted Affordability 0303 v0.2.1; loader transcript ending OVERALL PASS; FY2026 candidate parcel base and official DLS reconciliation; reporting baseline RPT-DATA-BASELINE-20260820-03. Download the accepted controls and calculations · Read the methodology and boundaries.
FY2027 funding bridge
The uses are visible; the complete same-year sources bridge is not.
The final-voted General Fund shows where authority was allocated. A complete resident answer also needs every funding source on the same FY2027 budget basis.
What can be said now
Wilbraham authorized a $57,018,471 FY2027 General Fund. Final municipal and HWRSD Cherry Sheet estimates provide controlled state-aid and charge context. The loaded evidence does not yet provide one complete FY2027 bridge that reconciles property-tax support, state aid, local receipts, transfers, available funds, free cash or reserves, and other nonrecurring sources to the full $57,018,471.
| Bridge component | Status | Current reporting treatment |
|---|---|---|
| Total uses · FY2027 General Fund | Known | $57,018,471 final-voted spending authority. |
| State aid and charges | Known with stage label | Final Cherry Sheet estimates; an estimate or assessment is not an actual payment. |
| Property-tax-supported amount | Not complete on FY2027 basis | Do not substitute the FY2026 actual levy of $48,746,259. |
| Local receipts and fees | Historical evidence only | Do not turn FY2017–FY2026 history into an unstated FY2027 forecast. |
| Transfers and other available funds | Bridge missing | Identify source fund, restriction, recurrence, authorization, and amount. |
| Free cash, reserves, other one-time funding | Use not reconciled here | Keep one-time support separate from dependable recurring revenue. |
Publication finding
We can account for the voted spending authority, but the loaded evidence does not yet provide a complete same-year bridge showing how every dollar will be funded. No “remaining revenue” or surplus is inferred.
FY2026 → FY2027
The loaded ATM comparison is not a year-over-year budget bridge.
A stable FY2027 display between preliminary and final stages answers a process question. It does not answer why the budget changed from the prior fiscal year.
Keep this sentence with the comparison
“Zero of 588 displayed cells changed” means the loaded FY2027 schedule remained unchanged during the documented pre-meeting-to-final process. It does not mean that spending did not change from FY2026 to FY2027.
Preserve the FY2027 stage-to-stage finding.
Label it as a preliminary-to-final schedule comparison, with the displayed-cell population and source dates attached.
Build the same-grain annual bridge.
Prior-year amount, current amount, dollar and percent change, department or service, recurring/one-time treatment, driver, unresolved driver, reclassification, and effect on the General Fund total.
Current readiness: limited.
The loaded records do not provide complete FY2026 department/account detail at the same grain as the FY2027 final-voted schedule. A partial comparison must not be presented as the whole answer.
Debt and capital evidence
Existing Town and HWRSD payment schedules are now visible; a complete forward portfolio is not.
The position values below are Town of Wilbraham FY2025 continuing-disclosure observations as of June 30, 2025, issuer-prepared and unaudited on a disclosure basis. A separate horizon now shows accepted annual Town and full-District HWRSD payment schedules through FY2040 and FY2041.
The duplicate $12,718,631 observations are not added together.
Do not add it to total direct debt as a separate obligation.
Funding treatment and annual payments still require review.
Authorization is not issued or outstanding debt.
| FY2025 disclosure observation | Amount | How to read it |
|---|---|---|
| Building direct debt outstanding | $10,275,000 | Component row from the direct-debt table. |
| Sewer direct debt outstanding | $1,079,631 | Component row; do not assume General Fund burden. |
| Water direct debt outstanding | $1,309,000 | Component row; source locator identifies the first numeric value. |
| Printed total direct debt / GO bonds | $12,718,631 | One source total appears in two normalized observations. Count it once. |
| Component-to-total difference | $55,000 | Calculated reconciliation gap between the three displayed components ($12,663,631) and the printed total. Preserve for source review; do not invent a category. |
| Prop 2½ debt-excluded principal | $3,291,000 | A classification within the debt picture, not another total to add. |
| Self-supporting debt principal | $2,417,631 | A classification within the debt picture, not proof of annual affordability. |
| Authorized but unissued · fire equipment | $984,000 | Possible future issuance; not existing outstanding principal. |
Do not label the position table “current Town debt.”
The annual horizon supplies accepted existing payment schedules, but a complete forward portfolio still needs the issue-to-security hierarchy, BAN/takeout/refunding lifecycle, exclusions, authorized-but-unissued amounts, later Wilbraham-supported District shares, future capital projects, and scenario timing. Debt rolling off does not automatically create affordable room for replacement debt.
See Town and HWRSD principal, interest, and total debt service by fiscal year →
Evidence basis: Wilbraham FY2025 Continuing Disclosure normalized observations; period end 2025-06-30; issuer-prepared unaudited; disclosure basis; explicit source-row mapping. Candidate disclosure evidence remains a discovery layer until mapping and canonical-source review are complete.
Household mechanics
Illustrate the calculation without predicting a household's bill.
A transparent band shows sensitivity to the applicable tax rate. It does not assume a current rate, assessment change, exemption, abatement, CPA surcharge, exclusion, or proposal effect.
Base calculation
(taxable assessed value ÷ 1,000) × applicable tax rate = calculated base property tax. For every $1.00 of tax rate, a $300,000 assessment produces $300 of base tax; a $500,000 assessment produces $500; and a $750,000 assessment produces $750.
| Illustrative taxable assessment | Bill effect for each $1.00 of applicable rate | Bill effect for each $0.10 of applicable rate | What this does not predict |
|---|---|---|---|
| $300,000 | $300 | $30 | A future tax rate, assessment, actual bill, exemption, abatement, CPA treatment, exclusion, or proposal-specific effect. |
| $400,000 | $400 | $40 | |
| $500,000 | $500 | $50 | |
| $600,000 | $600 | $60 | |
| $750,000 | $750 | $75 |
Share of taxable value
A property's assessment can change even when a Town-wide levy comparison is the focus.
Related, not interchangeable
The rate applies the levy across taxable value; a lower rate does not by itself prove a lower bill.
Exclusions and CPA
Debt/capital exclusions and a CPA surcharge require their own identified treatment.
Incremental effect
Show the proposal's authorized funding path and assessment-band effect separately from the full bill.
HWRSD boundary
Do not assign an unsupported percentage of an individual household bill to HWRSD. The District-wide budget, Wilbraham's assessment, Town appropriation, and household tax calculation are different stages and scopes.
Dollars, services, and the status quo
A financial choice is incomplete until the resident consequence is visible.
The new data improves the money history. It does not yet price every service baseline or the cost of continuing the current path.
Money → people/assets/programs → services → workload/capacity → resident consequence
For material areas, connect the amount to what it supports without claiming that spending alone caused an outcome.
“Do nothing” is not zero cost.
Include continuing operations, utilities, deferred maintenance, emergency repairs, code/accessibility exposure, service fragmentation, delay, cost escalation, opportunity cost, and risk.
Keep entity and allocation boundaries.
Connect HWRSD cost, enrollment, programs, capacity, staffing, transportation, and service pressure—then identify Wilbraham's supported share only where evidence exists.
Explain the public purpose.
Connect public safety, DPW, facilities, library, senior, recreation, health, and other funding to staffing, assets, demand, service levels, and risks.
Current readiness: partial.
Service categories and selected operational records are available, but a complete proposal-level chain and a comparable status-quo cost are not yet loaded. Options remain unranked.
Follow the number
Every material figure should open into its calculation, source, freshness, and missing evidence.
Discovery is now part of the five existing journeys. This supporting page is not a sixth journey.
01Resident question
02Short answer
03Measure identity
04Calculation
05Source + freshness
06Gap or next question
Follow purpose and performance.
Budget line → department → service purpose → expense type → actual spending → evidence gaps.
Follow authority and obligations.
Project → Town Meeting authority → funding sources → debt issue → annual payments → operating tail.
Follow the entity handoffs.
District total → Wilbraham assessment → debt → state aid → enrollment → Town appropriation → household boundary.
Follow the service and asset story.
Current use → parcel → condition → operating expense → capital need → scenario action → governance requirement.
Four useful links beside a number
How is this number built? · Why can't these figures be added? · What changed? · What could affect this next?
What would close the affordability finding
The new data narrows the next requests.
These are missing requirements, not zeros and not permission to infer a favorable or unfavorable result.
Governed multi-year forecast
Recurring revenue and expenditure, one-time items, assumptions, risks, scenarios, and compatible municipal budget-to-actual detail.
Timing and availability
Receivables, payables, payroll, debt service, state-aid timing, reimbursements, restrictions, and reserve policies.
One forward portfolio
Project scope, timing, full cost, funding source, issued and unissued debt, annual schedules, exclusions, operating impacts, maintenance deferral, and condition/criticality.
Distribution and consequences
Assessment bands, exemptions, service levels, workload/capacity, status-quo effects, proposal effects, and locally governed risk tolerances.
Complete funding bridge
Reconcile every General Fund source to the final-voted $57,018,471 on the same budget basis.
Change-and-driver bridge
Same-grain prior/current amounts, recurring/one-time treatment, known and unresolved drivers, and reclassifications.
Current overall finding
Affordability Evidence v2 is ready for historical context, legal-capacity explanation, existing scheduled-payment and dated debt facts, standardized tax-base distribution sensitivity, household mechanics, and evidence discovery. Dependable remaining recurring capacity is not determinable from current evidence.