Page 2 - Financial Workbook August
P. 2

Date:  Sep 15, 2017               Towne Square Care of Puryear - SNF
            Time: 13:50:08 CT                       INCOME STATEMENT
            User:  Zach Bell                         8/1/2017 to 8/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        6,080    160.00      0    6,080    62,525   172.72       0    62,525
                 Med A - Contract. Adj.     11,151    293.44      0    11,151   80,553   222.52       0    80,553
                 Med A - Pharmacy               0      0.00       0       0     6,332     17.49       0     6,332
                 Med A - PT                  4,610    121.32      0    4,610    15,305    42.28       0    15,305
                 Med A - OT                  7,336    193.06      0    7,336    70,254   194.07       0    70,254
                 Med A - ST                  6,118    160.99      0    6,118    27,830    76.88       0    27,830
                 Med A - X-Ray                  0      0.00       0       0       100      0.28       0      100
                 Med A - Laboratory             0      0.00       0       0       16       0.04       0       16
                 Med A - Anc. Contract. Adj.   (14,639)  (385.24)  0  (14,639)  (116,912)  (322.96)   0  (116,912)
                 Med A - 2% Reduction        (289)    (7.60)      0     (289)  (1,835)    (5.07)      0    (1,835)
                 TOTAL MEDICARE PART A      20,367    535.98      0    20,367  144,168   398.25       0   144,168

                 PRIVATE PAY
                 Private - Room & Board     21,100    167.46      0    21,100  187,730   133.71       0   187,730
                 TOTAL PRIVATE PAY          21,100    167.46      0    21,100  187,730   133.71       0   187,730
                 MEDICAID
                 Medicaid - Room & Board    95,935    163.43      0    95,935  613,780   177.44       0   613,780
                 Medicaid - Contract. Adj.   4,261     7.26       0    4,261    17,978     5.20       0    17,978
                 Medicaid - Pharmacy            0      0.00       0       0       56       0.02       0       56
                 Medicaid - Anc. Contract Adj.  0      0.00       0       0      (56)     (0.02)      0      (56)
                 TOTAL MEDICAID            100,196    170.69      0   100,196  631,758   182.64       0   631,758
                 MANAGED CARE
                 Managed - ST                   0         -       0       0     1,097        -        0     1,097
                 Managed - Anc. Contract. Adj.  0         -       0       0      (518)       -        0     (518)
                 TOTAL MANAGED CARE             0         -       0       0       578        -        0      578
                 HOSPICE
                 Hospice - Room & Board     12,770    168.03      0    12,770  103,010   168.32       0   103,010
                 Hospice - Contract. Adj.     264      3.47       0      264    1,434      2.34       0     1,434
                 TOTAL HOSPICE              13,034    171.49      0    13,034  104,444   170.66       0   104,444
                 VETERANS ADMINISTRATION
                 TOTAL VETERANS ADMINISTRATION  0         -       0       0        0         -        0        0
                 ASSISTED LIVING
                 Asst. Living - Room & Board  10,500   56.45      0    10,500   68,174    52.97       0    68,174
                 TOTAL ASSISTED LIVING      10,500     56.45      0    10,500   68,174    52.97       0    68,174
                 MEDICARE PART B
                 Med B - Contract. Adj.     (3,845)  (101.19)     0   (3,845)  (10,084)  (27.86)      0   (10,084)
                 Med B - PT                   802      21.11      0      802    4,546     12.56       0     4,546
                 Med B - OT                  2,459     64.71      0    2,459    6,046     16.70       0     6,046
                 Med B - ST                     0      0.00       0       0     3,615      9.99       0     3,615
                 Med B - 2% Reduction         (45)    (1.20)      0      (45)    (121)    (0.33)      0     (121)
                 TOTAL MEDICARE PART B       (630)    (16.57)     0     (630)   4,002     11.06       0     4,002
                 OTHER INCOME
                 Acuity Revenue Accrual      8,557     8.45       0    8,557    59,897     8.41       0    59,897
                 Other Income - Discounts       0      0.00       0       0       150      0.02       0      150
                 Other Income - Miscellaneous   2,120  2.09       0    2,120    2,120      0.30       0     2,120
                 TOTAL OTHER INCOME         10,677     10.54      0    10,677   62,167     8.73       0    62,167

            TOTAL REVENUE                  175,244    172.99      0   175,244  1,203,021  168.87      0  1,203,021
   1   2   3   4   5   6   7