Page 2 - July Financial

TOWNE SQUARE CARE OF PURYEAR
INCOME STATEMENT
Jul-18

CURRENT YEAR TO DATE
Actual $ Actual / Day Budget $ Var $ Actual $ Actual / Day Budget $ Var $
REVENUE
MEDICARE PART A 16,988 377.51 0 16,988 234,620 382.74 0 234,620
PRIVATE PAY 9,388 94.83 0 9,388 151,668 254.05 0 151,668
MEDICAID 128,569 187.15 0 128,569 747,139 169.61 0 747,139
MANAGED CARE 9,290 774.17 0 9,290 22,899 532.53 0 22,899
HOSPICE 10,600 113.98 0 10,600 84,117 134.37 0 84,117
ASSISTED LIVING 4,500 48.39 0 4,500 57,139 49.77 0 57,139
MEDICARE PART B 16,667 16.20 0 16,667 47,967 6.45 0 47,967
OTHER INCOME 310 322.92 0 310 5286 5745.65 0 5,286
TOTAL REVENUE 196,312 209.73 0 196,312 1,350,835 180.51 0 1,350,835
OPERATING EXPENSES
NURSING 36,258 38.74 0 36,258 319,769 50.94 0 319,769
THERAPY 0 0 0 0 41,641 6.63 0 41,641
DIETARY 14,286 15.26 0 14,286 105,390 16.79 0 105,390
ACTIVITIES 1,649 1.76 0 1,649 11,803 1.88 0 11,803
LAUNDRY 1,857 1.98 0 1,857 16,059 2.56 0 16,059
HOUSEKEEPING 4,614 4.93 0 4,614 30,832 4.91 0 30,832
PLANT AND MAINTENANCE 11,403 12.18 0 11,403 99,089 15.79 0 99,089
GENERAL AND ADMINISTRATIVE 36,422 38.91 0 36,422 230,807 36.77 0 230,807
TOTAL OPS EXPENSES 106,489 103 0 106,489 855,390 397.67 0 855,390
EBITDARMI PROFIT/(LOSS) 89,823 495,445
EBITDARMI % OF REVENUE 46% 37%
Insurance - General Liability 0 0.00 0 6,024 21,048 2.83 0 21,048
Insurance - General Liabil-ALF 0 0.00 0 677 2030 0.27 0 2,030
Insurance - Surety Bond 0 0.00 0 0 300 0.04 0 300
Insurance - Workers Comp. 0 0.00 0 123 123 0.02 0 123
EBITDARM PROFIT/(LOSS) 89,823 472,067
EBITDARM % OF REVENUE 46% 35%
Management Fees 14,438 14.03 0 14,438 101,063 16.10 0 86,625
Management Fees-ALF 3,063 2.98 0 3,063 21,438 3.42 0 18,375
EBITDAR PROFIT/(LOSS) 72,322 349,566
EBITDAR % OF REVENUE 37% 26%
Rent Expense 21,000 20.41 0 21,000 147,000 19.78 0 126,000
EBITDA PROFIT/(LOSS) 51,322 202,566
EBITDA % OF REVENUE 26% 15%
Assessment Fees 7,183 6.98 0 7,183 50,280 6.77 0 50,280
Professional Fees - Accounting 1,350 1.31 0 1,350 17,277 2.32 0 17,277
Professional Fees - Legal 0 0.00 0 0 4,185 0.56 0 4,185
Professional Fees - Billing 0 0.00 0 0 450 0.06 0 450
Professional Fees - Other 14,500 14.09 0 14,500 50,613 6.81 0 50,613
EBIT PROFIT/(LOSS) 28,289 80,211
Interest 0 0 0 0 0 0 0 0
Taxes - Personal Property 140 0.14 0 140 980 0.13 0 840
Taxes - Real Estate 1,848 1.80 0 1,848 12,936 1.74 0 11,788
NET INCOME / (LOSS) 26,301 66,295
STATISTICS PATIENT DAYS CENSUS PATIENT DAYS CENSUS
MEDICARE PART A 45 0 1.5 0 613 0 4.1 0
PRIVATE PAY 99 0 3.2 0 597 0 4.0 0
MEDICAID 687 0 22.2 0 4,405 0 29.2 0
MANAGED CARE 12 0 0.4 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,148 0 7.6 0
TOTAL PATIENT DAYS 1,029 0 5.5 0 7,432 0 82.6 0
OCCUPANCY % SNF 96% 92%
LABOR WAGES PPD WAGES PPD
Nursing 36,985 0 35.9 0 277,441 0 37.3 0
Dietary 13,634 0 13.2 0 50,488 0 6.8 0
Therapy 0 0 0.0 0 49,068 0 6.6 0
HK/L 5,758 0 5.6 0 38,952 0 5.2 0
Maintenance 2,685 0 2.6 0 15,447 0 2.1 0
Activities 1,649 0 1.6 0 11,197 0 1.5 0
Admin. 10,399 10.1 69,243 9.3
TOTAL 71,110 0 0 0 511,836 0 0 0
NURSING OT 2,414 29,449
% OF NURSING LABOR 7% 11%
TOTAL OT 6,481 32,083
% OF TOTAL LABOR 9% 6%