Page 5 - Financial Workbook October
P. 5

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

                                                     CURRENT PERIOD                      YEAR TO DATE
                                             Actual $ Actual / Day  Budget $  Var $  Actual $ Actual / Day  Budget $  Var $
                 GENERAL AND ADMINISTRATIVE (con't)
                 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    160       0.14      0     160    1,205      0.13      0     1,205
                 Late Fee/Finance Charges-ALF    34       0.03      0      34      89       0.01      0       89
                 Licenses & Permits               0       0.00      0       0    2,825      0.30      0     2,825
                 Licenses & Permits-ALF           0       0.00      0       0    1,775      0.19      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         1,072      0.95      0    1,072   1,261      0.14      0     1,261
                 ADP Payroll Processing           0       0.00      0       0    1,483      0.16      0     1,483
                 ADP Payroll Processing - ALF     0       0.00      0       0      315      0.03      0      315
                 Payroll Exp - Payroll Taxes      0       0.00      0       0   (10,997)   (1.19)     0   (10,997)
                 SUTA Taxes                       0       0.00      0       0    8,774      0.95      0     8,774
                 SUTA Taxes ALF                   0       0.00      0       0      822      0.09      0      822
                 FUTA Taxes                       0       0.00      0       0    1,944      0.21      0     1,944
                 FUTA Taxes ALF                   0       0.00      0       0      182      0.02      0      182
                 Payroll Exp - Workers Comp    2,405      2.14      0    2,405   4,810      0.52      0     4,810
                 Postage & Delivery Expenses      0       0.00      0       0      801      0.09      0      801
                 Printing & Copier Expense      163       0.14      0     163    1,691      0.18      0     1,691
                 Printing & Copier Expense-ALF   30       0.03      0      30      61       0.01      0       61
                 Professional fees - Accounting  515      0.46      0     515    1,628      0.18      0     1,628
                 Professional fees-Account-ALF  109       0.10      0     109      345      0.04      0      345
                 Professional Fees - Architect  2,651     2.35      0    2,651   4,656      0.50      0     4,656
                 Professional Fees - Arch. ALF    0       0.00      0       0      425      0.05      0      425
                 Professional Fees - Other        0       0.00      0       0    2,298      0.25      0     2,298
                 Software Expense               945       0.84      0     945    10,027     1.08      0    10,027
                 Software Expense-ALF           165       0.15      0     165      353      0.04      0      353
                 Supplies - Office               18       0.02      0      18    2,326      0.25      0     2,326
                 Supplies - Office-ALF            4       0.00      0       4      494      0.05      0      494
                 Travel expenses - Mileage      195       0.17      0     195      781      0.08      0      781
                 Travel expenses - Mileage-ALF   41       0.04      0      41      166      0.02      0      166
                 Bank Charges                     0       0.00      0       0      13       0.00      0       13
                 Insurance - General Liability  3,190     2.83      0    3,190   25,487     2.75      0    25,487
                 Insurance - General Liabil-ALF  677      0.60      0     677    5,447      0.59      0     5,447
                 Insurance - Workers Compensati   0       0.00      0       0    12,835     1.38      0    12,835
                 Insurance WC ALF                 0       0.00      0       0    1,203      0.13      0     1,203
                 Late Fees & Finance Charges     20       0.02      0      20    1,630      0.18      0     1,630
                 Licenses & Permits               0       0.00      0       0      900      0.10      0      900
                 Assessment Fees               7,183      6.38      0    7,183   63,366     6.83      0    63,366
                 Management Fees              14,438     12.82      0   14,438  112,000    12.08      0   112,000
                 Management Fees-ALF           3,063      2.72      0    3,063   28,000     3.02      0    28,000
                 Payroll Exp - Benefits           0       0.00      0       0      974      0.11      0      974
                 Payroll Exp - Payroll Taxes   7,663      6.81      0    7,663   70,346     7.59      0    70,346
                 Payroll Exp - Wages - PTO     1,388      1.23      0    1,388   10,107     1.09      0    10,107
                 Payroll Exp - Fac Admin       7,802      6.93      0    7,802   70,400     7.59      0    70,400
                 Payroll Exp-Admin Assist      2,703      2.40      0    2,703   23,915     2.58      0    23,915
                 Payroll Exp-Admin Assist-OT    422       0.37      0     422    2,852      0.31      0     2,852
                 Professional Fees - Accounting  2,945    2.62      0    2,945   12,599     1.36      0    12,599
                 Professional Fees- Account-ALF  625      0.55      0     625    2,306      0.25      0     2,306
                 Professional Fees - Legal        0       0.00      0       0    9,145      0.99      0     9,145
                 Professional Fees - Legal-ALF    0       0.00      0       0    1,940      0.21      0     1,940
                 Prof. Fees - Billing Services    0       0.00      0       0    1,464      0.16      0     1,464
                 Prof. Fees-Billing Serv-ALF      0       0.00      0       0      311      0.03      0      311
                 Professional Fees - Other        0       0.00      0       0      170      0.02      0      170
                 Professional Fees-Other-ALF      0       0.00      0       0      36       0.00      0       36
                 Rent Expense                 21,000     18.65      0   21,000  126,000    13.59      0   126,000
                 Software Expense               550       0.49      0     550    4,950      0.53      0     4,950
                 Taxes - Personal Property      140       0.12      0     140    1,260      0.14      0     1,260
                 Taxes - Real Estate           1,848      1.64      0    1,848   16,632     1.79      0    16,632
                 Utilities - Security & Fire      0       0.00      0       0    1,183      0.13      0     1,183
                 TOTAL GENERAL AND ADMINISTRATIVE  84,162  74.74    0   84,162  651,766    70.28      0   651,766
   1   2   3   4   5   6   7   8   9   10