Quarterly Statement of Cash Flows

Republic of the Philippines
Province of Bohol
Municipality of Baclayon
STATEMENT OF CASHFLOVYS
GENERAL FUND
For the Year Ended December 31,2012






Collection from Taxes
p
1,700,712.76
Share from Internal Revenue Collections

34,119,868.11
Receipts from sale of goods and selVices

412,550.00
Interest Income

294.831.33
Dividend Incomes



 
CASH FLOm  FROM OPERATING ACTIVITIES Cash lnf1ows:






Other Receipts
Total Cash Inflow
Cash Outflows:
P~ents-
To suppliers/creditors
To employaes
Interest Expenses
Other Expenses
Total Cash Outflow
Net Cash Operating Activities
Cash Flows from Investing  Activities
Cash Inflows:
From Sale of Property. Plant and Equipment
From Sale of Dept Securities of Other Entities
From Collection of Principal on Loans to Other Entities
Total Cash Inflow
Cash Outflows:

34.191.561.90
p       70,719,52 ....10


33,651,370.05
24,488,137.12·

4,221:;.40
p      82,361    .57
8,358,269.53

To Purchase Property, Plant and Equipment
To purchase Debt Securities of Other Entities
6,750,294.43
To Grant.-MakeLoans to Other Entities

Total Cash Outflows
6,150,294.43
Net Cash Investing  Activities
(6,750,294.43)
Cash Flows from Financing  Activites


Cash Inflows:
From Issuance of Debt Securities
From Acquisition of Loan
Total Cash Inflow
Cash Outflows:
RetirementlRedemption of Debt Securities
P~ent    of Loan Amortization
Total Cash Outflow:
Net Cash from Financing  Activities
Net Income in cash
Cash at the beginning  of the year
Cash at the End of the Period










1,607,975.10
21,408,908.68
p       23,018t883.18
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 March 31, 2012


GENERAL FUND
                                                                                                                                                           
CASH FLOWS FROM OPERATING ACTIVITIES:


       Cash Inflows:


              Collection of Business Income
1,342,653.40

              Collection of Inter-agency Receivables
5,961,780.51

              Collection of Local Taxes
1,163,298.34

              Collection of Other Income
118,485.23

              Collection of Permits and Licenses
271,648.45

              Collection of Real Property Tax
608,599.34

              Collection of Service and Income
726,989.44

              Receipt of Internal Revenue Allotment
8,697,580.00

              Receipt of Refund of Cash Advance for Travel
978.15

Total Cash Inflows:
18,891,012.86

       Cash Outflows:


              Grant of Cash Advance for Travel and Special Purpose
285,593.48

               Payment for Grant of Subsidies and Donations
7,000.00

               Payment for Other Current Assets
29,880.00

               Payment for Other Maintenance And Other Operating Expenses
1,274,162.32

               Payment for Taxes, Premiums and Other Fees
16,230.00

               Payment for Training Expenses
97,100.00

               Payment for Utility Expenses
2,384,854.08

               Payment for the Repair and Maintenance of PPE
57,653.00

               Payment of Accounts Payable for Supp. Matls & Other MODE
146,107.61

               Payment of Inter-Agency Payables
1,179,121.76

               Payment of Professional Services
800.00

               Payment of Salaries, Wages, Benefits and Other Compensation
4,817,560.50

               Payment/Reimbursement of Traveling Expenses
60,103.50

               Pmt.  For Purc. Of Supp. Matls & Other Inv. Items directly issue
346,585.38

              Remittance of Withholding Taxes to BIR 
685,472.57

              Remittance to GSIS for Mandatory and authorized deductions
1,091.152.39

              Remittance to PAGIBIG for Mandatory and authorized deduction
78,933.98

              Remittance to PHILHEALTH for authorized deductions
106,450.00

              Remittance to government agencies and private entire’s
516,201.54

              Transfer of funds for Implementation of Project (MOOE)
86,600.00

Total Cash Outflows:
13,267,562.11

          Net Cash from Operating Activities:

5,623,450.75
CASH FLOWS FROM INVESTING ACTIVITIES:



PROVINCE OF BOHOL
MUNICIPALITY OF BACLAYON
STATEMENT OF CASH FLOWS
For the period ended September 30, 2011


GENERAL FUND


CASH FLOWS FROM OPERATING ACTIVITIES

Cash Inflows
           
            Collection of Business Income                                                               3,960,851.38
            Collection of Inter-agency Receivables                                                   8,126,315.76
            Collection of Local Taxes                                                                      1,005,365.73
            Collection of Other Income                                                                    312,814.85
            Collection of Overpayment of Maintenance and Other Expenses             84,100.00
            Collection of Permits and Licenses                                                        288,820.12
            Collection of Real Property Tax                                                              920,738.42
            Collection of Service and Income                                                           1,515,876.13
            Receipt of Internal Revenue Allotment                                                    26,367,003.00
            Total Cash Inflows                                                                               42,581.885.39
           
            Cash Outflows

            Adjustment for Cancellation of Official receipt                                        0.50
            Grant of Cash Advance for Travel and Special Purpose                          520,696.51
            Payment for Communications Expenses                                                            7,976.00
            Payment for Grant of Subsidies and Donations                                      17,800.00
            Payment for Other Current Assets                                                          53,583.11
            Payment for Other Maintenance and Other Operating Expenses               2,286,244.01
            Payment for Taxes, Premiums and Other Fees                                        21,632.70
            Payment for Training Expenses                                                              111,396.15
            Payment for Utility Expenses                                                                 5,191,838.89
            Payment for the Repair and Maintenance of PPE                                    360,090.25
            Payment of Account Payable for Supp., Matls & Other MOOE                572,494.71
            Payment of Inter-agency Payables                                                         3,485,206.57
            Payment of Salaries, Wages, Benefits and Other Compensation              13,424,524.76
            Payment/Reimbursement of Traveling Expenses                                     445,912.39
            Pmt. for Purchase of Inventories, Supplies & Matls. for Stocks               430,178.00
            Pmt. for Purc. Of Supp. Matls. & Other Inv. Items Directly Issue              1,866,201.30
            Pmt. for Purchase of Agri’l, Fishery and Forestry Products                     13,800.00
            Remittance of Witholding Taxes to BIR                                                   1,296,250.22
            Remittance to GSIS for Mandatory and Authorized Deductions                2,799.736.92
            Remittance to PAG-IBIG for Mandatory and Authorized Deductions         252,389.08
            Remittance to PHILHEALTH for authorized deductions                            866,232.50
            Remittance to government agencies and private entires                           1,018,294.31
            Transfer of Funds for Implementation of Project (MOOE)                                    271,930.00
            Total Cash Outflows                                                                             35,314,388.88


Net Cash from Operating Activities                                                                                           7,267,496.51

FLOWS FROM INVESTING ACTIVITIES
            Payment for Purchase of Other Assets                                                   674,708.53
            Pmt. of Progress Billing of Contractors of Public Infra/ Reform               2,439,892.08
            Purc/Fab/Const. of PPE, Public Infra & Reforestation Project                 512,817.66
            Total Cash Outflows                                                                             3,627,418.27

Net Cash from Investing Activities                                                                                            (3,627,418.27)

TOTAL CASH PROVIDED BY OPERATING, INVESTING AND FINANCING ACTIVITIES  3,640,078.24

BALANCE, BEGINNING January 1, 2011                                                                                   20,821,455.75
BALANCE, ENDING December 31, 2010                                                                                    24,461,533.99