| Balance Sheet (Unaudited) |
|
Statement Of Revenues & Expenditures (Unaudited) (Accrual) |
|
|
|
|
|
| |
|
03/31/06 |
|
03/31/07 |
|
Variance |
|
|
|
03/31/06 |
|
03/31/07 |
|
Variance |
|
| Assets |
|
|
|
|
Revenues |
|
|
|
|
| Cash & Cash Equivalents |
|
$48,706 |
|
$336,846 |
|
$288,140 |
|
Gross Patient Revenues |
|
$54,611,318 |
|
$59,443,568 |
|
$4,832,251 |
|
|
|
| Accounts Receivable (Net) |
|
29,131,179 |
|
24,476,785 |
|
(4,654,394) |
|
Contractual Adjustments |
|
(8,093,576) |
|
(8,810,813) |
|
(717,237) |
|
|
|
| Due From Gov Guam |
|
9,692,796 |
|
10,293,606 |
|
600,810 |
|
Bad Debts Expense |
|
(15,863,965) |
|
(16,828,566) |
|
(964,601) |
|
|
|
| Other Receivables |
|
886,388 |
|
681,336 |
|
(205,052) |
|
Net Patient Revenues |
|
30,653,777 |
|
33,804,189 |
|
3,150,413 |
|
|
|
| Inventories |
|
2,866,867 |
|
5,130,099 |
|
2,263,232 |
|
Other Revenues |
|
279,086 |
|
335,490 |
|
56,404 |
|
|
|
| Prepaid Expenses |
|
338,734 |
|
541,492 |
|
202,759 |
|
Total Revenues |
|
$30,932,863
|
|
$34,139,680
|
|
$3,206,817 |
|
|
| Property Plant and Equipment
(Net) |
|
39,281,346 |
|
40,807,741 |
|
1,526,395 |
|
|
|
|
|
|
|
| Total Assets |
|
$82,246,015
|
|
$82,267,906
|
|
$21,891
|
|
Expenditures |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
Salaries & Benefits |
|
$23,202,617 |
|
$25,663,951 |
|
$2,461,335 |
|
| Liabilities & Fund Balance |
|
|
|
|
|
|
|
Travel |
|
28,196 |
|
40,305 |
|
12,109 |
|
|
|
| Accounts Payable (Trade) |
|
$7,235,192 |
|
$8,677,505 |
|
$1,442,313 |
|
Training |
|
13,550 |
|
33,939 |
|
20,389 |
|
| Accounts Payable (Government) |
|
9,429,463 |
|
9,307,128 |
|
(122,334) |
|
Contractual Services |
|
3,380,193 |
|
3,109,743 |
|
(270,450) |
|
|
|
| Accrued Payroll & Benefits |
|
- |
|
- |
|
- |
|
Supplies & Materials |
|
5,351,176 |
|
5,533,763 |
|
182,587 |
|
|
|
| Accrued Annual Leave, S/L
(Current) |
|
2,333,593 |
|
2,574,463 |
|
240,870 |
|
Minor Equipment |
|
51,087 |
|
116,501 |
|
65,414 |
|
|
|
| Long-Term Debt (Current) |
|
6,652,213 |
|
6,624,855 |
|
(27,358) |
|
Miscellaneous |
|
611,573 |
|
510,082 |
|
(101,491) |
|
|
|
| Deferred Revenue |
|
10,361,796 |
|
8,976,104 |
|
(1,385,692) |
|
Utilities |
|
857,546 |
|
1,030,960 |
|
173,413 |
|
|
|
| Deferred retirement Fund
Contribution |
|
2,634,703 |
|
2,634,703 |
|
- |
|
Long Term Care Facility |
|
154,257 |
|
131,855 |
|
(22,402) |
|
|
|
| Accrued Annual Leave, S/L
(Non-Current) |
|
1,987,875 |
|
2,193,061 |
|
205,186 |
|
Interest Expense |
|
166,631 |
|
484,022 |
|
317,391 |
|
|
|
| Fund Balance |
|
41,611,181 |
|
41,280,087 |
|
(331,094) |
|
Sick & Annual Leave Expense |
|
605,412 |
|
612,351 |
|
6,939 |
|
|
|
| |
|
|
|
|
|
|
|
Depreciation Expense |
|
1,669,743 |
|
2,050,285 |
|
380,543 |
|
| Total Liabilities & Fund
Balance |
|
$82,246,015
|
|
$82,267,906
|
|
$21,891
|
|
Gain/Loss on Disposal of Assets |
|
|
|
- |
|
- |
|
|
0 |
|
0 |
|
0 |
|
Bioterrorism Expenses |
|
469,544 |
|
243,232 |
|
(226,312) |
|
|
|
|
FEMA Projects |
|
- |
|
383,395 |
|
383,395 |
|
|
|
| Cash Flow Statement |
|
Compact Impact Expenses |
|
399,835 |
|
90,374 |
|
(309,461) |
|
| |
|
03/31/06 |
|
03/31/07 |
|
Advanced Appropriation |
|
- |
|
383,212 |
|
383,212 |
|
| Beginning Cash Balance |
|
$1,157,962 |
|
$498,202 |
|
Inventory Adjustment |
|
43,550 |
|
100,677 |
|
57,127 |
|
| |
|
|
|
|
|
Total Expenditures |
|
$37,004,910
|
|
$40,518,648
|
|
$3,513,738
|
|
| Cash Receipts |
|
|
|
|
|
|
|
|
|
|
|
| Patient Revenues |
|
$27,543,213 |
|
$34,858,802
|
|
|
|
|
|
|
|
|
| Other Receipts |
|
338,732 |
|
382,306 |
|
|
|
|
|
|
|
|
|
|
| FEMA Assistance |
|
80,678 |
|
43,107 |
|
Non-Operating Revenues |
|
|
|
|
|
|
| Advanced Appropriations |
|
5,713 |
|
- |
|
FEMA Assistance |
|
- |
|
- |
|
- |
|
| Bioterrorism |
|
553,087 |
|
355,133 |
|
Transfers from GovGuam-GRT Funds |
|
4,096,863 |
|
4,337,995 |
|
241,132 |
|
| Compact Impact |
|
2,626,889 |
|
291,348 |
|
Compact Impact Funds |
|
1,948,300 |
|
40,395 |
|
(1,907,905) |
|
| Health Securities Trust Fund |
|
183,130 |
|
164,101 |
|
|
Bioterrorism Grant |
|
- |
|
57,678 |
|
57,678 |
|
|
| Gov Guam GRT |
|
3,330,059 |
|
4,279,921 |
|
ANA Grant |
|
6,240 |
|
- |
|
(6,240) |
|
|
| Medicare Reimbursement FY03
MCR |
|
|
|
4,522,765 |
|
Contributions |
|
25,877 |
|
28,790 |
|
2,913 |
|
| Total Cash Receipts |
|
$34,661,501
|
|
$44,897,483
|
|
Total Non-Operating Revenues |
|
$6,077,280
|
|
$4,464,858
|
|
($1,612,422) |
|
| |
|
|
|
|
|
Net Revenues Over/(Under) Expenditures |
|
$5,233 |
|
($1,914,110) |
|
($1,919,342) |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Disbursements |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Salaries & Benefits |
|
24,958,049 |
|
$30,623,382
|
|
|
|
|
|
|
| Travel and Training |
|
103,729 |
|
56,246 |
|
|
|
|
|
|
|
| Contractual Services |
|
2,631,363 |
|
2,990,405 |
|
|
|
|
|
|
|
| Supplies & Materials |
|
6,069,723 |
|
8,948,308 |
|
|
|
|
|
| Miscellaneous |
|
695,954 |
|
178,936 |
|
|
|
|
| Utilities |
|
859,037 |
|
1,087,836 |
|
|
|
|
|
|
| Capital Outlay |
|
235,487 |
|
956,312 |
|
|
|
|
| Retirement Funds Note |
|
- |
|
- |
|
|
|
|
| GPA Note |
|
217,415 |
|
217,415 |
|
|
|
|
| Total Cash Disbursements |
|
$35,770,757
|
|
$45,058,840
|
|
|
|
|
|
|
| Ending Cash balance |
|
$48,706 |
|
$336,846 |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
(0) |
|
0 |
|
13560 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
|
|
|
|
|
|
|
|
| Current Ratio |
|
1.550033342 |
|
1.316533153 |
|
|
|
|
|
2 |
|
|
|
|
| Cash to Debt |
|
2007 |
|
0 |
|
|
|
|
|
|
|
|
| Average Payment Period |
|
187,497.04 |
|
29,205.02 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
09/29/04 |
|
09/30/05 |
|
|
|
|
|
03/31/06 |
|
03/31/07 |
|
|
|
|
|
548.00 |
|
547.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|