| Balance Sheet (Unaudited) | Statement Of Revenues & Expenditures (Unaudited) | ||||||||||||||||||
| 07/31/04 | 07/31/05 | Variance | 07/31/04 | 07/31/05 | Variance | ||||||||||||||
| Assets | Revenues | ||||||||||||||||||
| Cash & Cash Equivalents | 1 | 958,971 | 384,288 | (574,683) | Gross Patient Revenues | 5 | 85,201,773 | 83,876,846 | (1,324,927) | ||||||||||
| Accounts Receivable (Net) | 26,839,524 | 24,975,639 | (1,863,885) | Contractual Adjustments | 5 | (13,802,493) | (12,440,394) | 1,362,099 | |||||||||||
| Prepaid Expenses | 247,262 | 762,170 | 514,908 | Net Patient Revenues | 71,399,280 | 71,436,452 | 37,172 | ||||||||||||
| Other Receivables | 492,761 | 608,636 | 115,875 | Other Revenues | 590,805 | 1,207,078 | 616,273 | ||||||||||||
| Due From Gov Guam | 2 | 551,201 | 963,003 | 411,802 | Total Revenues | 71,990,085 | 72,643,530 | 653,445 | |||||||||||
| Inventories | 2,367,115 | 2,134,086 | (233,029) | ||||||||||||||||
| Property Plant and Equipment (Net) | 42,793,284 | 40,444,707 | (2,348,577) | Expenditures | |||||||||||||||
| Total Assets | 74,250,118 | 70,272,529 | (3,977,589) | Salaries & Benefits | 6 | 33,591,109 | 35,832,839 | 2,241,730 | |||||||||||
| Travel | 7 | 96,363 | 100,064 | 3,701 | |||||||||||||||
| Liabilities & Fund Balance | Training | 8 | 45,382 | 49,313 | 3,931 | ||||||||||||||
| Accounts Payable (Trade) | 3 | 7,788,651 | 11,507,189 | 3,718,538 | Contractual Services | 9 | 5,000,716 | 6,807,445 | 1,806,729 | ||||||||||
| Accounts Payable (Government) | 10,266,636 | 9,398,826 | (867,810) | Supplies & Materials | 10 | 8,101,520 | 9,789,004 | 1,687,484 | |||||||||||
| Accrued Payroll & Benefits | - | - | - | Minor Equipment | 78,203 | 166,270 | 88,067 | ||||||||||||
| Accrued Annual Leave (Current) | 2,224,743 | 2,187,974 | (36,769) | Miscellaneous | 605,328 | 1,092,424 | 487,096 | ||||||||||||
| Long-Term Debt (Current) | 6,117,088 | 5,695,652 | (421,436) | Utilities | 1,283,786 | 1,242,408 | (41,378) | ||||||||||||
| Deferred Revenue | 4 | 1,167,219 | 1,167,219 | Long Term Care Facility | 289,048 | 219,074 | (69,974) | ||||||||||||
| Long Term Debt | 834,148 | 776,680 | (57,468) | Bad Debts | 5 | 24,780,338 | 24,908,323 | 127,985 | |||||||||||
| Deferred retirement Fund Contribution | 2,634,703 | 2,634,703 | - | Interest Expense | 11 | 1,551,634 | 903,625 | (648,009) | |||||||||||
| Accrued Annual Leave (Non-Current) | 1,363,552 | 1,341,016 | (22,536) | Annual Leave Expense | 145,945 | 394,488 | 248,543 | ||||||||||||
| Fund Balance | 43,020,597 | 35,563,270 | (7,457,327) | Depreciation Expense | 2,765,080 | 2,477,421 | (287,659) | ||||||||||||
| Total Liabilities & Fund Balance | 74,250,118 | 70,272,529 | (3,977,589) | Typhoon Expenses | 522,145 | 7,887 | (514,258) | ||||||||||||
| - | - | - | Bioterrorism | 125,785 | 89,974 | (35,811) | |||||||||||||
| 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 | 7,595 | 1,106,760 | 1,099,165 | |||||||||||||
| Beginning Cash Balance | 1,176,391 | 637,556 | Inventory Adjustment | 294,729 | 32,465 | (262,264) | |||||||||||||
| Cash Receipts | Total Expenditures | 79,309,757 | 85,219,091 | 5,909,334 | |||||||||||||||
| Patient Revenues | 56,393,097 | 46,591,736 | Non-Operating Revenues | ||||||||||||||||
| Other Receipts | 998,991 | 761,504 | ANA Grant | - | 21,927 | 21,927 | |||||||||||||
| Tobacco Funds | 1,381,251 | Bioterrorism | 181,063 | - | (181,063) | ||||||||||||||
| Insurance Settlement | 730,844 | Compact Impact | 3,485,167 | 2,425,040 | (1,060,127) | ||||||||||||||
| FEMA | 178,812 | 177,413 | FEMA | 315,935 | 575,660 | 259,725 | |||||||||||||
| Compact Impact | 3,559,455 | 5,023,984 | Healthy Futures Fund | 13 | 3,300,000 | 3,415,317 | 115,317 | ||||||||||||
| Healthy Futures | 3,800,000 | 2,349,999 | Tobacco Funds | 413,620 | 578,846 | 165,226 | |||||||||||||
| Bioterrorism | 209,695 | 340,465 | Contributions | 56,000 | 75,326 | 19,326 | |||||||||||||
| ANA Grant | 12,362 | Total Non-Operating Revenues | 7,751,785 | 7,092,116 | (659,669) | ||||||||||||||
| Citizens Saving Account | 495,119 | Net Revenues Over/(Under) Expenditures | 432,113 | (5,483,445) | (5,915,558) | ||||||||||||||
| Total Cash Receipts | 67,016,420 | 55,988,307 | |||||||||||||||||
| Cash Disbursements | |||||||||||||||||||
| Salaries & Benefits | 41,023,537 | 35,348,289 | |||||||||||||||||
| Travel and Training | 184,499 | 141,140 | |||||||||||||||||
| Contractual Services | 6,362,894 | 6,258,462 | |||||||||||||||||
| Supplies & Materials | 13,038,305 | 9,657,715 | |||||||||||||||||
| Miscellaneous | 748,566 | 208,724 | |||||||||||||||||
| Utilities | 1,481,423 | 1,649,155 | |||||||||||||||||
| Capital Outlay | 2,917,907 | 2,372,225 | |||||||||||||||||
| Cost Report | 205,532 | ||||||||||||||||||
| Retirement Funds Note | 1,522,334 | 125,543 | |||||||||||||||||
| GPA Note | 275,790 | 274,790 | |||||||||||||||||
| Total Cash Disbursements | 67,555,255 | 56,241,575 | |||||||||||||||||
| Ending Cash balance | 637,556 | 384,288 | |||||||||||||||||
| - | |||||||||||||||||||
| (2,023,382.00) | (2,525,527.00) | ||||||||||||||||||
| 2,455,495.00 | (2,957,918.00) | ||||||||||||||||||
| Current Ratio | 1.081122492 | 0.928484416 | |||||||||||||||||
| Cash to Debt | 2.145931729 | 1.613065465 | |||||||||||||||||
| Average Payment Period | 81.52 | 113.00 | |||||||||||||||||
| 09/30/03 | 09/30/04 | ||||||||||||||||||
| 07/31/04 | 07/31/05 | ||||||||||||||||||
| 305.00 | 304.00 | ||||||||||||||||||