|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
|
|
|
Cash Receipts |
|
|
|
|
|
Patient Revenues |
4,149,628 |
4,112,837 |
|
|
8,262,465 |
|
|
|
|
|
Other Receipts |
57,757 |
42,547 |
|
|
100,304 |
|
|
|
|
|
Insurance Settlement |
|
|
- |
|
|
|
|
|
Compact Impact Fund |
86,549 |
592,040 |
|
|
678,589 |
|
|
|
|
|
FEMA Reimbursement |
|
|
- |
|
|
|
|
|
Healthy Futures Funds |
|
|
- |
|
|
|
|
|
Bioterrorism Grant |
247,402 |
|
|
247,402 |
|
|
|
|
|
ANA Grant |
|
|
- |
|
|
|
|
|
Gov Guam GRT |
|
684,705 |
|
|
684,705 |
|
|
|
|
|
GTA Sale Proceeds |
|
|
- |
|
|
|
|
Total Cash Receipts |
4,541,336 |
5,432,129 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
9,973,465 |
|
|
|
|
|
|
|
|
|
|
Cash Disbursements |
|
|
|
|
|
|
Operational
Disbursements |
|
|
|
|
|
|
Salaries & Benefits |
3,644,333 |
4,340,561 |
|
7,984,894 |
|
|
|
|
Travel & Training |
41,008 |
10,274 |
|
51,282 |
|
|
|
|
Contractual Services |
548,934 |
500,108 |
|
1,049,042 |
|
|
|
|
Supplies & materials |
418,059 |
682,065 |
|
1,100,124 |
|
|
|
|
Miscellaneous |
22,774 |
9,724 |
|
32,498 |
|
|
|
|
Utilities - Power |
119,756 |
93,936 |
|
213,692 |
|
|
|
Water |
|
- |
|
|
|
|
Telephone |
22,249 |
|
22,249 |
|
|
|
|
Boiler
Fuel |
|
- |
|
|
|
|
Cost report |
|
- |
|
|
|
|
Capital Outlay |
|
- |
|
|
|
|
Total Operational
Disbursements |
4,817,113 |
5,636,668 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
10,453,781 |
|
|
|
Other Cash Outlay |
|
|
|
|
|
|
Retirement Fund Note |
|
- |
|
|
|
|
GPA Note |
|
43,483 |
|
43,483 |
|
|
|
Total Other Cash Outlay |
- |
43,483 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
43,483 |
|
|
|
Total Cash Disbursements |
4,817,113 |
5,680,151 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
10,497,264 |
|
|
|
Ending Cash |
882,185 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
|
|
|
|
882,185 |
634,163 |
|
|
|
|
- |
- |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
634,163 |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
235,941 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|