CF2015_4.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
FDP From 9 - Statement of Cash Flow
2
(COA Form )
3
STATEMENT OF CASH FLOW
4
Province of Quezon, Municipality of Candelaria
5
6
As of
7
Dec. 31, 2015
Oct. 1- Dec. 31
Sept. 30, 2015
July 1 - Sept. 30
June 30, 2015
April 1- June 30, 2015
March 31, 2015
8
Cash Flows from Operating Activities:
9
Cash Inflows:
10
Collection from taxpayers
58,322,807.38 9,326,751.10 48,996,056.28 9,450,374.71 39,545,681.57 9,995,058.70 29,550,622.87
11
Share from IRA Collections
169,053,326.00 47,898,443.80 121,154,882.20 36,628,220.20 84,526,662.00 42,263,331.00 42,263,331.00
12
Interest Income
123,401.78 48,412.03 74,989.75 40,678.95 34,310.80 - 34,310.80
13
Other Receipts
271,666.36 2,906.00 268,760.36 254,757.09 14,003.27 2,659.27 11,344.00
14
Loan Proceeds
15
Total Cash Inflows
227,771,201.52 57,276,512.93 170,494,688.59 46,374,030.95 124,120,657.64 52,261,048.97 71,859,608.67
16
Cash Outflows:
17
Payments
18
To Suppliers/Creditors
57,250,570.10 4,612,237.91 52,638,332.19 17,841,863.41 34,796,468.78 14,914,808.94 19,881,659.84
19
To Employees
79,048,407.96 25,762,928.86 53,285,479.10 19,911,435.28 33,374,043.82 17,768,020.58 15,606,023.24
20
Interest Expense
579,753.90 131,995.67 447,758.23 148,995.94 298,762.29 147,538.36 151,223.93
21
Total Cash Outflows
136,878,731.96 30,507,162.44 106,371,569.52 37,902,294.63 68,469,274.89 32,830,367.88 35,638,907.01
22
Net Cash From Operating Activities
90,892,469.56 26,769,350.49 64,123,119.07 8,471,736.32 55,651,382.75 19,430,681.09 36,220,701.66
23
24
Cash Flows from Investing Activities:
25
Cash Inflows:
26
Total Cash Inflows
27
Cash Outflows:
28
To Purchase P/P/E & Public Infra
57,991,902.72 26,672,101.03 31,319,801.69 14,231,362.30 17,088,439.39 16,758,244.39 330,195.00
29
Total Cash Outflows
57,991,902.72 26,672,101.03 31,319,801.69 14,231,362.30 17,088,439.39 16,758,244.39 330,195.00
30
Net Cash From Investing Activities
(57,991,902.72) (26,672,101.03) (31,319,801.69) (14,231,362.30) (17,088,439.39) (16,758,244.39) (330,195.00)
31
32
Cash Flows from Financing Activities:
33
Cash Inflows:
34
Subsidy from Other LGUs
35
Subsidy from Other Funds
36
Total Cash Inflows
37
Cash Outflows:
38
Subsidy & Donations
18,415,581.56 802,310.86 17,613,270.70 13,901,876.70 3,711,394.00 3,117,653.00 593,741.00
39
Payment of Loan Amortization
2,236,369.64 559,092.41 1,677,277.23 559,092.41 1,118,184.82 559,092.41 559,092.41
40
Total Cash Outflows
20,651,951.20 1,361,403.27 19,290,547.93 14,460,969.11 4,829,578.82 3,676,745.41 1,152,833.41
41
Net Cash From Financing Activities
(20,651,951.20) (1,361,403.27) (19,290,547.93) (14,460,969.11) (4,829,578.82) (3,676,745.41)- 1,152,833.41
42
43
Net Increase in Cash
12,248,615.64 (1,264,153.81) 13,512,769.45 (20,220,595.09) 33,733,364.54 (1,004,308.71) 34,737,673.25
44
Cash at Beginning of the Period
57,645,834.83 57,645,834.83 - 57,645,834.83 - 57,645,834.83
45
Cash at the End of the Period
69,894,450.47 (1,264,153.81) 71,158,604.28 (20,220,595.09) 91,379,199.37 (1,004,308.71) 92,383,508.08
46
47
48
I hereby certify that I have reviewed the contents and hereby attest to the veracity and
49
correctness of the data or information contained in this document.
50
51
52
BENILDA R. DE GUIA, CPA
53
Municipal Accountant
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
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
Loading...
 
 
 
4th
 
 
Main menu