Statement of Cash Flow 1st Quarter

by | Apr 9, 2012 | Statement of Cash Flow

Consolidated Statement of Cash Flows
For the Quarter Ending March 31, 2012
         
Cash Flows from Operating Activities:    
      Cash Inflows:    
    Collection from taxpayers P
7,425,992.38
    Share from Internal Revenue Collections  
20,107,062.00
    Receipts from sale of goods or services  
2,807,580.10
    Interest Income  
0.00
    Dividend Income  
0.00
    Other Receipts  
3,299,523.45
    Total Cash Inflow P
33,640,157.93
  Cash Outflows:    
    Payments-    
    To suppliers/creditors P
15,738,087.79
    To Employees  
11,228,383.37
    Interest Expense  
0.00
    Other Expenses  
1,260,000.00
    Total Cash Outflow P
28,226,471.16
  Net Cash from Operating Activities P
5,413,686.77
Cash Flows from Investing Activities:    
  Cash Inflows:    
    From Sale of Property, Plant and Equipment P
0.00
    From Sale of Debt Securities of Other Entities  
0.00
    From Collection of Principal on Loans to Other Entities
0.00
    Total Cash Inflow P
0.00
  Cash Outflow:    
    To Purchase Property,Plant & Equipment P
351,365.65
    To Purchase Debt Securities of Other Entities  
0.00
    To Grant/Make Loans to Other Entities  
0.00
    Total Cash Outflow P
351,365.65
  Net Cash From Investing Activities P
(351,365.65)
Cash Flows from Financing Activities:    
  Cash Inflows:    
    From Issuance of Debt Securities P
0.00
    From Acquisition of Loan  
0.00
    Total Cash Inflow P
0.00
  Cash Outflows:    
    Retirement/Redemption of Debt Securities P
0.00
    Payment of Loan Amortization  
0.00
    Total Cash Outflow P
0.00
  Net Cash from Financing Activities P
0.00
Net Increase/Decrease in Cash P
5,062,321.12
Cash at the Beginning of the Period  
30,065,836.86
Cash at the End of the Period P
35,128,157.98

Statement of Receipts and Expenditure (2011)

by | Jan 30, 2012 | Statement of Receipts and Expenditure

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 Debt Service (2011)

by | Jan 23, 2012 | Statement of Debt Service

STATEMENT OF DEBT SERVICE

For the Year Ended December 31, 2011

 This is to certify that the Debt Service Expenses of the Local Government Unit of Miagao, Iloilo for the calendar year 2011 are as follows:

 

Amount of Loan

Debt Service Expenses for the Year 2011

 

Remaining Balance on Principal as of December 31, 2011

P 11,500,000.00

Principal         

1,162,234.60

P

2,615,027.69

 

Interest

202,138.06

 

 

 

Total

1,364,372.66

 

 

 

 Certified Correct:

 MARY GRACE P. CEPE

Supervising Administrative Officer

Acting Municipal Accountant

 

 Approved:

 

HON. JULIETA N. FLORES
     Municipal Mayor

PDAF Utilization Report (BANAT)

by | Jun 9, 2011 | PDAF Utilization

PDAF- (BANAT) UTILIZATION REPORT

( Thru: Congressman Salvador B.Britanico)

For the Year Ended December 31, 2010

 

Amount Received

Total Expenditures as of Dec. 31, 2010

Balance
     

P 4,945,000.00

P 3,187,980.53

P 1,757,019.47

SARO No. G-10-05375 dated June 25, 2010

    

 

Certified Correct:

 

 

(SGD)

MARY GRACE P. CEPE

Supervising Administrative Officer

Acting Municipal Accountant

 

 

 

Approved :

 

 

(SGD)

JULIETA N. FLORES

Municipal Mayor