|
Statement
Of Revenues & Expenditures (Unaudited) |
|
Cash Flow Statement |
|
|
|
|
|
|
|
|
|
|
07/31/07 |
|
07/31/08 |
|
Variance |
|
|
|
07/31/07 |
|
07/31/08 |
|
|
Revenues |
|
|
|
|
Beginning Cash Balance |
|
$498,202 |
|
$618,767 |
|
|
Gross Patient Revenues |
|
$98,285,434 |
|
$101,943,461 |
|
$3,658,027
|
|
|
|
|
|
|
|
|
Contractual Adjustments |
|
(18,721,278) |
|
(29,053,656) |
|
(10,332,378) |
|
Cash Receipts |
|
|
|
|
|
|
Bad Debts Expense |
|
(23,637,233) |
|
(7,849,931) |
|
15,787,302 |
|
Patient Revenues |
|
$54,072,100 |
|
56,914,056 |
|
|
Net Patient Revenues |
|
55,926,923 |
|
65,039,874 |
|
9,112,952 |
|
Other Receipts |
|
600,666 |
|
820,220 |
|
|
Other Revenues |
|
643,881 |
|
1,888,788 |
|
1,244,907 |
|
FEMA Assistance |
|
43,107 |
|
783,104 |
|
|
Total Revenues |
|
$56,570,804
|
|
$66,928,662
|
|
$10,357,859
|
|
Medicare Reimbursement |
|
9,275,565 |
|
396,963 |
|
|
|
|
|
|
|
|
Advance Appropriation |
|
1,225,029 |
|
- |
|
|
|
|
|
|
|
|
Bioterrorism |
|
549,463 |
|
628,406 |
|
|
Expenditures |
|
|
|
|
|
Compact Impact |
|
3,113,641 |
|
6,547,883 |
|
|
|
|
|
|
|
|
Subsidy General Fund
PL28-150 |
351,562 |
|
- |
|
|
Salaries & Benefits |
|
$45,314,994 |
|
$46,922,618 |
|
$1,607,624 |
|
FMIP Reimbursement |
|
222,174 |
|
- |
|
|
|
|
Travel |
|
98,250 |
|
148,889 |
|
50,639 |
|
GovGuam Reimbursement- GRT |
10,659,890 |
|
9,616,551 |
|
|
Training |
|
57,414 |
|
38,397 |
|
(19,017) |
|
Health Securities Trust Fund |
|
|
|
743,436 |
|
|
|
|
Contractual Services |
|
5,925,854 |
|
6,425,340 |
|
499,486 |
|
UPCA Settlement |
|
- |
|
92,345 |
|
|
Supplies & Materials |
|
9,577,162 |
|
10,731,490 |
|
1,154,328 |
|
GMHP Settlement |
|
- |
|
900,659 |
|
|
Minor Equipment |
|
381,603 |
|
353,725 |
|
(27,878) |
|
Total Cash Receipts |
|
$80,113,197
|
|
$77,443,623
|
|
|
Miscellaneous |
|
173,194 |
|
130,708 |
|
(42,486) |
|
|
|
|
|
|
|
|
|
|
Utilities |
|
1,961,170 |
|
2,237,164 |
|
275,994 |
|
Cash Disbursements |
|
|
|
|
|
|
Interest Expense |
|
1,081,480 |
|
837,319 |
|
(244,160) |
|
Salaries & Benefits |
|
49,476,199 |
|
51,260,299 |
|
|
Sick & Annual Leave Expense |
|
807,811 |
|
702,781 |
|
(105,030) |
|
Travel and Training |
|
107,121 |
|
159,476 |
|
|
Depreciation Expense |
|
3,366,958 |
|
3,387,960 |
|
21,001 |
|
Contractual Services |
|
5,904,680 |
|
4,174,151 |
|
|
Gain/Loss on Disposal of Assets |
|
- |
|
393 |
|
393 |
|
Supplies & Materials |
|
15,458,554 |
|
15,709,278 |
|
|
FMIP Expense |
|
58,073 |
|
- |
|
(58,073) |
|
Miscellaneous |
|
344,986 |
|
256,355 |
|
|
ANA Grant |
|
2,693 |
|
- |
|
(2,693) |
|
Utilities |
|
1,805,040 |
|
2,206,564 |
|
|
Bioterrorism Expenses |
|
80,372 |
|
307,495 |
|
227,123 |
|
Capital Outlay |
|
2,319,865 |
|
1,278,317 |
|
|
FEMA Projects |
|
99,252 |
|
973,452 |
|
874,200 |
|
Debt Service |
|
3,916,365 |
|
396,071 |
|
|
Compact Impact Expenses |
|
406,852 |
|
487,726 |
|
80,873 |
|
Total Cash Disbursements |
|
$79,332,810
|
|
$75,440,511
|
|
|
|
Advanced Appropriation |
|
1,023,602 |
|
- |
|
(1,023,602) |
|
Ending Cash balance |
|
$1,278,589 |
|
$2,621,880
|
|
|
|
Inventory Adjustment |
|
148,185 |
|
208,549 |
|
60,364 |
|
|
|
|
|
|
|
|
Total Expenditures |
|
$70,564,919
|
|
$73,894,005
|
|
$3,329,086
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Non-Operating Revenues |
|
|
|
|
|
|
Accounts Payable Aging |
|
|
FEMA Assistance |
|
474,732 |
|
769,530 |
|
294,798 |
|
07/31/08 |
|
|
GovGuam Reimbursement |
|
12,392,706 |
|
10,359,978 |
|
(2,032,728) |
|
|
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
Over 90 |
|
TOTAL |
|
|
Compact Impact Funds |
|
2,956,715 |
|
6,367,083 |
|
3,410,368 |
|
House Doctors |
|
$862 |
|
$8,770 |
|
$794,434 |
|
$804,066
|
|
|
Bioterrorism Grant |
|
277,483 |
|
356,246 |
|
78,763 |
|
Trade Payables |
|
1,412,556 |
|
1,566,176 |
|
715,604 |
1,294,148 |
|
4,988,484 |
|
|
FMIP |
|
58,073 |
|
- |
|
(58,073) |
|
Payroll Payables |
|
- |
|
|
|
- |
|
|
Contributions |
|
28,790 |
|
1,000 |
|
(27,790) |
|
- Gov Ret Fund DBP |
|
174,998 |
|
|
|
174,998 |
|
|
Total Non-Operating Revenues |
|
16,188,499 |
|
17,853,837 |
|
1,665,338 |
|
- Gov Ret Fund DCP |
|
- |
|
|
|
- |
|
|
Net Revenues Over/(Under) Expenditures |
|
$2,194,383 |
|
$10,888,494 |
|
8,694,111
|
|
- Dept of Rev &
Tax |
|
240,207 |
|
485,999 |
|
|
726,206 |
|
|
|
|
|
|
|
|
|
|
GTA |
|
48,731 |
|
|
- |
|
|
48,731 |
|
|
|
|
|
|
|
|
|
|
GPA |
|
238,611 |
|
161,016 |
|
|
399,626 |
|
|
|
|
|
|
|
|
GWA |
|
36,012 |
|
32,144 |
|
30,394 |
66 |
|
98,617 |
|
|
|
|
|
|
|
Total |
|
$2,151,977
|
|
$2,254,106
|
|
$745,998
|
$2,088,647
|
|
$7,240,728
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
NET Patient Accounts
Receivable (Balance Sheet) |
07/31/08 |
|
|
|
|
FY 2008 BUDGET SUMMARY |
|
|
Medicare |
|
2,455,091 |
|
|
|
|
07/31/08 |
|
|
Medicaid |
|
4,195,925 |
|
|
|
|
|
BUDGET |
BUDGET |
|
BUDGET |
|
MODIFIED |
EXPENDITURES |
|
REMAINING BAL |
|
|
MIP |
|
7,602,416 |
|
|
|
|
DIVISION |
FTEs |
AMOUNT |
|
MODIFICATION |
|
BUDGET |
Y-T-D 10-MONTHS |
|
2-MONTHS |
|
|
TakeCare |
|
1,315,005 |
|
|
|
|
Administration |
23 |
3,460,229
|
|
272,418 |
|
3,732,647
|
3,037,348
|
|
695,299 |
|
|
Staywell |
|
1,612,465 |
|
|
|
|
Admin Support |
145 |
12,452,961 |
|
34,938 |
|
12,487,899 |
9,884,598 |
|
2,603,301 |
|
|
Selectcare |
|
1,539,364 |
|
|
|
|
Fiscal Services |
107 |
6,401,326 |
|
86,276 |
|
6,471,326 |
5,123,575 |
|
1,347,751 |
|
|
Netcare |
|
350,734 |
|
|
|
|
Medical Services |
49.25 |
12,529,645 |
|
144,078 |
|
12,673,723 |
9,364,222 |
|
3,309,501 |
|
|
Self Pay |
|
15,925,095
|
|
|
|
|
Nursing Services |
460.29 |
28,389,662 |
|
1,016,389 |
|
29,406,051 |
25,836,078 |
|
3,569,973 |
|
|
Others |
|
938,771 |
|
|
|
|
Professional Support |
228 |
24,444,611 |
|
(1,554,099) |
|
22,906,788 |
18,043,912 |
|
4,862,876 |
|
|
NET Patient Accounts Receivable |
|
$35,934,866
|
|
|
|
|
T O T A L S |
1012.54 |
$87,678,434
|
|
$87,678,434
|
$71,289,733
|
|
$16,388,701 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
02/28/08 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|