| Statement Of Revenues & Expenditures (Unaudited) | Cash Flow Statement | |||||||||||||||||||
| 11/30/06 | 11/30/07 | Variance | 11/30/06 | 11/30/07 | ||||||||||||||||
| Revenues | Beginning Cash Balance | $498,202 | $618,767 | |||||||||||||||||
| Gross Patient Revenues | $20,509,542 | $20,825,861 | $316,319 | |||||||||||||||||
| Contractual Adjustments | (2,738,734) | (6,805,659) | (4,066,925) | Cash Receipts | ||||||||||||||||
| Bad Debts Expense | (6,473,371) | (2,693,628) | 3,779,743 | Patient Revenues | $11,670,349 | $8,964,607 | ||||||||||||||
| Net Patient Revenues | 11,297,437 | 11,326,574 | 29,137 | Other Receipts | 165,724 | 174,173 | ||||||||||||||
| ` | Other Revenues | 129,574 | 773,012 | 643,437 | FEMA Assistance | - | 144,022 | |||||||||||||
| Total Revenues | $11,427,012 | $12,099,586 | $672,575 | Advanced Appropriations | - | - | ||||||||||||||
| Bioterrorism | - | 284,087 | ||||||||||||||||||
| Expenditures | Compact Impact | 61,194 | 143,996 | |||||||||||||||||
| Salaries & Benefits | $8,528,318 | $8,911,637 | $383,319 | FMIP Reimbursement | 164,101 | - | ||||||||||||||
| Travel | 31,046 | 28,138 | (2,907) | GovGuam Reimbursement- GRT | 1,107,171 | 1,750,239 | ||||||||||||||
| Training | 8,513 | 8,128 | (385) | Health Securities Trust Fund | 743,436 | |||||||||||||||
| Contractual Services | 721,196 | 939,297 | 218,100 | Medicare Reimbursement | 4,921,530 | - | ||||||||||||||
| Supplies & Materials | 1,816,388 | 1,932,135 | 115,747 | GMHP Settlement | - | 595,865 | ||||||||||||||
| Minor Equipment | 14,010 | 40,566 | 26,556 | Total Cash Receipts | $18,090,069 | $12,800,425 | ||||||||||||||
| Miscellaneous | 34,721 | 7,805 | (26,916) | |||||||||||||||||
| Utilities | 379,620 | 349,763 | (29,857) | Cash Disbursements | ||||||||||||||||
| Interest Expense | 69,341 | 238,010 | 168,670 | Salaries & Benefits | 8,887,063 | 10,812,239 | ||||||||||||||
| Sick & Annual Leave Expense | 208,603 | 164,436 | (44,167) | Travel and Training | 31,352 | 47,879 | ||||||||||||||
| Depreciation Expense | 679,362 | 696,354 | 16,992 | Contractual Services | 1,620,735 | 629,357 | ||||||||||||||
| Gain/Loss on Disposal of Assets | - | - | - | Supplies & Materials | 3,928,453 | 1,115,994 | ||||||||||||||
| ANA Grant | 1,047 | - | (1,047) | Miscellaneous | 85,471 | 75,357 | ||||||||||||||
| Bioterrorism Expenses | 79,878 | 113,561 | 33,683 | Utilities | 466,941 | 370,828 | ||||||||||||||
| FEMA Projects | - | 60,858 | 60,858 | Capital Outlay | 556,585 | 60,858 | ||||||||||||||
| FMIP Expense | - | - | - | Debt Service | 1,838,982 | - | ||||||||||||||
| Compact Impact Expenses | 39,855 | 113,501 | 73,646 | Total Cash Disbursements | $17,415,582 | $13,112,512 | ||||||||||||||
| Advanced Appropriation | 34,854 | 218,553 | 183,699 | Ending Cash balance | $1,172,689 | $306,681 | ||||||||||||||
| Inventory Adjustment | (61,235) | 57,851 | 119,087 | |||||||||||||||||
| Total Expenditures | $12,585,516 | $13,880,593 | $1,295,077 | |||||||||||||||||
| Accounts Receivable Aging | ||||||||||||||||||||
| Non-Operating Revenues | 11/30/07 | |||||||||||||||||||
| FEMA Assistance | - | - | - | 0 - 30 | 31 - 60 | 61 - 90 | Over 90 days | TOTAL | ||||||||||||
| GovGuam Reimbursement | 1,107,171 | 2,493,676 | 1,386,505 | Commercial | $2,841,437 | $2,781,326 | $1,304,096 | $5,535,753 | $12,462,612 | |||||||||||
| Compact Impact Funds | 20,820 | - | (20,820) | GovGuam | 31,929 | 71,854 | 31,421 | 2,869,531 | $3,004,735 | |||||||||||
| Bioterrorism Grant | - | - | - | MAP/Medicaid | 1,529,812 | 2,078,441 | 2,035,803 | 10,197,904 | $15,841,961 | |||||||||||
| ANA Grant | - | - | - | Medically Indigent Program | 1,578,336 | 1,190,382 | 1,327,134 | 9,352,944 | $13,448,796 | |||||||||||
| FMIP | - | - | - | Medicare | 2,837,629 | 1,148,685 | 505,273 | 4,279,862 | $8,771,449 | |||||||||||
| Contributions | 28,490 | - | (28,490) | Self Pay | 2,225,268 | 1,711,840 | 2,344,325 | 41,284,812 | $47,566,245 | |||||||||||
| Total Non-Operating Revenues | $1,156,481 | 2,493,676 | $1,337,195 | Total | $11,044,412 | $8,982,527 | $7,548,052 | $73,520,806 | $101,095,798 | |||||||||||
| Net Revenues Over/(Under) Expenditures | ($2,023) | $712,669 | $714,692 | |||||||||||||||||
| Accounts Payable Aging | ||||||||||||||||||||
| 11/30/07 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | TOTAL | ||||||||||||||||
| House Doctors | $14,861 | $56,190 | $433,901 | $504,952 | ||||||||||||||||
| Trade Payables | 881,774 | 1,388,807 | 928,753 | 3,550,362 | 6,749,697 | |||||||||||||||
| Payroll Payables | 185,443 | 185,443 | ||||||||||||||||||
| - Gov Ret Fund DBP | - | |||||||||||||||||||
| - Gov Ret Fund DCP | - | |||||||||||||||||||
| - Dept of Rev & Tax | 228,854 | 221,154 | 450,008 | |||||||||||||||||
| GTA | 25,968 | 25,968 | ||||||||||||||||||
| GPA | - | |||||||||||||||||||
| GWA | 1,507 | 37,419 | 28,684 | 67,610 | ||||||||||||||||
| Unbilled PO Receipts | 405,649 | 405,649 | ||||||||||||||||||
| Total | $1,703,227 | $1,662,242 | $1,039,594 | $3,984,263 | $8,389,326 | |||||||||||||||
| 11/30/07 | ||||||||||||||||||||