Civic Stewardship Studio™
Powered by the Civic Stewardship Knowledge Engine™
← Project overview
Draft for community decision discussion • v0.3.8 • August 14, 2026

Making better Town decisions by seeing the whole picture

A plain-language walk-down for understanding and comparing major Town choices.

This is not a recommendation for or against a particular project. It is a proposed way to put purpose, money, service, alternatives, community effect, and implementation in one decision view before choices become commitments.

How to begin the detailed path

The resident guide asks, “What do these numbers mean for me?” This edition asks, “What should the Town see together so that a financially legal choice also becomes an understandable, sustainable, and well-executed choice?”

This is the deepest report path. You do not need to read every section in order. Begin with the eight questions and current picture. Then use the navigation above to move directly to the evidence that matters for the proposal you are reviewing. If the finance terms are new, start with the resident high-level story. If you are trying to understand who acts and when, follow the annual financial process journey first.

Not finance after the decision

Financial analysis is most useful while the problem, alternatives, timing, site, service design, and funding method can still change—not only after a preferred project is defined.

Not one proposal in isolation

Every decision competes with current services, HWRSD, debt, reserves, staff capacity, other capital work, and household capacity. That shared constraint is the portfolio.

Not cost without value

A smaller number is not automatically a better decision. The Town needs the cost, the service outcome, alternatives, risks, and the community qualities or assets affected.

Not approval without follow-through

A vote or appropriation is one gate. Procurement, implementation, operating funding, maintenance, measurement, and later review determine whether the intended result is actually delivered.

Central idea: a whole-picture view does not replace judgment. It gives different decision-makers the same reproducible baseline, exposes tradeoffs early, and makes disagreements more specific and useful.
Back to top

Eight questions before a major commitment

These questions can sit above a budget article, capital proposal, property decision, service redesign, borrowing, or regional-school discussion.

No.Decision lensQuestion to answer
1Purpose and resultWhat problem are we solving, what result should change, and how does it support the services and community qualities Wilbraham intends to sustain?
2BaselineWhat exists today—cost, staffing, service, condition, legal status, revenue, debt, and risk—and what source proves it?
3TimeWhat changes this year, over five years, and over the asset or obligation's full life? Which effects are recurring and which are one-time?
4FundingWhich source pays—recurring revenue, levy capacity, fee, grant, reserve, sale proceeds, or borrowing—and what is the replacement plan if it is temporary?
5PortfolioHow does this fit beside current Town operations, HWRSD, existing debt, pension/OPEB, reserves, and other proposed capital work?
6AlternativesWhat credible alternatives were considered, including redesign, phasing, reuse, collaboration, delay, another site, or doing nothing?
7ConsequencesWhat happens to services, households, taxpayers, staff, neighborhoods, assets, and community character under each alternative?
8Execution and learningWho decides, who implements, what evidence is required at each gate, how will results be measured, and when will the decision be revisited?

Different roles—one consistent picture

ParticipantPrimary lens this shared view can support
Town administration and departmentsOperational feasibility, staffing, procurement, schedule, dependencies, legal implementation, source quality, and ongoing management.
Select BoardPolicy direction, priorities, alternatives, public value, tradeoffs, executive accountability, and whether a proposal is ready to advance.
Finance CommitteeFinancial reasonableness, sustainability, recurring-versus-one-time discipline, revenue and levy capacity, debt and reserve effects, assumptions, and recommendation.
Town Meeting and voters, where applicableThe exact appropriation, borrowing, exclusion, or other formal choice presented—supported by an understandable account of its consequences.
Boundary: this is a decision-support framework, not a statement of anyone's complete legal authority. Exact statutes, bylaws, charter provisions, warrant language, vote thresholds, and counsel guidance still control.
Back to top

The current whole-picture snapshot

Each number answers a different question. The value of the view is not adding them together; it is seeing their direction, scope, timing, and interaction.

TOWN DISCLOSURE

Town budget

$48,322,189 → $56,595,042

+$8,272,853 • 17.1%

FY2021–FY2025; about 4.0% annualized.

TOWN DISCLOSURE

Actual levy

$40,826,000 → $47,337,000

+$6,511,000 • 15.9%

FY2021–FY2025; Town-wide property-tax total.

DISTRICT DISCLOSURE

HWRSD budget

$50,281,358 → $57,289,029

+$7,007,671 • 13.9%

FY2022–FY2026; budget, not actual expenditure.

FY2026 ESTIMATE

Wilbraham member amount

$32,275,236.25

77.4% of the two-town amount

Not 77.4% of a household tax bill.

CALCULATED EXAMPLE

One home's base tax

$11,484 → $12,881

+$1,397 • 12.2%

Susan's example; not a Town-wide median.

AUDITED BASELINE

Town debt outstanding

$12,745,767

June 30, 2024; five instruments. Later financing requires a current consolidated schedule.

FY2027 EXPENSE CONTROL

Warrant-budget detail

$66,372,362

473 accounts of adjusted expenditure budget; a different year and scope from the published total-budget series.

OWNERSHIP-CONTROLLED

Town-owned parcels

171

Out of 197 loaded parcel-card rows; parcels are not the same as buildings, developable sites, or surplus property.

PRELIMINARY INVENTORY

Known grant programs

48

Research starting points only; not guaranteed complete, current, eligible, awarded, received, or available.

Why this matters: the Town budget, levy, revenue, assessment, tax bill, District budget, member assessment, and debt are connected—but none is a synonym for another. A good decision package states the measure and denominator beside every number.
Back to top

2026 Annual Town Meeting: what changed from preliminary to final?

The database now connects the preliminary schedule, voter workbook, anticipated motion, final vote, all 588 displayed budget cells, warrant articles, motions, recommendations, votes, and controlled exceptions.

$57,018,471

April 14 preliminary

$57,018,471

May 11 workbook

$57,018,471

Final voted

0 of 588

Displayed cells changed

Do not miss the intermediate event: the May 6 anticipated Article 19 motion was $57,041,471—$23,000 above the April schedule. The final vote reversed it. The loaded evidence does not identify the affected line.
Evidence dateStageAmountChange from AprilWhat the evidence supports
2026-04-14Select Board Pre Meeting Proposed$57,018,471Standalone preliminary schedule
2026-05-06Anticipated Article 19 Motion$57,041,471$23,000Temporary $23,000 increase; no loaded source identifies the line
2026-05-11Meeting Presented Workbook$57,018,471$0All 588 displayed cells match the April schedule
2026-05-11Final Voted$57,018,471$0Final vote returned to the April/workbook amount
HWRSD share of the final-voted General Fund: $31,662,062 assessment + $1,432,613 debt = $33,094,675, or 58.042% of $57,018,471. The workbook's separately reported 55% chart remains a rounded source presentation with an unresolved methodology bridge.
Latest-evidence boundary: no post-May-11 budget version is loaded. The report can prove the final-voted result as of May 11; it cannot yet prove whether a later transfer, amendment, or other change occurred.
Back to top

Begin with the two major choices now in front of the Town

The Middle School capacity problem and the four BUC building scenarios need a common decision structure now—even before every alternative is designed or costed.

Middle School capacity

The working decision premise is that Wilbraham Middle School is over capacity. Collected District evidence reports 613 students on October 1, 2024 and projects 614 for 2025–26, but the current extract does not yet contain rated capacity, functional program capacity, room utilization, enrollment by grade, or a current multi-year forecast.

BUC buildings

The original four working scenarios are preserved below. They affect Memorial School and, depending on the scenario, Town Hall, Little Red School House, the Former Police / IT Building, and other properties that have not yet been specifically named.

Shared portfolio constraint

The decisions are separate, but they compete for cash, debt capacity, annual operating room, staff capacity, project timing, and the ability to address other capital needs.

What the database already says about Wilbraham Middle School

AssetParcelReported acres2021 square feet2021 critical2021 non-critical2021 reported deferred2021 ten-year inflatedFY2027 Town facility allocationQA exceptions
Wilbraham Middle School487463.12099,750$38,419$102,564$140,983$1,010,638Not explicitly allocated0
Do not confuse condition with capacity: the 2021 assessment supplies building-condition and planning-cost evidence. It does not establish how many students the building can support, whether it is educationally adequate, what space is constrained, or what response should be selected.

Preserve the four BUC scenarios before comparing them

CodeWorking scenarioAssets explicitly namedWhat must be measured
BUC-01Consolidate into Memorial School; sell Town Hall, Little Red Schoolhouse, and the former Police/IT building.Memorial School; Town Hall; Little Red School House; Former Police / IT BuildingConsolidation design; functions and occupants moving; renovation and transition work; service continuity; legal and property restrictions; sale authority, timing, and net proceeds; recurring operating change.
BUC-02Maintain current approach with improvements.Current BUC building arrangement; exact improvement list not loadedCurrent use, condition, utilization, accessibility, safety, service delivery, full operating cost, improvement scope, funding, sequencing, and retained flexibility for each building.
BUC-03Sell Memorial School; evaluate redevelopment of some properties.Memorial School; other properties are not yet specifically identifiedFunctions displaced; replacement locations; legal and property restrictions; redevelopment criteria; community and service effects; transition cost; timing; proceeds; meaning of “some properties.”
BUC-04Reimagine Memorial as community center.Memorial SchoolProgram and service model; users; occupancy and code needs; renovation scope; operating owner; staffing; annual cost and revenue; other building effects; implementation phases; measures of community value.
2021 SOURCE MEASURE
$1,558,190

BUC reported deferred maintenance

Four affected assets; point-in-time 2021 evidence.

ORIGINAL 2022–2031 HORIZON
$453,115

BUC inflated projection

Kept separate from deferred maintenance because the measures may overlap.

PARTIAL FY2027 MAPPING
$768,400

Explicit facility allocations

Memorial, Little Red, and Town Hall only—not total cost or savings.

AssetParcelReported acres2021 square feet2021 critical2021 non-critical2021 reported deferred2021 ten-year inflatedFY2027 explicit allocationQA exceptions
Memorial School273339.99748,895$24,002$1,274,063$1,298,066$203,551$500,0002
Town Hall45614.80911,446$46,591$176,908$223,499$105,859$53,7500
Little Red School House45100.7922,840$6,250$6,854$19,354$59,191$214,6501
Former Police / IT Building26520.7503,193$5,000$7,271$17,271$84,514Not explicitly allocated1
What remains missing: current condition and completed-work status; space use and utilization; people and programs in each building; complete operating and lifecycle cost; renovation and transition scopes; service consequences; legal/title/restriction review; sale or redevelopment assumptions; financing; timing; and who owns delivery and measurement.
Back to top

The biggest forward financial decisions: building use, capital, and Wilbraham Middle School

These are different decisions, but they form one forward capital picture. Every option draws on some combination of cash, debt and levy capacity, annual operating room, staff time, project sequencing, and the Town's ability to address other capital needs. The evidence can now show what is known and how ready each choice is; it cannot yet select or financially rank an option.

Wilbraham Middle School

The school is reported as over capacity. The loaded evidence supports a sharper facilities question—where grade, program, room type, and schedule constraints occur—but does not contain rated or functional capacity needed to measure the gap.

Building utilization

Four public scenario questions now connect to six working variants. The database makes unresolved uses, execution blockers, property constraints, and developer-leaseback risks visible before an option is treated as feasible.

Capital commitments

A usable comparison must include project, financing, transition, operating, maintenance, service, and household effects. Partial appropriations or a renovation estimate alone are not a complete cost.

Middle School: enrollment context changes the question, not the reported concern

2,890 → 2,836 → 2,830

District enrollment: 2021–22 actual, 2025–26 actual, and 2026–27 projected. Districtwide decline does not disprove school-level crowding.

613 → 614

WMS students on 2024-10-01, then the AY2025-26 projection. Enrollment counts are not capacity measures.

$140,983

WMS source-reported 2021 deferred maintenance. The separate original ten-year inflated projection was $1,010,638.

What this means: districtwide enrollment moved down while WMS stayed near 613–614 students. That redirects due diligence toward local grade configuration, educational programs, room types, and scheduling. The building is listed as built in 1968 with no remodel year printed; age is a reason to investigate, not proof of condition or replacement need.

Town–District capital connection: the loaded disclosure describes Lease of Wilbraham elementary/middle school buildings facilities and grounds; One dollar; term not to exceed twenty years; renewed July 1 2015. It also states: “Capital outlay for leased elementary and middle schools is assessed only to the town where the building is located.” WMS is therefore both an educational-space question and a Town asset/capital question.

Needed measureLoaded statusWhy it matters
Rated design capacityNot loadedNeeded for a verified enrollment-to-capacity percentage.
Functional program capacityNot loadedShows whether room types and educational programs constrain usable space.
Room and schedule utilizationNot loadedShows where and when crowding occurs.
Enrollment by grade and multi-year forecastNot loadedSizes and times a durable response rather than reacting to one total.

Building utilization: the questions are structured, but the economics are not

The four original scenario families remain the comparison frame. The six database variants are working configurations—one current-arrangement baseline and five possible changes—not adopted recommendations.

Scenario familyWorking variantRoleUnresolved functionsUnresolved blockersRecorded risksFinancial readiness
Option 1 - Consolidate municipal functions at MemorialOption 1B - Developer-owned leasebackWorking change344Lease economics unspecified
Option 1 - Consolidate municipal functions at MemorialOption 1A - Town-owned consolidationWorking change340Only the 30-year horizon is populated
Option 2 - Maintain current arrangementOption 2A - Current arrangementCurrent baseline000Complete cost of keeping is not loaded
Option 3 - Sell or redevelop MemorialOption 3A - Memorial dispositionWorking change300Only the 30-year horizon is populated
Option 4 - Reimagine Memorial as a community centerOption 4B - Developer-owned community-center leasebackWorking change303Lease economics unspecified
Option 4 - Reimagine Memorial as a community centerOption 4A - Town-owned community centerWorking change300Only the 30-year horizon is populated

Memorial uses still unresolved

  • Wrestling program
  • Pickleball
  • Other Memorial recreation functions

Every nonbaseline variant leaves these three current functions without a resolved destination.

Option 1 execution blockers

  • Protect Senior Center access before Town Hall disposition
  • LRS pond and wetland due diligence
  • LRS Article 97 determination
  • LRS deed and title clearance

Both Option 1 variants carry all four as unresolved, potentially blocking requirements.

Developer-leaseback risks

Bundled transaction dependency, Lease escalation exposure, Loss of residual ownership value, Reduced property control. Bundling applies where the loaded configuration joins multiple properties.

The two lease-term records leave rent, area, term, escalation, renewal, maintenance allocation, termination, and purchase terms unspecified.

Financial-readiness boundary: the scenario model defines 13 possible parameters but contains only 6 values—all the same 30-year comparison horizon. No loaded variant supplies sale proceeds, renovation cost, lease or program revenue, tax revenue, housing units, delay/carrying cost, or legal and environmental clearance cost. The baseline's zero recorded blockers and risks does not mean that keeping the current arrangement is risk-free; its complete cost is not loaded.

Capital: show the cost of keeping and the cost of financing

$1,558,190

2021 source-reported deferred maintenance across the four BUC assets.

$1,298,066

Memorial alone—83.3% of that four-asset deferred total.

$768,400

Partial FY2027 explicit allocations across 3 assets. This is not total ownership, lifecycle, or scenario cost.

$453,115

Separate original ten-year inflated projection for the four BUC assets. Do not add it to deferred maintenance because the measures may overlap.

Why financing belongs in every future comparison: the final permanent Senior Center financing provides a concrete example: $6,680,000 principal + $2,327,964 contractual interest = $9,007,964 scheduled debt service. That still excludes temporary BAN interest, issuance costs, operating, maintenance, staffing, and future renewal/lifecycle costs.

What the reporting can—and cannot—say now

The reporting can nowThe reporting still cannot
Place WMS, BUC building use, 2021 capital needs, parcels, constraints, Town allocations, and financing in one forward portfolio.Verify the WMS over-capacity percentage or identify the constrained grades, rooms, programs, and periods.
Compare scenario structure and readiness: assets, actions, unresolved functions, blockers, risks, and missing assumptions.Financially rank the BUC variants or calculate net savings, proceeds, rent, household effect, or service value.
Show why principal-only or partial-account comparisons understate a long-lived capital decision.Recommend a building outcome without current condition, utilization, full lifecycle cost, funding, timing, transition, and service evidence.
Back to top

Other existing data connected behind the main stories

The same reporting path also reaches security-level debt, audited statements and compliance, property-card history, HWRSD operations, the complete asset/building registry, and the source-provenance graph.

Reporting rule: decision facts receive row-level extracts; source pages, lines, tokens, and crosswalks are connected by count and QA role so they are not mistaken for unique financial facts.

Back to top

Historical FY2025 signals: what was visible before the next year arrived?

The official FY2025 Finance Committee presentation contained four stories that help explain how multi-year pressure builds: costs already entering the next year, a faster reported school-increase pace, one-time funding, and a request to see the whole Memorial School project before approving more pieces.

Historical-source boundary: these are FY2025 packet statements and forecasts, not current audited results. The presentation is a supplemental official source for this explanation; it has not been added to or used to change the controlled 410-source database register.
FY2026 FORECAST IN FY2025 PACKET

Pressure visible before salaries, schools, and other capital

$1.265 million

$365,000 Senior Center debt + $300,000 roads + $200,000 group insurance + $300,000 fire engine + $100,000 IT subscriptions.

SCALE COMPARISON

Share of the packet's recent tax and new-growth increase

82.6% / 78.0%

$1.265 million was 82.6% of the cited FY2024 increase and 78.0% of the cited FY2025 increase. This shows magnitude, not earmarking.

POTENTIAL REVENUE

Dispatch did not erase the whole stack

$865k–$1.015m

After the packet's prospective $250,000–$400,000 Central Dispatch range, this much of the identified stack would remain.

REPORTED HWRSD PACE

Later average annual increase

$1.106m

Displayed FY2023–FY2025 increases average $1,106,349, compared with $689,569 for FY2019–FY2022—about 60.4% higher.

FY2026 anticipated items stated in the packet$365,000 + $300,000 + $200,000 + $300,000 + $100,000
Pressure stack before salaries, schools, and other capital$1,265,000

One-time money paid one-time purchases

The packet says $2.000 million of free cash supported vehicles, a mower, and wireless access points, with another $168,000 used at the FY2024 Special Town Meeting for Minnechaug capital improvements.

Decision lesson: preserve the distinction between an available balance and recurring annual revenue, then identify any later maintenance, subscription, staffing, or replacement cost.

Memorial School triggered a whole-project gate

The packet describes an approximately $5 million, four-to-five-year concept and four approximately $250,000 funding components. It says FinCom requested a formal total-project proposal and did not recommend further renovation investment until taxpayer review.

Decision lesson: the whole scope, phases, sources, conditions, operating effects, and total cost belong in view before serial appropriations narrow the remaining choices.

Reconciliation controls: the packet's four listed FY2025 funding sources sum to $59,550,895, not its reported $58,685,075 total—an unresolved $865,820 difference. Its $47,290,728 levy and $500,000 new-growth amounts were estimates; later controlled figures are $47,337,000 and $548,000. Its 56%, 54.83%, and the controlled 53.38% school shares use definitions or denominators that have not been reconciled.
Back to top

Walk-down view 2: where did change appear?

Driver views locate pressure. They do not prove the underlying cause until staffing, contracts, service, facilities, and account detail are linked consistently.

Town reported positive movements, FY2021–FY2025

The 100% denominator is $10,520,297 of positive movements—not the smaller net budget increase after offsets.

Schools
General
Benefits
Safety
Other
Schools: $3,940,529General government: $2,951,249Benefits/insurance: $1,389,132Public safety: $703,011Other positive movements: $1,536,376
Reconcile before interpreting: $10,520,297 positive movements − $326,140 debt-service decline − $1,921,304 other offsets/presentation effects = $8,272,853 net increase.

HWRSD positive category changes, FY2022–FY2026

The 100% denominator is $7,082,867 of positive category movements.

Instruction
Operations
Fixed
Tuition
Admin
Services
Instruction: $3,448,539 • 49.2% of net increaseOperations and maintenance: $1,264,847 • 18.0%Fixed charges: $955,101 • 13.6%Outside tuition: $543,540 • 7.8%Administration: $473,965 • 6.8%Other school services: $396,875 • 5.7%
Source control: $7,082,867 positive changes − $75,195 capital decline = $7,007,672, one dollar above the source-printed total-budget change of $7,007,671.

Enrollment counter-trend

2,890 → 2,836

-1.9%

The budget increased 13.9%. Enrollment growth does not explain that increase.

Net-state-aid coverage

27.4% → 26.0%

The selected aid measure covered a smaller share of the District budget. This is a pressure indicator, not a complete funding reconciliation.

Decision use: move from “where did it grow?” to “why did it grow?” through comparable account, position, contract, facility, utilization, and service-result evidence. Broad categories form the investigation map.
Back to top

Walk-down view 3: rotate the FY2027 warrant budget across several axes

The broad historical categories show where change appeared. The 473-account FY2027 Expense Control report lets leadership inspect the current budget from several directions without pretending that one hierarchy answers every question.

Do not make this a growth point: the FY2027 adjusted expenditure budget is $66,372,362 across General Operating, enterprise, special-article, receipts-reserved, Community Preservation, and revolving-fund authority. It is a different year and scope from the FY2025 published total budget of $56,595,042. The difference between them is not a one- or two-year growth calculation.

Begin with concentration

The two rows answer separate questions and are not added together.

Top 5 accounts
63.2%
Remaining accounts
63.2%
Top 25 accounts
81.0%
Remaining accounts
81.0%
Top five: five account lines hold 63.2% of budget authority.Top 25: 5.3% of accounts hold 81.0% of the total.Decision implication: understand the largest flows before debating small line items.
Run the top-level launcher for the new account drill-down: this packaged static edition does not contain the live 473-row account extract. The launcher now creates acct_detail.csv, rebuilds this page, and exposes each grouping and department as a clickable list of exact source accounts.

Axis 1: what service or public purpose does the budget support?

The service-purpose classification is a CSKE analytical overlay. Town department and account labels remain unchanged.

Education
Safety
Public works
Benefits
Other
Education: $33,603,523 • 50.6%Public safety: $8,951,426 • 13.5%Public works/utilities/environment: $8,132,616 • 12.3%Employee benefits: $5,656,384 • 8.5%All other purposes: $10,028,413 • 15.1%
CSKE service-purpose categorySource accountsAdjusted budgetShare of this report
Education11$33,603,52350.6%
Public Safety and Emergency Services82$8,951,42613.5%
Public Works Utilities and Environmental Services127$8,132,61612.3%
Employee Benefits3$5,656,3848.5%
Community and Resident Services66$2,415,8893.6%
Governance Elections and Civic Administration41$1,470,7072.2%
Debt Service and Financing Costs7$1,386,2292.1%
Facilities and Municipal Asset Stewardship25$1,365,3902.1%
Financial Administration and Revenue37$1,023,0871.5%
Risk Management and Required Financial Protections6$1,012,0001.5%
Internal Administration and Support16$887,2521.3%
Public Health Protection and Inspection32$288,5260.4%
Planning Conservation and Community Character20$179,3330.3%

Axis 2: what kind of cost is the Town buying?

expense nature separates unlike commitments. A regional assessment, salary, capital project, debt payment, facility repair, and technology purchase should not be discussed as though the same action could change each one.

Programs/transfers
Personnel
Debt
Capital
Other
Programs, aid, and transfers: $31,975,737 • 48.2%; dominated by the regional-school operating assessment.Personnel: $19,787,237 • 29.8%.Debt and financing: $3,890,702 • 5.9%.Capital: $3,765,348 • 5.7%.All other expense groups: $6,953,338 • 10.5%.
CSKE expense groupSource accountsAdjusted budgetShare of this report
Programs Aid and Transfers16$31,975,73748.2%
Personnel119$19,787,23729.8%
Debt and Financing14$3,890,7025.9%
Capital Projects and Major Acquisitions24$3,765,3485.7%
Contracted Services and Administration130$2,194,9213.3%
Facilities Buildings and Occupancy53$1,700,0562.6%
Technology Equipment Vehicles and Materials105$1,596,3492.4%
Risk Insurance and Financial Protection7$732,9501.1%
Reserves Contingencies and Pools5$729,0621.1%

Axis 3: which accounting container holds the authority?

fund family is not the same as revenue source. Enterprise placement is meaningful, but it does not prove that every dollar came from current-year user charges; a restricted-looking fund still requires legal and source confirmation.

General Operating
Enterprise
Special articles
Other funds
General Operating: $57,018,471 • 85.9%Enterprise: $4,021,873 • 6.1%Special Article: $3,078,348 • 4.6%Receipts-reserved, CPA, and revolving: $2,253,670 • 3.4%
CSKE fund familySource accountsAdjusted budgetShare of this report
General Operating Fund357$57,018,47185.9%
Enterprise Fund77$4,021,8736.1%
Special Article Fund18$3,078,3484.6%
Receipts Reserved for Appropriation7$1,582,2702.4%
Community Preservation Fund5$560,4000.8%
Revolving Fund9$111,0000.2%

Axis 4: where is the cost displayed, and who ultimately benefits?

accounting presentation protects against reading a source cost center as the final beneficiary. Centralized benefits, insurance, IT, facilities, salary pools, and regional assessments require their own allocation logic.

Regional
Source departments
Benefits
Other centralized
Regional assessment: $33,603,523 • 50.6%Source department cost centers: $23,264,501 • 35.1%Centralized benefits: $5,656,384 • 8.5%Other centralized/reserve/pass-through: $3,847,954 • 5.8%
CSKE accounting presentationSource accountsAdjusted budgetShare of this report
Regional Assessment11$33,603,52350.6%
Source Department Cost Center415$23,264,50135.1%
Centralized Benefits3$5,656,3848.5%
Centralized Facilities or Utilities18$1,311,6402.0%
Centralized Insurance5$1,010,0001.5%
Centralized Information Technology15$722,2521.1%
Centralized Salary Pool4$479,0620.7%
Reserve or Contingency1$250,0000.4%
Pass-Through or Transfer1$75,0000.1%

Department index: open the exact source-account lines

This is the source-cost-center view. It is especially useful when a leadership office or department asks which lines were included. It does not by itself prove which service or resident ultimately benefits from a centralized cost.

Axis 5: which building costs can currently be shown?

Only explicit, evidence-backed facility allocations are presented. They identify known account mappings—not utilities, staff time, shared services, deferred maintenance, capital renewal, or complete cost of ownership.

FacilityMapped accountsAllocated FY2027 budgetConfidenceBoundary
Memorial School3$500,000HIGHExplicit evidence-backed mapping only; not complete building cost.
Little Red Schoolhouse6$214,650HIGHExplicit evidence-backed mapping only; not complete building cost.
Town Hall7$53,750HIGHExplicit evidence-backed mapping only; not complete building cost.
Why this matters for property decisions: a building with only $53,750 or $214,650 explicitly mapped should not be called inexpensive, expensive, surplus, or unaffordable from that number alone. The proper baseline adds all direct and shared operating costs, condition, capital needs, utilization, revenue, legal status, service value, alternatives, and the cost or lost value of disposition.

The discipline before asking “what can we cut?”

spending flexibility is still unassessed for all 473 accounts. The current source does not establish which costs are legally fixed, contractually constrained, operationally necessary, changeable at the next budget, or reducible only with a service consequence. In addition, 247 accounts totaling $4,674,021 do not yet have even a provisional cost driver.

Missing evidence is not discretion: “unassessed” is an intentional control. The next layer should attach statutes, contracts, bargaining terms, debt schedules, regional rules, service levels, cost drivers, controllability, time horizon, and reduction consequence before assigning labels such as mandatory, fixed, flexible, or discretionary.
Back to top

Walk-down view 4: the Town's parcel and managed-asset portfolio

Before deciding whether land or a building should be retained, changed, leased, reused, protected, improved, or sold, leadership needs a controlled inventory—and a clear separation between what the database proves and what still requires title, legal, physical, operating, and community evidence.

Reconciling “about 200 parcels”: the database has 197 loaded FY2026 parcel-card rows. The Town-owned parcel control identifies 171 with a current owner of TOWN OF WILBRAHAM, public-owner indicator Y, and provisional class MUNICIPAL. Three cards name another current owner; 23 have no current ownership row. The report does not silently call those 26 Town-owned.
LOADED SOURCE CARDS

Parcel-card records

197

The inventory scope—not the ownership conclusion.

CURRENT OWNER CONTROL

Town-owned parcels

171

One controlled current ownership row per Vision ID.

REPORTED AREA

Mechanical acreage sum

2,027.888

Source-reported acres; not surveyed or developable acres.

CORE REGISTRY

Managed assets

22

23 parcel links and 30 building identities.

What the parcel cards report about improvements

This bar classifies all 171 parcels meeting the current Town-owner control. It does not classify use, necessity, restriction, condition, or disposition readiness.

159 vacant-label parcels
12 improved/reported
Vacant label: 159 • 93.0%Improved or improvements reported: 12 • 7.0%
“Vacant” does not mean “available”: a card may show no primary improvement while the land still serves drainage, conservation, recreation, access, utilities, buffers, future public needs, neighborhood character, or another purpose. Deeds, Article 97 or other protections, easements, environmental conditions, access, utilities, zoning, and public process remain separate evidence.

Three layers that should not be confused

LayerWhat it tells leadershipWhat it does not prove
Parcel inventoryWhere the 171 ownership-controlled land records are, their source acreage, use/status codes, deed references, and assessment fields.A legal lot, developability, unrestricted ownership, complete current use, or readiness for sale.
Managed-asset registryWhich 22 facilities, parks, recreation properties, and reference properties currently have a curated decision identity.That every Town parcel has been evaluated as an asset—or that unregistered parcels lack public value.
Building registryWhich 30 physical structures have a stable identity linked to managed assets.Complete condition, utilization, operating cost, deferred maintenance, code needs, or replacement cost.

What a property decision packet should answer

Decision questionMinimum evidence before advancing
What public purpose does it serve now?Current use, users, service delivered, land function, department responsibility, operating cost, revenue, and measurable result.
What do we legally own and control?Current deed, title, legal parcel, easements, restrictions, trust or gift terms, Article 97 or other protected status, votes, and authority.
What is physically possible?Survey, access, utilities, wetlands/environmental conditions, zoning, condition, capacity, code, traffic, parking, and realistic project cost.
What are the credible alternatives?Retain, maintain, repair, share, lease/license, adaptively reuse, consolidate, protect, acquire, dispose, or take no action—using comparable assumptions.
What is the full financial effect?Life-cycle operating and capital cost, debt, grant eligibility, transition cost, revenue or proceeds, replacement services, risk, and opportunity cost.
What would the community gain or give up?Service access, historic fabric, green space, safety, neighborhood effect, future flexibility, sense of place, and the qualities residents want Wilbraham to retain.
Who decides, and when?Applicable boards, Town Meeting or voter action, procurement/disposition law, public notice, legal review, decision gates, implementation owner, and later review. A surplus property conclusion comes after this evidence—not before it.

Curated managed assets and parcel links

Twenty-two managed assets produce 23 link rows because one managed property spans more than one parcel. A link row is not an additional asset.

Managed assetTypePrimary addressSource parcel IDReported acresRelationshipBuilding identitiesScope note
Wilbraham Public LibraryFacility25 CRANE PARK DR WILBRAHAM MAF_404404_28708596.040000Located On1Known municipal library facility.
Former Police / IT BuildingFacility16 MAIN ST WILBRAHAM MAF_405091_28812840.750000Located On1Initial Building Utilization scenario asset at 16 Main Street.
Memorial SchoolFacility318 MAIN ST WILBRAHAM MAF_404754_287475939.997000Located On1Initial Building Utilization scenario asset at 318 Main Street.
Old Meeting HouseFacility450 MAIN ST WILBRAHAM MAF_403712_28712540.537000Located On1Known historic community facility.
Crane ParkPark or open space322V MAIN ST WILBRAHAM MAF_403655_28709640.769000Located On0Known park asset; no building is inferred from the property roster.
Gazebo ParkPark or open space480 MAIN ST WILBRAHAM MAF_403548_28705271.540000Located On0Known park asset; the gazebo is not automatically classified as a building.
Children's MuseumFacility678 MAIN ST WILBRAHAM MAF_402445_28659181.200000Located On1Known community facility included in the initial controlled asset registry.
Little Red School HouseFacility28 SPRINGFIELD ST WILBRAHAM MA 01095F_402641_28706800.792000Located On1Initial Building Utilization scenario asset at 28 Springfield Street.
Town HallFacility240 SPRINGFIELD ST WILBRAHAM MAF_397755_28703674.809000Located On1Initial Building Utilization scenario asset at 240 Springfield Street.
Wilbraham Country ClubRecreation property859 STONY HILL RD WILBRAHAM MAF_394713_2867770170.179000Located On2Separate recreation asset represented within the combined Senior Center and Country Club property research unit.
Senior CenterFacility250 SPRINGFIELD ST WILBRAHAM MA 01095F_394713_2867770170.179000Located On1Separate municipal Senior Center asset located on shared parcel 4977; operational address is 250 Springfield Street.
Fire Station 2Facility6 WOODLAND DELL RD WILBRAHAM MAF_403787_28704040.505000Located On1Known municipal public-safety facility.
Department of Public WorksFacility2721 BOSTON RD WILBRAHAM MAF_404713_28813772.250000Located On5Known municipal operating facility; individual structures require later verification.
Fire HeadquartersFacility2770 BOSTON RD WILBRAHAM MAF_405257_28821471.500000Located On1Known municipal public-safety facility; source property label is New Fire Station.
Police DepartmentFacility2780 BOSTON RD WILBRAHAM MAF_405530_28823041.423000Located On1Known municipal public-safety facility; source property label is New Police Department.
Spec Pond Recreation SiteRecreation property2540V BOSTON RD WILBRAHAM MAF_401662_288099810.400000Includes6Distinct Spec Pond parcel linked to the shared recreation-site asset.
Spec Pond Recreation SiteRecreation property2540V BOSTON RD WILBRAHAM MAF_401783_288180528.000000Includes6Distinct Spec Pond parcel linked to the shared recreation-site asset.
Stony Hill SchoolFacility675 STONY HILL RD WILBRAHAM MAF_396593_287124411.420000Includes1Town-owned Stony Hill School parcel and facility asset.
Soule Road SchoolFacility300 SOULE RD WILBRAHAM MAF_397143_286049013.500000Includes1Town-owned Soule Road School parcel and facility asset.
Wilbraham Middle SchoolFacility492 STONY HILL RD WILBRAHAM MAF_397558_287528163.120000Includes1Town-owned Wilbraham Middle School parcel and facility asset.
Mile Tree SchoolFacility625 MAIN ST WILBRAHAM MAF_401698_28667708.842000Includes1Town-owned Mile Tree School parcel and facility asset.
Sewer Treatment PlantFacility2480 BOSTON RD WILBRAHAM MAF_401049_288258524.400000Includes1Town-owned parcel evaluated separately as the sewage-treatment facility asset.
481 Main StreetReference property481 MAIN ST WILBRAHAM MA 01095F_402858_28704752.980000Located On1Privately owned reference property represented as an asset solely to support contextual property and building relationships.

Attach the 2021 capital-needs evidence—without making it current by implication

The database also contains a capital needs assessment prepared by EBI Consulting and dated August 23, 2021. Its 17 assessment properties are linked to 17 managed assets, 27 building identities, and 18 parcel relationships. That is the defensible attachment point: site-level findings remain attached to the assessed property while readers can still navigate to every related building and parcel.

Time boundary: these are point-in-time conditions from 2021, with an original 2022–2031 horizon. They are not current 2026 conditions or prices, approved projects, appropriations, commitments, actual expenditures, or proof that listed work remains undone. Before a decision, the Town should mark each item completed, still open, superseded, rescoped, or newly verified and then obtain current estimates.
2021 SOURCE TOTAL

Critical repairs

$1,318,312

Source snapshot classification; three properties are affected by extraction exceptions.

2021 SOURCE TOTAL

Non-critical repairs

$3,777,199

Source snapshot classification; Memorial detail has an unresolved extraction exception.

REPORTED MEASURE

Deferred maintenance

$5,106,762

Reported across 17 snapshots; not a current appropriation request.

Why the totals are shown separately: critical repairs plus non-critical repairs equal $5,095,511, which is $11,251 below the source-reported deferred-maintenance total. The 10-year uninflated projection is $3,595,290; the inflated projection is $4,125,966. These measures can overlap and use different timing or source treatment. They must not be added into one “total need.”

Where the 2021 reported deferred-maintenance total was concentrated

This stacked bar partitions the $5,106,762 source-reported total across the 17 assessed properties. It shows relative scale in the 2021 study—not current urgency, completed-work status, or a ranking of community value.

Memorial School
Soule Road School
Mile Tree School
Stony Hill School
Other 13
Memorial School: $1,298,066 • 25.4%Soule Road School: $1,279,053 • 25.0%Mile Tree School: $848,559 • 16.6%Stony Hill School: $791,192 • 15.5%Other 13 assessed properties: $889,892 • 17.4%

Seventeen assessed properties connected to today's asset registry

Current managed-asset names and addresses are displayed beside the study's reported names and addresses so identity changes remain visible. For example, the Little Red School House source says 26 Springfield Street, while the current managed-asset address is 28 Springfield Street. Address alignment is not a condition update.

Current managed asset2021 study propertyCurrent primary addressStudy-reported addressLinked buildingsLinked parcelsCritical repairsNon-critical repairsReported deferred maintenance10-year uninflated10-year inflatedQA exceptions
Town HallTown Office Building240 SPRINGFIELD ST WILBRAHAM MA240 Springfield Street11$46,591$176,908$223,499$91,306$105,8590
Fire HeadquartersFire Station 12770 BOSTON RD WILBRAHAM MA2770 Boston Road11$17,241$11,214$28,455$77,438$89,0520
Fire Station 2Fire Station 2 / Auxiliary Fire6 WOODLAND DELL RD WILBRAHAM MA6 Woodland Dell Road11$0$2,188$2,188$63,555$71,5120
Police DepartmentPolice Station2780 BOSTON RD WILBRAHAM MA2780 Boston Road11$6,382$8,406$14,789$23,543$26,3420
Former Police / IT BuildingIT/Facilities Maintenance16 MAIN ST WILBRAHAM MA16 Main Street Building11$5,000$7,271$17,271$74,058$84,5141
Department of Public WorksPublic Works/DPW2721 BOSTON RD WILBRAHAM MA2721 Boston Road51$2,204$49,215$51,418$46,879$55,1010
Soule Road SchoolSoule Road School300 SOULE RD WILBRAHAM MA300 Soule Road11$1,112,646$166,407$1,279,053$676,114$773,3620
Wilbraham Middle SchoolWilbraham Middle School492 STONY HILL RD WILBRAHAM MA466 Stony Hill Road11$38,419$102,564$140,983$869,426$1,010,6380
Memorial SchoolMemorial Elementary School318 MAIN ST WILBRAHAM MA318 Main Street11$24,002$1,274,063$1,298,066$176,425$203,5512
Mile Tree SchoolMile Tree Elementary School625 MAIN ST WILBRAHAM MA625 Main Street11$10,743$837,816$848,559$477,497$551,5490
Stony Hill SchoolStony Hill Elementary School675 STONY HILL RD WILBRAHAM MA675 Stony Hill Road11$3,439$787,753$791,192$374,446$431,6780
Wilbraham Public LibraryPublic Library25 CRANE PARK DR WILBRAHAM MA2 Crane Park Drive11$18,894$196,410$215,304$350,981$380,0780
Little Red School HouseLittle Red School House28 SPRINGFIELD ST WILBRAHAM MA 0109526 Springfield Street11$6,250$6,854$19,354$47,614$59,1911
Spec Pond Recreation Site2540V BOSTON RD WILBRAHAM MABoston Road62$0$28,979$28,979$38,998$44,9190
Children's MuseumChildren's Museum678 MAIN ST WILBRAHAM MA678 Main Street11$625$2,519$3,144$37,988$43,2000
Old Meeting HouseOld Meeting House450 MAIN ST WILBRAHAM MA450 Main Street11$0$12,057$12,057$25,232$27,3680
Wilbraham Country ClubCountry Club859 STONY HILL RD WILBRAHAM MA859 Stony Hill Road21$25,876$106,575$132,451$143,790$168,0520
Four disclosed reconciliation exceptions: the Former Police / IT Building and Little Red School House each have a critical-repair source/detail difference; Memorial School has unresolved critical- and non-critical-detail extractions. All 438 recommendation records, 147 condition observations, and 448 schedule occurrences remain marked REVIEW_REQUIRED. The controlled snapshot totals above are the portfolio reporting layer; the detailed records are evidence for rechecking, not a substitute for it.

Coverage gaps are part of the view. Five of the 22 curated assets do not have a 2021 assessment link: Crane Park, Gazebo Park, the Senior Center, the Sewer Treatment Plant, and the private 481 Main Street reference asset. The Senior Center post-dates the study; the Sewer Treatment Plant was not in the 17-property scope; parks and the private example are different asset types. “No link” does not mean “no needs.”

Open all 27 building relationships

DPW links to five building identities, Spec Pond to six, and the 2021 Country Club scope to two. The 2021 Country Club study explicitly excluded the later Senior Center. A relationship preserves navigation; it does not allocate a property-wide dollar to a particular building.

Assessment propertyManaged assetBuilding codeBuilding nameRoleVerification
WIL-CNA-2021-P01Town HallWIL-240-SPRINGFIELD-001-B001Town HallAssessed StructureReconciled
WIL-CNA-2021-P02Fire HeadquartersWIL-2770-BOSTON-001-B001Fire HeadquartersAssessed StructureReconciled
WIL-CNA-2021-P03Fire Station 2WIL-6-WOODLAND-DELL-001-B001Fire Station 2Assessed StructureReconciled
WIL-CNA-2021-P04Police DepartmentWIL-2780-BOSTON-001-B001Police DepartmentAssessed StructureReconciled
WIL-CNA-2021-P05Former Police / IT BuildingWIL-16-MAIN-001-B001Former Police / IT BuildingAssessed StructureReconciled
WIL-CNA-2021-P06Department of Public WorksWIL-2721-BOSTON-001-B001DPW Main Office and WarehouseAssessed StructureReconciled
WIL-CNA-2021-P06Department of Public WorksWIL-2721-BOSTON-001-B002DPW Garage 1Assessed StructureReconciled
WIL-CNA-2021-P06Department of Public WorksWIL-2721-BOSTON-001-B003DPW Garage 2Assessed StructureReconciled
WIL-CNA-2021-P06Department of Public WorksWIL-2721-BOSTON-001-B004DPW Garage 3Assessed StructureReconciled
WIL-CNA-2021-P06Department of Public WorksWIL-2721-BOSTON-001-B005DPW BarnAssessed StructureReconciled
WIL-CNA-2021-P07Soule Road SchoolWIL-300-SOULE-001-B001Soule Road SchoolAssessed StructureReconciled
WIL-CNA-2021-P08Wilbraham Middle SchoolWIL-492-STONY-HILL-001-B001Wilbraham Middle SchoolAssessed StructureReconciled
WIL-CNA-2021-P09Memorial SchoolWIL-318-MAIN-001-B001Memorial SchoolAssessed StructureReconciled
WIL-CNA-2021-P10Mile Tree SchoolWIL-625-MAIN-001-B001Mile Tree SchoolAssessed StructureReconciled
WIL-CNA-2021-P11Stony Hill SchoolWIL-675-STONY-HILL-001-B001Stony Hill SchoolAssessed StructureReconciled
WIL-CNA-2021-P12Wilbraham Public LibraryWIL-25-CRANE-PARK-001-B001Wilbraham Public LibraryAssessed StructureReconciled
WIL-CNA-2021-P13Little Red School HouseWIL-28-SPRINGFIELD-001-B001Little Red School HouseAssessed StructureReconciled
WIL-CNA-2021-P14Spec Pond Recreation SiteWIL-2540V-BOSTON-001-B001Spec Pond Building 1Assessed StructureReconciled
WIL-CNA-2021-P14Spec Pond Recreation SiteWIL-2540V-BOSTON-001-B002Spec Pond Building 2Assessed StructureReconciled
WIL-CNA-2021-P14Spec Pond Recreation SiteWIL-2540V-BOSTON-001-B003Spec Pond Building 3Assessed StructureReconciled
WIL-CNA-2021-P14Spec Pond Recreation SiteWIL-2540V-BOSTON-001-B004Spec Pond Building 4Assessed StructureReconciled
WIL-CNA-2021-P14Spec Pond Recreation SiteWIL-2540V-BOSTON-001-B005Spec Pond Building 5Assessed StructureReconciled
WIL-CNA-2021-P14Spec Pond Recreation SiteWIL-2540V-BOSTON-001-B006Spec Pond Building 6Assessed StructureReconciled
WIL-CNA-2021-P15Children's MuseumWIL-678-MAIN-001-B001Children's MuseumAssessed StructureReconciled
WIL-CNA-2021-P16Old Meeting HouseWIL-450-MAIN-001-B001Old Meeting HouseAssessed StructureReconciled
WIL-CNA-2021-P17Wilbraham Country ClubWIL-859-STONY-HILL-002-B001Wilbraham Country Club Main BuildingAssessed StructureReconciled
WIL-CNA-2021-P17Wilbraham Country ClubWIL-859-STONY-HILL-002-B002Wilbraham Country Club Utilities ShedAssessed StructureReconciled
Open all 18 parcel relationships

Spec Pond is the only assessed property linked to two parcels in this controlled view. Parcel relationships do not by themselves establish legal boundaries, restrictions, developability, or disposition authority.

Assessment propertyManaged assetParcel codeSource parcel IDReported acresRole
WIL-CNA-2021-P01Town Hall4561F_397755_28703674.809Assessment Site
WIL-CNA-2021-P02Fire Headquarters659F_405257_28821471.500Assessment Site
WIL-CNA-2021-P03Fire Station 25664F_403787_28704040.505Assessment Site
WIL-CNA-2021-P04Police Department663F_405530_28823041.423Assessment Site
WIL-CNA-2021-P05Former Police / IT Building2652F_405091_28812840.750Assessment Site
WIL-CNA-2021-P06Department of Public Works656F_404713_28813772.250Assessment Site
WIL-CNA-2021-P07Soule Road School4436F_397143_286049013.500Assessment Site
WIL-CNA-2021-P08Wilbraham Middle School4874F_397558_287528163.120Assessment Site
WIL-CNA-2021-P09Memorial School2733F_404754_287475939.997Assessment Site
WIL-CNA-2021-P10Mile Tree School2819F_401698_28667708.842Assessment Site
WIL-CNA-2021-P11Stony Hill School4919F_396593_287124411.420Assessment Site
WIL-CNA-2021-P12Wilbraham Public Library1395F_404404_28708596.040Assessment Site
WIL-CNA-2021-P13Little Red School House4510F_402641_28706800.792Assessment Site
WIL-CNA-2021-P14Spec Pond Recreation Site614F_401662_288099810.400Assessment Site
WIL-CNA-2021-P14Spec Pond Recreation Site615F_401783_288180528.000Assessment Site
WIL-CNA-2021-P15Children's Museum2825F_402445_28659181.200Assessment Site
WIL-CNA-2021-P16Old Meeting House2759F_403712_28712540.537Assessment Site
WIL-CNA-2021-P17Wilbraham Country Club4977F_394713_2867770170.179Assessment Site
Open all 68 reconciliation checks

The four exceptions are displayed first. A zero difference means the extracted detail reconciled to the reported metric; it does not make the 2021 amount current.

2021 study propertyMetricReported totalExtracted totalDifferenceStatusSource pages
IT/Facilities MaintenanceCritical Repairs$5,000$10,000$5,000Exception15
Memorial Elementary SchoolCritical Repairs$24,002Not extracted$0Exception27;28
Memorial Elementary SchoolNon-Critical Repairs$1,274,063Not extracted$0Exception27;28
Little Red School HouseCritical Repairs$6,250$12,500$6,250Exception40
Town Office BuildingCritical Repairs$46,591$46,591$0Reconciled3
Town Office BuildingNon-Critical Repairs$176,908$176,908$0Reconciled3
Town Office BuildingCapital Needs / 10-Year Uninflated$91,306$91,306$0Reconciled4
Town Office BuildingInflated Capital Needs$105,859$105,859$0Reconciled4
Fire Station 1Critical Repairs$17,241$17,241$0Reconciled6
Fire Station 1Non-Critical Repairs$11,214$11,214$0Reconciled6
Fire Station 1Capital Needs / 10-Year Uninflated$77,438$77,438$0Reconciled7
Fire Station 1Inflated Capital Needs$89,052$89,052$0Reconciled7
Fire Station 2 / Auxiliary FireCritical Repairs$0$0$0Reconciled9
Fire Station 2 / Auxiliary FireNon-Critical Repairs$2,188$2,188$0Reconciled9
Fire Station 2 / Auxiliary FireCapital Needs / 10-Year Uninflated$63,555$63,555$0Reconciled10
Fire Station 2 / Auxiliary FireInflated Capital Needs$71,512$71,512$0Reconciled10
Police StationCritical Repairs$6,382$6,382$0Reconciled12
Police StationNon-Critical Repairs$8,406$8,406$0Reconciled12
Police StationCapital Needs / 10-Year Uninflated$23,543$23,543$0Reconciled13
Police StationInflated Capital Needs$26,342$26,342$0Reconciled13
IT/Facilities MaintenanceNon-Critical Repairs$7,271$7,271$0Reconciled15
IT/Facilities MaintenanceCapital Needs / 10-Year Uninflated$74,058$74,058$0Reconciled16
IT/Facilities MaintenanceInflated Capital Needs$84,514$84,514$0Reconciled16
Public Works/DPWCritical Repairs$2,204$2,204$0Reconciled18
Public Works/DPWNon-Critical Repairs$49,215$49,215$0Reconciled18
Public Works/DPWCapital Needs / 10-Year Uninflated$46,879$46,879$0Reconciled19
Public Works/DPWInflated Capital Needs$55,101$55,101$0Reconciled19
Soule Road SchoolCritical Repairs$1,112,646$1,112,646$0Reconciled21
Soule Road SchoolNon-Critical Repairs$166,407$166,407$0Reconciled21
Soule Road SchoolCapital Needs / 10-Year Uninflated$676,114$676,114$0Reconciled22
Soule Road SchoolInflated Capital Needs$773,362$773,362$0Reconciled22
Wilbraham Middle SchoolCritical Repairs$38,419$38,419$0Reconciled24
Wilbraham Middle SchoolNon-Critical Repairs$102,564$102,564$0Reconciled24
Wilbraham Middle SchoolCapital Needs / 10-Year Uninflated$869,426$869,426$0Reconciled25
Wilbraham Middle SchoolInflated Capital Needs$1,010,638$1,010,638$0Reconciled25
Memorial Elementary SchoolCapital Needs / 10-Year Uninflated$176,425$176,425$0Reconciled29
Memorial Elementary SchoolInflated Capital Needs$203,551$203,551$0Reconciled29
Mile Tree Elementary SchoolCritical Repairs$10,743$10,743$0Reconciled31
Mile Tree Elementary SchoolNon-Critical Repairs$837,816$837,816$0Reconciled31
Mile Tree Elementary SchoolCapital Needs / 10-Year Uninflated$477,497$477,497$0Reconciled32
Mile Tree Elementary SchoolInflated Capital Needs$551,549$551,549$0Reconciled32
Stony Hill Elementary SchoolCritical Repairs$3,439$3,439$0Reconciled34
Stony Hill Elementary SchoolNon-Critical Repairs$787,753$787,753$0Reconciled34
Stony Hill Elementary SchoolCapital Needs / 10-Year Uninflated$374,446$374,446$0Reconciled35
Stony Hill Elementary SchoolInflated Capital Needs$431,678$431,678$0Reconciled35
Public LibraryCritical Repairs$18,894$18,894$0Reconciled37
Public LibraryNon-Critical Repairs$196,410$196,410$0Reconciled37
Public LibraryCapital Needs / 10-Year Uninflated$350,981$350,981$0Reconciled38
Public LibraryInflated Capital Needs$380,078$380,078$0Reconciled38
Little Red School HouseNon-Critical Repairs$6,854$6,854$0Reconciled40
Little Red School HouseCapital Needs / 10-Year Uninflated$47,614$47,614$0Reconciled41
Little Red School HouseInflated Capital Needs$59,191$59,191$0Reconciled41
Critical Repairs$0$0$0Reconciled43
Non-Critical Repairs$28,979$28,979$0Reconciled43
Capital Needs / 10-Year Uninflated$38,998$38,998$0Reconciled44
Inflated Capital Needs$44,919$44,919$0Reconciled44
Children's MuseumCritical Repairs$625$625$0Reconciled46
Children's MuseumNon-Critical Repairs$2,519$2,519$0Reconciled46
Children's MuseumCapital Needs / 10-Year Uninflated$37,988$37,988$0Reconciled47
Children's MuseumInflated Capital Needs$43,200$43,200$0Reconciled47
Old Meeting HouseCritical Repairs$0$0$0Reconciled49
Old Meeting HouseNon-Critical Repairs$12,057$12,057$0Reconciled49
Old Meeting HouseCapital Needs / 10-Year Uninflated$25,232$25,232$0Reconciled50
Old Meeting HouseInflated Capital Needs$27,368$27,368$0Reconciled50
Country ClubCritical Repairs$25,876$25,876$0Reconciled52
Country ClubNon-Critical Repairs$106,575$106,575$0Reconciled52
Country ClubCapital Needs / 10-Year Uninflated$143,790$143,790$0Reconciled53
Country ClubInflated Capital Needs$168,052$168,052$0Reconciled53

How the audited capital-asset accounting balance moved in FY2024

A capital-asset rollforward answers a different question from the 2021 condition assessment. It starts with recorded historical-cost accounting balances, adds capitalized work, records depreciation, moves completed construction into asset categories, and reconciles to ending net book value. It does not tell us current market value, replacement cost, physical condition, current capital need, or what should be sold or retained.

Audit scopeOpening net book valueGross-cost additionsDepreciation recordedNet changeEnding net book valueCIP moved to completed categories
Governmental activities$37,405,877$9,335,459$2,663,039$6,672,420$44,078,297$12,799,660
Business-type activities$13,411,987$64,499$837,941$-773,442$12,638,545$250,006
Combined accounting view$50,817,864$9,399,958$3,500,980$5,898,978$56,716,842$13,049,666
Plain-language walk-down: combined net book value began at $50,817,864. The audit records $9,399,958 of gross-cost additions and $3,500,980 of additional accumulated depreciation. After all rollforward components, combined net book value increased $5,898,978 to $56,716,842. The $13,049,666 moved from construction in progress into completed asset categories is an internal reclassification, not an additional Town-wide asset total.
Materiality inside this accounting schedule: gross additions equaled 18.5% of opening net book value, depreciation equaled 6.9%, and the net increase was 11.6%. Those percentages show the scale of movement within the rollforward; they are not shares of the annual budget or proof of current asset condition.
Do not join this to the parcel inventory by assumption: the audited rollforward is activity-level accounting evidence, not a parcel- or building-level ledger. The next reporting layer needs asset IDs, project IDs, capitalized cost, in-service dates, funding sources, accumulated depreciation, condition, completed work, and current replacement estimates before the accounting balance can be attached to individual properties.

Source status and use-code composition

DimensionSource classificationParcel countReported acresBoundary
Parcel statusVacant1591,871.439Source-derived inventory classification; not a legal-use, developability, or disposition finding.
Parcel statusImprovements Reported9153.361Source-derived inventory classification; not a legal-use, developability, or disposition finding.
Parcel statusImproved33.088Source-derived inventory classification; not a legal-use, developability, or disposition finding.
State use code903Z1221,335.288Source-derived inventory classification; not a legal-use, developability, or disposition finding.
State use code903V49692.600Source-derived inventory classification; not a legal-use, developability, or disposition finding.

The FY2026 source records mechanically sum to assessed value of $24,059,300, all shown as exempt value. That number is not market value, sale proceeds, replacement cost, insurance value, or a measure of the land's service, historic, environmental, or community value.

Open the complete 171-parcel ownership-controlled inventory
Vision IDLocationState useParcel statusReported acresFY2026 assessed valueOwnership dateDeed bookDeed pageVerificationQA flag
281V ALGONQUIN DR903ZVacant0.161$7,9006954390STRUCTURAL_QA_COMPLETEN
302V ALGONQUIN DR903ZVacant17.760$144,0006954390STRUCTURAL_QA_COMPLETEN
645V APPLE HILL RD903ZVacant0.713$112,8005048129STRUCTURAL_QA_COMPLETEN
667 APPLE HILL RD903VVacant3.960$141,1003741345STRUCTURAL_QA_COMPLETEN
9124V BARTLETT AV903VVacant1.500$18,50012348253STRUCTURAL_QA_COMPLETEN
9328V BARTLETT AV903ZVacant0.990$82,4003555407STRUCTURAL_QA_COMPLETEN
9432V BARTLETT AV903ZVacant2.900$48,4009809592STRUCTURAL_QA_COMPLETEN
11928 BARTLETT CT903ZImproved1.910$2,789,5001976-09-13432253VISUALLY_VERIFIEDN
12030 BARTLETT CT903ZVacant3.020$97,200432256STRUCTURAL_QA_COMPLETEN
18356V BENNETT RD903ZVacant7.660$123,6003428475STRUCTURAL_QA_COMPLETEN
18444V BENNETT RD903ZImprovements Reported41.800$284,000390280STRUCTURAL_QA_COMPLETEN
19396V BENNETT RD903ZVacant70.140$398,600390280STRUCTURAL_QA_COMPLETEN
19498V BENNETT RD903ZVacant1.640$97,200390280STRUCTURAL_QA_COMPLETEN
5432208 BOSTON RD903VImprovements Reported0.358$23,40015500329STRUCTURAL_QA_COMPLETEN
6422667 BOSTON RD903ZVacant0.135$98,500415374STRUCTURAL_QA_COMPLETEN
6432671 BOSTON RD903ZVacant0.323$92,500415374STRUCTURAL_QA_COMPLETEN
6552720 BOSTON RD903ZImprovements Reported16.000$190,6001831504STRUCTURAL_QA_COMPLETEN
6762835 BOSTON RD903ZVacant2.330$124,2004515149STRUCTURAL_QA_COMPLETEN
6782960 BOSTON RD903ZVacant8.580$121,7003391114STRUCTURAL_QA_COMPLETEN
7143180 BOSTON RD903VVacant0.232$13,50023821181STRUCTURAL_QA_COMPLETEN
7263232 BOSTON RD903ZVacant6.930$114,4004584219STRUCTURAL_QA_COMPLETEN
7323248 BOSTON RD903ZVacant0.630$75,4003555407STRUCTURAL_QA_COMPLETEN
85529V BRENTWOOD DR903ZVacant13.100$171,600319256STRUCTURAL_QA_COMPLETEN
87114V BRIAR CLIFF DR903VVacant0.678$12,1007203221STRUCTURAL_QA_COMPLETEN
95716A BROOKMONT DR903VImprovements Reported0.030$54,4002017675STRUCTURAL_QA_COMPLETEN
106830V BRUUER AV903ZVacant0.050$6,7001973-05-073797559VISUALLY_VERIFIEDN
11373V CADWELL DR903ZVacant0.553$86,6005559426STRUCTURAL_QA_COMPLETEN
11517V CAPTAIN RD903ZVacant0.900$107,40031899STRUCTURAL_QA_COMPLETEN
115512V CAPTAIN RD903ZVacant9.707$156,70031898STRUCTURAL_QA_COMPLETEN
11709V CEDAR OAK DR903ZVacant175.000$807,500343561STRUCTURAL_QA_COMPLETEN
11787R CENTERWOOD DR903ZVacant3.890$131,1003500569STRUCTURAL_QA_COMPLETEN
12558V CLIFFSIDE DR903VVacant2.210$9,70016631247STRUCTURAL_QA_COMPLETEN
125610V CLIFFSIDE DR903VVacant0.509$7,800132360162STRUCTURAL_QA_COMPLETEN
13281 COTTAGE AV903ZImproved0.260$733,5001970-08-133526511VISUALLY_VERIFIEDN
1369143V CRANE HILL RD903ZVacant28.750$228,4003391114STRUCTURAL_QA_COMPLETEN
150316R DEER RUN DR903ZVacant12.250$179,8007088220STRUCTURAL_QA_COMPLETEN
15248V DELMOR AV903ZVacant0.170$88,400343562STRUCTURAL_QA_COMPLETEN
152512V DELMOR AV903ZVacant2.370$124,400396525STRUCTURAL_QA_COMPLETEN
157125V DEVONSHIRE DR903ZVacant0.120$7,8001047388STRUCTURAL_QA_COMPLETEN
1575406V DIPPING HOLE RD903ZVacant10.670$148,900529188STRUCTURAL_QA_COMPLETEN
1591445V DIPPING HOLE RD903ZVacant1.990$22,1007338324STRUCTURAL_QA_COMPLETEN
1595449V DIPPING HOLE RD903ZVacant14.990$167,9003267337STRUCTURAL_QA_COMPLETEN
1598450V DIPPING HOLE RD903ZVacant10.070$146,2004709118STRUCTURAL_QA_COMPLETEN
165640V EAST LONGMEADOW RD903ZVacant3.280$116,4003680163STRUCTURAL_QA_COMPLETEN
165763V EAST LONGMEADOW RD903ZVacant1.400$108,1003680163STRUCTURAL_QA_COMPLETEN
165955V EAST LONGMEADOW RD903ZVacant1.230$104,5003680163STRUCTURAL_QA_COMPLETEN
166279 EAST LONGMEADOW RD903VVacant1.960$110,6003680163STRUCTURAL_QA_COMPLETEN
166681VR EAST LONGMEADOW RD903ZVacant7.000$132,7003797559STRUCTURAL_QA_COMPLETEN
1667147V EAST LONGMEADOW RD903ZVacant5.000$123,9003680163STRUCTURAL_QA_COMPLETEN
18684V FOX HILL DR903ZVacant0.866$106,8003001565STRUCTURAL_QA_COMPLETEN
18837V GARY DR903ZVacant0.920$108,2003797559STRUCTURAL_QA_COMPLETEN
1916470R GLENDALE RD903ZVacant60.510$368,2003338367STRUCTURAL_QA_COMPLETEN
1917158V GLENDALE RD903ZVacant15.130$168,5003261200STRUCTURAL_QA_COMPLETEN
1943611V GLENDALE RD903ZVacant47.310$310,10022200445STRUCTURAL_QA_COMPLETEN
1984376V GLENDALE RD903ZVacant2.240$111,8002949134STRUCTURAL_QA_COMPLETEN
19911067V GLENDALE RD903ZVacant37.200$53,10013143251STRUCTURAL_QA_COMPLETEN
222840V HILLCREST DR903VVacant21.060$176,60011488565STRUCTURAL_QA_COMPLETEN
233114V INWOOD DR903VVacant71.470$417,9002345916STRUCTURAL_QA_COMPLETEN
23321V IROQUOIS LN903ZVacant2.480$15,7006954390STRUCTURAL_QA_COMPLETEN
24119V KATIE ST903ZVacant0.477$48,2003635153STRUCTURAL_QA_COMPLETEN
245810V LADD LN903ZVacant1.380$108,000387741STRUCTURAL_QA_COMPLETEN
247436V LAKE DR903ZVacant1.000$123,5003555407STRUCTURAL_QA_COMPLETEN
249491V LAKE DR903VVacant1.850$20,10011865200STRUCTURAL_QA_COMPLETEN
249592V LAKE DR903ZVacant1.890$20,300453046STRUCTURAL_QA_COMPLETEN
249794V LAKE DR903ZVacant0.933$16,300453046STRUCTURAL_QA_COMPLETEN
249896V LAKE DR903VVacant4.530$31,90024618509STRUCTURAL_QA_COMPLETEN
249999V LAKE DR903ZVacant0.938$16,3003555407STRUCTURAL_QA_COMPLETEN
25591V MARILYN DR903VVacant41.060$306,60025035466STRUCTURAL_QA_COMPLETEN
26512V MAIN ST903ZVacant0.120$69,7001100304STRUCTURAL_QA_COMPLETEN
2737356V MAIN ST903VVacant0.003$3,1006567102STRUCTURAL_QA_COMPLETEN
2785535V MAIN ST903ZVacant4.500$109,7003050294STRUCTURAL_QA_COMPLETEN
28871004V MAIN ST903ZVacant69.530$245,9003936272STRUCTURAL_QA_COMPLETEN
292572V MANCHONIS RD903VVacant0.107$30,40017856216STRUCTURAL_QA_COMPLETEN
3000230V MANCHONIS RD EXT903ZVacant1.630$121,1002603219STRUCTURAL_QA_COMPLETEN
30136V MAPLE ST903VVacant0.160$88,2001476228STRUCTURAL_QA_COMPLETEN
30313VR MAPLEWOOD DR903ZVacant10.310$159,3003548382STRUCTURAL_QA_COMPLETEN
30335V MAPLEWOOD DR903ZVacant0.026$38,8003658496STRUCTURAL_QA_COMPLETEN
3114124 MAYNARD RD903VVacant0.323$11,20011491304STRUCTURAL_QA_COMPLETEN
311542V MAYNARD RD903VVacant3.500$151,50011491304STRUCTURAL_QA_COMPLETEN
314911V MCINTOSH DR903VImprovements Reported0.028$49,4004443186STRUCTURAL_QA_COMPLETEN
3349700V MONSON RD903ZVacant0.940$108,600390280STRUCTURAL_QA_COMPLETEN
335090V MONSON RD903ZVacant33.050$247,400390280STRUCTURAL_QA_COMPLETEN
3352718V MONSON RD903ZVacant1.050$111,100390280STRUCTURAL_QA_COMPLETEN
3354722V MONSON RD903ZVacant0.998$110,000390280STRUCTURAL_QA_COMPLETEN
3430364V MOUNTAIN RD903ZVacant1.420$120,20013159367STRUCTURAL_QA_COMPLETEN
3457166V MOUNTAIN RD903ZVacant1.340$29,8002285434STRUCTURAL_QA_COMPLETEN
371313A-V OLDWOOD RD903ZVacant7.320$144,800363583STRUCTURAL_QA_COMPLETEN
375010V OXFORD DR903ZVacant0.459$86,4003797559STRUCTURAL_QA_COMPLETEN
377921V PEAK RD903ZVacant4.000$17,60030020083STRUCTURAL_QA_COMPLETEN
378123V PEAK RD903VVacant46.000$212,5003192101STRUCTURAL_QA_COMPLETEN
378224V PEAK RD903VVacant1.500$16,7003797559STRUCTURAL_QA_COMPLETEN
378325V PEAK RD903VVacant22.000$106,9003504599STRUCTURAL_QA_COMPLETEN
379412V PEARL DR903ZVacant0.317$41,6003737591STRUCTURAL_QA_COMPLETEN
382220V PEASE ST903ZVacant13.440$161,1003784236STRUCTURAL_QA_COMPLETEN
38298V PHEASANT FARM RD903ZVacant6.060$152,6003353281STRUCTURAL_QA_COMPLETEN
39646V POWERS DR903ZVacant1.000$14,8005048128STRUCTURAL_QA_COMPLETEN
398217V PRIMROSE LN903ZVacant5.930$70,0003488368STRUCTURAL_QA_COMPLETEN
399551V RAILROAD AV903ZVacant5.120$26,1002701280STRUCTURAL_QA_COMPLETEN
4122260V RIDGE RD903ZVacant11.400$140,9005559427STRUCTURAL_QA_COMPLETEN
418956 RIVER RD903ZImproved0.918$652,4001900-01-0100VISUALLY_VERIFIEDN
436837V SHIRLEY ST903ZVacant0.194$19,60010901564STRUCTURAL_QA_COMPLETEN
4429227 SOULE RD903ZVacant58.950$180,7003597213STRUCTURAL_QA_COMPLETEN
44854V SOUTHWOOD DR903VVacant28.430$215,0003588479STRUCTURAL_QA_COMPLETEN
45527V SPRINGFIELD ST903ZVacant1.900$55,2003387400STRUCTURAL_QA_COMPLETEN
4554109V SPRINGFIELD ST903ZVacant4.300$120,9003387399STRUCTURAL_QA_COMPLETEN
4568355 SPRINGFIELD ST903ZVacant0.475$15,5006236313STRUCTURAL_QA_COMPLETEN
4604230V SPRINGFIELD ST903ZVacant6.000$128,3005368331STRUCTURAL_QA_COMPLETEN
4789188V STONY HILL RD903ZVacant30.000$221,9003936196STRUCTURAL_QA_COMPLETEN
4804269V STONY HILL RD903VVacant5.700$115,000529188STRUCTURAL_QA_COMPLETEN
4845304VR STONY HILL RD903VVacant3.908$17,20025035466STRUCTURAL_QA_COMPLETEN
4885540 STONY HILL RD903ZImprovements Reported61.220$447,80032582STRUCTURAL_QA_COMPLETEN
5080269VR STONY HILL RD903ZVacant2.900$51,4007725148STRUCTURAL_QA_COMPLETEN
510323V SUNNYSIDE TR903ZVacant2.340$16,4005942550STRUCTURAL_QA_COMPLETEN
518635V THREE RIVERS RD903ZVacant0.096$32,4004515149STRUCTURAL_QA_COMPLETEN
5198164 THREE RIVERS RD903ZVacant14.200$146,400389476STRUCTURAL_QA_COMPLETEN
520060V THREE RIVERS RD903ZVacant10.100$128,400389476STRUCTURAL_QA_COMPLETEN
5203211 THREE RIVERS RD903VVacant0.815$79,20015647591STRUCTURAL_QA_COMPLETEN
5210237 THREE RIVERS RD903VVacant1.170$42,80015647592STRUCTURAL_QA_COMPLETEN
523513V TINKHAM RD903ZVacant0.120$6,500387741STRUCTURAL_QA_COMPLETEN
523817V TINKHAM RD903ZVacant2.940$96,900387741STRUCTURAL_QA_COMPLETEN
524427V TINKHAM RD903ZVacant3.880$101,000387741STRUCTURAL_QA_COMPLETEN
525138V TINKHAM RD903ZVacant9.750$32,20012570329STRUCTURAL_QA_COMPLETEN
5268828 TINKHAM RD903ZVacant0.580$89,2003195526STRUCTURAL_QA_COMPLETEN
5312153V TINKHAM RD903ZImprovements Reported4.900$131,5003310553STRUCTURAL_QA_COMPLETEN
535422V TINKHAM GLEN903ZVacant0.241$16,300387743STRUCTURAL_QA_COMPLETEN
535927V TINKHAM GLEN903ZVacant4.610$122,200387741STRUCTURAL_QA_COMPLETEN
543412V WASHINGTON RD903ZImprovements Reported28.810$209,70017856216STRUCTURAL_QA_COMPLETEN
56062V WHITE ST903VVacant0.115$60,90017281474STRUCTURAL_QA_COMPLETEN
564319 WINTERBERRY DR903ZVacant11.460$188,400563475STRUCTURAL_QA_COMPLETEN
571916V WRIGHT PL903VVacant0.581$9,90013917380STRUCTURAL_QA_COMPLETEN
572118V WRIGHT PL903ZVacant0.613$9,90011085465STRUCTURAL_QA_COMPLETEN
5746174R THREE RIVERS RD903ZVacant1.190$8,8008684542STRUCTURAL_QA_COMPLETEN
574868V BRAINARD RD903ZVacant16.096$172,8004230186STRUCTURAL_QA_COMPLETEN
574930 FERNWOOD DR903ZVacant0.022$33,4009572385STRUCTURAL_QA_COMPLETEN
57838R SURREY LN903ZVacant5.000$13,600841575STRUCTURAL_QA_COMPLETEN
579932V OAKLAND ST903VVacant0.191$17,800898426STRUCTURAL_QA_COMPLETEN
5802110V FACULTY ST903ZVacant0.070$61,8009308340STRUCTURAL_QA_COMPLETEN
58333R WHITFORD PL903ZVacant6.900$7,3009442154STRUCTURAL_QA_COMPLETEN
584011V WHITFORD PL903ZVacant0.656$13,7009442156STRUCTURAL_QA_COMPLETEN
58429V HITCHCOCK RD903ZVacant10.510$86,1009562273STRUCTURAL_QA_COMPLETEN
58509R VICTORIA LN903ZVacant17.020$200,8009562277STRUCTURAL_QA_COMPLETEN
586110V HARNESS DR903ZVacant1.300$105,900944212STRUCTURAL_QA_COMPLETEN
587820V HARNESS DR903ZVacant91.890$466,400944215STRUCTURAL_QA_COMPLETEN
588930V BRIAR CLIFF DR903ZVacant0.002$400944231STRUCTURAL_QA_COMPLETEN
10013223V DANFORTH FARM RD903VVacant53.390$219,20010244572STRUCTURAL_QA_COMPLETEN
100154242R MAIN ST903ZVacant5.377$22,70010968496STRUCTURAL_QA_COMPLETEN
100161300V THREE RIVERS RD903VVacant0.007$70010405448STRUCTURAL_QA_COMPLETEN
100278939V GLENDALE RD903ZVacant1.190$103,70010969406STRUCTURAL_QA_COMPLETEN
100330108V FACULTY ST903ZVacant0.658$91,20011225557STRUCTURAL_QA_COMPLETEN
100389388V THREE RIVERS RD903VVacant31.400$222,1001168437STRUCTURAL_QA_COMPLETEN
100413288R THREE RIVERS RD903VVacant27.770$41,20011878439STRUCTURAL_QA_COMPLETEN
10047614V STONINGTON DR903ZVacant19.470$225,70012637263STRUCTURAL_QA_COMPLETEN
1005046V KING DR903VVacant0.321$9,70012315382STRUCTURAL_QA_COMPLETEN
100564139V CRANE HILL RD903ZVacant26.700$219,4003310553STRUCTURAL_QA_COMPLETEN
1006698V BRIDLE PATH RD903ZVacant5.210$160,90013599149STRUCTURAL_QA_COMPLETEN
10068916V KENSINGTON DR903ZVacant0.041$14,80013754545STRUCTURAL_QA_COMPLETEN
10069020V KENSINGTON DR903ZVacant21.240$46,30013754543STRUCTURAL_QA_COMPLETEN
1008109V PATRIOT RIDGE LN903VVacant5.140$22,70014171592STRUCTURAL_QA_COMPLETEN
101828228V BURLEIGH RD903VVacant9.180$154,30013966512STRUCTURAL_QA_COMPLETEN
10183230V HIGHMOOR DR903VVacant140.760$733,3001504431STRUCTURAL_QA_COMPLETEN
101913235V CRANE HILL RD903VVacant46.300$329,700159051STRUCTURAL_QA_COMPLETEN
10194010V FALCON HEIGHTS RD903VVacant23.930$115,40016196299STRUCTURAL_QA_COMPLETEN
10194325V DEERFIELD DR903ZVacant3.643$142,00016282210STRUCTURAL_QA_COMPLETEN
10223416V CARLA LN903VVacant1.510$132,60019295179STRUCTURAL_QA_COMPLETEN
10246815V WILLOW BROOK LN903VVacant0.757$13,90020971553STRUCTURAL_QA_COMPLETEN
1025243R HIGHVIEW CR903VVacant0.102$19,00016923102STRUCTURAL_QA_COMPLETEN
10316016VR CARLA LN903VVacant24.196$106,5004230186STRUCTURAL_QA_COMPLETEN
10316113VR CEDAR OAK DR903VVacant6.084$24,10025035466STRUCTURAL_QA_COMPLETEN
10316211VR CEDAR OAK DR903VVacant19.890$87,5004230186STRUCTURAL_QA_COMPLETEN
1031680V POND RD903VVacant35.710$157,10000000000STRUCTURAL_QA_COMPLETEN
10317416V WELLFLEET DR903VImprovements Reported0.215$873,6004403328STRUCTURAL_QA_COMPLETEN
Open the 26-row ownership reconciliation

These rows remain outside the Town-owned view. Three identify a different current owner; 23 have no current ownership row loaded.

Vision IDLocationCurrent owner statusOwner classReason excluded
30813V BONAIR DRNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
7303244 BOSTON RDDUDA JACOB AUNRESOLVEDCURRENT OWNER IS NOT TOWN OF WILBRAHAM
125021V CIRCLE DRNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
213919V HEMINGWAY RDNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
2984181 MANCHONIS RDNASCEMBENI CHRISTOPHERPRIVATECURRENT OWNER IS NOT TOWN OF WILBRAHAM
32447V MILL BROOK CRNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
32744V MOHAWK STNASCEMBENI CHRISTOPHERUNRESOLVEDCURRENT OWNER IS NOT TOWN OF WILBRAHAM
358165V OAKLAND STNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
390945V PLEASANT VIEW RDNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
432513 SHADY LNNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
432613V SHADY LNNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
432714 SHADY LNNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
432815 SHADY LNNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
432916 SHADY LNNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
433118 SHADY LNNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
433220 SHADY LNNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
433422 SHADY LNNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
433524 SHADY LNNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
4445257V SOULE RDNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
4914649V STONY HILL RDNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
5068810V STONY HILL RDNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
5070813V STONY HILL RDNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
576214V WARREN RDNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
578715V WARREN RDNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
10009332R VICTORIA LNNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
10014424R OVERLOOK DRNO CURRENT OWNERSHIP ROW LOADEDUNRESOLVEDNO CURRENT OWNERSHIP ROW LOADED
Decision use: this view gives the Town one place to begin. The next layer should connect each parcel or managed asset to its present purpose, restrictions, buildings, condition, utilization, full cost, future need, alternatives, and community value—so a financial decision does not accidentally erase the reason the property was held in the first place.
Back to top

Walk-down view 5: recurring demands beside recurring capacity

A recurring commitment needs a dependable recurring funding source. Reserves, grants, and sale proceeds may be valuable, but they answer a different question.

FY2025 ordinary 2.5% increment$1,122,000
FY2025 certified new growth+ $548,000
Ordinary recurring levy-limit capacity added= $1,670,000
FY2024→FY2025 Town Schools increase$1,090,340
Pressure comparison$1,090,340 ÷ $1,670,000 = 65.3%

Scale of the annual comparison

Capacity added
2.5% $1,122,000
Growth $548,000
$1,670,000
School increase
65.3% of comparison
$1,090,340
Not earmarking: this does not say the ordinary increment or new growth was legally assigned to schools. It shows the scale of one recurring pressure beside one year's ordinary recurring levy-limit growth. Every other Town cost and revenue change also belongs in the full view.

Capacity questions for every proposal

Is the cost recurring?

Show the first year, stabilized annual year, five-year total, and any step-up or expiry.

Is the funding recurring?

Separate property taxes, state aid, dependable fees, grants, reserves, and proceeds by reliability and legal availability.

What else uses the capacity?

Place the proposal beside schools, benefits, public safety, contracts, debt, and other planned initiatives.

What changes if assumptions fail?

Show inflation, interest, grant, schedule, utilization, staffing, and revenue sensitivities.

Back to top

Walk-down view 6: what “affordable” should mean for the Town

A Town can afford a proposal when dependable expected revenue can pay existing obligations, maintain the services and assets already in place, preserve reasonable reserves, and cover the proposal's full recurring and life-cycle burden—while leaving reasonable flexibility and making any additional household burden explicit.

The household idea carries over: first pay the obligations and responsible upkeep that already exist. What remains is the Town's true available recurring capacity. If a proposal does not fit, it may still be desirable or financeable, but the decision packet must state which taxes, fees, reductions, delays, reserves, grants, sales, borrowing, or scope changes make it possible.

Your household model translated to a Town

Household questionTown equivalentWilbraham reporting input
What dependable money comes in?Property taxes, state aid, local receipts, dependable fees and other recurring revenue.FY2024 audited General Fund revenue was $52,059,479; property taxes supplied $45,321,168. A forward recurring-revenue forecast is not loaded.
What must already be paid?Payroll, benefits, pensions, debt service, HWRSD, insurance, contracts, utilities and essential operations.The FY2027 account view and debt/HWRSD schedules show important components, but not one aligned five-to-ten-year obligation forecast.
What must be maintained?Roads, buildings, vehicles, equipment, technology, utilities and other assets.The 2021 building study and FY2024 asset rollforward are baselines; a current completed/open work bridge and annual funding standard are not loaded.
What savings should remain?Free cash, stabilization, capital reserves and contingency under adopted policies.Balances are loaded, but the complete reserve policy, targets, planned uses and replenishment schedule are not.
What is truly left?Dependable recurring capacity after the responsibilities above.N/A — not loaded until the aligned operating, capital, maintenance, reserve and HWRSD forecasts are present.

The calculation the Town should be able to show

Dependable recurring revenueForecast input required
Existing services, payroll, benefits and HWRSD− aligned recurring obligations
Existing debt service and contracts− annual fixed commitments
Responsible asset maintenance and replacement funding− annual portfolio provision
Reserve contribution and known future pressures− resilience provision
true available recurring capacity= N/A — not loaded
Full annual cost of the proposal− staffing + benefits + operations + maintenance + net debt service
Capacity remaining after the proposal= decision result
“Within the levy limit” is not the conclusion. Legal levy room says the Town may be able to raise additional property taxes without an override. It does not say the current levy already contains the money, that the community can comfortably absorb the increase, or that using the capacity leaves enough flexibility for maintenance, emergencies, and other commitments.

Two questions, not one

Does the proposal fit within presently expected resources? If not, what would residents need to pay, reduce, defer, sell, or authorize to expand those means? A tax mechanism makes funding possible; it does not answer whether the household burden is reasonable.

Borrowing changes timing

The annual burden is principal + interest + new operations + maintenance − dependable dedicated support. Borrowing can make a large initial cost payable over time, but the annual and life-cycle cost still must fit beside every other obligation.

Reserves are savings

A reserve is money set aside for later use; free cash is a separately certified balance. Wilbraham's FY2024 certified free cash was $4,125,286. Both are one-time resources, not annual income for a continuing program; repeated use can create a structural deficit when the balance runs out.

Four tests—each answers a different question

TestQuestionFailure signal
Annual cash-flow affordabilityCan the Town pay every year without an unidentified tax or fee increase, repeated reserve use, service reduction, or maintenance deferral?A continuing cost is balanced with one-time money, an unnamed revenue assumption, or an unpriced reduction elsewhere.
Financial resilienceAfter funding the proposal, is there still room for emergencies, maintenance, inflation, contract changes and foreseeable capital work?The plan consumes nearly all levy, reserve, staffing, or borrowing flexibility and has no sensitivity or contingency.
Long-term capital affordabilityCan the Town acquire, finance, operate, maintain, renew and eventually replace the asset while sustaining the rest of the portfolio?Construction or bond payments are shown without staffing, utilities, maintenance, renewal, concurrent capital work or end-of-life cost.
Household impactWhat taxes or fees will households actually pay, for how long, and what service or value will they receive?The packet uses a Town-wide percentage as if it were a household bill or omits assessment bands, duration and distribution.

Use a classification instead of a vague “yes”

Affordability classificationMeaningRequired decision statement
Affordable within present meansFits within dependable projected revenue after existing services, maintenance, reserves and known obligations.Show the forecast and the capacity that remains after the proposal.
Affordable only through reprioritizationRequires an identified service reduction, project delay or spending reallocation.Name the change, amount, timing, service consequence and responsible decision-maker.
Affordable only with new revenueRequires higher taxes, an override, new fees or another dependable recurring source.State the revenue action, annual household effect, duration and contingency if it is not approved.
Affordable only with one-time fundingA nonrecurring cost can be paid from a grant, reserve or sale proceeds.Show that no permanent operating or replacement cost is being left unfunded.
Financeable but not yet proven affordableThe Town can legally borrow or arrange financing, but the full annual and life-cycle burden has not been shown to fit.Do not advance the word “affordable”; complete the missing operating, maintenance, portfolio and household tests.
Not affordable under the stated assumptionsThe proposal still exceeds resources or creates unacceptable risk after the named funding changes.Change scope, timing, funding or another commitment—or state what residents must give up or pay.
UnknownRequired revenue, operating, maintenance, reserve, debt, tax-impact or long-term inputs are missing.Show N/A — not loaded for each missing input and identify the evidence owner and due date.

What the loaded multi-year pension and OPEB schedules add

The Release 5 audit model contains 21 schedules and 967 facts, including required supplementary information (RSI). RSI is useful because a one-year liability can hide the direction of contributions, payroll, plan assets, assumptions, and investment effects. These schedules are labeled RSI unaudited and must not be called bonded debt or current-year expense.

RSI UNAUDITED

Pension net liability

$21,049,000 → $31,900,000

2015–2024; not monotonic. Liability/payroll moved from 280.17% to 325.81%.

RSI UNAUDITED

Pension contribution

$1,568,000 → $3,143,000

20.87% → 32.10% of covered payroll; the schedule reports no contribution deficiency.

RSI UNAUDITED

OPEB net liability

$20,821,000 → $8,747,000

2017–2024; plan assets increased while total liability declined.

Responsible reading: OPEB's direction improved materially in this window; pension plan coverage in 2024 was above 2015 but the liability remained large relative to payroll and annual contributions rose. Neither trend alone proves that a new proposal is affordable. The next view should place annual required contributions and assumption sensitivities inside the same operating forecast used for services, debt, maintenance and reserves.
Open the ten-year pension RSI walk-down
YearNet pension liabilityCovered payrollLiability / payrollPlan fiduciary %Actual contributionContribution / payroll
2015$21,049,000$7,513,000280.17%51.38%$1,568,00020.87%
2016$23,365,000$7,785,000300.13%49.22%$1,705,00021.90%
2017$27,665,000$8,247,000335.46%46.82%$1,869,00022.66%
2018$27,935,000$8,567,000326.08%50.82%$2,102,00024.54%
2019$30,603,000$8,788,000348.24%47.33%$2,235,00025.43%
2020$30,927,000$9,134,000338.59%50.23%$2,360,00025.84%
2021$28,750,000$9,179,000313.21%53.80%$2,456,00026.76%
2022$25,665,000$9,272,000276.80%60.81%$2,703,00029.16%
2023$32,294,000$9,606,000336.19%52.02%$2,904,00030.23%
2024$31,900,000$9,791,000325.81%55.12%$3,143,00032.10%
Open the eight-year OPEB RSI walk-down

Plan fiduciary net position and contribution-in-relation amounts are displayed as positive magnitudes for readability; the source schedule stores them with a presentation sign. The reconciliation and raw facts preserve the original sign.

YearTotal OPEB liabilityPlan assetsNet OPEB liabilityPlan fiduciary %Contribution in relationContribution deficiency
2017$21,801,000$980,000$20,821,0004.50%$301,000$1,026,000
2018$20,279,000$1,321,000$18,958,0006.51%$346,000$1,278,000
2019$23,013,000$1,733,000$21,280,0007.53%$783,000$880,000
2020$27,474,000$2,203,000$25,271,0008.02%$905,000$787,000
2021$29,156,000$2,691,000$26,465,0009.23%$1,014,000$1,220,000
2022$19,921,000$3,227,000$16,694,00016.20%$1,039,000$1,224,000
2023$14,122,000$3,895,000$10,227,00027.58%$1,096,000$605,000
2024$13,632,000$4,885,000$8,747,00035.83%$1,196,000$294,000
The present conclusion: the report can now explain the affordability test and show several important obligations. It cannot yet produce a Town-wide dollar answer. That result should remain unknown until the missing forecast inputs are loaded, rather than being inferred from legal debt capacity, available reserves, or a repayment schedule alone.
Back to top

Walk-down view 7: a complete funding bridge

The budget is a spending plan. The levy is one revenue mechanism. Audited revenue uses an accounting basis and fund scope. A proposal should show its own sources and uses rather than rely on casual subtraction.

FY2024 audited General Fund revenue composition

Property taxes $45,321,168
Other $6,738,311
Total audited General Fund revenue: $52,059,479Property-tax share: 87.1%Other categories: excise, aid, fees, permits, interest, and other receipts.

Minimum sources-and-uses bridge for a decision packet

Uses: what the choice requiresSources: how it will be paidControl question
Acquisition/construction; design; contingencies; financing costsAvailable funds; grants; reimbursements; reserves; proceeds; borrowingDo sources equal uses, and are every amount and restriction source-supported?
Annual staffing, benefits, utilities, contracts, maintenance, technology, insuranceRecurring General Fund revenue; fee revenue; aid; enterprise revenueDoes dependable recurring funding cover stabilized recurring cost?
Principal and interest by yearInside-levy funding; debt exclusion; enterprise revenue; reimbursementWhat is the legal levy treatment, household effect, duration, and failure contingency?
Renewal, replacement, decommissioning, or dispositionCapital reserve contribution; future authorization; residual valueIs the end-of-life obligation recognized rather than deferred outside the decision horizon?

FY2024 interfund transfers: where resources moved within the fund statements

An interfund transfer is not new outside revenue or a new Town-wide expense. It moves resources from one fund to another. The FY2024 audited governmental-fund schedule reports $747,640 of transfers in and the same $747,640 of transfers out.

FundTransfers inTransfers outNet internal movementWhat the source says about timing
General Fund$10,113$272,000$-261,887FY2024; audit page 50; transaction dates and purposes are not in this schedule.
Nonmajor special-revenue funds$214,579$261,061$-46,482FY2024; audit page 50; transaction dates and purposes are not in this schedule.
Capital Projects Fund$272,000$0$272,000FY2024; audit page 50; transaction dates and purposes are not in this schedule.
Federal Grant Fund$0$124,579$-124,579FY2024; audit page 50; transaction dates and purposes are not in this schedule.
Ambulance Fund$0$90,000$-90,000FY2024; audit page 50; transaction dates and purposes are not in this schedule.
Community Preservation Fund$250,948$0$250,948FY2024; audit page 50; transaction dates and purposes are not in this schedule.
Audited schedule total$747,640$747,640$0Both sides reconcile; transfers are internal to the governmental-fund view.

Arithmetic-compatible paths—not a transaction ledger

Possible source sideAmount outPossible destination sideAmount inEvidence boundary
General Fund$272,000Capital Projects Fund$272,000Exact amount match; likely path, but not a transaction-level proof.
Federal Grant Fund + Ambulance Fund$124,579 + $90,000Nonmajor special-revenue funds$214,579Exact aggregate match; individual destination detail is not loaded.
Nonmajor special-revenue funds$261,061Community Preservation Fund + General Fund$250,948 + $10,113Exact aggregate match; individual source detail is not loaded.
What we can and cannot say: the amounts reconcile exactly and support the aggregate paths shown above. The loaded schedule does not explicitly pair each journal entry, identify the legal authorization or purpose, or say when within FY2024 it moved. The definitive next input is a transfer ledger with journal date, source fund/account, destination fund/account, amount, article or authority, project/purpose, and reversal or correction status.
Decision use: make every proposal reconcile on its own terms, then connect it to the Town-wide budget, levy, reserves, and debt portfolio. That is the difference between “the money exists” and “the funding plan is sustainable.”
Back to top

Walk-down view 8: a preliminary map of known grant sources

This is an early research map of outside funding sources already found in the database. It can help leadership ask “what should we investigate?” before a project is funded. It is not guaranteed to be complete, and it does not promise that a listed program is open, that the Town is eligible, or that a past award can pay a new cost.

Do not treat this as available cash: a program, instrument, or award record is not proof of application, award authorization, receipt, accounting entry, expenditure, reimbursement, or grant closeout. No amount in this section should reduce a proposed taxpayer cost until a project-level source-and-use bridge confirms purpose, restrictions, match requirement, timing, receipt, ledger posting, allowable use, and closeout.
RESEARCH INVENTORY

Programs

48

Named active-or-historical program records; overlapping or umbrella identities may remain.

RESEARCH INVENTORY

Instruments

117

Grant, aid, allocation, reimbursement, earmark, eligibility, and related assistance records.

RESEARCH INVENTORY

Award records

68

52 contain an amount; these values are not safely additive as revenue.

OPEN CONTROL WORK

Research questions

121

All remain open; 94 are high priority.

Where the present evidence is strongest—and where it is not

1. Known source
48 program records
2. Instrument found
117 records
3. Award-like record
68 records
4. Cash received and posted
5 explicitly “received”; 1 “reported received”
5. Used and closed
No complete project-to-ledger bridge loaded

These are nested research stages, not a numeric funnel: program, instrument, and award records have different meanings and are not one-to-one. The received count reports database labels only; it does not independently prove bank receipt or General Ledger posting.

How Town leadership can use the preliminary view now

Decision momentUseful question nowWhat must be verified before reliance
Problem definitionWhich known programs may align with the service, asset, population, environmental, safety, transportation, technology, health, or historic-preservation purpose?Current notice, administrator, eligibility, eligible costs, deadline, award period, and competitiveness.
Alternative designWould changing scope, phasing, partners, site, timing, or procurement make an option eligible—or create a harmful grant-driven design?Program rules, life-cycle operating effect, local priorities, legal/site constraints, and whether the alternative still solves the Town problem.
Funding planCould outside money reduce borrowing, levy, reserve use, or fees?Exact award, local match, reimbursement timing, restrictions, contingency if denied, and source-and-use reconciliation.
ImplementationCan the Town administer the award without losing control of schedule or outcomes?Responsible owner, procurement, cash-flow bridge, reporting, audit trail, performance terms, and continuing obligations.
CloseoutDid the Town receive and use the amount as intended?General Ledger posting, project expenditures, reimbursement, final reporting, unspent balance, repayment exposure, and closeout evidence.

Examples of individually recorded awards

These examples show the range and scale of records already identified. Do not add the amounts: they span different years, purposes, lifecycle labels, and evidence conditions, and may overlap with project funding chains or other representations.

Recorded purposeFiscal year / periodRecorded amountLifecycle labelEvidence labelOpen note
Senior Center construction2022$1,804,151awardedCONFIRMEDConfirm expenditure and federal reporting
Vehicle Acquisition — new fire engineFY2023$690,476awardedCONFIRMEDOfficial congressional announcement confirms amount and vehicle-acquisition purpose; retrieve FEMA award number, agreement, match, purchase, reimbursement, and closeout.
FY2022 State 911 Regional Development Grant — transition expenses and equipmentFY2022$574,978.00awardedCONFIRMEDOfficial award schedule establishes the award and purpose; it does not establish Town receipt, obligation, expenditure, reimbursement, or closeout.
Springfield Street / Stony Hill Road intersection reconstruction, signals, widening, and sidewalksFY2026$517,000awardedCONFIRMEDRetrieve executed agreement, quarterly reports, receipts, expenditures, and closeout
Springfield St / Stony Hill Rd improvements2026$500,000awardedCONFIRMEDProject may not yet be expended
Senior Center construction2022$380,000awardedCONFIRMEDConfirm expenditure and federal reporting
Annual state CPA trust-fund matching distribution to WilbrahamFY2022 match$179,125receivedSUPPORTEDConfirm Town receipt date, fund posting, and DOR distribution record
Professional evaluation and redesign of Springfield Street / Stony Hill Road intersectionFY2025$176,854awardedCONFIRMEDDetermine relationship to FY2026 construction award, deliverables, acceptance, and closeout
Annual state CPA trust-fund matching distribution to WilbrahamFY2023 match$172,889receivedSUPPORTEDConfirm Town receipt date, fund posting, and DOR distribution record
Municipal energy conservation2021 block 2$170,434awardedCONFIRMEDConfirm receipts and closeout

Award-record lifecycle labels currently loaded

Lifecycle labelAward recordsHow to read it
Awarded45A database label; verify its source meaning before treating it as cash status.
Unknown14A database label; verify its source meaning before treating it as cash status.
Received5A database label; verify its source meaning before treating it as cash status.
Authorized2A database label; verify its source meaning before treating it as cash status.
Federally Marked Complete1A database label; verify its source meaning before treating it as cash status.
Reported Received1A database label; verify its source meaning before treating it as cash status.

Award-record evidence labels

Evidence labelAward records
Confirmed41
Supported25
Reported2

All 48 known program records—with every loaded date, period, and amount

This complete inventory is included to preserve detail. It is a preliminary grant-source map, not a catalog of currently open opportunities. The program-level effective-date fields are presently empty for all 48 records, so the table says N/A — not loaded rather than inventing dates. Linked instrument periods, award dates, award periods, research dates, and every recorded instrument or award amount are shown where the database contains them. Do not add the amount entries: instrument and award records can describe the same underlying funding event.

Program recordSource typeProgram effective datesResearch dateLinked periods / datesInstrument recordsAward recordsRecorded amount entries — not summed
ARPA SLFRFotherN/A — not loaded2026-07-21Instrument period 2022; Award FY202222Instrument: ARPA SLFRF — Senior Center construction [2022] — $1,804,151 — award amount
Instrument: ARPA SLFRF — Senior Center construction [2022] — $380,000 — award amount
Award: Senior Center construction [FY2022] — $1,804,151
Award: Senior Center construction [FY2022] — $380,000
ARPA SLFRF umbrellaotherN/A — not loaded2026-07-21Instrument period 2021-2026; Award FY2021-202611N/A — no amount loaded in linked instrument or award records
Chapter 90 municipal road aidotherN/A — not loaded2026-07-21Instrument period Annual 2010-present; Instrument period FY2012; Instrument period FY2013; Instrument period FY2014; Instrument period FY2015; Instrument period FY2016; Instrument period FY2017; Instrument period FY2018; Instrument period FY2019; Instrument period FY2020; Instrument period FY2024; Instrument period FY2025 Fair Share supplement; Instrument period Proposed FY2026130Instrument: Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionment [FY2012] — $427,500.07 — allocation amount
Instrument: Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionment [FY2013] — $552,727 — allocation amount
Instrument: Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionment [FY2014] — $548,589.62 — allocation amount
Instrument: Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionment based on $300 million statewide authorization [FY2015] — $824,552 — allocation amount
Instrument: Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionment [FY2016] — $549,446 — allocation amount
Instrument: Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionment [FY2017] — $549,344 — allocation amount
Instrument: Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionment [FY2018] — $543,258 — allocation amount
Instrument: Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionment [FY2019] — $547,510 — allocation amount
Instrument: Chapter 90 municipal road aid — Wilbraham supplemental road funding placed into the Town existing Chapter 90 contract [FY2025 Fair Share supplement] — $124,312.44 — allocation amount
Instrument: Chapter 90 municipal road aid — FY2020 Wilbraham base and supplemental apportionment [FY2020] — $603,728 — allocation amount
Instrument: Chapter 90 municipal road aid — proposed FY2026 Wilbraham allocation under five-year bond bill [Proposed FY2026] — $893,163.14 — proposed allocation
Instrument: Chapter 90-related Fair Share FY2024 Wilbraham municipal infrastructure allocation [FY2024] — $302,518 — allocation amount
Community Preservation Trust Fund distributionsotherN/A — not loaded2026-07-21Instrument period Annual10N/A — no amount loaded in linked instrument or award records
District Local Technical AssistanceotherN/A — not loaded2026-07-21Instrument period 2023; Award FY202311N/A — no amount loaded in linked instrument or award records
Earlier FEMA Assistance to Firefighters GrantsotherN/A — not loaded2026-07-21Instrument period Before 2024; Instrument period FY2018 award / reported 2019; Instrument period FY2019 / announced 2020; Instrument period FY2021 / 2023-2025 performance; Award FYBefore 2024; Award FYFY2018; Award FYFY2019; Award FYFY2021; Award date 2023-01-30; Award period 2023-01-30 to 2025-01-2944Instrument: FY2018 AFG award — breathing apparatus and RIT equipment [FY2018 award / reported 2019] — $155,057 — reported grant amount
Instrument: FY2019 AFG award — powered stretchers and ambulance load systems [FY2019 / announced 2020] — $128,571 — federal share
Instrument: FY2021 AFG award EMW-2021-FG-02167 [FY2021 / 2023-2025 performance] — $42,800 — federal obligation
Award: FY2018 AFG — breathing apparatus and RIT equipment [FYFY2018] — $155,057
Award: FY2019 AFG — powered stretchers and ambulance load systems [FYFY2019] — $128,571
Award: FY2021 Assistance to Firefighters Grant [FYFY2021; 2023-01-30; 2023-01-30 to 2025-01-29] — $42,800
Eastern Hampden Shared Public Health Services grantotherN/A — not loaded2026-07-21Instrument period Through at least 2026; Award FYThrough at least 202611N/A — no amount loaded in linked instrument or award records
Federal Title III senior-services grant through Greater Springfield Senior ServicesotherN/A — not loaded2026-07-21Instrument period FY2015; Instrument period October 2019 presentation; present staffing; Award FYFY201521Instrument: Federal Title III senior-services grant through Greater Springfield Senior Services — Partial salary of the Wilbraham Senior Center Social Services Coordinator [FY2015] — $4,000 — award amount
Instrument: Federal Title III senior-services grant through Greater Springfield Senior Services — Reported current Senior Center staffing allocation for the Social Services Coordinator [October 2019 presentation; present staffing] — $11,333 — allocation amount
Award: Partial salary of the Wilbraham Senior Center Social Services Coordinator [FYFY2015] — $4,000
FEMA Assistance to Firefighters GrantotherN/A — not loaded2026-07-21Instrument period FY2023 award announced 2024; Award FYFY202311Instrument: FEMA Assistance to Firefighters Grant — New fire engine [FY2023 award announced 2024] — $690,476 — federal award amount
Award: Vehicle Acquisition — new fire engine [FYFY2023] — $690,476
Greater Springfield Senior Services one-time Title III GrantotherN/A — not loaded2026-07-21Instrument period FY2015; Award FYFY201511Instrument: Greater Springfield Senior Services one-time Title III Grant — Fitness equipment for free weekly Wilbraham Senior Center exercise classes [FY2015] — $1,662 — award amount
Award: Fitness equipment for free weekly Wilbraham Senior Center exercise classes [FYFY2015] — $1,662
Greater Springfield Senior Services volunteer medical-driver reimbursement grantotherN/A — not loaded2026-07-29Instrument period Calendar 201010N/A — no amount loaded in linked instrument or award records
Green Communities competitive grantotherN/A — not loaded2026-07-21Instrument period 2021 block 2; Instrument period 2023 block 2; Award FY2021 block 2; Award FY2023 block 222Instrument: Green Communities competitive grant — Municipal energy conservation [2021 block 2] — $170,434 — award amount
Instrument: Green Communities competitive grant — Police HQ energy projects and vehicle [2023 block 2] — $54,358 — award amount
Award: Municipal energy conservation [FY2021 block 2] — $170,434
Award: Police HQ energy projects and vehicle [FY2023 block 2] — $54,358
Green Communities designation grantotherN/A — not loaded2026-07-21Instrument period 2018; Award FY201811N/A — no amount loaded in linked instrument or award records
Home Depot community grant assistanceotherN/A — not loaded2026-07-21Instrument period FY201510N/A — no amount loaded in linked instrument or award records
HWP4Y prevention fundingotherN/A — not loaded2026-07-21Instrument period Through 2026; Award FYThrough 202611N/A — no amount loaded in linked instrument or award records
Mass Cultural Council local allocationotherN/A — not loaded2026-07-21Instrument period Annual; Instrument period FY2019; Instrument period FY2020; Instrument period FY2021; Instrument period FY2022; Instrument period FY2023; Instrument period FY2025; Instrument period FY2026; Instrument period FY202790Instrument: Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grants [FY2019] — $5,600 — allocation amount
Instrument: Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grants [FY2020] — $7,300 — allocation amount
Instrument: Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grants [FY2021] — $7,800 — allocation amount
Instrument: Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grants [FY2022] — $8,800 — allocation amount
Instrument: Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grants [FY2023] — $10,400 — allocation amount
Instrument: Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grants [FY2025] — $10,800 — allocation amount
Instrument: Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grants [FY2026] — $10,800 — allocation amount
Instrument: Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grants [FY2027] — $10,800 — allocation amount
Massachusetts Clean Water Trust Drinking Water assistanceotherN/A — not loaded2026-07-21Instrument period 2023; Award FY202311Instrument: Massachusetts Clean Water Trust Drinking Water assistance — Wilbraham drinking-water project DWL-23-34 [2023] — $160,000 — award amount
Award: Wilbraham drinking-water project DWL-23-34 [FY2023] — $160,000
Massachusetts COA earmarkotherN/A — not loaded2026-07-21Instrument period FY2023; Instrument period FY2024; Award FYFY2023; Award FYFY202422Instrument: Massachusetts COA earmark — Council on Aging / Senior Center [FY2023] — $50,000 — authorized ceiling
Instrument: Massachusetts COA earmark — Council on Aging / Senior Center [FY2024] — $100,000 — authorized ceiling
Award: Council on Aging / Senior Center [FYFY2023] — $50,000
Award: Council on Aging / Senior Center [FYFY2024] — $100,000
Massachusetts COA formula grantotherN/A — not loaded2026-07-21Instrument period Recurring; Award FYRecurring11N/A — no amount loaded in linked instrument or award records
Massachusetts Community Preservation Trust Fund distributionotherN/A — not loaded2026-07-21Instrument period FY2021 match; Instrument period FY2022 match; Instrument period FY2023 match; Instrument period FY2024 match; Instrument period November 2024 distribution; Award FYFY2021 match; Award FYFY2022 match; Award FYFY2023 match; Award FYFY2024 match; Award FYNovember 2024 distribution55Instrument: Massachusetts Community Preservation Trust Fund distribution — Annual state CPA trust-fund matching distribution to Wilbraham [FY2021 match] — $112,994 — distribution amount
Instrument: Massachusetts Community Preservation Trust Fund distribution — Annual state CPA trust-fund matching distribution to Wilbraham [FY2022 match] — $179,125 — distribution amount
Instrument: Massachusetts Community Preservation Trust Fund distribution — Annual state CPA trust-fund matching distribution to Wilbraham [FY2023 match] — $172,889 — distribution amount
Instrument: Massachusetts Community Preservation Trust Fund distribution — Annual state CPA trust-fund matching distribution to Wilbraham [FY2024 match] — $98,135 — distribution amount
Instrument: Massachusetts Community Preservation Trust Fund distribution — Annual state CPA trust-fund matching distribution to Wilbraham; 18.06% of $508,800 net surcharge shown [November 2024 distribution] — $91,895 — distribution amount
Award: Annual state CPA trust-fund matching distribution to Wilbraham [FYFY2021 match] — $112,994
Award: Annual state CPA trust-fund matching distribution to Wilbraham [FYFY2022 match] — $179,125
Award: Annual state CPA trust-fund matching distribution to Wilbraham [FYFY2023 match] — $172,889
Award: Annual state CPA trust-fund matching distribution to Wilbraham [FYFY2024 match] — $98,135
Award: Annual state CPA trust-fund matching distribution to Wilbraham; 18.06% of $508,800 net surcharge shown [FYNovember 2024 distribution] — $91,895
Massachusetts Council on Aging Formula GrantotherN/A — not loaded2026-07-21Instrument period FY2012; Instrument period FY2013; Instrument period FY2014; Instrument period FY2015; Instrument period FY2016; Instrument period FY2017; Instrument period FY2018; Instrument period FY2019; Instrument period FY2020; Instrument period FY2022; Instrument period FY2025; Instrument period October 2019 presentation; present staffing; Award FYFY2012; Award FYFY2018; Award date 2018-02-01; Award period 2011-07-01 to 2012-06-30; Award period 2017-07-01 to 2018-06-30122Instrument: Massachusetts Council on Aging Formula Grant — Wilbraham Senior Center staffing: partial salaries for two full-time coordinators and the full salary of the part-time van driver/handyman [FY2015] — $29,056 — receipt amount
Instrument: Massachusetts Council on Aging Formula Grant — Reported current Senior Center staffing allocation: Activities/Volunteer Coordinator $16,209 and van driver/custodian $8,715 [October 2019 presentation; present staffing] — $24,924 — allocation amount
Instrument: Massachusetts Council on Aging Formula Grant — Wilbraham FY2025 formula allocation based on 4,504 residents age 60 and over; official schedule also lists $33,780 as 50% distributed in October 2024 [FY2025] — $67,560 — allocation amount
Instrument: Massachusetts Council on Aging Formula Grant — Derived Wilbraham FY2022 formula allocation: executed contract rate of $12 per elder multiplied by the official 2020-Census schedule count of 4,504 [FY2022] — $54,048 — allocation amount
Instrument: Massachusetts Council on Aging Formula Grant — Wilbraham FY2019 published contract form maximum obligation for the COA Formula Grant; actual award equals compensation less any FY2018 carryover [FY2019] — $43,584 — contract maximum obligation
Instrument: Massachusetts Council on Aging Formula Grant — Wilbraham FY2020 published contract form maximum obligation for the COA Formula Grant; actual award equals compensation less any FY2019 carryover [FY2020] — $43,584 — contract maximum obligation
Instrument: Massachusetts Council on Aging Formula Grant — Wilbraham FY2018 COA Formula Grant under countersigned Town/Commonwealth contract; performance period July 1, 2017 through June 30, 2018 [FY2018] — $35,230 — award amount
Instrument: Massachusetts Council on Aging Formula Grant — Wilbraham FY2017 published contract form maximum obligation; administrator states actual award equals compensation less FY2016 carryover [FY2017] — $36,320 — contract maximum obligation
Instrument: Massachusetts Council on Aging Formula Grant — Wilbraham FY2016 formula allocation based on 3,632 elders in the 2010 federal census at $9 per elder [FY2016] — $32,688 — allocation amount
Instrument: Massachusetts Council on Aging Formula Grant — Wilbraham FY2014 allocation and published contract face sheet [FY2014] — $29,056 — allocation amount
Instrument: Massachusetts Council on Aging Formula Grant — Wilbraham FY2013 allocation and published contract face sheet [FY2013] — $25,424 — allocation amount
Instrument: Massachusetts Council on Aging Formula Grant — Wilbraham FY2012 award [FY2012] — $22,700 — award amount
Award: Wilbraham FY2018 COA Formula Grant under countersigned Town/Commonwealth contract; performance period July 1, 2017 through June 30, 2018 [FYFY2018; 2018-02-01; 2017-07-01 to 2018-06-30] — $35,230
Award: Wilbraham FY2012 Council on Aging Formula Grant [FYFY2012; 2011-07-01 to 2012-06-30] — $22,700
Massachusetts Firefighter Safety Equipment GrantotherN/A — not loaded2026-07-21Instrument period FY2023; Instrument period FY2025; Instrument period FY2026; Instrument period Year unknown; Award FYFY2023; Award FYFY2025; Award FYFY2026; Award FYYear unknown44Instrument: Massachusetts Firefighter Safety Equipment Grant — Fire safety equipment [Year unknown] — $17,000 — award amount
Instrument: Massachusetts Firefighter Safety Equipment Grant — Firefighter safety equipment [FY2026] — $16,675.37 — award amount
Instrument: FY2025 Massachusetts Firefighter Safety Equipment Grant — Wilbraham Fire Department [FY2025] — $16,381.96 — award amount
Instrument: FY2023 Massachusetts Firefighter Safety Equipment Grant — Wilbraham Fire Department [FY2023] — $18,892.00 — award amount
Award: Fire safety equipment [FYYear unknown] — $17,000
Award: Firefighter safety equipment [FYFY2026] — $16,675.37
Award: FY2025 Firefighter Safety Equipment Grant — Wilbraham [FYFY2025] — $16,381.96
Award: FY2023 Firefighter Safety Equipment Grant — Wilbraham [FYFY2023] — $18,892.00
Massachusetts Gaming Commission Community Mitigation FundotherN/A — not loaded2026-07-21Instrument period 2015; Instrument period 2023; Instrument period FY2025; Instrument period FY2026; Award FY2015; Award FY2023; Award FYFY2025; Award FYFY202688Instrument: Massachusetts Gaming Commission Community Mitigation Fund — Springfield Street / Stony Hill Road intersection reconstruction, signals, widening, and sidewalks [FY2026] — $517,000 — award amount
Instrument: Massachusetts Gaming Commission Community Mitigation Fund — One-time mitigation reserve; project use not yet identified [2015] — $100,000 — award amount
Instrument: Massachusetts Gaming Commission Community Mitigation Fund — Upgrade 10 police vehicle radios, five fire vehicle radios, and one police portable radio [2023] — $42,800 — award amount
Instrument: Massachusetts Gaming Commission Community Mitigation Fund — Two highway message boards [FY2025] — $36,933 — award amount
Instrument: Massachusetts Gaming Commission Community Mitigation Fund — Four license plate cameras [FY2025] — $43,232 — award amount
Instrument: Massachusetts Gaming Commission Community Mitigation Fund — 96TB video server for camera upgrades [FY2025] — $42,408 — award amount
Instrument: Massachusetts Gaming Commission Community Mitigation Fund — Video-redaction software [FY2025] — $9,595 — award amount
Instrument: Massachusetts Gaming Commission Community Mitigation Fund — Professional evaluation and redesign of Springfield Street / Stony Hill Road intersection [FY2025] — $176,854 — award amount
Award: Springfield Street / Stony Hill Road intersection reconstruction, signals, widening, and sidewalks [FYFY2026] — $517,000
Award: One-time mitigation reserve; project use not yet identified [FY2015] — $100,000
Award: Upgrade 10 police vehicle radios, five fire vehicle radios, and one police portable radio [FY2023] — $42,800
Award: Two highway message boards [FYFY2025] — $36,933
Award: Four license plate cameras [FYFY2025] — $43,232
Award: 96TB video server for camera upgrades [FYFY2025] — $42,408
Award: Video-redaction software [FYFY2025] — $9,595
Award: Professional evaluation and redesign of Springfield Street / Stony Hill Road intersection [FYFY2025] — $176,854
Massachusetts Gaming Commission mitigation fundingotherN/A — not loaded2026-07-21Instrument period 2018 onward approx; Award FY2018 onward approx11N/A — no amount loaded in linked instrument or award records
Massachusetts Municipal Rideshare Fundformula_aidN/A — not loaded2026-07-29Instrument period 2018 report; Instrument period 2024 report; Instrument period June 202030Instrument: 2019 Massachusetts Municipal Rideshare Fund distribution to Wilbraham [June 2020] — $1,453 — receipt amount
Instrument: 2018 Massachusetts Municipal Rideshare Fund amount and reported road-repair use — Wilbraham [2018 report] — $965.80 — reported use amount
Instrument: 2024 Massachusetts Municipal Rideshare Fund amount banked for future use — Wilbraham [2024 report] — $1,700.80 — banked balance
Massachusetts Office of Travel and Tourism grantotherN/A — not loaded2026-07-21Instrument period 2018 approx10N/A — no amount loaded in linked instrument or award records
Massachusetts SAFEotherN/A — not loaded2026-07-21Instrument period FY2024; Instrument period FY2025; Instrument period FY2026; Award FYFY2024; Award FYFY2025; Award FYFY202633Instrument: Massachusetts SAFE — Student fire-safety education [FY2025] — $8,300 — award amount
Instrument: Massachusetts SAFE — Student fire-safety education [FY2024] — $4,695.39 — award amount
Instrument: Massachusetts SAFE — Student fire-safety education [FY2026] — $9,966.42 — award amount
Award: Student fire-safety education [FYFY2025] — $8,300
Award: Student fire-safety education [FYFY2024] — $4,695.39
Award: Student fire-safety education [FYFY2026] — $9,966.42
Massachusetts Senior SAFEotherN/A — not loaded2026-07-21Instrument period FY2024; Instrument period FY2025; Instrument period FY2026; Award FYFY2024; Award FYFY2025; Award FYFY202633Instrument: Massachusetts Senior SAFE — Senior fire-safety education [FY2025] — $4,000 — award amount
Instrument: Massachusetts Senior SAFE — Senior fire-safety education [FY2024] — $2,199.76 — award amount
Instrument: Massachusetts Senior SAFE — Senior fire-safety education [FY2026] — $5,363.10 — award amount
Award: Senior fire-safety education [FYFY2025] — $4,000
Award: Senior fire-safety education [FYFY2024] — $2,199.76
Award: Senior fire-safety education [FYFY2026] — $5,363.10
Massachusetts State 911 grantsotherN/A — not loaded2026-07-21Instrument period FY2018; Instrument period FY2021; Instrument period FY2022; Instrument period Recurring; Award FYFY2022; Award FYRecurring62Instrument: FY2018 Massachusetts State 911 reimbursement — Wilbraham [FY2018] — $7,504.20 — reimbursement amount
Instrument: FY2021 Massachusetts State 911 Training Grant expenditures — Wilbraham RECC [FY2021] — $2,945.00 — expenditure amount
Instrument: FY2021 Massachusetts State 911 EMD Grant expenditures — Wilbraham RECC [FY2021] — $3,925.13 — expenditure amount
Instrument: FY2021 Massachusetts State 911 Support and Incentive Grant expenditures — Wilbraham RECC [FY2021] — $89,119.00 — expenditure amount
Instrument: FY2022 Massachusetts State 911 Regional Development Grant — Wilbraham RECC [FY2022] — $574,978.00 — award amount
Award: FY2022 State 911 Regional Development Grant — transition expenses and equipment [FYFY2022] — $574,978.00
Massachusetts State 911 Support and Incentive GrantotherN/A — not loaded2026-07-21Instrument period FY2020; Instrument period FY2026; Award FYFY202621Instrument: Massachusetts State 911 Support and Incentive Grant — Wilbraham RECC [FY2026] — $660,471 — eligibility ceiling
Instrument: FY2020 Massachusetts State 911 Support and Incentive Grant eligibility — Wilbraham [FY2020] — $52,134 — eligibility ceiling
Massachusetts State Aid to Public LibrariesotherN/A — not loaded2026-07-21Instrument period FY2021; Instrument period FY2023; Instrument period FY2025; Instrument period FY2026; Award FYFY2021; Award FYFY2023; Award FYFY2025; Award FYFY2026; Award date 2026-01-0844Instrument: Massachusetts State Aid to Public Libraries — Wilbraham Public Library: LIG, MEG, and NRC combined award [FY2021] — $26,940.92 — award amount
Instrument: Massachusetts State Aid to Public Libraries — Wilbraham Public Library: LIG $23,486.34, MEG $17,453.56, NRC $3,590.70 [FY2025] — $44,530.60 — award amount
Instrument: Massachusetts State Aid to Public Libraries — Wilbraham Public Library initial award: LIG $9,281.99, MEG $6,565.10, NRC $1,652.77; certified November 3, 2022 [FY2023] — $17,499.86 — award amount
Instrument: FY2026 Massachusetts State Aid to Public Libraries total award to Wilbraham Public Library [FY2026] — $44,906.44 — award amount
Award: Wilbraham Public Library: LIG, MEG, and NRC combined award [FYFY2021] — $26,940.92
Award: Wilbraham Public Library: LIG $23,486.34, MEG $17,453.56, NRC $3,590.70 [FYFY2025] — $44,530.60
Award: Wilbraham Public Library initial award: LIG $9,281.99, MEG $6,565.10, NRC $1,652.77; certified November 3, 2022 [FYFY2023] — $17,499.86
Award: FY2026 State Aid to Public Libraries total award [FYFY2026; 2026-01-08] — $44,906.44
Massachusetts Traffic Safety GrantotherN/A — not loaded2026-07-21Instrument period 2025; Award FY202511Instrument: Massachusetts Traffic Safety Grant — Police traffic safety [2025] — $28,175 — award amount
Award: Police traffic safety [FY2025] — $28,175
MassDEP SMRP Mattress Collection ContainerotherN/A — not loaded2026-07-21Instrument period 2023; Award FY202311Instrument: MassDEP SMRP Mattress Collection Container — Mattress recycling [2023] — $10,000 — award amount
Award: Mattress recycling [FY2023] — $10,000
MassDEP SMRP Recycling DividendsotherN/A — not loaded2026-07-21Instrument period 2023; Instrument period 2024; Instrument period 2025; Award FY2023; Award FY2024; Award FY202533Instrument: MassDEP SMRP Recycling Dividends — Recycling [2023] — $5,600 — award amount
Instrument: MassDEP SMRP Recycling Dividends — Recycling [2024] — $5,600 — award amount
Instrument: MassDEP SMRP Recycling Dividends — Recycling [2025] — $6,600 — award amount
Award: Recycling [FY2023] — $5,600
Award: Recycling [FY2024] — $5,600
Award: Recycling [FY2025] — $6,600
MassDOT Complete StreetsotherN/A — not loaded2026-07-21Instrument period 2026; Award FY202611Instrument: MassDOT Complete Streets — Springfield St / Stony Hill Rd improvements [2026] — $500,000 — award amount
Award: Springfield St / Stony Hill Rd improvements [FY2026] — $500,000
MassWildlife Habitat Management GrantotherN/A — not loaded2026-07-21Instrument period Year unknown; Award FYYear unknown11Instrument: MassWildlife Habitat Management Grant — Habitat management [Year unknown] — $11,600 — award amount
Award: Habitat management [FYYear unknown] — $11,600
Municipal Digital Equity Planning GrantotherN/A — not loaded2026-07-21Instrument period 2023; Award FY202311N/A — no amount loaded in linked instrument or award records
Municipal Fiber GrantotherN/A — not loaded2026-07-21Instrument period FY202610Instrument: Municipal Fiber Grant — Regional project benefiting Wilbraham [FY2026] — $487,313 — benefit value
MVP Action GrantotherN/A — not loaded2026-07-21Instrument period FY2024; Award FYFY202411Instrument: MVP Action Grant — Culvert assessment [FY2024] — $60,000 — award amount
Award: Culvert assessment [FYFY2024] — $60,000
MVP Planning GrantotherN/A — not loaded2026-07-21Instrument period 2020-2021 approx; Award FY2020-2021 approx11N/A — no amount loaded in linked instrument or award records
Police Taser grant componentotherN/A — not loaded2026-07-21Instrument period 2019-2020 approx; Award FY2019-2020 approx11N/A — no amount loaded in linked instrument or award records
Public Health Grant AwardotherN/A — not loaded2026-07-21Instrument period 2021; Award FY202111N/A — no amount loaded in linked instrument or award records
PVTA and MassDOT senior transportation vehicle assistanceotherN/A — not loaded2026-07-21Instrument period Award announced May 2015; vehicle expected by June 201610Instrument: PVTA and MassDOT senior transportation vehicle assistance — New Wilbraham Senior Center van; Town newsletter characterizes $60,000 as savings to the Town [Award announced May 2015; vehicle expected by June 2016] — $60,000 — benefit value
SAFE and Senior SAFEotherN/A — not loaded2026-07-21Instrument period Recurring; Award FYRecurring11N/A — no amount loaded in linked instrument or award records
State Aid to Public LibrariesotherN/A — not loaded2026-07-21Instrument period Annual10N/A — no amount loaded in linked instrument or award records
United Way of Pioneer Valley Basic Needs GrantotherN/A — not loaded2026-07-21Instrument period FY2015; Award FYFY201511Instrument: United Way of Pioneer Valley Basic Needs Grant — Fuel assistance for Wilbraham seniors [FY2015] — $5,000 — award amount
Award: Fuel assistance for Wilbraham seniors [FYFY2015] — $5,000
University of Massachusetts grantotherN/A — not loaded2026-07-21Instrument period FY2026 evidence; Award FYFY2026 evidence11N/A — no amount loaded in linked instrument or award records
Unspecified state and federal grants supporting Wilbraham Senior Center staffingotherN/A — not loaded2026-07-29Instrument period Calendar 201010N/A — no amount loaded in linked instrument or award records

Click any program for its complete linked records

Each program opens to its research boundary, every linked instrument, every linked award record, and every loaded date or amount. Missing values are labeled N/A; they are not treated as zero.

ARPA SLFRF — 2 instruments • 2 awards • 4 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
ARPA SLFRF — Senior Center constructionfederal_formula_assistance2022$1,804,151award amountawardedCONFIRMED2026-07-21Confirm expenditure and federal reporting
ARPA SLFRF — Senior Center constructionfederal_formula_assistance2022$380,000award amountawardedCONFIRMED2026-07-21Confirm expenditure and federal reporting

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Senior Center construction2022N/A — not loadedN/A — not loaded$1,804,151awardedCONFIRMED2026-07-21Confirm expenditure and federal reporting
Senior Center construction2022N/A — not loadedN/A — not loaded$380,000awardedCONFIRMED2026-07-21Confirm expenditure and federal reporting
ARPA SLFRF umbrella — 1 instruments • 1 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
ARPA SLFRF umbrella — Townwide projectsfederal_formula_assistance2021-2026N/A — no amount loadedN/A — not loadedunknownCONFIRMED2026-07-21Retrieve full project and expenditure reports

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Townwide projects2021-2026N/A — not loadedN/A — not loadedN/A — no amount loadedunknownCONFIRMED2026-07-21Retrieve full project and expenditure reports
Chapter 90 municipal road aid — 13 instruments • 0 awards • 12 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Chapter 90 municipal road aid — Road projectsformula_aidAnnual 2010-presentN/A — no amount loadedN/A — not loadedunknownCONFIRMED2026-07-21Extract annual Wilbraham receipts
Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionmentformula_aidFY2012$427,500.07allocation amountallocatedCONFIRMED2026-07-21Confirm approved projects, obligations, reimbursement requests, receipts, expenditures, and remaining balance
Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionmentformula_aidFY2013$552,727allocation amountallocatedCONFIRMED2026-07-21Confirm exact cents from source file plus approved projects, reimbursement requests, receipts, expenditures, and balance
Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionmentformula_aidFY2014$548,589.62allocation amountallocatedCONFIRMED2026-07-21Confirm approved projects, obligations, reimbursement requests, receipts, expenditures, and remaining balance
Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionment based on $300 million statewide authorizationformula_aidFY2015$824,552allocation amountallocatedCONFIRMED2026-07-21Confirm exact cents and whether later authorization adjustment affected available balance; retrieve project and reimbursement lifecycle
Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionmentformula_aidFY2016$549,446allocation amountallocatedCONFIRMED2026-07-21Confirm exact cents plus approved projects, reimbursement requests, receipts, expenditures, and balance
Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionmentformula_aidFY2017$549,344allocation amountallocatedCONFIRMED2026-07-21Confirm exact cents plus approved projects, reimbursement requests, receipts, expenditures, and balance
Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionmentformula_aidFY2018$543,258allocation amountallocatedCONFIRMED2026-07-21Confirm exact cents plus approved projects, reimbursement requests, receipts, expenditures, and balance
Chapter 90 municipal road aid — Annual Wilbraham Chapter 90 transportation infrastructure apportionmentformula_aidFY2019$547,510allocation amountallocatedCONFIRMED2026-07-21Confirm exact cents plus approved projects, reimbursement requests, receipts, expenditures, and balance
Chapter 90 municipal road aid — FY2020 Wilbraham base and supplemental apportionmentformula_aidFY2020$603,728allocation amountallocatedCONFIRMED2026-07-29Total comprises $548,843 base plus $54,884 supplemental as printed; table rounding creates a $1 arithmetic variance. Confirm MassDOT contract posting, approved projects, reimbursement requests, receipts, expenditures, and balance.
Chapter 90-related Fair Share FY2024 Wilbraham municipal infrastructure allocationformula_aidFY2024$302,518allocation amountallocatedCONFIRMED2026-07-29$166,656 road-miles component plus $135,862 population component. Do not merge with base Chapter 90 or infer reimbursement, receipt, or expenditure.
Chapter 90 municipal road aid — Wilbraham supplemental road funding placed into the Town existing Chapter 90 contractformula_aidFY2025 Fair Share supplement$124,312.44allocation amountallocatedCONFIRMED2026-07-21Keep separate from base FY2025 Chapter 90 apportionment; confirm contract posting, projects, reimbursement requests, receipts, expenditures, and remaining balance
Chapter 90 municipal road aid — proposed FY2026 Wilbraham allocation under five-year bond billformula_aidProposed FY2026$893,163.14proposed allocationproposedCONFIRMED2026-07-29Official budget brief is proposal evidence only. Confirm enactment, final annual contract amount, any later adjustment, projects, reimbursements, receipts, expenditures, and balance.

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Community Preservation Trust Fund distributions — 1 instruments • 0 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Community Preservation Trust Fund distributions — Community preservationformula_aidAnnualN/A — no amount loadedN/A — not loadedunknownCONFIRMED2026-07-21Extract annual distributions

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
District Local Technical Assistance — 1 instruments • 1 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
District Local Technical Assistance — Subdivision regulation updatecompetitive_grant2023N/A — no amount loadedaward amountawardedSUPPORTED2026-07-21Retrieve PVPC scope value and deliverables

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Subdivision regulation update2023N/A — not loadedN/A — not loadedN/A — no amount loadedawardedSUPPORTED2026-07-21Retrieve PVPC scope value and deliverables
Earlier FEMA Assistance to Firefighters Grants — 4 instruments • 4 awards • 6 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Earlier FEMA Assistance to Firefighters Grants — Fire equipment and trainingcompetitive_grantBefore 2024N/A — no amount loadedN/A — not loadedunknownSUPPORTED2026-07-21Enumerate individual federal awards; avoid double-count with G015
FY2018 AFG award — breathing apparatus and RIT equipmentcompetitive_grantFY2018 award / reported 2019$155,057reported grant amountreported receivedSUPPORTED2026-07-29Article says received; exact payment transaction, FAIN, federal share, match, expenditures, and closeout remain unresolved.
FY2019 AFG award — powered stretchers and ambulance load systemscompetitive_grantFY2019 / announced 2020$128,571federal shareawardedCONFIRMED2026-07-29Official announcement rounds federal share to whole dollars; does not establish total award including local match.
FY2021 AFG award EMW-2021-FG-02167competitive_grantFY2021 / 2023-2025 performance$42,800federal obligationfederally marked completeSUPPORTED2026-07-29Federal obligation is distinct from $2,140 non-federal obligation and $44,940 total obligated; project scope remains unresolved.

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Fire equipment and trainingBefore 2024N/A — not loadedN/A — not loadedN/A — no amount loadedunknownSUPPORTED2026-07-21Enumerate individual federal awards; avoid double-count with G015
FY2018 AFG — breathing apparatus and RIT equipmentFY2018N/A — not loadedN/A — not loaded$155,057reported receivedSUPPORTED2026-07-29Contemporary recipient-specific report; primary award record remains requested.
FY2019 AFG — powered stretchers and ambulance load systemsFY2019N/A — not loadedN/A — not loaded$128,571awardedCONFIRMED2026-07-29Federal share rounded in official announcement; FAIN and full obligation split remain requested.
FY2021 Assistance to Firefighters GrantFY20212023-01-302023-01-30 to 2025-01-29$42,800federally marked completeSUPPORTED2026-07-29Federal obligation only; total obligated including $2,140 non-federal share is $44,940.
Eastern Hampden Shared Public Health Services grant — 1 instruments • 1 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Eastern Hampden Shared Public Health Services grant — Regional public healthcompetitive_grantThrough at least 2026N/A — no amount loadedN/A — not loadedunknownSUPPORTED2026-07-21Identify lead award and Wilbraham share

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Regional public healthThrough at least 2026N/A — not loadedN/A — not loadedN/A — no amount loadedunknownSUPPORTED2026-07-21Identify lead award and Wilbraham share
Federal Title III senior-services grant through Greater Springfield Senior Services — 2 instruments • 1 awards • 3 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Federal Title III senior-services grant through Greater Springfield Senior Services — Partial salary of the Wilbraham Senior Center Social Services Coordinatorcompetitive_grantFY2015$4,000award amountawardedSUPPORTED2026-07-21Retrieve the application, award notice or contract, Title III program component, receipt, payroll charges, reporting, and closeout
Federal Title III senior-services grant through Greater Springfield Senior Services — Reported current Senior Center staffing allocation for the Social Services Coordinatorpass_through_grant_allocationOctober 2019 presentation; present staffing$11,333allocation amountallocatedCONFIRMED2026-07-21Identify fiscal year and Title III component, retrieve application and agreement, reconcile the $11,333 staffing allocation to the full grant, and obtain payroll and ledger support

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Partial salary of the Wilbraham Senior Center Social Services CoordinatorFY2015N/A — not loadedN/A — not loaded$4,000awardedSUPPORTED2026-07-21Retrieve the application, award notice or contract, Title III program component, receipt, payroll charges, reporting, and closeout
FEMA Assistance to Firefighters Grant — 1 instruments • 1 awards • 2 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
FEMA Assistance to Firefighters Grant — New fire enginecompetitive_grantFY2023 award announced 2024$690,476federal award amountawardedCONFIRMED2026-07-21Confirm federal award number match receipts and closeout

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Vehicle Acquisition — new fire engineFY2023N/A — not loadedN/A — not loaded$690,476awardedCONFIRMED2026-07-29Official congressional announcement confirms amount and vehicle-acquisition purpose; retrieve FEMA award number, agreement, match, purchase, reimbursement, and closeout.
Greater Springfield Senior Services one-time Title III Grant — 1 instruments • 1 awards • 2 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Greater Springfield Senior Services one-time Title III Grant — Fitness equipment for free weekly Wilbraham Senior Center exercise classescompetitive_grantFY2015$1,662award amountawardedCONFIRMED2026-07-21Retrieve the application, award notice or contract, Title III program component, receipt, equipment invoice and inventory record, reporting, and closeout

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Fitness equipment for free weekly Wilbraham Senior Center exercise classesFY2015N/A — not loadedN/A — not loaded$1,662awardedCONFIRMED2026-07-21Retrieve the application, award notice or contract, Title III program component, receipt, equipment invoice and inventory record, reporting, and closeout
Greater Springfield Senior Services volunteer medical-driver reimbursement grant — 1 instruments • 0 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-29CONFIRMEDactive_or_historicalTown report confirms the intermediary and purpose; exact program title, underlying federal/state authority, and award terms remain unresolved.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Greater Springfield Senior Services grant reimbursing Wilbraham volunteer medical driversgrantCalendar 2010N/A — no amount loadedamount unknownreceivedCONFIRMED2026-07-29Town report explicitly says received and identifies the reimbursement purpose; amount, dates, award number, receipt account, reimbursement claims, and closeout remain unresolved.

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Green Communities competitive grant — 2 instruments • 2 awards • 4 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Green Communities competitive grant — Municipal energy conservationcompetitive_grant2021 block 2$170,434award amountawardedCONFIRMED2026-07-21Confirm receipts and closeout
Green Communities competitive grant — Police HQ energy projects and vehiclecompetitive_grant2023 block 2$54,358award amountawardedCONFIRMED2026-07-21Confirm fiscal-year label and closeout

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Municipal energy conservation2021 block 2N/A — not loadedN/A — not loaded$170,434awardedCONFIRMED2026-07-21Confirm receipts and closeout
Police HQ energy projects and vehicle2023 block 2N/A — not loadedN/A — not loaded$54,358awardedCONFIRMED2026-07-21Confirm fiscal-year label and closeout
Green Communities designation grant — 1 instruments • 1 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Green Communities designation grant — Municipal energy projectscompetitive_grant2018N/A — no amount loadedN/A — not loadedunknownSUPPORTED2026-07-21Retrieve designation award and projects

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Municipal energy projects2018N/A — not loadedN/A — not loadedN/A — no amount loadedunknownSUPPORTED2026-07-21Retrieve designation award and projects
Home Depot community grant assistance — 1 instruments • 0 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Home Depot community grant assistance — Materials and labor for a handicap ramp at the home of an elderly Wilbraham veteran and spouserelated_external_assistanceFY2015N/A — no amount loadedN/A — not loadedunknownCONFIRMED2026-07-21Retrieve the application or approval, identify the legal recipient and Home Depot program, value the materials and labor if documented, and confirm completion

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
HWP4Y prevention funding — 1 instruments • 1 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
HWP4Y prevention funding — Youth substance-use preventioncompetitive_grantThrough 2026N/A — no amount loadedN/A — not loadedunknownSUPPORTED2026-07-21Identify program funder award and expenditures

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Youth substance-use preventionThrough 2026N/A — not loadedN/A — not loadedN/A — no amount loadedunknownSUPPORTED2026-07-21Identify program funder award and expenditures
Mass Cultural Council local allocation — 9 instruments • 0 awards • 8 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Mass Cultural Council local allocation — Wilbraham Cultural Councilformula_aidAnnualN/A — no amount loadedN/A — not loadedunknownCONFIRMED2026-07-21Extract annual allocations
Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grantsformula_aidFY2019$5,600allocation amountallocatedCONFIRMED2026-07-21Confirm Town accounting treatment, receipt date, local awards, reimbursements, and year-end balance
Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grantsformula_aidFY2020$7,300allocation amountallocatedCONFIRMED2026-07-21Confirm Town accounting treatment, receipt date, local awards, reimbursements, and year-end balance
Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grantsformula_aidFY2021$7,800allocation amountallocatedCONFIRMED2026-07-21Confirm Town accounting treatment, receipt date, local awards, reimbursements, and year-end balance
Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grantsformula_aidFY2022$8,800allocation amountallocatedCONFIRMED2026-07-21Confirm Town accounting treatment, receipt date, local awards, reimbursements, and year-end balance
Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grantsformula_aidFY2023$10,400allocation amountallocatedCONFIRMED2026-07-21Confirm Town accounting treatment, receipt date, local awards, reimbursements, and year-end balance
Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grantsformula_aidFY2025$10,800allocation amountallocatedCONFIRMED2026-07-21Confirm Town accounting treatment, receipt date, local awards, reimbursements, and year-end balance; FY2024 remains unresolved
Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grantsformula_aidFY2026$10,800allocation amountallocatedCONFIRMED2026-07-21Confirm Town accounting treatment, receipt date, local awards, reimbursements, and year-end balance
Mass Cultural Council local allocation — Wilbraham Cultural Council annual allocation for locally administered cultural grantsformula_aidFY2027$10,800allocation amountallocatedCONFIRMED2026-07-21Prospective allocation as of research date; confirm later receipt, local awards, reimbursements, and year-end balance

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Massachusetts Clean Water Trust Drinking Water assistance — 1 instruments • 1 awards • 2 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Massachusetts Clean Water Trust Drinking Water assistance — Wilbraham drinking-water project DWL-23-34competitive_grant2023$160,000award amountawardedSUPPORTED2026-07-21Determine recipient legal entity, loan versus grant composition, agreement, and expenditure

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Wilbraham drinking-water project DWL-23-342023N/A — not loadedN/A — not loaded$160,000awardedSUPPORTED2026-07-21Determine recipient legal entity, loan versus grant composition, agreement, and expenditure
Massachusetts COA earmark — 2 instruments • 2 awards • 4 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Massachusetts COA earmark — Council on Aging / Senior Centerstate_earmarkFY2023$50,000authorized ceilingauthorizedCONFIRMED2026-07-21Confirm receipt and use
Massachusetts COA earmark — Council on Aging / Senior Centerstate_earmarkFY2024$100,000authorized ceilingauthorizedCONFIRMED2026-07-21Confirm receipt and use

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Council on Aging / Senior CenterFY2023N/A — not loadedN/A — not loaded$50,000authorizedCONFIRMED2026-07-21Confirm receipt and use
Council on Aging / Senior CenterFY2024N/A — not loadedN/A — not loaded$100,000authorizedCONFIRMED2026-07-21Confirm receipt and use
Massachusetts COA formula grant — 1 instruments • 1 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Massachusetts COA formula grant — Council on Agingcompetitive_grantRecurringN/A — no amount loadedN/A — not loadedunknownSUPPORTED2026-07-21Retrieve FY2010-present allocations and ledger

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Council on AgingRecurringN/A — not loadedN/A — not loadedN/A — no amount loadedunknownSUPPORTED2026-07-21Retrieve FY2010-present allocations and ledger
Massachusetts Community Preservation Trust Fund distribution — 5 instruments • 5 awards • 10 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Massachusetts Community Preservation Trust Fund distribution — Annual state CPA trust-fund matching distribution to Wilbrahamcompetitive_grantFY2021 match$112,994distribution amountreceivedSUPPORTED2026-07-21Confirm Town receipt date, fund posting, and DOR distribution record
Massachusetts Community Preservation Trust Fund distribution — Annual state CPA trust-fund matching distribution to Wilbrahamcompetitive_grantFY2022 match$179,125distribution amountreceivedSUPPORTED2026-07-21Confirm Town receipt date, fund posting, and DOR distribution record
Massachusetts Community Preservation Trust Fund distribution — Annual state CPA trust-fund matching distribution to Wilbrahamcompetitive_grantFY2023 match$172,889distribution amountreceivedSUPPORTED2026-07-21Confirm Town receipt date, fund posting, and DOR distribution record
Massachusetts Community Preservation Trust Fund distribution — Annual state CPA trust-fund matching distribution to Wilbrahamcompetitive_grantFY2024 match$98,135distribution amountreceivedSUPPORTED2026-07-21Confirm Town receipt date, fund posting, and DOR distribution record
Massachusetts Community Preservation Trust Fund distribution — Annual state CPA trust-fund matching distribution to Wilbraham; 18.06% of $508,800 net surcharge showncompetitive_grantNovember 2024 distribution$91,895distribution amountreceivedSUPPORTED2026-07-21Confirm fiscal-year booking, Town receipt date, and DOR distribution record

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Annual state CPA trust-fund matching distribution to WilbrahamFY2021 matchN/A — not loadedN/A — not loaded$112,994receivedSUPPORTED2026-07-21Confirm Town receipt date, fund posting, and DOR distribution record
Annual state CPA trust-fund matching distribution to WilbrahamFY2022 matchN/A — not loadedN/A — not loaded$179,125receivedSUPPORTED2026-07-21Confirm Town receipt date, fund posting, and DOR distribution record
Annual state CPA trust-fund matching distribution to WilbrahamFY2023 matchN/A — not loadedN/A — not loaded$172,889receivedSUPPORTED2026-07-21Confirm Town receipt date, fund posting, and DOR distribution record
Annual state CPA trust-fund matching distribution to WilbrahamFY2024 matchN/A — not loadedN/A — not loaded$98,135receivedSUPPORTED2026-07-21Confirm Town receipt date, fund posting, and DOR distribution record
Annual state CPA trust-fund matching distribution to Wilbraham; 18.06% of $508,800 net surcharge shownNovember 2024 distributionN/A — not loadedN/A — not loaded$91,895receivedSUPPORTED2026-07-21Confirm fiscal-year booking, Town receipt date, and DOR distribution record
Massachusetts Council on Aging Formula Grant — 12 instruments • 2 awards • 14 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Massachusetts Council on Aging Formula Grant — Wilbraham FY2012 awardformula_aidFY2012$22,700award amountawardedCONFIRMED2026-07-29Official instructions identify the compensation box as the FY2012 award. Archived face sheet is not visibly countersigned; do not infer receipt or expenditure.
Massachusetts Council on Aging Formula Grant — Wilbraham FY2013 allocation and published contract face sheetformula_aidFY2013$25,424allocation amountallocatedCONFIRMED2026-07-29Do not infer Town receipt or expenditure; the initial 50% is a state payment schedule and the archived contract face sheet is not visibly countersigned.
Massachusetts Council on Aging Formula Grant — Wilbraham FY2014 allocation and published contract face sheetformula_aidFY2014$29,056allocation amountallocatedCONFIRMED2026-07-29Do not infer Town receipt, expenditure, or closeout; archived face sheet is not visibly countersigned.
Massachusetts Council on Aging Formula Grant — Wilbraham Senior Center staffing: partial salaries for two full-time coordinators and the full salary of the part-time van driver/handymanformula_aidFY2015$29,056receipt amountreceivedCONFIRMED2026-07-21Retrieve the FY2015 application, award notice, municipal receipt and ledger postings, payroll allocation detail, year-end report, and balance
Massachusetts Council on Aging Formula Grant — Wilbraham FY2016 formula allocation based on 3,632 elders in the 2010 federal census at $9 per elderformula_aidFY2016$32,688allocation amountallocatedCONFIRMED2026-07-21Retrieve executed or countersigned contract, FY2015 carryover balance, resulting total FY2016 award, payment and Town receipt dates, ledger posting, annual fiscal report, expenditures, and closeout
Massachusetts Council on Aging Formula Grant — Wilbraham FY2017 published contract form maximum obligation; administrator states actual award equals compensation less FY2016 carryoverformula_aidFY2017$36,320contract maximum obligationauthorizedCONFIRMED2026-07-21Confirm execution, FY2016 carryover, resulting FY2017 award/payment, Town receipt, annual fiscal report, expenditures, and closeout
Massachusetts Council on Aging Formula Grant — Wilbraham FY2018 COA Formula Grant under countersigned Town/Commonwealth contract; performance period July 1, 2017 through June 30, 2018competitive_grantFY2018$35,230award amountawardedCONFIRMED2026-07-21Confirm payment and Town receipt dates, ledger posting, annual fiscal report, expenditures, remaining balance, and closeout
Massachusetts Council on Aging Formula Grant — Wilbraham FY2019 published contract form maximum obligation for the COA Formula Grant; actual award equals compensation less any FY2018 carryoverformula_aidFY2019$43,584contract maximum obligationauthorizedCONFIRMED2026-07-21Confirm signatures or execution record, FY2018 carryover, resulting FY2019 award/payment, Town receipt, annual fiscal report, expenditures, and closeout
Massachusetts Council on Aging Formula Grant — Wilbraham FY2020 published contract form maximum obligation for the COA Formula Grant; actual award equals compensation less any FY2019 carryoverformula_aidFY2020$43,584contract maximum obligationauthorizedCONFIRMED2026-07-21Confirm signatures or execution record, FY2019 carryover, resulting FY2020 award/payment, Town receipt, annual fiscal report, expenditures, and closeout
Massachusetts Council on Aging Formula Grant — Derived Wilbraham FY2022 formula allocation: executed contract rate of $12 per elder multiplied by the official 2020-Census schedule count of 4,504formula_aidFY2022$54,048allocation amountallocatedSUPPORTED2026-07-21Confirm the $54,048 total against the FY2022 award/payment schedule and Town ledger; retrieve annual fiscal report, expenditures, and any adjustments
Massachusetts Council on Aging Formula Grant — Wilbraham FY2025 formula allocation based on 4,504 residents age 60 and over; official schedule also lists $33,780 as 50% distributed in October 2024formula_aidFY2025$67,560allocation amountallocatedCONFIRMED2026-07-21Confirm Town receipt and ledger posting of both tranches, spending categories, FY2025 annual report, remaining balance, and closeout treatment
Massachusetts Council on Aging Formula Grant — Reported current Senior Center staffing allocation: Activities/Volunteer Coordinator $16,209 and van driver/custodian $8,715formula_aidOctober 2019 presentation; present staffing$24,924allocation amountallocatedCONFIRMED2026-07-21Identify fiscal year, retrieve the annual application and award notice, reconcile the $24,924 staffing allocation to the full grant, and obtain payroll and ledger support

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Wilbraham FY2012 Council on Aging Formula GrantFY2012N/A — not loaded2011-07-01 to 2012-06-30$22,700awardedCONFIRMED2026-07-29Award amount is explicitly identified by the administrator instructions and printed on the Wilbraham face sheet; execution, receipt, use, reporting, and closeout remain unresolved.
Wilbraham FY2018 COA Formula Grant under countersigned Town/Commonwealth contract; performance period July 1, 2017 through June 30, 2018FY20182018-02-012017-07-01 to 2018-06-30$35,230awardedCONFIRMED2026-07-21Confirm payment and Town receipt dates, ledger posting, annual fiscal report, expenditures, remaining balance, and closeout
Massachusetts Firefighter Safety Equipment Grant — 4 instruments • 4 awards • 8 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
FY2023 Massachusetts Firefighter Safety Equipment Grant — Wilbraham Fire Departmentcompetitive_grantFY2023$18,892.00award amountawardedSUPPORTED2026-07-29Published recipient table supports the award; retrieve original DFS schedule and Town lifecycle records.
FY2025 Massachusetts Firefighter Safety Equipment Grant — Wilbraham Fire Departmentcompetitive_grantFY2025$16,381.96award amountawardedCONFIRMED2026-07-29Official award table; reimbursement, Town receipt, equipment purchases, reporting, and closeout remain unresolved.
Massachusetts Firefighter Safety Equipment Grant — Firefighter safety equipmentcompetitive_grantFY2026$16,675.37award amountawardedCONFIRMED2026-07-21Confirm equipment, receipt, invoice, and closeout
Massachusetts Firefighter Safety Equipment Grant — Fire safety equipmentcompetitive_grantYear unknown$17,000award amountawardedSUPPORTED2026-07-21Retrieve state award sheet and fiscal year

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
FY2023 Firefighter Safety Equipment Grant — WilbrahamFY2023N/A — not loadedN/A — not loaded$18,892.00awardedSUPPORTED2026-07-29Secondary recipient table; primary DFS schedule and lifecycle evidence remain open.
FY2025 Firefighter Safety Equipment Grant — WilbrahamFY2025N/A — not loadedN/A — not loaded$16,381.96awardedCONFIRMED2026-07-29Official award table; later lifecycle stages remain unresolved.
Firefighter safety equipmentFY2026N/A — not loadedN/A — not loaded$16,675.37awardedCONFIRMED2026-07-21Confirm equipment, receipt, invoice, and closeout
Fire safety equipmentYear unknownN/A — not loadedN/A — not loaded$17,000awardedSUPPORTED2026-07-21Retrieve state award sheet and fiscal year
Massachusetts Gaming Commission Community Mitigation Fund — 8 instruments • 8 awards • 16 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Massachusetts Gaming Commission Community Mitigation Fund — One-time mitigation reserve; project use not yet identifiedcompetitive_grant2015$100,000award amountawardedCONFIRMED2026-07-21Determine approved use, disbursement, expenditures, unused balance, and whether funds later expired or were returned
Massachusetts Gaming Commission Community Mitigation Fund — Upgrade 10 police vehicle radios, five fire vehicle radios, and one police portable radiocompetitive_grant2023$42,800award amountawardedCONFIRMED2026-07-21Retrieve application, agreement, invoices, quarterly reports, and closeout
Massachusetts Gaming Commission Community Mitigation Fund — 96TB video server for camera upgradescompetitive_grantFY2025$42,408award amountawardedCONFIRMED2026-07-21Retrieve application, agreement, procurement, reports, and closeout
Massachusetts Gaming Commission Community Mitigation Fund — Four license plate camerascompetitive_grantFY2025$43,232award amountawardedCONFIRMED2026-07-21Retrieve application, agreement, procurement, privacy policy, reports, and closeout
Massachusetts Gaming Commission Community Mitigation Fund — Professional evaluation and redesign of Springfield Street / Stony Hill Road intersectioncompetitive_grantFY2025$176,854award amountawardedCONFIRMED2026-07-21Determine relationship to FY2026 construction award, deliverables, acceptance, and closeout
Massachusetts Gaming Commission Community Mitigation Fund — Two highway message boardscompetitive_grantFY2025$36,933award amountawardedCONFIRMED2026-07-21Retrieve application, agreement, quarterly reports, disbursement, and closeout
Massachusetts Gaming Commission Community Mitigation Fund — Video-redaction softwarecompetitive_grantFY2025$9,595award amountawardedCONFIRMED2026-07-21Retrieve application, agreement, procurement, reports, and closeout
Massachusetts Gaming Commission Community Mitigation Fund — Springfield Street / Stony Hill Road intersection reconstruction, signals, widening, and sidewalkscompetitive_grantFY2026$517,000award amountawardedCONFIRMED2026-07-21Retrieve executed agreement, quarterly reports, receipts, expenditures, and closeout

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
One-time mitigation reserve; project use not yet identified2015N/A — not loadedN/A — not loaded$100,000awardedCONFIRMED2026-07-21Determine approved use, disbursement, expenditures, unused balance, and whether funds later expired or were returned
Upgrade 10 police vehicle radios, five fire vehicle radios, and one police portable radio2023N/A — not loadedN/A — not loaded$42,800awardedCONFIRMED2026-07-21Retrieve application, agreement, invoices, quarterly reports, and closeout
96TB video server for camera upgradesFY2025N/A — not loadedN/A — not loaded$42,408awardedCONFIRMED2026-07-21Retrieve application, agreement, procurement, reports, and closeout
Four license plate camerasFY2025N/A — not loadedN/A — not loaded$43,232awardedCONFIRMED2026-07-21Retrieve application, agreement, procurement, privacy policy, reports, and closeout
Professional evaluation and redesign of Springfield Street / Stony Hill Road intersectionFY2025N/A — not loadedN/A — not loaded$176,854awardedCONFIRMED2026-07-21Determine relationship to FY2026 construction award, deliverables, acceptance, and closeout
Two highway message boardsFY2025N/A — not loadedN/A — not loaded$36,933awardedCONFIRMED2026-07-21Retrieve application, agreement, quarterly reports, disbursement, and closeout
Video-redaction softwareFY2025N/A — not loadedN/A — not loaded$9,595awardedCONFIRMED2026-07-21Retrieve application, agreement, procurement, reports, and closeout
Springfield Street / Stony Hill Road intersection reconstruction, signals, widening, and sidewalksFY2026N/A — not loadedN/A — not loaded$517,000awardedCONFIRMED2026-07-21Retrieve executed agreement, quarterly reports, receipts, expenditures, and closeout
Massachusetts Gaming Commission mitigation funding — 1 instruments • 1 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Massachusetts Gaming Commission mitigation funding — Public safety/traffic/impact mitigationcompetitive_grant2018 onward approxN/A — no amount loadedN/A — not loadedunknownREPORTED2026-07-21Identify applications recipient awards and closeouts

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Public safety/traffic/impact mitigation2018 onward approxN/A — not loadedN/A — not loadedN/A — no amount loadedunknownREPORTED2026-07-21Identify applications recipient awards and closeouts
Massachusetts Municipal Rideshare Fund — 3 instruments • 0 awards • 3 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-29CONFIRMEDhistoricalPer-ride municipal distribution; exact statutory and annual reporting rules require further capture.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
2018 Massachusetts Municipal Rideshare Fund amount and reported road-repair use — Wilbrahamformula_aid2018 report$965.80reported use amountexpendedCONFIRMED2026-07-29State report identifies the amount and road-repair use; Town receipt date, ledger transactions, and specific road work remain unresolved.
2024 Massachusetts Municipal Rideshare Fund amount banked for future use — Wilbrahamformula_aid2024 report$1,700.80banked balanceallocatedCONFIRMED2026-07-29Official report says banked for future statutory use; not treated as expenditure or project assignment.
2019 Massachusetts Municipal Rideshare Fund distribution to Wilbrahamformula_aidJune 2020$1,453receipt amountreceivedCONFIRMED2026-07-29Official state report expressly says received; Town ledger posting, appropriation/use, report, and balance remain unresolved.

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Massachusetts Office of Travel and Tourism grant — 1 instruments • 0 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Massachusetts Office of Travel and Tourism grant — Fountain Parkrelated_external_assistance2018 approxN/A — no amount loadedaward amountawardedSUPPORTED2026-07-21Confirm legal recipient and amount

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Massachusetts SAFE — 3 instruments • 3 awards • 6 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Massachusetts SAFE — Student fire-safety educationcompetitive_grantFY2024$4,695.39award amountawardedCONFIRMED2026-07-21Confirm receipt, activity, and closeout
Massachusetts SAFE — Student fire-safety educationcompetitive_grantFY2025$8,300award amountawardedCONFIRMED2026-07-21Confirm receipt, activity, and closeout
Massachusetts SAFE — Student fire-safety educationcompetitive_grantFY2026$9,966.42award amountawardedCONFIRMED2026-07-21Confirm receipt, activity, and closeout

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Student fire-safety educationFY2024N/A — not loadedN/A — not loaded$4,695.39awardedCONFIRMED2026-07-21Confirm receipt, activity, and closeout
Student fire-safety educationFY2025N/A — not loadedN/A — not loaded$8,300awardedCONFIRMED2026-07-21Confirm receipt, activity, and closeout
Student fire-safety educationFY2026N/A — not loadedN/A — not loaded$9,966.42awardedCONFIRMED2026-07-21Confirm receipt, activity, and closeout
Massachusetts Senior SAFE — 3 instruments • 3 awards • 6 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Massachusetts Senior SAFE — Senior fire-safety educationcompetitive_grantFY2024$2,199.76award amountawardedCONFIRMED2026-07-21Confirm receipt, activity, and closeout
Massachusetts Senior SAFE — Senior fire-safety educationcompetitive_grantFY2025$4,000award amountawardedCONFIRMED2026-07-21Confirm receipt, activity, and closeout
Massachusetts Senior SAFE — Senior fire-safety educationcompetitive_grantFY2026$5,363.10award amountawardedCONFIRMED2026-07-21Confirm receipt, activity, and closeout

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Senior fire-safety educationFY2024N/A — not loadedN/A — not loaded$2,199.76awardedCONFIRMED2026-07-21Confirm receipt, activity, and closeout
Senior fire-safety educationFY2025N/A — not loadedN/A — not loaded$4,000awardedCONFIRMED2026-07-21Confirm receipt, activity, and closeout
Senior fire-safety educationFY2026N/A — not loadedN/A — not loaded$5,363.10awardedCONFIRMED2026-07-21Confirm receipt, activity, and closeout
Massachusetts State 911 grants — 6 instruments • 2 awards • 6 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
FY2018 Massachusetts State 911 reimbursement — Wilbrahamreimbursement_grantFY2018$7,504.20reimbursement amountreimbursedCONFIRMED2026-07-29Official State 911 exhibit identifies the amount reimbursed under the FY2018 grant; underlying claims and Town ledger receipt remain unresolved.
FY2021 Massachusetts State 911 EMD Grant expenditures — Wilbraham RECCreimbursement_grantFY2021$3,925.13expenditure amountexpendedCONFIRMED2026-07-29Official State 911 annual report identifies FY2021 EMD Grant expenditures by recipient; Town ledger, reimbursement requests, and receipt dates remain unresolved.
FY2021 Massachusetts State 911 Support and Incentive Grant expenditures — Wilbraham RECCcompetitive_grantFY2021$89,119.00expenditure amountexpendedCONFIRMED2026-07-29Official State 911 annual report identifies FY2021 Support and Incentive Grant expenditures by recipient; component split, Town ledger, and receipt dates remain unresolved.
FY2021 Massachusetts State 911 Training Grant expenditures — Wilbraham RECCreimbursement_grantFY2021$2,945.00expenditure amountexpendedCONFIRMED2026-07-29Official State 911 annual report identifies FY2021 Training Grant expenditures by recipient; Town ledger, reimbursement requests, and receipt dates remain unresolved.
FY2022 Massachusetts State 911 Regional Development Grant — Wilbraham RECCcompetitive_grantFY2022$574,978.00award amountawardedCONFIRMED2026-07-29Official State 911 award table identifies transition-expense and equipment purposes. Payments, expenditures, participating-community allocation, reporting, and closeout remain unresolved.
Massachusetts State 911 grants — Regional emergency communicationscompetitive_grantRecurringN/A — no amount loadedN/A — not loadedunknownSUPPORTED2026-07-21Retrieve each fiscal-year award and spending

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
FY2022 State 911 Regional Development Grant — transition expenses and equipmentFY2022N/A — not loadedN/A — not loaded$574,978.00awardedCONFIRMED2026-07-29Official award schedule establishes the award and purpose; it does not establish Town receipt, obligation, expenditure, reimbursement, or closeout.
Regional emergency communicationsRecurringN/A — not loadedN/A — not loadedN/A — no amount loadedunknownSUPPORTED2026-07-21Retrieve each fiscal-year award and spending
Massachusetts State 911 Support and Incentive Grant — 2 instruments • 1 awards • 2 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
FY2020 Massachusetts State 911 Support and Incentive Grant eligibility — Wilbrahamcompetitive_grant_eligibilityFY2020$52,134eligibility ceilingeligibleCONFIRMED2026-07-29$39,634 support component plus $12,500 incentive component. Eligibility is not an award, receipt, obligation, or expenditure.
Massachusetts State 911 Support and Incentive Grant — Wilbraham RECCcompetitive_grantFY2026$660,471eligibility ceilingeligibleCONFIRMED2026-07-21FY2026 guidelines list $660,471 total eligibility, with displayed $193,813 and $466,657 components; displayed components differ from the printed total by $1 due to source rounding. Do not infer an award or receipt.

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Wilbraham RECCFY2026N/A — not loadedN/A — not loadedN/A — no amount loadedunknownSUPPORTED2026-07-21Confirm column meanings award notices and disbursement
Massachusetts State Aid to Public Libraries — 4 instruments • 4 awards • 8 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Massachusetts State Aid to Public Libraries — Wilbraham Public Library: LIG, MEG, and NRC combined awardcompetitive_grantFY2021$26,940.92award amountawardedCONFIRMED2026-07-21Confirm municipal receipt, separate-account posting, and expenditure
Massachusetts State Aid to Public Libraries — Wilbraham Public Library initial award: LIG $9,281.99, MEG $6,565.10, NRC $1,652.77; certified November 3, 2022competitive_grantFY2023$17,499.86award amountawardedCONFIRMED2026-07-21Confirm municipal receipt, separate-account posting, permissible expenditure, component accounting, and year-end balance
Massachusetts State Aid to Public Libraries — Wilbraham Public Library: LIG $23,486.34, MEG $17,453.56, NRC $3,590.70competitive_grantFY2025$44,530.60award amountawardedCONFIRMED2026-07-21Confirm municipal receipt, separate-account posting, and expenditure
FY2026 Massachusetts State Aid to Public Libraries total award to Wilbraham Public Librarycompetitive_grantFY2026$44,906.44award amountawardedCONFIRMED2026-07-29Final total comprises LIG $23,473.40, MEG $17,649.93, and NRC $3,783.11. Receipt and expenditure are not inferred.

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Wilbraham Public Library: LIG, MEG, and NRC combined awardFY2021N/A — not loadedN/A — not loaded$26,940.92awardedCONFIRMED2026-07-21Confirm municipal receipt, separate-account posting, and expenditure
Wilbraham Public Library initial award: LIG $9,281.99, MEG $6,565.10, NRC $1,652.77; certified November 3, 2022FY2023N/A — not loadedN/A — not loaded$17,499.86awardedCONFIRMED2026-07-21Confirm municipal receipt, separate-account posting, permissible expenditure, component accounting, and year-end balance
Wilbraham Public Library: LIG $23,486.34, MEG $17,453.56, NRC $3,590.70FY2025N/A — not loadedN/A — not loaded$44,530.60awardedCONFIRMED2026-07-21Confirm municipal receipt, separate-account posting, and expenditure
FY2026 State Aid to Public Libraries total awardFY20262026-01-08N/A — not loaded$44,906.44awardedCONFIRMED2026-07-29Wilbraham certified November 6, 2025; final total published January 8, 2026. Receipt and use remain unconfirmed.
Massachusetts Traffic Safety Grant — 1 instruments • 1 awards • 2 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Massachusetts Traffic Safety Grant — Police traffic safetycompetitive_grant2025$28,175award amountawardedCONFIRMED2026-07-21Confirm expenditure and closeout

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Police traffic safety2025N/A — not loadedN/A — not loaded$28,175awardedCONFIRMED2026-07-21Confirm expenditure and closeout
MassDEP SMRP Mattress Collection Container — 1 instruments • 1 awards • 2 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
MassDEP SMRP Mattress Collection Container — Mattress recyclingcompetitive_grant2023$10,000award amountawardedCONFIRMED2026-07-21Confirm expenditure

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Mattress recycling2023N/A — not loadedN/A — not loaded$10,000awardedCONFIRMED2026-07-21Confirm expenditure
MassDEP SMRP Recycling Dividends — 3 instruments • 3 awards • 6 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
MassDEP SMRP Recycling Dividends — Recyclingcompetitive_grant2023$5,600award amountawardedCONFIRMED2026-07-21Confirm expenditure
MassDEP SMRP Recycling Dividends — Recyclingcompetitive_grant2024$5,600award amountawardedCONFIRMED2026-07-21Confirm expenditure
MassDEP SMRP Recycling Dividends — Recyclingcompetitive_grant2025$6,600award amountawardedCONFIRMED2026-07-21Confirm expenditure

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Recycling2023N/A — not loadedN/A — not loaded$5,600awardedCONFIRMED2026-07-21Confirm expenditure
Recycling2024N/A — not loadedN/A — not loaded$5,600awardedCONFIRMED2026-07-21Confirm expenditure
Recycling2025N/A — not loadedN/A — not loaded$6,600awardedCONFIRMED2026-07-21Confirm expenditure
MassDOT Complete Streets — 1 instruments • 1 awards • 2 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
MassDOT Complete Streets — Springfield St / Stony Hill Rd improvementscompetitive_grant2026$500,000award amountawardedCONFIRMED2026-07-21Project may not yet be expended

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Springfield St / Stony Hill Rd improvements2026N/A — not loadedN/A — not loaded$500,000awardedCONFIRMED2026-07-21Project may not yet be expended
MassWildlife Habitat Management Grant — 1 instruments • 1 awards • 2 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
MassWildlife Habitat Management Grant — Habitat managementcompetitive_grantYear unknown$11,600award amountawardedSUPPORTED2026-07-21Confirm award year project and closeout

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Habitat managementYear unknownN/A — not loadedN/A — not loaded$11,600awardedSUPPORTED2026-07-21Confirm award year project and closeout
Municipal Digital Equity Planning Grant — 1 instruments • 1 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Municipal Digital Equity Planning Grant — Broadband/digital equity planningcompetitive_grant2023N/A — no amount loadedaward amountawardedSUPPORTED2026-07-21Retrieve MBI award amount agreement and plan

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Broadband/digital equity planning2023N/A — not loadedN/A — not loadedN/A — no amount loadedawardedSUPPORTED2026-07-21Retrieve MBI award amount agreement and plan
Municipal Fiber Grant — 1 instruments • 0 awards • 1 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Municipal Fiber Grant — Regional project benefiting Wilbrahamrelated_external_assistanceFY2026$487,313benefit valueawardedCONFIRMED2026-07-21Determine Wilbraham subaward or in-kind benefit

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
MVP Action Grant — 1 instruments • 1 awards • 2 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
MVP Action Grant — Culvert assessmentcompetitive_grantFY2024$60,000award amountawardedCONFIRMED2026-07-21Confirm final reimbursement and closeout

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Culvert assessmentFY2024N/A — not loadedN/A — not loaded$60,000awardedCONFIRMED2026-07-21Confirm final reimbursement and closeout
MVP Planning Grant — 1 instruments • 1 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
MVP Planning Grant — HMP/MVP plancompetitive_grant2020-2021 approxN/A — no amount loadedN/A — not loadedunknownSUPPORTED2026-07-21Retrieve award contract amount and closeout

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
HMP/MVP plan2020-2021 approxN/A — not loadedN/A — not loadedN/A — no amount loadedunknownSUPPORTED2026-07-21Retrieve award contract amount and closeout
Police Taser grant component — 1 instruments • 1 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Police Taser grant component — Police equipmentcompetitive_grant2019-2020 approxN/A — no amount loadedN/A — not loadedunknownREPORTED2026-07-21Identify funder amount and grant account

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Police equipment2019-2020 approxN/A — not loadedN/A — not loadedN/A — no amount loadedunknownREPORTED2026-07-21Identify funder amount and grant account
Public Health Grant Award — 1 instruments • 1 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
Public Health Grant Award — Public healthcompetitive_grant2021N/A — no amount loadedN/A — not loadedunknownSUPPORTED2026-07-21Identify funder amount term and use

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Public health2021N/A — not loadedN/A — not loadedN/A — no amount loadedunknownSUPPORTED2026-07-21Identify funder amount term and use
PVTA and MassDOT senior transportation vehicle assistance — 1 instruments • 0 awards • 1 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
PVTA and MassDOT senior transportation vehicle assistance — New Wilbraham Senior Center van; Town newsletter characterizes $60,000 as savings to the Townrelated_external_assistanceAward announced May 2015; vehicle expected by June 2016$60,000benefit valueawardedCONFIRMED2026-07-21Retrieve application, selection notice, vehicle title and ownership, delivery and acceptance records, local match, operating obligations, useful-life restrictions, and valuation basis

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
SAFE and Senior SAFE — 1 instruments • 1 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
SAFE and Senior SAFE — Fire prevention educationcompetitive_grantRecurringN/A — no amount loadedN/A — not loadedunknownSUPPORTED2026-07-21Retrieve annual DFS awards and expenditures

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Fire prevention educationRecurringN/A — not loadedN/A — not loadedN/A — no amount loadedunknownSUPPORTED2026-07-21Retrieve annual DFS awards and expenditures
State Aid to Public Libraries — 1 instruments • 0 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
State Aid to Public Libraries — Wilbraham Public Libraryformula_aidAnnualN/A — no amount loadedN/A — not loadedunknownSUPPORTED2026-07-21Extract annual awards and use

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
United Way of Pioneer Valley Basic Needs Grant — 1 instruments • 1 awards • 2 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
United Way of Pioneer Valley Basic Needs Grant — Fuel assistance for Wilbraham seniorscompetitive_grantFY2015$5,000award amountawardedCONFIRMED2026-07-21Retrieve the application, award notice, recipient account, eligibility rules, assistance payments, reporting, and closeout

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
Fuel assistance for Wilbraham seniorsFY2015N/A — not loadedN/A — not loaded$5,000awardedCONFIRMED2026-07-21Retrieve the application, award notice, recipient account, eligibility rules, assistance payments, reporting, and closeout
University of Massachusetts grant — 1 instruments • 1 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-21SUPPORTEDactive_or_historicalProgram identity derived from discovery register; administrator and authoritative program identity require refinement.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
University of Massachusetts grant — COA nutrition/SNAP-related activitycompetitive_grantFY2026 evidenceN/A — no amount loadedN/A — not loadedunknownSUPPORTED2026-07-21Retrieve agreement receipts and distinguish 30000 spending ceiling

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
COA nutrition/SNAP-related activityFY2026 evidenceN/A — not loadedN/A — not loadedN/A — no amount loadedunknownSUPPORTED2026-07-21Retrieve agreement receipts and distinguish 30000 spending ceiling
Unspecified state and federal grants supporting Wilbraham Senior Center staffing — 1 instruments • 0 awards • 0 recorded amount entries
Program effective datesResearch dateEvidence labelRecord statusResearch boundary
N/A — not loaded2026-07-29CONFIRMEDactive_or_historicalPlaceholder program family required to preserve the Town's reported funding statement without inventing specific programs.

Linked instruments

InstrumentTypeFiscal year / periodRecorded amountAmount roleLifecycleEvidenceResearch dateResearch note
State and federal grant support for full-time Wilbraham Senior Center Activities/Volunteer CoordinatorgrantCalendar 2010N/A — no amount loadedamount unknownreported useCONFIRMED2026-07-29Town report confirms grant-funded staffing but does not identify specific programs, amounts, allocation shares, award dates, receipts, payroll expenditures, or closeout.

Linked award records

AwardFiscal yearAward dateAward periodRecorded amountLifecycleEvidenceResearch dateResearch note
The promise for the next layer: connect each candidate source to a real upcoming decision, then walk it through eligibility, application, award, receipt, accounting, expenditure, and closeout. That will let the Town distinguish “a source worth investigating” from “money that can responsibly reduce this proposal's local cost.”
Back to top

Walk-down view 9: Town and District debt as one portfolio—without false addition

A complete view includes both issuers, but compatible dates and allocations matter. The purpose is to see overlapping capacity claims, not create a misleading grand total.

TOWN AUDIT • 6/30/2024

Town outstanding principal

$12,745,767

Five governmental and business-type instruments.

TOWN AUDIT SCHEDULE

Town remaining service

$15,642,423

$12,745,767 principal + $2,896,656 future interest.

DISTRICT SCHEDULE

HWRSD displayed service

$30,115,833

FY2026–FY2041 displayed rows.

FY2026 CALCULATION

Wilbraham HWRSD share

$1,518,319.73

79.9% × approximately $1,900,275 FY2026 District service.

HWRSD displayed FY2026–FY2041 service

Principal $23,815,000
Interest $6,300,833
Principal: $23,815,000Interest: $6,300,833Displayed-row total: $30,115,833; source prints $2 less.
Non-duplication rules: use Town direct debt service + Wilbraham's allocated HWRSD debt service for the same fiscal year and compatible date. Do not add 100% of District debt. Do not add District debt again if it is already included in the member amount. Do not add temporary and permanent financing in the same refinancing chain.

The annual debt table we ultimately need—started now, with missing inputs visible

Each fiscal year should eventually show opening debt, new borrowing, principal retired, ending debt, interest, annual service by funding treatment, Wilbraham's HWRSD share, authorized and projected borrowing, burden ratios, household impact, and exclusion expiration. The current table creates that receiving structure from FY2024 through FY2041. A field marked N/A — not loaded is unknown in this view, not zero.

How to read every field

FieldPlain-language definitionReal Wilbraham example or present boundary
Opening principalDebt owed at the beginning of the fiscal year.FY2024 audited opening principal was $6,357,128.
New borrowingPrincipal added during the year; this is borrowed amount, not interest.FY2024 audited additions were $7,200,000.
Principal retiredBorrowed amount repaid during the year.FY2024 audited principal reductions were $811,361.
Ending principalDebt still owed after additions and repayments.FY2024 audited ending principal was $12,745,767.
InterestThe financing cost paid for using borrowed money, separate from repayment of principal.The current Town FY2025–FY2040 schedule contains $2,812,836 of interest; it is a schedule, not actual spending.
Total debt servicePrincipal plus interest due under the displayed schedule.The current Town FY2025–FY2040 schedule totals $14,797,467: $11,984,631 principal + $2,812,836 interest.
Ordinary-levy debt serviceDebt service paid within the ordinary levy and therefore competing with regular services and other operating costs.N/A — not loaded; the present debt schedule does not allocate each annual payment to ordinary levy.
Debt-excluded serviceQualifying annual debt cost added outside the ordinary levy limit under voter authorization.The FY2025 levy schedule reports $1,760,000 of aggregate current-year debt exclusions, but project-level principal, interest, reimbursement, and expiration are not loaded.
Enterprise-supported serviceDebt service expected to be paid by charges from water, sewer, solid waste, or another enterprise rather than ordinary taxes.N/A — not loaded in the annual receiving table.
Grant or reimbursement supportConfirmed outside funding that reduces the local debt or annual payment burden.N/A — not loaded; a grant record alone is not a confirmed debt-service offset.
HWRSD Wilbraham shareThe District payment allocated to Wilbraham using the applicable annual capital-allocation factor.FY2026 is calculated at $1,518,319.73 using the 79.9% factor; later official annual factors are not loaded.
Authorized unissuedBorrowing legally authorized but not yet issued as debt.The current Town snapshot reports $984,000 for fire equipment as of March 11, 2025; HWRSD reported $0 for FY2025.
Projected borrowingA capital-plan or scenario amount that has not yet been authorized or issued.N/A — not loaded; no scenario is manufactured.
Debt service / levyAnnual debt service divided by the actual property-tax levy; a property-tax burden indicator.FY2025 Town scheduled debt service alone is 1.34% of the FY2025 actual levy.
Debt service / expendituresAnnual debt service divided by the compatible expenditure or budget measure; an indicator of budget rigidity.FY2025 Town scheduled debt service alone is 1.12% of the published FY2025 budget.
Tax impact by property valueThe added annual tax calculated for representative assessed values under the actual proposed levy or exclusion.N/A — not loaded; the proposal-specific added levy and assessment-band calculation are missing.
Exclusion expirationThe year a temporary debt-exclusion addition ends because the authorized debt is paid.N/A — not loaded; project-level DE-1 and repayment attribution are required.
Two evidence layers remain separate: FY2024 opening, additions, reductions, and ending principal are audited historical rollforward facts. FY2025–FY2040 Town payments and FY2026–FY2041 HWRSD payments are schedule views, not actual expenditures and not forecasts of future new borrowing. Aggregate current schedule only; annual current rows are not packaged in this static edition.
Fiscal yearTown scheduled principalTown scheduled interestTown scheduled debt serviceCurrent HWRSD District debt serviceWilbraham HWRSD shareAuthorized unissuedSource/scope note
FY2024N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedrow retained so missing inputs remain visible
FY2025$575,000$59,813$634,813N/A — not loadedN/A — no official factor for this yearTown $984,000 as of 3/11/2025; HWRSD $0 reported for FY2025Town schedule as of 3/11/2025
FY2026$1,271,008$414,522$1,685,530$1,900,275.01$1,518,319.73N/A — not loadedTown schedule as of 3/11/2025; FY2026 HWRSD aggregate reconstructed from controlled allocation
FY2027$1,270,978$379,775$1,650,753N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2028$1,201,048$336,642$1,537,690N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2029$1,206,221$297,220$1,503,441N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2030$977,361$259,534$1,236,895N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2031$978,015$223,630$1,201,645N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2032$945,000$187,550$1,132,550N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2033$445,000$151,300$596,300N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2034$445,000$129,050$574,050N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2035$445,000$106,800$551,800N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2036$445,000$89,000$534,000N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2037$445,000$71,200$516,200N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2038$445,000$53,400$498,400N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2039$445,000$35,600$480,600N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2040$445,000$17,800$462,800N/A — not loadedN/A — no official factor for this yearN/A — not loadedTown schedule as of 3/11/2025
FY2041N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedrow retained so missing inputs remain visible
Open the full annual debt affordability matrix—all requested fields

The wide table scrolls horizontally. Project-level levy treatment, grant support, future borrowing, household impact, and exclusion expiration remain N/A until the identified evidence is loaded.

Fiscal yearEvidence layerOpening principalNew borrowingPrincipal retiredEnding principalTown scheduled principalTown scheduled interestTown scheduled total debt serviceOrdinary-levy debt serviceDebt-excluded serviceEnterprise-supported serviceGrant/reimbursement supportHWRSD District debt serviceHWRSD Wilbraham shareAuthorized unissuedProjected borrowingDebt service / levyDebt service / expendituresTax impact by property valueExclusion expirationSource and scope note
FY2024AUDITED FY2024 PRINCIPAL ROLLFORWARD$6,357,128$7,200,000$811,361$12,745,767N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedrow retained so missing inputs remain visible
FY2025DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$575,000$59,813$634,813N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearTown $984,000 as of 3/11/2025; HWRSD $0 reported for FY2025N/A — not loaded1.34% — Town scheduled service only1.12% — Town scheduled service / published budgetN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2026DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$1,271,008$414,522$1,685,530N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$1,900,275.01$1,518,319.73N/A — not loadedN/A — not loadedN/A — not loaded2.84% — Town scheduled service / published budgetN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025; FY2026 HWRSD aggregate reconstructed from controlled allocation
FY2027DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$1,270,978$379,775$1,650,753N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2028DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$1,201,048$336,642$1,537,690N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2029DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$1,206,221$297,220$1,503,441N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2030DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$977,361$259,534$1,236,895N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2031DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$978,015$223,630$1,201,645N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2032DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$945,000$187,550$1,132,550N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2033DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$445,000$151,300$596,300N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2034DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$445,000$129,050$574,050N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2035DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$445,000$106,800$551,800N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2036DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$445,000$89,000$534,000N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2037DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$445,000$71,200$516,200N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2038DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$445,000$53,400$498,400N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2039DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$445,000$35,600$480,600N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2040DISCLOSED SCHEDULE; NOT ACTUAL AND EXCLUDES FUTURE NEW BORROWINGN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loaded$445,000$17,800$462,800N/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedTown schedule as of 3/11/2025
FY2041RECEIVING ROW — INPUTS NOT LOADEDN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — no official factor for this yearN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedN/A — not loadedrow retained so missing inputs remain visible

What the portfolio view should add next

A current same-year Town debt schedule; exact project-level exclusions; all authorized-but-unissued work; Town and District capital plans; facility condition; operating effects; expected grants; reserves; and the timing of debt that retires. Only then can declining old debt be distinguished from capacity already spoken for by new commitments.

Back to top

Walk-down view 10: Town capacity is not household capacity

The legal ability to levy or borrow does not answer whether the distribution of cost is understandable or absorbable.

Susan's FY2025 assessment$720,400
Residential rate per $1,000$17.88
Calculated base tax$720,400 × $17.88 ÷ 1,000 ≈ $12,881
FY2023→FY2025 change+$1,397 • 12.2%
One example is not a distribution: this excludes the CPA surcharge, exemptions, abatements, betterments, and other bill adjustments. It does not establish the median home, fixed-income effect, assessment-band effect, or exact school share of a bill.

Household view appropriate for a major proposal

Several assessment bands

Show the same rate or exclusion effect for multiple values, with formula and assumptions visible.

Actual distribution

When available, show median and percentile changes, exemptions, residential/commercial classification, and comparable properties.

Duration

Separate a temporary exclusion from a permanent operating override and show when annual payments begin, peak, and end.

Service received

Pair the cost with the service, asset, risk reduction, access, or community result residents are expected to receive.

Decision use: present household examples after the Town-wide funding bridge is known. Never multiply a bill by HWRSD's 77.42% member share, 79.9% capital allocation, 53.38% Town-budget composition, or 63.82% levy scale comparison.
Back to top

A one-page whole-picture proposal view

This is the compact view leadership could receive first, with detailed evidence behind it.

1. Define
problem, baseline, result
2. Compare
alternatives and scenarios
3. Test
finance, law, operations, community effect
4. Decide and learn
gate, owner, measure, review
PanelWhat should appear
Decision requestedExact action, amount, authority, decision date, and what a yes/no or advance/pause choice changes.
Purpose and baselineProblem, current service/asset condition, current annual cost, use, risk, source date, and desired result.
AlternativesPreferred option plus credible alternatives, status quo consequences, common assumptions, and reasons for differences.
Five-year operating viewRecurring staffing, benefits, contracts, utilities, maintenance, insurance, technology, revenue, and service changes.
Capital and debt viewFull project cost, sources and uses, borrowing, principal, interest, annual payments, exclusion treatment, grants, reserves, replacement, and contingencies.
Portfolio fitCurrent Town and allocated HWRSD debt; other capital timing; levy capacity; reserves; schools; pension/OPEB; staff and project-management capacity.
Resident/community viewHousehold bands, users, service level, access, neighborhoods, historic or environmental assets, community character, and future flexibility.
Execution and accountabilityResponsible owner, milestones, procurement, dependencies, risks, measures, public reporting, review date, and course-correction trigger.
Standard affordability conclusion: “The proposal costs $X initially and $Y annually. Only $Z fits within presently projected resources. The remaining $A would require additional taxes, fees, reductions elsewhere, or another identified funding source. At the proposed funding level, it would leave $B of annual flexibility and produce an estimated tax impact of $C for a representative household.” Every placeholder should be source-supported or shown as N/A with an evidence owner and due date.
Why this helps: it does not force agreement. It makes the decision itself visible: which facts are known, which assumptions drive the result, what tradeoff is being made, and what must happen after approval.
Back to top

Decision-readiness gates

A proposal can be important and still not be ready. A decision gate turns missing evidence into a specific next step rather than a vague objection.

GateQuestionMinimum evidence to advancePause condition
Purpose and desired resultWhat changes for residents or Town operations?Named result, baseline, target, affected population, and connection to Town priorities.Pause if the proposal is only an object or expenditure without a defined outcome.
Current baselineWhat do we already own, spend, owe, or deliver?Current operating cost, staffing, use, condition, revenue, debt, legal status, and service performance.Pause if the starting condition cannot be reproduced from controlled evidence.
AlternativesWhy this option?At least two credible alternatives, including status quo/do-nothing consequences, common assumptions, and comparable life-cycle costs.Pause if only the preferred option is costed.
Operating effectWhat becomes recurring?Annual staffing, benefits, utilities, contracts, maintenance, technology, insurance, and revenue changes for at least five years.Pause if capital approval creates an unpriced operating commitment.
Capital and debtWhat is the full financing path?Authorization, grants, reserves, proceeds, borrowing, principal, interest, annual payments, exclusions, maturity, and replacement timing.Pause if original project cost is shown without financing and life-cycle effect.
Funding and levyWho pays and from what source?Same-year sources-and-uses bridge; recurring/one-time/restricted status; levy and unused-capacity effect; no double counting.Pause if a reserve, grant, fee, or sale is treated as interchangeable recurring revenue.
Household and service effectWho experiences the result?Representative assessment bands, actual-bill distribution when available, service users, equity/fixed-income exposure, and service-level change.Pause if one example is called typical or a departmental budget share is assigned to one tax bill.
Governance and executionCan the Town lawfully and practically deliver?Authority, votes, legal/title constraints, milestones, responsible owner, procurement, contingency, measures, and review date.Pause if the formal vote is mistaken for the entire implementation plan.

What the current data can and cannot answer

QuestionCurrent statusResponsible interpretation
Town-wide multi-year directionAvailableBudget +17.1% and actual levy +15.9% from FY2021 to FY2025, with periods and scopes preserved.
Broad Town spending movementsAvailable with cautionPublished category movements identify where to investigate; presentation changes and offsets prevent unsupported causal claims.
Current FY2027 warrant compositionAvailableAll 473 accounts and $66,372,362 of adjusted expenditure authority reconcile across service purpose, expense nature, fund family, and accounting presentation.
Which current accounts can changeNot yet assessedAll 473 flexibility records remain unassessed; 247 accounts totaling $4,674,021 also lack even a provisional cost driver.
Town-owned parcel inventoryAvailable with ownership boundary197 parcel-card rows are loaded; 171 meet the exact current Town-owner control, three name another current owner, and 23 lack a current ownership row. Legal use, restriction, condition, utilization, and disposition readiness remain separate questions.
2021 capital-needs assessmentAvailable as point-in-time evidenceSeventeen assessed properties connect to 17 managed assets, 27 building identities, and 18 parcel relationships. The source reports $5,106,762 of 2021 deferred maintenance and an original 2022–2031 inflated projection of $4,125,966; current work status, condition, scope, and prices remain unverified.
FY2024 capital-asset rollforwardAvailable as audited accounting evidenceThe rollforward contains 140 facts and moves combined net book value from $50,817,864 to $56,716,842. It does not provide market value, replacement cost, condition, or parcel-level project spending.
FY2024 interfund transfersAvailable by fund; transaction path incompleteTransfers in and out both reconcile to $747,640. Exact amount matches show compatible aggregate paths, but the schedule does not supply journal dates, purposes, or explicit one-to-one transaction links.
Pension and OPEB multi-year RSIAvailable with RSI-unaudited labelTen pension years and eight OPEB years show liability, plan-asset coverage, payroll, and contribution patterns. They inform long-range pressure but are not bonded debt, current-year cash requirements, or a complete forecast.
HWRSD budget and member burdenAvailableDistrict budget +13.9%, enrollment -1.9%, state-aid coverage down, and Wilbraham member amount +17.8% through the FY2026 estimate.
Known grant-source inventoryPreliminary and incomplete48 program records, 117 instrument records, and 68 award records support source discovery; 121 questions remain open, and no complete project-to-ledger receipt/use bridge is loaded.
Town and District debt pathsPartly availableDated Town audit baseline and current District schedule are controlled; a same-date consolidated portfolio and project-level exclusion bridge remain needed.
Household experienceExample onlySusan's calculated base tax changed by 12.2% from FY2023 to FY2025; median bills and distribution are not yet established.
Service value and underlying causesIncompleteComparable staffing, contract, facility, placement, transportation, utilization, quality, and outcome measures are not yet consistently linked to the financial changes.
Future capital affordabilityIncompleteThe 2021 building study provides a valuable baseline, but a completed/open/superseded work bridge, current conditions and prices, complete Town and District capital plans, operating forecasts, reserve plans, and replacement-capacity scenarios remain necessary.
Town affordability classificationFramework available; numeric finding incompleteThe report can classify a proposal as within present means, requiring reprioritization, requiring new revenue, one-time funded, financeable but unproven, not affordable under assumptions, or unknown. The full Town-wide recurring-capacity calculation is not yet loaded.
Affordability standard: affordability is not established because debt is amortizing or because legal levy room exists. It requires the combined operating, capital, debt, reserve, service, and household view across a meaningful horizon.
Back to top

A practical way to test the framework

The lowest-risk next step would be to use the same template on one real upcoming decision while it is still shapeable.

  1. Agree on the decision question. State the exact choice, required date, and decision-makers.
  2. Populate only controlled facts first. Use the existing budget, levy, HWRSD, debt, reserve, and household evidence; label every estimate and missing field.
  3. Ask departments for the smallest repeatable evidence set. Current baseline, alternatives, five-year operating effect, capital sources and uses, service result, implementation owner, and risk.
  4. Review the whole picture together. Let administration test feasibility, the Select Board test policy and public value, and Finance Committee test financial sustainability using the same assumptions.
  5. Record what changed. Preserve the chosen alternative, reasons, unresolved risks, funding, conditions, measures, and scheduled review.
The promise of this approach: major choices become easier to explain because the Town can show not only what it proposes to spend, but what problem it is solving, what alternatives were considered, how the commitment fits with everything else, what residents receive, and how the result will be checked.
Back to top

Decision-language glossary with Wilbraham examples

Every dotted term used in this guide is defined here with a real-number or local decision example.

TermPlain-language definitionWilbraham exampleFirst use
accounting presentationA classification that distinguishes the ledger location of a cost from its possible ultimate beneficiary, including regional assessments, centralized benefits, facilities, insurance, IT, salary pools, and source department cost centers.Only $23,264,501 is presented as a source department cost center; the remaining authority is regional, centralized, reserved, or passed through.Return to first use
adjusted expenditure budgetThe spending authority shown after the source report's budget adjustments. It is not the same as actual spending, cash on hand, incoming revenue, or another report's total-budget scope.The July 9, 2026 FY2027 Expense Control report contains 473 accounts with $66,372,362 of adjusted expenditure authority.Return to first use
affordabilityThe ability to pay existing obligations, maintain services and assets, preserve reasonable reserves, and cover a new commitment from dependable resources while leaving reasonable flexibility and making any household burden explicit.The Town and HWRSD schedules show repayment paths, but missing operating forecasts, current capital plans, maintenance funding standards, project-level exclusions, and household distributions prevent a final Wilbraham affordability conclusion.Return to first use
annual cash-flow affordabilityWhether a commitment can be paid every year from dependable resources without an unidentified tax or fee increase, repeated reserve draw, service reduction, or maintenance deferral.A new recurring program cannot be called affordable merely because free cash can cover its first year.Return to first use
assessed valueA value used in the local property-assessment record. For tax-exempt municipal property it is not a sale appraisal, replacement cost, insurance value, public value, or promise of proceeds.The 171 FY2026 Town-owned records mechanically sum to $24,059,300 of total assessed value, all shown as exempt value in the loaded records.Return to first use
assessment propertyThe site-level unit used by a professional study. It may represent one building, several buildings, or a broader facility property, so it must not automatically be relabeled as a building.The 2021 study has 17 assessment properties linked to 17 managed assets, 27 building identities, and 18 parcel relationships.Return to first use
award recordA record indicating that a specific award or award-like event was identified. Its status still must be checked before it is treated as received, posted, spent, or available for another purpose.There are 68 award records; 52 contain an amount, but only 5 are explicitly labeled received and one more is labeled reported received.Return to first use
capital needs assessmentA professional, point-in-time review of physical conditions and projected repairs or renewal. It is planning evidence—not an approved budget, appropriation, current bid, or proof that every item remains outstanding.EBI Consulting's August 23, 2021 study assessed 17 Wilbraham properties and used an original 2022–2031 planning horizon.Return to first use
capital projectionAn estimate of repair, replacement, or renewal needs over a stated future horizon. It is not cash already spent or automatically authorized, and it may overlap with other condition measures.The study's original 2022–2031 projections total $3,595,290 uninflated and $4,125,966 inflated across the 17 properties.Return to first use
capital-asset rollforwardAn accounting reconciliation showing how recorded capital-asset balances moved from the beginning to the end of a year through additions, disposals, transfers from construction in progress, and depreciation.The FY2024 audit moves combined governmental and business-type net capital assets from $50,817,864 to $56,716,842.Return to first use
critical repair classificationThe consultant's source category for work treated as critical in the 2021 assessment. The label is preserved, but present urgency still requires a current condition and completed-work check.The 17 source snapshots report $1,318,312 in the critical-repair field; three properties are affected by detailed-extraction exceptions.Return to first use
cumulative concentrationThe share of a total reached as items are added from largest to smallest. It shows how quickly a budget becomes concentrated.The five largest FY2027 account lines hold 63.2% of the adjusted expenditure budget; the largest 25 hold 81.0%.Return to first use
decision baselineThe current condition against which a proposal is measured: current cost, staffing, service level, asset condition, revenue, debt, and legal status.The FY2025 actual levy of $47,337,000 and FY2025 Town budget of $56,595,042 are two baseline measures, but they are not the same measure.Return to first use
decision gateA point at which a proposal advances, pauses for evidence, changes, or stops because defined financial, legal, operational, or public-value conditions have or have not been met.A major project should not move from concept to financing without a source-and-use bridge, life-cycle cost, alternatives, legal path, household effect, and operating plan.Return to first use
deferred maintenanceMaintenance or repair identified as delayed or outstanding in the source assessment. The reported amount must be rechecked against subsequent work and current prices before it is treated as a present obligation.Across the 17 assessment snapshots, the source-reported 2021 total is $5,106,762.Return to first use
depreciationAn accounting allocation of a capital asset's recorded cost over its estimated useful life. It is not automatically cash spent on repairs or the amount required to replace the asset.The FY2024 rollforward records $3,500,980 of additional accumulated depreciation across both activity types.Return to first use
distributional effectHow a decision affects different households, taxpayers, service users, neighborhoods, or future residents rather than only the Town-wide average.Susan's example base tax rose 12.2% from FY2023 to FY2025, but one home cannot establish the median or distribution of household effects.Return to first use
expense natureAn analytical grouping that asks what the Town is purchasing—such as personnel, assessment or aid, facilities, capital, debt, contracts, technology, or materials.The FY2027 view identifies $19,787,237 as personnel and $3,765,348 as capital projects and major acquisitions.Return to first use
facility allocationAn evidence-backed assignment of some or all of an account to a named building. A partial explicit allocation is not a full cost-of-ownership calculation.Current explicit FY2027 mappings show $500,000 for Memorial School, $214,650 for the Little Red Schoolhouse, and $53,750 for Town Hall; shared and centralized costs remain incomplete.Return to first use
financeableLegally or practically capable of being funded or borrowed. Financeable does not mean the full annual and life-cycle burden has been shown to fit within present means.A project may fit under a legal debt limit or receive voter authorization while still requiring an unshown tax, fee, reserve, service, or maintenance tradeoff.Return to first use
fund familyThe accounting container where spending authority is recorded. It does not by itself prove whether taxes, fees, grants, reserves, borrowing, or another inflow supplied the money.The General Operating Fund holds $57,018,471, or 85.9%, of this FY2027 report scope.Return to first use
funding bridgeA reconciliation showing which sources pay for a proposal and how those sources connect to the budget, levy, reserves, grants, fees, or debt without double counting.FY2024 audited General Fund revenue was $52,059,479; property taxes supplied $45,321,168, while other audited categories supplied $6,738,311.Return to first use
funding instrumentA particular grant, allocation, reimbursement, formula-aid, earmark, eligibility, or assistance record associated with a program and a possible recipient or purpose.The inventory has 117 instrument records; some describe awards, while others describe allocations, eligibility, proposals, or historical assistance.Return to first use
funding programThe named public or private grant, aid, reimbursement, or assistance program under which funding may be offered.Examples in the current Wilbraham inventory include ARPA SLFRF, Green Communities, Complete Streets, State 911, FEMA assistance, and Community Preservation Act distributions.Return to first use
grant closeoutThe final confirmation that allowable costs, reimbursement, reporting, records, and any repayment or continuing obligations have been completed.An award or received label is not the same as proof that a Wilbraham project is fully expended, reconciled, and closed.Return to first use
grant lifecycleThe sequence from identifying a source through eligibility, application, authorization or award, receipt, accounting, expenditure, reporting, and closeout.The current data is much stronger for identifying programs, instruments, and awards than for proving Town cash receipt, accounting entry, use, or closeout.Return to first use
inflated projectionThe study's projected capital-needs amount after applying its stated inflation treatment over the original horizon. It is not a 2026 price update.Across the 17 properties, the original 2022–2031 inflated field totals $4,125,966.Return to first use
interfund transferA movement of resources between Town funds. It is a source for one fund and a use for another, but it is not new outside revenue or a new Town-wide expense.The FY2024 audited governmental-fund schedule reports $747,640 transferred in and the same $747,640 transferred out.Return to first use
levy capacityLegal room within Proposition 2½ to raise property taxes. It is not cash, revenue already collected, or permission to spend without an appropriation.FY2025 unused levy capacity was $986,000 after the actual levy was set.Return to first use
life-cycle costThe full cost of a choice over time: acquisition or construction, financing, staffing, operation, maintenance, renewal, and eventual replacement or disposition.The $6.68 million Senior Center permanent bond is financing evidence, not the building's complete life-cycle cost.Return to first use
long-term capital affordabilityWhether an asset can be acquired, financed, operated, maintained, renewed, and eventually replaced while the Town also sustains the rest of its portfolio.The $6.68 million Senior Center bond is one financing input; staffing, utilities, maintenance, renewal, and other concurrent capital needs complete the affordability test.Return to first use
managed assetA facility, park, recreation property, or reference property maintained as a decision and management identity, separate from the parcel or parcels beneath it.The core registry contains 22 asset identities linked to 23 parcels and 30 building identities.Return to first use
match requirementMoney, eligible cost, or other contribution the recipient must provide to qualify for or retain an outside award.A $500,000 grant does not necessarily reduce Town cost by $500,000 if it requires additional eligible spending or a local match.Return to first use
materialityThe size of an item relative to the whole being studied. It helps put the largest decisions first without declaring smaller items unimportant.Education is 50.6% of the FY2027 adjusted expenditure budget in this report scope.Return to first use
N/A — not loadedA required field for which the report does not yet have compatible controlled evidence. It means unknown or unavailable in this view—not zero.The annual debt matrix marks project-level excluded service and tax impact N/A because the DE-1 and household distribution inputs are not loaded.Return to first use
net book valueCapitalized historical cost less accumulated depreciation under the accounting rules. It is not market value, replacement cost, insured value, sale proceeds, or a condition rating.The audited FY2024 ending net book value is $56,716,842 across governmental and business-type activities.Return to first use
non-critical repair classificationThe consultant's source category for repair work not placed in its critical category. It does not mean optional, unnecessary, completed, or correctly priced today.The 17 source snapshots report $3,777,199 in the non-critical-repair field; Memorial School has an unresolved detailed-extraction exception.Return to first use
non-duplication controlA rule preventing the same obligation, refinancing chain, reserve, or allocated cost from being counted more than once.The $7.2 million Senior Center temporary note and $6.68 million permanent financing are one chain, not two current obligations; HWRSD debt also cannot be added again if it is already inside a member assessment.Return to first use
one-time resourceMoney available once or irregularly, such as certain reserves, grants, or sale proceeds. It should not support a permanent cost without a replacement plan.FY2024 certified free cash of $4,125,286 was an available balance, not recurring annual revenue.Return to first use
opportunity costThe other service, project, reserve use, or tax capacity that becomes harder to fund when one choice uses limited money, staff time, land, or borrowing capacity.The FY2024–FY2025 Town Schools increase of $1,090,340 equaled 65.3% of that year's ordinary increment plus new-growth capacity; that is a pressure comparison, not earmarking.Return to first use
parcelA mapped and assessed land record. A parcel is not automatically a separately managed facility, a legal lot, a developable site, or an asset available for sale.The database has 197 loaded FY2026 parcel-card rows, of which 171 meet the report's current Town-owner control.Return to first use
plan fiduciary percentagePlan assets measured as a percentage of the related total liability under the source schedule. A higher percentage means a larger share is covered by plan assets, but it does not by itself establish contribution affordability.Pension RSI reports 55.12% for 2024; OPEB RSI reports 35.83% using rounded schedule values, with an exact-note cross-control of 35.84%.Return to first use
point-in-time conditionWhat an assessment observed or reported at a particular date. Later repairs, deterioration, reuse, demolition, construction, price changes, or scope changes require a new verification.The loaded capital assessment describes 2021 conditions; it does not by itself describe building condition in 2026.Return to first use
portfolioThe full set of current and proposed commitments that compete for the same financial and organizational capacity.A Wilbraham debt portfolio view uses Town direct debt service plus Wilbraham's allocated HWRSD debt service for compatible dates—not 100% of District debt.Return to first use
preliminary grant-source mapA research inventory of grant programs and related records already identified. It is a place to begin investigation—not a complete list, a promise of eligibility, or proof that money is available.The current controlled inventory contains 48 program records and 117 funding-instrument records, with 121 open research questions.Return to first use
reconciliation exceptionA controlled difference or unresolved extraction between a source-reported total and the detailed records. It is disclosed so a reader does not mistake an unresolved detail for a verified fact.Four of 68 capital-assessment reconciliation metrics are exceptions: two at Memorial School, one at the Former Police / IT Building, and one at the Little Red School House.Return to first use
recurring commitmentA cost expected to continue in later budgets unless a policy, contract, staffing level, service design, or obligation changes.The FY2025 ordinary 2.5% increment plus certified new growth added $1,670,000 of recurring levy-limit capacity.Return to first use
required supplementary informationSchedules required to accompany the audited financial statements but not covered by the auditor's opinion in the same way as the basic statements. RSI commonly provides multi-year pension, OPEB, and budget information.The loaded FY2024 report package includes ten years of pension RSI and eight years of OPEB RSI, each labeled RSI unaudited.Return to first use
scenarioA clearly labeled set of assumptions used to compare possible futures. A scenario is not a forecast unless supported and presented as one.Applying HWRSD's FY2026 79.9% capital share to later debt years would be an illustrative scenario—not an official member-town forecast.Return to first use
service outcomeThe observable result residents receive from spending, such as response time, instructional result, facility availability, safety, reliability, or condition.The current broad budget data identifies where spending changed, but it does not yet connect every change to a comparable service result.Return to first use
service-purpose classificationAn analytical grouping that asks which public service or organizational purpose a cost supports, while preserving the Town's original account and department labels.The CSKE service-purpose view places $8,951,426 in Public Safety and Emergency Services across 82 source accounts.Return to first use
source cost centerThe Town department or ledger location holding an account. It identifies source placement, which may differ from the departments, employees, services, or residents ultimately benefiting.The Select Board department contains a centralized salary pool; the pool should not be interpreted as Select Board operating consumption without a beneficiary allocation.Return to first use
source-and-use bridgeA project-level reconciliation connecting each funding source to the cost it may legally and practically pay, including timing, restrictions, match, reimbursement, accounting, and contingency.A grant award for a named project should not reduce the stated taxpayer cost until the Town can connect the award, receipt, allowable project use, and ledger treatment without double counting.Return to first use
spending flexibilityAn evidence-supported assessment of how much practical choice exists, when a change could occur, why the cost is constrained, and what consequence a reduction would create.All 473 FY2027 accounts remain unassessed; the Expense Control report alone cannot responsibly label them mandatory or discretionary.Return to first use
structural deficitA recurring gap in which ongoing costs exceed dependable ongoing revenue. One-time reserves can postpone the gap but do not eliminate it.A $1 million recurring program funded from a $3 million reserve can be paid temporarily; the fourth-year funding problem remains unless recurring revenue or spending changes.Return to first use
surplus propertyProperty determined through the applicable legal and policy process to be no longer needed for its municipal, protected, restricted, programmatic, or public purpose. An inventory label alone cannot make that determination.A parcel described as vacant still requires title, deed restrictions, Article 97 or other protection, present use, access, utilities, environmental conditions, community value, and future-need review.Return to first use
Town-owned parcel controlThe report's reproducible ownership test: the current ownership row names TOWN OF WILBRAHAM, has public-owner indicator Y, and has provisional owner classification MUNICIPAL.The test includes 171 parcels; 26 other loaded parcel cards remain outside that view because three name another current owner and 23 have no current ownership row.Return to first use
true available recurring capacityDependable recurring revenue remaining after existing services, debt, benefits, school obligations, responsible maintenance, reserve contributions, and known recurring pressures are recognized.The current data shows individual pieces, but a complete Wilbraham calculation remains N/A until a multi-year operating forecast, asset-funding standard, reserve plan, and aligned HWRSD assumptions are loaded.Return to first use
uninflated projectionThe study's capital-needs estimate before its stated future inflation factors are applied. The database also labels this source field as present value; the report preserves that wording rather than treating it as a current bid.Across the 17 properties, the original 2022–2031 uninflated/present-value field totals $3,595,290.Return to first use
vacant parcel labelA source-derived card status indicating that a primary improvement was not reported. It does not prove that land is unused, unrestricted, developable, surplus, or disposable.159 of the 171 controlled Town-owned parcel records carry the vacant label.Return to first use
whole-picture viewA decision view that places operating costs, revenue, levy capacity, debt, reserves, school obligations, household effects, service results, alternatives, and timing together before a commitment is made.For Wilbraham, it keeps the $56.6 million FY2025 Town budget, $47.3 million levy, HWRSD member amount, Town debt, District debt allocation, and household effects in related—but non-duplicated—views.Return to first use
Back to top

Underlying evidence remains available

This leadership guide changes the decision sequence; it does not remove the resident education or technical record.

Evidence labels, source scopes, reconciliation differences, raw CSV extracts, HWRSD controls, and missing-evidence boundaries remain in the package.

Back to top

Choose the next working view

Follow the annual process to see who acts and when, use the Finance Committee walkthrough to test one proposal, inspect the source register, or return to a resident-level explanation.