|
|
 |
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
State Summary for New Mexico for 2007
15 Grantees
| Payor Category |
Full
Charges This Period (a) |
Charges
as Percent of Payor |
Charges
as Percent of Total |
Amount
Collected This Period (b) |
Collections
as Percent of Payor |
Collections
as Percent of Total |
Collections
as Percent of Charges |
Collection
of recon./wrap around Current Year (c1) |
Collection
of recon./wrap around Previous Years
(c2) |
Collection
of other retroactive payments (c3) |
Penalty/Payback
(c4) |
Net
Retros |
Net
Retros as Percent of Charges |
Allowances
(d) |
Allowances
as Percent of Charges |
| 1. Medicaid Non-Managed Care |
9,494,147 |
27.5% |
8.1% |
7,078,880 |
21.6% |
10.1% |
74.6% |
110,277 |
2,102 |
|
0 |
112,379 |
1.2% |
1,673,260 |
17.6% |
| 2a. Medicaid Managed Care (capitated)
|
7,851,036 |
22.7% |
6.7% |
9,399,326 |
28.7% |
13.4% |
119.7% |
4,593,096 |
751,765 |
338,159 |
0 |
5,683,020 |
72.4% |
-1,578,202 |
- 20.1% |
| 2b. Medicaid Managed Care (fee-for-service)
|
17,175,659 |
49.8% |
14.6% |
16,293,673 |
49.7% |
23.3% |
94.9% |
4,718,059 |
1,509,815 |
263,512 |
0 |
6,491,386 |
37.8% |
3,091,713 |
18.0% |
| 3. Total Medicaid (Lines 1 +
2a + 2b) |
34,520,842 |
100.0% |
29.3% |
32,771,879 |
100.0% |
46.8% |
94.9% |
9,421,432 |
2,263,682 |
601,671 |
0 |
12,286,785 |
35.6% |
3,186,771 |
9.2% |
| 4. Medicare Non-Managed Care |
10,916,146 |
99.5% |
9.3% |
8,678,657 |
99.6% |
12.4% |
79.5% |
0 |
22,724 |
|
57,891 |
-35,167 |
- 0.3% |
1,212,173 |
11.1% |
| 5a. Medicare Managed Care (capitated)
|
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
0 |
0 |
0 |
0 |
0 |
--- |
0 |
--- |
| 5b. Medicare Managed Care (fee-for-service)
|
59,352 |
0.5% |
0.1% |
35,259 |
0.4% |
0.1% |
59.4% |
0 |
0 |
0 |
0 |
0 |
0.0% |
32,500 |
54.8% |
| 6. Total Medicare (Lines 4 +
5a + 5b) |
10,975,498 |
100.0% |
9.3% |
8,713,916 |
100.0% |
12.5% |
79.4% |
0 |
22,724 |
0 |
57,891 |
-35,167 |
- 0.3% |
1,244,673 |
11.3% |
| 7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
4,888,321 |
73.1% |
4.2% |
2,148,298 |
58.5% |
3.1% |
43.9% |
|
|
|
0 |
0 |
0.0% |
2,698,352 |
55.2% |
| 8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
1,772,649 |
26.5% |
1.5% |
1,512,108 |
41.2% |
2.2% |
85.3% |
|
|
0 |
0 |
0 |
0.0% |
260,541 |
14.7% |
| 8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
29,889 |
0.4% |
0.0% |
8,914 |
0.2% |
0.0% |
29.8% |
|
|
0 |
0 |
0 |
0.0% |
0 |
0.0% |
| 9. Total Other Public (Lines
7 + 8a + 8b) |
6,690,859 |
100.0% |
5.7% |
3,669,320 |
100.0% |
5.2% |
54.8% |
|
|
0 |
0 |
0 |
0.0% |
2,958,893 |
44.2% |
| 10. Private Non-Managed Care |
16,707,402 |
82.3% |
14.2% |
9,739,721 |
82.4% |
13.9% |
58.3% |
|
|
|
0 |
0 |
|
5,258,106 |
31.5% |
| 11a. Private Managed Care (capitated)
|
3,203,386 |
15.8% |
2.7% |
1,994,054 |
16.9% |
2.8% |
62.2% |
|
|
0 |
0 |
0 |
0.0% |
1,209,332 |
37.8% |
| 11b. Private Managed Care (fee-for-service)
|
380,076 |
1.9% |
0.3% |
79,627 |
0.7% |
0.1% |
21.0% |
|
|
0 |
0 |
0 |
0.0% |
2,212 |
0.6% |
| 12. Total Private (Lines 10
+ 11a + 11b) |
20,290,864 |
100.0% |
17.2% |
11,813,402 |
100.0% |
16.9% |
58.2% |
|
|
0 |
0 |
0 |
0.0% |
6,469,650 |
31.9% |
| 13. Self-Pay |
45,295,526 |
100.0% |
38.5% |
13,020,300 |
100.0% |
18.6% |
28.7% |
|
|
|
|
|
|
|
|
| 14. Total (Lines 3 + 6 + 9 +
12 + 13) |
117,773,589 |
|
100.0% |
69,988,817 |
|
100.0% |
59.4% |
9,421,432 |
2,286,406 |
601,671 |
57,891 |
12,251,618 |
10.4% |
13,859,987 |
11.8% |
|
Sliding Discounts (e) |
Sliding Discounts as a Percent of Self-Pay
Charges |
Bad Debt Write Off(f) |
Bad Debt as Percent of Self-Pay
Charges |
| 13. Self-Pay (line 14 is same) |
27,491,234 |
60.7% |
3,444,923 |
7.6% |
data as of: 7/22/2008 3:15:35
|
