|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
498,202 |
1,745,613 |
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
Cash Receipts |
|
|
|
|
|
Patient Revenues |
7,262,166 |
4,408,183 |
|
|
11,670,349 |
|
|
|
|
|
Other Receipts |
121,847 |
43,877 |
|
|
165,724 |
|
|
|
|
|
Medicare Reimbursement FY03 MCR |
4,921,530 |
|
|
4,921,530 |
|
|
|
|
|
Compact Impact Fund |
|
61,194 |
|
|
61,194 |
|
|
|
|
|
FMIP Reimbursement |
164,101 |
|
|
164,101 |
|
|
|
|
|
Health Securities Trust Fund |
|
|
- |
|
|
|
|
|
Healthy Futures Funds |
|
|
- |
|
|
|
|
|
Bioterrorism Grant |
|
|
- |
|
|
|
|
|
ANA Grant |
|
|
- |
|
|
|
|
|
Gov Guam GRT |
|
1,107,171 |
|
|
1,107,171 |
|
|
|
|
|
GTA Sale Proceeds |
|
|
- |
|
|
|
|
Total Cash Receipts |
12,469,644 |
5,620,425 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
18,090,069 |
|
|
|
|
|
|
|
|
|
|
|
Cash Disbursements |
|
|
|
|
|
|
|
Operational Disbursements |
|
|
|
|
|
|
Salaries & Benefits |
6,557,643 |
4,081,436 |
|
10,639,079 |
|
|
|
|
Travel & Training |
22,577 |
8,775 |
|
31,352 |
|
|
|
|
Contractual Services |
1,477,096 |
143,639 |
|
1,620,735 |
|
|
|
|
Supplies & materials |
2,844,316 |
1,084,137 |
|
3,928,453 |
|
|
|
|
Miscellaneous |
7,033 |
78,438 |
|
85,471 |
|
|
|
|
Utilities - Power |
131,420 |
123,419 |
|
254,839 |
|
|
|
Water |
34,836 |
46,566 |
|
81,402 |
|
|
|
|
Telephone |
52,162 |
24,000 |
|
76,162 |
|
|
|
|
Boiler
Fuel |
27,781 |
26,757 |
|
54,538 |
|
|
|
|
Capital Outlay |
23,886 |
532,699 |
|
556,585 |
|
|
|
|
Total Operational
Disbursements |
11,178,750 |
6,149,866 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
17,328,616 |
|
|
|
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 |
11,222,233 |
6,193,349 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
17,415,582 |
|
|
|
Ending Cash |
1,745,613 |
1,172,689 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
1,745,613 |
1,172,689 |
|
|
|
|
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
466,941 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|