Accountant's Reports For the Quarter Ended December 31, 2015 (Fourth Quarter 2015)

Parent Category: Financial Reports

Consolidated Statement of Cash Flows

ISLAND GARDEN CITY OF SAMAL

Consolidated Statement of Cash Flows

For the quarter ended December 31, 2015

Particulars			Total	General Fund	Special Education Fund	Trust Fund
Cash Inflows
	Share from Internal Revenue Allotment		110,736,450.00	110,736,450.00	-	-
	Collection from Taxpayers		2,846,861.48	1,423,430.74	1,423,430.74	-
	Receipts from sale of goods and services		-	-	-	-
	Interest Income		708,577.03	690,243.44	18,333.59	-
	Other Receipts		37,930,515.33	15,253,298.78	23,575.46	22,653,641.09
	Total Cash Inflows		152,222,403.84	128,103,422.96	1,465,339.79	22,653,641.09
Cash Outflows
	Payments to -
		Suppliers / Creditors	116,343,912.93	111,032,323.82	803,017.89	4,508,571.22
		Employees	31,693,646.24	27,899,341.72	174,000.00	3,620,304.52
	Interest Expenses		1,131,871.51	1,131,871.51	-	-
	Other Disbursements		3,206,526.60	2,613,486.25	-	593,040.35
	Total Cash Outflows		152,375,957.28	142,677,023.30	977,017.89	8,721,916.09

Cash Provided by (Used in)			(153,553.44)	(14,573,600.34)	488,321.90	13,931,725.00

Cash Inflows
	Sale of Property, Plant and Equipment		-	-	-	-
	Sale of Debt Securities of Other Entities		-	-	-	-
	Other Receipts		262,402.50	262,402.50	-	-
	Total Cash Inflows		262,402.50	262,402.50	-	-
Cash Outflows
	Purchase of Property, Plant and Equipment		7,509,093.32	671,492.62	96,766.79	6,740,833.91
	Infrastructures		306,552.80	89,167.70	-	217,385.10
	Purchase of Debt Securities of Other Entities		-	-	-	-
	Grant/Loans to Other Entities		-	-	-	-
	Other Disbursements		584,598.91	262,402.50	-	322,196.41
	Total Cash Outflows		8,400,245.03	1,023,062.82	96,766.79	7,280,415.42

Cash Provided by (Used in)			(8,137,842.53)	(760,660.32)	(96,766.79)	(7,280,415.42)

Cash Inflows
	Issuance of Debt Securities
	Acquisition of Loan		-	-
	Total Cash Inflows		-	-	-	-
Cash Outflows
	Retirement/Redemption of Debt Securities
	Payment of Loan Amortization		4,508,670.63	4,508,670.63
	Total Cash Outflows		4,508,670.63	4,508,670.63	-	-

Cash Provided by (Used in)			(4,508,670.63)	(4,508,670.63)	-	-

Net Cash Provided By (Used In)			(12,800,066.60)	(19,842,931.29)	391,555.11	6,651,309.58
Cash at the Beginning of the Period Oct 1 2015			259,722,363.14	191,615,047.71	14,313,389.45	53,793,925.98
Cash at the End of the Period			246,922,296.54	171,772,116.42	14,704,944.56	60,445,235.56

Certified Correct:

GLADYS P. HURAÑO, CPA

City Accountant

Utilization of Disaster Risk Reduction and Management Fund

REPORT OF UTILIZATION OF DISASTER RISK REDUCTION AND MANAGEMENT FUND

As of December 31, 2015

City: ISLAND GARDEN CITY OF SAMAL

PARTICULARS	LDRRMF		NDRRMF	From Other LGUs	From Other Sources	TOTAL
PARTICULARS	Quick Response Fund (QRF) 30%	Mitigation Fund 70%	NDRRMF	From Other LGUs	From Other Sources	TOTAL
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
CY 2014		8,978,012.23				8,978,012.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,310,830.73	53,295,791.33	-	-	150,000.00	68,756,622.06
B. Utilization
Medicines						-
Food Supplies		36,946.00				36,946.00
Non-Food Supplies		2,954,865.69				2,954,865.69
Repair of Evacuation Center						-
Institutional/Capacity Development (Ex. Trainings, environmental assessments & other related activities		1,249,150.55				1,249,150.55
Construction of Evacuation Center		-				-
Improvement of Evacuation & Operation Center		3,499,040.68				3,499,040.68
Installation of Early Warning Device		138,088.60				138,088.60
Road Concreting @ New City Hall Site		2,953,965.42				2,953,965.42
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,480,875.11				1,480,875.11
Construction of gabions/steep slope protection		428,220.00				428,220.00
Sanitary Landfill		2,000,000.00				2,000,000.00
Septage and Waste Water Facility		1,000,000.00				1,000,000.00
Transformers with accessories		147,200.00				147,200.00
Core Shelters						-
Equipment		2,776,332.77				2,776,332.77
Transfer to other LGUs						-
Transfer to Special Trust - Calamity Fund	6,770,458.59	2,207,553.64				8,978,012.23
Transfer to General Fund		1,491,707.54				1,491,707.54
Others (Please specify)						-
- Traveling Expenses		332,838.45				332,838.45
- Printing and Binding Expenses		4,990.00				4,990.00
- Rent Expense		120,326.50				120,326.50
- Representation Expenses		109,000.00				109,000.00
- Transportation and Delivery Expenses		5,000.00				5,000.00
- Subscription Expenses		9,100.00				9,100.00
- Other Professional Services		1,519,875.92				1,519,875.92
- R/m - Office Equipment		22,400.00				22,400.00
- R/m - Rescue & Emergency Vehicle		561,080.00				561,080.00
- R/M - Other Machineries and Equipt		38,958.00				38,958.00
- Other MOOE		3,277.80				3,277.80
Total Utilization	6,770,458.59	28,144,497.77	-	-	-	34,914,956.36
Unutilized Balance	8,540,372.14	25,151,293.56	-	-	150,000.00	33,841,665.70

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 FOURTH 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
Program or Project	Location	Total Cost	Date Started	Target Completion Date	% of Completion	Total Cost Incurred to Date	No. of Extensions, if any	Remarks
Concreting of FMR Libertad to Tucanga Road Section	Barangay Libertad	3,000,000.00	04/05/15	09/10/15		477,833.46		contract for rescind
Concreting of FMR Sitio Bagsak to Anonang Road Section	Barangay Aumbay	3,000,000.00	05/05/15	10/02/15	100%	1,716,151.22		completed as of January 7, 2016
Concreting of FMR Sitio Dos to Sitio Kila Road Section	Barangay Balet	4,400,000.00	04/23/15	09/10/15	100%	2,245,632.79		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%	2,362,718.62		completed last June 30, 2015
Drainage Improvement	Sitio Supa, Peñaplata	3,908,909.00	10/7/2015	3/5/2016	75%	1,735,393.98
Const of Centralized Mango Sorting/Packing House Phase 2	Maag, Peñaplata	2,400,000.00	1/15/2015	12/31/2015	35%	22,073.73
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	85%	85,525.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	85%	2,439,500.00
Supplementary Feeding Program	Islandwide	2,449,628.80	9/1/2015	04/30/16	40%	987,786.42
Water System Rehabilitation (BUB)	Islandwide	3,723,600.00						for bidding
Green House Vegetable Production (BUB)	Bandera, Aumbay, Peñaplata, Sto.Niño	1,400,000.00	11/1/2015	11/1/2016		-		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,074.00		on procurement process

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

Approved:

ANIANO P. ANTALAN

City Mayor

Schedule of Advances to Officers and Employees

Schedule of Advances to Officers and Employees

As of December 31, 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

Purpose

A m o u n t D u e

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

SPECIAL PURPOSE:

ANTALAN, ANIANO P

52,643,380.00

*** 2011 - 2015

CA Intelligence Fund

5,500,000.00

13,906,000.00

10,987,400.00

22,249,980.00

DENIEGA, MABEL

5,000.00

12/16/2015

CA for Pinakamaanyag na Barangay 2015

5,000.00

UNDERLIQUIDATION:

ACEDILLO, ARLENE

365.90

12/31/2015

underliquidation

365.90

BT - Poblacion Kaputian

0.10

12/31/2015

underliquidation

0.10

BT - Tagbaobo

49.00

11/30/2015

underliquidation

49.00

DE LUNA, PERLITA

20.00

11/30/2015

underliquidation

20.00

SULARTE, ALICIA

0.75

10/30/2015

underliquidation

0.25

0.50

TELEMPROS, JOAN

5.00

10/30/2015

underliquidation

5.00

TELEMPROS, JOAN

1,350.00

12/31/2015

underliquidation

1,350.00

TOTAL

52,650,170.75

6,716.25

74.50

5,500,000.00

13,906,000.00

10,987,400.00

22,249,980.00

Bitmap Bitmap

***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.

Certified Correct:

GLADYS P. HURAÑO, CPA

City Accountant