|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accounts Receivable Days Summary |
|
|
Insurance |
10/31/05 |
11/30/05 |
12/31/05 |
01/31/06 |
02/28/06 |
03/31/06 |
04/30/06 |
05/31/06 |
06/30/06 |
07/31/06 |
08/30/06 |
09/30/06 |
Goal |
|
|
Medicare |
|
116.74 |
92.56 |
|
|
|
|
|
|
|
|
|
|
90.00 |
|
|
MIP |
|
257.88 |
544.40 |
|
|
|
|
|
|
|
|
|
|
90.00 |
|
|
Medicaid |
|
458.36 |
731.50 |
|
|
|
|
|
|
|
|
|
|
90.00 |
|
|
Staywell |
|
85.90 |
70.90 |
|
|
|
|
|
|
|
|
|
|
90.00 |
|
|
Pacificare |
|
70.90 |
77.35 |
|
|
|
|
|
|
|
|
|
|
90.00 |
|
|
Select care |
|
86.31 |
49.38 |
|
|
|
|
|
|
|
|
|
|
90.00 |
|
|
Net care |
|
68.98 |
65.83 |
|
|
|
|
|
|
|
|
|
|
90.00 |
|
|
|
|
|
|
Other
Financial Ratios |
|
|
|
|
10/31/05 |
11/30/05 |
12/31/05 |
01/31/06 |
02/28/06 |
03/31/06 |
04/30/06 |
05/31/06 |
06/30/06 |
07/31/06 |
08/30/06 |
09/30/06 |
Goal |
|
|
Current Ratio |
|
1.21 |
1.18 |
|
|
|
|
|
|
|
|
|
|
1.00 |
|
|
Cash To Debt |
|
1.66 |
1.56 |
|
|
|
|
|
|
|
|
|
|
1.12 |
|
|
Average Payment Period |
|
94.71 |
86.74 |
|
|
|
|
|
|
|
|
|
|
90.00 |
|
|
|
|
|
FY 2005
CASH FLOW |
|
|
|
|
Oct-05 |
Nov-05 |
Dec-05 |
Jan-06 |
Feb-06 |
Mar-06 |
Apr-06 |
May-06 |
Jun-06 |
Jul-06 |
Aug-06 |
Sep-06 |
Total |
|
|
Beginning Cash Balance |
1,157,962 |
882,185 |
634,163 |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
|
|
|
Cash Receipts |
|
|
|
|
|
Patient Revenues |
4,149,628 |
4,112,837 |
5,347,575 |
|
|
13,610,040 |
|
|
|
|
|
Other Receipts |
57,757 |
42,547 |
74,252 |
|
|
174,556 |
|
|
|
|
|
Insurance Settlement |
|
|
- |
|
|
|
|
|
Compact Impact Fund |
86,549 |
592,040 |
200,489 |
|
|
879,078 |
|
|
|
|
|
FEMA Reimbursement |
|
|
- |
|
|
|
|
|
Health Securities Trust Fund |
|
183,130 |
|
|
183,130 |
|
|
|
|
|
Healthy Futures Funds |
|
|
- |
|
|
|
|
|
Bioterrorism Grant |
247,402 |
|
|
247,402 |
|
|
|
|
|
ANA Grant |
|
|
- |
|
|
|
|
|
Gov Guam GRT |
|
684,705 |
569,823 |
|
|
1,254,528 |
|
|
|
|
|
GTA Sale Proceeds |
|
|
- |
|
|
|
|
Total Cash Receipts |
4,541,336 |
5,432,129 |
6,375,269 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
16,348,734 |
|
|
|
|
|
|
|
|
|
|
Cash Disbursements |
|
|
|
|
|
|
Operational
Disbursements |
|
|
|
|
|
|
Salaries & Benefits |
3,644,333 |
4,340,561 |
5,322,935 |
|
13,307,829 |
|
|
|
|
Travel & Training |
41,008 |
10,274 |
31,375 |
|
82,657 |
|
|
|
|
Contractual Services |
548,934 |
500,108 |
319,363 |
|
1,368,405 |
|
|
|
|
Supplies & materials |
418,059 |
682,065 |
1,130,913 |
|
2,231,037 |
|
|
|
|
Miscellaneous |
22,774 |
9,724 |
8,720 |
|
41,218 |
|
|
|
|
Utilities - Power |
119,756 |
93,936 |
85,357 |
|
299,049 |
|
|
|
Water |
|
54,726 |
|
54,726 |
|
|
|
|
Telephone |
22,249 |
|
21,415 |
|
43,664 |
|
|
|
|
Boiler
Fuel |
|
29,934 |
|
29,934 |
|
|
|
|
Cost report |
|
- |
|
|
|
|
Capital Outlay |
|
75,029 |
|
75,029 |
|
|
|
|
Total Operational
Disbursements |
4,817,113 |
5,636,668 |
7,079,767 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
17,533,548 |
|
|
|
Other Cash Outlay |
|
|
|
|
|
|
Retirement Fund Note |
|
- |
|
|
|
|
GPA Note |
|
43,483 |
43,483 |
|
86,966 |
|
|
|
Total Other Cash Outlay |
- |
43,483 |
43,483 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
86,966 |
|
|
|
Total Cash Disbursements |
4,817,113 |
5,680,151 |
7,123,250 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
17,620,514 |
|
|
|
Ending Cash |
882,185 |
634,163 |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
|
|
|
|
882,185 |
634,163 |
(113,818) |
|
|
|
|
- |
- |
- |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
(113,818) |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
427,373 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|