|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accounts Receivable Days Summary |
|
|
Insurance |
10/31/04 |
11/30/04 |
12/31/04 |
01/31/05 |
02/28/05 |
03/31/05 |
04/30/05 |
05/31/05 |
06/30/05 |
07/31/05 |
08/31/05 |
09/30/05 |
Goal |
|
|
Medicare |
|
62.56 |
81.14 |
84.55 |
91.11 |
108.30 |
93.60 |
92.59 |
100.23 |
104.88 |
96.91 |
|
|
90.00 |
|
|
MIP |
370.21 |
364.22 |
252.95 |
215.15 |
254.98 |
261.18 |
266.30 |
239.39 |
232.60 |
238.19 |
|
|
90.00 |
|
|
Medicaid |
|
904.92 |
1,913.25 |
3,113.58 |
4,080.31 |
2,345.17 |
2,194.67 |
471.51 |
568.73 |
501.32 |
434.98 |
|
|
90.00 |
|
|
Staywell |
|
49.48 |
62.59 |
57.45 |
75.25 |
82.90 |
78.42 |
78.45 |
93.21 |
100.52 |
107.26 |
|
|
90.00 |
|
|
Pacificare |
|
66.68 |
58.56 |
62.18 |
82.69 |
66.65 |
66.72 |
66.37 |
80.82 |
81.00 |
81.73 |
|
|
90.00 |
|
|
Select care |
|
84.21 |
97.88 |
40.00 |
47.38 |
78.96 |
69.76 |
43.76 |
55.26 |
72.09 |
74.32 |
|
|
90.00 |
|
|
Net care |
|
95.11 |
112.55 |
65.60 |
73.38 |
82.50 |
84.35 |
95.19 |
63.11 |
75.08 |
65.81 |
|
|
90.00 |
|
|
|
|
|
Other
Financial Ratios |
|
|
|
|
10/31/04 |
11/30/04 |
12/31/04 |
01/31/05 |
02/28/05 |
03/31/05 |
04/30/05 |
05/31/05 |
06/30/05 |
07/31/05 |
08/31/05 |
09/30/05 |
Goal |
|
|
Current Ratio |
|
1.45 |
1.39 |
1.38 |
1.41 |
1.30 |
1.16 |
1.02 |
1.04 |
1.03 |
0.93 |
|
|
1.00 |
|
|
Cash To Debt |
|
1.80 |
0.28 |
0.48 |
0.69 |
0.81 |
0.90 |
1.21 |
1.21 |
1.35 |
1.61 |
|
|
1.12 |
|
|
Average Payment Period |
|
102.61 |
117.30 |
105.03 |
110.00 |
118.42 |
120.18 |
114.48 |
118.44 |
114.02 |
113.00 |
|
|
90.00 |
|
|
|
FY 2005
CASH FLOW |
|
|
|
|
Oct-04 |
Nov-04 |
Dec-04 |
Jan-05 |
Feb-05 |
Mar-05 |
Apr-05 |
May-05 |
Jun-05 |
Jul-05 |
Aug-05 |
Sep-05 |
Total |
|
|
Beginning Cash Balance |
637,556 |
1,492,036 |
449,861 |
152,856 |
416,841 |
92,016 |
(194,211) |
(202,352) |
412,276 |
298,350 |
|
|
|
|
Cash Receipts |
|
|
|
|
|
Patient Revenues |
4,796,917 |
3,381,581 |
5,454,580 |
4,747,288 |
3,812,888 |
4,138,300 |
5,660,782 |
4,841,594 |
4,103,496 |
5,654,310 |
|
46,591,736 |
|
|
|
Other Receipts |
142,005 |
49,607 |
75,296 |
49,788 |
40,555 |
40,228 |
57,016 |
58,636 |
169,294 |
79,079 |
|
761,504 |
|
|
|
Insurance Settlement |
|
730,844 |
|
730,844 |
|
|
|
Compact Impact Fund |
1,094,079 |
|
42,977 |
488,678 |
145,849 |
868,754 |
295,024 |
315,153 |
1,500,000 |
273,470 |
|
5,023,984 |
|
|
|
FEMA Reimbursement |
|
167,963 |
|
9,450 |
|
177,413 |
|
|
|
Healthy Futures Funds |
|
925,000 |
308,333 |
349,999 |
308,334 |
|
150,000 |
308,333 |
|
2,349,999 |
|
|
|
Bioterrorism Grant |
|
43,862 |
|
32,225 |
115,353 |
- |
|
80,997 |
|
68,028 |
|
340,465 |
|
|
|
ANA Grant |
|
5,564 |
4,000 |
|
2,798 |
|
12,362 |
|
|
Total Cash Receipts |
6,033,001 |
3,475,050 |
6,497,853 |
5,794,275 |
4,470,208 |
5,369,066 |
6,012,822 |
5,446,380 |
6,081,123 |
6,808,529 |
- |
- |
55,988,307 |
|
|
|
|
|
|
|
|
|
Cash Disbursements |
|
|
|
|
|
|
Operational Disbursements |
|
|
|
|
|
Salaries & Benefits |
2,907,050 |
2,977,383 |
4,442,908 |
3,215,081 |
3,120,205 |
2,709,535 |
4,111,665 |
3,422,470 |
3,528,159 |
4,913,833 |
|
35,348,289 |
|
|
|
Travel & Training |
50,513 |
19,861 |
19,425 |
17,334 |
3,401 |
12,911 |
1,350 |
5,265 |
1,725 |
9,355 |
|
141,140 |
|
|
|
Contractual Services |
815,407 |
479,447 |
825,704 |
636,718 |
446,091 |
779,215 |
796,688 |
288,511 |
609,454 |
581,227 |
|
6,258,462 |
|
|
|
Supplies & materials |
899,055 |
511,647 |
830,888 |
883,540 |
913,542 |
1,506,391 |
730,756 |
733,901 |
1,749,069 |
898,926 |
|
9,657,715 |
|
|
|
Miscellaneous |
22,783 |
26,854 |
34,090 |
8,710 |
12,424 |
19,620 |
13,532 |
9,035 |
54,422 |
7,254 |
|
208,724 |
1,649,155 |
|
|
Utilities - Power |
88,063 |
177,054 |
176,327 |
90,066 |
91,216 |
93,376 |
94,842 |
92,904 |
92,219 |
102,971 |
|
1,099,038 |
|
|
|
Water |
25,657 |
|
38,458 |
26,385 |
|
- |
|
133,530 |
28,844 |
22,139 |
|
275,013 |
|
|
|
Telephone |
21,375 |
|
26,273 |
22,384 |
25,130 |
25,291 |
25,409 |
24,697 |
24,156 |
18,045 |
|
212,760 |
|
|
|
Boiler Fuel |
|
14,192 |
|
14,567 |
|
15,071 |
18,514 |
|
62,344 |
|
|
|
Cost report |
|
205,532 |
|
205,532 |
|
|
|
Capital Outlay |
302,653 |
185,244 |
400,785 |
424,540 |
183,024 |
448,422 |
200,756 |
121,439 |
|
105,362 |
|
2,372,225 |
|
|
Total Operational
Disbursements |
5,132,556 |
4,391,682 |
6,794,858 |
5,530,290 |
4,795,033 |
5,609,328 |
5,974,998 |
4,831,752 |
6,103,119 |
6,677,626 |
- |
- |
55,841,242 |
|
|
Other Cash Outlay |
|
|
|
|
|
Retirement Fund Note |
- |
125,543 |
|
- |
|
125,543 |
|
|
|
GPA Note |
45,965 |
|
45,965 |
45,965 |
|
91,930 |
44,965 |
|
274,790 |
|
|
Total Other Cash Outlay |
45,965 |
125,543 |
- |
- |
- |
45,965 |
45,965 |
- |
91,930 |
44,965 |
- |
- |
400,333 |
|
|
Total Cash Disbursements |
5,178,521 |
4,517,225 |
6,794,858 |
5,530,290 |
4,795,033 |
5,655,293 |
6,020,963 |
4,831,752 |
6,195,049 |
6,722,591 |
- |
- |
56,241,575 |
|
|
Ending Cash |
1,492,036 |
449,861 |
152,856 |
416,841 |
92,016 |
(194,211) |
(202,352) |
412,276 |
298,350 |
384,288 |
- |
- |
|
|
|
1,492,036 |
449,861 |
152,856 |
416,841 |
92,016 |
(194,211) |
(202,352) |
412,276 |
298,350 |
384,288 |
|
|
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
1,649,155 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|