Statement of Receipts and Expenditures

Municipality: MIAGAO

Period Covered: Q2, 2009

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

14,399,500
7,144,300
  

1,044,313
                

-  
      

8,188,613
30.98%
TAX REVENUE (10+11+12)     

7,175,000
3,224,908
  

1,044,313
                

-  
      

4,269,221
16.15%
  Real Property Tax     

3,750,000
     

835,450
  

1,044,313
        

1,879,763
7.11%
  Tax on Business     

2,820,000
      

2,030,260
          

2,030,260
7.68%
  Other Taxes        

605,000
         

359,198
            

359,198
1.36%
NON-TAX REVENUE (14+15+16+17)     

7,224,500
      

3,919,392
             

-  
                

-  
      

3,919,392
14.83%
  Regulatory Fees (Permit and Licenses)     

1,324,000
      

1,041,147
             

-  
        

1,041,147
3.94%
  Service/User Charges (Service Income)        

901,500
         

457,983
             

-  
          

457,983
1.73%
  Income from Economic Enterprises (Business Income)     

4,500,000
      

2,274,586
             

-  
        

2,274,586
8.61%
  Other Receipts (Other General Income)        

499,000
         

145,676
             

-  
          

145,676
0.55%
EXTERNAL SOURCES (19+20+21+22)   

72,139,889
    

18,239,716
             

-  
     

3,933,664
    

22,173,380
69.02%
  Internal Revenue Allotment   

72,139,889
    

18,239,716
             

-  
      

18,239,716
69.02%
  Other Shares from National Tax Collections                

-  
                 

-  
             

-  
                   

-  
0.00%
  Inter-Local Transfer                

-  
                 

-  
             

-  
                   

-  
0.00%
  Extaordinary Receipts/Grants/Donations/Aids                

-  
                 

-  
             

-  
     

3,933,664
      

3,933,664
0.00%
TOTAL CURRENT OPERATING INCOME (8+18)   

86,539,389
    

25,384,016
  

1,044,313
     

3,933,664
    

30,361,993
100.00%
LESS: CURRENT OPERATING EXPENDITURES (PS + MOOE+FE)            
  General Public Services   

45,972,783
    

15,369,869
             

-  
     

3,452,327
    

18,822,196
53.12%
  Department of Education     

3,610,978
          

84,739
    

785,476
                

-  
        

870,215
3.01%
  Health, Nutrition & Population Control   

11,891,455
      

4,702,013
             

-  
                

-  
      

4,702,013
16.25%
  Labor & Employment                

-  
                 

-  
             

-  
                

-  
                 

-  
0.00%
  Housing & Community Development     

3,465,185
         

804,517
             

-  
                

-  
        

804,517
2.78%
  Social Services & Social Welfare     

2,210,712
         

868,791
             

-  
                

-  
        

868,791
3.00%
  Economic Services   

19,236,875
      

6,320,210
             

-  
                

-  
      

6,320,210
21.84%
  Debt Service (FE) (Interest Expense & Other Charges)     

1,700,000
                 

-  
             

-  
                   

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

88,087,988
    

28,150,139
    

785,476
     

3,452,327
    

32,387,942
100.00%
NET OPERATING INCOME/(LOSS) FROM CURRENT OPERATIONS(23-33)    

(1,548,599)
     

(2,766,123)
    

258,837
       

481,337
     

(2,025,949)
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)     

9,004,641
      

2,734,377
             

-  
                

-  
      

2,734,377
100.00%
  Purchase/Construct of Property Plant and Equipment  (Assets/Capital Outlay)     

9,004,641
      

2,734,377
             

-  
                

-  
      

2,734,377
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)     

9,004,641
      

2,734,377
             

-  
                

-  
      

2,734,377
 
NET INCREASE/(DECREASE) IN FUNDS (34+43-52)  

(10,553,240)
     

(5,500,500)
    

258,837
       

481,337
     

(4,760,326)
 
ADD: CASH BALANCE, BEGINNING   

16,132,879
    

13,544,148
  

2,588,731
     

8,899,820
    

25,032,699
 
FUNDS AVAILABLE (53+54)     

5,579,639
      

8,043,648
  

2,847,568
     

9,381,156
    

20,272,373
 
Less: Payment of Prior Year Accounts Payable                

-  
                 

-  
             

-  
                   

-  
 
FUND BALANCE, END (55-56)     

5,579,639
      

8,043,648
  

2,847,568
     

9,381,156
    

20,272,373
 
CONTINUING  APPROPRIATION     

7,449,239
      

3,812,831
          

3,812,831
  3,636,408
Total Assets                

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

130,147
                

-  
      

6,970,147
 
Amount set aside for payment of Prior Year Accounts Payable           722,918       

40,859
                

-  
        

763,777
 
Amount set aside for Obligation not yet Due and Demandable         2,979,279     

723,700
     

7,476,904
    

11,179,883
 
Amount Available for appropriations/operations          7,861,125     

619,230
                

-  
      

8,480,354
 
Fund Balance, End (should be reconciled w/cash flow statement)      18,403,322   

1,513,935
     

7,476,904
    

27,394,161