Accountant's Report For the quarter ended June 30, 2016

Parent Category: Financial Reports

Consolidated Statement of Cash Flows

Consolidated Statement of Cash Flows

For the quarter ended June 30, 2016

Particulars	Total	General Fund	Special Education Fund	Trust Fund
Cash Flows from Operating Activities
Cash Inflows
Collection from taxpayers	27,492,187.20	18,837,113.88	8,655,073.32	-
Share from Internal Revenue Allotment	242,406,684.00	242,406,684.00	-	-
Receipts from business/service income	27,779,552.17	27,779,552.17	-	-
Interest Income	1,076,819.25	851,394.79	54,429.58	170,994.88
Other Receipts	54,101,680.90	18,073,893.43	-	36,027,787.47
Total Cash Inflows	352,856,923.52	307,948,638.27	8,709,502.90	36,198,782.35
Cash Outflows
Payment of expenses	4,247,425.36	4,241,425.36	6,000.00	-
Payments to suppliers and creditors	38,621,704.98	28,324,017.22	2,209,398.26	8,088,289.50
Payments to employees	125,283,946.99	124,994,874.53	-	289,072.46
Other Expenses	42,244,444.85	27,332,608.47	356,850.38	14,554,986.00
Total Cash Outflows	210,397,522.18	184,892,925.58	2,572,248.64	22,932,347.96
Net Cash Flows from Operating Activities	142,459,401.34	123,055,712.69	6,137,254.26	13,266,434.39
Cash Flows from Investing Activities
Cash Inflows
Total Cash Inflows	-	-	-	-
Cash Outflows
Purchase/Construction of Property, Plant and Equipment	33,690,629.45	28,975,620.17	563,320.58	4,151,688.70
Total Cash Outflows	33,690,629.45	28,975,620.17	563,320.58	4,151,688.70
Net Cash Flows from Investing Activities	(33,690,629.45)	(28,975,620.17)	(563,320.58)	(4,151,688.70)
Cash Flows from Financing Activities
Cash Inflows
Total Cash Inflows	-	-	-	-
Cash Outflows
Payment of loan amortization	8,964,682.77	8,964,682.77
Total Cash Outflows	8,964,682.77	8,964,682.77	-	-
Net Cash Flows from Financing Activities	(8,964,682.77)	(8,964,682.77)	-	-
Total Cash Provided by Operating, Investing and
Financing Activities	99,804,089.12	85,115,409.75	5,573,933.68	9,114,745.69
Add: Cash at the Beginning of the year	246,922,296.54	171,772,116.42	14,704,944.56	60,445,235.56
Cash Balance at the End of the Quarter	346,726,385.66	256,887,526.17	20,278,878.24	69,559,981.25

Certified Correct :

GLADYS P. HURAÑO, CPA

City Accountant

On Disaster Risk Reduction And Mgt. Fund Utilization

REPORT OF UTILIZATION OF DISASTER RISK REDUCTION AND MANAGEMENT FUND
As of June 30, 2016

City: ISLAND GARDEN CITY OF SAMAL

PARTICULARS	LDRRMF
	Quick Response Fund (QRF) 30%	Mitigation Fund 70%	NDRRMF	From Other LGUs	From Other Sources	TOTAL
A. Source of Funds
Current Appropriation	7,723,047.13	18,020,443.32				25,743,490.45
Continuing Appropriation	7,650,372.14	12,730,132.41				20,380,504.55
Previous Year's Appropriation Transferred to the Special Trust Fund:						-
						-
CY 2010		420,000.00				420,000.00
CY 2011		1,570,331.52				1,570,331.52
CY 2012		1,374,437.95				1,374,437.95
CY 2013		298,973.57				298,973.57
CY 2014		8,906,952.23				8,906,952.23
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,373,419.27	43,321,271.00	-	-	150,000.00	58,844,690.27
B. Utilization
Medicines						-
Food Supplies		63,722.00				63,722.00
Non-Food Supplies		1,039,160.84			13,400.00	1,052,560.84
Repair of Evacuation Center						-
Institutional/Capacity Development (Ex. Trainings, environmental assessments & other related activities		746,650.00				746,650.00
Land		500,000.00				500,000.00
Construction of Evacuation Center		2,000,000.00				2,000,000.00
Road Concreting		79,662.07				79,662.07
Core Shelters						-
Equipment	2,296,000.00	229,010.00				2,525,010.00
Transfer to other LGUs						-
Transfer to Special Trust - Calamity Fund						-
Transfer to General Fund						-
Others (Please specify)						-
- Traveling Expenses		39,360.00				39,360.00
- R/M - Rescue Equipment		206,706.00				206,706.00
- Printing and Binding Expenses		175.00				175.00
- Rent Expenses		5,000.00				5,000.00
- Representation Expenses		24,800.00				24,800.00
- Subscription Expenses		4,000.00				4,000.00
- Transportation and Delivery Expenses		200.00				200.00
- Other Professional Services		44,344.51				44,344.51
- Plastic Drums for Farmers		192,850.00				192,850.00
- Other Maintenance and Other Operating Expenses					42,000.00	42,000.00
Total Utilization	2,296,000.00	5,175,640.42	-	-	55,400.00	7,527,040.42
Unutilized Balance	13,077,419.27	38,145,630.58	-	-	94,600.00	51,317,649.85

Prepared by: ROSALE C. APAT

Admin Off IV

Certified Correct : GLADYS P. HURAÑO, CPA

City Accountant

ON GOVERNMENT PROJECTS, PROGRAMS OR ACTIVITIES

CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS OR ACTIVITIES

FOR THE 2ND QUARTER, CY 2016

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		477,989.54		re-program for bidding
Concreting of FMR Sitio Bagsak to Anonang Road Section	Barangay Aumbay	3,000,000.00	05/05/15	10/02/15	100%	2,507,234.69
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
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%	3,678,673.46
Drainage Improvement	Sitio Supa, Peñaplata	3,908,909.00	10/7/2015	3/5/2016	100%	1,928,195.59
Const of Centralized Mango Sorting/Packing House Phase 2	Maag, Peñaplata	2,400,000.00	12/16/2015	3/14/2016	100%	2,084,535.78
Water System Rehabilitation (BUB)	Tagdaliao/Libertad/San Isidro (K)/Toril/Sto. Niño	3,723,600.00						for pre-procurement process
Provision of Potable Water Supply	Balet/Aundanao	2,800,000.00	4/20/2016	9/30/2016
Fish Capture Project	Islandwide	3,600,000.00	12/1/2014	12/31/2015	100%	3,237,650.18
Animal Health Care Management Project	Islandwide	600,000.00	12/1/2014	12/31/2015	97%	582,579.78
Barangay Upland Vegetable Production Project	15 Upland Brgys	100,000.00	12/1/2014	12/31/2015	91%	91,430.72
Fish Processing (Bangus Deboning)	Camudmud	120,000.00	12/1/2014	12/31/2015	85%	102,500.20
Social Pension of Indigent Senior Citizen	Islandwide	4,138,500.00	4/1/2016	6/30/2016	100%	3,960,000.00
Supplementary Feeding Program	Islandwide	2,449,628.80	9/1/2015	04/30/16	100%	2,423,228.80
Green House Vegetable Production	Bandera, Aumbay, Peñaplata, Sto.Niño	1,400,000.00	11/1/2015	11/1/2016	10%	139,500.00		on procurement process
Gulayan for Upland Barangay	Balet, Caliclic, San Isidro-Babak, Tagpopongan,Libuak, Aumbay, SanMiguel, Tagbay, Limao, Cawag, Kanaan, Libertad, Pangubatan, San Isidro-K, San Remegio	2,100,000.00	11/1/2015	11/1/2016	4%	96,447.90		on procurement process
Hog Raising Projects	Balet	1,120,000.00	6/30/2016	12/31/2016
Fish Sanctuary Management	Cogon(K), Linosutan, Dadatan	2,800,000.00	6/15/2016	12/31/2016
Fish Capture with Fishing Boat	7 Coastal Brgys	1,620,000.00	6/15/2016	12/31/2016
Fish R onward to Seaweeds Culture Project	Islandwide	2,000,000.00	6/15/2016	12/31/2016
Capacity Building MNCHN, TB, Dengue Control, STD/HIV and Aids Prevention	Islandwide	812,000.00	5/1/2016	12/31/2016	9%	76,954.55
Training for Better Access to Job Opportunities (Trabajo Program)	Islandwide	10,000,000.00	4/26/2016	12/31/2016

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:

GLADYS P. HURAÑO, CPA

City Accountant

Schedule of Advances to Officers and Employees

Schedule of Advances to Officers and Employees

As of June 30, 2016

Agency Name ISLAND GARDEN CITY OF SAMAL			Account Title	Advances to Officers and Employees

Agency Code 65-02			Account Code	148
Fund Title	General Fund
Name of Debtor	Amount Balance	Date Granted	Purpose	A m o u n t D u e

				C u r r e n t			P a s t D u e
(in alphabetical order)				less than 30 days	31- 90 days	91- 365 days	Over 1 Year	Over 2 years	3 year s & above
TRAVEL:
Bantillo, Ruel	5,400.00	6/27/2016	Travel Cash Advance	5,400.00
Bustamante, Percenito	8,740.00	6/24/2016	Travel Cash Advance	8,740.00
Colmenares, Abelardo	5,100.00	6/27/2016	Travel Cash Advance	5,100.00
Guindolman, Richard	5,100.00	6/27/2016	Travel Cash Advance	5,100.00
Padillo, Joel	13,800.00	6/7/2016	Travel Cash Advance	13,800.00
Rosario, Samuel	4,500.00	6/27/2016	Travel Cash Advance	4,500.00
Esdrelon, Nieljun	4,800.00	6/27/2016	Travel Cash Advance	4,800.00
Mara, Godofredo	4,500.00	6/27/2016	Travel Cash Advance	4,500.00
Villarica, Napoleon Roberto	4,800.00	6/27/2016	Travel Cash Advance	4,800.00
Colmenares, Glenn	5,100.00	6/27/2016	Travel Cash Advance	5,100.00
San Juan, Alfonso Sr.	5,400.00	6/27/2016	Travel Cash Advance	5,400.00
Ortiz, Alberto	4,800.00	6/27/2016	Travel Cash Advance	4,800.00
Gervacio, Dan	5,100.00	6/27/2016	Travel Cash Advance	5,100.00
Gervacio, Luduig	5,400.00	6/27/2016	Travel Cash Advance	5,400.00
Quesada, Lludeza	25,900.00	6/23/2016	Travel Cash Advance	25,900.00
SPECIAL PURPOSE:
ALLOSA, CHELEAL	6,100.00	6/27/2016	CA for Capability Bldg @ Mati City	6,100.00
ANTALAN, ANIANO P	52,643,380.00	*** 2011 - 2015	CA Intelligence Fund				8,420,000.00	12,236,000.00	31,987,380.00
***Complete Liquidation Reports for all of the above Cash Advances for Confidential Fund have been promptly transmitted to COA Central Office. However, to date, we still have not received any Credit Notice for these advances.
CABALLERO, MERLINA	215,000.00	6/20/2016	CA for Kadagayaan 2016	215,000.00
DENIEGA, MABEL	16,074.00	5/17/2016	CA for Youth Leadership Summit		16,074.00
DENIEGA, MABEL	22,500.00	6/1/2016	CA for Community Participation Activity	22,500.00
LANZADERAS, ELNIE	10,000.00	5/30/2016	CA for Technical Assistance and Assessment re: Prime HRM Systems		10,000.00
LARIOSA, ABUNDIA	147,600.00	6/20/2016	CA for Day Care Worker's Evaluation @ Davao City	147,600.00
SALA, EDUNEL	15,800.00	6/22/2016	CA for Mid Year Evaluation of CVET Personnel	15,800.00
SISOR, EDWARD	158,838.00	6/25/2016	CA for Plane ticket of Dept Head at Manila	158,838.00
SISOR, EDWARD	392,600.00	6/10/2016	CA for Exposure & Study Trip at Marikina City	392,600.00
SISOR, EDWARD	169,390.00	6/21/2016	CA for Planning Workshop & Competency Profiling at Davao City	169,390.00
SUAREZ, XANDRA MAY	22,600.00	6/20/2016	CA for Mid Year Evaluation of CENRO	22,600.00
UY, AL DAVID	600.00	6/28/2016	CA for rent of chairs and tables	600.00



UNDERLIQUIDATION:
PRIETO, DOREENJEN	5.00	6/30/2016	underliquidation	5.00
ACEDILLO, ARLENE	0.50	6/30/2016	underliquidation	0.50



TOTAL	53,928,927.50			1,259,473.50	26,074.00	-	8,420,000.00	12,236,000.00	31,987,380.00

Trust Fund - Proper
Name of Debtor	Amount Balance	Date Granted	Purpose	A m o u n t D u e

				C u r r e n t			P a s t D u e
(in alphabetical order)				less than 30 days	31- 90 days	91- 365 days	Over 1 Year	Over 2 years	3 year s & above
TRAVEL:
QUESADA, LLUDEZA	25,290.00	6/13/2016	CA for Yaman Pinoy Program	25,290.00
SPECIAL PURPOSE:
LARIOSA, ABUNDIA	26,400.00	6/13/2016	CA for Day Care Worker's Evaluation	26,400.00
FLORES, DENNIS CARLOS	9,600.00	6/22/2016	CA for BUB Monitoring	9,600.00
UNDERLIQUIDATION:
SULARTE, ALICIA	53.89	6/30/2016	UNDERLIQUIDATION	53.89

TOTAL	61,343.89			61,343.89	0.00	0.00	0.00	0.00	0.00

Certified Correct :

GLADYS P. HURAÑO, CPA

City Accountant