| Balance Sheet (Unaudited) | Statement Of Revenues & Expenditures (Unaudited) (Accrual) | ||||||||||||||||||
| 11/30/04 | 11/30/05 | Variance | 11/30/04 | 11/30/05 | Variance | ||||||||||||||
| Assets | Revenues | ||||||||||||||||||
| Cash & Cash Equivalents | 1 | 449,464 | 634,163 | 184,699 | Gross Patient Revenues | 5 | 16,517,686 | 18,261,902 | 1,744,216 | ||||||||||
| Accounts Receivable (Net) | 26,521,864 | 26,368,169 | (153,695) | Contractual Adjustments | 5 | (2,463,933) | (2,736,731) | (272,798) | |||||||||||
| Due From Gov Guam | 4,300,397 | 1,055,959 | (3,244,438) | Net Patient Revenues | 14,053,753 | 15,525,171 | 1,471,418 | ||||||||||||
| Other Receivables | 1,251,810 | 605,788 | (646,022) | Other Revenues | 90,254 | 91,964 | 1,710 | ||||||||||||
| Inventories | 2 | 1,321,475 | 2,035,639 | 714,164 | Total Revenues | 14,144,007 | 15,617,135 | 1,473,128 | |||||||||||
| Prepaid Expenses | 255,241 | 615,199 | 359,958 | Bioterrorism | |||||||||||||||
| Property Plant and Equipment (Net) | 41,801,157 | 39,318,947 | (2,482,210) | Expenditures | |||||||||||||||
| Total Assets | 75,901,408 | 70,633,864 | (5,267,544) | Salaries & Benefits | 6 | 6,289,244 | 7,797,792 | 1,508,548 | |||||||||||
| Due From Gov Guam | Travel | 7 | 68,747 | 10,719 | (58,028) | ||||||||||||||
| Liabilities & Fund Balance | Training | 8 | 22,271 | 1,870 | (20,401) | ||||||||||||||
| Accounts Payable (Trade) | 3 | 8,304,558 | 5,638,106 | (2,666,452) | Contractual Services | 9 | 1,387,217 | 1,022,381 | (364,836) | ||||||||||
| Accounts Payable (Government) | 10,363,838 | 9,287,970 | (1,075,868) | Supplies & Materials | 10 | 2,109,606 | 1,595,831 | (513,775) | |||||||||||
| Accrued Payroll & Benefits | 1,365,328 | 1,559,095 | 193,767 | Minor Equipment | 21,521 | 15,329 | (6,192) | ||||||||||||
| Accrued Annual Leave (Current) | 2,170,337 | 2,258,422 | 88,085 | Miscellaneous | 229,589 | 1,222,094 | 992,505 | ||||||||||||
| Long-Term Debt (Current) | 6,007,822 | 5,567,122 | (440,700) | Utilities | 168,114 | 185,717 | 17,603 | ||||||||||||
| Deferred Revenue | 4 | 3,917,500 | 3,977,873 | 60,373 | Long Term Care Facility | 39,646 | 26,106 | (13,540) | |||||||||||
| Long Term Debt | 819,248 | 759,153 | (60,095) | Bad Debts | 5 | 5,214,760 | 5,302,627 | 87,867 | |||||||||||
| Deferred retirement Fund Contribution | 2,634,703 | 2,634,703 | - | Interest Expense | 11 | 142,556 | 73,083 | (69,473) | |||||||||||
| Accrued Annual Leave (Non-Current) | 1,330,206 | 1,384,194 | 53,988 | Annual Leave Expense | 182,500 | 177,717 | (4,783) | ||||||||||||
| Fund Balance | 38,987,868 | 37,567,226 | (1,420,642) | Depreciation Expense | 558,808 | 286,310 | (272,498) | ||||||||||||
| Total Liabilities & Fund Balance | 75,901,408 | 70,633,864 | (5,267,544) | Typhoon Expenses | 7,427 | 2 | (7,425) | ||||||||||||
| - | - | - | Gain/Loss on Disposal of Assets | - | |||||||||||||||
| Bioterrorism | 22,463 | 71,841 | 49,378 | ||||||||||||||||
| Cash Flow Statement | FEMA | - | |||||||||||||||||
| Fiscal Year 2005 | Fiscal Year 2006 | Compact Impact Expenses | 12 | 261,878 | 275,239 | 13,361 | |||||||||||||
| Beginning Cash Balance | 637,556 | 1,157,962 | Inventory Adjustment | 7,155 | 4,707 | (2,448) | |||||||||||||
| Cash Receipts | Total Expenditures | 16,733,502 | 18,069,365 | 1,335,863 | |||||||||||||||
| Patient Revenues | 56,610,717 | 8,262,465 | Non-Operating Revenues | ||||||||||||||||
| Other Receipts | 855,948 | 100,304 | Healthy Futures Fund | - | |||||||||||||||
| Tobacco Funds | FEMA | 71,149 | (71,149) | ||||||||||||||||
| Insurance Settlement | 730,844 | - | 684705 | ||||||||||||||||
| Compact Impact | 8,256,559 | 678,589 | Tobacco Funds | - | |||||||||||||||
| FEMA | 177,413 | - | Compact Impact | - | |||||||||||||||
| Healthy Futures | 4,791,666 | - | Bioterrorism | 13 | - | ||||||||||||||
| Bioterrorism | 340,465 | 247,402 | ANA Grant | - | |||||||||||||||
| ANA Grant | 12,362 | - | Contributions | 300 | (300) | ||||||||||||||
| GTA Sale Proceeds | 5,000,000 | - | Total Non-Operating Revenues | 71,449 | 684,705 | (71,449) | |||||||||||||
| Gov Guam GRT | 684,705 | Net Revenues Over/(Under) Expenditures | (2,518,046) | (1,767,525) | 65,816 | ||||||||||||||
| Citizens Saving Account | |||||||||||||||||||
| Total Cash Receipts | 76,775,974 | 9,973,465 | |||||||||||||||||
| Cash Disbursements | |||||||||||||||||||
| Salaries & Benefits | 45,165,333 | 7,984,894 | |||||||||||||||||
| Travel and Training | 149,149 | 51,282 | |||||||||||||||||
| Contractual Services | 9,635,419 | 1,049,042 | |||||||||||||||||
| Supplies & Materials | 16,273,422 | 1,100,124 | |||||||||||||||||
| Miscellaneous | 266,389 | 32,498 | |||||||||||||||||
| Utilities | 1,888,462 | 235,941 | |||||||||||||||||
| Capital Outlay | 2,431,725 | - | |||||||||||||||||
| Cost Report | - | - | |||||||||||||||||
| Retirement Funds Note | 125,543 | - | |||||||||||||||||
| GPA Note | 320,126 | 43,483 | |||||||||||||||||
| Total Cash Disbursements | 76,255,568 | 10,497,264 | |||||||||||||||||
| Ending Cash balance | 1,157,962 | 634,163 | |||||||||||||||||
| - | |||||||||||||||||||
| 3.62 | |||||||||||||||||||
| Current Ratio | 1.152831061 | 1.179071821 | |||||||||||||||||
| Cash to Debt | 2.079886513 | 0.301617147 | |||||||||||||||||
| Average Payment Period | 15.18 | 86.74 | |||||||||||||||||
| 09/29/04 | 09/30/05 | ||||||||||||||||||
| 11/30/04 | 11/30/05 | ||||||||||||||||||
| 62.00 | 61.00 | ||||||||||||||||||