Financial Reports For the Quarter EndedSeptember 30, 2015 (Third Quarter 2015)

Parent Category: Financial Reports

Consolidated Statement of Cash Flows

For the quarter ended September 30, 2015

       Total   General Fund   Special Education Fund   Trust Fund 
Cash Inflows        
  Share from Internal Revenue Allotment        110,736,453.00        110,736,453.00                            -                                -  
  Collection from Taxpayers            2,916,973.54            1,458,486.77          1,458,486.77                              -  
  Receipts from sale of goods and services                              -                                -                              -                                -  
  Interest Income               247,050.71               181,706.79               12,757.06                 52,586.86
  Other Receipts          27,181,508.65          14,375,720.78                      28.50          12,805,759.37
  Total Cash Inflows        141,081,985.90        126,752,367.34          1,471,272.33          12,858,346.23
Cash Outflows        
  Payments to -        
    Suppliers / Creditors          72,960,799.34          70,124,242.60             264,740.00            2,571,816.74
    Employees          12,286,727.57          12,082,278.03             192,770.91                 11,678.63
  Interest Expenses               579,837.66               579,837.66                            -                                -  
  Other Disbursements          42,348,204.76          39,566,694.76                      10.00            2,781,500.00
  Total Cash Outflows        128,175,569.33        122,353,053.05             457,520.91            5,364,995.37
             
Cash Provided by (Used in)          12,906,416.57            4,399,314.29          1,013,751.42            7,493,350.86
             
Cash Inflows        
  Sale of Property, Plant and Equipment                               -                                -                              -                                -  
  Sale of Debt Securities of Other Entities                              -                                -                              -                                -  
  Other Receipts                               -                                -                              -                                -  
  Total Cash Inflows                              -                                -                              -                                -  
Cash Outflows        
  Purchase of Property, Plant and Equipment          11,797,732.63            5,217,818.36               54,715.89            6,525,198.38
  Infrastructures               254,996.25               147,974.43                            -                 107,021.82
  Purchase of Debt Securities of Other Entities                              -                                -                              -                                -  
  Grant/Loans to Other Entities                              -                                -                              -                                -  
  Other Disbursements                   6,393.00                   6,393.00                            -                                -  
  Total Cash Outflows          12,059,121.88            5,372,185.79               54,715.89            6,632,220.20
             
Cash Provided by (Used in)        (12,059,121.88)          (5,372,185.79)              (54,715.89)          (6,632,220.20)
             
Cash Inflows        
  Issuance of Debt Securities        
  Acquisition of Loan          39,800,000.00          39,800,000.00    
  Total Cash Inflows          39,800,000.00          39,800,000.00                            -                                -  
Cash Outflows        
  Retirement/Redemption of Debt Securities        
  Payment of Loan Amortization            6,193,864.80            6,193,864.80    
  Total Cash Outflows            6,193,864.80            6,193,864.80                            -                                -  
             
Cash Provided by (Used in)          33,606,135.20          33,606,135.20                            -                                -  
             
Net Cash Provided By (Used In)          34,453,429.89          32,633,263.70             959,035.53               861,130.66
Cash at the Beginning of the Period Jul 1 2015        225,268,933.25        158,981,784.01        13,354,353.92          52,932,795.32
Cash at the End of the Period        259,722,363.14        191,615,047.71        14,313,389.45          53,793,925.98
             
        Certified Correct:    
             
        GLADYS P. HURAÑO, CPA  
        City Accountant    

REPORT OF UTILIZATION OF DISASTER RISK REDUCTION AND MANAGEMENT FUND

As of September 30, 2015

City: ISLAND GARDEN CITY OF SAMAL

PARTICULARS   LDRRMF     NDRRMF    From Other LGUs    From Other Sources    TOTAL 
 Quick Response Fund (QRF) 30%   Mitigation Fund 70% 
A. Source of Funds            
       Current Appropriation      7,650,372.14      17,850,868.31             25,501,240.45
       Continuing Appropriation      7,660,458.59      13,094,424.43             20,754,883.02
       Previous Year's Appropriation   Transferred to the Special Trust Fund:                                        -  
                                         -  
        CY 2010          1,911,707.54               1,911,707.54
        CY 2011          1,796,930.65               1,796,930.65
        CY 2012          2,188,397.57               2,188,397.57
        CY 2013          7,475,450.60               7,475,450.60
Cash Prize for Gawad Kalasag Awardee                  50,000.00               50,000.00
Cash Prize for Gawad Kalasag (1st Prize) - Component City                   50,000.00               50,000.00
Cash Prize - 3rd Placer for Best CDRRMC Component City (Gawad Kalasag 2014)                  50,000.00               50,000.00
Total Funds Available    15,310,830.73      44,317,779.10                         -                           -          150,000.00       59,778,609.83
B. Utilization            
Medicines                                        -  
Food Supplies                36,240.00                     36,240.00
Non-Food Supplies          1,306,922.58               1,306,922.58
Repair of Evacuation Center                                        -  
Institutional/Capacity Development (Ex. Trainings, environmental assessments & other related activities             945,533.55                  945,533.55
Construction of Evacuation Center                               -                                      -  
Improvement of Evacuation & Operation Center             976,118.17                  976,118.17
Satellite Evacuation Center @ Babak                29,346.24                     29,346.24
Installation of Early Warning Device             138,088.60                  138,088.60
Road Concreting @ New City Hall Site          2,939,821.57               2,939,821.57
Repair/Rehab of canals, bridges and drainage          1,553,705.10               1,553,705.10
Land          1,500,000.00               1,500,000.00
Imprv't/Rehab of Existing Overflow Bridge @ Tagdaliao          1,466,263.75               1,466,263.75
Construction of gabions/steep slope protection             410,000.00                  410,000.00
Core Shelters                                        -  
Equipment          2,349,932.77               2,349,932.77
Transfer to other LGUs                                        -  
Transfer to Special Trust - Calamity Fund                                        -  
Transfer to General Fund          1,491,707.54               1,491,707.54
Others (Please specify)                                        -  
- Traveling Expenses             242,719.77                  242,719.77
- Printing and Binding Expenses                  4,990.00                       4,990.00
- Rent Expense             104,776.50                  104,776.50
- Representation Expenses                64,500.00                     64,500.00
- Subscription Expenses                  6,000.00                       6,000.00
- Other Professional Services             709,494.07                  709,494.07
- R/m - Office Equipment                22,400.00                     22,400.00
- R/m - Rescue & Emergency Vehicle             176,670.00                  176,670.00
- R/M - Other Machineries and Equipt                37,990.00                     37,990.00
- Other MOOE                  3,277.80                       3,277.80
Total Utilization                           -        16,516,498.01                         -                           -                           -         16,516,498.01
Unutilized Balance    15,310,830.73      27,801,281.09                         -                           -          150,000.00       43,262,111.82
             
       Certified Correct:     
             
         GLADYS P. HURAÑO, CPA   
         City Accountant    

CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS OR ACTIVITIES

FOR THE 3RD QUARTER, CY 2015

ISLAND GARDEN CITY OF SAMAL

Program or Project Location  Total Cost  Date Started Target Completion Date Project Status   No. of Extensions, if any  Remarks 
          % of Completion  Total Cost Incurred to Date 
Concreting of FMR Libertad to Tucanga Road Section Barangay Libertad      3,000,000.00 04/05/15 09/10/15 20%           480,545.52    
Concreting of FMR Sitio Bagsak to Anonang Road Section Barangay Aumbay      3,000,000.00 05/05/15 10/02/15 35%           437,677.18    
Concreting of FMR Sitio Dos to Sitio Kila Road Section Barangay Balet      4,400,000.00 04/23/15 09/10/15 100%        4,036,076.69   completed last August 29, 2015
Concreting of FMR Mambago A to Mambago B Road Section Mambago A to Mambago B      4,000,000.00 04/24/15 08/21/15 100%        1,952,749.65   completed last June 30, 2015
Drainage Improvement Sitio Supa, Peñaplata      3,908,909.00 10/7/2015 3/5/2016                            -     on going
Const of Centralized Mango Sorting/Packing House Phase 2 Maag, Peñaplata      2,400,000.00 1/15/2015 12/31/2015                            -     bidded last Oct. 15, 2015
Fish Capture Project Islandwide      3,600,000.00 12/1/2014 12/31/2015 3%           108,320.00    
Animal Health Care Management Project Islandwide         600,000.00 12/1/2014 12/31/2015 90%           542,250.00    
Barangay Upland Vegetable Production Project 15 Upland Brgys         100,000.00 12/1/2014 12/31/2015 75%             75,605.00    
Fish Processing (Bangus Deboning) Camudmud         120,000.00 12/1/2014 12/31/2015 7%               8,858.00    
                 
Social Pension of Indigent Senior Citizen Islandwide      2,847,000.00 7/1/2015 9/30/2015 97%        2,781,500.00    
Supplementary Feeding Program Islandwide      2,449,628.80 9/1/2015 04/30/16                            -      
We hereby certify that we have reviewed the contents and hereby attest to the veracity and correctness of the data or information contained in this document.    
                 
Prepared by:         Approved by:     
                 
                 
                 
GLADYS P. HURAÑO, CPA          HON. ANIANO P. ANTALAN  
City Accountant            City Mayor     
Schedule of  Advances to Officers and Employees               
                   
As of September 30, 2015              
                   
                   
Agency Name      ISLAND GARDEN CITY OF SAMAL   Account Title  Advances to Officers and Employees   Fund Title General Fund
                   
Agency Code       65-02     Account Code 148          
                   
Name of Debtor (in alphabetical order)   Amount Balance   Date Granted     A m o u n t   D u e           
 Purpose
  C u r r e n t   P a s t   D u e  
        less than 30 days 31- 90 days 91- 365 days Over   1    Year      Over    2 years 3 year s & above
TRAVEL                  
ANTALAN, TERESITA                     800.00 9/11/2015  Travel Cash Advance                      800.00          
CABALLERO, MERLINA                  4,100.00 9/14/2015  Travel Cash Advance                   4,100.00          
CAMASO, JEMELITA                     200.00 9/14/2015  Travel Cash Advance                      200.00          
ESDRELON, NIELJUN                14,335.00 9/8/2015  Travel Cash Advance                 14,335.00          
FUERTES, JOSE ERSANTE                  4,180.00 9/29/2015  Travel Cash Advance                   4,180.00          
GARDE, ROSEMARIE                10,000.00 8/19/2015  Travel Cash Advance                     10,000.00        
IBO, VIRGINIA                36,000.00 9/29/2015  Travel Cash Advance                 36,000.00          
LUNA, ELIZABETH                  2,500.00 9/10/2015  Travel Cash Advance                   2,500.00          
ORTIZ, ALBERTO                14,535.00 9/7/2015  Travel Cash Advance                 14,535.00          
ORTIZ, ALBERTO                24,444.00 9/10/2015  Travel Cash Advance                 24,444.00          
TALATTAG, VLADIMIR                  1,950.00 8/19/2015  Travel Cash Advance                       1,950.00        
UY, AL DAVID                  5,600.00 8/26/2015  Travel Cash Advance                       5,600.00        
VILLARICA, NAPOLEON ROBERTO                14,535.00 9/7/2015  Travel Cash Advance                 14,535.00          
SPECIAL PURPOSE:                  
ALLOSA, CHELEAL                43,900.00 9/24/2015  CA for Cooperative Month Celebration                 43,900.00          
ANTALAN, ANIANO P         52,643,380.00  *** 2011 - 2015   CA Intelligence Fund                5,740,000.00        13,916,000.00       10,737,400.00        22,249,980.00
CARIAGA, JENNIFER                45,000.00 8/19/2015  CA for Phil Travel Mart                     45,000.00        
DENIEGA, MABEL                     (98.32) 8/5/2015  CA for Pangapog Celebration                           (98.32)        
DENIEGA, MABEL                  1,000.00 8/11/2015  CA for Dalit Kalingawan at Cogon, Babak                       1,000.00        
DENIEGA, MABEL                  4,800.00 9/18/2015  CA for Dalit Kalingawan at Bandera                   4,800.00          
DENIEGA, MABEL              123,056.00 9/18/2015  CA for sports for LGU Sportsfest 2015               123,056.00  
 
     
***Complete Liquidation Reports for all of the above Cash Advances for Intelligence Fund have been promptly transmitted to COA Central Office. However, to date, we still have not received any Credit Notice for these advances.            
                   
                   
                   
                   
                   
                   
LARIOSA, ABUNDIA                  4,000.00 9/4/2015  CA for Financial Assistance                   4,000.00          
LARIOSA, ABUNDIA                32,950.00 9/28/2015  CA for cash prizes for Senior Citizen                 32,950.00          
PACALDO, MARIO                24,989.00 9/14/2015  CA for TEV and other expenses for Phil Statistics Advocacy Project                 24,989.00          
PRIETO, DOREENJEN              233,300.00 9/23/2015  CA for World Teachers Day Celebration               233,300.00          
SISOR, EDWARD                28,000.00 9/8/2015  CA for Workshop on Prime HRM                 28,000.00          
UNDERLIQUIDATION:                  
PRIETO, DOREENJEN                     298.94 9/30/2015  underliquidation                      298.94          
TELEMPROS, JOAN                     870.01 9/30/2015  underliquidation                      870.01          
                   
                   
TOTAL         53,318,624.63                  611,792.95                  63,451.68           5,740,000.00        13,916,000.00       10,737,400.00        22,249,980.00
                   
                   
                   
                   
                   
             Certified Correct :      
                   
                   
                   
              GLADYS P. HURAÑO, CPA   
              CITY ACCOUNTANT   
              CITY ACCOUNTING OFFICE