ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
BATAC WATER DISTRICT
2
Cash Flow Statement
3
For the period ended November 30, 2022
4
5
6
CURRENTYEAR-TO-UPDATEDYEAR-TO-
7
MONTHDATEDATE
8
Cash flow from operating activities
9
Cash inflows:
10
Collection of Water Bills & Franchise Tax
 0.00
11
Collection of Other Receivables
 0.00
12
Collection of Receivables from Joint Ventures
 324,900.10 324,900.10 324,900.10
13
Collection of Receivables from Officers and Employees
 3,489.52 3,489.52 3,489.52
14
Collection of Other Revenues
 0.00
15
Collection of JV Share
 316,666.67 3,482,335.04 3,482,335.04 3,165,668.37
16
Collection of JV Share (Loan amortization)
 92,959.00 1,298,008.20 1,298,008.20 1,205,049.20
17
Refund of Advances
 17,143.49 95,957.43 95,957.43 78,813.94
18
Refund of Petty Cash
 0.00
19
Collection of Advance Billings (Offset)
 0.00
20
Reactivation of Dormant Accounts
 200.00 200.00 200.00
21
Collection of cost of materials due to PrimeWater
 0.00
22
Miscellaneous Income
 10,000.00 10,000.00 10,000.00
23
Collection from PYA including A/R from disallowances
 0.00
24
Total Cash inflows
 430,258.68 5,214,890.29 5,214,890.29 4,784,631.61
25
Cash outflows:
26
Payment of Salaries
 58,531.97 617,453.01 617,453.01 558,921.04
27
Payment of Power Purchased for Pumping
 0.00
28
Payment of Employees Benefits
 192,304.23 1,098,429.32 1,098,429.32 906,125.09
29
Payment of 5 commercial check booklets
 0.00
30
Payment of Collection Fee (PrimeWater)
 579.32 579.32 579.32
31
Payment of Materials
 0.00
32
Other Disbursements
 209,397.65 1,882,095.92 1,882,095.92 1,672,698.27
33
Total Cash Outflows
 460,233.85 3,598,557.57 3,598,557.57 3,138,323.72
34
Cash from/(used in) operating activities
(29,975.17) 1,616,332.72 1,616,332.72 1,646,307.89
35
36
Cash flow from investing activities
37
Cash inflows:
38
Interest earned of bank deposits
 134.67 134.67 134.67
39
Cash outflows:
40
Payment of UPIS & Other non-current assets
 59,990.00 59,990.00 59,990.00
41
42
Total Cash Outflows
 0.00 59,990.00 59,990.00
43
Cash from/(used in) investing activities
 0.00 (59,855.33)(59,855.33)
44
45
Cash flow from financing activities
46
Cash inflows:
47
48
Cash outflows:
49
Payment Of Loan Amortization
 92,959.00 1,345,210.83 1,345,210.83 1,252,251.83
50
Cash from/(used in) financing activities
(92,959.00)(1,345,210.83)(1,252,251.83)
51
Increase/(decrease) in cash and cash equivalents
(122,934.17) 211,266.56 334,200.73
52
Cash and cash equivalents at beginning of period
 1,448,734.09 1,114,533.36 1,114,533.36
53
Cash and cash equivalents at end of period
 1,325,799.92 1,325,799.92 1,448,734.09
54
55
56
A/CACCOUNTED AS FOLLOWS :
57
10101010Cash - Collecting Officer
58
10101020Petty Cash 5,000.00
59
10102020
Cash In Bank - Local Currency, Current Account (LBP)
 876,649.71
60
10102030
Cash In Bank - Local Currency, Savings Account (Customer's Deposit)
 187,421.52
61
10102040
Cash In Bank - Local Currency, Savings Account (JSA - LWUA/BWD)
 256,728.69
62
TOTAL CASH BALANCE, END 1,325,799.92
63
 (0.00)
64
65
PREPARED BY :
NOTED BY :
66
67
68
MAIZEL MAIA V. CASTROMARIA DOHNA D. SAGUN
69
Sr. Accounting Processor AGeneral Manager D
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100