Statement of Cash Flow as of December, 2010


LGU - PANGLAO , BOHOL
Statement of Cash Flows
For the month  ended,  December 31, 2010






GENERAL FUND

(Detailed)






Cash Flows from Operating Activities


Cash Inflows
General

Receipt of Internal Revenue Allotment
39,849,972.00

Collection of Local Taxes
4,470,067.48

Collection of Real Property Taxes
1,479,284.35

Collection of Special Education Tax
0.00

Collection of Permits and Licenses
8,447,981.02

Collection of Service Income
2,027,534.77

Collection of Business Income
6,116,620.34

Collection/Receipt of Subsidy Income
0.00

Collection of Interest Income
236,789.90

Collection of Receivables
0.00

Collection of Inter-agency Receivables
0.00

Collection of Intra-agency Receivables
0.00

Other Icome
3,500,000.00

Collection from Sale of Inventory Items
0.00

Receipt of Refund of Cash Advance for Travel
0.00

Receipt of Retention Fees from Contractors
0.00

Collection from From Other Funds
0.00

Collection of Overpayments of  Salaries and wages
0.00

Receipt from Other Funds
0.00

Advance Collection of RPT/SET and Other Deferred Credits


Collection from Audit Disallowances


Interfund transfers
0.00

Refund/Restitution of Cash Shortages of Collecting and Disbursing Officers


Receipt of Payment for Lost Property when Request for Relief was Denied


Collection from Closing of Petty Cash Fund


Restoration of Cash for Lost/Cancelled Checks


Total Cash Inflows
66,128,249.86

Net Cash From (Used) In Operating Activities
66,128,249.86






Cash Flows From Investing Activities:


Cash Outflows


Payment of Salaries,Wages,Benefits and Other Compensation
22,112,141.88

Remittance of Withholding Taxes to BIR
1,564,655.00

Remittance to GSIS for  mandatory and authorized deductions
4,126,561.78

Remittances to PAG-IBIG for mandatory and authorized deductions
433,743.79

Remittances to PHILHEALTH  for  authorized deductions
321,996.44

Remittance to government agencies and private entities for authorized deductions
7,353,274.01

Payment/Reimbursement of Travelling Expenses
794,713.24

Payment for Training Expenses
0.00

Payment for Utility Expenses
2,915,561.85

Payment for Communication Expenses
-

Payment for Professional Services
0.00

Payment for Other Maintenance and Other Operating Expenses
15,379,324.65

Payment for the Repair and Maintenance of Property, Plant and Equipment
1,370,419.29

Payment for the Repair and Maintenance of Public Infrastructures
0.00

Payment for the Repair and Maintenance of Reforestation Projects
0.00

Payment for Grant of Subsidies and Donations
0.00

Payment/Reimbursement of Confidential, Intelligence, Extraordinary


and Miscellaneous Expense
0.00

Payment for Taxes, Premiums and Other Fees
0.00

Payment for Purchase Of Inventories, Supplies and Materials for Stock
899,910.81

Payment of Prepaid Expenses
0.00

Payment for Transfer of Dipository
0.00

Payment of Accounts Payable for Supplies, Materials and Other MOOE
0.00

Payment of Inter-Fund Transfer
3,000,000.00


Total Cash Outflows
60,272,302.74


Net Cash From (Used) In Operating Activities
5,855,947.12






Cash Flows From Investing Activites:


Cash Inflows:


Proceeds from Sale of Investments


Proceeds from Matured Investments



Proceeds from Sales of Property, Plant and Equipment



Collection o Loans Receivables



Total Cash Inflows
0.00






Cash Outflows:



Purchase/Fabrication/Construction of Property, Plant and Equipment,



Public Infrastructures and Reforestation Projects



Payment of Progress Billing of Contractors for Agency Assets



Payment of Progress Billing of Contractors of Public Infrastructures/



Reforestation Project



Refund of Retention Fees to Contactors



Payment of Rght-of-Way



Transfers of Funds for Implementation of Capital/Infrastrurue Projects



Total Cash Outflows
0.00







Net Cash From (Used) in Investing Activities












Cash Flows From Financing Activities


Cash Inflows:



Proceeds from Loan



Proceeds from Bond Floatation



Total Cash Inflows
0.00






Cash Outflows:



Payment of Mortgage/Bonds/Loans Payable and Other Long Term Liabilities



Payment for Financial Expenses



Total Cash Outflows



Net Cash From (Used) in Financing Activities
0.00







Net Increase (Decreased) in Cash and Cash Equivalents
0.00







Cash and Cash Equivalents,  January  31, 2010
54,343,709.64







Cash and Cash Equivalents, December  31, 2010
60,199,656.76