Nonprofit Revenue and Program Research

The organization had multiple years of public financial reporting, but the filings alone could not explain which specific programs, participant behaviors, or operating practices were driving the patterns visible in aggregate revenue.

The work used the public record to identify the most important follow-up questions and scope a study that the organization could carry forward with its internal data.

Annual IRS Form 990 filings were located and reviewed through the IRS Tax Exempt Organization Search. A structured extraction workflow logged the relevant filing periods and converted reported revenue, expenses, and program-service information into a consistent financial history.

The tooling normalized line items and program labels across filing years, separated nominal changes from inflation-adjusted comparisons, and used reconciliation checks to keep reported totals aligned with the source filings. Changes were then decomposed by category so the organization could see which questions merited deeper internal analysis.

The process preserved the program labels reported in the filings and documented the limits of aggregate public data before recommending next steps. This created a defensible starting point without implying that public records contained customer, participation, capacity, cost, or outcomes detail that they did not.

The presentation converted the public findings into a practical research scope. It outlined a data audit, common program measures, patron segmentation, participation-pathway analysis, and outcomes documentation that the organization could use to structure its own internal work.

The proposed study would begin with an inventory of available data, definitions, workflows, privacy requirements, and reporting practices. It then organized the measures needed to examine program revenue, direct costs, fill rates, repeat participation, retention, capacity, scholarships, and outcomes. Patron segments and participation pathways would be studied across reservations, instruction, leagues, competition, and youth development, with validated definitions and governance rules established before any recurring reporting was automated.

The work concluded with the presentation and research framework. It did not include implementation of the internal study or reporting system.

The outcome was a clearer path from aggregate public filings to specific internal questions, measures, and data requirements that the organization could use for later research and decision support.