Statement of Receipts and Expenditure (2011)

Statement of Receipts and Expenditures
Municipality: MIAGAO
Period Covered: Q4, 2011

           
        Population:  
Particulars Income Target/ Budget Appropriation General Fund SEF Total                           (C + D) % of General + SEF to Total Income(GF+SEF)               
A B C D E F
LOCAL SOURCES (9+13)         

32,038,498
         

20,582,036
       

1,117,700
     

21,699,736
23.49%
TAX REVENUE (10+11+12)         

16,425,209
           

4,189,349
       

1,117,700
       

5,307,049
5.75%
  Real Property Tax         

12,435,209
              

894,160
       

1,117,700
       

2,011,861
2.18%
  Tax on Business           

2,980,000
           

2,666,819
         

2,666,819
2.89%
  Other Taxes           

1,010,000
              

628,370
           

628,370
0.68%
NON-TAX REVENUE (14+15+16+17)         

15,613,289
         

16,392,687
                  

-  
     

16,392,687
17.75%
  Regulatory Fees (Permit and Licenses)           

2,029,000
           

2,148,318
                  

-  
       

2,148,318
2.33%
  Service/User Charges (Service Income)             

601,500
              

859,798
                  

-  
         

859,798
0.93%
  Income from Economic Enterprises (Business Income)         

11,582,789
         

13,110,611
                  

-  
     

13,110,611
14.19%
  Other Receipts (Other General Income)           

1,400,000
              

273,960
                  

-  
         

273,960
0.30%
EXTERNAL SOURCES (19+20+21+22)         

82,776,779
         

70,673,222
                  

-  
     

70,673,222
76.51%
  Internal Revenue Allotment         

82,776,779
         

70,673,222
                  

-  
     

70,673,222
76.51%
 Other Shares from National Tax Collections                      

-  
                      

-  
                  

-  
                  

-  
0.00%
  Inter-Local Transfer                      

-  
                      

-  
                  

-  
                  

-  
0.00%
  Extaordinary Receipts/Grants/Donations/Aids                      

-  
                      

-  
                  

-  
                  

-  
0.00%
TOTAL CURRENT OPERATING INCOME (8+18)       

114,815,277
         

91,255,257
       

1,117,700
     

92,372,958
100.00%
LESS: CURRENT OPERATING EXPENDITURES (PS + MOOE+FE)          
  General Public Services         

48,574,393
         

41,157,174
                  

-  
     

41,157,174
45.93%
  Department of Education           

3,307,629
           

1,286,624
       

1,355,554
       

2,642,179
2.95%
  Health, Nutrition & Population Control         

11,535,774
         

10,691,725
                  

-  
     

10,691,725
11.93%
  Labor & Employment                      

-  
                      

-  
                  

-  
                  

-  
0.00%
  Housing & Community Development           

1,580,000
              

978,532
                  

-  
         

978,532
1.09%
  Social Services & Social Welfare           

3,575,765
           

3,446,364
                  

-  
       

3,446,364
3.85%
  Economic Services         

35,743,740
         

30,695,623
                  

-  
     

30,695,623
34.25%
  Debt Service (FE) (Interest Expense & Other Charges)                      

-  
                      

-  
                  

-  
                  

-  
0.00%
TOTAL CURRENT OPERATING EXPENDITURES (25 to 32)       

104,317,301
         

88,256,043
       

1,355,554
     

89,611,597
100.00%
NET OPERATING INCOME/(LOSS) FROM CURRENT OPERATIONS(23-33)         

10,497,976
           

2,999,215
        

(237,854)
       

2,761,360
0.00%
ADD: NON INCOME RECEIPTS          
CAPITAL/INVESTMENT RECEIPTS (37+38+39)                      

-  
                      

-  
                  

-  
                  

-  
#DIV/0!
  Proceeds from Sale of Assets                      

-  
                      

-  
                  

-  
                  

-  
#DIV/0!
  Proceeds from Sale of Debt Securities of Other Entities                      

-  
                      

-  
                  

-  
                  

-  
#DIV/0!
  Collection of Loans Receivables                      

-  
                      

-  
                  

-  
                  

-  
#DIV/0!
RECEIPTS FROM LOANS AND BORROWINGS (41+42)                      

-  
                      

-  
                  

-  
                  

-  
#DIV/0!
  Acquisition of Loans                      

-  
                      

-  
                  

-  
                  

-  
#DIV/0!
  Issuance of Bonds                      

-  
                      

-  
                    

-  
#DIV/0!
TOTAL NON-INCOME RECEIPTS (36+40)                      

-  
                      

-  
                  

-  
                  

-  
#DIV/0!
LESS: NON OPERATING EXPENDITURES          
CAPITAL/INVESTMENT EXPENDITURES (46+47+48)         

14,813,011
           

8,634,479
         

315,359
       

8,949,838
100.00%
  Purchase/Construct of Property Plant and Equipment  (Assets/Capital Outlay)         

14,813,011
           

8,634,479
         

315,359
       

8,949,838
100.00%
  Purchase of Debt Securities of Other Entities (Investment Outlay)                      

-  
                      

-  
                  

-  
                  

-  
0.00%
  Grant/Make Loan to Other Entities (Investment Outlay)                      

-  
                      

-  
                  

-  
                  

-  
0.00%
DEBT SERVICE (50+51) (Principal Cost)                      

-  
                      

-  
                  

-  
                  

-  
#DIV/0!
  Payment of Loan Amortization                      

-  
                      

-  
                  

-  
                  

-  
#DIV/0!
  Retirement/Redemption of Bonds/Debt Securities                      

-  
                      

-  
                  

-  
                  

-  
#DIV/0!
TOTAL NON-OPERATING EXPENDITURES (45+49)         

14,813,011
           

8,634,479
         

315,359
       

8,949,838
 
NET INCREASE/(DECREASE) IN FUNDS (34+43-52)          

(4,315,035)
          

(5,635,264)
        

(553,214)
      

(6,188,478)
 
ADD: CASH BALANCE, BEGINNING         

24,894,977
         

23,430,124
       

1,464,853
     

24,894,977
 
FUNDS AVAILABLE (53+54)         

20,579,942
         

17,794,860
         

911,639
     

18,706,499
 
Less: Payment of Prior Year Accounts Payable                      

-  
                      

-  
                  

-  
                  

-  
 
FUND BALANCE, END (55-56)         

20,579,942
         

17,794,860
         

911,639
     

18,706,499
 
CONTINUING  APPROPRIATION                      

-  
                      

-  
                    

-  
                             

-  
Total Assets                      

-  
       
           
Amount set aside to finance projects with appropriations  
GF
SEF
Total
 
      provided in the previous years (Continuing appropriations)            

13,653,530
         

244,901
     

13,898,431
 
Amount set aside for payment of Prior Year Accounts Payable                 

524,460
           

17,050
         

541,510
 
Amount set aside for Obligation not yet Due and Demandable             

21,332,136
         

845,356
     

22,177,492
 
Amount Available for appropriations/operations              

9,136,771
         

292,205
       

9,428,976
 
Fund Balance, End (should be reconciled w/cash flow statement)            

44,646,897
       

1,399,511
     

46,046,409
 

Statement of Receipts and Expenditure (2010)

Statement of Receipts and Expenditures
Municipality: MIAGAO
Period Covered: Q4, 2010

           
        Population:  
Particulars
Income Target/ Budget Appropriation
General Fund
SEF
Total (C + D)
% of General + SEF to Total Income(GF+SEF)               
A B C D E F
LOCAL SOURCES (9+13)           

23,700,500
          

17,670,601
       

1,743,329
        

19,413,930
19.52%
TAX REVENUE (10+11+12)           

10,990,000
            

4,350,301
       

1,743,329
          

6,093,630
6.13%
  Real Property Tax            

2,000,000
            

1,394,663
       

1,743,329
          

3,137,991
3.16%
  Tax on Business            

3,335,000
            

2,165,740
            

2,165,740
2.18%
  Other Taxes            

5,655,000
               

789,898
              

789,898
0.79%
NON-TAX REVENUE (14+15+16+17)           

12,710,500
          

13,320,300
                  

-  
        

13,320,300
13.39%
  Regulatory Fees (Permit and Licenses)            

1,974,000
            

1,375,028
                  

-  
          

1,375,028
1.38%
  Service/User Charges (Service Income)               

551,500
            

1,556,283
                  

-  
          

1,556,283
1.56%
  Income from Economic Enterprises (Business Income)            

9,645,000
          

10,040,822
                  

-  
        

10,040,822
10.10%
  Other Receipts (Other General Income)               

540,000
               

348,167
                  

-  
            

348,167
0.35%
EXTERNAL SOURCES (19+20+21+22)           

77,044,864
          

80,044,864
                  

-  
        

80,044,864
80.48%
  Internal Revenue Allotment           

77,044,864
          

77,044,864
                  

-  
        

77,044,864
77.46%
 Other Shares from National Tax Collections                        

-  
                       

-  
                  

-  
                     

-  
0.00%
  Inter-Local Transfer                        

-  
                       

-  
                  

-  
                     

-  
0.00%
  Extaordinary Receipts/Grants/Donations/Aids                        

-  
            

3,000,000
                  

-  
          

3,000,000
3.02%
TOTAL CURRENT OPERATING INCOME (8+18)         

100,745,364
          

97,715,465
       

1,743,329
        

99,458,794
100.00%
LESS: CURRENT OPERATING EXPENDITURES (PS + MOOE+FE)          
  General Public Services           

50,660,622
          

43,476,486
                  

-  
        

43,476,486
53.06%
  Department of Education            

3,959,000
            

1,250,591
       

1,938,626
          

3,189,217
3.89%
  Health, Nutrition & Population Control           

12,266,339
          

11,312,365
                  

-  
        

11,312,365
13.81%
  Labor & Employment                        

-  
                       

-  
                  

-  
                     

-  
0.00%
  Housing & Community Development            

1,493,000
            

1,193,644
                  

-  
          

1,193,644
1.46%
  Social Services & Social Welfare            

2,557,911
            

2,524,741
                  

-  
          

2,524,741
3.08%
  Economic Services           

22,864,305
          

20,246,689
                  

-  
        

20,246,689
24.71%
  Debt Service (FE) (Interest Expense & Other Charges)                        

-  
                       

-  
                  

-  
                     

-  
0.00%
TOTAL CURRENT OPERATING EXPENDITURES (25 to 32)           

93,801,177
          

80,004,516
       

1,938,626
        

81,943,142
100.00%
NET OPERATING INCOME/(LOSS) FROM CURRENT OPERATIONS(23-33)            

6,944,187
          

17,710,950
         

(195,298)
        

17,515,652
0.00%
ADD: NON INCOME RECEIPTS          
CAPITAL/INVESTMENT RECEIPTS (37+38+39)                        

-  
                       

-  
                  

-  
                     

-  
#DIV/0!
  Proceeds from Sale of Assets                        

-  
                       

-  
                  

-  
                     

-  
#DIV/0!
  Proceeds from Sale of Debt Securities of Other Entities                        

-  
                       

-  
                  

-  
                     

-  
#DIV/0!
  Collection of Loans Receivables                        

-  
                       

-  
                  

-  
                     

-  
#DIV/0!
RECEIPTS FROM LOANS AND BORROWINGS (41+42)                        

-  
                       

-  
                  

-  
                     

-  
#DIV/0!
  Acquisition of Loans                        

-  
                       

-  
                  

-  
                     

-  
#DIV/0!
  Issuance of Bonds                        

-  
                       

-  
                       

-  
#DIV/0!
TOTAL NON-INCOME RECEIPTS (36+40)                        

-  
                       

-  
                  

-  
                     

-  
#DIV/0!
LESS: NON OPERATING EXPENDITURES          
CAPITAL/INVESTMENT EXPENDITURES (46+47+48)           

14,456,170
          

10,637,644
            

33,995
        

10,671,639
100.00%
  Purchase/Construct of Property Plant and Equipment  (Assets/Capital Outlay)           

14,456,170
          

10,637,644
            

33,995
        

10,671,639
100.00%
  Purchase of Debt Securities of Other Entities (Investment Outlay)                        

-  
                       

-  
                  

-  
                     

-  
0.00%
  Grant/Make Loan to Other Entities (Investment Outlay)                        

-  
                       

-  
                  

-  
                     

-  
0.00%
DEBT SERVICE (50+51) (Principal Cost)                        

-  
                       

-  
                  

-  
                     

-  
#DIV/0!
  Payment of Loan Amortization                        

-  
                       

-  
                  

-  
                     

-  
#DIV/0!
  Retirement/Redemption of Bonds/Debt Securities                        

-  
                       

-  
                  

-  
                     

-  
#DIV/0!
TOTAL NON-OPERATING EXPENDITURES (45+49)           

14,456,170
          

10,637,644
            

33,995
        

10,671,639
 
NET INCREASE/(DECREASE) IN FUNDS (34+43-52)           

(7,511,983)
            

7,073,305
         

(229,293)
          

6,844,013
 
ADD: CASH BALANCE, BEGINNING           

15,476,199
          

13,783,754
       

1,692,445
        

15,476,199
 
FUNDS AVAILABLE (53+54)            

7,964,216
          

20,857,059
       

1,463,152
        

22,320,211
 
Less: Payment of Prior Year Accounts Payable               

426,364
               

426,364
                  

-  
            

426,364
 
FUND BALANCE, END (55-56)            

7,537,852
          

20,430,696
       

1,463,152
        

21,893,848
 
CONTINUING  APPROPRIATION                        

-  
                       

-  
                       

-  
                             

-  
Total Assets                        

-  
       
           
Amount set aside to finance projects with appropriations  
GF
SEF
Total
 
      provided in the previous years (Continuing appropriations)               

9,410,580
          

130,151
          

9,540,731
 
Amount set aside for payment of Prior Year Accounts Payable                  

320,364
            

17,050
            

337,414
 
Amount set aside for Obligation not yet Due and Demandable                

7,346,989
          

786,622
          

8,133,611
 
Amount Available for appropriations/operations               

9,894,402
          

259,141
        

10,153,543
 
Fund Balance, End (should be reconciled w/cash flow statement)             

26,972,336
       

1,192,964
        

28,165,300