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