Wyoming Healthcare Financials

What is on this site?

This site collects and reports indicators of healthcare provider financial health, using publicly-accessible data. Currently, provider groups on this site include:

• Senior centers;
• Developmental preschools (or "Early Intervention and Education Programs" - EIEP - in the menu);
• Service providers for individuals with intellectual or developmental disabilities ("I/DD");
• Community mental health and substance abuse (MHSA) providers;
• Nursing homes; and
• Hospitals.

We continually work to update and re-assess the indicators displayed.

Why measure the financial stability of healthcare providers?

The vast majority of the Department of Health's budget goes to paying health care providers around the State to take care of various groups of people.

Many of these providers depend heavily on either governmental grants or Medicaid revenue for their business. These providers range from community mental health and substance abuse centers and service providers for individuals with intellectual and developmental disabilities to nursing homes and hospitals.

The intent of this site to make information available to the both decision-makers and the general public to support funding and oversight decisions that balance provider solvency and cost to the taxpayer.

How do I use the tool?

When you first open the page, all the indicators for all providers will show up.

• It helps to begin by filtering the table, based on either (a) a single provider, to see all indicators, or (b) a single indicator, to see how all providers compare.
• Once you have the view you want, the indicators are shown for each fiscal year.
• Data is presented as reported or calculated, but the surrounding cell color reflects the percentile rank of that indicator, as compared to similarly-sized providers nationally.
• The intensity of each color shows the percentile: red colors means that the percentile rank was low (e.g., starting at the 1st percentile), white colors reflect values around the median/50th percentile, and green colors indicate values that scored in the higher percentiles (e.g., up to the 99th percentile.).

Where does the data come from?

It depends on the service provider.

• For senior centers, EIEP, I/DD and MHSA providers, we use IRS non-profit tax return data from the Form 990. The IRS maintains a data dump of tax returns using Amazon Web Services.
• For nursing homes and hospitals, we use cost reports filed to the Centers for Medicare and Medicaid Services (CMS).

How is the data processed?

Once relevant data is extracted, we generally have a similar workflow for non-profits, nursing homes and hospitals:

• Calculate relevant indicators (e.g. Cash on Hand = (Cash + Savings) * 365 / (Total Expenses - Depreciation)
• Filter national providers based on those with similar NTEE codes, total expenditures and total employees.
• Group state and national providers by size, based on average total expenditures.
• Calculate the percentile rank -- within provider groups and fiscal years -- for each indicator and provider.
• Format values and percentiles and publish to a Google Sheet.