We have 5 files for this case. PLEASE READ EACH OF THE INSTRUCTIONS BELOW. NO WORD DOC IS REQUIRED. ONLY THE SIX SHEETS OF THE EXCEL FILE NEEDS TO BE FILLED OUT. That's why I am paying for 6 pages...

Operating Statement
    
    BROOKSTONE OB/GYN ASSOCIATES
    OPERATING STATEMENTS
                        JAN    FEB    MAR    APR    MAY    JUN    JUL    AUG    SEP    OCT    NOV    DEC    TOTAL
    REVENUE:
        Professional Services                $ 678.2    $ 693.1    $ 704.9    $ 719.0    $ 732.7    $ 748.8    $ 763.8    $ 779.1    $ 794.6    $ 810.5    $ 826.7    $ 843.3    $ 9,094.7
        Less: allowances and bad debts                135.6    138.6    141.0    143.8    146.5    149.8    152.8    155.8    158.9    162.1    165.3    168.7    1,818.9
    NET REVENUE                    $ 542.6    $ 554.5    $ 563.9    $ 575.2    $ 586.2    $ 599.0    $ 611.0    $ 623.2    $ 635.7    $ 648.4    $ 661.4    $ 674.6    $ 7,275.8
    EXPENSES:
        Physician payments                $ 110.2    $ 113.3    $ 118.0    $ 122.7    $ 125.9    $ 130.6    $ 141.6    $ 141.6    $ 141.6    $ 141.6    $ 141.6    $ 141.6    $ 1,570.3
        Administrative salaries                57.5    61.6    61.6    65.7    65.7    73.9    73.9    73.9    73.9    73.9    73.9    73.9    829.4
        Benefits                27.8    28.8    29.8    31.1    31.1    33.5    27.60    27.87    28.15    28.43    28.71    29.00    351.8566485835
        Medical Supplies                10.2    10.4    10.6    10.8    10.8    11.2    11.46    11.69    11.92    12.16    12.40    12.65    136.2698709518
        Rent and Utilities                43.6    43.6    43.6    43.6    43.6    43.6    43.6    43.6    43.6    43.6    43.6    43.6    523.2
        Billing/collection fees                54.3    55.0    56.4    57.5    57.5    59.9    61.10    62.32    63.57    64.84    66.14    67.46    726.0393117431
        Equipment depreciation                2.0    2.0    2.0    2.4    2.4    2.4    2.6    2.6    2.6    2.9    2.9    2.9    29.7
        Office expense                5.0    5.0    5.0    5.0    5.0    5.0    5.0    5.0    5.0    5.0    5.0    5.0    60.0
        Liability insurance                101.7    104.0    105.7    107.9    107.9    112.3    114.57    116.86    119.19    121.58    124.01    126.49    1362.1987095184
        Contracted services                10.6    10.6    10.6    10.6    10.6    10.6    10.6    10.6    10.6    10.6    10.6    10.6    127.2
        Other                4.5    4.5    4.5    4.5    4.5    4.5    4.5    4.5    4.5    4.5    4.5    4.5    54.0
        Contribution to Dean                59.7    61.0    62.0    63.3    64.5    65.9    67.2    68.6    69.9    71.3    72.8    74.2    800.4
                        $ 487.1    $ 499.8    $ 509.8    $ 525.1    $ 529.5    $ 553.4    $ 563.7    $ 569.1    $ 574.6    $ 580.4    $ 586.1    $ 591.9    $ 6,570.5
        SURPLUS (DEFICIT)                $ 55.5    $ 54.7    $ 54.1    $ 50.1    $ 56.7    $ 45.6    $ 47.3    $ 54.1    $ 61.1    $ 68.0    $ 75.3    $ 82.7    $ 705.2
Balance Sheet
    
    BROOKSTONE OB/GYN ASSOCIATES
    BALANCE SHEET
                            JAN    FEB    MAR    APR    MAY    JUN    JUL    AUG    SEP    OCT    NOV    DEC
    ASSETS:
        Cash                    $ 44.30    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
        Accounts receivable (net)                    1,932.2    2,025.0    2,105.3    2,171.5    2,223.0    2,279.5    2,835.5    3,402.4    3,980.6    4,571.5    5,173.0    5,786.5
        Medical supply inventory                    135.0    145.0    155.0    165.0    167.0    170.0    173.0    176.0    179.0    182.0    185.0    188.0
        Prepaid...