5 YEARS OF HISTORIC DATA | ||||||
SPECIFY TIME PERIOD AND ELIGIBILITY GROUP DEPICTED: | ||||||
Medicaid Pop 1 | HY 1 | HY 2 | HY 3 | HY 4 | HY 5 | 5-YEARS |
TOTAL EXPENDITURES | $- | |||||
ELIGIBLE MEMBER MONTHS | ||||||
PMPM COST | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
TREND RATES | 5-YEAR | |||||
ANNUAL CHANGE | AVERAGE | |||||
TOTAL EXPENDITURE | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
ELIGIBLE MEMBER MONTHS | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
PMPM COST | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
Medicaid Pop 2 | HY 1 | HY 2 | HY 3 | HY 4 | HY 5 | 5-YEARS |
TOTAL EXPENDITURES | $- | |||||
ELIGIBLE MEMBER MONTHS | ||||||
PMPM COST | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
TREND RATES | 5-YEAR | |||||
ANNUAL CHANGE | AVERAGE | |||||
TOTAL EXPENDITURE | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
ELIGIBLE MEMBER MONTHS | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
PMPM COST | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
Medicaid Pop 3 | HY 1 | HY 2 | HY 3 | HY 4 | HY 5 | 5-YEARS |
TOTAL EXPENDITURES | $- | |||||
ELIGIBLE MEMBER MONTHS | ||||||
PMPM COST | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
TREND RATES | 5-YEAR | |||||
ANNUAL CHANGE | AVERAGE | |||||
TOTAL EXPENDITURE | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
ELIGIBLE MEMBER MONTHS | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
PMPM COST | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
Other Data | HY 1 | HY 2 | HY 3 | HY 4 | HY 5 | 5-YEARS |
TOTAL EXPENDITURES | $- | |||||
ELIGIBLE MEMBER MONTHS | ||||||
PMPM COST | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
TREND RATES | 5-YEAR | |||||
ANNUAL CHANGE | AVERAGE | |||||
TOTAL EXPENDITURE | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
ELIGIBLE MEMBER MONTHS | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
PMPM COST | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
DEMONSTRATION WITHOUT WAIVER (WOW) BUDGET PROJECTION: COVERAGE COSTS FOR POPULATIONS | ||||||||||
ELIGIBILITY | TREND | MONTHS | BASE YEAR | TREND | DEMONSTRATION YEARS (DY) | TOTAL | ||||
GROUP | RATE 1 | OF AGING | DY 00 | RATE 2 | DY 01 | DY 02 | DY 03 | DY 04 | DY 05 | WOW |
Medicaid Pop 1 | ||||||||||
Pop Type: | Medicaid | |||||||||
Eligible Member Months | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
PMPM Cost | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
Total Expenditure | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||
Medicaid Pop 2 | ||||||||||
Pop Type: | Medicaid | |||||||||
Eligible Member Months | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
PMPM Cost | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
Total Expenditure | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||
Medicaid Pop 3 | ||||||||||
Pop Type: | Medicaid | |||||||||
Eligible Member Months | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
PMPM Cost | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
Total Expenditure | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
DEMONSTRATION WITH WAIVER (WW) BUDGET PROJECTION: COVERAGE COSTS FOR POPULATIONS | ||||||||
DEMONSTRATION YEARS (DY) | TOTAL WW | |||||||
ELIGIBILITY GROUP | DY 00 | DEMO TREND RATE | DY 01 | DY 02 | DY 03 | DY 04 | DY 05 | |
Medicaid Pop 1 | ||||||||
Pop Type: | Medicaid | |||||||
Eligible Member Months | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
PMPM Cost | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
Total Expenditure | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
Medicaid Pop 2 | ||||||||
Pop Type: | Medicaid | |||||||
Eligible Member Months | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
PMPM Cost | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
Total Expenditure | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
Medicaid Pop 3 | ||||||||
Pop Type: | Medicaid | |||||||
Eligible Member Months | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
PMPM Cost | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
Total Expenditure | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
Exp Pop 1 | ||||||||
Pop Type: | Expansion | |||||||
Eligible Member Months | ||||||||
PMPM Cost | ||||||||
Total Expenditure | $- | $- | $- | $- | $- | $- | ||
Exp Pop 2 | ||||||||
Pop Type: | Expansion | |||||||
Eligible Member Months | ||||||||
PMPM Cost | ||||||||
Total Expenditure | $- | $- | $- | $- | $- | $- |
Panel 1: Historic DSH Claims for the Last Five Fiscal Years: | ||||||
RECENT PAST FEDERAL FISCAL YEARS | ||||||
20__ | 20__ | 20__ | 20__ | 20__ | ||
State DSH Allotment (Federal share) | ||||||
State DSH Claim Amount (Federal share) | ||||||
DSH Allotment Left Unspent (Federal share) | $- | $- | $- | $- | $- | |
Panel 2: Projected Without Waiver DSH Expenditures for FFYs That Overlap the Demonstration Period | ||||||
FEDERAL FISCAL YEARS THAT OVERLAP DEMONSTRATION YEARS | ||||||
FFY 00 (20__) | FFY 01 (20__) | FFY 02 (20__) | FFY 03 (20__) | FFY 04 (20__) | FFY 05 (20__) | |
State DSH Allotment (Federal share) | ||||||
State DSH Claim Amount (Federal share) | ||||||
DSH Allotment Projected to be Unused (Federal share) | $- | $- | $- | $- | $- | $- |
Panel 3: Projected With Waiver DSH Expenditures for FFYs That Overlap the Demonstration Period | ||||||
FEDERAL FISCAL YEARS THAT OVERLAP DEMONSTRATION YEARS | ||||||
FFY 00 (20__) | FFY 01 (20__) | FFY 02 (20__) | FFY 03 (20__) | FFY 04 (20__) | FFY 05 (20__) | |
State DSH Allotment (Federal share) | $- | $- | $- | $- | $- | $- |
State DSH Claim Amount (Federal share) | ||||||
Maximum DSH Allotment Available for Diversion (Federal share) | ||||||
Total DSH Alltoment Diverted (Federal share) | $- | $- | $- | $- | $- | $- |
DSH Allotment Available for DSH Diversion Less Amount Diverted (Federal share, must be non-negative) | $- | $- | $- | $- | $- | $- |
DSH Allotment Projected to be Unused (Federal share, must be non-negative) | $- | $- | $- | $- | $- | $- |
Panel 4: Projected DSH Diversion Allocated to DYs | ||||||
DEMONSTRATION YEARS | ||||||
DY 01 | DY 02 | DY 03 | DY 04 | DY 05 | ||
DSH Diversion to Leading FFY (total computable) | ||||||
FMAP for Leading FFY | ||||||
DSH Diversion to Trailing FFY (total computable) | ||||||
FMAP for Trailing FFY | ||||||
Total Demo Spending From Diverted DSH (total computable) | $- | $- | $- | $- | $- |
Budget Neutrality Summary | ||||||
Without-Waiver Total Expenditures | ||||||
DEMONSTRATION YEARS (DY) | TOTAL | |||||
DY 01 | DY 02 | DY 03 | DY 04 | DY 05 | ||
Medicaid Populations | ||||||
Medicaid Pop 1 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
Medicaid Pop 2 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
Medicaid Pop 3 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
TOTAL | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
With-Waiver Total Expenditures | ||||||
DEMONSTRATION YEARS (DY) | TOTAL | |||||
DY 01 | DY 02 | DY 03 | DY 04 | DY 05 | ||
Medicaid Populations | ||||||
Medicaid Pop 1 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
Medicaid Pop 2 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
Medicaid Pop 3 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
Expansion Populations | ||||||
Exp Pop 1 | $- | $- | $- | $- | $- | $- |
Exp Pop 2 | $- | $- | $- | $- | $- | $- |
TOTAL | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
VARIANCE | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
Population Status Drop-Down |
Medicaid |
Expansion |
File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
File Modified | 0000-00-00 |
File Created | 0000-00-00 |