| Statement Of Revenues & Expenditures (Unaudited) | Cash Flow Statement | |||||||||||||||||||
| 12/31/06 | 12/31/07 | Variance | 12/31/06 | 12/31/07 | ||||||||||||||||
| Revenues | Beginning Cash Balance | $498,202 | $618,767 | |||||||||||||||||
| Gross Patient Revenues | $29,725,715 | $31,210,682 | $1,484,967 | |||||||||||||||||
| Contractual Adjustments | (3,847,214) | (9,688,113) | (5,840,899) | Cash Receipts | ||||||||||||||||
| Bad Debts Expense | (9,439,423) | (3,380,170) | 6,059,253 | Patient Revenues | $17,234,996 | $13,667,028 | ||||||||||||||
| Net Patient Revenues | 16,439,078 | 18,142,399 | 1,703,321 | Other Receipts | 214,234 | 220,088 | ||||||||||||||
| ` | Other Revenues | 166,339 | 829,354 | 663,015 | FEMA Assistance | 43,107 | 144,022 | |||||||||||||
| Total Revenues | $16,605,417 | $18,971,753 | $2,366,337 | Advanced Appropriations | - | - | ||||||||||||||
| Bioterrorism | 57,678 | 445,669 | ||||||||||||||||||
| Expenditures | Compact Impact | 61,194 | 143,996 | |||||||||||||||||
| Salaries & Benefits | $12,684,400 | $13,507,451 | $823,051 | FMIP Reimbursement | 164,101 | - | ||||||||||||||
| Travel | 31,546 | 23,324 | (8,222) | GovGuam Reimbursement- GRT | 1,733,964 | 3,650,239 | ||||||||||||||
| Training | 8,513 | 8,128 | (385) | Health Securities Trust Fund | 743,436 | |||||||||||||||
| Contractual Services | 1,427,386 | 1,356,266 | (71,120) | Medicare Reimbursement | 5,093,962 | - | ||||||||||||||
| Supplies & Materials | 2,569,128 | 2,966,103 | 396,975 | GMHP Settlement | - | 595,865 | ||||||||||||||
| Minor Equipment | 21,629 | 43,446 | 21,817 | Total Cash Receipts | $24,603,236 | $19,610,343 | ||||||||||||||
| Miscellaneous | 103,107 | 66,330 | (36,778) | |||||||||||||||||
| Utilities | 576,505 | 534,212 | (42,293) | Cash Disbursements | ||||||||||||||||
| Interest Expense | 239,999 | 317,696 | 77,697 | Salaries & Benefits | 14,097,760 | 15,742,653 | ||||||||||||||
| Sick & Annual Leave Expense | 290,122 | 242,961 | (47,162) | Travel and Training | 31,352 | 51,854 | ||||||||||||||
| Depreciation Expense | 1,022,639 | 1,042,933 | 20,295 | Contractual Services | 1,940,516 | 853,236 | ||||||||||||||
| Gain/Loss on Disposal of Assets | - | - | - | Supplies & Materials | 5,213,907 | 1,686,660 | ||||||||||||||
| ANA Grant | 2,560 | - | (2,560) | Miscellaneous | 90,443 | 104,353 | ||||||||||||||
| Bioterrorism Expenses | 113,183 | 296,019 | 182,835 | Utilities | 513,057 | 490,219 | ||||||||||||||
| FEMA Projects | 48,390 | 143,494 | 95,104 | Capital Outlay | 556,585 | 140,186 | ||||||||||||||
| FMIP Expense | - | - | - | Debt Service | 2,054,238 | - | ||||||||||||||
| Compact Impact Expenses | 70,799 | 70,890 | 92 | Total Cash Disbursements | $24,497,858 | $19,069,161 | ||||||||||||||
| Advanced Appropriation | 282,866 | 296,461 | 13,595 | Ending Cash balance | $603,580 | $1,159,950 | ||||||||||||||
| Inventory Adjustment | (47,662) | 82,980 | 130,642 | |||||||||||||||||
| Total Expenditures | $19,445,110 | $20,998,694 | $1,553,584 | |||||||||||||||||
| Accounts Receivable Aging | ||||||||||||||||||||
| Non-Operating Revenues | 12/31/07 | |||||||||||||||||||
| FEMA Assistance | - | - | - | 0 - 30 | 31 - 60 | 61 - 90 | Over 90 days | TOTAL | ||||||||||||
| GovGuam Reimbursement | 1,733,964 | 4,393,676 | 2,659,711 | Commercial | $2,857,462 | $1,911,043 | $1,275,454 | $5,375,221 | $11,419,180 | |||||||||||
| Compact Impact Funds | 20,820 | - | (20,820) | GovGuam | 80,744 | 68,177 | 112,312 | 3,156,107 | $3,417,341 | |||||||||||
| Bioterrorism Grant | 57,678 | - | (57,678) | MAP/Medicaid | 1,493,807 | 1,547,808 | 1,896,489 | 12,383,189 | $17,321,294 | |||||||||||
| ANA Grant | - | - | - | Medically Indigent Program | 1,076,150 | 1,601,399 | 1,237,320 | 10,794,633 | $14,709,502 | |||||||||||
| FMIP | - | - | - | Medicare | 2,713,419 | 1,075,042 | 1,117,581 | 4,901,739 | $9,807,780 | |||||||||||
| Contributions | 28,490 | 200 | (28,290) | Self Pay | 2,341,158 | 1,849,536 | 1,803,849 | 43,790,358 | $49,784,901 | |||||||||||
| Total Non-Operating Revenues | $1,840,952 | 4,393,876 | $2,552,923 | Total | $10,562,741 | $8,053,005 | $7,443,004 | $80,401,247 | $106,459,997 | |||||||||||
| Net Revenues Over/(Under) Expenditures | ($998,741) | $2,366,935 | $3,365,676 | |||||||||||||||||
| Accounts Payable Aging | ||||||||||||||||||||
| 12/31/07 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | TOTAL | ||||||||||||||||
| House Doctors | $15,662 | $18,659 | $104,053 | $421,970 | $560,344 | |||||||||||||||
| Trade Payables | 1,589,712 | 1,308,547 | 1,882,564 | 3,431,280 | 8,212,102 | |||||||||||||||
| Payroll Payables | 185,443 | 185,443 | ||||||||||||||||||
| - Gov Ret Fund DBP | 168,849 | 168,849 | ||||||||||||||||||
| - Gov Ret Fund DCP | - | |||||||||||||||||||
| - Dept of Rev & Tax | 211,455 | 211,455 | ||||||||||||||||||
| GTA | 278 | 429 | 26,398 | 27,104 | ||||||||||||||||
| GPA | 144,843 | 144,843 | ||||||||||||||||||
| GWA | 25,566 | 38,993 | 28,684 | 113 | 93,357 | |||||||||||||||
| Unbilled PO Receipts | 445,738 | 445,738 | ||||||||||||||||||
| Total | $2,642,425 | $1,511,320 | $2,015,729 | $3,879,761 | $10,049,235 | |||||||||||||||
| 12/31/07 | ||||||||||||||||||||