| Balance Sheet (Unaudited) | Statement Of Revenues & Expenditures (Unaudited) | ||||||||||||||||||
| 08/31/04 | 08/31/05 | Variance | 08/31/04 | 08/31/05 | Variance | ||||||||||||||
| Assets | Revenues | ||||||||||||||||||
| Cash & Cash Equivalents | 1 | 959,392 | 2,590,526 | 1,631,134 | Gross Patient Revenues | 5 | 93,636,044 | 93,697,196 | 61,152 | ||||||||||
| Accounts Receivable (Net) | 26,475,685 | 24,814,616 | (1,661,069) | Contractual Adjustments | 5 | (14,936,602) | (13,865,393) | 1,071,209 | |||||||||||
| Due From Gov Guam | 494,038 | 2,166,088 | 1,672,050 | Net Patient Revenues | 78,699,442 | 79,831,803 | 1,132,361 | ||||||||||||
| Other Receivables | 502,191 | 592,083 | 89,892 | Other Revenues | 647,434 | 518,492 | (128,942) | ||||||||||||
| Inventories | 2 | 2,515,645 | 2,420,523 | (95,122) | Total Revenues | 79,346,876 | 80,350,295 | 1,003,419 | |||||||||||
| Prepaid Expenses | 213,120 | 431,224 | 218,104 | Bioterrorism | |||||||||||||||
| Property Plant and Equipment (Net) | 44,330,914 | 39,919,268 | (4,411,646) | Expenditures | |||||||||||||||
| Total Assets | 75,490,985 | 72,934,328 | (2,556,657) | Salaries & Benefits | 6 | 36,683,665 | 39,528,173 | 2,844,508 | |||||||||||
| Due From Gov Guam | Travel | 7 | 105,895 | 100,814 | (5,081) | ||||||||||||||
| Liabilities & Fund Balance | Training | 8 | 65,182 | 50,118 | (15,064) | ||||||||||||||
| Accounts Payable (Trade) | 3 | 10,091,608 | 6,728,772 | (3,362,836) | Contractual Services | 9 | 5,363,712 | 7,803,873 | 2,440,161 | ||||||||||
| Accounts Payable (Government) | 9,799,002 | 9,097,452 | (701,550) | Supplies & Materials | 10 | 8,898,004 | 11,026,600 | 2,128,596 | |||||||||||
| Accrued Payroll & Benefits | - | Minor Equipment | 83,271 | 239,729 | 156,458 | ||||||||||||||
| Accrued Annual Leave (Current) | 2,214,059 | 2,232,680 | 18,621 | Miscellaneous | 1,336,298 | 1,462,923 | 126,625 | ||||||||||||
| Long-Term Debt (Current) | 6,084,244 | 5,655,756 | (428,488) | Utilities | 1,425,443 | 1,386,932 | (38,511) | ||||||||||||
| Deferred Revenue | 4 | 2,754,276 | 2,754,276 | Long Term Care Facility | 338,080 | 243,044 | (95,036) | ||||||||||||
| Long Term Debt | 829,670 | 771,239 | (58,431) | Bad Debts | 5 | 27,415,349 | 27,947,233 | 531,884 | |||||||||||
| Deferred retirement Fund Contribution | 2,634,703 | 2,634,703 | - | Interest Expense | 11 | 1,672,677 | 903,690 | (768,987) | |||||||||||
| Accrued Annual Leave (Non-Current) | 1,357,004 | 1,368,418 | 11,414 | Annual Leave Expense | 145,945 | 389,139 | 243,194 | ||||||||||||
| Fund Balance | 42,480,695 | 41,691,032 | (789,663) | Depreciation Expense | 3,031,023 | 2,995,685 | (35,338) | ||||||||||||
| Total Liabilities & Fund Balance | 75,490,985 | 72,934,328 | (2,556,657) | Typhoon Expenses | 533,631 | 7,887 | (525,744) | ||||||||||||
| - | - | - | Gain/Loss on Disposal of Assets | (3,000) | (3,000) | ||||||||||||||
| Bioterrorism | 299,013 | 89,974 | (209,039) | ||||||||||||||||
| Cash Flow Statement | FEMA | 25,051 | 2,307 | (22,744) | |||||||||||||||
| Fiscal Year 2004 | Fiscal Year 2005 | Compact Impact Expenses | 12 | 122,285 | 1,106,747 | 984,462 | |||||||||||||
| Beginning Cash Balance | 1,176,391 | 637,556 | Inventory Adjustment | 294,575 | 47,014 | (247,561) | |||||||||||||
| Cash Receipts | Total Expenditures | 87,839,099 | 95,328,882 | 7,489,783 | |||||||||||||||
| Patient Revenues | 56,393,097 | 51,477,249 | Non-Operating Revenues | ||||||||||||||||
| Other Receipts | 998,991 | 805,804 | Healthy Futures Fund | 3,800,000 | 3,110,927 | (689,073) | |||||||||||||
| Tobacco Funds | 1,381,251 | FEMA | 315,937 | 575,660 | 259,723 | ||||||||||||||
| Insurance Settlement | 730,844 | Tobacco Funds | 435,990 | 5,578,846 | 5,142,856 | ||||||||||||||
| Compact Impact | 3,559,455 | 8,105,769 | Compact Impact | 3,537,084 | 5,430,040 | 1,892,956 | |||||||||||||
| FEMA | 178,812 | 177,413 | Bioterrorism | 13 | 239,424 | (239,424) | |||||||||||||
| Healthy Futures | 3,800,000 | 2,841,666 | ANA Grant | 21,927 | 21,927 | ||||||||||||||
| Bioterrorism | 209,695 | 340,465 | Contributions | 56,000 | 64,779 | 8,779 | |||||||||||||
| ANA Grant | 12,362 | Total Non-Operating Revenues | 8,384,435 | 14,782,179 | 6,397,744 | ||||||||||||||
| GTA Sale Proceeds | 5,000,000 | Net Revenues Over/(Under) Expenditures | (107,788) | (196,408) | (88,620) | ||||||||||||||
| Citizens Saving Account | 495,119 | ||||||||||||||||||
| Total Cash Receipts | 67,016,420 | 69,491,572 | |||||||||||||||||
| Cash Disbursements | |||||||||||||||||||
| Salaries & Benefits | 41,023,537 | 39,449,371 | |||||||||||||||||
| Travel and Training | 184,499 | 145,587 | |||||||||||||||||
| Contractual Services | 6,362,894 | 8,387,847 | |||||||||||||||||
| Supplies & Materials | 13,038,305 | 14,575,894 | |||||||||||||||||
| Miscellaneous | 748,566 | 244,663 | |||||||||||||||||
| Utilities | 1,481,423 | 1,697,650 | |||||||||||||||||
| Capital Outlay | 2,917,907 | 2,431,725 | |||||||||||||||||
| Cost Report | 205,532 | ||||||||||||||||||
| Retirement Funds Note | 1,522,334 | 125,543 | |||||||||||||||||
| GPA Note | 275,790 | 274,790 | |||||||||||||||||
| Total Cash Disbursements | 67,555,255 | 67,538,602 | |||||||||||||||||
| Ending Cash balance | 637,556 | 2,590,526 | |||||||||||||||||
| - | (2,023,382.00) | (2,525,527.00) | |||||||||||||||||
| 1,915,594.00 | 2,329,119.00 | ||||||||||||||||||
| Current Ratio | 1.008598877 | 1.271926859 | |||||||||||||||||
| Cash to Debt | 2.030167563 | 2.224207459 | |||||||||||||||||
| Average Payment Period | 98.93 | 78.50 | |||||||||||||||||
| 09/30/03 | 09/30/04 | ||||||||||||||||||
| 08/31/04 | 08/31/05 | ||||||||||||||||||
| 336.00 | 335.00 | ||||||||||||||||||