|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 2006
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) |
159,618 |
793,153 |
53,255 |
508,410 |
734,410 |
177,616 |
148,288 |
425,399 |
|
|
|
Cash Receipts |
|
|
|
|
|
Patient Revenues |
4,149,628 |
4,112,837 |
5,347,575 |
3,953,844 |
4,919,072 |
5,060,258 |
5,630,449 |
4,697,816 |
5,368,195 |
5,302,573 |
4,674,551 |
4,133,818 |
57,350,616 |
|
|
|
|
|
Other Receipts |
57,757 |
42,547 |
74,252 |
67,062 |
36,008 |
61,106 |
63,178 |
56,597 |
99,279 |
47,975 |
60,790 |
77,127 |
743,678 |
|
|
|
|
|
Medicare Reimbursement FY03 MCR |
|
|
1,457,016 |
1,457,016 |
|
|
|
|
|
Compact Impact Fund |
86,549 |
592,040 |
200,489 |
|
118,797 |
1,629,014 |
|
126,558 |
1,871,243 |
456,336 |
5,081,026 |
|
|
|
|
|
FEMA Reimbursement |
|
80,678 |
|
103,746 |
|
184,424 |
|
|
|
|
|
Health Securities Trust Fund |
|
183,130 |
|
|
283,130 |
466,260 |
|
|
|
|
|
Healthy Futures Funds |
|
|
- |
|
|
|
|
|
Bioterrorism Grant |
247,402 |
|
283,070 |
|
22,615 |
|
93,373 |
|
646,460 |
|
|
|
|
|
ANA Grant |
|
5,713 |
|
|
5,713 |
|
|
|
|
|
Gov Guam GRT |
|
684,705 |
569,823 |
651,525 |
1,244,136 |
179,870 |
680,835 |
528,539 |
668,228 |
716,353 |
1,221,941 |
1,275,566 |
8,421,521 |
|
|
|
|
|
GTA Sale Proceeds |
|
|
- |
|
|
|
|
Total Cash Receipts |
4,541,336 |
5,432,129 |
6,375,269 |
4,961,214 |
6,398,691 |
6,952,863 |
6,374,462 |
5,282,952 |
6,332,821 |
6,193,459 |
7,828,525 |
7,682,993 |
74,356,714 |
|
|
|
|
|
|
|
|
|
|
|
Cash Disbursements |
|
|
|
|
|
|
|
Operational Disbursements |
|
|
|
|
|
|
Salaries & Benefits |
3,644,333 |
4,340,561 |
5,322,935 |
3,575,260 |
3,559,911 |
4,515,049 |
3,535,210 |
3,631,863 |
5,001,601 |
3,701,668 |
4,240,865 |
4,697,485 |
49,766,741 |
|
|
|
|
Travel & Training |
41,008 |
10,274 |
31,375 |
- |
13,966 |
7,106 |
38,828 |
22,231 |
8,625 |
1,198 |
9,508 |
16,737 |
200,856 |
|
|
|
|
Contractual Services |
548,934 |
500,108 |
319,363 |
256,293 |
239,852 |
766,813 |
812,872 |
272,683 |
478,899 |
391,322 |
219,945 |
432,986 |
5,240,070 |
|
|
|
|
Supplies & materials |
418,059 |
682,065 |
1,130,913 |
414,485 |
1,236,765 |
2,183,720 |
1,340,915 |
852,974 |
962,436 |
1,851,415 |
1,002,976 |
2,117,369 |
14,194,092 |
|
|
|
|
Miscellaneous |
22,774 |
9,724 |
8,720 |
118,506 |
523,425 |
11,974 |
37,537 |
5,449 |
18,529 |
5,026 |
15,194 |
27,990 |
804,848 |
|
|
|
|
Utilities - Power |
119,756 |
93,936 |
85,357 |
95,859 |
99,257 |
106,403 |
|
115,560 |
276,871 |
129,635 |
123,472 |
247,086 |
1,493,192 |
|
|
|
Water |
|
54,726 |
- |
|
34,657 |
|
44,258 |
24,040 |
- |
|
157,681 |
|
|
|
|
Telephone |
22,249 |
|
21,415 |
23,434 |
25,138 |
23,556 |
45,781 |
|
23,142 |
23,300 |
24,729 |
23,907 |
256,651 |
|
|
|
|
Boiler
Fuel |
|
29,934 |
|
23,359 |
|
15,889 |
8,506 |
14,991 |
|
16,707 |
109,386 |
|
|
|
|
Capital Outlay |
|
75,029 |
160,458 |
- |
|
108,164 |
52,562 |
|
60,749 |
1,871,243 |
|
2,328,205 |
|
|
|
|
Total Operational
Disbursements |
4,817,113 |
5,636,668 |
7,079,767 |
4,644,295 |
5,721,673 |
7,649,278 |
5,919,307 |
5,013,469 |
6,802,649 |
6,179,304 |
7,507,932 |
7,580,267 |
74,551,722 |
|
|
|
Other Cash Outlay |
|
|
|
|
|
|
Retirement Fund Note |
|
- |
|
|
|
|
GPA Note |
|
43,483 |
43,483 |
43,483 |
43,483 |
43,483 |
|
43,483 |
86,966 |
43,483 |
43,483 |
43,483 |
478,313 |
|
|
|
Total Other Cash Outlay |
- |
43,483 |
43,483 |
43,483 |
43,483 |
43,483 |
- |
43,483 |
86,966 |
43,483 |
43,483 |
43,483 |
478,313 |
|
|
|
Total Cash Disbursements |
4,817,113 |
5,680,151 |
7,123,250 |
4,687,778 |
5,765,156 |
7,692,761 |
5,919,307 |
5,056,952 |
6,889,615 |
6,222,787 |
7,551,415 |
7,623,750 |
75,030,035 |
|
|
|
Ending Cash |
882,185 |
634,163 |
(113,818) |
159,618 |
793,153 |
53,255 |
508,410 |
734,410 |
177,616 |
148,288 |
425,398 |
484,642 |
|
|
|
|
882,185 |
634,163 |
(113,818) |
159,618 |
793,153 |
53,255 |
508,410 |
734,410 |
177,616 |
148,288 |
|
|
|
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
425,398 |
484,642 |
- |
|
|
|
|
|
|
77779069 |
|
|
|
76635533 |
|
|
|
1143536 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,016,910 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|