Page 5 - Financial Workbook December
P. 5

Date:  Jan 19, 2018                  Towne Square Care of Puryear - SNF
       Time: 17:51:55 CT                           INCOME STATEMENT
       User:  Zach Bell                            12/1/2017 to 12/31/2017                                    Page # 4


                                                    CURRENT PERIOD                         YEAR TO DATE
                                           Actual $ Actual / Day  Budget $  Var $  Actual $ Actual / Day  Budget $  Var $
            GENERAL AND ADMINISTRATIVE (con't)
            Conferences & Seminars-ALF           0       0.00       15     (15)     525       0.05      160      365
            Employee Function Expense            0       0.00       0        0       33       0.00        0       33
            Employee Function Expense-ALF        0       0.00       0        0        7       0.00        0        7
            Employee Screening & Hiring          0       0.00       37     (37)     326       0.03      401      (75)
            Employee Screening & Hire-ALF        0       0.00       2       (2)      69       0.01       27       43
            Late Fees & Finance Charges          4       0.00       65     (61)    1,210      0.10      701      509
            Late Fee/Finance Charges-ALF         0       0.00       2       (2)      90       0.01       27       63
            Licenses & Permits                   0       0.00      279    (279)    2,825      0.24     3,006    (181)
            Licenses & Permits-ALF               0       0.00       47     (47)    1,775      0.15      508     1,267
            Marketing Expenses                   0       0.00       9       (9)      65       0.01      100      (35)
            Marketing Expense-ALF                0       0.00       0        0        3       0.00        0        3
            Meals & Entertainment                0       0.00       0        0       48       0.00        0       48
            Meals & Entertainment-ALF            0       0.00       0        0       10       0.00        0       10
            Miscellaneous Expense                0       0.00       0        0     1,261      0.11        0     1,261
            ADP Payroll Processing               0       0.00      149    (149)    1,483      0.13     1,603    (121)
            ADP Payroll Processing - ALF         0       0.00       7       (7)     315       0.03       80      234
            Payroll Exp - Payroll Taxes          0       0.00       0        0   (10,997)    (0.95)       0   (10,997)
            SUTA Taxes                           0       0.00      883    (883)    8,774      0.76     9,517    (743)
            SUTA Taxes ALF                       0       0.00       22     (22)     822       0.07      240      582
            FUTA Taxes                           0       0.00      195    (195)    1,944      0.17     2,104    (161)
            FUTA Taxes ALF                       0       0.00       5       (5)     182       0.02       53      129
            Rehab Director                       0       0.00       0        0      400       0.03        0      400
            Payroll Exp - Workers Comp       2,405       2.06      484    1,921    9,619      0.83     5,210    4,409
            Postage & Delivery Expenses          0       0.00       84     (84)     801       0.07      902     (101)
            Printing & Copier Expense          133       0.11      167     (34)    1,968      0.17     1,804     165
            Printing & Copier Expense-ALF       28       0.02       2       26      120       0.01       27       93
            Professional fees - Accounting       0       0.00      167    (167)    2,742      0.24     1,804     938
            Professional fees-Account-ALF        0       0.00       10     (10)     582       0.05      107      475
            Professional Fees - Architect      750       0.64      465     285     5,406      0.47     5,010     396
            Professional Fees - Arch. ALF        0       0.00       12     (12)     425       0.04      134      292
            Professional Fees - Other            0       0.00      233    (232)    2,298      0.20     2,505    (207)
            Software Expense                   854       0.73    1,004    (150)   11,735      1.01    10,822     913
            Software Expense-ALF               146       0.12       10     136      646       0.06      107      539
            Supplies - Office                    0       0.00      233    (232)    2,326      0.20     2,505    (179)
            Supplies - Office-ALF                0       0.00       12     (12)     494       0.04      134      360
            Travel expenses - Mileage            0       0.00       74     (74)     781       0.07      802      (20)
            Travel expenses - Mileage-ALF        0       0.00       5       (5)     166       0.01       53      112
            Bank Charges                         0       0.00       0        0       13       0.00        0       13
            Insurance - General Liability    3,190       2.73    2,706     484    31,867      2.75    29,158    2,709
            Insurance - General Liabil-ALF     677       0.58      146     530     6,801      0.59     1,576    5,224
            Insurance - Workers Compensati       0       0.00    1,283   (1,283)  12,835      1.11    13,828    (993)
            Insurance WC ALF                     0       0.00       32     (32)    1,203      0.10      347      856
            Late Fees & Finance Charges         23       0.02      167    (145)    1,691      0.15     1,816    (125)
            Late Fees/Finance Charges-ALF        0       0.00       0        0        8       0.00        0        8
            Licenses & Permits                   0       0.00       93     (93)     900       0.08     1,002    (102)
            Assessment Fees                  7,183       6.14    6,352     831    77,731      6.71    68,437    9,295
            Management Fees                  14,438     12.35    1,123   13,315  140,875      12.15  100,818   40,057
            Management Fees-ALF              3,063       2.62      749    2,314   34,125      2.94     8,069   26,056
            Payroll Exp - Benefits               0       0.00      102    (102)    1,092      0.09     1,102     (10)
            Payroll Exp - Payroll Taxes      3,845       3.29    7,059   (3,214)  82,026      7.08    76,052    5,974
            Payroll Exp - Wages - PTO          276       0.24    1,014    (738)   12,814      1.11    10,922    1,893
            Payroll Exp - Fac Admin          6,974       5.97    7,059     (85)   85,177      7.35    76,052    9,125
            Payroll Exp-Admin Assist         2,345       2.01    2,399     (55)   28,582      2.47    25,852    2,730
            Payroll Exp-Admin Assist-OT        287       0.25      288      (1)    3,302      0.28     3,106     195
            Professional Fees - Accounting   2,200       1.88    1,265     935    14,799      1.28    13,627    1,172
            Professional Fees- Account-ALF       0       0.00       62     (62)    2,306      0.20      668     1,638
            Professional Fees - Legal            0       0.00      921    (921)   10,998      0.95     9,920    1,078
            Professional Fees - Legal-ALF        0       0.00       52     (52)    1,940      0.17      961      979
            Prof. Fees - Billing Services        0       0.00      144    (144)    1,464      0.13     1,598    (134)
            Prof. Fees-Billing Serv-ALF          0       0.00       7       (7)     311       0.03       80      230
            Professional Fees - Other            0       0.00      205    (205)     170       0.01     2,204   (2,035)
            Professional Fees-Other-ALF          0       0.00       0        0       36       0.00        0       36
            Rent Expense                     21,000     17.96   12,639    8,361  168,000      14.50  136,172   31,828
            Software Expense                   550       0.47      493      57     6,050      0.52     5,311     739
   1   2   3   4   5   6   7   8   9   10