40DHHS-S3339 - Caseload Projections with Retros.xlsx

The document is a detailed Excel spreadsheet tracking Medicaid caseload projections for the Nevada Department of Health and Human Services (DHHS) from July 2013 through June 2027. The spreadsheet provides monthly historical and projected enrollment data across multiple Medicaid categories, including Parents and Children, Newly Eligible Adults, Aged Blind and Disabled, Waiver County Match Program, Child Welfare, and Nevada Check Up. The data captures total Medicaid managed care organization (MCO) and fee-for-service (FFS) enrollments, broken down by various demographic and program-specific segments.

The caseload data reveals significant growth in total Medicaid enrollment, increasing from approximately 314,050 individuals in July 2013 to a projected 789,142 in June 2027, representing a substantial expansion of healthcare coverage. The spreadsheet shows notable variations in enrollment across different program categories, with fluctuations in managed care and fee-for-service populations. Key observations include dramatic increases in enrollment during specific periods, such as the COVID-19 pandemic, and shifts in demographic composition. The data appears to be used for state-level healthcare planning, budgeting, and resource allocation, providing a comprehensive view of Medicaid program dynamics over an extended period.