Page 5 - Financial Workbook September
P. 5

Date:  Oct 25, 2017               Towne Square Care of Puryear - SNF
            Time: 17:23:04 CT                       INCOME STATEMENT
            User:  Zach Bell                         8/1/2017 to 9/30/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        2,475     1.22       0    2,475   2,475      0.30      0     2,475
                 Conferences & Seminars-ALF     525      0.26       0     525      525      0.06      0      525
                 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       0       0      326      0.04      0      326
                 Employee Screening & Hire-ALF   0       0.00       0       0      69       0.01      0       69
                 Late Fees & Finance Charges    640      0.31       0     640    1,045      0.13       0    1,045
                 Late Fee/Finance Charges-ALF   (31)    (0.02)      0     (31)     55       0.01      0       55
                 Licenses & Permits               0      0.00       0       0    2,825      0.35      0     2,825
                 Licenses & Permits-ALF           0      0.00       0       0    1,775      0.22      0     1,775
                 Marketing Expenses               0      0.00       0       0      65       0.01       0      65
                 Marketing Expense-ALF            0      0.00       0       0       3       0.00       0       3
                 Meals & Entertainment            0      0.00       0       0      48       0.01      0       48
                 Meals & Entertainment-ALF        0      0.00       0       0      10       0.00      0       10
                 Miscellaneous Expense          100      0.05       0     100      190      0.02      0      190
                 ADP Payroll Processing         172      0.08       0     172    1,483      0.18      0     1,483
                 ADP Payroll Processing - ALF    37      0.02       0      37      315      0.04      0      315
                 Payroll Exp - Payroll Taxes  (10,997)  (5.40)      0  (10,997)  (10,997)  (1.35)     0   (10,997)
                 SUTA Taxes                    8,774     4.31       0    8,774   8,774      1.08      0     8,774
                 SUTA Taxes ALF                 822      0.40       0     822      822      0.10      0      822
                 FUTA Taxes                    1,944     0.95       0    1,944   1,944      0.24      0     1,944
                 FUTA Taxes ALF                 182      0.09       0     182      182      0.02      0      182
                 Payroll Exp - Workers Comp   (9,619)   (4.72)      0   (9,619)  2,405      0.30      0     2,405
                 Postage & Delivery Expenses    169      0.08       0     169      801      0.10      0      801
                 Postage-Delivery Expenses-ALF  (134)   (0.07)      0    (134)      0       0.00      0        0
                 Printing & Copier Expense      528      0.26       0     528    1,529      0.19      0     1,529
                 Printing & Copier Expense-ALF  (182)   (0.09)      0    (182)     30       0.00      0       30
                 Professional fees - Accounting  1,114   0.55       0    1,114   1,114      0.14      0     1,114
                 Professional fees-Account-ALF  236      0.12       0     236      236      0.03      0      236
                 Professional Fees - Architect    0      0.00       0       0    2,005      0.25      0     2,005
                 Professional Fees - Arch. ALF    0      0.00       0       0      425      0.05      0      425
                 Professional Fees - Other      402      0.20       0     402    2,298      0.28      0     2,298
                 Professional Fees - Other     (402)    (0.20)      0    (402)      0       0.00      0        0
                 Software Expense              3,976     1.95       0    3,976   9,082      1.11      0     9,082
                 Software Expense-ALF          (940)    (0.46)      0    (940)     188      0.02      0      188
                 Supplies - Office               86      0.04       0      86    2,308      0.28      0     2,308
                 Supplies - Office-ALF           18      0.01       0      18      490      0.06      0      490
                 Travel expenses - Mileage      391      0.19       0     391      586      0.07       0     586
                 Travel expenses - Mileage-ALF   83      0.04       0      83      124      0.02      0      124
                 Bank Charges                     2      0.00       0       2      13       0.00       0      13
                 Bank Charges-ALF                (2)     0.00       0      (2)      0       0.00       0       0
                 Insurance - General Liability  (1,351)  (0.66)     0   (1,351)  22,297     2.74      0    22,297
                 Insurance - General Liabil-ALF  (303)  (0.15)      0    (303)   4,771      0.59      0     4,771
                 Insurance - Workers Compensati  12,835  6.30       0   12,835   12,835     1.58      0    12,835
                 Insurance WC ALF              1,203     0.59       0    1,203   1,203      0.15      0     1,203
                 Late Fees & Finance Charges   1,280     0.63       0    1,280   1,610      0.20       0    1,610
                 Licenses & Permits             158      0.08       0     158      900      0.11      0      900
                 Licenses & Permits-ALF        (157)    (0.08)      0    (157)      0       0.00      0        0
                 Assessment Fees              13,086     6.42       0   13,086   56,183     6.90      0    56,183
                 Management Fees               8,875     4.36       0    8,875   97,563    11.97      0    97,563
                 Management Fees-ALF           6,125     3.01       0    6,125   24,938     3.06      0    24,938
                 Payroll Exp - Benefits         270      0.13       0     270      974      0.12      0      974
                 Payroll Exp - Payroll Taxes  14,233     6.99       0   14,233   62,683     7.69       0   62,683
                 Payroll Exp - Wages - PTO     3,262     1.60       0    3,262   8,719      1.07      0     8,719
                 Payroll Exp - Fac Admin      19,685     9.66       0   19,685   62,598     7.68       0   62,598
                 Payroll Exp-Admin Assist      6,547     3.21       0    6,547   21,213     2.60      0    21,213
                 Payroll Exp-Admin Assist-OT    507      0.25       0     507    2,430      0.30      0     2,430
                 Professional Fees - Accounting  2,749   1.35       0    2,749   9,654      1.18      0     9,654
                 Professional Fees- Account-ALF  583     0.29       0     583    1,681      0.21      0     1,681
                 Professional Fees - Legal        0      0.00       0       0    9,145      1.12      0     9,145
                 Professional Fees - Legal-ALF    0      0.00       0       0    1,940      0.24      0     1,940
                 Prof. Fees - Billing Services  699      0.34       0     699    1,464      0.18      0     1,464
                 Prof. Fees-Billing Serv-ALF    148      0.07       0     148      311      0.04      0      311
                 Professional Fees - Other        0      0.00       0       0      170      0.02      0      170
   1   2   3   4   5   6   7   8   9   10