|
| |
|
SMALL
|
AVERAGE
|
MEDIUM
|
BIG
|
LARGE
|
V-LARGE
|
OVER-ALL
|
| PROFITABILITY |
| Net
Income/Operating Revenues |
%
|
7
|
11
|
10
|
12
|
9
|
23
|
10
|
| Interest
Expense/Operating Revenues |
%
|
14
|
12
|
14
|
8
|
11
|
11
|
12
|
| Internal
Cash Ratio |
%
|
44
|
32
|
34
|
33
|
31
|
41
|
36
|
| Debt
Service Ratio |
%
|
461
|
308
|
351
|
580
|
489
|
388
|
440
|
| Debt
Service |
P
|
1,113,978
|
2,027,388
|
4,466,367
|
5,217,090
|
17,243,130
|
55,761,199
|
6,884,998
|
| Net
Income/Net UPIS |
%
|
4
|
11
|
10
|
10
|
9
|
20
|
9
|
| Return
on Fixed Assets |
%
|
3
|
9
|
8
|
8
|
7
|
14
|
7
|
| Net
Income/Month |
P
|
18,834
|
138,253
|
194,863
|
520,847
|
944,919
|
5,441,201
|
519,955
|
| COST
CONTROL |
| Operating
Ratio |
%
|
77
|
81
|
76
|
81
|
76
|
75
|
78
|
| Operating
Expense/Month |
P
|
358,929
|
972,018
|
1,804,082
|
4,219,539
|
7,931,665
|
25,252,604
|
3,450,766
|
| Operating
Expense/Conn/Month |
P
|
255
|
308
|
291
|
343
|
335
|
408
|
304
|
| Operating
Expense/M3 Billed |
P
|
16
|
17
|
15
|
16
|
15
|
14
|
16
|
| Admin
& General Exp./Conn/Month |
P
|
147
|
150
|
113
|
118
|
118
|
168
|
131
|
| Admin
& General Exp./Operating Expense |
%
|
61
|
52
|
41
|
35
|
33
|
41
|
46
|
| Maintenance
Expense/Operating Expense |
%
|
14
|
15
|
10
|
10
|
12
|
19
|
13
|
| Other
Operations and Maintenance Expense |
P
|
1,731,450
|
3,997,619
|
8,023,762
|
17,928,228
|
46,675,561
|
124,577,696
|
16,719,925
|
| MARKETING
EFFORT |
| Average
Active Service Conn |
No.
|
1,432
|
3,140
|
6,198
|
12,244
|
27,346
|
64,895
|
10,378
|
| Operating
Rev./Month |
P
|
444,190
|
1,202,757
|
2,340,791
|
5,250,025
|
11,032,490
|
32,767,257
|
4,478,806
|
| Operating
Rev./Conn/Month |
P
|
313
|
379
|
385
|
426
|
457
|
562
|
388
|
| Operating
Rev./M3 Billed |
P
|
19
|
22
|
20
|
19
|
21
|
20
|
20
|
| M3
Billed/Conn/Month |
M3
|
16
|
18
|
20
|
21
|
23
|
29
|
20
|
| M3
Billed/Month |
M3
|
25,631
|
56,119
|
127,643
|
251,822
|
646,401
|
1,853,145
|
242,822
|
| Monthly
Billing per Connection |
P
|
292
|
372
|
376
|
412
|
444
|
532
|
373
|
| Monthly
Billing per cu.m. billed |
P
|
18
|
21
|
19
|
28
|
20
|
19
|
21
|
| COLLECTION
EFFORT |
| Average
Collection Period |
Days
|
56
|
42
|
44
|
31
|
38
|
69
|
45
|
| On-Time
Payment |
%
|
61
|
64
|
64
|
64
|
64
|
68
|
63
|
| Collection
Efficiency |
%
|
87
|
94
|
94
|
94
|
94
|
95
|
92
|
| Collection
Ratio |
%
|
82
|
91
|
90
|
92
|
90
|
88
|
88
|
| Peso
Collection - Current Year's Sales |
P
|
4,672,091
|
13,343,980
|
25,294,727
|
57,633,103
|
137,959,729
|
629,652,887
|
63,088,751
|
| Peso
Collection - Previous Year's Sales |
P
|
240,196
|
482,162
|
1,172,487
|
2,969,816
|
4,722,676
|
27,707,973
|
2,765,423
|
| FINANCIAL
POSITION |
| Total
Debt/Total Assets |
%
|
69
|
56
|
53
|
41
|
51
|
49
|
55
|
| Loans
Payable/Fixed Assets |
%
|
75
|
64
|
60
|
39
|
49
|
93
|
61
|
| Total
Debt (Total Debt + Total Equity) |
%
|
70
|
56
|
54
|
41
|
51
|
49
|
55
|
| Current
Ratio |
%
|
771
|
471
|
508
|
413
|
479
|
319
|
545
|
| Net
Income/Total Assets |
%
|
2
|
6
|
5
|
6
|
6
|
8
|
5
|
| Long
Term Debt/Total Equity |
%
|
(69)
|
74
|
37
|
76
|
217
|
155
|
42
|
| PRODUCTION
EFFICIENCY |
| Metered
Service Connection |
No.
|
1,432
|
3,140
|
6,208
|
12,244
|
27,346
|
64,728
|
10,373
|
| Non-Revenue
Water |
%
|
20
|
26
|
25
|
25
|
29
|
34
|
25
|
| Production
Capacity Utilized |
%
|
52
|
80
|
67
|
91
|
74
|
87
|
71
|
| Pumping
Exp/M3
Produced |
P
|
1.76
|
2.35
|
2.65
|
3.06
|
3.42
|
1.92
|
2.49
|
| Treatment
Exp/M3
Produced |
P
|
0.41
|
0.19
|
0.24
|
0.65
|
0.23
|
0.30
|
0.37
|
| Fuel
Purchased for Pumping/M3
Produced |
P
|
1.53
|
2.32
|
3.08
|
2.37
|
2.14
|
2.25
|
2.28
|
| Total
Production Exp/M3
Produced |
P
|
2.04
|
2.63
|
3.17
|
4.32
|
3.95
|
2.53
|
3.08
|
| Total
Production Exp/Conn/Month |
P
|
44
|
65
|
69
|
113
|
117
|
100
|
77
|
| Total
Production Exp/Operating Expense |
%
|
15
|
20
|
24
|
30
|
48
|
27
|
24
|
| M3
Produced |
M3
|
384,499
|
940,322
|
1,977,531
|
4,077,517
|
11,477,108
|
32,936,400
|
4,130,143
|
| PERSONNEL
MANAGEMENT |
| Average
No. of Employees |
No.
|
9
|
18
|
34
|
67
|
128
|
361
|
56
|
| Active
Service Conn/Employee |
No.
|
150
|
170
|
184
|
198
|
225
|
180
|
179
|
| Average
Payroll/Employee/Month |
P
|
12,033
|
12,642
|
12,184
|
15,233
|
18,655
|
17,547
|
13,682
|
| Average
Payroll/Operating Expense |
%
|
33
|
27
|
26
|
25
|
30
|
25
|
28
|
| |
|
|
|
|
|
|
|
|
| | |