| Balance Sheet (Unaudited) | Statement Of Revenues & Expenditures (Unaudited) (Accrual) | ||||||||||||||||||
| 10/31/05 | 10/31/06 | Variance | 10/31/05 | 10/31/06 | Variance | ||||||||||||||
| Assets | Revenues | ||||||||||||||||||
| Cash & Cash Equivalents | 928,483 | 1,745,613 | 817,129 | Gross Patient Revenues | 9,362,079 | 10,610,269 | 1,248,190 | ||||||||||||
| Accounts Receivable (Net) | 27,914,713 | 23,815,421 | (4,099,292) | Contractual Adjustments | (1,389,891) | (1,389,776) | 115 | ||||||||||||
| Due From Gov Guam | 10,682,899 | 7,561,016 | (3,121,883) | Bad Debts Expense | (2,791,911) | (3,440,892) | (648,981) | ||||||||||||
| Other Receivables | 595,853 | 628,916 | 33,063 | Net Patient Revenues | 5,180,277 | 5,779,601 | 599,324 | ||||||||||||
| Inventories | 1,990,758 | 4,824,534 | 2,833,776 | Other Revenues | 50,039 | 53,951 | 3,912 | ||||||||||||
| Prepaid Expenses | 614,800 | 470,207 | (144,593) | Total Revenues | 5,230,315 | 5,833,552 | 603,236 | ||||||||||||
| Property Plant and Equipment (Net) | 40,410,440 | 41,375,894 | 965,454 | Bioterrorism | |||||||||||||||
| Total Assets | 83,137,946 | 80,421,600 | (2,716,346) | Expenditures | |||||||||||||||
| Salaries & Benefits | 3,874,673 | 4,165,988 | 291,316 | ||||||||||||||||
| Liabilities & Fund Balance | Travel | 6,109 | 26,384 | 20,275 | |||||||||||||||
| Accounts Payable (Trade) | 5,935,231 | 6,555,981 | 620,750 | Training | 1,870 | 14,113 | 12,243 | ||||||||||||
| Accounts Payable (Government) | 11,511,051 | 10,555,567 | (955,484) | Contractual Services | 464,517 | 298,096 | (166,421) | ||||||||||||
| Accrued Payroll & Benefits | 1,557,834 | 1,683,558 | 125,725 | Supplies & Materials | 730,642 | 593,861 | (136,781) | ||||||||||||
| Accrued Annual Leave, S/L (Current) | 2,072,057 | 2,333,144 | 261,087 | Minor Equipment | 10,738 | 5,108 | (5,629) | ||||||||||||
| Long-Term Debt (Current) | 6,961,696 | 6,444,431 | (517,265) | Miscellaneous | 474,844 | 29,655 | (445,190) | ||||||||||||
| Deferred Revenue | 10,368,035 | 8,147,772 | (2,220,263) | Utilities | 220,878 | 29,569 | (191,309) | ||||||||||||
| Deferred retirement Fund Contribution | 2,634,703 | 2,634,703 | - | Long Term Care Facility | 50,975 | 1,133 | (49,842) | ||||||||||||
| Accrued Annual Leave, S/L (Non-Current) | 1,765,085 | 1,987,493 | 222,407 | Interest Expense | 23 | 69,317 | 69,294 | ||||||||||||
| Fund Balance | 40,332,254 | 40,078,951 | (253,303) | Sick & Annual Leave Expense | 79,219 | 71,127 | (8,092) | ||||||||||||
| Depreciation Expense | 246,376 | 336,153 | 89,777 | ||||||||||||||||
| Total Liabilities & Fund Balance | 83,137,946 | 80,421,600 | (2,716,346) | Typhoon Expenses | - | - | |||||||||||||
| - | 0 | 0 | Gain/Loss on Disposal of Assets | - | - | ||||||||||||||
| Bioterrorism | 71,724 | 32,699 | (39,025) | ||||||||||||||||
| Cash Flow Statement | FEMA | - | - | - | |||||||||||||||
| 10/31/05 | 10/31/06 | Compact Impact Expenses | 254,662 | 39,855 | (214,807) | ||||||||||||||
| Beginning Cash Balance | 1,157,962 | 484,642 | Advanced Appropiration | 319,783 | 319,783 | ||||||||||||||
| Cash Receipts | Inventory Adjustment | 417 | 13,369 | 12,953 | |||||||||||||||
| Patient Revenues | 4,149,628 | 7,262,165 | Total Expenditures | 6,487,666 | 6,046,210 | (441,456) | |||||||||||||
| Other Receipts | 57,757 | 121,847 | Non-Operating Revenues | ||||||||||||||||
| Medicare Reimbursement FY03 MCR | 4,921,530 | Healthy Futures Fund | - | - | - | ||||||||||||||
| Insurance Settlement | - | FEMA | - | - | - | ||||||||||||||
| Compact Impact | 86,549 | Transfers from GovGuam | (16,343) | - | 16,343 | ||||||||||||||
| FEMA | - | 164,101 | Tobacco Funds | - | - | ||||||||||||||
| Healthy Futures | - | - | Compact Impact | - | - | - | |||||||||||||
| Health Securities Trust Fund | - | Bioterrorism | - | - | |||||||||||||||
| Bioterrorism | 247,402 | - | ANA Grant | - | - | - | |||||||||||||
| ANA Grant | - | - | Contributions | - | 28,490 | 28,490 | |||||||||||||
| GTA Sale Proceeds | - | - | Total Non-Operating Revenues | (16,343) | 28,490 | 44,833 | |||||||||||||
| Gov Guam GRT | - | Net Revenues Over/(Under) Expenditures | (1,273,694) | (184,169) | 1,089,525 | ||||||||||||||
| Citizens Saving Account | |||||||||||||||||||
| Total Cash Receipts | 4,541,336 | 12,469,643 | |||||||||||||||||
| Cash Disbursements | |||||||||||||||||||
| Salaries & Benefits | 3,644,333 | 6,557,643 | |||||||||||||||||
| Travel and Training | 41,008 | 22,578 | |||||||||||||||||
| Contractual Services | 502,636 | 1,477,096 | |||||||||||||||||
| Supplies & Materials | 418,059 | 2,830,755 | |||||||||||||||||
| Miscellaneous | 22,774 | 7,033 | |||||||||||||||||
| Utilities | 142,005 | 246,199 | |||||||||||||||||
| Capital Outlay | - | 23,886 | |||||||||||||||||
| Retirement Funds Note | - | - | |||||||||||||||||
| GPA Note | - | 43,483 | |||||||||||||||||
| Total Cash Disbursements | 4,770,815 | 11,208,673 | |||||||||||||||||
| Ending Cash balance | 928,483 | 1,745,613 | |||||||||||||||||
| - | 0.00 | ||||||||||||||||||
| 1.86 | |||||||||||||||||||
| Current Ratio | 1.430991398 | 1.224072654 | |||||||||||||||||
| Cash to Debt | 0.054624106 | 0.155053406 | |||||||||||||||||
| Average Payment Period | 1,451.78 | 604.55 | |||||||||||||||||
| 09/29/04 | 09/30/05 | ||||||||||||||||||
| 10/31/05 | 10/31/06 | ||||||||||||||||||
| 397.00 | 396.00 | ||||||||||||||||||