Docstoc

Mortgage Calculator Alabama

Document Sample
Mortgage Calculator Alabama Powered By Docstoc
					          A

1
2
3   This spreadsheet has a compa
4   Please read it first and your br
5   Step 1: Find your three geogra
6   I've arranged the three GPCI c
7   Step 2: Determine the current
           A
 8   Step 3: Determine YOUR Co
 9   Step 4: Determine your total p
10   Put this "billing as a percentag
11   YOU'RE DONE!
12   If you don't like the calculated
13   Step 5: To get all of the curren
14   The codes are located in files
15   The current (October '03) listi
           A
16   The codes for 2004, when firs
17   The link to download will giv
18   The RVU and CF codes are in
19   The GPCI codes are in files G
20   The .xls file type (Excel) prob
21   No commercial use of this pro
22   There is no guarantee of the a
23   However, I would appreciate
          A
24   Richard L. Anderson, O.D.
25   Camarillo, CA
26   randerson@west.net
27
28   Step 1
29   Step 2
30   Step 3
31   Step 4
           A
32
33   CPT
34    For info, click and view the
35   65205
36   65210
37   65220
38   65222
39   67820
         A
40   67938
41   68530
42   68761
43   68801
44   68810
45   68840
46   92002
47   92004
         A
48   92012
49   92014
50   92015
51   92020
52   92081
53   92082
54   92083
55   92100
         A
56   92265
57   92283
58   92285
59   92286
60   99201
61   99202
62   99203
63   99204
         A
64   99205
65   99211
66   99212
67   99213
68   99214
69   99215
70   66984
71
     A
72
73
74
75
76
77
78
79
     A
80
81
82
83
84
85
86
87
     A
88
89
90
91
92
93
94
95
      A
96
97
98
99
100
101
102
103
      A
104
105
106
107
108
109
110
111
      A
112
113
114
115
116
117
118
119
          A
120
121
122
123
124 EVERYTHING BELOW TH
125 This is what the current (2003
126 open the pprrvu03.xls file from
127 You want to copy the five val
       A
128 HCPCS
129
130
131
132
133
134 65205
135 65210
        A
136 65220
137 65222
138 65235
139 67938
140 68530
141 68761
142 68801
143 68810
        A
144 68840
145 92002
146 92004
147 92012
148 92014
149 92015
150 92081
151 92082
        A
152 92083
153 92100
154 92265
155 92283
156 92285
157 92286
158 99201
159 99202
        A
160 99203
161 99204
162 99205
163 99211
164 99212
165 99213
166 99214
167 99215
        A
168 67820
169 92020
170 66984
                         B

       1
       2
 spreadsheet has a companion Word document: CP
       3
        it
 e read4 first and your browsing here will make m
 1: Find your three geographic codes (GPCI) from
       5
arranged the three GPCI codes so you can copy and
       6
 2: Determine the current Medicare Conversion Fa
       7
                             B
  3: Determine YOUR Conversion Factor (CF) and
         8
  4: Determine your total percentage office overhea
         9
 his "billing as a percentage of overhead" figure int
        10
U'RE DONE!
        11
 u don't like the calculated "My Fee" (too high or lo
        12
        get
  5: To 13 all of the current CF, RVU and CGCI co
        are
 codes 14 located in files on this page: http://www.
 current (October '03) listing is at a link on that pag
        15
                           B
        for
codes 16 2004, when first published, should be RV
 ink to17download will give you several files when u
RVU and CF codes are in files pprrvu03.??? where
        18
GPCI 19 codes are in files GPCI03.??? where ??? det
 xls file type (Excel) probably makes the most sens
        20
ommercial use of this program is authorized.
        21
e is no guarantee of the accuracy of this spreadshe
        22
ever, I would appreciate an email if you do find an
        23
                          B
ard L.24Anderson, O.D.
        CA
arillo,25
erson@west.net
       26
     27
     28   GPCI's (Copy and paste from blue table)
     29   Medicare CF:
     30   My CF:
     31   Billing as a percentage of overhead:
                          B
       32
       33 Description (Short)
        click
r info,34 and view the formula bar info at the to
       35 Remove foreign body from eye
       36 Remove foreign body from eye
       37 Remove foreign body from eye
       38 Remove foreign body from eye
       39 Epilation, with forceps
                     B
40   Remove eyelid foreign body
41   Clearance of tear duct
42   Close tear duct opening
43   Dilate tear duct opening
44   Probe nasolacrimal duct
45   Explore/irrigate tear ducts
46   Eye exam, new patient
47   Eye exam, new patient
                     B
48   Eye exam established pat
49   Eye exam & treatment
50   Refraction
51   Special eye evaluation
52   Visual field examination(s)
53   Visual field examination(s)
54   Visual field examination(s)
55   Serial tonometry exam(s)
                      B
56   Eye muscle evaluation
57   Color vision examination
58   Eye photography
59   Internal eye photography
60   Office/outpatient visit, new
61   Office/outpatient visit, new
62   Office/outpatient visit, new
63   Office/outpatient visit, new
                      B
64   Office/outpatient visit, new
65   Office/outpatient visit, est
66   Office/outpatient visit, est
67   Office/outpatient visit, est
68   Office/outpatient visit, est
69   Office/outpatient visit, est
70   Cataract surg w/iol, 1 stage
71
     B
72
73
74
75
76
77
78
79
     B
80
81
82
83
84
85
86
87
     B
88
89
90
91
92
93
94
95
      B
96
97
98
99
100
101
102
103
      B
104
105
106
107
108
109
110
111
      B
112
113
114
115
116
117
118
119
                           B
     120
     121
     122
     123
RYTHING BELOW THIS LINE IS NOT NECES
      124
      125
is what the current (2003) CPT spreadsheet looks
      126
 the pprrvu03.xls file from Step 5.
want 127
      to copy the five values in pink to the area abo
                    B
128 MOD
129 Suggestion - not necessary though:
130 Copy the whole line of the desired CPTs
131 I've done several of them to show you. Y
132 Then you can copy and paste vertical col
133 Check when you cut, copy and paste. I th
134
135
      B
136
137
138
139
140
141
142
143
      B
144
145
146
147
148
149
150
151
      B
152
153
154
155
156
157
158
159
      B
160
161
162
163
164
165
166
167
      B
168
169
170
                C           D           E

         1  CPT Fee Calculator With
         2
d document: CPT Fee Calculator Info which explai
         3
ere will make more sense. It would make sense to s
         4
 s (GPCI) from the list (blue table) on this spreadsh
         5
ou can copy and paste all three in one operation. T
         6
 Conversion Factor and enter it. (See step 5) I've d
         7
                C           D           E
actor (CF) and enter it. Remember that Medicare i
          8
  office overhead expenses related to billing. There
          9
head" figure into the blue box of the green calculat
         10
         11                         (Here's the gree
" (too high or low) then override it by entering a fe
         12
U and CGCI codes, follow these directions:
         13
ge: http://www.cms.hhs.gov/providers/pufdownloa
         14
         that
 ink on 15 page titled RVU03 D.Zip. (Meaning R
                C           D            E
d, should be RVU04 A.Zip.
         16
eral files when unzipped (Get Stuffit Expander or o
         17
 vu03.??? where ??? determines the file type. The t
         18
          ???
? where19 determines the file type. The two num
es the most sense. Most of the data is duplicated in
         20
         21
  this spreadsheet nor its suitability for any purpose
         22
f you do find an error.
         23
               C          D           E
      24
      25
      26
      27                 Work        Practice
rom blue table) --->
      28                 0.978         0.87
      29 36.7856 <--- Put in the current Medic
      30           38 <--- Put in what you want fo
      31         0.33 <--- This is from the bottom
               C           D          E
        32     Work      Non-FAC     MP
        33     RVU       PE RVU     RVU
        at                ?
ar info 34 the top -->---> (Click)  To get these th
        35        0.71         0.62    0.03
        36        0.84         0.77    0.03
        37        0.71         3.50    0.05
        38        0.93         0.78    0.04
        39        0.89         1.14    0.04
     C      D       E
40   1.33    9.40   0.06
41   3.66   13.81   0.16
42   1.36    3.00   0.06
43   0.94    0.85   0.04
44   1.90    2.40   0.08
45   1.25    1.56   0.05
46   0.88    0.94   0.02
47   1.67    1.66   0.03
     C      D          E
48   0.67       0.99   0.01
49   1.10       1.37   0.02
50   0.38       1.51   0.01
51   0.89       1.14   0.04
52   0.36       0.89   0.02
53   0.44       1.06   0.02
54   0.50       1.37   0.02
55   0.92       0.73   0.02
     C      D          E
56   0.81       1.89   0.04
57   0.17       0.86   0.02
58   0.20       0.85   0.02
59   0.66       2.86   0.03
60   0.45       0.48   0.02
61   0.88       0.77   0.05
62   1.34       1.10   0.08
63   2.00       1.49   0.10
     C       D          E
64    2.67       1.79   0.12
65    0.17       0.38   0.01
66    0.45       0.52   0.02
67    0.67       0.69   0.03
68    1.10       1.03   0.04
69    1.77       1.34   0.07
70   10.23       7.65   0.41
71
     C   D   E
72
73
74
75
76
77
78
79
     C   D   E
80
81
82
83
84
85
86
87
     C   D   E
88
89
90
91
92
93
94
95
      C   D   E
96
97
98
99
100
101
102
103
      C   D   E
104
105
106
107
108
109
110
111
      C   D   E
112
113
114
115
116
117
118
119
           C       D       E
    120
    121
    122
    123
S NOT124NECESSARY FOR THE CALCULATOR
       125
eadsheet looks like if you  NOT USED
       126                  FOR
k to the area above. STATUS MEDICARE
       127
                C           D           E
       128 DESCRIPTIONCODE          PAYMENT
       129
e desired CPTs from the master list spreadsheet (s
       130
 to show you. You can go find any additional ones
       131
aste vertical columns into the CPT Calculator abov
       132
y and paste. I think Excel does it oddly. If you real
       133
                      A
       134 Remove foreign body from eye
                      A
       135 Remove foreign body from eye
       C          D         E
                A
136 Remove foreign body from eye
                A
137 Remove foreign body from eye
                A
138 Remove foreign body from eye
                A
139 Remove eyelid foreign body
                A
140 Clearance of tear duct
                A
141 Close tear duct opening
                duct opening
142 Dilate tear A
                A
143 Probe nasolacrimal duct
        C           D             E
               A
144 Explore/irrigate tear ducts
                new
145 Eye exam, A patient
                new
146 Eye exam, A patient
               A
147 Eye exam established pat
               A
148 Eye exam & treatment
149 Refraction N            +
               A
150 Visual field examination(s)
               A
151 Visual field examination(s)
        C           D              E
               A
152 Visual field examination(s)
               A
153 Serial tonometry exam(s)
               A
154 Eye muscle evaluation
               A
155 Color vision examination
               A
156 Eye photography
               A
157 Internal eye photography
               A
158 Office/outpatient visit, new
               A
159 Office/outpatient visit, new
        C           D              E
              A
160 Office/outpatient visit, new
              A
161 Office/outpatient visit, new
              A
162 Office/outpatient visit, new
              A
163 Office/outpatient visit, est
              A
164 Office/outpatient visit, est
              A
165 Office/outpatient visit, est
              A
166 Office/outpatient visit, est
              A
167 Office/outpatient visit, est
        C           D              E
              A
168 Revise eyelashes
              A
169 Special eye evaluation
              A
170 Cataract surg w/iol, 1 stage
                  F               G
culator With Time of Service (T
      1
          2
Info which explains much of the background of th
          3
d make sense to save a copy before you make chan
          4
 ) on this5spreadsheet and copy them to the three ap
  one operation. These codes are 2003. For next ye
          6
           5)
See step7 I've defaulted to 2003's value of 36.785
                   F                G
er that Medicare is a discount program. I defaulted
          8
 to billing. There is a green calculator here or you
          9
the green calculator. I defaulted to .33 (33%).
         10
  (Here's the green calculator) ------->-------->-----
         11
it by entering a fee in the next column. The TOS f
         12
       13
iders/pufdownload/rvudown.asp
       14
.Zip. (Meaning RVU 2003 Fourth Version)
       15
                  F                G
         16
ffit Expander or other utility)
         17
he file type. The two numerals are the year.
         18
          two
pe. The19 numerals are the year.
a is duplicated in the different file types.
         20
         21
y for any purpose.
         22
         23
                  F              G
        24
        25
        26
        27 Malpractice
        28      0.807      (Here's the blue table)
the current Medicare Conversion Factor (It was 36
        29
what you want for your personal Conversion Facto
        30
 from the bottom blue box in the green calculator.
        31
         F            G
32
33 Medicare Calc    My fee
34   ? (Click)     ? (Click)      This
                   Check this column w
35    $46.28         $47.80
36    $55.75         $57.59
37   $139.04        $143.63
38    $59.61         $61.58
39    $69.69         $71.99
       F         G
40   $350.46   $362.03
41   $578.39   $597.49
42   $146.72   $151.56
43    $62.21    $64.26
44   $147.54   $152.41
45    $96.38    $99.56
46    $62.34    $64.39
47   $114.10   $117.86
       F        G
48   $56.08   $57.94
49   $84.01   $86.79
50   $62.29   $64.35
51   $69.69   $71.99
52   $42.03   $43.42
53   $50.35   $52.01
54   $62.43   $64.49
55   $57.05   $58.94
       F         G
56    $90.81    $93.81
57    $34.23    $35.36
58    $34.99    $36.15
59   $116.16   $120.00
60    $32.14    $33.21
61    $57.79    $59.69
62    $85.79    $88.62
63   $122.61   $126.65
       F         G
64   $156.91   $162.09
65    $18.57    $19.19
66    $33.42    $34.53
67    $47.08    $48.63
68    $73.72    $76.16
69   $108.64   $112.23
70   $625.04   $645.67
71    $0.00     $0.00
      F       G
72   $0.00   $0.00
73   $0.00   $0.00
74   $0.00   $0.00
75   $0.00   $0.00
76   $0.00   $0.00
77   $0.00   $0.00
78   $0.00   $0.00
79   $0.00   $0.00
      F       G
80   $0.00   $0.00
81   $0.00   $0.00
82   $0.00   $0.00
83   $0.00   $0.00
84   $0.00   $0.00
85   $0.00   $0.00
86   $0.00   $0.00
87   $0.00   $0.00
      F       G
88   $0.00   $0.00
89   $0.00   $0.00
90   $0.00   $0.00
91   $0.00   $0.00
92   $0.00   $0.00
93   $0.00   $0.00
94   $0.00   $0.00
95   $0.00   $0.00
       F       G
96    $0.00   $0.00
97    $0.00   $0.00
98    $0.00   $0.00
99    $0.00   $0.00
100   $0.00   $0.00
101   $0.00   $0.00
102   $0.00   $0.00
103   $0.00   $0.00
       F       G
104   $0.00   $0.00
105   $0.00   $0.00
106   $0.00   $0.00
107   $0.00   $0.00
108   $0.00   $0.00
109   $0.00   $0.00
110   $0.00   $0.00
111   $0.00   $0.00
       F       G
112   $0.00   $0.00
113   $0.00   $0.00
114   $0.00   $0.00
115   $0.00   $0.00
116   $0.00   $0.00
117   $0.00   $0.00
118   $0.00   $0.00
119   $0.00   $0.00
            F          G
    120   $0.00       $0.00
    121   $0.00       $0.00
    122   $0.00       $0.00
    123
CALCULATOR TO WORK. IT IS ONLY HERE
    124
     USED
 NOT125          FULLY
    126          IMPLEMENTED
    127 WORK     NON-FAC
                  F              G
        128 RVU             PE RVU
        129
ist spreadsheet (see step 5) and paste them here.
        130
y additional ones you need in step 5.
        131
T Calculator above. These may change over time.
        132
        If you
oddly. 133 really mess up, start over from your
        134            0.71              0.62
        135            0.84              0.77
      F          G
136       0.71        3.50
137       0.93        0.78
138       7.57        6.84
139       1.33        9.40
140       3.66       13.81
141       1.36        3.00
142       0.94        0.85
143       1.90        2.40
      F          G
144       1.25       1.56
145       0.88       0.94
146       1.67       1.66
147       0.67       0.99
148       1.10       1.37
149       0.38       1.51
150       0.36       0.89
151       0.44       1.06
      F          G
152       0.50       1.37
153       0.92       0.73
154       0.81       1.89
155       0.17       0.86
156       0.20       0.85
157       0.66       2.86
158       0.45       0.48
159       0.88       0.77
      F          G
160       1.34       1.10
161       2.00       1.49
162       2.67       1.79
163       0.17       0.38
164       0.45       0.52
165       0.67       0.69
166       1.10       1.03
167       1.77       1.34
      F           G
168        0.89       1.14
169        0.37       0.92
170       10.23       7.65
                   H              I
of Service (TOS) Discount
       1
            2
he background of this calculator.
            3
efore you make changes.
            4
  them to the three appropriate boxes.
            5
 e 2003. For next years, see Step 5.
            6
            of
 03's value 7 36.7856.
                     H                I
program. I 8 defaulted to 38. CF? (Click) Your
lculator here or you can enter any value.
             9
d to .33 (33%).
            10
 ------->-------->--------->------->-------->------->----
            11
 column. The TOS fee will be recalculated.
            12
          13
          14
urth Version)
          15
     H   I
16
17
18
19
20
21
22
23
                    H               I
           24
           25
           26
           27
ere's the blue table) ----->----->----->----->----->---
           28
           (It
on Factor 29 was 36.7856 in March 2003)
al Conversion Factor
           30
he green calculator. Change it there.
           31
        H             I
32   Override
33   My Fee My Fee (TOS)
34   ? (Click)    you enter      here,
               If ? (Click) a feeThis
35                $41.04
36                $49.19
37               $105.45
38                $53.07
39                $59.55
     H      I
40       $259.48
41       $446.82
42       $118.83
43        $54.99
44       $126.23
45        $82.54
46        $54.14
47        $99.75
     H     I
48       $47.14
49       $71.84
50       $47.88
51       $59.55
52       $33.71
53       $40.44
54       $49.54
55       $50.97
     H      I
56        $73.19
57        $25.98
58        $26.87
59        $88.80
60        $27.97
61        $51.29
62        $76.62
63       $110.40
     H      I
64       $142.56
65        $15.04
66        $28.86
67        $41.10
68        $64.92
69        $97.61
70       $562.21
71        $0.00
     H     I
72       $0.00
73       $0.00
74       $0.00
75       $0.00
76       $0.00
77       $0.00
78       $0.00
79       $0.00
     H     I
80       $0.00
81       $0.00
82       $0.00
83       $0.00
84       $0.00
85       $0.00
86       $0.00
87       $0.00
     H     I
88       $0.00
89       $0.00
90       $0.00
91       $0.00
92       $0.00
93       $0.00
94       $0.00
95       $0.00
      H     I
96        $0.00
97        $0.00
98        $0.00
99        $0.00
100       $0.00
101       $0.00
102       $0.00
103       $0.00
      H     I
104       $0.00
105       $0.00
106       $0.00
107       $0.00
108       $0.00
109       $0.00
110       $0.00
111       $0.00
      H     I
112       $0.00
113       $0.00
114       $0.00
115       $0.00
116       $0.00
117       $0.00
118       $0.00
119       $0.00
             H          I
      120             $0.00
      121             $0.00
      122             $0.00
      123
IT IS ONLY HERE TO HELP YOU GET THE R
        124
        125         FULLY
        126 NON-FAC IMPLEMENTED
        127 NA      FACILITY
                   H             I
                           P
           128 INDICATORE RVU
           129
  paste them here.
           130
           131
y change over time.
           132
 tart over from your copy, after you make another c
           133
           134                        0.19
           135                        0.30
         H   I
136              0.18
137              0.28
138 NA           6.84
139              0.51
140              3.00
141              0.95
142              0.56
143              0.88
      H   I
144           0.93
145           0.35
146           0.70
147           0.30
148           0.48
149           0.15
150           0.89
151           1.06
      H   I
152           1.37
153           0.38
154           1.89
155           0.86
156           0.85
157           2.86
158           0.16
159           0.32
      H   I
160           0.49
161           0.72
162           0.95
163           0.06
164           0.16
165           0.24
166           0.40
167           0.64
         H   I
168              0.38
169              0.16
170 NA           7.65
           J        K
Discount
      1
      2          ? (Click)        Why
      3        Billing Overhead Cal
      4        There are many ways t
      5        I have filled in sample
      6                      Fill in val
      7        Practice Gross Income
                     J            K
              8                Cost of Goods Sold
              9                Rent or mortgage
             10                Total Square Footage
---->-------->------->-------->Square Footage related
             11
be recalculated.
             12                Employee expense rela
             13                Office expense related
             14                Phone expense related
             15                Total utilities
     J        K
16       Hours you spend on bi
17       Hourly salary for your
18       Other billing expenses
19       Other billing expenses
20       Practice Net
21       Calculated Overhead
22       Calculated Billing as a
23       Enter the value in yello
                    J            K
            24
            25
            26
            27
--->----->----->----->----->
            28
n March 2003)
            29               Carrier No
            30                 00510
            31                 00831
       J          K
32              00832
33 % Discount   00520
34  ? (Click)    This
                31146calculates how
35   14%        31146
36   15%        31140
37   27%        31140
38   14%        31140
39   17%        31140
      J      K
40   28%   31140
41   25%   31146
42   22%   31146
43   14%   31140
44   17%   00824
45   17%   00591
46   16%   00902
47   15%   00903
      J      K
48   19%   00590
49   17%   00590
50   26%   00590
51   17%   00511
52   22%   00511
53   22%   00833
54   23%   05130
55   14%   00952
      J      K
56   22%   00952
57   27%   00952
58   26%   00952
59   26%   00630
60   16%   00826
61   14%   00650
62   14%   00740
63   13%   00660
        J        K
64    12%      00528
65    22%      00528
66    16%      31142
67    15%      31142
68    15%      00901
69    13%      00901
70    13%      31143
71   #DIV/0!   31143
        J        K
72   #DIV/0!   00953
73   #DIV/0!   00953
74   #DIV/0!   00954
75   #DIV/0!   00512
76   #DIV/0!   00740
77   #DIV/0!   00523
78   #DIV/0!   00740
79   #DIV/0!   00523
        J        K
80   #DIV/0!   00751
81   #DIV/0!   00655
82   #DIV/0!   00834
83   #DIV/0!   31144
84   #DIV/0!   00805
85   #DIV/0!   00805
86   #DIV/0!   00521
87   #DIV/0!   00803
        J        K
88   #DIV/0!   00803
89   #DIV/0!   00803
90   #DIV/0!   14330
91   #DIV/0!   00801
92   #DIV/0!   05535
93   #DIV/0!   00820
94   #DIV/0!   00883
95   #DIV/0!   00522
         J        K
96    #DIV/0!   00835
97    #DIV/0!   00835
98    #DIV/0!   00865
99    #DIV/0!   00865
100   #DIV/0!   00973
101   #DIV/0!   00870
102   #DIV/0!   00880
103   #DIV/0!   00820
         J        K
104   #DIV/0!   05440
105   #DIV/0!   00900
106   #DIV/0!   00900
107   #DIV/0!   00900
108   #DIV/0!   00900
109   #DIV/0!   00900
110   #DIV/0!   00900
111   #DIV/0!   00900
         J        K
112   #DIV/0!   00900
113   #DIV/0!   00910
114   #DIV/0!   31145
115   #DIV/0!   00973
116   #DIV/0!   00904
117   #DIV/0!   00836
118   #DIV/0!   00836
119   #DIV/0!   00884
                J         K
       120   #DIV/0!    00951
       121   #DIV/0!    00825
       122   #DIV/0!
       123             * Payment locality
ELP YOU GET THE RVUs YOU WANT INTO T
        124
       125
       126 FACILITY
       127 NA       MP
                 J             K
          128 INDICATOR VU R
          129
          130
          131
          132
fter you make another copy.
          133
          134                      0.03
          135                      0.03
      J   K
136           0.05
137           0.04
138           0.30
139           0.06
140           0.16
141           0.06
142           0.04
143           0.08
         J   K
144              0.05
145              0.02
146              0.03
147              0.01
148              0.02
149              0.01
150 NA           0.02
151 NA           0.02
         J   K
152 NA           0.02
153              0.02
154 NA           0.04
155 NA           0.02
156 NA           0.02
157 NA           0.03
158              0.02
159              0.05
      J   K
160           0.08
161           0.10
162           0.12
163           0.01
164           0.02
165           0.03
166           0.04
167           0.07
      J   K
168           0.04
169           0.01
170           0.41
                           L

          1
          2
Billing Overhead Calculator (What does your bil
          3
          many ways to calculate overhead. If you
There are 4
 have filled in sample data. Enter your number, fro
          5
          6 Fill in values in pink and blue.
Practice Gross Income
          7
                          L
Cost of Goods Sold
           8
Rent or mortgage
           9
Total Square Footage
          10
Square Footage related to billing
          11
Employee expense related to billing
          12
Office expense related to billing
          13
Phone expense related to billing
          14
Total utilities
          15
                           L
Hours you spend on billing matters
         16
Hourly salary for your billing work
         17
Other billing expenses
         18
Other billing expenses
         19
         20
Calculated Overhead
         21
Calculated Billing as a % of overhead
         22
         value in yellow, or your own value:
Enter the23
              L
24
25
26
27
28
29 Locality
30            00
31            01
     L
32   00
33   13
34   26
35   18
36   03
37   07
38   05
39   06
     L
40   09
41   17
42   99
43   99
44   01
45   00
46   01
47   01
     L
48   03
49   04
50   99
51   01
52   99
53   01
54   00
55   16
     L
56   12
57   15
58   99
59   00
60   00
61   00
62   04
63   00
     L
64   01
65   99
66   03
67   99
68   01
69   99
70   01
71   99
     L
72   01
73   99
74   00
75   00
76   02
77   01
78   99
79   99
     L
80   01
81   00
82   00
83   40
84   01
85   99
86   05
87   01
     L
88   02
89   03
90   04
91   99
92   00
93   01
94   00
95   00
      L
96    01
97    99
98    01
99    99
100   20
101   01
102   01
103   02
      L
104   35
105   31
106   20
107   09
108   11
109   28
110   15
111   18
      L
112   99
113   09
114   50
115   50
116   00
117   02
118   99
119   16
                        L
       120              00
       121              21
       122
*   Payment
       123    locality is serviced by two carr
YOU WANT INTO THE CALCULATOR.
     124
     125 FULLY
     126 IMPLEMENTED
     127 NON-FACILITY
            L
128 TOTAL
129
130
131
132
133
134             1.36
135             1.64
      L
136        4.26
137        1.75
138       14.71
139       10.79
140       17.63
141        4.42
142        1.83
143        4.38
      L
144       2.86
145       1.84
146       3.36
147       1.67
148       2.49
149       1.90
150       1.27
151       1.52
      L
152       1.89
153       1.67
154       2.74
155       1.05
156       1.07
157       3.55
158       0.95
159       1.70
      L
160       2.52
161       3.59
162       4.58
163       0.56
164       0.99
165       1.39
166       2.17
167       3.18
      L
168        2.07
169        1.30
170       18.29
                           M

      1
      2
 at does your billing department cost you as a perc
      3
 verhead. If you do not like this method, you are fr
      4
your number, from the yellow box or your own cal
      5
nd blue.
      6
      7                                100000
     M
 8       30000
 9        7000
10        1000
11         120
12       10000
13         250
14          30
15         800
     M
16            40
17            20
18             0
19             0
20       30000
21       40000
22       0.3004
23          0.33
                      M
24   You have to enter something in the
25   above blue box to calculate discount.
26
27
28
29   Locality Name
30    ALABAMA
31    ALASKA
                 M
32   ARIZONA
33   ARKANSAS
34   ANAHEIM/SANTA ANA, CA
35   LOS ANGELES, CA
36   MARIN/NAPA/SOLANO, CA
37   OAKLAND/BERKELEY, CA
38   SAN FRANCISCO, CA
39   SAN MATEO, CA
                  M
40   SANTA CLARA, CA
41   VENTURA, CA
42   REST OF CALIFORNIA*
43   REST OF CALIFORNIA*
44   COLORADO
45   CONNECTICUT
46   DELAWARE
47   DC + MD/VA SUBURBS
                  M
48   FORT LAUDERDALE, FL
49   MIAMI, FL
50   REST OF FLORIDA
51   ATLANTA, GA
52   REST OF GEORGIA
53   HAWAII/GUAM
54   IDAHO
55   CHICAGO, IL
                   M
56   EAST ST. LOUIS, IL
57   SUBURBAN CHICAGO, IL
58   REST OF ILLINOIS
59   INDIANA
60   IOWA
61   KANSAS*
62   KANSAS*
63   KENTUCKY
                  M
64   NEW ORLEANS, LA
65   REST OF LOUISIANA
66   SOUTHERN MAINE
67   REST OF MAINE
68   BALTIMORE/SURR. CNTYS, MD
69   REST OF MARYLAND
70   METROPOLITAN BOSTON
71   REST OF MASSACHUSETTS
                 M
72   DETROIT, MI
73   REST OF MICHIGAN
74   MINNESOTA
75   MISSISSIPPI
76   METROPOLITAN KANSAS CITY, MO
77   METROPOLITAN ST. LOUIS, MO
78   REST OF MISSOURI*
79   REST OF MISSOURI*
                 M
80   MONTANA
81   NEBRASKA
82   NEVADA
83   NEW HAMPSHIRE
84   NORTHERN NJ
85   REST OF NEW JERSEY
86   NEW MEXICO
87   MANHATTAN, NY
                  M
88   NYC SUBURBS/LONG I., NY
89   POUGHKPSIE/N NYC SUBURBS, NY
90   QUEENS, NY
91   REST OF NEW YORK
92   NORTH CAROLINA
93   NORTH DAKOTA
94   OHIO
95   OKLAHOMA
                  M
96    PORTLAND, OR
97    REST OF OREGON
98    METROPOLITAN PHILADELPHIA, PA
99    REST OF PENNSYLVANIA
100   PUERTO RICO
101   RHODE ISLAND
102   SOUTH CAROLINA
103   SOUTH DAKOTA
                  M
104   TENNESSEE
105   AUSTIN, TX
106   BEAUMONT, TX
107   BRAZORIA, TX
108   DALLAS, TX
109   FORT WORTH, TX
110   GALVESTON, TX
111   HOUSTON, TX
                    M
112   REST OF TEXAS
113   UTAH
114   VERMONT
115   VIRGIN ISLANDS
116   VIRGINIA
117   SEATTLE (KING CNTY), WA
118   REST OF WASHINGTON
119   WEST VIRGINIA
                        M
      120 WISCONSIN
      121 WYOMING
      122
ed   by two carriers.
      123
LATOR.
   124
   125 FULLY
   126 IMPLEMENTED
   127 FACILITY
            M
128 TOTAL
129
130
131
132
133
134             0.93
135             1.17
      M
136        0.94
137        1.25
138       14.71
139        1.90
140        6.82
141        2.37
142        1.54
143        2.86
      M
144       2.23
145       1.25
146       2.40
147       0.98
148       1.60
149       0.54
150       1.27
151       1.52
      M
152       1.89
153       1.32
154       2.74
155       1.05
156       1.07
157       3.55
158       0.63
159       1.25
      M
160       1.91
161       2.82
162       3.74
163       0.24
164       0.63
165       0.94
166       1.54
167       2.48
      M
168        1.31
169        0.54
170       18.29
                 N            O

            1
            2
            a
cost you as 3 percentage of your overhead?)
method, you are free to use your own numbers.
            4
x or your own calculations, into the blue box.
            5
            6      FOR A DETAILED LOOK AT
            7     Christopher J. Feahr's site:
          N              O
 8        http://Optiserv.com/
 9       and click on Free Tool... for a co
10
11   (If 50% of an area's time is spent on
12   (Salary & benefits of all billing activ
13   (postage, paper, printing, copies, etc
14
15   (water, gas, electricity, sewer, trash,
          N              O
16   (strictly billing issues, not all insuran
17   (What you would pay someone to do
18   (anything else you consider related t
19
20   (enter the value)
21
22   This is how much of your overhead
23   Enter as a decimal less than one: 15%
       N           O
24
25
26
27 >>>>>>>>>>>2003 Values<<<<<<
28 You need these three numbers from
29 Work GPCI Practice GPCI
30      0.978          0.870
31      1.064          1.172
     N        O
32    0.994       0.978
33    0.953       0.847
34    1.037       1.184
35    1.056       1.139
36    1.015       1.248
37    1.041       1.235
38    1.068       1.458
39    1.048       1.432
     N        O
40    1.063       1.380
41    1.028       1.125
42    1.007       1.034
43    1.007       1.034
44    0.985       0.992
45    1.050       1.156
46    1.019       1.035
47    1.050       1.166
     N        O
48    0.996       1.018
49    1.015       1.052
50    0.975       0.946
51    1.006       1.059
52    0.970       0.892
53    0.997       1.124
54    0.960       0.881
55    1.028       1.092
     N        O
56    0.988       0.924
57    1.006       1.071
58    0.964       0.889
59    0.981       0.922
60    0.959       0.876
61    0.963       0.895
62    0.963       0.895
63    0.970       0.866
     N        O
64    0.998       0.945
65    0.968       0.870
66    0.979       0.999
67    0.961       0.910
68    1.021       1.038
69    0.984       0.972
70    1.041       1.239
71    1.010       1.129
     N        O
72    1.043       1.038
73    0.997       0.938
74    0.990       0.974
75    0.957       0.837
76    0.988       0.967
77    0.994       0.938
78    0.946       0.825
79    0.946       0.825
     N        O
80    0.950       0.876
81    0.948       0.877
82    1.005       1.039
83    0.986       1.030
84    1.058       1.193
85    1.029       1.110
86    0.973       0.900
87    1.094       1.351
     N        O
88    1.068       1.251
89    1.011       1.075
90    1.058       1.228
91    0.998       0.944
92    0.970       0.931
93    0.950       0.880
94    0.988       0.944
95    0.968       0.876
      N        O
96     0.996       1.049
97     0.961       0.933
98     1.023       1.092
99     0.989       0.929
100    0.881       0.712
101    1.017       1.065
102    0.974       0.904
103    0.935       0.878
      N        O
104    0.975       0.900
105    0.986       0.996
106    0.992       0.890
107    0.992       0.978
108    1.010       1.065
109    0.987       0.981
110    0.988       0.969
111    1.020       1.007
      N        O
112    0.966       0.880
113    0.976       0.941
114    0.973       0.986
115    0.965       1.023
116    0.984       0.938
117    1.005       1.100
118    0.981       0.972
119    0.963       0.850
      N        O
120    0.981       0.929
121    0.967       0.895
122
123
124
125
126
127 PCTC       GLOB
          N         O
128 IND             DAYS
129
130
131
132
133
134 0         000
135 0         000
        N         O
136 0       000
137 0       000
138 0       090
139 0       010
140 0       010
141 0       010
142 0       010
143 0       010
        N         O
144 0       010
145 0       XXX
146 0       XXX
147 0       XXX
148 0       XXX
149 9       XXX
150 1       XXX
151 1       XXX
        N         O
152 1       XXX
153 0       XXX
154 1       XXX
155 1       XXX
156 1       XXX
157 1       XXX
158 0       XXX
159 0       XXX
        N         O
160 0       XXX
161 0       XXX
162 0       XXX
163 0       XXX
164 0       XXX
165 0       XXX
166 0       XXX
167 0       XXX
        N         O
168 0       000
169 0       XXX
170 0       090
              P          Q

         1
         2
ur overhead?)
         3
ur own numbers.
         4
to the blue box.
         5
TAILED6LOOK AT COST SAVINGS, SEE
 J. Feahr's site:
         7
                     P               Q
           8
n Free Tool... for a cost savings analysis program.
           9
          10
rea's time is spent on billing, then enter 50% of the
          11
fits of all billing activities)
          12
  printing, copies, etc.)
          13
          14
ctricity, sewer, trash, etc.)
          15
                      P              Q
 issues, not all insurance issues)
          16
 ld pay someone to do it.)
          17
you consider related to billing)
          18
         19
         20
         21
ch of your overhead is related to billing
         22
mal less than one: 15% = .15
         23
                  P               Q
        24
        25
        26
2003 Values<<<<<<<<<<<<<<<
        27
three numbers from your locale.
        28
        29 MalPractice GPCI
        30             0.807
        31             1.223
     P           Q
32       1.111
33       0.340
34       0.955
35       0.955
36       0.687
37       0.687
38       0.687
39       0.687
     P           Q
40       0.639
41       0.783
42       0.748
43       0.748
44       0.840
45       0.966
46       0.712
47       0.909
     P           Q
48       1.877
49       2.528
50       1.265
51       0.935
52       0.935
53       0.834
54       0.497
55       1.797
     P           Q
56       1.691
57       1.645
58       1.157
59       0.481
60       0.596
61       0.756
62       0.756
63       0.877
     P           Q
64       1.283
65       1.073
66       0.666
67       0.666
68       0.916
69       0.774
70       0.784
71       0.784
     P           Q
72       2.738
73       1.571
74       0.452
75       0.779
76       0.846
77       0.846
78       0.793
79       0.793
     P           Q
80       0.727
81       0.430
82       1.209
83       0.825
84       0.860
85       0.860
86       0.902
87       1.668
     P           Q
88       1.952
89       1.275
90       1.871
91       0.764
92       0.595
93       0.657
94       0.957
95       0.444
      P           Q
96        0.436
97        0.436
98        1.413
99        0.774
100       0.275
101       0.883
102       0.279
103       0.406
      P           Q
104       0.592
105       0.859
106       1.338
107       1.338
108       0.931
109       0.931
110       1.338
111       1.336
      P           Q
112       0.956
113       0.644
114       0.539
115       1.002
116       0.500
117       0.788
118       0.788
119       1.378
          P              Q
120           0.939
121           1.005
122
123
124
125
126
127 PRE               INTRA
         P               Q
128 OP              OP
129
130
131
132
133
134          0.00            0.00
135          0.00            0.00
      P          Q
136       0.00       0.00
137       0.00       0.00
138       0.10       0.70
139       0.10       0.80
140       0.10       0.80
141       0.10       0.80
142       0.10       0.80
143       0.10       0.80
      P          Q
144       0.10       0.80
145       0.00       0.00
146       0.00       0.00
147       0.00       0.00
148       0.00       0.00
149       0.00       0.00
150       0.00       0.00
151       0.00       0.00
      P          Q
152       0.00       0.00
153       0.00       0.00
154       0.00       0.00
155       0.00       0.00
156       0.00       0.00
157       0.00       0.00
158       0.00       0.00
159       0.00       0.00
      P          Q
160       0.00       0.00
161       0.00       0.00
162       0.00       0.00
163       0.00       0.00
164       0.00       0.00
165       0.00       0.00
166       0.00       0.00
167       0.00       0.00
      P          Q
168       0.00       0.00
169       0.00       0.00
170       0.10       0.70
               R   S

         1
         2
         3
         4
         5
SAVINGS, SEE
         6
         7
                   R          S
            8
            program.
gs analysis 9
           10
then enter 50% of the area)
           11
           12
           13
           14
           15
     R   S
16
17
18
19
20
21
22
23
     R   S
24
25
26
27
28
29
30
31
     R   S
32
33
34
35
36
37
38
39
     R   S
40
41
42
43
44
45
46
47
     R   S
48
49
50
51
52
53
54
55
     R   S
56
57
58
59
60
61
62
63
     R   S
64
65
66
67
68
69
70
71
     R   S
72
73
74
75
76
77
78
79
     R   S
80
81
82
83
84
85
86
87
     R   S
88
89
90
91
92
93
94
95
      R   S
96
97
98
99
100
101
102
103
      R   S
104
105
106
107
108
109
110
111
      R   S
112
113
114
115
116
117
118
119
       R     S
120
121
122
123
124
125
126
127 POST   MULT
         R            S
128 OP           PROC
129
130
131
132
133
134          0.00 2
135          0.00 2
      R            S
136       0.00 2
137       0.00 2
138       0.20 2
139       0.10 2
140       0.10 2
141       0.10 2
142       0.10 2
143       0.10 2
      R            S
144       0.10 2
145       0.00 0
146       0.00 0
147       0.00 0
148       0.00 0
149       0.00 9
150       0.00 0
151       0.00 0
      R            S
152       0.00 0
153       0.00 0
154       0.00 0
155       0.00 0
156       0.00 0
157       0.00 0
158       0.00 0
159       0.00 0
      R            S
160       0.00 0
161       0.00 0
162       0.00 0
163       0.00 0
164       0.00 0
165       0.00 0
166       0.00 0
167       0.00 0
      R            S
168       0.00 2
169       0.00 0
170       0.20 2
    T   U

1
2
3
4
5
6
7
     T   U
 8
 9
10
11
12
13
14
15
     T   U
16
17
18
19
20
21
22
23
     T   U
24
25
26
27
28
29
30
31
     T   U
32
33
34
35
36
37
38
39
     T   U
40
41
42
43
44
45
46
47
     T   U
48
49
50
51
52
53
54
55
     T   U
56
57
58
59
60
61
62
63
     T   U
64
65
66
67
68
69
70
71
     T   U
72
73
74
75
76
77
78
79
     T   U
80
81
82
83
84
85
86
87
     T   U
88
89
90
91
92
93
94
95
      T   U
96
97
98
99
100
101
102
103
      T   U
104
105
106
107
108
109
110
111
      T   U
112
113
114
115
116
117
118
119
       T       U
120
121
122
123
124
125
126
127 BILAT   ASST
      T        U
128 SURG   SURG
129
130
131
132
133
134 1      1
135 1      1
        T       U
136 1       1
137 1       1
138 1       0
139 0       1
140 0       1
141 1       0
142 1       1
143 1       1
        T       U
144 0       1
145 2       0
146 2       0
147 2       0
148 2       0
149 9       9
150 2       0
151 2       0
        T       U
152 2       0
153 2       0
154 2       0
155 2       0
156 2       0
157 2       0
158 0       0
159 0       0
        T       U
160 0       0
161 0       0
162 0       0
163 0       0
164 0       0
165 0       0
166 0       0
167 0       0
        T       U
168 0       1
169 2       0
170 1       1
    V   W

1
2
3
4
5
6
7
     V   W
 8
 9
10
11
12
13
14
15
     V   W
16
17
18
19
20
21
22
23
     V   W
24
25
26
27
28
29
30
31
     V   W
32
33
34
35
36
37
38
39
     V   W
40
41
42
43
44
45
46
47
     V   W
48
49
50
51
52
53
54
55
     V   W
56
57
58
59
60
61
62
63
     V   W
64
65
66
67
68
69
70
71
     V   W
72
73
74
75
76
77
78
79
     V   W
80
81
82
83
84
85
86
87
     V   W
88
89
90
91
92
93
94
95
      V   W
96
97
98
99
100
101
102
103
      V   W
104
105
106
107
108
109
110
111
      V   W
112
113
114
115
116
117
118
119
          V     W
120
121
122
123
124
125
126
127 CO-       TEAM
      V        W
128 SURG   SURG
129
130
131
132
133
134 0      0
135 0      0
        V       W
136 0       0
137 0       0
138 0       0
139 0       0
140 0       0
141 0       0
142 0       0
143 0       0
        V       W
144 0       0
145 0       0
146 0       0
147 0       0
148 0       0
149 9       9
150 0       0
151 0       0
        V       W
152 0       0
153 0       0
154 0       0
155 0       0
156 0       0
157 0       0
158 0       0
159 0       0
        V       W
160 0       0
161 0       0
162 0       0
163 0       0
164 0       0
165 0       0
166 0       0
167 0       0
        V       W
168 0       0
169 0       0
170 0       0
    X   Y

1
2
3
4
5
6
7
     X   Y
 8
 9
10
11
12
13
14
15
     X   Y
16
17
18
19
20
21
22
23
     X   Y
24
25
26
27
28
29
30
31
     X   Y
32
33
34
35
36
37
38
39
     X   Y
40
41
42
43
44
45
46
47
     X   Y
48
49
50
51
52
53
54
55
     X   Y
56
57
58
59
60
61
62
63
     X   Y
64
65
66
67
68
69
70
71
     X   Y
72
73
74
75
76
77
78
79
     X   Y
80
81
82
83
84
85
86
87
     X   Y
88
89
90
91
92
93
94
95
      X   Y
96
97
98
99
100
101
102
103
      X   Y
104
105
106
107
108
109
110
111
      X   Y
112
113
114
115
116
117
118
119
      X       Y
120
121
122
123
124
125              PHYSICIA
126          SUPERVISION O
127 ENDO   CONV
       X      Y
128 BASE   FACTOR
129
130
131
132
133
134          36.7856
135          36.7856
      X    Y
136       36.7856
137       36.7856
138       36.7856
139       36.7856
140       36.7856
141       36.7856
142       36.7856
143       36.7856
      X    Y
144       36.7856
145       36.7856
146       36.7856
147       36.7856
148       36.7856
149       36.7856
150       36.7856
151       36.7856
      X    Y
152       36.7856
153       36.7856
154       36.7856
155       36.7856
156       36.7856
157       36.7856
158       36.7856
159       36.7856
      X    Y
160       36.7856
161       36.7856
162       36.7856
163       36.7856
164       36.7856
165       36.7856
166       36.7856
167       36.7856
      X    Y
168       36.7856
169       36.7856
170       36.7856
    Z

1
2
3
4
5
6
7
     Z
 8
 9
10
11
12
13
14
15
     Z
16
17
18
19
20
21
22
23
     Z
24
25
26
27
28
29
30
31
     Z
32
33
34
35
36
37
38
39
     Z
40
41
42
43
44
45
46
47
     Z
48
49
50
51
52
53
54
55
     Z
56
57
58
59
60
61
62
63
     Z
64
65
66
67
68
69
70
71
     Z
72
73
74
75
76
77
78
79
     Z
80
81
82
83
84
85
86
87
     Z
88
89
90
91
92
93
94
95
      Z
96
97
98
99
100
101
102
103
      Z
104
105
106
107
108
109
110
111
      Z
112
113
114
115
116
117
118
119
         Z
  120
  121
  122
  123
   124
     PHYSICIAN
   125
SUPERVISION OF
   126
   DIAGNOSTIC
   127
         Z
PROCEDURES
128
129
130
131
132
133
134 09
135 09
         Z
136 09
137 09
138 09
139 09
140 09
141 09
142 09
143 09
         Z
144 09
145 09
146 09
147 09
148 09
149 09
150 09
151 09
         Z
152 09
153 09
154 09
155 09
156 01
157 01
158 09
159 09
         Z
160 09
161 09
162 09
163 09
164 09
165 09
166 09
167 09
         Z
168 09
169 09
170 09

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:4
posted:11/15/2010
language:English
pages:330
Description: Mortgage Calculator Alabama document sample