 Tagkawayan Water District
|
|||||||||||||
|
Tagkawayan, Quezon |
|||||||||||||
|
PROJECTED CASH FLOW |
|||||||||||||
|
CY 2016 |
|||||||||||||
|
PARTICULARS |
AMOUNT |
||||||||||||
|
CASH RECEIPTS: |
|||||||||||||
|
Operating Revenues: |
|||||||||||||
|
Collection on Water Sales - CY |
Pp |
12,969,968.00 |
|||||||||||
|
Collection on Water Sales - Arrears CY |
5,558,558.00 |
||||||||||||
|
Collection on Water Sales - Arrears PY |
555,856.00 |
||||||||||||
|
Collection on Penalty Charges |
500,270.00 |
||||||||||||
|
Total Collections on Operating Revenues |
19,584,652.00 |
||||||||||||
|
Add: |
Collection on Miscellaneous Service Revenues |
598,000.00 |
|||||||||||
|
Collection on Miscellaneous Non-Operating Revenues |
90,000.00 |
||||||||||||
|
Interest Revenues |
15,000.00 |
||||||||||||
|
Others-Loans (Salintubig/Financial Assistance from LWUA) |
9,880,000.00 |
||||||||||||
|
TOTAL CASH RECEIPTS |
30,167,652.00 |
|
|||||||||||
|
DISBURSEMENTS: |
|||||||||||||
|
Payroll |
4,908,750.00 |
||||||||||||
|
Power Cost |
3,240,000.00 |
||||||||||||
|
Chemicals |
480,000.00 |
||||||||||||
|
Other Operating & Maintenance Expenses |
5,052,308.00 |
||||||||||||
|
Total Operating & Maintenance Expenses |
13,681,058.00 |
||||||||||||
|
Debt Service - LWUA |
1,924,000.00 |
||||||||||||
|
Other Creditors |
1,800,000.00 |
||||||||||||
|
Taxes Payable |
685,000.00 |
||||||||||||
|
Total |
18,090,058.00 |
||||||||||||
|
Add: |
CAPEX |
5,580,000.00 |
|||||||||||
|
Reserves (3%) |
587,539.56 |
||||||||||||
|
TOTAL DISBURSEMENTS |
24,257,597.56 |
||||||||||||
|
NET RECEIPTS (DISBURSEMENTS) |
5,910,054.44 |
||||||||||||
|
Add: |
CASH BALANCE, BEG. |
2,623,158.61 |
|||||||||||
|
CASH BALANCE, END |
8,533,213.05 |
||||||||||||
|
Prepared By: |
Checked & Verified by: |
Approved By: |
|||||||||||
|
YOLANDA C. DAGOS |
CIRILO T. FRONDOSO |
JOSEPH A. PUA |
|||||||||||
|
Division Manager C, Admin. & Fin. |
General Manager |
Chairman of the Board |
|||||||||||