| Balance Sheet (Unaudited) | Statement Of Revenues & Expenditures (Unaudited) | ||||||||||||||||||
| 06/30/04 | 06/30/05 | Variance | 06/30/04 | 06/30/05 | Variance | ||||||||||||||
| Assets | Revenues | ||||||||||||||||||
| Cash & Cash Equivalents | 1 | 1,058,027 | 298,350 | (759,677) | Gross Patient Revenues | 5 | 76,135,124 | 74,934,180 | (1,200,944) | ||||||||||
| Accounts Receivable (Net) | 27,586,824 | 29,563,194 | 1,976,370 | Contractual Adjustments | 5 | (12,559,799) | (9,720,281) | 2,839,518 | |||||||||||
| Prepaid Expenses | 87,362 | 433,643 | 346,281 | Net Patient Revenues | 63,575,325 | 65,213,899 | 1,638,574 | ||||||||||||
| Other Receivables | 489,914 | 603,587 | 113,673 | Other Revenues | 540,944 | 422,486 | (118,458) | ||||||||||||
| Due From Gov Guam | 2 | 536,264 | 1,037,936 | 501,672 | Total Revenues | 64,116,269 | 65,636,385 | 1,520,116 | |||||||||||
| Inventories | 2,410,612 | 2,030,350 | (380,262) | ||||||||||||||||
| Property Plant and Equipment (Net) | 42,886,201 | 40,708,061 | (2,178,140) | Expenditures | |||||||||||||||
| Total Assets | 75,055,204 | 74,675,121 | (380,083) | Salaries & Benefits | 6 | 30,334,793 | 32,101,130 | 1,766,337 | |||||||||||
| Travel | 7 | 79,997 | 95,501 | 15,504 | |||||||||||||||
| Liabilities & Fund Balance | Training | 8 | 20,305 | 48,333 | 28,028 | ||||||||||||||
| Accounts Payable (Trade) | 3 | 9,931,733 | 11,111,121 | 1,179,388 | Contractual Services | 9 | 4,281,536 | 6,145,369 | 1,863,833 | ||||||||||
| Accounts Payable (Government) | 10,014,378 | 9,518,982 | (495,396) | Supplies & Materials | 10 | 7,198,394 | 9,078,147 | 1,879,753 | |||||||||||
| Accrued Payroll & Benefits | 1,278,310 | 1,359,027 | 80,717 | Minor Equipment | 73,221 | 139,334 | 66,113 | ||||||||||||
| Accrued Annual Leave (Current) | 2,270,802 | 2,203,546 | (67,256) | Miscellaneous | 233,696 | 1,191,681 | 957,985 | ||||||||||||
| Long-Term Debt (Current) | 6,132,188 | 5,765,898 | (366,290) | Utilities | 1,144,687 | 1,076,238 | (68,449) | ||||||||||||
| Deferred Revenue | 4 | 1,487,914 | 1,487,914 | Long Term Care Facility | 247,011 | 192,902 | (54,109) | ||||||||||||
| Long Term Debt | 836,207 | 786,258 | (49,949) | Bad Debts | 5 | 21,902,165 | 19,703,462 | (2,198,703) | |||||||||||
| Deferred retirement Fund Contribution | 2,634,703 | 2,634,703 | - | Interest Expense | 11 | 1,449,922 | 657,929 | (791,993) | |||||||||||
| Accrued Annual Leave (Non-Current) | 1,391,782 | 1,350,560 | (41,222) | Annual Leave Expense | 194,132 | 415,092 | 220,960 | ||||||||||||
| Fund Balance | 40,565,101 | 38,457,112 | (2,107,989) | Depreciation Expense | 2,498,791 | 2,212,816 | (285,975) | ||||||||||||
| Total Liabilities & Fund Balance | 75,055,204 | 74,675,121 | (380,083) | Typhoon Expenses | 521,134 | 7,427 | (513,707) | ||||||||||||
| - | - | - | Bioterrorism | 75,105 | 89,962 | 14,857 | |||||||||||||
| Gain/Loss on Disposal of Assets | (3,000) | (3,000) | |||||||||||||||||
| Cash Flow Statement | FEMA | 25,051 | 2,307 | (22,744) | |||||||||||||||
| Fiscal Year 2004 | Fiscal Year 2005 | Compact Impact Expenses | 12 | 966,978 | 966,978 | ||||||||||||||
| Beginning Cash Balance | 1,176,391 | 637,556 | Inventory Adjustment | 291,510 | 23,512 | (267,998) | |||||||||||||
| Cash Receipts | Total Expenditures | 70,571,450 | 74,145,120 | 3,573,670 | |||||||||||||||
| Patient Revenues | 56,393,097 | 40,812,318 | Non-Operating Revenues | ||||||||||||||||
| Other Receipts | 998,991 | 682,424 | ANA Grant | 9,564 | 9,564 | ||||||||||||||
| Tobacco Funds | 1,381,251 | Bioterrorism | 124,262 | (124,262) | |||||||||||||||
| Insurance Settlement | Compact Impact | 557,053 | 2,283,701 | 1,726,648 | |||||||||||||||
| FEMA | 178,812 | 177,413 | FEMA | 280,864 | 507,633 | 226,769 | |||||||||||||
| Compact Impact | 3,559,455 | 4,750,514 | Healthy Futures Fund | 13 | 3,000,000 | 3,106,984 | 106,984 | ||||||||||||
| Healthy Futures | 3,800,000 | 2,349,999 | Tobacco Funds | 413,620 | (413,620) | ||||||||||||||
| Bioterrorism | 209,695 | 272,438 | Contributions | 56,000 | 75,326 | 19,326 | |||||||||||||
| ANA Grant | 9,564 | Total Non-Operating Revenues | 4,431,799 | 5,983,208 | 1,551,409 | ||||||||||||||
| Citizens Saving Account | 495,119 | Net Revenues Over/(Under) Expenditures | (2,023,382) | (2,525,527) | (502,145) | ||||||||||||||
| Total Cash Receipts | 67,016,420 | 49,054,670 | |||||||||||||||||
| Cash Disbursements | |||||||||||||||||||
| Salaries & Benefits | 41,023,537 | 30,468,038 | |||||||||||||||||
| Travel and Training | 184,499 | 131,784 | |||||||||||||||||
| Contractual Services | 6,362,894 | 5,667,235 | |||||||||||||||||
| Supplies & Materials | 13,038,305 | 8,815,632 | |||||||||||||||||
| Miscellaneous | 748,566 | 201,019 | |||||||||||||||||
| Utilities | 1,481,423 | 1,487,938 | |||||||||||||||||
| Capital Outlay | 2,917,907 | 2,266,862 | |||||||||||||||||
| Cost Report | |||||||||||||||||||
| Retirement Funds Note | 1,522,334 | 125,543 | |||||||||||||||||
| GPA Note | 275,790 | 229,825 | |||||||||||||||||
| Total Cash Disbursements | 67,555,255 | 49,393,876 | |||||||||||||||||
| Ending Cash balance | 637,556 | 298,350 | |||||||||||||||||
| - | |||||||||||||||||||
| (2,023,382.00) | (2,525,527.00) | ||||||||||||||||||
| - | - | ||||||||||||||||||
| Current Ratio | 0.986320641 | 1.031383336 | |||||||||||||||||
| Cash to Debt | 1.943062333 | 1.354427572 | |||||||||||||||||
| Average Payment Period | 80.90 | 114.02 | |||||||||||||||||
| 09/30/03 | 09/30/04 | ||||||||||||||||||
| 06/30/04 | 06/30/05 | ||||||||||||||||||
| 274.00 | 273.00 | ||||||||||||||||||