| Balance Sheet (Unaudited) | Statement Of Revenues & Expenditures (Unaudited) (Accrual) | ||||||||||||||||||
| 11/30/05 | 11/30/06 | Variance | 11/30/05 | 11/30/06 | Variance | ||||||||||||||
| Assets | Revenues | ||||||||||||||||||
| Cash & Cash Equivalents | $687,924 | $1,172,689 | $484,764 | Gross Patient Revenues | $18,261,902 | $20,506,310 | $2,244,408 | ||||||||||||
| Accounts Receivable (Net) | 28,484,121 | 24,888,379 | (3,595,742) | Contractual Adjustments | (2,736,731) | (2,738,734) | (2,003) | ||||||||||||
| Due From Gov Guam | 10,090,858 | 9,829,909 | (260,950) | Bad Debts Expense | (5,302,627) | (6,473,371) | (1,170,744) | ||||||||||||
| Other Receivables | 851,213 | 715,671 | (135,542) | Net Patient Revenues | 10,222,544 | 11,294,205 | 1,071,661 | ||||||||||||
| Inventories | 2,020,810 | 4,513,297 | 2,492,487 | Other Revenues | 87,144 | 132,807 | 45,663 | ||||||||||||
| Prepaid Expenses | 510,231 | 365,883 | (144,348) | Total Revenues | $10,309,687 | $11,427,012 | $1,117,324 | ||||||||||||
| Property Plant and Equipment (Net) | 40,129,458 | 41,538,500 | 1,409,042 | ||||||||||||||||
| Total Assets | $82,774,616 | $83,024,327 | $249,711 | Expenditures | |||||||||||||||
| Salaries & Benefits | $7,797,653 | $8,528,318 | $730,666 | ||||||||||||||||
| Liabilities & Fund Balance | Travel | 10,719 | 29,296 | 18,577 | |||||||||||||||
| Accounts Payable (Trade) | $6,232,268 | $6,880,324 | $648,057 | Training | 1,870 | 8,513 | 6,643 | ||||||||||||
| Accounts Payable (Government) | 11,427,315 | 9,516,551 | (1,910,764) | Contractual Services | 1,025,206 | 770,101 | (255,105) | ||||||||||||
| Accrued Payroll & Benefits | 1,559,095 | 1,741,740 | 182,645 | Supplies & Materials | 1,595,830 | 1,821,103 | 225,273 | ||||||||||||
| Accrued Annual Leave, S/L (Current) | 2,120,439 | 2,388,828 | 268,388 | Minor Equipment | 15,456 | 15,057 | (399) | ||||||||||||
| Long-Term Debt (Current) | 6,860,977 | 6,862,143 | 1,167 | Miscellaneous | 807,134 | 147,133 | (660,001) | ||||||||||||
| Deferred Revenue | 10,368,035 | 8,995,679 | (1,372,357) | Utilities | 365,812 | 354,091 | (11,721) | ||||||||||||
| Deferred retirement Fund Contribution | 2,634,703 | 2,634,703 | - | Long Term Care Facility | 77,080 | 25,528 | (51,552) | ||||||||||||
| Accrued Annual Leave, S/L (Non-Current) | 1,806,300 | 2,034,927 | 228,627 | Interest Expense | 73,128 | 69,341 | (3,787) | ||||||||||||
| Fund Balance | 39,765,483 | 41,969,431 | 2,203,948 | Sick & Annual Leave Expense | 177,717 | 208,603 | 30,886 | ||||||||||||
| Depreciation Expense | 532,686 | 679,362 | 146,676 | ||||||||||||||||
| Total Liabilities & Fund Balance | $82,774,616 | $83,024,327 | $249,711 | Typhoon Expenses | - | - | |||||||||||||
| 0 | 0 | (0) | Gain/Loss on Disposal of Assets | - | - | ||||||||||||||
| Bioterrorism | 71,841 | 1,057,420 | 985,579 | ||||||||||||||||
| Cash Flow Statement | FEMA | - | - | - | |||||||||||||||
| 11/30/05 | 11/30/06 | Compact Impact Expenses | 261,675 | 39,855 | (221,821) | ||||||||||||||
| Beginning Cash Balance | $1,157,962 | $498,202 | Advanced Appropiration | - | 34,854 | 34,854 | |||||||||||||
| Inventory Adjustment | 4,707 | 19,682 | 14,975 | ||||||||||||||||
| Cash Receipts | Total Expenditures | $12,818,515 | $13,808,258 | $989,743 | |||||||||||||||
| Patient Revenues | $8,262,465 | $11,670,349 | |||||||||||||||||
| Other Receipts | 100,304 | 165,724 | |||||||||||||||||
| ANA Grant | - | - | Non-Operating Revenues | ||||||||||||||||
| Advanced Appropriations | - | - | FEMA | - | - | - | |||||||||||||
| Bioterrorism | 247,402 | - | Transfers from GovGuam | 668,362 | 1,107,171 | 438,808 | |||||||||||||
| Compact Impact | 678,589 | 61,194 | Compact Impact | - | 20,820 | 20,820 | |||||||||||||
| FMIP Reimbursement | - | 164,101 | Bioterrorism | - | - | ||||||||||||||
| Gov Guam GRT | 684,705 | 1,107,171 | ANA Grant | - | - | - | |||||||||||||
| Medicare Reimbursement FY03 MCR | 4,921,530 | Contributions | - | 28,490 | 28,490 | ||||||||||||||
| Total Cash Receipts | $9,973,465 | $18,090,069 | Total Non-Operating Revenues | $668,362 | $1,156,481 | $488,119 | |||||||||||||
| Net Revenues Over/(Under) Expenditures | (1,840,465) | (1,224,765) | 615,700 | ||||||||||||||||
| Cash Disbursements | |||||||||||||||||||
| Salaries & Benefits | 7,984,894 | $10,639,079 | |||||||||||||||||
| Travel and Training | 51,282 | 31,353 | |||||||||||||||||
| Contractual Services | 1,049,042 | 1,620,735 | |||||||||||||||||
| Supplies & Materials | 1,046,362 | 3,928,453 | |||||||||||||||||
| Miscellaneous | 32,498 | 85,471 | |||||||||||||||||
| Utilities | 235,942 | 466,941 | |||||||||||||||||
| Capital Outlay | - | 556,585 | |||||||||||||||||
| Retirement Funds Note | - | - | |||||||||||||||||
| GPA Note | 43,483 | 86,966 | |||||||||||||||||
| Total Cash Disbursements | $10,443,503 | $17,415,583 | |||||||||||||||||
| Ending Cash balance | $687,924 | $1,172,689 | |||||||||||||||||
| ($0) | (0.00) | 13560 | |||||||||||||||||
| - | |||||||||||||||||||
| Current Ratio | 1.422481674 | 1.336516989 | |||||||||||||||||
| Cash to Debt | 0 | 0 | |||||||||||||||||
| Average Payment Period | 10,961.45 | 5,956.45 | |||||||||||||||||
| 09/29/04 | 09/30/05 | ||||||||||||||||||
| 11/30/05 | 11/30/06 | ||||||||||||||||||
| 427.00 | 426.00 | ||||||||||||||||||