Republic of the Philippines
Province of Bohol
Municipality
of Baclayon
STATEMENT OF CASHFLOVYS
GENERAL FUND
For the
Year
Ended December 31,2012
|
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