Page 2 - Financial Workbook September
P. 2

Date:  Oct 25, 2017               Towne Square Care of Puryear - SNF
            Time: 17:23:01 CT                       INCOME STATEMENT
            User:  Zach Bell                         8/1/2017 to 9/30/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       14,485    134.12      0    14,485   70,930   164.19       0    70,930
                 Med A - Contract. Adj.    (97,284)  (900.78)     0   (97,284)  (27,882)  (64.54)     0   (27,882)
                 Med A - Pharmacy            1,822     16.87      0    1,822    8,154     18.87       0     8,154
                 Med A - PT                  4,610     42.69      0    4,610    15,305    35.43       0    15,305
                 Med A - OT                 14,819    137.21      0    14,819   77,736   179.94       0    77,736
                 Med A - ST                  6,419     59.44      0    6,419    28,131    65.12       0    28,131
                 Med A - X-Ray                  0      0.00       0       0       100      0.23       0      100
                 Med A - Laboratory             0      0.00       0       0       16       0.04       0       16
                 Med A - Anc. Contract. Adj.   89,242  826.32     0    89,242  (13,030)  (30.16)      0   (13,030)
                 Med A - 2% Reduction        1,139     10.55      0    1,139     (407)    (0.94)      0     (407)
                 TOTAL MEDICARE PART A      35,252    326.41      0    35,252  159,053   368.18       0   159,053
                 PRIVATE PAY
                 Private - Room & Board     22,555    169.59      0    22,555  189,185   134.08       0   189,185
                 Private - ST                 750      5.64       0      750      750      0.53       0      750
                 TOTAL PRIVATE PAY          23,305    175.23      0    23,305  189,935   134.61       0   189,935
                 MEDICAID
                 Medicaid - Room & Board   188,825    156.70      0   188,825  706,670   173.33       0   706,670
                 Medicaid - Contract. Adj.   63,868    53.00      0    63,868   77,585    19.03       0    77,585
                 Medicaid - Pharmacy            0      0.00       0       0       56       0.01       0       56
                 Medicaid - Anc. Contract Adj.  56     0.05       0       56       0       0.00       0        0
                 TOTAL MEDICAID            252,749    209.75      0   252,749  784,311   192.37       0   784,311
                 MANAGED CARE
                 Managed - ST                   0         -       0       0     1,097        -        0     1,097
                 Managed - Anc. Contract. Adj.  518       -       0      518       0         -        0        0
                 TOTAL MANAGED CARE           518         -       0      518    1,097        -        0     1,097
                 HOSPICE
                 Hospice - Room & Board     42,100    197.65      0    42,100  132,340   176.69       0   132,340
                 Hospice - Contract. Adj.    8,280     38.87      0    8,280    9,450     12.62       0     9,450
                 TOTAL HOSPICE              50,380    236.53      0    50,380  141,790   189.31       0   141,790
                 VETERANS ADMINISTRATION
                 TOTAL VETERANS ADMINISTRATION  0         -       0       0        0         -        0        0
                 ASSISTED LIVING
                 Asst. Living - Room & Board  21,600   57.14      0    21,600   79,274    53.60       0    79,274
                 TOTAL ASSISTED LIVING      21,600     57.14      0    21,600   79,274    53.60       0    79,274
                 MEDICARE PART B
                 Med B - Contract. Adj.     (6,006)   (55.61)     0   (6,006)  (12,245)  (28.34)      0   (12,245)
                 Med B - PT                  3,901     36.12      0    3,901    7,645     17.70       0     7,645
                 Med B - OT                 10,379     96.10      0    10,379   13,967    32.33       0    13,967
                 Med B - ST                  9,744     90.23      0    9,744    13,359    30.92       0    13,359
                 Med B - 2% Reduction         (52)    (0.48)      0      (52)    (127)    (0.29)      0     (127)
                 TOTAL MEDICARE PART B      17,967    166.36      0    17,967   22,599    52.31       0    22,599
                 OTHER INCOME
                 Acuity Revenue Accrual    (42,784)   (21.00)     0   (42,784)  8,557      1.05       0     8,557
                 Other Income - Interest        0      0.00       0       0       150      0.02       0      150
                 Other Income - Miscellaneous   2,420  1.19       0    2,420    2,420      0.30       0     2,420
                 TOTAL OTHER INCOME        (40,363)   (19.82)     0   (40,363)  11,127     1.37       0    11,127
            TOTAL REVENUE                  361,408    177.42      0   361,408  1,389,186  170.49      0  1,389,186
   1   2   3   4   5   6   7