|
Statement Of Revenues & Expenditures (Unaudited) |
|
Cash Flow Statement |
|
|
|
|
|
|
|
|
|
|
08/31/06 |
|
08/31/07 |
|
Variance |
|
|
|
08/31/06 |
|
08/31/07 |
|
|
Revenues |
|
|
|
|
Beginning Cash Balance |
|
$1,157,962 |
|
$498,202 |
|
|
Gross Patient Revenues |
|
$101,270,305 |
|
$109,481,871 |
|
$8,211,566
|
|
|
|
|
|
|
|
|
Contractual Adjustments |
|
(15,173,552) |
|
(22,299,011) |
|
(7,125,459) |
|
Cash Receipts |
|
|
|
|
|
|
Bad Debts Expense |
|
(29,544,227) |
|
(25,293,268) |
|
4,250,959 |
|
Patient Revenues |
|
$53,216,799 |
|
$58,385,229 |
|
|
Net Patient Revenues |
|
56,552,526 |
|
61,889,592 |
|
5,337,066 |
|
Other Receipts |
|
666,551 |
|
655,246 |
|
|
Other Revenues |
|
507,176 |
|
698,121 |
|
190,945 |
|
FEMA Assistance |
|
184,424 |
|
43,107 |
|
|
Total Revenues |
|
$57,059,701
|
|
$62,587,713
|
|
$5,528,012
|
|
Advanced Appropriations |
|
5,713 |
|
1,225,029 |
|
|
|
|
|
|
|
|
Bioterrorism |
|
646,460 |
|
587,566 |
|
|
Expenditures |
|
|
|
|
|
Compact Impact |
|
4,624,690 |
|
4,631,131 |
|
|
Salaries & Benefits |
|
$45,120,249 |
|
$49,625,131 |
|
$4,504,882 |
|
FMIP Reimbursement |
|
|
|
222,174 |
|
|
Travel |
|
108,747 |
|
104,089 |
|
(4,658) |
|
Subsidy- GRT (PL28-68) |
|
7,145,955 |
|
8,553,784 |
|
|
Training |
|
56,328 |
|
74,377 |
|
18,049 |
|
Subsidy- General Fund
(PL29-02) |
|
|
3,445,000 |
|
|
Contractual Services |
|
7,075,369 |
|
6,755,586 |
|
(319,783) |
|
Medicare Reimbursement |
|
|
|
9,140,791 |
|
|
Supplies & Materials |
|
10,688,086 |
|
10,642,358 |
|
(45,729) |
|
Health Securities Trust Fund |
|
183,130 |
|
|
|
|
Minor Equipment |
|
90,543 |
|
461,633 |
|
371,090 |
|
Total Cash Receipts |
|
$66,673,722
|
|
$86,889,057
|
|
|
Miscellaneous |
|
153,889 |
|
193,193 |
|
39,304 |
|
|
|
|
|
|
|
|
Utilities |
|
1,831,117 |
|
2,170,884 |
|
339,767 |
|
Cash Disbursements |
|
|
|
|
|
|
Interest Expense |
|
1,103,696 |
|
1,343,237 |
|
239,541 |
|
Salaries & Benefits |
|
45,069,257 |
|
54,715,865 |
|
|
Sick & Annual Leave Expense |
|
707,085 |
|
793,391 |
|
86,306 |
|
Travel and Training |
|
184,119 |
|
138,145 |
|
|
Depreciation Expense |
|
3,323,406 |
|
3,690,666 |
|
367,260 |
|
Contractual Services |
|
4,807,084 |
|
6,271,656 |
|
|
Gain/Loss on Disposal of Assets |
|
11,270 |
|
171,256 |
|
159,986 |
|
Supplies & Materials |
|
12,052,136 |
|
16,815,569 |
|
|
ANA Grant |
|
13,934 |
|
2,693 |
|
(11,241) |
|
Miscellaneous |
|
777,689 |
|
357,452 |
|
|
Bioterrorism Expenses |
|
507,973 |
|
86,333 |
|
(421,640) |
|
Utilities |
|
1,729,210 |
|
1,979,603 |
|
|
FEMA Projects |
|
131,437 |
|
99,252 |
|
(32,185) |
|
Capital Outlay |
|
2,328,205 |
|
2,319,865 |
|
|
FMIP Expense |
|
- |
|
58,073 |
|
58,073 |
|
Debt Service |
|
434,830 |
|
3,914,178 |
|
|
|
Compact Impact Expenses |
|
311,439 |
|
416,577 |
|
105,138 |
|
Total Cash Disbursements |
|
$67,382,530
|
|
$86,512,333
|
|
|
|
Advanced Appropriation |
|
91,185 |
|
1,187,917 |
|
1,096,732 |
|
Ending Cash balance |
|
$449,154 |
|
$874,927
|
|
|
Inventory Adjustment |
|
93,820 |
|
164,635 |
|
70,816 |
|
|
|
|
|
|
|
|
Total Expenditures |
|
$71,419,572
|
|
$78,041,279
|
|
$6,621,707
|
|
|
|
|
|
|
|
|
|
Accounts Receivable Aging |
|
Non-Operating Revenues |
|
|
|
|
|
|
08/31/07 |
|
FEMA Assistance |
|
144,553 |
|
474,732 |
|
330,179 |
|
|
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
Over 90 days |
|
TOTAL |
|
|
|
GovGuam Reimbursement |
|
10,584,478 |
|
13,380,039 |
|
2,795,561 |
|
Commercial |
|
$4,207,690 |
|
$1,836,644 |
|
$710,420 |
$4,641,144 |
|
$11,395,898
|
|
|
|
Compact Impact Funds |
|
2,203,841 |
|
4,474,205 |
|
2,270,363 |
|
GovGuam |
|
390,427 |
|
174,060 |
|
111,725 |
2,222,538 |
|
2,898,750 |
|
|
|
Bioterrorism Grant |
|
- |
|
277,483 |
|
277,483 |
|
MAP/Medicaid |
|
1,958,630 |
|
1,304,824 |
|
1,557,419 |
10,239,061 |
|
15,059,934 |
|
|
|
ANA Grant |
|
6,240 |
|
- |
|
(6,240) |
|
Medically Indigent
Program |
2,217,004 |
|
1,257,152 |
|
811,201 |
8,471,705 |
|
12,757,062 |
|
|
|
FMIP |
|
- |
|
58,073 |
|
58,073 |
|
Medicare |
|
3,149,572 |
|
282,410 |
|
170,789 |
3,362,696 |
|
6,965,467 |
|
|
|
Contributions |
|
79,080 |
|
28,790 |
|
(50,290) |
|
Self Pay |
|
3,716,751 |
|
1,450,432 |
|
1,590,133 |
34,577,995 |
|
41,335,311 |
|
|
|
Total Non-Operating Revenues |
|
$13,018,192
|
|
18,693,322 |
|
$5,675,130
|
|
Total |
|
$15,640,074
|
|
$6,305,522
|
|
$4,951,687
|
$63,515,139
|
|
$90,412,422
|
|
|
|
Net Revenues Over/(Under) Expenditures |
|
($1,341,679) |
|
$3,239,755 |
|
$4,581,434 |
|
|
|
|
|
|
|
|
|
|
|
|
Accounts Payable Aging |
|
|
|
|
|
|
|
08/31/07 |
|
|
|
|
|
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
Over 90 |
|
TOTAL |
|
|
|
|
|
|
House Doctors |
|
$3,152 |
|
$5,807 |
|
$28,417 |
$292,183 |
|
$329,559
|
|
|
|
|
|
|
|
|
Trade Payables |
|
931,842 |
|
1,684,323 |
|
933,827 |
997,169 |
|
4,547,161 |
|
|
|
|
|
|
Payroll Payables |
|
|
|
|
|
- |
|
|
|
|
|
|
|
|
- Gov Ret Fund DBP |
|
159,278 |
|
|
|
159,278 |
|
|
|
|
|
|
- Gov Ret Fund DCP |
|
|
|
|
|
- |
|
|
|
|
|
|
- Dept of Rev &
Tax |
|
|
|
|
|
- |
|
|
|
|
|
|
GTA |
|
|
|
|
|
- |
|
|
|
|
|
|
GPA |
|
148,114 |
|
|
|
148,114 |
|
|
|
|
|
|
GWA |
|
|
|
|
|
- |
|
|
|
|
|
|
Unbilled PO Receipts |
|
587,119 |
|
|
|
587,119 |
|
|
|
|
|
|
|
Total |
|
$1,829,506
|
|
$1,690,130
|
|
$962,244
|
$1,289,351
|
|
$5,771,231
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11 |
|
|
|
|
|
|
|
|
|
|
2007 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
08/31/07 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|