Budget Plan Vs. Actual and a Income Statement - Excel by udm47210

VIEWS: 1,036 PAGES: 3

Budget Plan Vs. Actual and a Income Statement document sample

More Info
									                                               First United Methodist Church of Lexington
                                                               July 2009 - Financial Summary


                                               Jul-09                                            YTD 2009                    Full Year

Income Statement                     Actual        Budget
                                                                   Actual vs.
                                                                     Budget            Actual         Budget
                                                                                                                Actual vs.
                                                                                                                  Budget
                                                                                                                                    2009
                                                                                                                                  Budget

Total Income                       $105,688      $121,100           ($15,412)       $769,458        $847,700    ($78,242)      $1,453,200

Total Giving                        $89,205      $103,167           ($13,962)       $651,507        $722,167    ($70,660)      $1,238,000
  Pledges                           $63,131       $67,917            ($4,786)       $433,690        $475,417    ($41,727)       $815,000
  Non-Pledges                       $24,258       $33,333            ($9,075)       $205,704        $233,333    ($27,629)       $400,000
  Loose Offering                     $1,488        $1,583               ($95)         $9,695         $11,083     ($1,388)        $19,000
  Sunday School                       $328          $333                 ($5)         $2,418          $2,333         $85          $4,000

Other Income                        $16,483       $17,933            ($1,450)       $117,951        $125,533     ($7,582)       $215,200
  Monthly Parking                    $3,316        $2,767               $549         $24,186         $19,367      $4,819         $33,200
  Event Parking                          $0        $1,333            ($1,333)         $6,637          $9,333     ($2,696)        $16,000
  S.Upper Apartment                  $2,500        $2,500                 $0         $14,260         $17,500     ($3,240)        $30,000
  Interest / Stock Gain & Losses       $400        $1,067              ($667)         $1,001          $7,467     ($6,466)        $12,800
  Andover Cell Tower                 $1,100        $1,100                 $0          $7,700          $7,700          $0         $13,200
  Church Development Funds           $4,167        $4,167                 $0         $29,167         $29,167          $0         $50,000
  Generations Funds                  $5,000        $5,000                 $0         $35,000         $35,000          $0         $60,000


Total Expenses                     $108,554      $121,100           ($12,546)       $833,322        $847,700    ($14,378)      $1,453,200
  Apportionments                    $13,413       $14,542            ($1,129)        $96,653        $101,793     ($5,140)       $174,502
  Programs                           $6,847        $5,250            $1,597          $46,221         $36,750      $9,471         $63,000
  Outreach                           $5,015        $5,653             ($638)         $36,092         $39,568     ($3,476)        $67,830
  Church Home                       $14,929       $16,183            ($1,254)       $129,665        $113,283     $16,382        $194,200
  Staff                             $52,406       $61,796            ($9,390)       $398,923        $432,574    ($33,651)       $741,556
  Administration                      $784         $2,517            ($1,733)        $19,648         $17,617      $2,031         $30,200
  Debt Service
    General
    Andover                          $4,743        $4,743                $0          $33,201         $33,199          $2         $56,912
    FUMC Realty - Operating          $5,417        $5,417                $0          $37,919         $37,917          $2         $65,000
    FUMC Realty - Principal          $5,000        $5,000                $0          $35,000         $35,000          $0         $60,000


Income - Expenses                   ($2,866)            ($0)         ($2,866)        ($63,864)           ($0)   ($63,864)             ($0)
1st United Methodist Church
2008 - 2009 Operating Budget Expenses
                                                           2008                                               2009 Budget
                                   2008         2008     Actual-   July 2009                          2009              vs
                                 Budget        Actual   Budget-       Actual        YTD Actual      Budget     2008 Actual

Total Expenses                $1,672,383   $1,591,524   (80,859)   $108,587          $757,520    $1,453,200      (138,324)

Program Expenses               $146,263     $107,237    (39,026)     $6,847            46,221      $63,000        (44,237)
  Music Program                 $36,300      $33,942     (2,358)   $ 1,900     $       18,004      $10,000        (23,942)
  Childrens Ministries          $43,650      $31,575    (12,075)   $ 2,706     $       16,086      $27,000         (4,575)
  Youth                         $13,250       $6,976     (6,274)   $    875    $        5,529       $6,000           (976)
  Worship                       $12,800      $11,059     (1,741)   $    (20)   $          977       $5,000         (6,059)
  Church School                 $12,850       $8,026     (4,824)   $    578    $        3,446       $5,000         (3,026)
  College Ministries             $3,750       $3,009       (741)   $    838    $        1,040
  Adult Ministries               $4,000       $1,022     (2,978)               $          (61)
  Family Ministries              $8,300       $4,838     (3,462)   $      (66) $          492
  Athletics                      $1,875       $1,350       (525)               $          -
  Prayer Ministries              $2,738       $1,189     (1,549)   $       35 $           408
                                                                                                   $10,000        ($5,659)
  Older Adults                   $1,800        $812        (988)               $           72
  Library & Archives             $1,650        $898        (752)               $           50
  Scouting                       $1,000       $1,000          0                $          228
  Caring/Stephen Ministries      $1,600        $551      (1,049)               $          (50)
  Membership/Other                $700         $990         290

Apportionments                 $228,008     $196,055    (31,953)   $ 13,413     $      96,653     $174,502        (21,553)
 Conference                    $202,696     $174,293    (28,403)   $ 12,194     $      87,804     $158,638        (15,655)
 District                       $25,312      $21,762     (3,550)   $ 1,219      $       8,849      $15,864         (5,898)

Outreach Expenses               $86,210      $72,019    (14,191)   $ 5,015      $      36,092      $67,830         (4,189)
 Missions                       $54,500      $53,348     (1,152)   $ 3,492      $      31,136      $54,500          1,152
 Communications                 $23,700      $15,136     (8,564)   $   430      $       3,211      $10,000         (5,136)
 Evangelism                      $6,180       $2,769     (3,411)   $ 1,093      $       1,680       $2,500           (269)
 Christian Unity                  $830            $0       (830)   $   -        $          65        $830             830
 Lay Leadership                  $1,000        $766        (234)                                        $0           (766)

Church Home                    $175,250     $206,736    31,486     $   14,929   $     129,665     $194,200        (12,536)
 Utilities                      $63,100      $79,871    16,771     $    4,372   $      54,726      $79,600           (271)
 Property Maintenance           $53,169      $69,651    16,482     $    5,114   $      36,524      $56,600        (13,051)
 Insurance                      $27,978      $31,784     3,806     $    2,516   $      17,919      $32,000            216
 Transportation                  $6,111       $7,276     1,165     $      325   $       5,704       $6,000         (1,276)
 Lawn & Grounds                 $12,374       $7,517    (4,857)    $    2,040   $       9,112       $7,500            (17)
 Custodial                      $10,500       $9,643      (857)    $      562   $       4,589      $10,500            857
 Technology                      $2,018        $994     (1,024)    $      -     $       1,091       $2,000          1,006

Staff Expenses                 $853,529     $776,219    (77,310)   $   52,406   $     398,923     $741,556        (34,663)
  Salaries                     $620,236     $549,199    (71,037)   $   38,712   $     298,519     $558,548          9,349
  Housing Allowance             $53,518      $50,414     (3,104)   $    4,551   $      33,407      $53,711          3,297
  Medical Insurance             $60,572      $48,618    (11,954)   $    3,242   $      22,947      $46,497         (2,121)
  FICA                          $33,577      $39,016      5,439    $    2,621   $      20,094      $36,284         (2,732)
  Business Expenses             $30,600      $32,966      2,366    $      169   $       2,102       $1,500        (31,466)
  MPP/CPP Expenses              $17,952      $22,700      4,748    $    1,861   $      13,076      $19,609         (3,091)
  Lay Pension Plan              $19,667      $13,598     (6,069)   $      699   $       4,923      $18,339          4,741
  Utilities Expenses             $9,407      $16,636      7,229         $551            4,005       $7,068         (9,568)
  Education                      $8,000       $3,072     (4,928)                         (150)          $0         (3,072)

Administrative                  $60,780      $77,880    17,100          $784           19,648      $30,200        (47,680)
 Administration                 $48,980      $64,952    15,972          $784           19,648
 Stewardship                     $2,500       $3,616     1,116
 Endowment                       $1,000        $804       (196)
 Admin Board                      $700         $908        208
 Church Audit                    $7,600       $7,600         0

Debt Service                   $122,343     $155,378    33,035      $15,193            30,318     $181,912         26,534
 Andover                        $56,912       $56,912        0        $4,742           23,713       $56,912             0
 FUMC Realty - operating        $58,785       $76,856   18,071        $5,417           27,083       $65,000       (11,856)
 FUMC Realty - principal             $0            $0        0        $5,000           25,000       $60,000        60,000
 Other                           $6,646      $21,610    14,964                                          $0        (21,610)
1st United Methodist Church
Monthly Giving Comparison (Pledge, Non-Pledge, Loose, Sunday School)


          2009                Jan         Feb       March        April        May        June         July       Aug        Sept        Oct        Nov        Dec
       YTD weeks                4           8          13          17          22          26          30         35         39          43         48         52
Monthly Actual            $91,477     $82,843    $102,757    $103,008     $98,816     $81,791     $89,205
Monthly Budget           $103,167    $103,167    $103,167    $103,167    $103,167    $103,167    $103,167    $103,167   $103,167   $103,167   $103,167   $103,167
YTD Actual                $91,477    $174,320    $277,077    $380,094    $478,915    $562,299    $651,504
YTD Budget               $103,167    $206,333    $309,500    $412,667    $515,833    $619,000    $722,167    $825,333   $928,500 $1,031,667 $1,134,833 $1,238,000
YTD Actual-Budget        ($11,690)   ($32,013)   ($32,423)   ($32,573)   ($36,918)   ($56,701)   ($70,663)
YTD Actual % of Annual       7.4%       14.1%       22.4%       30.7%       38.7%       45.4%       52.6%        0.0%       0.0%       0.0%       0.0%       0.0%


          2008                Jan         Feb       March        April        May        June         July        Aug       Sept         Oct       Nov         Dec
       YTD weeks                4           8          13          17          21          26          30          35         39          43        48          52
Monthly Actual            $95,329     $98,043    $137,908    $102,868    $110,544    $128,839    $164,720    $111,269  $103,128     $98,273  $107,501    $109,281
Monthly Budget           $118,613    $118,613    $118,613    $118,613    $118,613    $118,613    $118,613    $118,613  $118,613   $118,613   $118,613    $237,225
YTD Actual                $95,329    $193,372    $331,280    $434,148    $544,692    $673,531    $838,251    $949,520 $1,052,648 $1,150,920 $1,258,421 $1,367,702
YTD Budget               $118,613    $237,226    $355,837    $474,450    $593,063    $711,676    $830,288    $948,901 $1,067,514 $1,186,127 $1,304,740 $1,541,964
YTD Actual-Budget        ($23,284)   ($43,854)   ($24,557)   ($40,302)   ($48,371)   ($38,145)     $7,962       $618    ($14,867)  ($35,207)  ($46,319) ($174,262)
YTD Actual % of Annual       6.2%       12.5%       21.5%       28.2%       35.3%       43.7%       54.4%       61.6%      68.3%      74.6%      81.6%      88.7%


          2007                Jan         Feb       March      April          May        June          July       Aug       Sept         Oct       Nov        Dec
       YTD weeks                4           8          12        17            21          25           30         34         39          43        47         52
Monthly Actual            $87,288    $110,128    $115,802 $140,478       $112,913    $127,697     $119,314   $112,035   $143,047   $103,061   $114,790  $226,013
YTD Actual                $87,288    $197,417    $313,219 $453,696       $566,610    $694,306     $813,620   $925,655 $1,068,702 $1,171,763 $1,286,553 $1,512,566
YTD Budget               $131,084    $262,168    $393,252 $524,335       $655,419    $786,503     $917,587 $1,048,671 $1,179,755 $1,310,838 $1,441,922 $1,573,006
YTD Actual-Budget        ($43,796)   ($64,751)   ($80,033) ($70,639)     ($88,810)   ($92,197)   ($103,967) ($123,016) ($111,052) ($139,075) ($155,369)  ($60,440)
YTD Actual % of Annual       5.8%       13.1%       20.7%     30.0%         37.5%       45.9%        53.8%      61.2%      70.7%      77.5%      85.1%     100.0%


          2006                Jan         Feb       March     April           May        June         July        Aug       Sept         Oct       Nov        Dec
       YTD weeks                5           9          13       18             22          26          31          35         39          44        48         53
Monthly Actual           $113,111    $108,598    $113,348 $147,912        $90,323    $122,473    $124,091    $101,093  $102,121   $117,367   $129,288   $249,248
YTD Actual               $113,111    $221,709    $335,057 $482,969       $573,292    $695,765    $819,857    $920,950 $1,023,071 $1,140,439 $1,269,726 $1,518,974
YTD Budget               $122,177    $244,355    $366,532 $488,709       $610,887    $733,064    $855,241    $977,419 $1,099,596 $1,221,773 $1,343,951 $1,466,128
YTD Actual-Budget         ($9,066)   ($22,646)   ($31,475) ($5,740)      ($37,595)   ($37,299)   ($35,385)   ($56,469)  ($76,525)  ($81,335)  ($74,224)   $52,846
YTD Actual % of Annual       7.4%       14.6%       22.1%    31.8%          37.7%       45.8%       54.0%       60.6%      67.4%      75.1%      83.6%     100.0%


          2005                Jan         Feb       March      April          May        June         July        Aug       Sept         Oct       Nov        Dec
       YTD weeks                5           9          13        17            22          26          31          35         39          44        48         52
Monthly Actual           $112,169     $95,009     $99,765   $99,765      $109,253    $135,000    $115,627     $92,582    $85,729  $126,450    $112,867  $214,844
YTD Actual               $112,169    $207,179    $306,944 $406,709       $515,962    $650,962    $766,589    $859,171   $944,900 $1,071,350 $1,184,217 $1,399,061
YTD Budget               $116,778    $233,556    $350,334 $467,111       $583,889    $700,667    $817,445    $934,223 $1,051,001 $1,167,778 $1,284,556 $1,401,334
YTD Actual-Budget         ($4,608)   ($26,377)   ($43,390) ($60,402)     ($67,927)   ($49,705)   ($50,856)   ($75,051) ($106,100)  ($96,428) ($100,339)   ($2,273)
YTD Actual % of Annual       8.0%       14.8%       21.9%     29.1%         36.9%       46.5%       54.8%       61.4%      67.5%      76.6%      84.6%     100.0%

								
To top