PDAM Subang - Pamanukan WTP Pre FS

Page 1

PDAM KABUPATEN SUBANG PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

PDAM Tirta Rangga

Fees

Service Equity Shareholders

Legal

Tax Advisor

Pamanukan Project Company

International & Local Banks

Insurance Companies

Engineer

Construction Contractor

NOVEMBER 2006 This publication was produced by Development Alternatives, Inc. for the United States Agency for International Development under Contract No. 497-M-00-05-00005-00


Ilustration credit: ESP Jakarta Structure of a Typical Build- Operate-Transfer (BOT) Project.


PDAM KABUPATEN SUBANG PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

Title:

Program, activity, or project number: Strategic objective number: Sponsoring USAID office and contract number:

PDAM Kabupaten Subang Pamanukan Water Treatment Plant Pre Feasibility Study Environmental Services Program, DAI Project Number: 5300201. SO No. 2, Higher Quality Basic Human Services Utilized (BHS). USAID/Indonesia, Contract number: 497-M-00-05-00005-00.

Contractor name:

DAI.

Date of publication:

November 2006



TABLE OF CONTENTS LIST OF FIGURES.....................................................................................................................III LIST OF TABLE ........................................................................................................................IV EXECUTIVE SUMMARY...........................................................................................................V 1.

INTRODUCTION .............................................................................................................. 1 1.1. 1.2.

2.

SUMMARY OF EXISTING DEMAND AND SUPPLY ................................................... 2 2.1. 2.2. 2.3. 2.4.

3.

BACKGROUND ..........................................................................................................................................1 REVISED PROJECT.......................................................................................................................................1 POPULATION FORECAST ...........................................................................................................................2 WATER DEMAND ......................................................................................................................................2 WATER SUPPLY-QUANTITY AND QUALITY ............................................................................................3 RAW WATER QUALITY ANALYSIS AND DISCUSSION ............................................................................5

PROJECT FORMULATION .............................................................................................. 6 3.1. WATER TREATMENT PLANT PRELIMINARY DESIGN ...............................................................................6 3.2. DISPOSAL OF RESIDUALS ...........................................................................................................................6 3.3. METHOD OF CONTRACTING ...................................................................................................................9 3.3.1. Traditional Project Procurement (Design-Bid-Build) ..............................................................................9 3.3.2. Applicability of Traditional Approach to the Pamanukan Project......................................................9 3.3.3. Alternate Project Procurement Approaches and Benefits....................................................................9

4.

COST ANALYSIS AND IMPLEMENTATION OF THE PROJECT ........................... 13 4.1. CAPITAL COSTS ...................................................................................................................................... 13 4.2. PROJECT FINANCE ASSUMPTIONS ......................................................................................................... 13 4.3. O & M COSTS ........................................................................................................................................ 14 4.4. FINANCIAL MODEL KEY ASSUMPTIONS AND RESULTS........................................................................ 18 4.4.1. Key Assumptions.......................................................................................................................................... 18 4.4.2. Results of Financial Modeling................................................................................................................... 18 4.4.3. Conclusions and Recommendations ....................................................................................................... 18



LIST OF FIGURES FIGURE 2-1: WITHDRAWALS FROM THE TARUM TIMUR CANAL BY SEASON VS. CANAL FLOW. ..........................4 FIGURE 3-1: STRUCTURE OF A TYPICAL BOT PROJECT. ........................................................................................ 11



LIST OF TABLE TABLE 2-1: SUMMARY OF 2017 PAMANUKAN SERVICE AREA WATER DEMAND....................................................2 TABLE 2-2: SUMMARY OF KEY RAW WATER QUALITY PARAMETERS FROM TARUM TIMUR CANAL. ...................3 TABLE 3-1: RESIDUALS FROM WATER TREATMENT. ..................................................................................................6 TABLE 3-2: PRELIMINARY WATER TREATMENT DESIGN AND MATERIALS BALANCE..............................................7 TABLE 4-1: SUMMARY OF CAPITAL COSTS AND IMPLEMENTATION SCHEDULE. .................................................. 13 TABLE 4-2: PROJECT FINANCE ASSUMPTIONS. ........................................................................................................ 14 TABLE 4-3: ESTIMATE OF WATER STAFFING, LABOR AND BENEFIT COSTS .......................................................... 14 TABLE 4-4: ESTIMATED WATER TREATMENT ELECTRICAL COSTS. ....................................................................... 16 TABLE 4-5: ESTIMATED ANNUAL WATER TREATMENT CHEMICAL COSTS. ......................................................... 17 TABLE 4-6: TOTAL WATER O & M COSTS. ............................................................................................................ 17 TABLE 4-7: CASH FLOWS AND UNIT COSTS FOR THE WATER TREATMENT PLANT........................................... 20 TABLE 4-8: PROJECT PRO FORMA INCOME STATEMENT AND CASH FLOWS. ...................................................... 21



EXECUTIVE SUMMARY PDAM Tirta Rangga, Kabupaten Subang, is located in West Java. PDAM Tirta Rangga is planning to build a completely new water treatment system in sub-district (Kecamatan) of Pamanukan. The proposed system, originally designed to have a capacity of around 125 liters per second, is intended to serve approximately 15,000 new connections, providing service to a population of 57,000 dispersed in several areas of Pamanukan, Legon Kulon, Binong, and Pusakanagara. The total cost of the new system, as originally envisaged, would be about Rp 58 billion (around $6 million). The need to reshape the project stems from the receipt (since the feasibility study was done) of a grant by PDAM Tirta Rangga from the West Java Provincial Government to build and operate a 50 liters/ second water treatment supply facility in the Pamanukan area. This grant project has now been commissioned and is operational. Hence, the new feasibility study (to be provided by ESP) covers the financial and technical viability of an additional 100 liters per second water treatment facility in the same area, to be designed, built and operated by a private proponent in the same area at an investment cost of around US$ 3.6 million. The two facilities, combined, would give the region a total water production capacity of around 150 l/s. Raw water would be provided from the Tarum Timur Canal which is of acceptable quality and sufficient capacity to provide water to the revised project. As the PDAM wishes to procure the project through the private sector, a variety of privatesector procurement strategies were evaluated, and the Build-Operate-Transfer (BOT) method was selected as most suitable for the current situation. Under this method, the private-sector contractor would design, construct, and operate the facilities for a 25-year contract period, at a pre-agreed price. A financial model was prepared for the project, with construction estimated at approximately Rp 35.5 billion. At a typical domestic tariff of Rp 2,500 per cubic meter, the project appears to be financially feasible. At this tariff, the average monthly water bill is estimated at Rp 39,420. A sensitivity analysis showed these results still were valid with a construction cost 20% higher than estimated. A recommendation was made to proceed with a further, more detailed feasibility study to verify assumptions made, to clarify the facilities required, and to further refine the construction and operating costs used in the model.



1. INTRODUCTION 1.1. BACKGROUND PDAM Tirta Rangga, Kabupaten Subang, is located in West Java. PDAM Tirta Rangga is planning to build a completely new water treatment system in sub-district (Kecamatan) of Pamanukan. The proposed system, originally designed to have a capacity of around 125 liters per second, is intended to serve approximately 15,000 new connections, providing service to a population of 57,000 dispersed in several areas of Pamanukan, Legon Kulon, Binong, and Pusakanagara. The total cost of the new system, as originally envisaged, would be about Rp 58 billion (around $6 million). Initially, it was thought that this new facility in Pamanukan could be done on DBL (Design, Build, Lease) basis, funded through the World Bank WSSP and the related feasibility study was commissioned by the Bank on this basis. The study suggested that the Local Government (PEMDA) of Kabupaten Subang would bear a 20% proportion of the project cost in the form of equity, and the MOF, through the loan facility provided by Bank under the aforementioned program, would provide the balance of the total cost. The Regional Government rejected the 20% share of the project cost, and DBL financing this approach would limit its ability to borrow for other purposes, PDAM management has asked for assistance from ESP to reshape the project and provide a new feasibility study for building the facility on BOT (Build, Operate, and Transfer) basis.

1.2. REVISED PROJECT The need to reshape the project stems from the receipt (since the feasibility study was done) of a grant by PDAM Tirta Rangga from the West Java Provincial Government to build and operate a 50 liters/ second water treatment supply facility in the Pamanukan area. This grant project has now been commissioned and is operational. Hence, the new BOT feasibility study (to be provided by ESP) should cover the financial and technical viability of an additional 100 liters per second water treatment facility in the same area, to be designed, built and operated by a private proponent in the same area at an investment cost of around US$ 3.6 million. The two facilities, combined, would give the region a total water production capacity of around 150 l/s.



PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

2. SUMMARY OF EXISTING DEMAND AND SUPPLY 2.1. POPULATION FORECAST The population forecast from the 2003 World Bank-funded Rapid Feasibility Study for the Pamanukan Service Area projected a served population of 56,556 people, or 14,139 connections. This is the year 2011 projection, representing approximately 70% of the projected population in the Service Area. In updating the study, a design year of 2017 has been selected, or an eight-year design. Projected population in 2017 is 90,000. At 80% coverage, this results in a served population of 72,000. In addition to residential consumption, 400 non domestic connections were assumed.

2.2. WATER DEMAND Table 2-1 is a summary of 2017 water demand by category projected from the 2003 study. Table 2-1: Summary of 2017 Pamanukan Service Area Water Demand. Consumption, Category Number l/connection/day Total Population in 2017 90,000 Served Population @ 80% Coverage 72,000 Domestic 18,000 480 (@ 4 connections/household) Non Domestic Connections 400 1,113 Total Usage 12,760 1,593 Allowance for Nonrevenue Water (@ 20% of ADD) Total Average Daily Demand (ADD) Maximum Day Demand (MDD) (@ 120% of ADD) Intake Capacity (@ 106% of MDD to account for losses)

Demand, lps

100 5.15 105.15 26.29 131.44 157.73 167.19

Since the study was completed, PDAM Tirta Rangga has completed a 50 lps water treatment plant to address a portion of this demand, and wishes to construct a second 100 lps plant and associated transmission and distribution system to address this demand.

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

2


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

2.3. WATER SUPPLY-QUANTITY AND QUALITY The raw water source for both treatment plants is the Tarum Timur Canal. The “Master Plan of Water Supply and Usage During the Planting Season 2002/2003” projected the supply from the Curug Weir to the Tarum Timur Canal at 62.5 cu m/sec. The existing withdrawals from the canal include water are for irrigation, commercial and industrial uses, private water suppliers, and the PDAM water system. The withdrawal demand is seasonal. Figure 3-1 shows the seasonal withdrawal flows from the Tarum Timur Canal, versus the flow in the canal. While the withdrawals vary significantly, it is clear that the addition of another water demand of 0.10 cu m/sec (100 lps) will not create supply problems in the canal. Table 2-2 is a summary of raw water quality data summarized in the 2003 World Bank report, along with updated raw water quality provided to the Consultant by PDAM Tirta Rangga. Table 2-2: Summary of Key Raw Water Quality Parameters from Tarum Timur Canal. Aug 20-25, Raw Water Parameter Feb 5, 2003 2003 Standard 1 pH, units

--

7.15

6.5-8.5

Turbidity, NTU

49.9

183

25

Total Dissolved Solids, mg/L

208

105

1,500

Color, TCU

150

15

50

Iron, mg/L

1.10

3.195

1.0

Manganese, mg/L

0.10

0.09

0.50

Alkalinity, mg/L

92.95

75

500

Sulfate, mg/L

2.90

44.96

400

Ammonia, mg/L

0.75

--

--

Nitrate, mg/L

--

0.537

10

Organics, mg/L

--

10.44

--

1

MEN KES RI 416.IX/1990

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

3


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

70

Tarum Timur Flow 60

50

Flow Cu M/Sec

Abstraction By Month 40

30

20

10

0 Jan

Feb

Mar

Apr

May

June

July

Aug

Sept

Oct

Nov

Dec

M th Timur Canal by Season vs. Canal Flow. Figure 2-1: Withdrawals from the Tarum

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

4


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

2.4. RAW WATER QUALITY ANALYSIS AND DISCUSSION An analysis of the data in Table 3-2 indicates that the raw water is highly colored and turbid, with high levels of iron and manganese. Organic carbon levels are elevated, but typical for raw water in Indonesia. Levels of nitrate are low, meaning that agricultural activities in the watershed are not contributing significantly to the canal. Besides the data shown on Table 3-2, the 2003 World Bank Executive Summary indicates that iron concentrations in the canal range from 0-6 mg/L. Manganese is approximately 0.1 mg/L. The Indonesian Standard for finished water for iron and manganese are 1.0 mg/L and 0.1 mg/L, respectively. In fact, lower values are desired in finished water to reduce taste and odor problems, as well as staining problems. The current Safe Water Drinking Act in the United States recommends iron and manganese levels in finished water of 0.3 mg/L for iron and 0.05 mg/L for manganese. Conventional methods for treating iron and manganese are: 1. Preaeration and settling of iron and manganese. Raw water is normally introduced into a cascade or other aeration structure. The cascade effect converts ferrous iron (Fe+2) to ferric iron (Fe+3). Ferric iron is readily precipitated as ferric hydroxide at normal water treatment pH values, where it is settled or filtered. 2. Chemical oxidation and settling of iron and manganese. Raw water is dosed with an oxidizing chemical such as chlorine, potassium permanganate, ozone, chlorine dioxide, and hydrogen peroxide. pH adjustment has also been used for iron and manganese removal. Chemicals add to the cost of treatment, and in the case of chlorine, can create trihalomethanes, which are carcinogenic at high concentrations. 3. Filtration using special greensand media. Manganese greensand is a special type of sand that removes both iron and manganese through ion exchange. Normally, the water must be aerated or chemically oxidized prior to filtration. Also, the greensand must be regenerated using potassium permanganate or chlorine. Because of the cost of importing such sand and regeneration costs, greensand filters will not be considered further.

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

5


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

3. PROJECT FORMULATION 3.1. WATER TREATMENT PLANT PRELIMINARY DESIGN Under the proposed project, a 100 lps conventional water treatment plant would be constructed on the site of the recently-constructed 50 lps plant. New and existing raw water pumps would be configured to discharge into a common preaeration cascade structure, designed to handle flow to both plants. Iron would be oxidized by the cascade, as well by chlorine via a new line run to the structure. The plant would tie in to the existing plant and use similar processes for ease of maintenance. Space for future expansion will be provided or acquired by the PDAM, when and if such an expansion is necessary. The new facilities would typically include: 1. Raw Water Intake and Pumping 2. Preaeration Cascade/Flow Splitter Structure 3. Chemical Addition Facilities (Aluminum sulfate, polymer, & chlorine) 4. Tube-Settler Clarifiers 5. Dual-Media Filters (anthracite and sand) 6. Finished Water Disinfection and Storage 7. Treated Water Pumping and Metering A materials balance and typical plant design are shown in Table 4-2 on the next page. This preliminary design will be further developed in subsequent reports should the project prove feasible.

3.2. DISPOSAL OF RESIDUALS The water treatment plant will produce residuals that will be returned to the river. Table 3-1 summarizes the residuals from the water treatment plant which require disposal: Table 3-1: Residuals from Water Treatment. Residual

Flow, Cu M/Day

Mass, Kgs/Day

Alum sludge from the sedimentation tanks

65

518

Filter backwash from the multi-media filters

212

2

Total to the river

277

520

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

6



PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

Table 3-2: Preliminary Water Treatment Design and Materials Balance. 8-Jul-06 PAMENUKAN WATER PLANT ADDITION PRELIMINARY PROCESS DESIGN COMMENT PROCESS/UNITS PLANT FLOWS Average Raw Water Feed Rate Average Raw Water Feed Rate Maximum Hourly Rate (1.25 * Average Daily Rate) Maximum Raw Water Pumping (Max Rate + 6% for Losses) FLASH MIX / AERATOR Method Number of Tanks Unit Length Unit Width Unit Depth Total Volume Minimum Mixing Detention Time FLOCCULATION Method Number of Tanks Unit Length Unit Width Unit Depth Total Volume Minimum Flocculation Detention Time SEDIMENTATION BASINS Type Number of Units Unit Length Unit Width Unit Depth Unit Effective Settling Area Total Effective Settling Area, Maximum Surface Loading Rate @ Firm Capacity Est. Sludge Prodct. @ 0.075 kgs dry solids/M3 Avg Day Flow Sludge Production @ 1% Dry Solids CHEMICAL ADDITION--ALUM Number of Dosing Pumps Dosing Pump Capacity Firm Capacity (One Unit Out of Service) Maximum Feed Rate @ 10% Solution Maximum Dosage Rate @ Maximum Day Storage at Maximum Dosing Rate CHEMICAL ADDITION--POLYELECTROLYTE Number of Dosing Pumps Dosing Pump Capacity Firm Capacity (One Unit Out of Service) Maximum Feed Rate @ 1% Solution Maximum Maximum Dosage Rate @ Maximum Day Storage at Maximum Dosing Rate FILTERS Type of Filter Rate Control Number of Units Unit Length Unit Width Unit Area Total Area Media Depth Anthracite Sand Media Characteristics--Anthracite Effective Size Uniformity Coefficient Media Characteristics--Sand Effective Size Uniformity Coefficient

UNITS l/s M3/s M3/s M3/s

2008 100 0.100 0.125 Select Maximum Value 0.133 Cascade

No M M M Cu M Mins

1 2 2 5 20.0 2.5 Hydraulic

No M M M Cu M Mins

2 7 3.5 3 147 18.5 Tube settlers

No M M M Sq M Sq M L/min/sq m Kgs/Day Cu M/Day

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

8 3 2 3 95 760 10.5 648 65

No l/s l/s kg/day mg/L Days

3 0.030 0.060 518 48 30

No l/s l/s kg/day mg/L Days

3 0.005 0.0100 9 0.8 30 Declining-Rate

No M M Sq M Sq M

6 7 3.5 25 147

M M

0.5 0.3

mm

1.0 1.3

mm

0.5 1.3

7


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

Table 3-2: Continued. Preliminary Water Treatment Design and Materials Balance. Maximum Filter Loading Rate @ Firm Capacity--All Units Maximum Filter Loading Rate, 1 Out of Service Estimated Filter Run Time Backwash Method Backwash Source Backwash Pumps Type Unit Capacity No.of Units Unit Power (estimated) Backwash Loading Rate @ Firm Capacity Typical Backwash Duration Total Backwash Volume Total Backwash Volume, % of Average Day Raw Water DISINFECTION Type No of Chlorination Units, Pre and Post Unit Capacity, Pre and Post Total Capacity Dosage, Pre and Post Chlorine Contact Chamber (in Clearwell) Number Length Width Depth Contact Time @ Maximum Day Cylinder Storage Provided (100 kg Cylinders) Storage @ Average Flow & Dosage of 3 mg/L CLEARWELL Type Number of Units Unit Length Unit Width Unit Depth Total Volume Minimum Detention Time, Baffling Factor of 0.1 Typical Free Chlorine Concentration CT Value @ 1.5 log Reduction (pH 7.5, 25 deg C) Average Day Finished Water (After Backwash & Sludge) Average Day Finished Water (After Backwash & Sludge) Maximum Day Finished Water (After Backwash & Sludge) Maximum Day Finished Water (After Backwash & Sludge) FINISHED WATER PUMPS Number of Units

M/hr M/hr Hrs

3.1 3.7 24 Air Scour Clearwell

l/s Ea kw M/hr Mins Cu M/Day %

Vertical Turbine 100 2 6 15 10 356 4.1% Chlorine Gas

No Kgs/Day Kgs/Day mg/L

2 100 200 9.3

NO M M M Mins Ea Days

1 6 2 3.5 11 5 19 Baffled

No M M M Cu M Mins mg/L mg/L-Mins M3/s Cu M/Day M3/s Cu M/Day

Unit Capacity (estimated) Required Firm Capacity (1 Unit Out of Service ) Total Dynamic Head (estimated) Total Dynamic Head (estimated) Unit Power (estimated) MAIN TRANSMISSION LINE TO DISTRIBUTION SYSTEM Pipe Material Number of Pipes Diameter Velocity @ max-day flow Velocity Head Estimated Total Dynamic Head Calculation Fittings (K = 5) Friction loss at say, 5000 m C = 100 Minor loss, say System Head @ Distribution System Estimated Total Dynamic Head

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

2 30 25 6 9,000 124.9 Baffling Condition Factor of 0.5 1.0 124.9 0.095 8,219 0.120 10,379

Ea

3

l/s l/s

50 100

M kPa kw

190 1,798 106 Ductile Iron

mm M/s M

1 250 2.04 0.21

M M M M M

1.1 128 1.0 60 190

8


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

3.3. METHOD OF CONTRACTING This section will define and contrast traditional project procurement methods and alternate Private-Sector Procurement (PSP) methods that may be applicable to the Pamanukan Project.

3.3.1.

TRADITIONAL PROJECT PROCUREMENT (DESIGN-BID-BUILD)

The traditional project procurement model typically used by municipalities is referred to as Design-Bid-Build (DBB). Under the traditional DBB approach, there are separate contractual relationships between the PDAM, the Design Engineer, and a Construction Contractor. Any operations and maintenance services are performed by the PDAM, or subcontracted under a separate contract. Most infrastructure projects such as roads, bridges, pipelines (water, wastewater and gas) are procured using the Design-Bid-Build approach. Local consultants or in-house engineering team prepare a detailed design, tender the project to experienced contractors, and oversee the work. The contractor receives progress payments from the PDAM, which finance the project from their capital budget.

3.3.2.

APPLICABILITY OF TRADITIONAL APPROACH TO THE PAMANUKAN PROJECT

The design, construction and operation of a water facility is more complex than many infrastructure projects, and requires more specialized experience and expertise than is available to the PDAM. While the DBB contract structure is well understood by the PDAM, and provides them with a high level of control and involvement, the PDAM has decided to finance the capital for the project via the private sector.

3.3.3.

ALTERNATE PROJECT PROCUREMENT APPROACHES AND BENEFITS

A traditional project delivery approach involves discrete and sequential project components and contractual relationships between the PDAM and designers, contractors, and occasionally with operators. This can result in significant project management time by PDAM staff, an unclear delineation of responsibility and liability between design engineer, contractor, and operator for construction schedule and ultimate performance of the Pamanukan facility. Alternative project delivery models change the traditional roles and responsibilities of project participants by reducing the number of private-sector contractual relationships with the PDAM, while increasing the roles, responsibilities, and liabilities in those relationships.

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

9


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

A number of private-sector participation structures have been used to procure infrastructure facilities in the developing world. Other possible PSP procurement structures for the proposed facility are: 1. Design-Build-Operate 2. Build-Operate-Transfer 3. Management Contract for Operation and Maintenance. These PSP structures are discussed below. Design-Build-Operate (DBO). A DBO project involves a single contractual relationship between the PDAM and a DBO service provider or contractor. The DBO contract streamlines the project delivery schedule and reduces costs by eliminating separate selection processes for engineering, construction, procurement, and operating services. DBOs are often used on projects where project performance and the value of the service to be provided are more important than the details of what happens with the various procurement steps along the way. DBOs are particularly popular for fast-track projects, as well as complex projects that include relatively new technology and/or specialized O&M expertise. The complexity of the water project involves project development, engineering, construction, and operations and would require the PDAM’s management support team to include a Procurement Advisor, Design Engineer, Attorney, and Financial Advisor. PDAM Tirta Rangga may grant the DBO contractor wide latitude in the treatment technologies used, and the ways in which they are applied. The DBO project team often includes a technology provider for whom the process treatment technology is a core-competency. Therefore, the team may be willing to accept the risk of employing new and innovative solutions to lower production costs and improve operability. Companies specializing in process technology also have ready-access to new technologies. With a vested interest in controlling operating expenses, DBO contractors have a greater tendency to value-engineer plant designs and incorporate more expensive state-of-the-art technology. These projects often are driven by life-cycle costs because a single entity is responsible for design, construction, and O&M. One of the DBO participants will be the project guarantor and provide the PDAM with cost, schedule, and performance guarantees assuring that the project will perform as required, and that the equipment will be maintained, repaired, and replaced according to reasonable and measurable standards. Under the DBO method, the PDAM would be required to provide all financing of the project. Because it does not contain financing risk, the term of a DBO contract can vary according to the PDAM’s desire. It is estimated that the time to design and construct the water treatment facility is 1-2 years. The operations contract could run an additional 5 –10 years after construction, at the option of the PDAM.

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

10


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

Build- Operate-Transfer (BOT). Build-Operate-Transfer (BOT) projects are an expansion of the DBO concept, in which the BOT Contractor also finances the project through a combination of debt and equity. The BOT contract for the water treatment plant often serves as collateral to secure commercial private financing. An illustrative diagram of a typical BOT contract for the Pamanukan Project is shown in Figure 4-1.

PDAM Tirta Rangga

Fees

Service Equity Shareholders

Legal

Tax Advisor

Pamanukan Project Company

International & Local Banks

Insurance Companies

Engineer

Construction Contractor

Figure 3-1: Structure of a Typical BOT Project.

PDAM Tirta Rangga, supported by financial, legal, technical, and environmental advisors, selects the successful BOT Contractor from other prequalified consortiums based on a conceptual design, operating plan, and guaranteed treatment cost. The contract defines all aspects of the service delivery agreement including the contract term, production requirements, cost of service, financing arrangements, guarantees/ warranties, and all remedies. BOT contracts contain provisions to transfer ownership of the asset from the Project Company to the PDAM. The transfer is usually accomplished at the 'fair market value' of the enterprise or the amount of remaining indebtedness. It may take place at the end of the contract term, or at a mutually agreeable date prior to the contract's expiration. The primary benefit of a BOT project delivery is that the vendor/technology provider assumes both the technical risk and commercial risk, including the risk of development, permitting, and financing. PDAM Tirta Rangga is relieved of the financial burden of the project and wellinsulated from its liabilities and risks; the PDAM pays only for water treatment for which they have contracted. One key element in the structuring of a BOT contract is the relative contributions of debt and equity to financing the project. Equity is represented by private sector contributions to the project, and represents one of the major risks assumed by the private sector in a BOT transaction. ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

11


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

Typical BOT projects have historically used debt: equity ratios of 70%-30% to 80%-20%. Minimum equity requirements are typically prescribed in the tender documents. As a general matter, most lenders to the sector would require a minimum equity contribution of 20%. Equity in BOT projects is largely repaid later in the project life, as debt is retired and as project revenues begin to outpace project costs. As a result, equity requires a higher return than debt, often in the range of 18-23% return on equity. Thus, while higher equity contributions can lower initial project finance costs and any tariff increases, overall financing cost over the project life will be higher. In addition, higher equity ratios may dictate that a longer BOT contract term to recover an acceptable payback on equity. A BOT structure would allow PDAM Tirta Rangga the flexibility to finance a portion of the project, or none at all, while assigning technical and most or all technical, contractual and financial risk to the private sector. A BOT structure would permit a fast track project and would require a minimum of technical ability and commitment from the PDAM staff. A number of BOT variations are possible, given the PDAM’s interest in possibly financing a portion of the project. These variations have been evaluated in the financial model and are presented in more detail in the next section of the report. Management Contracts for Operations and Maintenance. A management contract for operations and maintenance (O&M) is a contract to operate and maintain a facility, usually at a fixed price for a specified term. The term of the contract can vary, but is typically 5 years. The contractor usually indemnifies the industry against fines for violations of performance standards. O&M contracts are increasingly utilized for complex projects, for large projects requiring large numbers of new staff, or where operating costs are perceived to be high. The principal benefits of the O&M contract are: No need to hire additional operating staff A fixed price contract, often less than in-house operation. Guaranteed performance Indemnification against additional costs and fines A management contract could be utilized to operate both the new plant and the recently constructed plant.

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

12


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

4. COST ANALYSIS AND IMPLEMENTATION OF THE PROJECT 4.1. CAPITAL COSTS An estimate of the capital costs was made in the 2003 World Bank Rapid Feasibility Study Report, and updated for this report, assuming an annual inflation rate of 10%. It has been assumed that the existing raw water intake is sufficient for the total design flow. An allowance of Rp 10 billion has been included for transmission and distribution lines. This figure should be verified prior to the commencement of the design. The estimated capital cost for the proposed water treatment plant addition is shown in Table 4-1. Table 4-1: Summary of Capital Costs and Implementation Schedule. Item

Cost, Rp (000)

Treatment Plant Addition

15,000,000

Reservoir Addition & Distribution Pumps

4,500,000

Transmission and Distribution System Improvements, Allowance

10,000,000

Contingency @ 20%

6,000,000

Total Capital Cost

35,500,000

Construction of the additional treatment facilities have been assumed to commence in 2008, with a one-year construction period. The facilities have been assumed to be on-line in 2009. In the start of the program, a 1-year period has been assumed for procurement of the contractor(s), including the following steps: 1. Notification and prequalification of prospective tenderers; 2. Solicitation of bids from prequalified tenderers; 3. Evaluation and award to the lowest cost, most responsive tenderer; 4. Finalize contract negotiations; 5. Mobilization by the contractor

4.2. PROJECT FINANCE ASSUMPTIONS For purposes of financing the capital costs, short-term loans were assumed to cover the period of construction, with longer term financing used once the facilities are on-line. It has been assumed that the private sector will finance the entire project. Equity financing of 30% of the total capital cost has been assumed.

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

13


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

Table 5-2 contains the assumptions used in developing the project finance assumptions. These assumptions are used in developing the average project costs per cubic meter of water treated. Table 4-2: Project Finance Assumptions. Cost

Rate

Term

Construction Financing

10%

Length of Construction

Long-Term Financing

15%

13 Years

Equity Financing (ROE)

25%

25 years

4.3. O & M COSTS The annual operation and maintenance costs for the water treatment plant fall into five general categories: 1. Labor and benefits 2. Electricity 3. Chemicals 4. Maintenance and repair 5. Supplies Labor and Benefits. Table 4-3 is an estimate of plant staffing, labor cost and benefits for the new water treatment facility. The plant staffing represents a 3-shift operation of 8 hours each, with the second and third shift operating at a reduced level. Salary and benefit costs are estimated. Table 4-3: Estimate of Water Staffing, Labor and Benefit Costs Number of Workers

Individual Salary, Rp/Month

Individual Benefits, Rp/Month

Monthly Labor Cost, Rp/Month

Annual Labor Cost, Rp/Year

Civil Engineer

1

1,800,000

270,000

2,070,000

24,840,000

Laboratory Manager

1

1,400,000

210,000

1,610,000

19,320,000

Mechanic

1

1,000,000

150,000

1,150,000

13,800,000

Electrician

1

1,000,000

150,000

1,150,000

13,800,000

Operator

6

1,000,000

150,000

6,900,000

82,800,000

Maintenance

2

1,000,000

150,000

2,300,000

27,600,000

Laborer

2

800,000

120,000

1,840,000

22,080,000

Driver

1

1,000,000

150,000

1,150,000

13,800,000

Total

15

18,170,000

218,040,000

Position

Electrical. Table 4-4 is an estimate of the electrical usage and costs for operating the various pumps for the water treatment plant. An electrical tariff of Rp 450 per kilowatthour was used to estimate the annual electrical cost. These costs have been assumed to be variable with water demand.

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

14


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

Chemical Costs. Chemical costs have been estimated, assuming alum, polymer, and chlorine will be used. Table 5-5 shows the annual estimated chemical usage and costs for the water treatment plant. These costs have been assumed to be variable with water demand. Other Costs. The annual costs of maintenance and repair and supplies have been estimated from plants of similar size and type. Total O & M Costs. The total annual operation and maintenance costs for the water treatment plant are shown in Table 5-6.

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

15


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

Table 4-4: Estimated Water Treatment Electrical Costs. PROJECTED TREATMENT PLANT ELECTRICAL ENERGY USAGE--100 lps Water OUTPUT

INPUT

NO OF UNITS

NO OF UNITS

HRS/DAY

KW-HRS/

KW-HRS/

KW

KW

INSTALLED

OPN

OPN

DAY

YEAR

Backwash Pumps

6.0

6.5

2

1

4

26

9,522

Alum Metering Pumps

0.8

0.8

2

1

24

20

7,237

Polymer Metering Pumps

0.8

0.8

2

1

24

20

7,237

Chlorination Water Pumps

10

10.9

2

1

24

261

95,217

106.0

115.2

3

2

24

5,530

1

24

293

MOTOR

Finished Water Pumps Miscellaneous @ 5 % used TOTAL ELECTRICAL USAGE

124

134

TOTAL ELECTRICAL COST @

450

Rp PER KW-HOUR

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

6150

2,018,609 106,891 2,244,712 1,010,120,361

16


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

Table 4-5: Estimated Annual Water Treatment Chemical Costs. Flow, Cu M/Day

8,640

@ 100 lps

Alum Concentration

mg/l

25

Weight

kg/day

216

Weight

kg/year

78,840

Rp/kg

5,000

Price Alum Cost

Rp/year

Estimate

@ Rp5,000,000/1000 kgs

394,200,000

Polymer Concentration

mg/l

3

Weight

kg/day

26

Weight

kg/year

9,461

Rp/kg

1,400

Price Polymer Cost

Rp/year

Estimate

@ Rp1,400,000 /1000 kgs

13,245,120

Chlorine Concentration

mg/l

2

Weight

kg/day

17

Weight

kg/year

6,307

Price

$/kg

9,500

Cost

$/year

Estimate

@ Rp 9,500,000/1000 kgs

59,918,400

Total Chemical Cost

467,363,520

Total Chemical Cost

86

Rp/Cu M

Table 4-6: Total Water O & M Costs. Cost Category

Annual Cost, Rp.

Labor and Benefits

218,040,000

Electricity

1,010,120,361

Chemicals

270,263,520

Maintenance and Repair

50,000,000

Supplies

15,000,000

Total O & M Cost

1,563,423,881

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

17


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

4.4. FINANCIAL MODEL KEY ASSUMPTIONS AND RESULTS Tables 5-7 and 5-8 show the recommended investment program schedule, the amortized capital costs, annual operation and maintenance costs, and the resulting unit treatment costs.

4.4.1.

KEY ASSUMPTIONS

The following are key assumptions in the financial modeling of the Pamanukan project: 1. The project would be a BOT project financed by 70% debt and 30% equity contributions. 2. Interest on debt = 15%. Term of debt = 13 years. Required minimum return on equity = 25%. 3. Debt service repayment would begin after 2 years. 4. The water tariff for domestic consumption was Rp 2,500 / Cu M. The tariff for water for non-domestic consumption was Rp 4,500 / Cu M. 5. The tariff collection rate for domestic billing was 80%, and 90% for non-domestic bills. 6. The number of existing connections is approximately 7,600 at 4 persons per connection. The rate of new domestic connections is as follows: 2008-2012 15% per year 2013-2017 10% per year 2018-2028 2% per year

4.4.2.

RESULTS OF FINANCIAL MODELING

The results of the financial modeling show that the project appears to be feasible at the costs and financial structure assumed for the project. Key outputs showing that the project is financially feasible are: 1. The assumed water tariff level of Rp 2,500 appears reasonable, given other tariff levels in the area. The average monthly water bill would be approximately Rp 39,420. 2. Debt service coverage ratio (DSCR) averages well above 1.40 throughout the project, considered a minimum value for lenders. A high DSCR shows that cash flow from operations is available to service debt. 3. Return on equity (ROE) is 35% over the 25-year contract period. A minimum of 2025% ROE is considered acceptable by a PPP contractor. 4. A sensitivity analysis for increased capital costs of 20% show that acceptable values for DSCR and ROE are still within the acceptable range at the same assumed tariff.

4.4.3.

CONCLUSIONS AND RECOMMENDATIONS

The conclusion of this study is that the proposed 100 lps water treatment plant and associated facilities are financially feasible, and can be procured via the private sector through a BOT model.

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

18


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

It is recommended that a further, more detailed feasibility study be prepared to develop the project in more detail. In particular, the following data must be developed and/or refined further through site visits and review of existing construction drawings: 1. More detailed project description of necessary facilities including: a. The capacity of the existing raw water intake; b. The layout of existing water treatment facilities on the existing site, and a layout of the proposed facilities on the same site; c. The capacity of existing primary transmission lines and the possible need for additional capacity; d. A layout of the secondary distribution system in the proposed project area. 2. More detailed construction costs based upon the results from the additional technical data and design information. 3. Updated operation and maintenance costs for the revised facilities. 4. Incorporation of the existing 50 lps facilities into the financial projections, particularly the labor costs.

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

19


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

Table 4-7: Cash Flows and Unit Costs for the Water Treatment Plant. Year Capital Cost--Water Treatment Plant (000)

2006

2007

2008

35,500,000

17,750,000

17,750,000

Interest During Construction @ 10%

3,550,000

1,775,000

1,775,000

Total Capital

39,050,000

19,525,000

19,525,000

Total Financed @ 70/30 Debt Equity (000)

27,335,000

Equity @ 30% of Capital

11,715,000

Amortized Water Treatment Investment (000) @

15%

2009

2010

2011

2012

2013

2014

2015

2016

2017

2018

2019

2020

2021

2022

2023

(4,895,984)

(4,895,984)

(4,895,984)

(4,895,984)

(4,895,984)

(4,895,984)

(4,895,984)

(4,895,984)

(4,895,984)

2024

2025

2026

2027

2028

(5,857,500) (5,857,500)

(4,895,984) (4,895,984) (4,895,984) (4,895,984)

Operation & Maintenance Costs Rp (000) Labor

(218,040) (218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

Electricity

(77,248) (164,130)

(255,588)

(356,534)

(434,686)

(520,328)

(614,208)

(717,151)

(830,063)

(855,489)

(881,398)

(907,799)

(934,702)

(962,117)

(990,054)

(1,018,524)

(1,047,537)

(1,077,104)

(1,107,237)

(1,137,947)

Chemicals

(20,668)

(43,914)

(68,384)

(95,393)

(116,303)

(139,217)

(164,335)

(191,878)

(222,088)

(228,891)

(235,823)

(242,887)

(250,085)

(257,420)

(264,895)

(272,512)

(280,275)

(288,185)

(296,248)

(304,464)

Maintenance and Repair

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

Supplies

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(10,853)

(23,059)

(35,908)

(50,090)

(61,069)

(73,101)

(86,290)

(100,753)

(116,616)

(120,188)

(123,828)

(127,537)

(131,316)

(135,168)

(139,093)

(143,093)

(147,169)

(151,323)

(155,556)

(159,870)

(380,956) (491,084) (607,012) (734,967) (834,029) (942,584) (1,061,583) (1,192,069) (1,335,191) (1,367,420) (1,400,261) (1,433,726) (1,467,826) (1,502,576) (1,537,988) (1,574,075) (1,610,851) (1,648,330) (1,686,525)

(1,725,451)

Raw Water Extraction (Rp 45 / Cu M) Total O & M Costs Rp (000)

Total Annual Cost Incl Debt Service, Rp (000)

Flow, Cu M/Year

Total Cost, Rp Per Cu M

(5,857,500) (5,857,500) (380,956) (491,084) (5,502,996) (5,630,952) (5,730,013) (5,838,569) (5,957,567) (6,088,053) (6,231,176) (6,263,405) (6,296,245) (6,329,710)

241,167

1,580

512,416

958

797,946

6,896

1,113,102

1,357,092

5,059

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

4,222

1,624,465

3,594

1,917,560

3,107

2,238,948

2,719

2,591,460

2,405

2,670,841

2,345

2,751,728

2,288

2,834,152

2,233

(6,363,811)

2,918,143

2,181

(6,398,561)

3,003,732

2,130

(6,433,973)

3,090,952

2,082

(1,574,075)

3,179,835

495

(1,610,851)

3,270,414

493

(1,648,330)

3,362,724

490

(1,686,525)

3,456,799

(1,725,451)

3,552,674

488

486

20


PDAM KABUPATEN SUBANG - PAMANUKAN WATER TREATMENT PLANT PRE FEASIBILITY STUDY

Table 4-8: Project Pro Forma Income Statement and Cash Flows. Year

2006

2007

2008

Pro Forma Income Statement Number of New Domestic Customers Average Household Use, Cu M/Year

2009

4,579

2010

9,844

2011

2012

15,899

22,863

2013

28,201

2014

34,074

2015

40,534

2016

47,639

2017

55,456

2018

57,175

2019

58,929

2020

60,718

2021

2022

62,543

2023

64,405

2024

66,303

2025

68,240

2026

70,215

2027

72,230

2028

74,285

76,381

175

175

175

175

175

175

175

175

175

175

175

175

175

175

175

175

175

175

175

175

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,700

2,165,861

4,656,601

7,520,952 10,814,956 13,340,359 16,118,302 19,174,039 22,535,351 26,232,793 27,046,230 27,875,936 28,722,237

29,585,463

30,465,954

31,364,054

32,280,117

33,214,500

34,167,572

35,139,705

36,131,280

80%

80%

80%

80%

80%

80%

80%

80%

80%

80%

80%

80%

1,732,689

3,725,281

6,016,762

8,651,965 10,672,287 12,894,642 15,339,232 18,028,281 20,986,234 21,636,984 22,300,749 22,977,789

23,668,370

24,372,763

25,091,243

25,824,093

26,571,600

27,334,057

28,111,764

28,905,024

100

200

250

275

300

325

350

375

400

410

420

430

440

450

460

470

480

490

500

510

406

406

406

406

406

406

406

406

406

406

406

406

406

406

406

406

406

406

406

406

4,500

4,500

4,500

4,500

4,500

4,500

4,500

4,500

4,500

4,500

4,500

4,500

4,500

4,500

4,500

4,500

4,500

4,500

4,500

4,500

182,810

365,621

457,026

502,728

548,431

594,133

639,836

685,538

731,241

749,522

767,803

786,084

804,365

822,646

840,927

859,208

877,489

895,770

914,051

932,332

90%

90%

90%

90%

90%

90%

90%

90%

90%

90%

90%

90%

90%

90%

90%

90%

90%

90%

90%

90%

164,529

329,058

411,323

452,455

493,588

534,720

575,852

616,985

658,117

674,570

691,023

707,476

723,929

740,382

756,834

773,287

789,740

806,193

822,646

839,099

1,897,218

4,054,339

6,428,085

9,104,420 11,165,875 13,429,362 15,915,084 18,645,265 21,644,351 22,311,554 22,991,772 23,685,265

24,392,299

25,113,144

25,848,078

26,597,381

27,361,341

28,140,251

28,934,410

29,744,123

Labor

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

(218,040)

0

Electricity

(164,130)

(255,588)

(356,534)

(434,686)

(520,328)

(614,208)

(717,151)

(830,063)

(855,489)

(881,398)

(907,799)

(934,702)

(962,117)

(990,054)

(1,018,524)

(1,047,537)

(1,077,104)

(1,107,237)

(1,137,947)

0

Chemicals

(43,914)

(68,384)

(95,393)

(116,303)

(139,217)

(164,335)

(191,878)

(222,088)

(228,891)

(235,823)

(242,887)

(250,085)

(257,420)

(264,895)

(272,512)

(280,275)

(288,185)

(296,248)

(304,464)

0

Maintenance and Repair

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

(50,000)

0

Supplies Raw Water Extraction (45 Rp/Cu M)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

(15,000)

0

(10,853)

(23,059)

(35,908)

(50,090)

(61,069)

(73,101)

(86,290)

(100,753)

(116,616)

(120,188)

(123,828)

(127,537)

(131,316)

(135,168)

(139,093)

(143,093)

(147,169)

(151,323)

(155,556)

(159,870)

Total O & M Costs (000)

(491,084)

(607,012)

(734,967)

(834,029)

(942,584) (1,061,583) (1,192,069) (1,335,191) (1,367,420) (1,400,261) (1,433,726)

(1,467,826)

(1,502,576)

(1,537,988)

(1,574,075)

(1,610,851)

(1,648,330)

(1,686,525)

(1,725,451)

0

Operating Profit (Deficit)

1,406,134

3,447,328

5,693,117

8,270,391 10,223,290 12,367,779 14,723,015 17,310,074 20,276,931 20,911,293 21,558,046 22,217,438

22,889,722

23,575,156

24,274,002

24,986,529

25,713,011

26,453,726

27,208,959

29,744,123

2.86

0.63

1.01

1.44

1.75

2.08

2.42

2.78

3.24

3.32

3.41

3.49

3.58

3.66

15.42

15.51

15.60

15.69

15.77

Less Debt Service

491,084

5,502,996

5,630,952

5,730,013

5,838,569

5,957,567

6,088,053

6,231,176

6,263,405

6,296,245

6,329,710

6,363,811

6,398,561

6,433,973

1,574,075

1,610,851

1,648,330

1,686,525

1,725,451

0

Less Depreciation

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

0

Sample Tariff, Rp/Cu M Total Potential Revenue, Rp/Year (000)

1,800

% Collected Total Domestic Revenue Actually Collected, Rp/Year (000) Number of New Nondomestic Customers Average Nondomestic Use, Cu M/Year Sample Tariff, Rp/Cu M Total Potential Revenue, Rp/Year % Collected Total Revenue Actually Collected, Rp/Year (000) Total Revenue Collected, Rp/Year (000)

80%

80%

80%

80%

80%

80%

80%

80%

Operating Costs, (000) Rp

Debt Service Coverage Ratio

Profit Before Taxes

(646,951) (3,617,668) (1,499,834)

Add Back Depreciation

1,562,000 IRR

Cash Flow From Operations, Rp (000)

#DIV/0!

978,378

2,822,722

4,848,212

7,072,962

9,516,898 12,451,526 13,053,048 13,666,336 14,291,628

14,929,162

15,579,183

21,137,927

21,813,678

22,502,681

23,205,201

23,921,509

29,744,123

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

1,562,000

0

915,049 (2,055,668)

62,166

2,540,378

4,384,722

6,410,212

8,634,962 11,078,898 14,013,526 14,615,048 15,228,336 15,853,628

16,491,162

17,141,183

22,699,927

23,375,678

24,064,681

24,767,201

25,483,509

29,744,123

1%

29%

41%

50%

70%

70%

90%

91%

91%

91%

91%

103%

0 (5,857,500) (5,857,500) (4,942,451) (6,998,119) (6,935,953) (4,395,575)

(10,854)

1,562,000

1,562,000

1,562,000

13,772,436

37.0%

0

0

Avg Cash Flow Margin, % (Cash Flow / Revenue)

53%

Net Cash Flow, Rp (000)

Return on Equity, %

Average Monthly Bill, Rp

-55%

56%

61%

67%

68%

68%

69%

6,399,358 15,034,320 26,113,218 40,126,745 54,741,792 69,970,129 85,823,756 102,314,918 119,456,101 142,156,028 165,531,706 189,596,387 214,363,589 239,847,097 269,591,220

35%

-

-

-

39,420

39,420

39,420

39,420

39,420

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

39,420

39,420

39,420

39,420

39,420

39,420

39,420

39,420

39,420

39,420

39,420

39,420

39,420

39,420

39,420

21



ENVIRONMENTAL SERVICES PROGRAM Ratu Plaza Building, 17th. Fl. Jl. Jend. Sudirman No. 9 Jakarta 10270 Indonesia Tel. +62-21-720-9594 Fax. +62-21-720-4546 www.esp.or.id


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.