| Statement Of Revenues & Expenditures (Unaudited) | Cash Flow Statement | |||||||||||||||||||
| 10/31/06 | 10/31/07 | Variance | 10/31/06 | 10/31/07 | ||||||||||||||||
| Revenues | Beginning Cash Balance | $498,202 | $618,767 | |||||||||||||||||
| Gross Patient Revenues | $10,611,325 | $10,759,069 | $147,745 | |||||||||||||||||
| Contractual Adjustments | (1,389,776) | (3,315,333) | (1,925,557) | Cash Receipts | ||||||||||||||||
| Bad Debts Expense | (3,440,892) | (1,452,575) | 1,988,317 | Patient Revenues | $7,262,166 | $4,801,023 | ||||||||||||||
| Net Patient Revenues | 5,780,657 | 5,991,161 | 210,505 | Other Receipts | 121,847 | 100,193 | ||||||||||||||
| ` | Other Revenues | 52,895 | 82,752 | 29,857 | FEMA Assistance | - | 88,421 | |||||||||||||
| Total Revenues | $5,833,552 | $6,073,913 | $240,362 | Advanced Appropriations | - | - | ||||||||||||||
| Bioterrorism | - | - | ||||||||||||||||||
| Expenditures | Compact Impact | - | 143,996 | |||||||||||||||||
| Salaries & Benefits | $4,169,053 | $4,208,357 | $39,304 | FMIP Reimbursement | 164,101 | - | ||||||||||||||
| Travel | 27,534 | 23,772 | (3,762) | Subsidy- GRT (PL28-68) | - | 234,531 | ||||||||||||||
| Training | 14,113 | 3,645 | (10,468) | Subsidy- General Fund (PL29-02) | 743,436 | |||||||||||||||
| Contractual Services | 196,204 | 409,091 | 212,888 | Medicare Reimbursement | 4,921,530 | - | ||||||||||||||
| Supplies & Materials | 589,279 | 1,000,465 | 411,186 | Health Securities Trust Fund | - | |||||||||||||||
| Minor Equipment | 4,839 | 26,654 | 21,815 | Total Cash Receipts | $12,469,644 | $6,111,600 | ||||||||||||||
| Miscellaneous | 28,492 | 7,832 | (20,660) | |||||||||||||||||
| Utilities | 30,702 | 189,531 | 158,829 | Cash Disbursements | ||||||||||||||||
| Interest Expense | 69,341 | 80,100 | 10,759 | Salaries & Benefits | 4,805,627 | 4,954,831 | ||||||||||||||
| Sick & Annual Leave Expense | 71,127 | 105,551 | 34,424 | Travel and Training | 22,577 | 28,560 | ||||||||||||||
| Depreciation Expense | 336,153 | 348,293 | 12,140 | Contractual Services | 1,477,096 | 450,433 | ||||||||||||||
| Gain/Loss on Disposal of Assets | - | - | - | Supplies & Materials | 2,844,316 | 615,500 | ||||||||||||||
| ANA Grant | 269 | - | (269) | Miscellaneous | 7,033 | 36,695 | ||||||||||||||
| Bioterrorism Expenses | 32,699 | 57,759 | 25,060 | Utilities | 246,199 | 148,114 | ||||||||||||||
| FEMA Projects | - | 60,858 | 60,858 | Capital Outlay | 23,886 | - | ||||||||||||||
| FMIP Expense | - | - | - | Debt Service | 1,795,499 | - | ||||||||||||||
| Compact Impact Expenses | 39,855 | - | (39,855) | Total Cash Disbursements | $11,222,233 | $6,234,133 | ||||||||||||||
| Advanced Appropriation | 319,783 | 40,933 | (278,850) | Ending Cash balance | $1,745,613 | $496,235 | ||||||||||||||
| Inventory Adjustment | (67,548) | 43,571 | 111,119 | |||||||||||||||||
| Total Expenditures | $5,861,894 | $6,606,412 | $744,519 | |||||||||||||||||
| Accounts Receivable Aging | ||||||||||||||||||||
| Non-Operating Revenues | 10/31/07 | |||||||||||||||||||
| FEMA Assistance | - | - | - | 0 - 30 | 31 - 60 | 61 - 90 | Over 90 days | TOTAL | ||||||||||||
| GovGuam Reimbursement | - | 977,968 | 977,968 | Commercial | $3,546,557 | $3,055,337 | $806,722 | $4,990,654 | $12,399,270 | |||||||||||
| Compact Impact Funds | - | - | - | GovGuam | 117,759 | 120,237 | 109,964 | 3,031,500 | $3,379,460 | |||||||||||
| Bioterrorism Grant | - | - | - | MAP/Medicaid | 1,713,467 | 1,876,737 | 1,478,296 | 8,492,902 | $13,561,402 | |||||||||||
| ANA Grant | - | - | - | Medically Indigent Program | 1,341,873 | 1,255,140 | 945,639 | 8,402,925 | $11,945,577 | |||||||||||
| FMIP | - | - | - | Medicare | 2,983,420 | 742,311 | 239,953 | 3,137,840 | $7,103,524 | |||||||||||
| Contributions | 28,490 | - | (28,490) | Self Pay | 2,448,660 | 2,236,098 | 2,404,057 | 39,730,186 | $46,819,001 | |||||||||||
| Total Non-Operating Revenues | $28,490 | 977,968 | $949,478 | Total | $12,151,736 | $9,285,860 | $5,984,631 | $67,786,007 | $95,208,234 | |||||||||||
| Net Revenues Over/(Under) Expenditures | $148 | $445,469 | $445,321 | |||||||||||||||||
| Accounts Payable Aging | ||||||||||||||||||||
| 10/31/07 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | TOTAL | ||||||||||||||||
| House Doctors | $1,251 | $54,426 | $67,653 | $330,013 | $453,343 | |||||||||||||||
| Trade Payables | 1,031,899 | 1,805,980 | 1,685,939 | 1,701,213 | 6,225,032 | |||||||||||||||
| Payroll Payables | - | |||||||||||||||||||
| - Gov Ret Fund DBP | - | |||||||||||||||||||
| - Gov Ret Fund DCP | - | |||||||||||||||||||
| - Dept of Rev & Tax | - | |||||||||||||||||||
| GTA | 25,968 | 27,177 | 53,144 | |||||||||||||||||
| GPA | 165,418 | 165,418 | ||||||||||||||||||
| GWA | 30,144 | 27,110 | 57,254 | |||||||||||||||||
| Unbilled PO Receipts | 455,338 | 455,338 | ||||||||||||||||||
| Total | $1,653,906 | $1,916,518 | $1,807,879 | $2,031,226 | $7,409,530 | |||||||||||||||
| 10/31/07 | ||||||||||||||||||||