| TABLE
I |
| |
|
SMALL
|
AVERAGE
|
MEDIUM
|
BIG
|
LARGE
|
V-LARGE
|
OVER-ALL
|
| PROFITABILITY |
|
Net
Income / Operating Revenues
|
%
|
4
|
13
|
9
|
15
|
10
|
23
|
11
|
|
Interest
Expense / Operating Revenues
|
%
|
15
|
11
|
17
|
7
|
14
|
8
|
13
|
|
Internal
Cash Ratio
|
%
|
27
|
34
|
37
|
31
|
35
|
40
|
33
|
|
Debt
Service Ratio
|
%
|
133
|
438
|
348
|
841
|
404
|
840
|
462
|
|
Debt Service
|
P
|
1,571,248
|
2,596,129
|
7,687,991
|
7,681,842
|
29,322,451
|
48,364,037
|
10,007,573
|
|
Net
Income / Net UPIS
|
%
|
4
|
14
|
11
|
11
|
9
|
21
|
10
|
|
Return
on Fixed Assets
|
%
|
2
|
10
|
4
|
11
|
6
|
16
|
7
|
|
Net Income / Month
|
P
|
7,478
|
260,049
|
185,941
|
966,512
|
1,302,091
|
9,281,062
|
871,097
|
|
COST
CONTROL
|
|
Operating
Ratio
|
%
|
69
|
68
|
78
|
77
|
77
|
78
|
75
|
|
Operating
Expense / Month
|
P
|
353,059
|
674,747
|
2,042,244
|
4,694,026
|
12,303,357
|
45,169,636
|
5,209,137
|
|
Operating
Expense / Conn / Month
|
P
|
223
|
273
|
324
|
356
|
396
|
443
|
319
|
|
Operating
Expense / M3 Billed
|
P
|
15
|
15
|
17
|
16
|
18
|
15
|
16
|
|
Admin.
& Gen. Exp / Conn / Month
|
P
|
121
|
116
|
141
|
110
|
131
|
145
|
126
|
|
Admin.
& Gen. Exp / Operating Exp
|
%
|
49
|
61
|
43
|
34
|
34
|
42
|
43
|
|
Maintenance
Exp / Operating Expense
|
%
|
9
|
16
|
12
|
10
|
9
|
16
|
11
|
|
Other
Operations & Maintenance Exp
|
P
|
1,985,157
|
3,498,519
|
8,634,877
|
18,561,738
|
55,778,347
|
59,639,668
|
16,341,793
|
|
MARKETING
EFFORT
|
|
Ave.
Active Service Connection
|
No.
|
1,452
|
3,136
|
6,800
|
12,733
|
30,381
|
81,115
|
12,580
|
|
Operating
Rev / Month
|
P
|
486,889
|
1,467,230
|
2,543,752
|
6,212,032
|
15,724,824
|
55,896,108
|
6,678,645
|
|
Operating
Rev / Conn / Month
|
P
|
296
|
434
|
404
|
469
|
510
|
560
|
419
|
|
Operating
Rev / M3 Billed
|
P
|
20
|
25
|
21
|
22
|
24
|
19
|
21
|
|
M3
Billed / Conn / Month
|
M3
|
14
|
17
|
20
|
22
|
22
|
29
|
20
|
|
M3
Billed / Month
|
M3
|
23,770
|
52,033
|
135,894
|
289,284
|
717,715
|
2,345,508
|
301,740
|
|
Monthly
Billing per Connection
|
P
|
284
|
424
|
390
|
453
|
495
|
584
|
406
|
|
Peso
Billing per cu. M. Billed
|
P
|
19
|
25
|
20
|
21
|
23
|
27
|
21
|
|
COLLECTION
EFFORT
|
|
Average
Collection Period
|
Days
|
55
|
36
|
33
|
34
|
50
|
47
|
40
|
|
On
time Payment
|
%
|
55
|
60
|
65
|
62
|
66
|
60
|
62
|
|
Collection
Efficiency
|
%
|
81
|
93
|
93
|
94
|
93
|
92
|
91
|
|
Collection
Ratio
|
%
|
77
|
91
|
88
|
99
|
87
|
87
|
89
|
|
Peso
Collection - Current Year's Sales
|
P
|
5,083,969
|
16,348,597
|
27,944,424
|
67,501,611
|
171,122,122
|
508,222,324
|
68,120,988
|
|
Peso
Collection - Previous Year's Sales
|
P
|
251,122
|
568,312
|
1,292,108
|
2,870,070
|
5,381,520
|
21,803,619
|
2,741,971
|
|
FINANCIAL
POSITION
|
|
Total
Debt / Total Assets
|
%
|
61
|
68
|
53
|
35
|
56
|
36
|
51
|
|
Loans
Payable / Fixed Assets
|
%
|
73
|
80
|
94
|
35
|
54
|
38
|
67
|
|
Total
Debt / (Total Debts + Total Equity)
|
%
|
62
|
71
|
53
|
35
|
57
|
40
|
52
|
|
Current
Ratio
|
%
|
554
|
516
|
750
|
388
|
432
|
415
|
552
|
|
Net
Income / Total Assets
|
%
|
1.48
|
7
|
4
|
7
|
5
|
9
|
5
|
|
Long
Term Debt / Total Equity
|
%
|
338
|
86
|
64
|
63
|
186
|
75
|
134
|
|
PRODUCTION
EFFICIENCY
|
|
Metered
Service Connection
|
No.
|
1,452
|
3,135
|
6,796
|
12,714
|
31,198
|
98,274
|
13,428
|
|
Non-Revenue
Water
|
%
|
19
|
24
|
24
|
26
|
31
|
34
|
25
|
|
Production
Capacity Utilized
|
%
|
54
|
73
|
77
|
67
|
68
|
93
|
69
|
|
Pumping
Exp / M3 Produced
|
P
|
2
|
2.25
|
2.37
|
3
|
3.29
|
1.68
|
2.45
|
|
Treatment
Exp / M3 Produced
|
P
|
0.23
|
0.16
|
0.35
|
0.30
|
0.21
|
0.17
|
0.27
|
|
Fuel
Purchased for Pumping / M3 Produced
|
P
|
2
|
2.36
|
2.40
|
2.65
|
2.81
|
2.15
|
2.32
|
|
Total
Prodn Exp / M3 Produced
|
P
|
2
|
3.07
|
2.58
|
4.13
|
3.58
|
2.78
|
3.01
|
|
Total
Prod'n Exp / Conn / Month
|
P
|
42
|
72
|
64
|
123
|
115
|
115
|
82
|
|
Total
Prodn Exp / Operating Expense
|
%
|
16
|
23
|
21
|
33
|
29
|
33
|
24
|
|
M3
Produced
|
M3
|
399,361
|
864,065
|
2,221,138
|
|