Page 2 - Financial Workbook October
P. 2

Date:  Dec 4, 2017                Towne Square Care of Puryear - SNF
            Time: 16:52:33 CT                       INCOME STATEMENT
            User:  Zach Bell                        10/1/2017 to 10/31/2017                               Page # 1

            Include Adjustment Periods:  NO  Include Closing Periods:  NO

                                                   CURRENT PERIOD                       YEAR TO DATE
                                           Actual $ Actual / Day  Budget $  Var $  Actual $ Actual / Day  Budget $  Var $
            REVENUE
                 MEDICARE PART A
                 Med A - Room & Board       17,280    160.00      0    17,280   88,210   163.35       0    88,210
                 Med A - Contract. Adj.     27,219    252.03      0    27,219    (663)    (1.23)      0     (663)
                 Med A - Pharmacy               0      0.00       0       0     8,154     15.10       0     8,154
                 Med A - PT                     0      0.00       0       0     15,305    28.34       0    15,305
                 Med A - OT                     0      0.00       0       0     77,736   143.96       0    77,736
                 Med A - ST                     0      0.00       0       0     28,131    52.09       0    28,131
                 Med A - X-Ray                  0      0.00       0       0       100      0.19       0      100
                 Med A - Laboratory             0      0.00       0       0       16       0.03       0       16
                 Med A - Anc. Contract. Adj.    0      0.00       0       0    (13,030)  (24.13)      0   (13,030)
                 Med A - 2% Reduction        (630)    (5.83)      0     (630)  (1,037)    (1.92)      0    (1,037)
                 TOTAL MEDICARE PART A      43,869    406.19      0    43,869  202,922   375.78       0   202,922
                 PRIVATE PAY
                 Private - Room & Board       310         -       0      310   189,495   134.30       0   189,495
                 Private - ST                   0         -       0       0       750      0.53       0      750
                 TOTAL PRIVATE PAY            310         -       0      310   190,245   134.83       0   190,245
                 MEDICAID
                 Medicaid - Room & Board   104,150    162.48      0   104,150  810,820   171.86       0   810,820
                 Medicaid - Contract. Adj.   5,243     8.18       0    5,243    82,828    17.56       0    82,828
                 Medicaid - Pharmacy            0      0.00       0       0       56       0.01       0       56
                 TOTAL MEDICAID            109,393    170.66      0   109,393  893,704   189.42       0   893,704
                 MANAGED CARE
                 Managed - Room & Board      8,000    163.27      0    8,000    8,000    163.27       0     8,000
                 Managed - Contract. Adj.   10,960    223.68      0    10,960   10,960   223.68       0    10,960
                 Managed - ST                   0      0.00       0       0     1,097     22.38       0     1,097
                 TOTAL MANAGED CARE         18,960    386.94      0    18,960   20,057   409.33       0    20,057
                 HOSPICE
                 Hospice - Room & Board     15,655    168.33      0    15,655  147,995   175.77       0   147,995
                 Hospice - Contract. Adj.     216      2.33       0      216    9,667     11.48       0     9,667
                 TOTAL HOSPICE              15,871    170.66      0    15,871  157,662   187.25       0   157,662
                 VETERANS ADMINISTRATION
                 TOTAL VETERANS ADMINISTRATION  0         -       0       0        0         -        0        0
                 ASSISTED LIVING
                 Asst. Living - Room & Board  11,903   50.65      0    11,903   91,178    53.20       0    91,178
                 TOTAL ASSISTED LIVING      11,903     50.65      0    11,903   91,178    53.20       0    91,178
                 MEDICARE PART B
                 Med B - Contract. Adj.        82      0.76       0      82    (12,163)  (22.52)      0   (12,163)
                 Med B - PT                     0      0.00       0       0     7,645     14.16       0     7,645
                 Med B - OT                     0      0.00       0       0     13,967    25.86       0    13,967
                 Med B - ST                     0      0.00       0       0     13,359    24.74       0    13,359
                 Med B - 2% Reduction          (1)    (0.01)      0      (1)     (128)    (0.24)      0     (128)
                 TOTAL MEDICARE PART B         81      0.75       0      81     22,680    42.00       0    22,680
                 OTHER INCOME
                 Acuity Revenue Accrual      8,557     7.60       0    8,557    17,113     1.85       0    17,113
                 Other Income - Interest        0      0.00       0       0       150      0.02       0      150
                 Other Income - Miscellaneous   310    0.28       0      310    2,730      0.29       0     2,730
                 TOTAL OTHER INCOME          8,867     7.87       0    8,867    19,994     2.16       0    19,994
            TOTAL REVENUE                  209,254    185.84      0   209,254  1,598,440  172.36      0  1,598,440
   1   2   3   4   5   6   7