ABCDEFGHIJKLVWXYZ
1
Republic of the Philippines
2
SAN NICOLAS (I.N.) WATER DISTRICT
3
4
Statement of Cash Flows
5
as of OCTOBER 31, 2021
6
7
 Current Month Year to Date
8
Cash Flows from Operating Activities
9
Cash Inflows:
10
Collection of Water Bills
P 2,756,529.44 P 27,480,922.07
11
Collection of Miscellaneous Service Revenue
 21,800.00 442,400.00
12
Collection of Customers Deposits
 6,723.00 159,533.60
13
Collection of W.D.C.F.
 756.00 18,636.00
14
Collection of Penalty Charge
 49,385.71 284,970.56
15
Collection of Non-Operating Other Income
 23,526.50 531,280.25
16
Collection of Payment of Materials
 119,115.50 2,487,409.75
19
Collection of Petty Cash Refund
 -
21
Refund of Cash Advances
 - 509.75
23
Collection of Bank Interest
 2,161.96 6,526.41
24
Returned VAT inclusion of expense
 - 1,143.48
25
Collection of Payment of Telephone bill
 - 825.31
27
Collection of Other Income
 600.00 34,217.06
28
Collection of Other Water Revenues
 - 18,595.61
29
Refund of Travel and Per Diems
 - 1,440.00
30
Prior Year Adjustment
 30,237.95 46,530.89
31
Receipt of Performance/Bidders/Bid Documents
 10,000.00 15,000.00
32
Total Cash Inflows
P 3,020,836.06 P 31,529,940.74
36
37
Cash Outflows:
38
Payment of Operating Expenses:
39
PayrollP 407,788.44 3,844,538.42
40
Fuel/Power for Pumping
 759,456.17 6,067,700.42
42
Other Operation and Maintenance Expenses
 1,058,198.17 6,470,873.83
44
Purchase of office supplies
 - 297,647.73
45
Payment of Accountable Forms
 - 559,629.28
47
Remittance of GSIS/PAG-IBIG/Withholding Taxes
48
Remittance of GSIS
 123,878.78 1,174,668.03
49
Remittance of Optional Life Insurance
 719.12 7,191.20
50
Remittance of Conso Loan
 35,857.21 379,248.07
51
Remittance of Policy Loan
 1,000.00 9,000.00
52
Remittance of OLI Loan
 1,000.00 9,000.00
53
Remittance of Emergency Loan
 17,017.81 153,025.35
54
Remittance of Pag-ibig
 23,690.00 219,348.60
55
Remittance of MPL
 4,999.75 86,302.23
56
Remittance of Calamity Loan
 2,338.38 23,815.80
57
Remittance of Philhealth
 15,364.17 146,779.47
58
Remittance of Witholding Taxes
 31,184.68 292,674.57
59
Remittance of VAT
 65,041.26 375,616.17
60
Remittance of CIT
 14,635.41 97,694.78
61
Cash Advances to Officers and Employees
 - 75,675.00
62
Other Maintenance and Operating Expense
 13,983.00 331,970.50
64
Total Cash Outflows
P 2,576,152.35 P 20,622,399.45
65
Total Cash Provided (used) by Operating Activities
P 444,683.71 P 10,907,541.29
66
67
Cash Flows from Investing Activities:
68
Cash Inflows:
 - -
74
Total Cash Inflows
 - -
75
Cash Outflows:
76
Investments in Securities
77
Purchase/ Construction of:
80
Construction in Progress - Water Supply Improvement System
P 4,148,345.84 P 4,148,345.84
81
Office Equipment
 114,214.77 114,214.77
82
Materials and Supply Inventory
P 132,121.43 P 3,173,981.43
83
Transportation Equipment
 144,000.00 144,000.00
84
Water Treatment Equipment
 - 168,464.28
85
Other Property, Plant and Equipment
 - 391,348.22
86
Transmission & Distribution Lines
 - 1,748,441.86
87
Pumping Equipment
 - 131,553.57
89
Total Cash Outflows
 4,538,682.04 10,020,349.97
90
Cash Provided by Operating & Investing Activities
P 4,538,682.04 P 887,191.32
91
92
Cash Flows from Financing Activities:
93
Cash Inflows:
 - -
95
Cash Outflows:
97
Payments of Principal Repayment/Amortization
P 34,749.00 P 138,996.00
98
Total Cash Provided (used) by Financing Activities
 34,749.00 138,996.00
99
Cash Provided by Operating, Investing and Financing Activities
 (4,128,747.33) 748,195.32
100
Add: Cash and Cash Equivalents - September 30, 2021
P 15,694,957.09 P 10,818,014.44
101
Cash and Cash Equivalents, October 31, 2021
P 11,566,209.76 P 11,566,209.76
102
103
Prepared by:
Noted by:
104
106
THELMA A. BASILIO
MARLINE B. BONILLA
107
SAP - B
General Manager
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123