| A | B | C | D | E | F | G | H | I | J | K | L | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Republic of the Philippines | |||||||||||||||||
2 | SAN NICOLAS (I.N.) WATER DISTRICT | |||||||||||||||||
3 | ||||||||||||||||||
4 | Statement of Cash Flows | |||||||||||||||||
5 | as of SEPTEMBER 30, 2021 | |||||||||||||||||
6 | ||||||||||||||||||
7 | Current Month | Year to Date | ||||||||||||||||
8 | Cash Flows from Operating Activities | |||||||||||||||||
9 | Cash Inflows: | |||||||||||||||||
10 | Collection of Water Bills | P | 2,587,341.37 | P | 24,724,392.63 | |||||||||||||
11 | Collection of Miscellaneous Service Revenue | 21,100.00 | 420,600.00 | |||||||||||||||
12 | Collection of Customers Deposits | 7,765.00 | 152,810.60 | |||||||||||||||
13 | Collection of W.D.C.F. | 972.00 | 17,880.00 | |||||||||||||||
14 | Collection of Penalty Charge | 11,235.41 | 235,584.85 | |||||||||||||||
15 | Collection of Non-Operating Other Income | 25,168.00 | 507,753.75 | |||||||||||||||
16 | Collection of Payment of Materials | 120,861.00 | 2,368,294.25 | |||||||||||||||
19 | Collection of Petty Cash Refund | - | ||||||||||||||||
21 | Refund of Cash Advances | - | 509.75 | |||||||||||||||
23 | Collection of Bank Interest | 1,625.06 | 4,364.45 | |||||||||||||||
24 | Returned VAT inclusion of expense | - | 1,143.48 | |||||||||||||||
25 | Collection of Payment of Telephone bill | - | 825.31 | |||||||||||||||
27 | Collection of Other Income | - | 33,617.06 | |||||||||||||||
28 | Collection of Other Water Revenues | 2,788.39 | 18,595.61 | |||||||||||||||
29 | Refund of Travel and Per Diems | - | 1,440.00 | |||||||||||||||
30 | Prior Year Adjustment | 16,292.94 | 16,292.94 | |||||||||||||||
31 | Receipt of Performance/Bidders/Bid Documents | - | 5,000.00 | |||||||||||||||
32 | Total Cash Inflows | P | 2,795,149.17 | P | 28,509,104.68 | |||||||||||||
36 | ||||||||||||||||||
37 | Cash Outflows: | |||||||||||||||||
38 | Payment of Operating Expenses: | |||||||||||||||||
39 | Payroll | P | 436,947.81 | 3,436,749.98 | ||||||||||||||
40 | Fuel/Power for Pumping | 658,182.30 | 5,308,244.25 | |||||||||||||||
42 | Other Operation and Maintenance Expenses | 387,886.31 | 5,412,675.66 | |||||||||||||||
44 | Purchase of office supplies | 2,500.00 | 297,647.73 | |||||||||||||||
45 | Payment of Accountable Forms | 175,089.28 | 559,629.28 | |||||||||||||||
47 | Remittance of GSIS/PAG-IBIG/Withholding Taxes | |||||||||||||||||
48 | Remittance of GSIS | 122,749.86 | 1,050,789.25 | |||||||||||||||
49 | Remittance of Optional Life Insurance | 719.12 | 6,472.08 | |||||||||||||||
50 | Remittance of Conso Loan | 35,857.21 | 343,390.86 | |||||||||||||||
51 | Remittance of Policy Loan | 1,000.00 | 8,000.00 | |||||||||||||||
52 | Remittance of OLI Loan | 1,000.00 | 8,000.00 | |||||||||||||||
53 | Remittance of Emergency Loan | 17,017.81 | 136,007.54 | |||||||||||||||
54 | Remittance of Pag-ibig | 22,866.64 | 195,658.60 | |||||||||||||||
55 | Remittance of MPL | 4,999.75 | 81,302.48 | |||||||||||||||
56 | Remittance of Calamity Loan | 2,338.38 | 21,477.42 | |||||||||||||||
57 | Remittance of Philhealth | 15,055.41 | 131,415.30 | |||||||||||||||
58 | Remittance of Witholding Taxes | 28,809.18 | 261,489.89 | |||||||||||||||
59 | Remittance of VAT | 66,741.52 | 310,574.91 | |||||||||||||||
60 | Remittance of CIT | 15,250.85 | 83,059.37 | |||||||||||||||
61 | Cash Advances to Officers and Employees | - | 75,675.00 | |||||||||||||||
62 | Other Maintenance and Operating Expense | 57,715.57 | 317,987.50 | |||||||||||||||
64 | Total Cash Outflows | P | 2,052,727.00 | P | 18,046,247.10 | |||||||||||||
65 | Total Cash Provided (used) by Operating Activities | P | 742,422.17 | P | 10,462,857.58 | |||||||||||||
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 | P | - | ||||||||||||||
81 | Office Equipment | - | ||||||||||||||||
82 | Materials and Supply Inventory | P | - | P | 3,041,860.00 | |||||||||||||
83 | Transportation Equipment | - | - | |||||||||||||||
84 | Water Treatment Equipment | - | 168,464.28 | |||||||||||||||
85 | Other Property, Plant and Equipment | 211,526.79 | 391,348.22 | |||||||||||||||
86 | Transmission & Distribution Lines | 681,371.78 | 1,748,441.86 | |||||||||||||||
87 | Pumping Equipment | 131,553.57 | 131,553.57 | |||||||||||||||
89 | Total Cash Outflows | 1,024,452.14 | 5,481,667.93 | |||||||||||||||
90 | Cash Provided by Operating & Investing Activities | P | 1,024,452.14 | P | 4,981,189.65 | |||||||||||||
91 | ||||||||||||||||||
92 | Cash Flows from Financing Activities: | |||||||||||||||||
93 | Cash Inflows: | - | - | |||||||||||||||
95 | Cash Outflows: | |||||||||||||||||
97 | Payments of Principal Repayment/Amortization | P | - | P | 104,247.00 | |||||||||||||
98 | Total Cash Provided (used) by Financing Activities | - | 104,247.00 | |||||||||||||||
99 | Cash Provided by Operating, Investing and Financing Activities | (282,029.97) | 4,876,942.65 | |||||||||||||||
100 | Add: Cash and Cash Equivalents - August 31, 2021 | P | 15,976,987.06 | P | 10,818,014.44 | |||||||||||||
101 | Cash and Cash Equivalents, September 30, 2021 | P | 15,694,957.09 | P | 15,694,957.09 | |||||||||||||
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 | ||||||||||||||||||