| Balance Sheet (Unaudited) | Statement Of Revenues & Expenditures (Unaudited) | ||||||||||||||||||
| 10/31/04 | 10/31/05 | Variance | 10/31/04 | 10/31/05 | Variance | ||||||||||||||
| Assets | Revenues | ||||||||||||||||||
| Cash & Cash Equivalents | 1 | 1,486,953 | 882,185 | (604,768) | Gross Patient Revenues | 5 | 8,583,461 | 9,362,079 | 778,618 | ||||||||||
| Accounts Receivable (Net) | 25,829,275 | 26,060,945 | 231,670 | Contractual Adjustments | 5 | (1,269,274) | (1,389,891) | (120,617) | |||||||||||
| Due From Gov Guam | 4,300,397 | 1,647,999 | (2,652,398) | Net Patient Revenues | 7,314,187 | 7,972,188 | 658,001 | ||||||||||||
| Other Receivables | 1,245,666 | 596,645 | (649,021) | Other Revenues | 48,225 | 46,960 | (1,265) | ||||||||||||
| Inventories | 2 | 1,364,780 | 2,003,333 | 638,553 | Total Revenues | 7,362,412 | 8,019,148 | 656,736 | |||||||||||
| Prepaid Expenses | 336,633 | 614,800 | 278,167 | Bioterrorism | |||||||||||||||
| Property Plant and Equipment (Net) | 41,913,550 | 39,599,929 | (2,313,621) | Expenditures | |||||||||||||||
| Total Assets | 76,477,254 | 71,405,836 | (5,071,418) | Salaries & Benefits | 6 | 2,918,568 | 3,874,814 | 956,246 | |||||||||||
| Due From Gov Guam | Travel | 7 | 63,669 | 7,208 | (56,461) | ||||||||||||||
| Liabilities & Fund Balance | Training | 8 | 4,081 | 1,870 | (2,211) | ||||||||||||||
| Accounts Payable (Trade) | 3 | 7,225,097 | 5,345,755 | (1,879,342) | Contractual Services | 9 | 275,857 | 444,231 | 168,374 | ||||||||||
| Accounts Payable (Government) | 9,862,728 | 9,371,705 | (491,023) | Supplies & Materials | 10 | 986,579 | 717,401 | (269,178) | |||||||||||
| Accrued Payroll & Benefits | 1,418,960 | 1,557,834 | 138,874 | Minor Equipment | 18,869 | 10,738 | (8,131) | ||||||||||||
| Accrued Annual Leave (Current) | 2,199,984 | 2,202,871 | 2,887 | Miscellaneous | 102,120 | 473,555 | 371,435 | ||||||||||||
| Long-Term Debt (Current) | 6,017,303 | 5,655,756 | (361,547) | Utilities | 113,176 | 40,719 | (72,457) | ||||||||||||
| Deferred Revenue | 4 | 3,917,500 | 3,977,874 | 60,374 | Long Term Care Facility | 33,400 | (33,400) | ||||||||||||
| Long Term Debt | 820,541 | 771,239 | (49,302) | Bad Debts | 5 | 2,689,554 | 2,791,911 | 102,357 | |||||||||||
| Deferred retirement Fund Contribution | 2,634,703 | 2,634,703 | - | Interest Expense | 11 | 67,790 | (67,790) | ||||||||||||
| Accrued Annual Leave (Non-Current) | 1,348,377 | 1,350,147 | 1,770 | Annual Leave Expense | 215,938 | 79,219 | (136,719) | ||||||||||||
| Fund Balance | 41,032,061 | 38,537,952 | (2,494,109) | Depreciation Expense | 281,308 | (281,308) | |||||||||||||
| Total Liabilities & Fund Balance | 76,477,254 | 71,405,836 | (5,071,418) | Typhoon Expenses | 7,127 | 2 | (7,125) | ||||||||||||
| - | - | - | Gain/Loss on Disposal of Assets | - | - | ||||||||||||||
| Bioterrorism | 5,052 | 70,625 | 65,573 | ||||||||||||||||
| Cash Flow Statement | FEMA | - | - | ||||||||||||||||
| Fiscal Year 2005 | Fiscal Year 2006 | Compact Impact Expenses | 12 | 72,090 | 268,226 | 196,136 | |||||||||||||
| Beginning Cash Balance | 637,556 | 1,157,962 | Inventory Adjustment | 8,673 | 417 | (8,256) | |||||||||||||
| Cash Receipts | Total Expenditures | 7,863,851 | 8,780,936 | 917,085 | |||||||||||||||
| Patient Revenues | 56,610,717 | 4,149,628 | Non-Operating Revenues | ||||||||||||||||
| Other Receipts | 855,948 | 57,757 | Healthy Futures Fund | - | - | ||||||||||||||
| Tobacco Funds | FEMA | 27,286 | (27,286) | ||||||||||||||||
| Insurance Settlement | 730,844 | - | Tobacco Funds | - | - | ||||||||||||||
| Compact Impact | 8,256,559 | 86,549 | Compact Impact | - | - | ||||||||||||||
| FEMA | 177,413 | - | Bioterrorism | 13 | - | - | |||||||||||||
| Healthy Futures | 4,791,666 | - | ANA Grant | - | - | ||||||||||||||
| Bioterrorism | 340,465 | 247,402 | Contributions | 300 | (300) | ||||||||||||||
| ANA Grant | 12362 | - | Total Non-Operating Revenues | 27,586 | - | (27,586) | |||||||||||||
| GTA Sale Proceeds | 5000000 | - | Net Revenues Over/(Under) Expenditures | (473,853) | (761,788) | (287,935) | |||||||||||||
| Citizens Saving Account | |||||||||||||||||||
| Total Cash Receipts | 76,775,974 | 4,541,336 | |||||||||||||||||
| Cash Disbursements | |||||||||||||||||||
| Salaries & Benefits | 45,165,333 | 3,644,333 | |||||||||||||||||
| Travel and Training | 149,149 | 41,008 | |||||||||||||||||
| Contractual Services | 9,635,419 | 548,934 | |||||||||||||||||
| Supplies & Materials | 16,273,422 | 418,059 | |||||||||||||||||
| Miscellaneous | 266,389 | 22,774 | |||||||||||||||||
| Utilities | 1,888,462 | 142,005 | |||||||||||||||||
| Capital Outlay | 2,431,725 | - | |||||||||||||||||
| Cost Report | - | - | |||||||||||||||||
| Retirement Funds Note | 125,543 | - | |||||||||||||||||
| GPA Note | 320,126 | - | |||||||||||||||||
| Total Cash Disbursements | 76,255,568 | 4,817,113 | |||||||||||||||||
| Ending Cash balance | 1,157,962 | 882,185 | |||||||||||||||||
| - | |||||||||||||||||||
| (761,788.00) | |||||||||||||||||||
| 1.66 | |||||||||||||||||||
| Current Ratio | 1.229688762 | 1.209408699 | |||||||||||||||||
| Cash to Debt | 2.166047565 | 0.138169406 | |||||||||||||||||
| Average Payment Period | 7.17 | 94.71 | |||||||||||||||||
| 09/29/04 | 09/30/05 | ||||||||||||||||||
| 10/31/04 | 10/31/05 | ||||||||||||||||||
| 32.00 | 31.00 | ||||||||||||||||||