| Balance Sheet (Unaudited) | Statement Of Revenues & Expenditures (Unaudited) | ||||||||||||||||||
| 04/30/04 | 04/30/05 | Variance | 04/30/04 | 04/30/05 | Variance | ||||||||||||||
| Assets | Revenues | ||||||||||||||||||
| Cash & Cash Equivalents | 1 | 1,172,108 | (202,352) | (1,374,460) | Gross Patient Revenues | 5 | 59,904,495 | 57,715,241 | (2,189,254) | ||||||||||
| Accounts Receivable (Net) | 27,121,491 | 24,674,759 | (2,446,732) | Contractual Adjustments | 5 | (10,419,582) | (8,510,296) | 1,909,286 | |||||||||||
| Prepaid Expenses | 103,373 | 375,970 | 272,597 | Net Patient Revenues | 49,484,913 | 49,204,945 | (279,968) | ||||||||||||
| Other Receivables | 467,728 | 590,366 | 122,638 | Other Revenues | 390,070 | 331,514 | (58,556) | ||||||||||||
| Due From Gov Guam | 2 | 571,126 | 1,246,828 | 675,702 | Total Revenues | 49,874,983 | 49,536,459 | (338,524) | |||||||||||
| Inventories | 2,621,367 | 2,692,344 | 70,977 | ||||||||||||||||
| Property Plant and Equipment (Net) | 42,994,449 | 40,972,583 | (2,021,866) | Expenditures | |||||||||||||||
| Total Assets | 75,051,642 | 70,350,498 | (4,701,144) | Salaries & Benefits | 6 | 22,484,206 | 25,338,027 | 2,853,821 | |||||||||||
| Travel | 7 | 57,114 | 86,447 | 29,333 | |||||||||||||||
| Liabilities & Fund Balance | Training | 8 | 19,846 | 46,013 | 26,167 | ||||||||||||||
| Accounts Payable (Trade) | 3 | 9,603,153 | 12179051 | 2,575,898 | Contractual Services | 9 | 3,434,864 | 5,404,696 | 1,969,832 | ||||||||||
| Accounts Payable (Government) | 9,566,503 | 8,607,429 | (959,074) | Supplies & Materials | 10 | 5,307,668 | 6,951,527 | 1,643,859 | |||||||||||
| Accrued Payroll & Benefits | - | 1,353,019 | 1,353,019 | Minor Equipment | 56,283 | 130,351 | 74,068 | ||||||||||||
| Accrued Annual Leave (Current) | 1,318,189 | 1,268,252 | (49,937) | Miscellaneous | 438,041 | 1,145,207 | 707,166 | ||||||||||||
| Long-Term Debt (Current) | 1,523,376 | 1,523,376 | - | Utilities | 889,606 | 813,313 | (76,293) | ||||||||||||
| Deferred Revenue | 4 | - | 1,749,604 | 1,749,604 | Long Term Care | 178,444 | 147,939 | (30,505) | |||||||||||
| Long Term Debt | 4,787,839 | 4,467,165 | (320,674) | Bad Debts | 5 | 16,783,485 | 17,151,666 | 368,181 | |||||||||||
| Deferred retirement Fund Contribution | 2,634,703 | 2,634,703 | - | Interest Expense | 11 | 1,267,954 | 531,567 | (736,387) | |||||||||||
| Accrued Annual Leave (Non-Current) | 1,547,439 | 1,488,818 | (58,621) | Annual Leave Expense | 632,877 | 374,794 | (258,083) | ||||||||||||
| Fund Balance | 44,070,440 | 35,079,081 | (8,991,359) | Depreciation Expense | 1,961,925 | 1,940,579 | (21,346) | ||||||||||||
| Total Liabilities & Fund Balance | 75,051,642 | 70,350,498 | (4,701,144) | Typhoon Expenses | 280,255 | 7,427 | (272,828) | ||||||||||||
| - | - | - | Bioterrorism | 86,720 | 67,029 | (19,691) | |||||||||||||
| FEMA | 25,051 | 2,307 | (22,744) | ||||||||||||||||
| Cash Flow Statement | Compact Impact Expenses | 12 | - | 789,745 | 789,745 | ||||||||||||||
| Fiscal Year 2004 | Fiscal Year 2005 | Inventory Adjustment | 278,150 | 26,948 | (251,202) | ||||||||||||||
| Beginning Cash Balance | 1,176,391 | 637,556 | Total Expenditures | 54,182,489 | 60,955,582 | 6,773,093 | |||||||||||||
| Cash Receipts | Non-Operating Revenues | ||||||||||||||||||
| Patient Revenues | 56,393,097 | 31,992,336 | ANA Grant | - | 9,564 | 9,564 | |||||||||||||
| Other Receipts | 998,991 | 454,495 | Bioterrorism | 22,237 | - | (22,237) | |||||||||||||
| Tobacco Funds | 1,381,251 | 1,891,666 | Compact Impact | 482,177 | 783,702 | 301,525 | |||||||||||||
| Insurance Settlement | FEMA | 280,864 | 426,635 | 145,771 | |||||||||||||||
| FEMA | 178,812 | 177,413 | Healthy Futures Fund | 13 | 2,000,000 | 2,158,332 | 158,332 | ||||||||||||
| Compact Impact | 3,559,455 | 2,935,361 | Tobacco Funds | 413,620 | - | (413,620) | |||||||||||||
| Healthy Futures | 3,800,000 | Contributions | 56,000 | 75,626 | 19,626 | ||||||||||||||
| Bioterrorism | 209,695 | 191,440 | Total Non-Operating Revenues | 3,254,898 | 3,453,859 | 198,961 | |||||||||||||
| ANA Grant | 9,564 | Net Revenues Over/(Under) Expenditures | (1,052,608) | (7,965,264) | (6,912,656) | ||||||||||||||
| Citizens Saving Account | 495,119 | ||||||||||||||||||
| Total Cash Receipts | 67,016,420 | 37,652,275 | |||||||||||||||||
| Cash Disbursements | |||||||||||||||||||
| Salaries & Benefits | 41,023,537 | 23,483,827 | |||||||||||||||||
| Travel and Training | 184,499 | 124,795 | |||||||||||||||||
| Contractual Services | 6,362,894 | 4,779,270 | |||||||||||||||||
| Supplies & Materials | 13,038,305 | 6,275,819 | |||||||||||||||||
| Miscellaneous | 748,566 | 138,013 | |||||||||||||||||
| Utilities | 1,481,423 | 1,076,065 | |||||||||||||||||
| Capital Outlay | 2,917,907 | 2,145,424 | |||||||||||||||||
| Cost Report | 205,532 | ||||||||||||||||||
| Retirement Funds Note | 1,522,334 | 125,543 | |||||||||||||||||
| GPA Note | 275,790 | 137,895 | |||||||||||||||||
| Total Cash Disbursements | 67,555,255 | 38,492,183 | |||||||||||||||||
| Ending Cash balance | 637,556 | (202,352) | |||||||||||||||||
| - | |||||||||||||||||||
| Current Ratio | 1.311362963 | 1.020360732 | |||||||||||||||||
| Cash to Debt | 2.163131695 | 1.067501059 | |||||||||||||||||
| Average Payment Period | 60.44 | 114.48 | |||||||||||||||||
| 09/30/03 | 09/30/04 | ||||||||||||||||||
| 04/30/04 | 04/30/05 | ||||||||||||||||||
| 213.00 | 212.00 | ||||||||||||||||||