| Statement Of Revenues & Expenditures (Unaudited) | Cash Flow Statement | |||||||||||||||||||
| 09/30/06 | 09/30/07 | Variance | 09/30/06 | 09/30/07 | ||||||||||||||||
| Revenues | Beginning Cash Balance | $1,157,962 | $498,202 | |||||||||||||||||
| Gross Patient Revenues | $110,844,878 | $120,783,387 | $9,938,509 | |||||||||||||||||
| Contractual Adjustments | (11,687,947) | (26,770,619) | (15,082,672) | Cash Receipts | ||||||||||||||||
| Bad Debts Expense | (33,097,039) | (26,630,181) | 6,466,857 | Patient Revenues | $57,350,617 | $62,952,072 | ||||||||||||||
| Net Patient Revenues | 66,059,892 | 67,382,586 | 1,322,694 | Other Receipts | 743,678 | 718,671 | ||||||||||||||
| Other Revenues | 571,145 | 941,948 | 370,803 | FEMA Assistance | 184,424 | 43,107 | ||||||||||||||
| Total Revenues | $66,631,037 | $68,324,534 | $1,693,497 | Advanced Appropriations | 5,713 | 1,225,029 | ||||||||||||||
| Bioterrorism | 646,460 | 587,566 | ||||||||||||||||||
| Expenditures | Compact Impact | 5,081,026 | 4,666,372 | |||||||||||||||||
| Salaries & Benefits | $50,697,287 | $56,624,938 | $5,927,651 | FMIP Reimbursement | 222,174 | |||||||||||||||
| Travel | 120,793 | 108,179 | (12,614) | Subsidy- GRT (PL28-68) | 8,421,521 | 9,813,754 | ||||||||||||||
| Training | 62,095 | 79,454 | 17,359 | Subsidy- General Fund (PL29-02) | 3,601,660 | |||||||||||||||
| Contractual Services | 8,599,142 | 7,498,181 | (1,100,961) | Medicare Reimbursement | 1,457,016 | 9,443,043 | ||||||||||||||
| Supplies & Materials | 11,856,157 | 12,893,982 | 1,037,825 | Health Securities Trust Fund | 466,260 | |||||||||||||||
| Minor Equipment | 104,997 | 403,492 | 298,495 | Total Cash Receipts | $74,356,715 | $93,273,448 | ||||||||||||||
| Miscellaneous | 153,250 | 219,734 | 66,484 | |||||||||||||||||
| Utilities | 2,188,599 | 2,456,621 | 268,022 | Cash Disbursements | ||||||||||||||||
| Interest Expense | 2,323,273 | 1,029,395 | (1,293,879) | Salaries & Benefits | 49,766,742 | 58,779,154 | ||||||||||||||
| Sick & Annual Leave Expense | 646,782 | 725,411 | 78,629 | Travel and Training | 200,856 | 141,145 | ||||||||||||||
| Depreciation Expense | 3,807,828 | 4,823,587 | 1,015,759 | Contractual Services | 5,240,070 | 6,424,330 | ||||||||||||||
| Gain/Loss on Disposal of Assets | 15,892 | 236,846 | 220,953 | Supplies & Materials | 14,179,700 | 18,295,963 | ||||||||||||||
| ANA Grant | 47,200 | 2,693 | (44,507) | Miscellaneous | 805,679 | 558,627 | ||||||||||||||
| Bioterrorism Expenses | 43,329 | 163,767 | 120,438 | Utilities | 2,016,910 | 2,199,471 | ||||||||||||||
| FEMA Projects | 131,437 | 99,252 | (32,185) | Capital Outlay | 2,328,205 | 2,319,865 | ||||||||||||||
| FMIP Expense | - | 58,073 | 58,073 | Debt Service | 478,313 | 4,440,054 | ||||||||||||||
| Compact Impact Expenses | 157,810 | 333,200 | 175,391 | Total Cash Disbursements | $75,016,475 | $93,158,609 | ||||||||||||||
| Advanced Appropriation | 71,937 | 1,178,176 | 1,106,239 | Ending Cash balance | $498,202 | $613,042 | ||||||||||||||
| Inventory Adjustment | 198,426 | 136,467 | (61,959) | |||||||||||||||||
| Total Expenditures | $81,226,234 | $89,071,448 | $7,845,214 | |||||||||||||||||
| Accounts Receivable Aging | ||||||||||||||||||||
| Non-Operating Revenues | 09/30/07 | |||||||||||||||||||
| FEMA Assistance | 144,553 | 474,277 | 329,724 | 0 - 30 | 31 - 60 | 61 - 90 | Over 90 days | TOTAL | ||||||||||||
| GovGuam Reimbursement | 14,420,860 | 14,796,669 | 375,808 | Commercial | $4,480,166 | $1,664,937 | $713,220 | $5,305,176 | $12,163,498 | |||||||||||
| Compact Impact Funds | 4,531,421 | 4,596,139 | 64,718 | GovGuam | 93,345 | 99,267 | 166,707 | 2,719,109 | 3,078,428 | |||||||||||
| Bioterrorism Grant | 615,628 | 455,224 | (160,404) | MAP/Medicaid | 1,793,053 | 1,416,702 | 1,483,810 | 8,574,385 | 13,267,949 | |||||||||||
| ANA Grant | 47,200 | - | (47,200) | Medically Indigent Program | 1,266,030 | 852,902 | 1,376,647 | 7,163,115 | 10,658,695 | |||||||||||
| FMIP | 164,101 | 58,073 | (106,028) | Medicare | 2,435,994 | 403,442 | 258,059 | 3,906,265 | 7,003,761 | |||||||||||
| Contributions | 74,430 | 92,456 | 18,026 | Self Pay | 2,932,219 | 2,278,921 | 1,642,128 | 37,448,404 | 44,301,671 | |||||||||||
| Total Non-Operating Revenues | $19,998,193 | 20,472,838 | $474,644 | Total | $13,000,807 | $6,716,171 | $5,640,571 | $65,116,453 | $90,474,002 | |||||||||||
| Net Revenues Over/(Under) Expenditures | $5,402,996 | ($274,077) | ($5,677,072) | |||||||||||||||||
| Accounts Payable Aging | ||||||||||||||||||||
| 09/30/07 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | TOTAL | ||||||||||||||||
| House Doctors | $30,828 | $26,528 | $51,424 | $301,429 | $410,209 | |||||||||||||||
| Trade Payables | 1,230,475 | 1,522,357 | 1,430,746 | 667,277 | 4,850,854 | |||||||||||||||
| Payroll Payables | - | |||||||||||||||||||
| - Gov Ret Fund DBP | 164,599 | 164,599 | ||||||||||||||||||
| - Gov Ret Fund DCP | - | |||||||||||||||||||
| - Dept of Rev & Tax | - | |||||||||||||||||||
| GTA | 27,177 | 27,177 | ||||||||||||||||||
| GPA | 148,114 | 313,533 | 461,647 | |||||||||||||||||
| GWA | 30,144 | 27,110 | 57,254 | |||||||||||||||||
| Unbilled PO Receipts | 86,717 | 86,717 | ||||||||||||||||||
| Total | $1,690,876 | $1,916,705 | $1,482,169 | $968,706 | $6,058,457 | |||||||||||||||
| 12 | ||||||||||||||||||||
| 2007 | ||||||||||||||||||||
| 09/30/07 | ||||||||||||||||||||