| Balance Sheet (Unaudited) | Statement Of Revenues & Expenditures (Unaudited) (Accrual) | ||||||||||||||||||
| 09/30/05 | 09/30/06 | Variance | 09/30/05 | 09/30/06 | Variance | ||||||||||||||
| Assets | Revenues | ||||||||||||||||||
| Cash & Cash Equivalents | 1,407,334 | 484,642 | (922,693) | Gross Patient Revenues | 103,161,746 | 110,829,146 | 7,667,401 | ||||||||||||
| Accounts Receivable (Net) | 27,239,065 | 30,617,818 | 3,378,753 | Contractual Adjustments | (15,230,154) | (16,609,477) | (1,379,323) | ||||||||||||
| Due From Gov Guam | 1,743,183 | 7,582,571 | 5,839,389 | Bad Debts Expense | (30,797,349) | (32,476,402) | (1,679,053) | ||||||||||||
| Other Receivables | 599,125 | 645,264 | 46,139 | Net Patient Revenues | 57,134,243 | 61,743,267 | 4,609,024 | ||||||||||||
| Inventories | 1,798,862 | 3,500,162 | 1,701,299 | Other Revenues | 557,356 | 573,694 | 16,338 | ||||||||||||
| Prepaid Expenses | 692,862 | 371,503 | (321,360) | Total Revenues | 57,691,599 | 62,316,962 | 4,625,362 | ||||||||||||
| Property Plant and Equipment (Net) | 40,619,500 | 42,205,302 | 1,585,803 | Bioterrorism | |||||||||||||||
| Total Assets | 74,099,931 | 85,407,262 | 11,307,331 | Expenditures | |||||||||||||||
| Salaries & Benefits | 45,870,895 | 51,258,561 | 5,387,667 | ||||||||||||||||
| Liabilities & Fund Balance | Travel | 105,428 | 93,511 | (11,918) | |||||||||||||||
| Accounts Payable (Trade) | 3,787,105 | 9,015,312 | 5,228,207 | Training | 50,258 | 62,095 | 11,838 | ||||||||||||
| Accounts Payable (Government) | 12,243,473 | 12,470,206 | 226,733 | Contractual Services | 8,792,996 | 7,151,398 | (1,641,598) | ||||||||||||
| Accrued Payroll & Benefits | 1,667,227 | 1,758,303 | 91,076 | Supplies & Materials | 12,892,584 | 12,154,098 | (738,487) | ||||||||||||
| Accrued Annual Leave (Current) | 1,406,460 | 1,568,803 | 162,343 | Minor Equipment | 243,272 | 105,813 | (137,460) | ||||||||||||
| Long-Term Debt (Current) | 7,310,546 | 6,391,500 | (919,046) | Miscellaneous | 1,505,504 | 1,060,428 | (445,077) | ||||||||||||
| Deferred Revenue | 1,078,025 | 7,997,772 | 6,919,747 | Utilities | 1,628,960 | 1,794,847 | 165,887 | ||||||||||||
| Deferred retirement Fund Contribution | 2,634,703 | 2,634,703 | - | Long Term Care Facility | 316,040 | 290,913 | (25,127) | ||||||||||||
| Accrued Annual Leave (Non-Current) | 1,198,096 | 1,336,388 | 138,292 | Interest Expense | 363,923 | 1,551,925 | 1,188,003 | ||||||||||||
| Accrued Sick Leave | 1,168,347 | 1,351,326 | 182,979 | Sick & Annual Leave Expense | 567,263 | 646,782 | 79,520 | ||||||||||||
| Fund Balance | 41,605,948 | 40,882,948 | (723,000) | Depreciation Expense | 3,494,096 | 3,077,030 | (417,066) | ||||||||||||
| Total Liabilities & Fund Balance | 74,099,931 | 85,407,262 | 11,307,331 | Typhoon Expenses | - | ||||||||||||||
| 0 | 0 | - | Gain/Loss on Disposal of Assets | (3,000) | 11,270 | 14,270 | |||||||||||||
| Bioterrorism | 72,963 | 57,649 | (15,315) | ||||||||||||||||
| Cash Flow Statement | FEMA | 2,548 | 131,437 | 128,888 | |||||||||||||||
| 09/30/05 | 09/30/06 | Compact Impact Expenses | 45,607 | 346,936 | 301,329 | ||||||||||||||
| Beginning Cash Balance | 631,237 | 1,157,962 | Advanced Appropiration | 76,074 | 76,074 | ||||||||||||||
| Cash Receipts | Inventory Adjustment | 176,027 | 117,509 | (58,518) | |||||||||||||||
| Patient Revenues | 56,610,716 | 57,350,616 | Total Expenditures | 76,125,365 | 79,988,275 | 3,862,910 | |||||||||||||
| Other Receipts | 855,948 | 743,678 | Non-Operating Revenues | ||||||||||||||||
| Medicare Reimbursement FY03 MCR | 1,457,016 | Healthy Futures Fund | 4,791,666 | - | (4,791,666) | ||||||||||||||
| Insurance Settlement | 730,844 | FEMA | 489,330 | 144,553 | (344,777) | ||||||||||||||
| Compact Impact | 8,256,559 | 5,081,027 | Transfers from GovGuam | 5,600,000 | 14,360,701 | 8,760,701 | |||||||||||||
| FEMA | 177,413 | 184,424 | Tobacco Funds | - | - | ||||||||||||||
| Healthy Futures | 4,791,666 | - | Compact Impact | 7,108,350 | 2,365,435 | (4,742,916) | |||||||||||||
| Health Securities Trust Fund | 466,260 | Bioterrorism | 451,937 | (451,937) | |||||||||||||||
| Bioterrorism | 340,465 | 646,460 | ANA Grant | 26,588 | (1,455) | (28,043) | |||||||||||||
| ANA Grant | 12,362 | 5,713 | Contributions | 65,928 | 79,080 | 13,153 | |||||||||||||
| GTA Sale Proceeds | 5,000,000 | - | Total Non-Operating Revenues | 18,533,799 | 16,948,313 | (1,585,485) | |||||||||||||
| Gov Guam GRT | 8,421,521 | Net Revenues Over/(Under) Expenditures | 100,033 | (723,000) | (823,033) | ||||||||||||||
| Citizens Saving Account | |||||||||||||||||||
| Total Cash Receipts | 76,775,973 | 74,356,715 | |||||||||||||||||
| Cash Disbursements | |||||||||||||||||||
| Salaries & Benefits | 45,165,336 | 49,766,741 | |||||||||||||||||
| Travel and Training | 149,149 | 200,857 | |||||||||||||||||
| Contractual Services | 9,630,731 | 5,240,070 | |||||||||||||||||
| Supplies & Materials | 16,022,418 | 14,194,092 | |||||||||||||||||
| Miscellaneous | 266,388 | 804,848 | |||||||||||||||||
| Utilities | 1,888,460 | 2,016,910 | |||||||||||||||||
| Capital Outlay | 2,431,725 | 2,328,205 | |||||||||||||||||
| Retirement Funds Note | 125,543 | - | |||||||||||||||||
| GPA Note | 320,126 | 478,313 | |||||||||||||||||
| Total Cash Disbursements | 75,999,876 | 75,030,036 | |||||||||||||||||
| Ending Cash balance | 1,407,334 | 484,642 | |||||||||||||||||
| (0.20) | 0.38 | ||||||||||||||||||
| 20.04 | |||||||||||||||||||
| Current Ratio | 1.173156428 | 1.260419724 | |||||||||||||||||
| Cash to Debt | 2.362775079 | 1.670024947 | |||||||||||||||||
| Average Payment Period | 77.20 | 104.52 | |||||||||||||||||
| 09/29/04 | 09/30/05 | ||||||||||||||||||
| 09/30/05 | 09/30/06 | ||||||||||||||||||
| 366.00 | 365.00 | ||||||||||||||||||