Quarterly Statement of Cash Flows






























PROVINCE OF BOHOL
MUNICIPALITY OF BACLAYON
STATEMENT OF CASH FLOWS
3rd Quarter OF 2012

CASH FLOWS FROM OPERATING ACTIVITIES:
                Cash Inflows :
Collection of Business Income
4,162,142.75
Collection of Inter-Agency Receivables
12,685,599.98
Collection of Local Taxes
1,538,319.87
Collection of Other Income
512,581.98
Collection of Overpayment of Maintenance and Other Expenses
1,200.00
Collection of Permits and Licenses
587,570.53
Collection of Real Property Tax
827,551.66
Collection of Service and Income
1,698,739.64
Receipt of Internal Revenue Allotment
25,544,286.00
Receipt of Refund of Cash Advance for Travel
978.15
TOTAL CASH INFLOWS
47,558,970.56

Cash Outflows:
Grant of Cash Advance for Travel and Special Purpose
314,074.67
Payment for Communications Expenses
9,020.00
Payment for Grant of Subsidies and Donations
57,000.00
Payment for Other Current Assets
893,480.00
Payment for Other Maintenance and Other Operating Expenses
4,706,716.82
Payment for Taxes, Premiums and Other Fees
57,553.91
Payment for Training Expenses
201,350.00
Payment for Utility Expenses
6,850,899.28
Payment for the Repair and Maintenance of PPE
348,443.64
Payment for the Repair and Maintenance of Public Infra
2,800.00
Payment of Accounts Payable for Supp. Matls. And Other MOOE
493,392.43
Payment of Inter-Agency Payables
4,197,214.75
Payment of Professional Services
4,300.00
Payment of Salaries, Wages, Benefits and Other Compensation
14,651,759.40
Payment/Reimbursement of Traveling Expenses
378,334.96
Permit for Purchase of Inventories, Supplies and Matls. for Stock
6,667.50
Permit for Purchase of Supplies Materials and Other Inventory Items directly issued
1,369,183.73
Permit for Purchase of Agri’l Fishery and Forestry Products
14,880.00
Remittance of Withholding Taxes for BIR
2,121,402.87
Remittance for GSIS for Mandatory and Authorized Deductions
3,372,848.32
Remittance to PAG-IBIG for Mandatory and Authorized Deduction
298,282.84
Remittance to PHILHEALTH for Authorized Deductions
350,812.50
Remittance to Government Agencies and Private Entries
1,240,917.24
Transfer of Funds for Implementation of Project (MODE)
651,190.00
TOTAL CASH OUTFLOWS
42,592,524.86


Net Cash from Operating Activities
CASH FLOWS FROM INVESTING ACTIVITIES:
Cash Outflows :
Payments for Purchase of Other Assets
710,607.54
Permit of Progress Billing of Contractors of Public Infra/Refor
2,172,066.66
Purc./Fab/Const. of PPE, Public Insfra and Reforestation Proj
661,528.96
TOTAL CASH OUTFLOWS
3,544,203.16

Net Cash from Investing Activities                                                                                                       (    3,544,203.16)
TOTAL CASH PROVIDED BY OPERATING, INVESTING AND FINANCING ACTIVITIES             1,422,242.54
BALANCE, BEGINNING January 01, 2012                                                                                                21,408,908.68
BALANCE ENDING September 30,2012                                                                                                   22,831,151.22


PROVINCE OF BOHOL
MUNICIPALITY OF BACLAYON
STATEMENT OF CASH FLOWS
For the period ended December 31, 2010


GENERAL FUND


CASH FLOWS FROM OPERATING ACTIVITIES

Cash Inflows
           
        Collection of Business Income                                                                                         5,199,141.36
            Collection of Inter-agency Receivables                                                                        11,422,346.47
            Collection of Local Taxes                                                                                                    1,026,343.22
            Collection of Other Income                                                                                                    578,086.98
            Collection of Overpayment of Maintenance and Other Expenses                                           0.80
            Collection of Overpayment of Salaries, Wages, Benefits                                                   8,250.00
            Collection of Permits and Licenses                                                                                   241,855.65
            Collection of Real Property Tax                                                                                          811,351.35
            Collection of Service and Income                                                                                     1,546,895.69
            Receipt of Internal Revenue Allotment                                                                         32,519,983.00
            Total Cash Inflows                                                                                                           53,344,253.52
           
            Cash Outflows

            Grant of Cash Advance for Travel and Special Purpose                                          779,745.04
            Payment for Communications Expenses                                                                         34,134.88
            Payment for Grant of Subsidies and Donations                                                           12,000.00
            Payment for Other Current Assets                                                                              1,540,860.64
            Payment for Other Maintenance and Other Operating Expenses                       3,084,808.21
            Payment for Taxes, Premiums and Other Fees                                                                43,037.70
            Payment for Training Expenses                                                                                       254,381.87
            Payment for Utility Expenses                                                                                      6,912,656.71
            Payment for the Repair and Maintenance of PPE                                                   1,056,802.19
            Payment for the Repair and Maintenance of Public Infra                                            39,920.00
            Payment of Account Payable for Supp., Matls & Other MOOE                             551,039.48
            Payment of Inter-agency Payables                                                                               4,567,163.44
            Payment of Salaries, Wages, Benefits and Other Compensation                       18,489,682.82
            Payment/Reimbursement of Traveling Expenses                                                        640,037.93
            Pmt. for Purchase of Inventories, Supplies & Matls. for Stocks                             251,891.26
            Pmt. for Purc. Of Supp. Matls. & Other Inv. Items Directly Issue                       1,428,842.65
            Pmt. for Purchase of Agri’l, Fishery and Forestry Products                                   258,125.00
            Remittance of Witholding Taxes to BIR                                                                   2,141,338.84
            Remittance to GSIS for Mandatory and Authorized Deductions                      3,355,316.59
            Remittance to PAG-IBIG for Mandatory and Authorized Deductions              409,126.82  
            Remittance to PHILHEALTH for authorized deductions                                      467,921.02
            Remittance to government agencies and private entires                                       1,336.317.38
            Transfer of Funds for Implementation of Project (MOOE)                                       511,718.50
            Total Cash Outflows                                                                                                  48,157,968.96


Net Cash from Operating Activities                                                                                                                          5,186,284.56

FLOWS FROM INVESTING ACTIVITIES
            Payment for Purchase of Other Assets                                                              978,373.40
            Pmt. of Progress Billing of Contractors of Public Infra/ Reform                3,047,418.15
            Purc/Fab/Const. of PPE, Public Infra & Reforestation Project                 1,104,339.00
            Total Cash Outflows                                                                                            5,130,130.55

Net Cash from Investing Activities                                                                                                                          (5,130,130.55)

TOTAL CASH PROVIDED BY OPERATING, INVESTING AND FINANCING ACTIVITIES           56,154.01

BALANCE, BEGINNING January 1, 2011                                                                                   20,765,301.74
BALANCE, ENDING December 31, 2010                                                                                        20,821,455.75