| Balance Sheet (Unaudited) |
|
Statement Of Revenues & Expenditures (Unaudited) (Accrual) |
|
|
|
|
|
| |
|
01/31/06 |
|
01/31/07 |
|
Variance |
|
|
|
01/31/06 |
|
01/31/07 |
|
Variance |
|
| Assets |
|
|
|
|
Revenues |
|
|
|
|
| Cash & Cash Equivalents |
|
$158,788 |
|
$106,242 |
|
($52,546) |
|
Gross Patient Revenues |
|
$36,932,403 |
|
$40,548,684 |
|
$3,616,280 |
|
|
|
| Accounts Receivable (Net) |
|
29,539,120 |
|
24,226,489 |
|
(5,312,631) |
|
Contractual Adjustments |
|
(5,342,512) |
|
(5,313,400) |
|
29,112 |
|
|
|
| Due From Gov Guam |
|
9,796,088 |
|
10,744,107 |
|
948,019 |
|
Bad Debts Expense |
|
(10,883,115) |
|
(12,553,270) |
|
(1,670,155) |
|
|
|
| Other Receivables |
|
854,621 |
|
697,122 |
|
(157,499) |
|
Net Patient Revenues |
|
20,706,776 |
|
22,682,014 |
|
1,975,237 |
|
|
|
| Inventories |
|
2,497,039 |
|
5,125,271 |
|
2,628,232 |
|
Other Revenues |
|
186,931 |
|
230,559 |
|
43,627 |
|
|
|
| Prepaid Expenses |
|
251,190 |
|
294,734 |
|
43,544 |
|
Total Revenues |
|
$20,893,708
|
|
$22,912,572 |
|
$2,018,865 |
|
|
| Property Plant and Equipment
(Net) |
|
39,768,265 |
|
40,858,388 |
|
1,090,124 |
|
|
|
|
|
|
|
| Total Assets |
|
$82,865,111
|
|
$82,052,353
|
|
($812,758) |
|
Expenditures |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
Salaries & Benefits |
|
$15,535,401 |
|
$16,968,546 |
|
$1,433,145 |
|
| Liabilities & Fund Balance |
|
|
|
|
|
|
|
Travel |
|
17,629 |
|
28,750 |
|
11,121 |
|
| Accounts Payable (Trade) |
|
$8,243,055
|
|
$7,827,528 |
|
($415,527) |
|
Training |
|
2,712 |
|
21,923 |
|
19,211 |
|
| Accounts Payable (Government) |
|
10,656,506 |
|
9,223,820 |
|
(1,432,686) |
|
Contractual Services |
|
2,171,141 |
|
1,963,905 |
|
(207,236) |
|
|
|
| Accrued Payroll & Benefits |
|
- |
|
- |
|
- |
|
Supplies & Materials |
|
3,574,173 |
|
3,491,655 |
|
(82,517) |
|
|
|
| Accrued Annual Leave, S/L
(Current) |
|
2,183,295 |
|
2,460,755 |
|
277,461 |
|
Minor Equipment |
|
27,631 |
|
58,318 |
|
30,687 |
|
|
|
| Long-Term Debt (Current) |
|
6,714,519 |
|
6,743,916 |
|
29,397 |
|
Miscellaneous |
|
798,111 |
|
340,422 |
|
(457,689) |
|
|
|
| Deferred Revenue |
|
10,363,766 |
|
8,995,679 |
|
(1,368,087) |
|
Utilities |
|
565,563 |
|
727,655 |
|
162,091 |
|
|
|
| Deferred retirement Fund
Contribution |
|
2,634,703 |
|
2,634,703 |
|
- |
|
Long Term Care Facility |
|
103,850 |
|
79,616 |
|
(24,234) |
|
|
|
| Accrued Annual Leave, S/L
(Non-Current) |
|
1,859,844 |
|
2,096,199 |
|
236,355 |
|
Interest Expense |
|
142,253 |
|
385,252 |
|
242,999 |
|
|
|
| Fund Balance |
|
40,209,423 |
|
42,069,753 |
|
1,860,330 |
|
Sick & Annual Leave Expense |
|
313,580 |
|
393,172 |
|
79,591 |
|
|
|
| |
|
|
|
|
|
|
|
Depreciation Expense |
|
1,102,665 |
|
1,365,801 |
|
263,136 |
|
| Total Liabilities & Fund
Balance |
|
$82,865,111
|
|
$82,052,353
|
|
($812,758) |
|
Gain/Loss on Disposal of Assets |
|
|
|
- |
|
- |
|
|
0 |
|
(0) |
|
(0) |
|
Bioterrorism Expenses |
|
442,020 |
|
119,622 |
|
(322,397) |
|
|
|
|
FEMA Projects |
|
- |
|
93,021 |
|
93,021 |
|
|
|
| Cash Flow Statement |
|
Compact Impact Expenses |
|
397,159 |
|
70,799 |
|
(326,360) |
|
| |
|
01/31/06 |
|
01/31/07 |
|
Advanced Appropriation |
|
- |
|
688,776 |
|
688,776 |
|
| Beginning Cash Balance |
|
$1,157,962 |
|
$498,202 |
|
Inventory Adjustment |
|
(39) |
|
43,285 |
|
43,324 |
|
| |
|
|
|
|
|
Total Expenditures |
|
$25,193,848
|
|
$26,840,518
|
|
$1,646,670
|
|
| Cash Receipts |
|
|
|
|
|
|
|
|
|
|
|
| Patient Revenues |
|
$17,563,883 |
|
$23,563,514
|
|
|
|
|
|
|
|
|
| Other Receipts |
|
241,618 |
|
269,054 |
|
|
|
|
|
|
|
|
|
|
| FEMA Assistance |
|
- |
|
43,107 |
|
Non-Operating Revenues |
|
|
|
|
|
|
| Advanced Appropriations |
|
5,713 |
|
- |
|
FEMA Assistance |
|
- |
|
- |
|
- |
|
| Bioterrorism |
|
530,472 |
|
57,678 |
|
Transfers from GovGuam-GRT Funds |
|
2,672,858 |
|
2,696,214 |
|
23,356 |
|
| Compact Impact |
|
879,078 |
|
80,229 |
|
Compact Impact Funds |
|
200,489 |
|
20,820 |
|
(179,669) |
|
| Health Securities Trust Fund |
|
183,130 |
|
164,101 |
|
|
Bioterrorism Grant |
|
- |
|
57,678 |
|
57,678 |
|
|
| Gov Guam GRT |
|
1,906,053 |
|
2,696,213 |
|
ANA Grant |
|
4,270 |
|
- |
|
(4,270) |
|
|
| Medicare Reimbursement FY03
MCR |
|
|
|
5,098,419 |
|
Contributions |
|
26,000 |
|
28,790 |
|
2,790 |
|
| Total Cash Receipts |
|
$21,309,947
|
|
$31,972,315
|
|
Total Non-Operating Revenues |
|
$2,903,616
|
|
$2,803,502
|
|
($100,114) |
|
| |
|
|
|
|
|
Net Revenues Over/(Under) Expenditures |
|
($1,396,525) |
|
($1,124,444) |
|
$272,081 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Disbursements |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Salaries & Benefits |
|
16,883,088 |
|
$21,443,695
|
|
|
|
|
|
|
| Travel and Training |
|
82,657 |
|
38,008 |
|
|
|
|
|
|
|
| Contractual Services |
|
1,624,698 |
|
2,495,578 |
|
|
|
|
|
|
|
| Supplies & Materials |
|
2,646,351 |
|
6,895,236 |
|
|
|
|
|
| Miscellaneous |
|
159,724 |
|
114,854 |
|
|
|
|
| Utilities |
|
546,667 |
|
689,871 |
|
|
|
|
|
|
| Capital Outlay |
|
235,487 |
|
556,585 |
|
|
|
|
| Retirement Funds Note |
|
- |
|
- |
|
|
|
|
| GPA Note |
|
130,449 |
|
130,449 |
|
|
|
|
| Total Cash Disbursements |
|
$22,309,121
|
|
$32,364,276
|
|
|
|
|
|
|
| Ending Cash balance |
|
$158,788 |
|
$106,242 |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
$0 |
|
$0 |
|
13560 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
|
|
|
|
|
|
|
|
| Current Ratio |
|
1.451526152 |
|
1.36250508 |
|
|
|
|
|
4 |
|
|
|
|
| Cash to Debt |
|
2007 |
|
0 |
|
|
|
|
|
|
|
|
| Average Payment Period |
|
58,202.67 |
|
78,321.74 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
09/29/04 |
|
09/30/05 |
|
|
|
|
|
01/31/06 |
|
01/31/07 |
|
|
|
|
|
489.00 |
|
488.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|