Page 2 - August Financial

TOWNE SQUARE CARE OF PURYEAR
INCOME STATEMENT
Aug-18
CURRENT YEAR TO DATE
Actual $ Actual / Day Budget $ Var $ Actual $ Actual / Day Budget $ Var $
REVENUE
MEDICARE PART A 22,305 323.26 0 22,305 256,925 419.13 0 256,925
PRIVATE PAY 19,982 214.86 0 19,982 171,650 287.52 0 171,650
MEDICAID 119,850 170.97 0 119,850 866,989 196.82 0 866,989
MANAGED CARE 15,405 496.94 0 15,405 38,304 890.79 0 38,304
HOSPICE 10,600 113.98 0 10,600 94,717 151.31 0 94,717
ASSISTED LIVING 4,500 48.39 0 4,500 61,639 49.67 0 61,639
MEDICARE PART B 21,354 21.64 0 21,354 69,322 11.03 0 69,322
OTHER INCOME 310 311.57 0 310 5596 6924.65 0 5,596
TOTAL REVENUE 214,306 209.73 0 214,306 1,565,142 180.51 0 1,565,142
OPERATING EXPENSES
NURSING 39,724 38.74 0 39,724 359,493 50.94 0 359,493
THERAPY 0 0 0 0 41,641 6.63 0 41,641
DIETARY 15,539 15.26 0 15,539 113,522 16.79 0 113,522
ACTIVITIES 1,788 1.76 0 1,788 13,591 1.88 0 13,591
LAUNDRY 3,321 1.98 0 3,321 19,381 2.56 0 19,381
HOUSEKEEPING 4,303 4.93 0 4,303 35,135 4.91 0 35,135
PLANT AND MAINTENANCE 12,481 12.18 0 12,481 111,571 15.79 0 111,571
GENERAL AND ADMINISTRATIVE 31,215 38.91 0 31,215 262,122 36.77 0 262,122
TOTAL OPS EXPENSES 108,371 105 0 108,371 956,456 152 0 956,456
EBITDARMI PROFIT/(LOSS) 105,935 608,686
EBITDARMI % OF REVENUE 49% 39%
Insurance - General Liability 0 0.00 0 6,024 21,048 3.35 0 21,048
Insurance - General Liabil-ALF 0 0.00 0 677 2030 0.32 0 2,030
Insurance - Surety Bond 0 0.00 0 0 300 0.05 0 300
Insurance - Workers Comp. 0 0.00 0 123 123 0.02 0 123
EBITDARM PROFIT/(LOSS) 105,935 585,308
EBITDARM % OF REVENUE 49% 37%
Management Fees 14,438 14.63 0 14,438 115,500 16.10 0 86,625
Management Fees-ALF 3,063 3.10 0 3,063 24,500 3.42 0 18,375
EBITDAR PROFIT/(LOSS) 88,434 445,308
EBITDAR % OF REVENUE 41% 28%
Rent Expense 21,000 21.28 0 21,000 168,000 26.73 0 126,000
EBITDA PROFIT/(LOSS) 67,434 277,308
EBITDA % OF REVENUE 31% 18%
Assessment Fees 7,183 7.28 0 7,183 57,463 9.14 0 57,463
Professional Fees - Accounting 1,350 1.37 0 1,350 18,627 2.96 0 18,627
Professional Fees - Legal 0 0.00 0 0 4,185 0.67 0 4,185
Professional Fees - Billing 5,000 5.07 0 0 5,450 0.87 0 5,450
Professional Fees - Other 15,601 15.81 0 14,500 66,214 10.54 0 66,214
EBIT PROFIT/(LOSS) 43,301 130,819
Interest 0 0 0 0 0 0 0 0
Taxes - Personal Property 140 0.14 0 140 1120 0.18 0 840
Taxes - Real Estate 1,848 1.87 0 1,848 14,784 2.35 0 11,788
NET INCOME / (LOSS) 41,313 114,915
STATISTICS PATIENT DAYS CENSUS PATIENT DAYS CENSUS
MEDICARE PART A 69 0 2.2 0 613 0 4.1 0
PRIVATE PAY 93 0 3.0 0 597 0 4.0 0
MEDICAID 701 0 22.6 0 4,405 0 29.2 0
MANAGED CARE 31 0 1.0 0 43 0 0.3 0
HOSPICE 93 0 3.0 0 626 0 4.1 0
ASSISTED LIVING 93 0 3.0 0 1,241 0 8.2 0
TOTAL SNF DAYS 987 0 31.8 0 6,284 0 69.8 0
OCCUPANCY % SNF 99% 81%
TOTAL ALF DAYS 93 0 3.0 0 1,241 0 8.2 0
OCCUPANCY % ALF 30% 51%
LABOR WAGES PPD WAGES PPD
Nursing 47,190 0 47.8 0 324,631 0 51.7 0
Dietary 8,637 0 8.8 0 59,124 0 9.4 0
Therapy 0 0 0.0 0 49,068 0 7.8 0
HK/L 5,164 0 5.2 0 44,116 0 7.0 0
Maintenance 3,653 0 3.7 0 19,101 0 3.0 0
Activities 2,145 0 2.2 0 13,342 0 2.1 0
Admin. 10,817 11.0 80,060 12.7
TOTAL 77,606 0 0 0 589,442 0 0 0
NURSING OT 6,558 36,007
% OF NURSING LABOR 14% 2% 11% 2%
TOTAL OT 8,097 40,180
% OF TOTAL LABOR 10% 2.5% 7% 2.5%