Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2006 FY 2006 FY 2006 12/31/06
    Approved   3 Month Budget   3 Month Actual       Gross Billings Bad Debt Collections
Patient  Revenues            53,258,165               13,314,541              13,610,040 Medically Indigent Program         996,013.00            3,048.00    1,432,174.00
Cafeteria Sales              600,000                  150,000                 174,556 Medicaid      1,434,273.00           22,651.00       787,920.00
HRSA Grant   Medicare      2,190,724.00           16,994.00       691,093.00
Healthy Futures           4,000,000               1,000,000   Pacificare         735,894.00            1,119.00       553,998.00
Healthy Futures - Pt Education   Staywell      1,284,262.00       893,953.00
Compact Impact Funds           3,200,000                  800,000                 879,078 Calvo's         304,561.00       395,641.00
Misc Revenues   Net care         294,536.00       173,691.00
FEMA   Commercial         356,717.00  
GovGuam Subsidy          17,958,964               4,489,741   Miscellaneous          69,473.00         43,322.00
Insurance Settlement   Nanbo  
Charitable Donations   FSM  
GTA Sale Proceeds   GOG          33,947.00                 47.00         37,692.00
GRT                 1,254,528 Healthy Futures Fund  
Health Securities Trust Fund                   183,130 Health Securities Trust Fund       183,130.00
Total Collections          79,017,129             19,754,282            16,101,332 Self-Pay      1,577,996.00         377,771.00       321,984.00
    DRT     21,666,246.00  
Salaries          34,884,362               8,721,091              7,948,793 Collection Agencies  
Specialty Pay              830,670                  207,668              1,078,513   CAOG      3,135,225.00  
Benefits           9,549,665               2,387,416              2,072,390   GMMS      2,643,435.00         13,188.00
Annual Lump Sum                    8,412   SAVANT      3,651,348.00         10,368.00
Other Pay     UPCA         386,187.00  
Overtime           2,011,306                  502,827                 543,352 Total          9,278,396.00     31,904,071.00    5,538,154.00
Total Salaries & Benefits          47,276,003             11,819,001            11,651,460
Travel & Training              100,230                   25,058                  43,690 Accounts Receivable (Net)
Contractual Services           9,096,233               2,274,058              1,721,411 Medically Indigent Program          6,774,499
Supplies & Materials          10,336,019               2,584,005              2,327,977 GovGuam          1,960,734
Minor Equipment              192,423                   48,106                  47,024 Self Pay          3,644,133
Miscellaneous              284,678                   71,170                  45,604 Medicare          2,637,441
Utilities           1,987,615                  496,904                 300,427 Medicaid          6,633,574
Capital Outlay           2,896,928                  724,232                 181,443 Commercial          5,525,020
Debt Service           6,847,000               1,711,748   Total A/R (Net)       27,175,401
Total Cash Disbursements          79,017,129             19,754,282            16,319,036                             -
Surplus /(Deficit)                          -                             -                 (217,704)
Accounts Payable Aging
12/31/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                74,160                     3,599                  20,744                182,998                281,501
Trade Payables           1,090,644                  749,370                 602,955              1,254,403              3,697,372
Payroll Payables              118,660                118,660
  - Gov Ret DBP             (351,107)                984,160                633,053
  - Gov Ret DCP                          -
  - Dept of Rev              186,213                186,213
GTA                        -                          -
GPA              116,804                 118,674                430,600                666,078
GWA                 1,136                   15,710                     (703)                      430                  16,573
Unbilled P O Receipts              582,414                582,414
Total           1,818,924                  768,679                 741,670              2,852,591              6,181,864
                         -
Accounts Receivable Aging                    
12/31/06                    
    0 - 30   31 - 60   61 - 90   Over 90   Total
Commercial           3,730,979               2,100,690                 715,312              4,016,429            10,563,410
GovGuam                42,691                   21,053                  46,464              2,030,004              2,140,212
Medicaid           1,637,424               1,463,596              1,416,853              9,790,959            14,308,832
Medically Indigent Program           3,099,065               1,272,606                 790,127            10,091,001            15,252,799
Medicare           2,599,600                  181,615                 159,851              2,199,028              5,140,094
Self Pay           3,796,483               1,326,094              1,522,238            30,330,151            36,974,966
Total          14,906,242               6,365,654              4,650,845            58,457,572            84,380,313
3
2006