| Statement Of Revenues & Expenditures (Unaudited) | Cash Flow Statement | |||||||||||||||||
| 03/31/07 | 03/31/08 | Variance | 03/31/07 | 03/31/08 | ||||||||||||||
| Revenues | Beginning Cash Balance | $498,202 | $618,767 | |||||||||||||||
| Gross Patient Revenues | $59,451,226 | $61,252,778 | $1,801,552 | |||||||||||||||
| Contractual Adjustments | (8,810,813) | (20,302,703) | (11,491,890) | Cash Receipts | ||||||||||||||
| Bad Debts Expense | (16,828,566) | (9,124,542) | 7,704,024 | Patient Revenues | $34,858,801 | $30,946,089 | ||||||||||||
| Net Patient Revenues | 33,811,847 | 31,825,533 | (1,986,314) | Other Receipts | 382,306 | 393,063 | ||||||||||||
| ` | Other Revenues | 327,832 | 1,544,148 | 1,216,316 | FEMA Assistance | 43,107 | 349,735 | |||||||||||
| Total Revenues | $34,139,680 | $33,369,681 | ($769,999) | Medicare Reimbursement | 4,522,765 | (687,179) | ||||||||||||
| Bioterrorism | 355,133 | 575,298 | ||||||||||||||||
| Expenditures | Compact Impact | 291,348 | 6,168,231 | |||||||||||||||
| Salaries & Benefits | $25,663,951 | $29,376,823 | $3,712,871 | FMIP Reimbursement | 164,101 | - | ||||||||||||
| Travel | 45,178 | 47,570 | 2,391 | GovGuam Reimbursement- GRT | 4,279,921 | 5,144,252 | ||||||||||||
| Training | 33,939 | 13,658 | (20,282) | Health Securities Trust Fund | 743,436 | |||||||||||||
| Contractual Services | 3,278,342 | 3,630,422 | 352,080 | UPCA Settlement | - | 75,000 | ||||||||||||
| Supplies & Materials | 5,529,048 | 6,226,416 | 697,368 | GMHP Settlement | - | 900,659 | ||||||||||||
| Minor Equipment | 113,941 | 268,796 | 154,855 | Total Cash Receipts | $44,897,482 | $44,608,584 | ||||||||||||
| Miscellaneous | 178,371 | 139,107 | (39,263) | |||||||||||||||
| Utilities | 1,162,183 | 1,240,351 | 78,168 | Cash Disbursements | ||||||||||||||
| Interest Expense | 484,022 | 589,330 | 105,308 | Salaries & Benefits | 28,655,199 | 30,190,388 | ||||||||||||
| Sick & Annual Leave Expense | 612,351 | 493,311 | (119,040) | Travel and Training | 56,245 | 78,447 | ||||||||||||
| Depreciation Expense | 2,050,285 | 2,057,544 | 7,259 | Contractual Services | 2,990,405 | 2,276,916 | ||||||||||||
| Gain/Loss on Disposal of Assets | - | - | - | Supplies & Materials | 8,948,307 | 10,387,678 | ||||||||||||
| ANA Grant | 2,693 | - | (2,693) | Miscellaneous | 178,936 | 150,343 | ||||||||||||
| Bioterrorism Expenses | 243,232 | 319,188 | 75,956 | Utilities | 1,087,836 | 1,093,676 | ||||||||||||
| FEMA Projects | 383,395 | 447,528 | 64,133 | Capital Outlay | 956,312 | 741,054 | ||||||||||||
| Compact Impact Expenses | 90,374 | 119,813 | 29,440 | Debt Service | 2,185,598 | - | ||||||||||||
| Advanced Appropriation | 383,212 | - | (383,212) | Total Cash Disbursements | $45,058,838 | $44,918,502 | ||||||||||||
| Inventory Adjustment | 19,760 | 156,339 | 136,579 | Ending Cash balance | $336,846 | $308,850 | ||||||||||||
| Total Expenditures | $40,274,277 | $45,126,196 | $4,851,919 | |||||||||||||||
| Non-Operating Revenues | Accounts Payable Aging | |||||||||||||||||
| FEMA Assistance | - | 225,527 | 225,527 | 03/31/08 | ||||||||||||||
| GovGuam Reimbursement | 4,279,922 | 5,887,688 | 1,607,766 | 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | TOTAL | ||||||||||
| Compact Impact Funds | 40,395 | 6,074,374 | 6,033,979 | House Doctors | $4,091 | $12,921 | $26,201 | $548,245 | $591,458 | |||||||||
| Bioterrorism Grant | 57,678 | 133,873 | 76,196 | Trade Payables | 1,025,691 | 749,789 | 359,493 | 1,192,483 | 3,327,455 | |||||||||
| FMIP | 58,073 | - | (58,073) | Payroll Payables | - | - | ||||||||||||
| Contributions | 28,790 | 400 | (28,390) | - Gov Ret Fund DBP | 158,098 | 158,098 | ||||||||||||
| Total Non-Operating Revenues | 4,464,858 | 12,321,863 | 7,857,004 | - Gov Ret Fund DCP | 167,398 | 167,398 | ||||||||||||
| Net Revenues Over/(Under) Expenditures | ($1,669,739) | $565,347 | ($1,104,392) | - Dept of Rev & Tax | 408,944 | 408,944 | ||||||||||||
| GTA | - | 23,931 | 24,325 | 48,256 | ||||||||||||||
| GPA | - | - | ||||||||||||||||
| GWA | 31,125 | 29,076 | 60,201 | |||||||||||||||
| Unbilled PO Receipts | 813,862 | 813,862 | ||||||||||||||||
| Total | $2,609,208 | $815,717 | $410,018 | $1,740,728 | $5,575,672 | |||||||||||||
| 02/28/08 | ||||||||||||||||||