finances - Excel

Document Sample
finances - Excel Powered By Docstoc
					                                                                                Breckenridge Chapel Free Methodist Church 2010 Ministry Expenditures and Re
                                   Jan-10          Feb-10         Mar-10          Apr-10         May-10          Jun-10          Jul-10         Aug-10          Sep-10
Insurance                   $     716.00    $        -      $     445.00   $        -      $        -     $        -      $     445.00    $        -     $        -
Missions                    $   1,383.00    $   1,383.00    $     463.00   $     383.00    $     298.00   $     383.00    $     383.00    $     633.00   $     458.00
Conference (WAVE)           $     305.00    $     146.00    $     273.00   $     432.00    $     579.00   $     604.00    $     174.00    $     344.00   $     283.00
Utilities - Church          $     345.16    $     246.24    $     219.88   $      96.44    $     157.06   $     106.63    $     221.59    $     158.19   $     121.78
Utilities - Parsonage       $     126.57    $      69.00    $     122.69   $      69.00    $     119.39   $      71.00    $     220.73    $      71.00   $     184.00
Miscellaneous               $      32.84    $        -      $      18.03   $        -      $   2,000.00   $        -      $        -      $        -     $        -
Fellowship/Food             $     359.28    $     621.73    $     703.09   $     518.06    $     628.45   $     385.84    $     154.34    $     157.35   $     304.16
Children/Youth              $      34.93    $      15.00    $        -     $        -      $     740.00   $     111.10    $     197.24    $        -     $        -
Member Care                 $      59.36    $      74.50    $        -     $     150.00    $     529.54   $        -      $        -      $     759.16   $     750.00
Worship                     $     123.38    $        -      $     105.00   $      24.35    $      23.66   $        -      $        -      $      19.95   $        -
Pastor Salary               $     420.55    $     420.55    $     420.55   $     433.33    $     433.33   $     641.67    $     850.00    $     850.00   $     850.00
Guest Preacher              $     200.00    $     200.00    $     475.00   $     450.00    $     375.00   $     100.00    $        -      $        -     $        -
Administration              $        -      $     100.00    $     185.20   $        -      $      35.20   $      30.56    $        -      $     143.85   $      44.50
Maintenance                 $        -      $      23.68    $        -     $     260.00    $     855.05   $   1,083.75    $     383.57    $     613.51   $     605.00
Taxes and Fees              $      38.34    $        -      $       4.00   $      19.20    $        -     $        -      $        -      $        -     $        -
Total Ministry Expenses     $   4,144.41    $   3,299.70    $   3,434.44   $   2,835.38    $   6,773.68   $   3,517.55    $   3,029.47    $   3,750.01   $   3,600.44

Carry Forward               $ 12,179.40     $ 10,967.99     $ 11,315.29    $ 12,112.85     $ 13,891.47    $ 13,265.79     $ 13,079.24     $ 13,067.13    $ 11,839.12
Offerings                   $ 2,633.00      $ 3,647.00      $ 4,172.00     $ 4,614.00      $ 6,148.00     $ 2,491.00      $ 3,017.36      $ 2,522.00     $ 3,160.00
Other Income                $    300.00     $       -       $     60.00    $       -       $       -      $    840.00     $       -       $       -      $       -
Total Financial Resources   $ 15,112.40     $ 14,614.99     $ 15,547.29    $ 16,726.85     $ 20,039.47    $ 16,596.79     $ 16,096.60     $ 15,589.13    $ 14,999.12

Balance                     $ 10,967.99     $ 11,315.29     $ 12,112.85    $ 13,891.47     $ 13,265.79    $ 13,079.24     $ 13,067.13     $ 11,839.12    $ 11,398.68

Worship                          17.40           23.00           24.75          21.25           28.20          34.25           28.50           30.80          26.75
Sundays Per Month                  5               4               4              5               4              4               4               5              4
Per Capita Offering             $30.26          $39.64          $42.14         $43.43          $54.50         $18.18          $26.47          $16.38         $29.53
Admin/Legal                $    254.46
Denomination               $    352.92               Breckenridge Chapel 2010
Missions                   $    631.50
                                                                                                               Admin/Legal
Children/Youth             $     91.52
Worship                    $     39.02                     11%    7%                                           Denomination
Pastor/Preacher            $    805.83                                    9%                                   Missions
Food/Fellowship            $    367.31                                                                         Children/Youth
Building/Grounds           $    787.79              21%
                                                                               17%                             Worship
Other                      $    401.12
                                                                                                               Pastor/Preacher
                                                     10%                                                       Food/Fellowship
                                                                                      2%
                                                                  22%                                          Building/Grounds
                                                                                      1%
                                                                                                               Other

                           Expenses    Income
                    Jan     $ 4,144.41 $ 2,933.00                         Breckenridge Chapel 2010
                   Feb      $ 3,299.70 $ 3,647.00
                   Mar      $ 3,434.44 $ 4,232.00     $7,000.00
                   Apr      $ 2,835.38 $ 4,614.00     $6,000.00
                   May      $ 6,773.68 $ 6,148.00     $5,000.00
                   Jun      $ 3,517.55 $ 3,331.00
                                                      $4,000.00
                     Jul    $ 3,029.47 $ 3,017.36                                                                                            Expenses
                   Aug      $ 3,750.01 $ 2,522.00     $3,000.00
                                                                                                                                             Income
                   Sep      $ 3,600.44 $ 3,160.00     $2,000.00
                   Oct      $ 3,197.63 $ 4,578.00     $1,000.00
                   Nov      $ 3,153.15 $ 2,642.04
                                                            $-
                   Dec      $ 4,041.71 $ 3,874.54




                                                                                                                                 Nov
                                                                                                               Aug
                                                                                       Apr
                                                                                             May


                                                                                                         Jul




                                                                                                                                       Dec
                                                                          Feb




                                                                                                                     Sep
                                                                                Mar




                                                                                                                           Oct
                                                                                                   Jun
                                                                    Jan
y Expenditures and Resources
               Oct-10         Nov-10          Dec-10       Total 2010     Average 2010   Annualized 2010
        $     446.07    $     101.50   $        -      $    2,153.57    $      179.46    $    2,153.57       4.8%
        $     508.00    $     483.00   $     820.00    $    7,578.00    $      631.50    $    7,578.00      16.9%
        $     318.00    $     512.00   $     265.00    $    4,235.00    $      352.92    $    4,235.00       9.5%
        $     161.93    $     117.75   $     216.14    $    2,168.79    $      180.73    $    2,168.79       4.8%
        $     367.97    $     184.00   $     849.46    $    2,454.81    $      204.57    $    2,454.81       5.5%
        $        -      $        -     $        -      $    2,050.87    $      170.91    $    2,050.87       4.6%
        $     234.13    $     191.50   $     149.84    $    4,407.77    $      367.31    $    4,407.77       9.8%
        $        -      $        -     $        -      $    1,098.27    $       91.52    $    1,098.27       2.5%
        $        -      $      40.00   $     400.00    $    2,762.56    $      230.21    $    2,762.56       6.2%
        $        -      $      37.90   $     133.94    $      468.18    $       39.02    $      468.18       1.0%
        $     850.00    $     850.00   $     850.00    $    7,869.98    $      655.83    $    7,869.98      17.6%
        $        -      $        -     $        -      $    1,800.00    $      150.00    $    1,800.00       4.0%
        $     110.20    $      35.00   $     153.84    $      838.35    $       69.86    $      838.35       1.9%
        $     201.33    $     600.50   $     203.49    $    4,829.88    $      402.49    $    4,829.88      10.8%
        $        -      $        -     $        -      $       61.54    $         5.13   $       61.54       0.1%
        $   3,197.63    $   3,153.15   $   4,041.71    $   44,777.57    $    3,731.46    $   44,777.57     100.0%

        $ 11,398.68     $ 12,779.05    $ 12,267.94     $   12,179.40    $   12,354.18
        $ 4,578.00      $ 2,642.04     $ 3,874.54      $   43,498.94    $    3,602.22    $   43,226.62
        $       -       $       -      $       -       $    1,200.00    $      109.09    $    1,309.09
        $ 15,976.68     $ 15,421.09    $ 16,142.48     $   56,878.34    $   16,065.49

        $ 12,779.05     $ 12,267.94    $ 12,100.77     $   12,100.77    $   12,334.03

             26.00           37.50          34.00                            27.13
               5               4              4                              4.36
            $35.22          $17.61         $28.49                           $30.43
                                       Annual           Actual         Actual          Actual          Actual          Actual          Actual          Actual           Actual         Actual
                                       Budget          January        February         March           April            May             June            July            August       September
Community - Children/Youth         $      500.00   $          -     $        -     $       14.98   $         -     $      500.00   $         -     $          -     $         -     $        -
Community - SMAM                   $      500.00   $       500.00   $        -     $         -     $         -     $         -     $         -     $          -     $         -     $        -
World - Missions                   $    3,600.00   $       275.00   $    495.00    $      495.00   $      495.00   $      495.00   $      495.00   $      495.00    $      495.00   $    175.00
Congregation - Fellowship/Food     $    2,000.00   $       191.84   $      41.38   $       54.65   $      135.43   $      108.55   $       94.11   $       76.63    $       83.57   $     75.53
Congregation - Member Care         $    1,100.00   $          -     $        -     $    1,000.00   $         -     $         -     $       50.35   $          -     $         -     $        -
Congregation - Movie Night         $      700.00   $          -     $        -     $       17.12   $        5.99   $       44.17   $       60.38   $          -     $         -     $        -
Worship - General                  $      500.00   $         7.82   $      20.90   $       24.56   $       25.79   $       36.50   $       46.80   $       19.15    $         -     $        -
Witness - Visibility               $    2,500.00   $       430.41   $        -     $         -     $      275.61   $         -     $         -     $          -     $         -     $        -
Denomination - WAVE                $    4,500.00   $       295.00   $    232.25    $      225.00   $      321.19   $      282.00   $      259.88   $      187.38    $      285.50   $    181.13
Pastor Salary/Taxes                $   10,200.00   $       850.00   $    850.00    $      850.00   $      850.00   $      850.00   $      850.00   $      850.00    $      850.00   $    850.00
Pastor - Guest Preacher            $      400.00   $          -     $        -     $         -     $         -     $         -     $         -     $      200.00    $         -     $        -
Facility - Insurance               $    2,500.00   $       271.83   $    269.58    $      269.58   $      269.58   $      269.58   $      269.58   $      269.58    $      269.58   $    269.58
Facility - Utilities - Church      $    2,500.00   $       259.38   $    312.35    $      157.38   $      243.21   $      136.95   $      244.40   $      173.07    $      282.45   $    177.00
Facility - Utilities - Parsonage   $    3,000.00   $       159.00   $    304.78    $      159.00   $      249.99   $      230.00   $      398.80   $      230.00    $      373.67   $    282.00
Facility - Maintenance/Cleaning    $    2,500.00   $          -     $    221.95    $      368.32   $      174.00   $      400.00   $      191.43   $      279.00    $    1,197.92   $     99.00
Administration - General           $      500.00   $        15.16   $        -     $         -     $       19.98   $       94.90   $         -     $         1.96   $         -     $        -
Administration - Materials         $      500.00   $       242.22   $      29.65   $      125.78   $         -     $         -     $      181.33   $          -     $         -     $        -
Administration - Weddings          $         -     $          -     $        -     $         -     $         -     $      150.00   $         -     $          -     $         -     $        -
Administration - NCD Survey        $      250.00   $          -     $        -     $         -     $         -     $         -     $         -     $          -     $         -     $        -
Administration - Fees              $      429.00   $          -     $        -     $      100.00   $         -     $         -     $       75.00   $          -     $       35.00   $     75.00
Total Ministry Expenses            $   38,679.00   $     3,497.66   $ 2,777.84     $    3,861.37   $    3,065.77   $    3,597.65   $    3,217.06   $    2,781.77    $    3,872.69   $ 2,184.24

Brought Forward                    $ 11,348.95     $ 11,348.95      $ 10,203.93    $ 10,055.09     $ 8,059.21      $ 7,744.44      $   6,721.79    $   5,498.85     $    5,496.47   $   3,480.91
Offerings                          $ 39,600.00     $ 2,352.64       $ 2,429.00     $ 1,615.49      $ 2,532.00      $ 2,575.00      $   1,994.12    $   2,779.39     $    1,857.13   $   1,992.85
Other Income                       $       -       $       -        $    200.00    $    250.00     $    219.00     $       -       $        -      $        -       $         -     $        -
Total Financial Resources          $ 50,948.95     $ 13,701.59      $ 12,832.93    $ 11,920.58     $ 10,810.21     $ 10,319.44     $   8,715.91    $   8,278.24     $    7,353.60   $   5,473.76

Balance                            $ 12,269.95     $ 10,203.93      $ 10,055.09    $   8,059.21    $   7,744.44    $   6,721.79    $   5,498.85    $   5,496.47     $    3,480.91   $   3,289.52

Finance Team recommendations for October next Board Meeting
1. Recommends adopting September-December 2011 adjustments to the budget.
2. Recommends temporary adherance to recommended budget until October decision.
3. Recommends consideration of a policy for pass-throughs and designated offerings.
4. Recommends consideration of renting the parsonage (project 1 January 2012).
5. Recommends consideration of aggressive marketing of wedding chapel service.
     Actual         Actual         Actual           Total          Average         Balance
    October        November       December          2011            2011            2011
$          -     $        -     $        -     $      514.98   $       42.92   $      (14.98)
$          -     $        -     $        -     $      500.00   $       41.67   $         -
$       175.00   $     125.00   $     125.00   $    4,340.00   $      361.67   $     (740.00)
$        96.28   $     100.00   $     412.44   $    1,470.41   $      122.53   $      529.59
$          -     $        -     $        -     $    1,050.35   $       87.53   $       49.65
$          -     $        -     $        -     $      127.66   $       10.64   $      572.34
$          -     $        -     $        -     $      181.52   $       15.13   $      318.48
$          -     $        -     $        -     $      706.02   $       58.84   $    1,793.98
$       227.23   $     232.98   $     181.13   $    2,910.67   $      242.56   $    1,589.33
$       850.00   $     850.00   $     850.00   $   10,200.00   $      850.00   $         -
$          -     $        -     $        -     $      200.00   $       16.67   $      200.00
$          -     $        -     $        -     $    2,428.47   $      202.37   $       71.53
$       185.65   $     156.77   $     281.89   $    2,610.50   $      217.54   $     (110.50)
$       441.85   $     282.00   $     245.64   $    3,356.73   $      279.73   $     (356.73)
$       597.25   $      90.00   $        -     $    3,618.87   $      301.57   $   (1,118.87)
$          -     $        -     $        -     $      132.00   $       11.00   $      368.00
$          -     $        -     $        -     $      578.98   $       48.25   $      (78.98)
$          -     $        -     $        -     $      150.00   $       12.50   $     (150.00)
$          -     $        -     $        -     $          -    $         -     $      250.00
$          -     $        -     $      75.00   $      360.00   $       30.00   $       69.00
$     2,573.26   $ 1,836.75     $ 2,171.10     $   35,437.16   $    3,333.98   $    3,241.84

$    3,289.52    $   2,755.13   $   2,445.38   $ 11,348.95
$    2,038.87    $   1,527.00   $   3,555.84   $ 27,249.33     $    2,270.78   $ 12,350.67
$         -      $        -     $        -     $    669.00     $       55.75   $   (669.00)
$    5,328.39    $   4,282.13   $   6,001.22   $ 39,267.28

$    2,755.13    $   2,445.38   $   3,830.12   $    3,830.12
       Breckenridge Chapel             Annual      Projected    Projected    Projected    Projected    Projected    Projected    Projected    Projected     Projected   Projected     Projected      Projected
          Budget for 2012              Budget        January    February       March        April        May          June         July         August     September     October     November        December
Community - SMAM                   $      500.00   $      -     $     -      $     -      $     -      $     -      $ 500.00     $     -      $     -      $      -     $     -      $       -      $       -
World - Missions                   $    1,500.00   $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00       $ 125.00
Congregation - Fellowship/Food     $    1,500.00   $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00     $ 125.00       $ 125.00
Congregation - Member Care         $      500.00   $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $     41.67    $     41.67
Congregation - Bible Studies       $      240.00   $ 20.00      $ 20.00      $ 20.00      $ 20.00      $ 20.00      $ 20.00      $ 20.00      $ 20.00      $ 20.00      $ 20.00      $     20.00    $     20.00
Worship - General                  $      500.00   $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $     41.67    $     41.67
Denomination - WAVE                $    2,750.00   $ 229.17     $ 229.17     $ 229.17     $ 229.17     $ 229.17     $ 229.17     $ 229.17     $ 229.17     $ 229.17     $ 229.17     $ 229.17       $ 229.17
Pastor Salary/Taxes                $   10,200.00   $ 850.00     $ 850.00     $ 850.00     $ 850.00     $ 850.00     $ 850.00     $ 850.00     $ 850.00     $ 850.00     $ 850.00     $ 850.00       $ 850.00
Pastor Housing Allowance           $    2,250.00   $      -     $     -      $     -      $ 250.00     $ 250.00     $ 250.00     $ 250.00     $ 250.00     $ 250.00     $ 250.00     $ 250.00       $ 250.00
Pastor - Guest Preacher            $      400.00   $ 33.33      $ 33.33      $ 33.33      $ 33.33      $ 33.33      $ 33.33      $ 33.33      $ 33.33      $ 33.33      $ 33.33      $     33.33    $     33.33
Facility - Insurance               $    2,619.00   $ 291.00     $ 291.00     $ 291.00     $ 291.00     $ 291.00     $ 291.00     $ 291.00     $ 291.00     $ 291.00     $     -      $       -      $       -
Facility - Utilities - Church      $    3,000.00   $ 250.00     $ 250.00     $ 250.00     $ 250.00     $ 250.00     $ 250.00     $ 250.00     $ 250.00     $ 250.00     $ 250.00     $ 250.00       $ 250.00
Facility - Utilities - Parsonage   $      600.00   $ 200.00     $ 200.00     $ 200.00     $     -      $     -      $     -      $     -      $     -      $      -     $     -      $       -      $       -
Facility - Maintenance/Cleaning    $    2,400.00   $ 200.00     $ 200.00     $ 200.00     $ 200.00     $ 200.00     $ 200.00     $ 200.00     $ 200.00     $ 200.00     $ 200.00     $ 200.00       $ 200.00
Administration - General           $      500.00   $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $     41.67    $     41.67
Administration - Materials         $      500.00   $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $     41.67    $     41.67
Administration - Weddings          $          -    $      -     $     -      $     -      $     -      $     -      $     -      $     -      $     -      $      -     $     -      $       -      $       -
Administration - NCD Survey        $      250.00   $      -     $     -      $     -      $     -      $     -      $     -      $     -      $     -      $ 250.00     $     -      $       -      $       -
Administration - Fees              $      500.00   $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $ 41.67      $     41.67    $     41.67
Total Ministry Expenses            $   30,709.00   $ 2,531.83   $ 2,531.83   $ 2,531.83   $ 2,581.83   $ 2,581.83   $ 3,081.83   $ 2,581.83   $ 2,581.83   $ 2,831.83   $ 2,290.83   $   2,290.83   $   2,290.83


Brought Forward                    $    1,979.46   $ 1,979.46   $ 1,799.77   $ 1,620.07   $ 1,440.38   $ 1,960.69   $ 2,480.99   $ 2,501.30   $ 3,021.61   $ 3,541.91   $ 3,812.22   $   4,623.53   $   5,434.83
Offerings                          $   28,225.68   $ 2,352.14   $ 2,352.14   $ 2,352.14   $ 2,352.14   $ 2,352.14   $ 2,352.14   $ 2,352.14   $ 2,352.14   $ 2,352.14   $ 2,352.14   $   2,352.14   $   2,352.14
Other Income & Rental              $    6,750.00   $      -     $      -     $      -     $   750.00   $   750.00   $   750.00   $   750.00   $   750.00   $   750.00   $   750.00   $    750.00    $    750.00
Total Financial Resources          $   36,955.14   $ 4,331.60   $ 4,151.91   $ 3,972.21   $ 4,542.52   $ 5,062.83   $ 5,583.13   $ 5,603.44   $ 6,123.75   $ 6,644.05   $ 6,914.36   $   7,725.67   $   8,536.97


Balance                            $    6,246.14   $ 1,799.77   $ 1,620.07   $ 1,440.38   $ 1,960.69   $ 2,480.99   $ 2,501.30   $ 3,021.61   $ 3,541.91   $ 3,812.22   $ 4,623.53   $   5,434.83   $   6,246.14

                                       2012          2011       Difference
Average Offering/Sunday            $      532.56   $ 524.03     $     8.53
Average Offering/Worshiper         $       22.19   $ 22.18      $     0.01
Worshippers                            24.00         23.63
     Total        Average      Balance
     2012          2012         2012
$      500.00   $    41.67   $      -
$    1,500.00   $ 125.00     $      -
$    1,500.00   $ 125.00     $      -
$      500.00   $    41.67   $      -
$      240.00   $    20.00   $      -
$      500.00   $    41.67   $      -
$    2,750.00   $ 229.17     $      -
$   10,200.00   $ 850.00     $      -
$    2,250.00   $ 187.50     $      -
$      400.00   $    33.33   $      -
$    2,619.00   $ 218.25     $      -
$    3,000.00   $ 250.00     $      -
$      600.00   $    50.00   $      -
$    2,400.00   $ 200.00     $      -
$      500.00   $    41.67   $      -
$      500.00   $    41.67   $      -
$          -    $      -     $      -
$      250.00   $    20.83   $      -
$      500.00   $    41.67   $      -
$   30,709.00   $ 2,559.08   $      -

$ 1,979.46
$ 28,225.68     $ 2,352.14   $      -
$ 6,750.00      $ 562.50     $      -
$ 36,955.14

$    6,246.14

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:169
posted:8/18/2012
language:
pages:7