| Balance Sheet (Unaudited) | Statement Of Revenues & Expenditures (Unaudited) (Accrual) | ||||||||||||||||||
| 07/31/05 | 07/31/06 | Variance | 07/31/05 | 07/31/06 | Variance | ||||||||||||||
| Assets | Revenues | ||||||||||||||||||
| Cash & Cash Equivalents | 382,548 | 148,288 | (234,260) | Gross Patient Revenues | 83,827,803 | 91,368,681 | 7,540,878 | ||||||||||||
| Accounts Receivable (Net) | 24,945,084 | 29,153,988 | 4,208,904 | Contractual Adjustments | (12,440,394) | (13,681,478) | (1,241,084) | ||||||||||||
| Due From Gov Guam | 1,064,497 | 9,348,463 | 8,283,966 | (24,908,323) | (26,654,178) | ||||||||||||||
| Other Receivables | 589,023 | 612,438 | 23,415 | Net Patient Revenues | 46,479,086 | 51,033,025 | 6,299,794 | ||||||||||||
| Inventories | 1,920,982 | 4,063,162 | 2,142,180 | Other Revenues | 476,234 | 473,519 | (2,715) | ||||||||||||
| Prepaid Expenses | 657,202 | 567,929 | (89,273) | Total Revenues | 46,955,320 | 51,506,544 | 6,297,079 | ||||||||||||
| Property Plant and Equipment (Net) | 40,131,491 | 38,313,237 | (1,818,254) | Bioterrorism | |||||||||||||||
| Total Assets | 69,690,827 | 82,207,505 | 12,516,678 | Expenditures | |||||||||||||||
| Due From Gov Guam | Salaries & Benefits | 35,242,503 | 41,072,481 | 5,829,978 | |||||||||||||||
| Liabilities & Fund Balance | Travel | 100,064 | 76,670 | (23,394) | |||||||||||||||
| Accounts Payable (Trade) | 11,483,761 | 10,084,405 | (1,399,356) | Training | 49,313 | 31,719 | (17,594) | ||||||||||||
| Accounts Payable (Government) | 9,097,452 | 10,740,477 | 1,643,025 | Contractual Services | 6,938,493 | 5,534,905 | (1,403,588) | ||||||||||||
| Accrued Payroll & Benefits | - | - | - | Supplies & Materials | 9,886,878 | 9,505,709 | (381,169) | ||||||||||||
| Accrued Annual Leave (Current) | 1,471,329 | 1,632,260 | 160,931 | Minor Equipment | 168,360 | 85,971 | (82,389) | ||||||||||||
| Long-Term Debt (Current) | 6,472,332 | 6,815,105 | 342,773 | Miscellaneous | 1,202,250 | 935,438 | (266,812) | ||||||||||||
| Deferred Revenue | 1,163,276 | 10,361,796 | 9,198,520 | Utilities | 1,260,621 | 1,400,886 | 140,265 | ||||||||||||
| Long Term Debt | 1,253,355 | 1,390,443 | 137,088 | Long Term Care Facility | 219,591 | 236,412 | 16,821 | ||||||||||||
| Deferred retirement Fund Contribution | 2,634,703 | 2,634,703 | - | Interest Expense | 903,690 | 294,380 | (609,310) | ||||||||||||
| Accrued Annual Leave (Non-Current) | 884,223 | 1,014,993 | 130,770 | Annual Leave Expense | 394,488 | 704,838 | 310,350 | ||||||||||||
| Fund Balance | 35,230,396 | 37,533,323 | 2,302,927 | Depreciation Expense | 2,701,573 | 2,779,240 | 77,667 | ||||||||||||
| Total Liabilities & Fund Balance | 69,690,827 | 82,207,505 | 12,516,678 | Typhoon Expenses | - | ||||||||||||||
| - | - | - | Gain/Loss on Disposal of Assets | (3,000) | 11,270 | 14,270 | |||||||||||||
| Bioterrorism | 89,974 | 507,973 | 417,999 | ||||||||||||||||
| Cash Flow Statement | FEMA | 4,855 | 131,437 | 126,582 | |||||||||||||||
| Fiscal Year 2005 | Fiscal Year 2006 | Compact Impact Expenses | 1,134,680 | 294,951 | (839,729) | ||||||||||||||
| Beginning Cash Balance | 631,237 | 1,157,962 | Advanced Appropiration | 2,348,607 | 2,348,607 | ||||||||||||||
| Cash Receipts | Inventory Adjustment | 32,466 | 84,348 | 51,882 | |||||||||||||||
| Patient Revenues | 46,466,630 | 48,542,247 | Total Expenditures | 60,326,799 | 66,037,235 | 5,710,436 | |||||||||||||
| Other Receipts | 761,504 | 605,761 | Non-Operating Revenues | ||||||||||||||||
| Tobacco Funds | Healthy Futures Fund | 3,419,260 | - | (3,419,260) | |||||||||||||||
| Insurance Settlement | 730,844 | - | FEMA | 575,660 | - | (575,660) | |||||||||||||
| Compact Impact | 5,023,984 | 2,753,447 | Transfers from GovGuam | 578,846 | 6,990,818 | ||||||||||||||
| FEMA | 177,413 | 184,424 | Tobacco Funds | - | - | ||||||||||||||
| Healthy Futures | 2,349,999 | - | Compact Impact | 2,425,040 | 1,948,300 | (476,740) | |||||||||||||
| Health Securities Trust Fund | 183,130 | Bioterrorism | - | - | |||||||||||||||
| Bioterrorism | 340,465 | 646,460 | ANA Grant | 21,927 | 6,240 | (15,687) | |||||||||||||
| ANA Grant | 12,362 | 5,713 | Contributions | 75,326 | 74,430 | (896) | |||||||||||||
| GTA Sale Proceeds | - | - | Total Non-Operating Revenues | 7,096,059 | 9,019,788 | (4,488,243) | |||||||||||||
| Gov Guam GRT | 5,924,014 | Net Revenues Over/(Under) Expenditures | (6,275,420) | (5,510,903) | (3,901,600) | ||||||||||||||
| Citizens Saving Account | |||||||||||||||||||
| Total Cash Receipts | 55,863,201 | 58,845,196 | |||||||||||||||||
| Cash Disbursements | |||||||||||||||||||
| Salaries & Benefits | 35,381,874 | 40,828,391 | |||||||||||||||||
| Travel and Training | 141,140 | 174,611 | |||||||||||||||||
| Contractual Services | 6,243,775 | 4,587,139 | |||||||||||||||||
| Supplies & Materials | 9,714,665 | 11,073,747 | |||||||||||||||||
| Miscellaneous | 208,273 | 761,664 | |||||||||||||||||
| Utilities | 1,649,605 | 1,581,009 | |||||||||||||||||
| Capital Outlay | 2,372,225 | 456,962 | |||||||||||||||||
| Retirement Funds Note | 125,543 | - | |||||||||||||||||
| GPA Note | 274,790 | 391,347 | |||||||||||||||||
| Total Cash Disbursements | 56,111,890 | 59,854,870 | |||||||||||||||||
| Ending Cash balance | 382,548 | 148,288 | |||||||||||||||||
| - | - | ||||||||||||||||||
| 15.81 | |||||||||||||||||||
| Current Ratio | 0.945881549 | 1.341310662 | |||||||||||||||||
| Cash to Debt | 1.621082482 | 1.317208136 | |||||||||||||||||
| Average Payment Period | 111.87 | 105.77 | |||||||||||||||||
| 09/29/04 | 09/30/05 | ||||||||||||||||||
| 07/31/05 | 07/31/06 | ||||||||||||||||||
| 305.00 | 304.00 | ||||||||||||||||||