| Balance Sheet (Unaudited) | Statement Of Revenues & Expenditures (Unaudited) (Accrual) | ||||||||||||||||||
| 08/31/05 | 08/31/06 | Variance | 08/31/05 | 08/31/06 | Variance | ||||||||||||||
| Assets | Revenues | ||||||||||||||||||
| Cash & Cash Equivalents | 2,586,458 | 425,399 | (2,161,060) | Gross Patient Revenues | 93,697,196 | 101,256,097 | 7,558,901 | ||||||||||||
| Accounts Receivable (Net) | 24,873,461 | 30,002,796 | 5,129,335 | Contractual Adjustments | (13,865,393) | (15,173,552) | (1,308,159) | ||||||||||||
| Due From Gov Guam | 2,270,379 | 7,877,314 | 5,606,935 | Bad Debt Expense | (27,947,233) | (29,544,227) | (1,596,994) | ||||||||||||
| Other Receivables | 592,083 | 631,735 | 39,652 | Net Patient Revenues | 51,884,570 | 56,538,318 | 4,653,748 | ||||||||||||
| Inventories | 2,207,418 | 4,024,721 | 1,817,303 | Other Revenues | 518,496 | 519,193 | 697 | ||||||||||||
| Prepaid Expenses | 431,224 | 490,832 | 59,608 | Total Revenues | 52,403,066 | 57,057,511 | 4,654,445 | ||||||||||||
| Property Plant and Equipment (Net) | 39,941,783 | 41,530,543 | 1,588,760 | Bioterrorism | |||||||||||||||
| Total Assets | 72,902,807 | 84,983,340 | 12,080,533 | Expenditures | |||||||||||||||
| Due From Gov Guam | Salaries & Benefits | 38,945,368 | 45,120,249 | 6,174,881 | |||||||||||||||
| Liabilities & Fund Balance | Travel | 100,814 | 90,511 | (10,303) | |||||||||||||||
| Accounts Payable (Trade) | 6,694,408 | 11,953,233 | 5,258,825 | Training | 50,118 | 56,328 | 6,210 | ||||||||||||
| Accounts Payable (Government) | 9,097,504 | 10,843,004 | 1,745,500 | Contractual Services | 7,912,320 | 6,269,459 | (1,642,862) | ||||||||||||
| Accrued Payroll & Benefits | - | - | - | Supplies & Materials | 11,124,446 | 10,688,596 | (435,850) | ||||||||||||
| Accrued Annual Leave (Current) | 1,467,113 | 1,782,997 | 315,883 | Minor Equipment | 241,692 | 90,903 | (150,789) | ||||||||||||
| Long-Term Debt (Current) | 6,426,995 | 6,731,221 | 304,226 | Miscellaneous | 1,416,304 | 980,504 | (435,799) | ||||||||||||
| Deferred Revenue | 2,754,276 | 7,990,077 | 5,235,802 | Utilities | 1,405,145 | 1,581,176 | 176,031 | ||||||||||||
| Deferred retirement Fund Contribution | 2,634,703 | 2,634,703 | - | Long Term Care Facility | 243,044 | 262,412 | 19,367 | ||||||||||||
| Accrued Annual Leave (Non-Current) | 1,249,763 | 1,518,849 | 269,086 | Interest Expense | 904,565 | 1,101,396 | 196,831 | ||||||||||||
| Accrued Sick Leave | 884,223 | 1,020,376 | 136,153 | Annual Leave Expense | 389,139 | 707,085 | 317,946 | ||||||||||||
| Fund Balance | 41,693,821 | 40,508,879 | (1,184,942) | Depreciation Expense | 2,995,685 | 3,077,030 | 81,345 | ||||||||||||
| Total Liabilities & Fund Balance | 72,902,807 | 84,983,340 | 12,080,533 | Typhoon Expenses | - | ||||||||||||||
| 0 | 0 | - | Gain/Loss on Disposal of Assets | (3,000) | 11,270 | 14,270 | |||||||||||||
| Bioterrorism | 89,974 | 507,973 | 417,999 | ||||||||||||||||
| Cash Flow Statement | FEMA | 4,855 | 131,437 | 126,582 | |||||||||||||||
| 8/31/2005 | 8/31/2006 | Compact Impact Expenses | 1,134,667 | 311,439 | (823,228) | ||||||||||||||
| Beginning Cash Balance | 631,237 | 1,157,962 | Advanced Appropiration | 91,185 | 91,185 | ||||||||||||||
| Cash Receipts | Inventory Adjustment | 47,014 | 93,820 | 46,806 | |||||||||||||||
| Patient Revenues | 51,352,143 | 53,216,798 | Total Expenditures | 67,002,149 | 71,172,772 | 4,170,623 | |||||||||||||
| Other Receipts | 805,804 | 666,551 | Non-Operating Revenues | ||||||||||||||||
| Tobacco Funds | Healthy Futures Fund | 3,110,927 | - | (3,110,927) | |||||||||||||||
| Insurance Settlement | 730,844 | - | FEMA | 575,660 | 144,553 | (431,107) | |||||||||||||
| Compact Impact | 8,105,769 | 4,624,690 | Transfers from GovGuam | 5,583,657 | 10,584,478 | 5,000,821 | |||||||||||||
| FEMA | 177,413 | 184,424 | Tobacco Funds | - | - | ||||||||||||||
| Healthy Futures | 2,841,666 | - | Compact Impact | 5,430,040 | 2,203,841 | (3,226,199) | |||||||||||||
| Health Securities Trust Fund | 183,130 | Bioterrorism | - | - | |||||||||||||||
| Bioterrorism | 340,465 | 646,460 | ANA Grant | 21,927 | 6,240 | (15,687) | |||||||||||||
| ANA Grant | 12,362 | 5,713 | Contributions | 64,779 | 79,080 | 14,301 | |||||||||||||
| GTA Sale Proceeds | 5,000,000 | - | Total Non-Operating Revenues | 14,786,990 | 13,018,192 | (1,768,798) | |||||||||||||
| Gov Guam GRT | 7,145,955 | Net Revenues Over/(Under) Expenditures | 187,907 | (1,097,069) | (1,284,976) | ||||||||||||||
| Citizens Saving Account | |||||||||||||||||||
| Total Cash Receipts | 69,366,466 | 66,673,721 | |||||||||||||||||
| Cash Disbursements | |||||||||||||||||||
| Salaries & Benefits | 39,482,957 | 45,069,256 | |||||||||||||||||
| Travel and Training | 145,587 | 184,119 | |||||||||||||||||
| Contractual Services | 8,373,159 | 4,807,084 | |||||||||||||||||
| Supplies & Materials | 14,635,172 | 12,076,723 | |||||||||||||||||
| Miscellaneous | 244,212 | 776,858 | |||||||||||||||||
| Utilities | 1,698,100 | 1,729,210 | |||||||||||||||||
| Capital Outlay | 2,431,725 | 2,328,205 | |||||||||||||||||
| Retirement Funds Note | 125,543 | - | |||||||||||||||||
| GPA Note | 274,790 | 434,830 | |||||||||||||||||
| Total Cash Disbursements | 67,411,245 | 67,406,285 | |||||||||||||||||
| Ending Cash balance | 2,586,458 | 425,399 | |||||||||||||||||
| (0.09) | 0.47 | ||||||||||||||||||
| 17.99 | |||||||||||||||||||
| Current Ratio | 1.280180458 | 1.243586001 | |||||||||||||||||
| Cash to Debt | 2.222644062 | 1.49914625 | |||||||||||||||||
| Average Payment Period | 78.71 | 113.29 | |||||||||||||||||
| 09/29/04 | 09/30/05 | ||||||||||||||||||
| 08/31/05 | 08/31/06 | ||||||||||||||||||
| 336.00 | 335.00 | ||||||||||||||||||