Spreadsheet: 89308d1289071011-copying-specific-data-from-one-file-into-another-file-generic_2010_q2
Sheet: Invoice

 |  |  | 2010-09-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALCULATE
 |  |  | 3 Months |  |  | 6 Months |  | 3 Months |  |  | 9 Months |  | 3 Months |  |  | 12 Months |  | 3 Months |  |  | TTM
 |  |  | 6/30/2010 | PPD |  | 9/30/2010 |  | 9/30/2010 | PPD |  | 12/31/2010 |  | 12/31/2010 | PPD |  | 3/31/2011 |  | 3/31/2011 | PPD |  | 3/31/2011 | PPD
Operator Chart of Accounts | OPERATING STATEMENT
1000-100 | Census & Occupancy |  |  | 0
1000-101 | [NAME] |  | 112 |  |  | 56 |  |  |  |  | 37.33333333333334 |  |  |  |  | 28 |  |  |  |  | 28
1000-102 | Beds in Operation |  | 104 |  |  | 52 |  |  |  |  | 34.66666666666666 |  |  |  |  | 26 |  |  |  |  | 26
1000-103 | Days in Period |  | 91 |  |  | 91 |  |  |  |  | 91 |  |  |  |  | 91 |  |  |  |  | 91
1000-104 | Patient Days - Capacity |  | 9464 |  |  | 4732 |  | 0 |  |  | 3154.666666666667 |  |  |  |  | 2366 |  |  |  |  | 2366
2000-000 | Payor Mix - Days & Percent
 | Residential Care (RC)
2000-101 | Private |  | 0 |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
2000-102 | Other |  | 0 |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
[NAME] | Total Residential Days |  | 0 |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | Skilled Nursing Care (SNF)
2000-103 | Private |  | 1537 | 0.2344059783437548 |  | 1537 |  |  | #N/A |  | 1537 |  |  | #N/A |  | 1537 |  |  | #N/A |  | 1537 | 0.2344059783437548
2000-104 | Medicare |  | 180 | 0.02745157846576178 |  | 180 |  |  | #N/A |  | 180 |  |  | #N/A |  | 180 |  |  | #N/A |  | 180 | 0.02745157846576178
2000-105 | Medicaid |  | 4840 | 0.7381424431904835 |  | 4840 |  |  | #N/A |  | 4840 |  |  | #N/A |  | 4840 |  |  | #N/A |  | 4840 | 0.7381424431904835
2000-106 | Other |  | 0 | 0 |  | 0 |  |  | #N/A |  | 0 |  |  | #N/A |  | 0 |  |  | #N/A |  | 0 | 0
[NAME] | Total SNF Days |  | 6557 | 1 |  | 6557 |  | 0 | #N/A |  | 6557 |  | 0 | #N/A |  | 6557 |  | 0 | #N/A |  | 6557
[NAME] | Patient Days - Actual |  | 6557 |  |  | 6557 |  | 0 |  |  | 6557 |  | 0 |  |  | 6557 |  | 0 |  |  | 6557
[NAME] | Premium Mix |  | 0.2618575568095166 |  |  | 0.2618575568095166 |  | #N/A |  |  | 0.2618575568095166 |  | #N/A |  |  | 0.2618575568095166 |  |  |  |  | 0.2344059783437548
[NAME] | Occupancy % |  | 0.6928360101437024 |  |  | 1.385672020287405 |  |  |  |  | 2.078508030431108 |  | #N/A |  |  | 2.77134404057481 |  | #N/A |  |  | 2.77134404057481
3000-000 Revenues | Revenue
3000-101 | RC Private |  | 0 | #N/A |  | 0 |  |  | #N/A |  | 0 |  |  | #N/A |  | 0 |  |  | #N/A |  | 0 | #N/A
3000-102 | RC Other |  | 0 | #N/A |  | 0 |  |  | #N/A |  | 0 |  |  | #N/A |  | 0 |  |  | #N/A |  | 0 | #N/A
3000-103 | Private |  | 170260.69 | 110.7746844502277 |  | 170260.69 |  |  | #N/A |  | 170260.69 |  |  | #N/A |  | 170260.69 |  |  | #N/A |  | 170260.69 | 110.7746844502277
3000-104 | Medicare |  | 105872.21 | 588.1789444444444 |  | 105872.21 |  |  | #N/A |  | 105872.21 |  |  | #N/A |  | 105872.21 |  |  | #N/A |  | 105872.21 | 588.1789444444444
3000-105 | Medicaid |  | 562683.81 | 116.2569855371901 |  | 562683.81 |  |  | #N/A |  | 562683.81 |  |  | #N/A |  | 562683.81 |  |  | #N/A |  | 562683.81 | 116.2569855371901
3000-106 | Ancillary |  | 779.5999999999999 | 0.1188958365105993 |  | 779.5999999999999 |  |  | #N/A |  | 779.5999999999999 |  |  | #N/A |  | 779.5999999999999 |  |  | #N/A |  | 779.5999999999999 | 0.1188958365105993
3000-107 | Other |  | 1005.44 | #N/A |  | 1005.44 |  |  | #N/A |  | 1005.44 |  |  | #N/A |  | 1005.44 |  |  | #N/A |  | 1005.44 | #N/A
3000-108 | Contractual Adjustments |  | 0 | 0 |  | 0 |  |  | #N/A |  | 0 |  |  | #N/A |  | 0 |  |  | #N/A |  | 0 | 0
3000-109 | Prior Period Adjustments |  | 0 | 0 |  | 0 |  |  | #N/A |  | 0 |  |  | #N/A |  | 0 |  |  | #N/A |  | 0 | 0
[NAME] | Total Revenue |  | 840601.75 | 128.1991383254537 |  | 840601.75 |  | 0 | #N/A |  | 840601.75 |  | 0 | #N/A |  | 840601.75 |  | 0 | #N/A |  | 840601.75 | 128.1991383254537
4000-000 Operating Expenses | Operating Expenses
4000-101 | Nursing
4000-102 | Administrative & General
4000-103 | Activities, Soc Svs & Marketing
4000-104 | Dietary
4000-105 | Housekeeping
4000-106 | Laundry
4000-107 | Plant Operation & Maint
4000-108 | Residential Care
4000-109 | Ancillary & Pharmacy
4000-110 | Other Expenses
4000-111 | Operating Expenses |  | 624721.8999999999 | 95.27556809516545 |  | 624721.8999999999 |  |  | #N/A |  | 624721.8999999999 |  |  | #N/A |  | 624721.8999999999 |  |  | #N/A |  | 624721.8999999999 | 95.27556809516545
[NAME] | Total Operating Expenses |  | 624721.8999999999 | 95.27556809516545 |  | 624721.8999999999 |  | 0 | #N/A |  | 624721.8999999999 |  | 0 | #N/A |  | 624721.8999999999 |  | 0 | #N/A |  | 624721.8999999999 | 95.27556809516545
[NAME] | EBITDARM |  | 215879.8500000001 | 32.92357023028826 |  | 215879.8500000001 |  | 0 | #N/A |  | 215879.8500000001 |  | 0 | #N/A |  | 215879.8500000001 |  | 0 | #N/A |  | 215879.8500000001 | 32.92357023028826
 |  |  | 0.2568158465051971 |  |  | 0.2568158465051971 |  | #N/A |  |  | 0.2568158465051971 |  | #N/A |  |  | 0.2568158465051971 |  | #N/A |  |  | 0.2568158465051971
4000-112 | Less: Management Fee |  | 41979.8 | 0.04994017678407165 |  | 41979.8 |  |  | #N/A |  | 41979.8 |  |  | #N/A |  | 41979.8 |  |  | #N/A |  | 41979.8 | 0.04994017678407165
[NAME] | EBITDAR |  | 173900.0500000001 | 26.52128259874944 |  | 173900.0500000001 |  | 0 | #N/A |  | 173900.0500000001 |  | 0 | #N/A |  | 173900.0500000001 |  | 0 | #N/A |  | 173900.0500000001 | 26.52128259874944
4000-113 | Less: Rent |  | 115255.26 | 17.57743785267653 |  | 115255.26 |  |  | #N/A |  | 115255.26 |  |  | #N/A |  | 115255.26 |  |  | #N/A |  | 115255.26 | 17.57743785267653
 |  |  | 0
[NAME] | EBITDA |  | 2563.37 | 0.390936403843221 |  | 58644.79000000011 |  | 0 | #N/A |  | 58644.79000000011 |  | 0 | #N/A |  | 58644.79000000011 |  | 0 | #N/A |  | 58644.79000000011 | 8.943844746072916
4000-114 | Less: Depr & Amortization |  | 7518.669999999999 | 1.146663108128717 |  | 7518.669999999999 |  |  | #N/A |  | 7518.669999999999 |  |  | #N/A |  | 7518.669999999999 |  |  | #N/A |  | 7518.669999999999 | 1.146663108128717
4000-115 | Less: Income Tax |  | 0 | 0 |  | 0 |  |  | #N/A |  | 0 |  |  | #N/A |  | 0 |  |  | #N/A |  | 0 | 0
4000-116 | Less: Interest |  | 2341.34 | 0.3570748818057038 |  | 2341.34 |  |  | #N/A |  | 2341.34 |  |  | #N/A |  | 2341.34 |  |  | #N/A |  | 2341.34 | 0.3570748818057038
 | Net Income |  | -7296.639999999999 | -1.1128015860912 |  | -7296.639999999999 |  | 0 | #N/A |  | 48784.78000000012 |  | 0 | #N/A |  | 48784.78000000012 |  | 0 | #N/A |  | 48784.78000000012 | 7.440106756138496
[NAME] | Rent Coverage |  | 1.508825280512144 |  |  | 1.508825280512144 |  | #N/A |  |  | 1.508825280512144 |  | #N/A |  |  | 1.508825280512144 |  | #N/A |  |  | 1.508825280512144
[NAME] | EBITDAR Adjustment |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Adjusted EBITDAR |  | 173900.0500000001 |  |  | 173900.0500000001 |  | 0 |  |  | 173900.0500000001 |  | 0 |  |  | 173900.0500000001 |  | 0 |  |  | 173900.0500000001