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