by Municipality of Miagao | Jun 9, 2011 | Financial Statements
Republic of the Philippines
Province of Iloilo
MUNICIPALITY OF MIAGAO
REPORT OF SEF UTILIZATION
For the Year Ended December 31, 2010
|
Beginning Balance
|
|
443,038.41
|
|
|
Receipt from SEF
|
|
1,757,761.59
|
|
| |
Total
|
P
|
2,200,800.00
|
|
|
Less:
|
Disbursement:
|
|
|
|
| |
|
|
|
|
| |
Personal Services
|
|
|
|
| |
Salaries and Wages
|
|
557,440.00
|
|
| |
PERA
|
|
72,000.00
|
|
| |
Clothing Allowance
|
|
12,000.00
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
Maintenance and other Operating Expenses
|
|
|
|
| |
Other Maintenance and Operating Expenses
|
|
1,353,918.46
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
Capital Outlay
|
|
–
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
Sub-total
|
P
|
1,995,358.46
|
|
| |
|
|
|
|
| |
Balance
|
P
|
205,441.54
|
|
| |
|
|
|
|
Prepared by:
MARY GRACE P. CEPE
Supervising Administrative Officer
Acting Municipal Accountant
Approved by:
HON. JULIETA N. FLORES
Municipal Mayor
LCE, Chairman, LSB
by Municipality of Miagao | Jun 9, 2011 | Statement of Cash Flow
Republic of the Philippines
Province of Iloilo
MUNICIPALITY OF MIAGAO
Consolidated Statement of Cash Flow
For the Quarter Ended December 31, 2010
|
Cash Flows from Operating Activities:
|
|
|
|
|
Cash Inflows:
|
|
|
| |
|
Collection from taxpayers
|
P
|
5,844,400.35
|
| |
|
Share from Internal Revenue Collections
|
|
77,044,864.00
|
| |
|
Receipts from sale of goods or services
|
|
9,708,761.84
|
| |
|
Interest Income
|
|
154,076.50
|
| |
|
Dividend Income
|
|
0.00
|
| |
|
Other Receipts
|
|
23,167,860.74
|
| |
|
Total Cash Inflow
|
P
|
115,919,963.43
|
| |
Cash Outflows:
|
|
|
| |
|
Payments-
|
|
|
| |
|
To suppliers/creditors
|
P
|
36,465,957.63
|
| |
|
To Employees
|
|
46,100,827.92
|
| |
|
Interest Expense
|
|
323,167.29
|
| |
|
Other Expenses
|
|
19,356,620.96
|
| |
|
Total Cash Outflow
|
P
|
102,246,573.80
|
| |
Net Cash from Operating Activities
|
P
|
13,673,389.63
|
|
Cash Flows from Investing Activities:
|
|
|
| |
Cash Inflows:
|
|
|
| |
|
From Sale of Property, Plant and Equipment
|
P
|
0.00
|
| |
|
From Sale of Debt Securities of Other Entities
|
|
0.00
|
| |
|
From Collection of Principal on Loans to Other Entities
|
|
0.00
|
| |
|
Total Cash Inflow
|
P
|
0.00
|
| |
Cash Outflow:
|
|
|
| |
|
To Purchase Property,Plant & Equipment
|
P
|
4,753,103.95
|
| |
|
To Purchase Debt Securities of Other Entities
|
|
0.00
|
| |
|
To Grant/Make Loans to Other Entities
|
|
0.00
|
| |
|
Total Cash Outflow
|
P
|
4,753,103.95
|
| |
Net Cash From Investing Activities
|
P
|
(4,753,103.95)
|
|
Cash Flows from Financing Activities:
|
|
|
| |
Cash Inflows:
|
|
|
| |
|
From Issuance of Debt Securities
|
P
|
0.00
|
| |
|
From Acquisition of Loan
|
|
0.00
|
| |
|
Total Cash Inflow
|
P
|
0.00
|
| |
Cash Outflows:
|
|
|
| |
|
Retirement/Redemption of Debt Securities
|
P
|
0.00
|
| |
|
Payment of Loan Amortization
|
|
1,162,234.60
|
| |
|
Total Cash Outflow
|
P
|
0.00
|
| |
Net Cash from Financing Activities
|
P
|
1,162,234.60
|
|
Net Increase/Decrease in Cash
|
P
|
7,758,051.08
|
|
Cash at the Beginning of the Period
|
|
22,307,785.78
|
|
Cash at the End of the Period
|
P
|
30,065,836.86
|
by Municipality of Miagao | Jun 9, 2011 | Statement of Cash Flow
Republic of the Philippines
Province of Iloilo
MUNICIPALITY OF MIAGAO
Consolidated Statement of Cash Flow
For the Quarter Ended September 30, 2010
|
Cash Flows from Operating Activities:
|
|
|
|
|
Cash Inflows:
|
|
|
| |
|
Collection from taxpayers
|
P
|
4,873,094.25
|
| |
|
Share from Internal Revenue Collections
|
|
57,038,157.00
|
| |
|
Receipts from sale of goods or services
|
|
6,827,381.37
|
| |
|
Interest Income
|
|
0.00
|
| |
|
Dividend Income
|
|
0.00
|
| |
|
Other Receipts
|
|
9,642,616.84
|
| |
|
Total Cash Inflow
|
P
|
78,381,249.46
|
| |
Cash Outflows:
|
|
|
| |
|
Payments-
|
|
|
| |
|
To suppliers/creditors
|
P
|
7,639,207.67
|
| |
|
To Employees
|
|
34,061,023.65
|
| |
|
Interest Expense
|
|
170,908.20
|
| |
|
Other Expenses
|
|
23,482,666.83
|
| |
|
Total Cash Outflow
|
P
|
65,353,806.35
|
| |
Net Cash from Operating Activities
|
P
|
13,027,443.11
|
|
Cash Flows from Investing Activities:
|
|
|
| |
Cash Inflows:
|
|
|
| |
|
From Sale of Property, Plant and Equipment
|
P
|
0.00
|
| |
|
From Sale of Debt Securities of Other Entities
|
|
0.00
|
| |
|
From Collection of Principal on Loans to Other Entities
|
|
0.00
|
| |
|
Total Cash Inflow
|
P
|
0.00
|
| |
Cash Outflow:
|
|
|
| |
|
To Purchase Property,Plant & Equipment
|
P
|
3,800,044.90
|
| |
|
To Purchase Debt Securities of Other Entities
|
|
|
| |
|
To Grant/Make Loans to Other Entities
|
|
|
| |
|
Total Cash Outflow
|
P
|
3,800,044.90
|
| |
Net Cash From Investing Activities
|
P
|
3,800,044.90
|
|
Cash Flows from Financing Activities:
|
|
|
| |
Cash Inflows:
|
|
|
| |
|
From Issuance of Debt Securities
|
P
|
0.00
|
| |
|
From Acquisition of Loan
|
|
0.00
|
| |
|
Total Cash Inflow
|
P
|
0.00
|
| |
Cash Outflows:
|
|
|
| |
|
Retirement/Redemption of Debt Securities
|
P
|
0.00
|
| |
|
Payment of Loan Amortization
|
|
581,117.30
|
| |
|
Total Cash Outflow
|
P
|
581,117.30
|
| |
Net Cash from Financing Activities
|
P
|
581,117.30
|
|
Net Increase/Decrease in Cash
|
P
|
8,646,280.91
|
|
Cash at the Beginning of the Period
|
|
22,307,785.78
|
|
Cash at the End of the Period
|
P
|
30,954,066.69
|
by Municipality of Miagao | Jun 9, 2011 | Statement of Cash Flow
Statement of Cash Flow (as of June 2010)
by Municipality of Miagao | Jun 9, 2011 | Statement of Cash Flow
Statement of Cash Flow (as of March 2010)
by Municipality of Miagao | Apr 28, 2011 | Annual Budget
The CY 2011 Budget of the Municipality of Miagao
Distribution by Type of Revenue
Expenditure Program
(Distribution by Sector)
SUMMARY OF THE FY 2011 ANNUAL BUDGET
General Fund
| I. Beginning Balance |
|
|
|
|
| II. Receipts |
|
|
|
|
|
| A. |
Local (Internal) Sources |
|
|
|
|
| |
1. Tax Revenue |
|
|
|
|
|
| |
|
a. Amusement Tax |
|
|
|
40,000.00 |
| |
|
b. Business Tax |
|
|
|
2,800,000.00 |
| |
|
c. Community Tax |
|
|
|
600,000.00 |
| |
|
d. Occupation Tax |
|
|
|
5,000.00 |
| |
|
e. Real Property Tax |
|
|
|
2,000,000.00 |
| |
|
f. Tax on Delivery Vans and Trucks |
|
|
15,000.00 |
| |
|
g. Tax on Sand, Gravel and Other quarry Products |
75,000.00 |
| |
|
h. Other Local Taxes |
|
|
|
5,000.00 |
| |
|
i. Fines and Penalties-Tax Revenue |
|
400,000.00 |
| |
Total Tax Revenue |
|
|
|
5,940,000.00 |
| |
|
|
|
|
|
|
|
|
|
| |
2. Non-Tax Revenue |
|
|
|
|
| |
|
a. Regulatory Fees |
|
|
|
|
| |
|
|
1. Fees on Weights and Measures |
|
4,000.00 |
| |
|
|
2. Permit Fees |
|
|
|
1,250,000.00 |
| |
|
|
3. Registration Fees |
|
|
|
325,000.00 |
| |
|
|
4. Fines and Penalties-Permit and Licenses |
|
50,000.00 |
| |
|
b. Business and Service Income |
|
|
|
| |
|
|
1. Clearance and Certification Fees |
|
300,000.00 |
| |
|
|
2. Garbage Fees |
|
|
|
300,000.00 |
| |
|
|
3. Fines and Penalties-Services Income |
|
1,500.00 |
| |
|
|
4. Other Business Income |
|
|
400,000.00 |
| |
|
|
5. Fines and Penalties-Business Income |
|
50,000.00 |
| |
|
c. Other Income/Receipts |
|
|
|
| |
|
|
1. Interests Income |
|
|
|
100,000.00 |
| |
|
|
2. Miscellaneous Income |
|
|
1,300,000.00 |
| |
Total Non-Tax Revenue |
|
|
|
4,080,500.00 |
| |
Total Local Sources |
|
|
|
10,020,500.00 |
| |
|
|
|
|
|
|
|
|
|
| B. |
External Sources |
|
|
|
|
| |
1. Shares from National Internal Revenue Taxes (IRA) |
76,530,188.00 |
| |
Total External Sources |
|
|
|
76,530,188.00 |
| |
Total Receipts |
|
|
|
|
86,550,688.00 |
| |
Total AvailableResources for Appropriation |
86,550,688.00 |
| |
|
|
|
|
|
|
|
|
|
| III. Expenditures |
|
|
|
|
|
| |
1.0 Current Operating Expenditures |
|
|
|
| |
|
1.1 PersonalServices |
|
|
|
|
| |
|
|
Salaries and Wages-Regular Pay |
|
|
26,924,376.00 |
| |
|
|
Salaries and Wages-Casuals |
|
|
245,448.00 |
| |
|
|
Other Compensation: |
|
|
|
|
| |
|
|
|
PERA |
|
|
|
|
3,168,000.00 |
| |
|
|
|
Representation Allowance |
|
|
1,640,880.00 |
| |
|
|
|
Transportation Allowance |
|
|
1,565,280.00 |
| |
|
|
|
Clothing/Uniform Allowance |
|
|
528,000.00 |
| |
|
|
|
Subsistence, Laundry and Quarter Allowance |
295,200.00 |
| |
|
|
|
Hazard Pay |
|
|
|
546.00 |
| |
|
|
|
Hazard Pay |
|
|
|
414,134.00 |
| |
|
|
|
Overtime Pay |
|
|
|
90,000.00 |
| |
|
|
|
Cash Gift |
|
|
|
|
660,000.00
|
| |
|
|
|
Year End Bonus |
|
|
2,264,152.00 |
| |
|
|
Personnel Benefits Contributions: |
|
|
| |
|
|
|
Life Retirement Insurance Contributions |
3,260,390.00 |
| |
|
|
|
PAG-IBIG Contributions |
|
|
154,800.00 |
| |
|
|
|
PHILHEALTH Contributions |
|
310,938.00 |
| |
|
|
|
ECC Contributions |
|
|
151,900.00 |
| |
|
|
Other Personnel Benefits: |
|
|
| |
|
|
|
Terminal Leave Benefits |
|
67,803.00 |
| |
|
|
|
Loyalty Pay |
|
|
|
75,000.00 |
| |
|
|
|
Monetization |
|
|
1,082,473.00 |
| |
|
|
|
Anniversary Bonus |
|
|
396,000.00 |
| |
|
|
Total Personal Services |
|
|
43,295,320.00 |
| |
|
|
|
|
|
|
|
|
|
| |
|
1.2 Maintenance and Other Operating Expenses |
|
| |
|
|
Travelling Expenses-Local |
|
1,374,000.00 |
| |
|
|
Training Expenses |
|
|
735,000.00 |
| |
|
|
Scholarship Expenses |
|
|
60,000.00 |
| |
|
|
Office Supplies Expenses |
|
|
1,345,000.00 |
| |
|
|
Accountable Forms Expenses |
|
250,000.00 |
| |
|
|
Drugs and Medicine Expenses |
|
300,000.00 |
| |
|
|
Gasoline, Oil and Lubricants Expenses |
2,045,000.00 |
| |
|
|
Other Supplies Expense |
|
|
160,000.00 |
| |
|
|
Water Expenses |
|
|
100,000.00 |
| |
|
|
Electricity Expenses |
|
|
900,000.00 |
| |
|
|
Postage and Deliveries |
|
|
10,000.00 |
| |
|
|
Telephone Expenses-Landline |
|
50,000.00 |
| |
|
|
Telephone Expenses-Mobile |
|
18,000.00 |
| |
|
|
Internet Expenses |
|
|
94,000.00 |
| |
|
|
Membership Dues and Cont. to Orgs. |
20,000.00 |
| |
|
|
Advertising Expenses |
|
|
35,000.00 |
| |
|
|
Printing and Binding Expense |
|
180,000.00 |
| |
|
|
Subscription Expenses |
|
|
40,000.00 |
| |
|
|
Survey Expenses |
|
|
100,000.00 |
| |
|
|
Auditing Services |
|
|
25,000.00 |
| |
|
|
R/M – Office Building |
|
|
1,600,000.00 |
| |
|
|
R/M – Office Equipment |
|
|
80,000.00 |
| |
|
|
R/M – Furniture and Fixtures |
|
80,000.00 |
| |
|
|
R/M – IT Equipment and Software |
|
115,000.00 |
| |
|
|
R/M – Communication Equipment |
|
10,000.00 |
| |
|
|
R/M – Conts. And Heavy Equipment |
|
500,000.00 |
| |
|
|
R/M – Tech and Scientific Equipment |
20,000.00 |
| |
|
|
R/M – Motor Vehicles |
|
|
734,000.00 |
| |
|
|
Consultancy Services |
|
|
20,000.00 |
| |
|
|
R/M – Roads, Highways and Bridges |
|
1,200,000.00 |
| |
|
|
R/M – Plaza, Parks andMonuments |
|
120,000.00 |
| |
|
|
R/M – Other Public Structures |
|
100,000.00 |
| |
|
|
Subsidy to Other Funds |
|
|
6,172,789.00 |
| |
|
|
Confidential Expenses |
|
|
20,000.00 |
| |
|
|
Intelligence Expenses |
|
|
20,000.00 |
| |
|
|
FidelityBond Premiums |
|
|
20,000.00 |
| |
|
|
Insurance Expenses |
|
|
150,000.00 |
| |
|
|
Other Maintence and Operating Expenses |
4,350,006.00 |
| |
|
|
|
Honoraria of Nat. Govt. Personnel, DBM-LBC 75 par 5.5 |
315,000.00 |
| |
|
|
|
Anti-Illegal drugs-RA 9165 |
|
35,000.00 |
| |
|
|
Total MOOE |
|
|
|
23,502,795.00 |
| |
2.0 Property, Plant and Equipment |
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
3.0 Budgetary Requirements |
|
|
|
| |
|
20% IRA |
|
|
|
|
5,306,038.00 |
| |
|
5% Calamity Fund |
|
|
|
4,327,535.00 |
| |
|
Aid to Barangays |
|
|
|
119,000.00 |
| |
|
Total Budgetary Requirements |
|
|
9,752,573.00 |
| |
|
Total Expenditures |
|
|
|
86,550,688.00 |
| |
|
Ending Balance |
|
|
|
0 |
