ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions for Using the Medicaid Rate Analysis Template
2
3
1. Complete the Practice Information section.
4
2. Enter your monthly costs in the Monthly Cost column.
5
3. Annual costs will auto-calculate.
6
4. Enter your total annual patient visits.
7
5. Enter your average Medicaid reimbursement per visit.
8
6. The spreadsheet will calculate your cost per visit and loss/gain.
9
10
Use this worksheet to support Medicaid rate negotiations and advocacy efforts.
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100