|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accounts Receivable Days Summary |
|
|
Insurance |
10/31/06 |
11/30/06 |
12/31/06 |
01/31/07 |
02/28/07 |
03/31/07 |
04/30/07 |
05/31/07 |
06/30/07 |
07/31/07 |
08/30/07 |
09/30/07 |
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/06 |
11/30/06 |
12/31/06 |
01/31/07 |
02/28/07 |
03/31/07 |
04/30/07 |
05/31/07 |
06/30/07 |
07/31/07 |
08/30/07 |
09/30/07 |
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 2006
CASH FLOW |
|
|
|
|
Oct-06 |
Nov-06 |
Dec-06 |
Jan-07 |
Feb-07 |
Mar-07 |
Apr-07 |
May-07 |
Jun-07 |
Jul-07 |
Aug-07 |
Sep-07 |
Total |
|
|
Beginning Cash Balance |
484,642 |
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
Cash Receipts |
|
|
|
|
|
Patient Revenues |
7,262,165 |
|
|
7,262,165 |
|
|
|
|
|
Other Receipts |
121,847 |
|
|
121,847 |
|
|
|
|
|
Medicare Reimbursement FY03 MCR |
4,921,530 |
|
|
4,921,530 |
|
|
|
|
|
Compact Impact Fund |
|
|
- |
|
|
|
|
|
FMIP Reimbursement |
164,101 |
|
|
164,101 |
|
|
|
|
|
Health Securities Trust Fund |
|
|
- |
|
|
|
|
|
Healthy Futures Funds |
|
|
- |
|
|
|
|
|
Bioterrorism Grant |
|
|
- |
|
|
|
|
|
ANA Grant |
|
|
- |
|
|
|
|
|
Gov Guam GRT |
|
|
- |
|
|
|
|
|
GTA Sale Proceeds |
|
|
- |
|
|
|
|
Total Cash Receipts |
12,469,643 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
12,469,643 |
|
|
|
|
|
|
|
|
|
|
|
Cash Disbursements |
|
|
|
|
|
|
|
Operational Disbursements |
|
|
|
|
|
|
Salaries & Benefits |
6,557,643 |
|
6,557,643 |
|
|
|
|
Travel & Training |
22,577 |
|
22,577 |
|
|
|
|
Contractual Services |
1,477,096 |
|
1,477,096 |
|
|
|
|
Supplies & materials |
2,830,755 |
|
2,830,755 |
|
|
|
|
Miscellaneous |
7,033 |
|
7,033 |
|
|
|
|
Utilities - Power |
131,420 |
|
131,420 |
|
|
|
Water |
34,836 |
|
34,836 |
|
|
|
|
Telephone |
52,162 |
|
52,162 |
|
|
|
|
Boiler
Fuel |
27,781 |
|
27,781 |
|
|
|
|
Capital Outlay |
23,886 |
|
23,886 |
|
|
|
|
Total Operational
Disbursements |
11,165,189 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
11,165,189 |
|
|
|
Other Cash Outlay |
|
|
|
|
|
|
Retirement Fund Note |
|
- |
|
|
|
|
GPA Note |
43,483 |
|
43,483 |
|
|
|
Total Other Cash Outlay |
43,483 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
43,483 |
|
|
|
Total Cash Disbursements |
11,208,672 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
11,208,672 |
|
|
|
Ending Cash |
1,745,613 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
1,745,613 |
|
|
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
246,199 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|