Report No: ACS16206 . Republic of Kenya Kenya Urban Commercial Financing for Water and Sanitation Kenya Water Service Provider Creditworthiness Index Report . November 2015 . GWASA AFRICA . Document of the World Bank . Standard Disclaimer: . This volume is a product of the staff of the International Bank for Reconstruction and Development/ The World Bank. The findings, interpretations, and conclusions expressed in this paper do not necessarily reflect the views of the Executive Directors of The World Bank or the governments they represent. The World Bank does not guarantee the accuracy of the data included in this work. The boundaries, colors, denominations, and other information shown on any map in this work do not imply any judgment on the part of The World Bank concerning the legal status of any territory or the endorsement or acceptance of such boundaries. . Copyright Statement: . The material in this publication is copyrighted. Copying and/or transmitting portions or all of this work without permission may be a violation of applicable law. The International Bank for Reconstruction and Development/ The World Bank encourages dissemination of its work and will normally grant permission to reproduce portions of the work promptly. For permission to photocopy or reprint any part of this work, please send a request with complete information to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, USA, telephone 978-750-8400, fax 978-750-4470, http://www.copyright.com/. All other queries on rights and licenses, including subsidiary rights, should be addressed to the Office of the Publisher, The World Bank, 1818 H Street NW, Washington, DC 20433, USA, fax 202-522-2422, e-mail pubrights@worldbank.org. Kenya Water Service Provider Creditworthiness Index Report November 2015 A publication of the Water Services Regulatory Board in collaboration with the World Bank Water Practice Cover Photo Credits: Ramadhan Khamis The Water Services Regulatory Board (WASREB) is a non-commercial State Corporation established in March 2003 as part of the comprehensive reforms in the water sector. The mandate of the institution is to oversee the implementation of policies and strategies relating to provision of water and sewerage services. WASREB sets rules and enforces standards that guide the sector towards ensuring that consumers are protected and have access to efficient, affordable and sustainable services. The Water and Sanitation Program is a multi-donor partnership, part of the World Bank Group’s Water Global Practice, supporting poor people in obtaining affordable, safe, and sustainable access to water and sanitation services. WSP’s donors include Australia, Austria, Denmark, Finland, France, the Bill & Melinda Gates Foundation, Luxembourg, Netherlands, Norway, Sweden, Switzerland, United Kingdom, United States, and the World Bank. Disclaimer The findings, interpretations, and conclusions expressed herein are entirely those of the authors and should not be attributed to the World Bank, WASREB or its affiliated organizations, or to members of the Board of Executive Directors of the World Bank or the governments they represent. The World Bank does not guarantee the accuracy of the data included in this work. The boundaries, colors, denominations, and other information shown on any map in this work do not imply any judgment on the part of the World Bank Group concerning the legal status of any territory or the endorsement or acceptance of such boundaries. The material in this publication is copyrighted. Requests for permission to reproduce portions of it should be sent to wsp@worldbank. org or info@wasreb.go.ke. The World Bank and WASREB encourage the dissemination of its work and will normally grant permission promptly. The Water and Sanitation Program reports are published to communicate the results of the program’s work to the development community and other stakeholders. Some sources cited may be informal documents that are not readily available. For more information, please visit www.wsp. org or wasreb.go.ke. 2015 WASREB/World Bank All Rights Reserved. Kenya Water Service Provider Creditworthiness Index Report November 2015 Foreword The Constitution of Kenya ensures the provision of safe water in adequate quantities and access to sanitation as human right for the citizens. To achieve this goal, substantial investment in water supply and sanitation services infrastructure is required both for rehabilitation of existing infrastructure, as well as for expanding water supply and sewer connections to unserved areas. Given the competing demands from different sectors of the economy, it is increasingly difficult for the available public sector resources, to match investments required in the sector to meet the needs for growing population. Partnership with the private sector is critical in plugging the finance gap for infrastructure development. Water Services Providers (WSPs), operating above full cost coverage and under an effective regulatory environment, provide an opportunity for private sector financing. This is also enhanced by the bankability of the subsector. In 2011, to further help facilitate commercial lending into the water sector of Kenya, the Water Services Regulatory Board (WASREB), in collaboration with the Water and Sanitation Program of the World Bank, facilitated shadow credit ratings of 43 Water Services Providers in Kenya. The results of this exercise were published in the report “Financing Urban Water Services in Kenya: Utility Shadow Credit Ratings”. The report identified 13 creditworthy WSPs. The publication of the Utility Shadow Credit Ratings report was a large step towards accessing commercial financing for the water services subsector in Kenya. The report spurred interest in commercial lending to the sector among WSPs, commercial lenders and development partners. However, in spite of the advantages, the report could not easily be annually updated because of complexity around data collection and analysis and cost required for the annual update. To resolve this problem and provide a timely and cost effective credit assessment tool, the WSP Creditworthiness Index was created. The Creditworthiness Index provides a simplified snap-shot of the financial and operational performance of WSPs in lieu of performing full shadow credit ratings analysis, which is more thorough but time consuming and expensive. The Creditworthiness Index is automated and calculated from data collected by WASREB. Going forward, the Creditworthiness Index will be incorporated into the annual Impact Reporting. The trade off of this automation is that qualitative analysis normally performed in detailed shadow credit rating is omitted. However, there is a significant correlation between the Creditworthiness Index scores and the recently performed shadow ratings. The Creditworthiness Index provides a useful starting point for screening the creditworthiness of the WSPs by the commercial lenders and becomes a management tool for the WSPs. It will also provide the public with insights about the capacity of the WSP to provide sustainable provision of water services and the basis for demanding a high degree of financial accountability. This report, together with the Impact Report, provides a snapshot of the financial and operational performance of the WSPs across the sector and insights into the sector wide trends. Together with the commercial lending toolkits that have been developed, the report provides both the public and private sector with an insight of the sub-sector and the opportunities available. I wish to acknowledge the various parties who made this exercise a success. I thank the World Bank for its partnership with the WASREB in the exercise, the WSPs for their cooperation in providing information, WASREB’s staff for quality control and coordination of the exercise, and all the teams involved in the drafting and editing of this report. Eng. Robert Gakubia Chief Executive Officer, WASREB iv Creditworthiness Index Report Acknowledgements This report was prepared jointly by Water Services Regulatory Board (WASREB) and the World Bank led by Eng. Robert Gakubia, CEO of WASREB, Eng. Peter Njaggah of WASREB and Kevin Bender, Task Team Leader/Senior Financial Specialist of the World Bank’s Water and Sanitation Program. The preparation of this report was supported by a team of industry experts led by Ernst & Young LLP (Kenya) and included Afcap Consulting Ltd and WS Atkins International Ltd. The publication was supported by the World Bank/Water and Sanitation Program’s Kenya Commercial Financing for Urban Water and Sanitation project. The overall objective of the project is to facilitate access to commercial finance for Kenya’s Water Service Providers from commercial lenders by directly supporting all stakeholders involved in the process. The report was created via consultations with the Ministry of Environment, Water and Natural Resources, WASREB, Water Service Providers, Water Services Boards, the Public Private Partnership Unit of Kenya, local commercial banks, County governments and development partners. The team is grateful to the World Bank peer reviewers, Josh Gallo, Senior Municipal Finance Specialist, Ketut Ariadi Kusuma, Senior Securities Market Specialist, and Lili Liu Lead Economist, for their review of the document. The team is grateful to Glenn Pearce-Oroz, Regional Team Leader, Water and Sanitation Program, Clifford Waithaka, Jemima Sy, Magdaline Nkando of the World Bank and all WASREB and World Bank colleagues who provided support throughout the preparation of this document. The material in this publication is copyrighted. Requests for permission to reproduce portions of it should be sent to info@wasreb.go.ke or wsp@worldbank.org. Water and Sanitation Program encourages the dissemination of its work and will normally grant permission promptly. For more information, please visit www.wsp.org or www.wasreb.co.ke. © WASREB/World Bank November 2015 World Bank/WASREB v Contents 1. Executive Summary 1 1.1 Rationale 1 1.2 Background 2 1.3 Creditworthiness Index 3 1.4 The Purpose of the Index 3 1.5 Methodology 4 1.6 Summary of Findings 4 1.7 The Structure of this Report 4 2. Evolution of Credit Assessment in the Water Sector of Kenya 5 2.1 Introduction 5 2.1.1 Background of Credit Ratings in the Water Sector in Africa 5 2.1.2 The 2011 Shadow Credit Rating Report 6 2.1.3 The Creditworthiness Index 8 3. Overview of the Kenyan Water Sector 9 3.1 The Water Sector in Context of the Kenyan Environment 9 3.1.1 Socio-Economic Overview 9 3.1.2 Water Sector Overview 9 3.2 Regulatory and Legal Framework of Water Sector 10 3.2.1 Water Sector Reforms of 2002 10 3.2.2 Devolution in the Water Sector 11 3.3 Rationale for WSPs to Source Funds 12 4. Introduction to the Creditworthiness Index 15 4.1 Introduction to Credit Ratings 15 4.1.1 International Versus Domestic Ratings 15 4.1.2 The Benefits of Credit Ratings 16 4.2 The Creditworthiness Index 17 4.2.1 Purpose of the Creditworthiness Index 17 4.2.2 Limitations of the Creditworthiness Index 17 4.2.3 The Structure and Methodology Applied 19 4.2.4 Important Note on First Year Methodology Fix 25 vi Creditworthiness Index Report 5. Results of the Creditworthiness Index Analysis 27 5.1 Overall Results 27 5.2 Comparison with 2011 Shadow Credit Rating 30 5.3 Comparison of Creditworthiness Index with 2015 Shadow Credit Rating Analysis of 10 WSPs 32 5.4 Analysis of Key Indicators 33 5.4.1 Overview 33 5.4.2 Net Profit Margin 36 5.4.3 Operating Cost Recovery Ratio 36 5.4.4 Debtor Days 37 5.4.5 Collection Efficiency 38 5.4.6 Billing Efficiency 39 5.4.7 Non- Revenue Water 39 5.4.8 Debt Service Cover Ratio 40 5.4.9 Cash Coverage Ratio 40 5.4.10 Size Versus Rating Comparison 41 6. Conclusions 43 7. Annexure 45 7.1 Annexure A: The Ranges of Norms & Points Associated with the Different Performances 45 7.2 Annexure B: Historical Financials 47 7.3 Annexure C: Key Indicators by WSP 57 7.4 Annexure D: Comparison between Creditworthiness Index Indicators and WaterCAT 58 7.5 Annexure E: Creditworthiness Index Model Statistical Analysis 65 World Bank/WASREB vii Abbreviations AfDB African Development Bank Bn Billion CIDP County Integrated Development Plans GCR Global Credit Rating Company GIZ Deutsche Gesellschaft für Internationale Zusammenarbeit GOK Government of Kenya JICA Japan International Cooperation Agency KES Kenya Shillings KFW Kreditanstalt für Wiederaufbau KPI Key Performance Indicators KWSIP Kenya Water Sector Investment Plan MDG Millennium Development Goals MEWNR Ministry of Environment, Water and Natural Resources Mn Million NEMA National Environment Management Authority NPV Net Present Value NRW Non-Revenue Water NS No Score NWMP 2030 National Water Master Plan 2030 OBA Output Based Aid O&M Operations and Maintenance OPEX Operational Expenses SLA Service level Agreement WARIS Water Regulation Information System (WARIS) WASREB Water Services Regulatory Board WATERCAT Water Credit Assessment Tool WRMA Water Resource Management Authority WSB Water Services Board WSP Water Service Provider WSS Water Supply and Sanitation WSTF Water Services Trust Fund viii Creditworthiness Index Report 1 Executive Summary 1.1 Rationale The Kenya water supply and sanitation (WSS) sector has been on a long path In lieu of a full shadow credit of facilitating commercial lending to Water Service Providers (WSPs). A key rating, the Creditworthiness component of this effort is the evolution of rating the credit risk of WSPs for local Index provides a simplified lenders. However, the trade-off in credit rating WSPs is to provide the best credit snap-shot of the financial analysis to help lenders assess the creditworthiness of WSPs, yet have a system performance of WSPs. that is simple and affordable enough to replicate on an annual basis. To solve this trade-off, the Water Services Regulatory Board (WASREB) and the Water and Sanitation Program of the World Bank have created a The Creditworthiness Index Creditworthiness Index for the WSPs in Kenya. In lieu of performing a full is automated and calculated shadow rating analysis, which is much more thorough yet also more time- using self-reported data in the consuming and costly, the Creditworthiness Index provides a simplified snap- WASREB database. shot of the financial and operational performance of WSPs. In contrast to shadow credit ratings, which have been done on WSPs in Kenya and are based on intensive analysis of separate WSPs, the Creditworthiness Index is automated and calculated from data self-reported by WSPs into the existing WASREB database, the Water Regulation Information System (WARIS).1 The trade-off of this automation is that none of the typical qualitative analysis included in a rating assessment is captured in the Creditworthiness Index (e.g. management capacity assessments, company structure, government 1 For more information on WASREB data collection via WARIS, see http://www.wasreb.go.ke/ regulatory-tools/reporting-guidelines World Bank/WASREB 1 support, etc.). However, when compared to recent shadow ratings results of the ten most-likely-to-borrow WSPs in Kenya, the pilot Creditworthiness Index was shown to be reasonably correlated with the shadow rating results. While not a rating, the Creditworthiness Index provides lenders with an initial overview credit screening of WSPs. It is a useful tool for lenders in determining which WSPs merit further credit review for potential loans. The Creditworthiness Index, in conjunction with WASREB’s Impact Report, is designed to provide lenders a snap-shot of the financial and operational performance of WSPs across the sector and insights into sector-wide trends and their key drivers. Therefore, the Creditworthiness Index is designed to be the first stage of a lender’s credit analysis and due diligence. The Creditworthiness Index also provides WSPs with a benchmark to measure their overall creditworthiness as well as their individual financial performance against their peers. The examination of the financial and operational indicators, in comparison to the market, will assist WSPs to gauge performance and institute measures to improve business efficiency and creditworthiness. Lastly, the Creditworthiness Index provides information to the regulator to identify financial management weaknesses in specific WSPs as well as identify systemic problems in the sector. Going forward, the Creditworthiness Index results report, as seen in chapter 5, will be included in the regulator’s annual Impact Report. 1.2 Background The financial demand to achieve Water coverage stands at 53% in areas covered by Water Service Providers water supply and sanitation in Kenya. Sewerage coverage stands at 16%.2 The Government of Kenya’s access for all Kenyans by 2030 development plan, Vision 2030, targets 100% coverage by 2030. For the is substantial. The government country to reach 100% coverage, substantial investment in WSS infrastructure seeks to close the gap by is required for both rehabilitation of existing infrastructure, as well as, expansion tapping into private sector of water supply and sewer connections to unserved areas. Consequently the financing. Government of Kenya has set a policy to attract private sector financing to bridge the financing gap. Private sector financiers, however, will only invest in the sector if the Government creates an enabling environment where the risk and reward is appropriately balanced for lending and the institutions seeking commercial finances are creditworthy. In 2011, in order to help facilitate commercial lending to the sector, WASREB, in collaboration with the Water and Sanitation Program of the World Bank, facilitated shadow credit ratings of 43 WSPs. The results of this shadow 2 WASREB, Impact Report Issue No. 8, Performance Review of Kenya’s Water Services Sector 2013 – 2014. 2 Creditworthiness Index Report credit rating review were published in a report entitled “Financing Urban Water Services in Kenya: Utility Shadow Credit Ratings”. The shadow ratings report identified 13 creditworthy WSPs. The 2011 report successfully spurred initial interest in commercial lending of WSPs, lenders and donors. However, the report was not readily or continuously used by commercial lenders or WSPs and was not sustainable to produce on an annual basis. . 1.3 Creditworthiness Index Creditworthiness is not static. Ratings of the WSPs can and will change over time The Creditworthiness Index and must be updated annually with the issuance of new audited financial statements. is purely based on hard data For this reason, WASREB and the World Bank created a Creditworthiness Index submitted by the utilities as a suitable and affordable alternative to the shadow rating report. An automated and excludes qualitative index is easier and cheaper to administer and provides an indicative assessment interpretations ordinarily found in of credit risk in lieu of a full shadow rating report. a credit rating report. The Creditworthiness Index is calculated solely from operational and financial indicators based on data that is submitted annually to WASREB by the WSPs. To allow for automation of the creditworthiness analysis, the Creditworthiness Index excludes any qualitative interpretations ordinarily found in a rating report. This automated reporting and calculation will allow WASREB to incorporate the Creditworthiness Index into the annual Impact report. It is worth emphasising that the Creditworthiness Index is only an indication of potential creditworthiness. Commercial lending entities should carry out their own credit analysis for lending decisions. Qualitative parameters are not incorporated in the Creditworthiness Index. In particular, the index does not consider the following parameters: management capacity, orientation, experience and qualification; human resources attitude orientation and performance; stakeholder support and relations; governance issues; legislative and regulatory framework; and strength of the economic base. 1.4 The Purpose of the Index The purpose of the Creditworthiness Index is to combine annual financial and operational data into a snapshot metric to estimate a WSP’s creditworthiness. For ease of reference and familiarity of scale, the well-known lettered rating symbols are retained. In general, it is assumed that the Creditworthiness Index scores would translate into the respective domestic credit rating. However, qualitative factors (not included in the index) can greatly affect a borrower’s credit rating. World Bank/WASREB 3 The index results allow commercial lenders to quickly estimate the borrowing risk Figure 1: Creditworthiness Index Methodology of all WSPs; while providing WASREB and the WSPs an industry benchmark to compare against and identify specific areas (ratios) of strength and weakness. 1. WASREB annually collects operational & financial data from WSPs 1.5 Methodology The methodology used in the Creditworthiness Index is much simpler than the shadow rating approach used in the 2011 report. The data collection is not 2. Data is extracted and fed into the Creditworthiness as extensive. The data required to compute the Creditworthiness Index indicators Index programme are provided by WSPs directly into WASREB’s data management system, WARIS, and are not as extensive as the data collected in 2011. These data are then fed into the Creditworthiness Index programme to calculate the index. This process allows for automation of the index going forward. 3. The Creditworthiness Index is computed Going forward, after the initial report, the index will be included in the regulator’s annual sector Impact report, providing both an annual indication of the WSPs’ operational efficiency and creditworthiness for a given year. 4. The output is incorporated into the regulator's annual Impact report 1.6 Summary of Findings The Creditworthiness Index analysis indicates thirteen WSPs can be considered creditworthy. Fourteen of the WSPs were classified as currently not yet creditworthy but have the potential of being creditworthy with a small level of improvement. Twelve WSPs still require considerable improvement to be considered creditworthy while two were awarded a “no rating” due to lack of data to compute a reliable score and/or due to low scores (below 30). 1.7 Structure of this Report This report summarises the draft findings, observations and recommendations on the engagement, including our understanding of the creditworthiness. The report is structured as follows: Section 1: Executive Summary Section 2: Introduction and Background to the assignment Section 3: Overview of Kenyan Water Sector Section 4: Introduction to Creditworthiness Index Section 5: Results of Creditworthiness Index Analysis Section 6: Conclusions Section 7: Annexures 4 Creditworthiness Index Report 2 Evolution of Credit Assessment in the Water Sector of Kenya 2.1 Introduction The process of using benchmark credit analysis in the Kenya water sector is detailed in Figure 2. Figure 2: Evolution of Credit Rating Products in the Water Sector in Kenya World Bank/WASREB 5 African Water Utilities Regional 2.1.1 Background of Credit Ratings in the Water Comparative Utility Creditworthiness Assessment Report Sector in Africa The concept of undertaking shadow credit ratings of WSPs originated with Water and Sanitation Program of the World Bank through its Mobilising Market Finance for Water Utilities in Africa program. The main purpose of this program was to facilitate private sector financing of water supply and sanitation service provision. The first step in this evolving methodology towards determining and reporting the creditworthiness of water utilities was the development of a credit assessment questionnaire. The questionnaire was initially envisioned to be a self-administered. However, a lack of objectivity in the responses of utility management led to overly positive evaluations of credit risk. To resolve this, the questionnaire was converted into a shadow credit rating/benchmarking model. To obtain a correlation between the predictions of the shadow rating model and what a formal rating would yield, seven African utilities were subjected to both a shadow rating review and a full formal rating. The formal ratings were performed by Global Credit Rating Company (GCR) and reported in African Water Utilities Regional Comparative Utility Creditworthiness Assessment Report: Individual credit assessment reports for seven African water utilities.3 The shadow rating results proved consistently correlated with the formal ratings. African Utilities rated under the Mobilising Market Finance for Water Utilities in Africa program included: Athi Water Services Board, Kenya Nairobi City Water and Sewage Company, Kenya National Water and Sewage Corporation, Uganda Nationale de L’eau et de L’assainissement, Burkina Faso Senegalaise des Eaux, Senegal Societe Nationale Des Eaux du Senegal, Senegal Societe Nationale d’Epolotation et de Distribution des Eaux, Tunisia 2.1.2 The 2011 Shadow Credit Rating Report In 2011, WASREB and Water and Sanitation Program of the World Bank conducted shadow credit ratings of 43 selected WSPs in Kenya that led to the publishing of the “Financing Urban Water Services in Kenya: Utility Shadow Credit Ratings.”4 3 See M. Joffe, R Hoffman and M Browne, “African Water Utilities, Regional Comparative Utility Creditworthiness Assessment Report” 2006. 4 https://www.wsp.org/sites/wsp.org/files/publications/WSP-Financing-Urban-Water-Services-Shadow- Ratings-Kenya.pdf 6 Creditworthiness Index Report The shadow rating model consisted of a questionnaire with 161 questions divided Utility Shadow Rating Report into external and internal factors covering: The Latest financial information (not necessarily from the audited statements as often these were not available at the time); Face to face interviews mostly with senior management; and 81 multiple choice questions completed by the interviewer based on responses provided by the executive management of WSPs. Each section of questions was weighted as outlined in Table 1 below. The shadow rating approach had several shortcomings: The model is not suitable for self-assessment as sophisticated interpretative intelligence is required; Formal and shadow ratings employ both quantitative and qualitative assessments in evaluating past and predicting future performances. A computerised evaluation model can therefore only give an indicative shadow rating; The model lacks flexibility to adjust to circumstances that may be particular to a specific WSP; The quality of financial information should be strengthenedThe model was not synchronised with the WASREB Impact report resulting in duplication of data collection; and All questions regarding national government support elicited similar responses across WSPs hence did not provide any form of differentiation. Table 1: Shadow Rating Scoring Weights Categories Weights General Background questions for sector understanding 0% Internal Considerations Financial and credit management 25% Management quality and capacity 19% Operational performance 15% Strategic planning and internal transformation 5% Human resources and utilisation of the private sector 5% Customer relations 3% External Considerations Support from government 10% Autonomy and accountability 5% External risks 3% Economic base 10% TOTAL 100% World Bank/WASREB 7 Despite the shortcomings of the 2011 shadow rating approach listed above, the report was a useful tool in eliciting initial interest in commercial financing for the sector from the government, WSPs, WASREB, donors and commercial lenders. However, credit ratings are calculated using annual financial statements, so the 2011 report quickly became out of date and obsolete. There was a need for a source of regular and up-to-date information on the creditworthiness of the WSPs for the various stakeholders. 2.1.3 The Creditworthiness Index Due to the shortcomings of the shadow rating approach, mainly the high cost and inability to replicate, WASREB and World Bank’s Water and Sanitation Program have designed an automated Creditworthiness Index system that can be easily compiled by WASREB and incorporated in the annual Impact Report. This report covers this index. 8 Creditworthiness Index Report 3 Overview of the Kenyan Water Sector 3.1 The Water Sector in Context of the Kenyan Environment 3.1.1 Socio-Economic Overview Figure 3: Water Sector Financing Gap Kenya has a liberalized economy with an estimated GDP of USD 60.9 billion as of December 2014. Real GDP growth was 5.4% in 2014 (with inflation of at an average of 2.7%). The economy’s key GDP drivers 1,400 1,288 according to estimates are agriculture (24% of total GDP), trade (11.4%), 1,200 manufacturing (11.9%), transport (10.6%), real estate (8.3%) and financial 1,000 services (5.5%). 800 600 562 477 The population of Kenya is estimated to be about 46.5 million, growing at 400 an annual rate of 2.7% and rapidly urbanizing. With the country classified 200 as a water scarce country, the growing population continues to put a 31 0 strain on the country’s WSS demands, especially in urban areas. KES Water Supply Sewerage billion 3.1.2 Water Sector Overview Required Investment Cost Available Government Budget Water coverage stands at 53% in areas covered by Water Service Providers Source: NWMP 2030 in Kenya. Sewerage coverage stands at 16%. This is against the Vision 2030 which targets of 100% coverage. For the country to reach these targets, substantial investment in WSS is required for both rehabilitation of existing infrastructure as well as expansion of water supply and sewer connections to un-served areas. World Bank/WASREB 9 Traditionally most of the financing for investments in the WSS sector has been sourced from government budgetary resources and development partners (as shown in Figure 4). Given the government’s limited budgetary resources, funding from donor sources currently provides more than half of the sector funding. With development partners shifting focus away from the WSS sector and limited government budgetary support, there are limited financial resources available to meet the increasing demand for WSS services. Figure 4: GOK & Donor Contribution to Budget 25 20 9 7 10 9 KES Billions 15 10 10 5 0 2009/10 2010/11 2011/12 2012/13 2013/14 Year Donor Funding GOK Funding Source: Annual Water Sector Report 2013/14/ WASREB 2013/14 3.2 Regulatory and Legal Framework of Water Sector 3.2.1 Water Sector Reforms of 2002 In 2002, the Kenyan government launched an ambitious program of reforms for the WSS sector, passing enabling legislation with clear roles and responsibilities of the key water institutions, increasing public spending to the sector, and pursuing other governance improvements such as the separation of water resources management from water supply services delivery. Previously service provision had been the responsibility of the Ministry in charge of Water, the National Water Conservation and Pipeline Corporation (NWCPC) as well as of a few local utilities established since 1996. After the passage of the Water Act of 2002, service provision was gradually decentralized to 117 WSPs. 10 Creditworthiness Index Report The ownership of facilities, previously owned by the central government and Key Reforms ushered by NWCPC, was transferred to eight regional Water Services Boards (WSBs). the Water Act of 2002 The WSBs are in charge of asset development and facilitate management and operation of water services. • WSPs became private entity companies that are The Water Act of 2002 also established the Water Services Regulatory autonomous, managed Board (WASREB), the sector regulator. WASREB’s mandate is to oversee the independently and run implementation of policies and strategies relating to provision of water and professionally sewerage services. WASREB’s role is to ensure that consumers are protected • WASREB became the sector’s and have access to efficient, adequate, affordable and sustainable water regulator services and sanitation. • WSPs act as agents of WSBs • WSBs have legal ownership Under the Act of 2002, WSPs were incorporated as companies under the of the water and sewerage Companies Act. This provided them with autonomy, independence and assets utilised by WSPs professional management. WSPs act as agents of the WSBs, who have • WSBs have the authority to legal ownership of the water and sewerage assets utilised by WSP’s and are regulate water tariffs set by contracted by the WSBs under a Service Provision Agreement (SPA). WSPs • Institutionalisation of financing The Water Services Trust Fund was established to institutionalise the sector water services through the investments, mainly grants, targeting the poor. establishment of the Water Services Trust Fund The 2002 reforms are acknowledged to be one of most advanced and comprehensive institutional designs and intervention packages for the water sector in Africa. The reforms are seen by most of the stakeholders as a key step to improving water supply and sanitation in the country. Since their implementation, the sector has been experienced significant progress. 3.2.2 Devolution in the Water Sector On the 27th of August 2010, Kenya adopted a new constitution. The Constitution established 47 counties, each with its own government, and devolved service provision. Among other functions, the delivery of water and sanitation services was devolved to the County Government level. This has wide-ranging implications for the water sector. Firstly, the Constitution recognizes access to safe and sufficient water and reasonable standards of sanitation as a basic human right. Secondly, the constitutional provisions firmly distribute the functions between the two levels of government with the national government being tasked with the management and protection of water resources while the County Governments are tasked with the provision of water and sanitation services and the implementation of the national government policies on natural resource including soil and water conservation. The specific roles for the Counties in the WSS are listed below. Roles of County Governments in the Water Sector a) Ensuring access to water and sanitation according to constitutional rights. World Bank/WASREB 11 b) Managing catchment and protection by implementing water catchment activities at county level. c) Protecting the interests of underserved consumers by enactment of regulations ensuring progressive achievement of the right to water d) Providing financial management through fiscal and investment planning. This is done through development of 5-year plans incorporating an investment and financing plan for the provision of water services. e) Safeguarding integrity, good governance and performance in water supply service delivery. f) Ring-fencing of income in the water sector and autonomy of management of WSPs. Counties can also participate in increasing mobilization and efficient use of funds. g) Ensuring and coordinating the participation of communities in governance. h) Cooperating and coordinating with other counties to ensuring smooth inter-county sharing of water resources. i) Contributing to research and development in the water sector. Under devolution, there arose a need for legislative alignment of the Water Act of 2002 to the new constitution. This has led to the creation of the Water Bill of 2014. The Bill is expected to advance the 2002 reforms with emphasis on the devolution of water services and sanitation. However, the Bill has not been enacted, as of the date of this publication, and there are areas that require clarity, including the asset ownership and the role and the responsibilities for the WSBs (who under the Act of 2002 are responsible for the sector investments). Constitutionally, County Governments cannot borrow without a full National Treasury guarantee. It is expressly prohibited to service loans from public money, making it impossible for County Governments to even guarantee the obligations of WSPs. Therefore, financial assistance for the sector must be drawn from development budgets of the respective counties. 3.3 Rationale for WSPs to Source Funds During the constitutional transition period, it important that investment in the sector continues in order to avoid an increasing investment backlog in that may add to future challenges. Since 2002, WSPs have been dependent on the WSBs for funding of WSS infrastructure investments. However, with limited budgets coupled with pressure to improve services, WSPs have had to look for alternative financing sources for investments in system improvements and expansion. 12 Creditworthiness Index Report The more financially sound WSPs have looked to raise commercial financing, supported by their income streams, to fund system expansion. The Creditworthiness Index is designed to help facilitate this borrowing. Commercial lending institutions in Kenya are unfamiliar with the water sector and WSPs’ ability to generate surplus cash flows and service loans. Therefore, a Creditworthiness Index will play a key role in facilitating lending to the sector by closing the information gap between financial institutions and WSPs. World Bank/WASREB 13 14 Creditworthiness Index Report 4 Introduction to the Creditworthiness Index 4.1 Introduction to Credit Ratings A credit rating is a formal opinion by an independent, specialized agency (the credit rating agency) on the long term ability, capacity, and willingness of a borrower to repay debt on a timely basis. The process of assessment is part science and part art in the sense that both historical data and qualitative analysis are used to predict trends into the future. 4.1.1 International Versus Domestic Ratings Ratings reflect an entity’s probability of defaulting on an obligation against benchmark investments that are regarded as “risk-free”. Risk-free borrowers (generally considered risk-free however very low levels of risk exist) represent the highest quality credit and are awarded an AAA (‘triple A’) rating. A lower credit rating indicates a higher probability that an entity will default on its debt payment. Figure 5 indicates the actual default rates versus credit ratings of global corporate borrowers. Many entities (sovereigns, corporates, utilities and municipalities) are rated. Moreover, specific debt instruments issued by these entities can also be rated. The ratings of an entity and one of its specific issues may differ due to the seniority and underlying security that underpins an instrument. World Bank/WASREB 15 Figure 5: Financial Corporate Default Rates for Different Ratings-1990 to 2014 45 40 Default Rate 35 30 25 20 15 10 5 0 AAA AA+ AA AA- A+ A A- BBB+ BBB BBB- BB+ BB BB- B+ B B- CCC TO C 1 Year 5 Year 10 Year Source: Fitch Ratings 2015 Forms NRSRO Annual accreditation On a global scale, sovereign ratings use the most robust economies, where defaults are regarded as highly improbable, as benchmarks. Ratings of sovereigns are based on a number of macro-economic considerations such as export surpluses, foreign reserves, and the general strength of the economy. Examples of AAA rated economies are Singapore, Germany, and New Zealand. Most emerging market economies, due to their higher risks, have lower credit ratings. Kenya, for example, has an international rating of B+. Domestic ratings use a ‘within-country’ approach by benchmarking other institutions to the government of the country. On a domestic rating scale, the government receives an AAA rating for borrowing in its local currency, even though its international rating may be far below AAA. In this assessment, the Kenyan government has a domestic rating of AAA on Kenya shilling denominated debt while the international rating is B+. In the domestic ratings context, the sovereign is largely regarded as risk-free as it can effectively print money to make a debt service payment. This implies that domestically, no entity can have a higher rating than the sovereign benchmark. Domestic ratings are normally indicated by a country suffix, such as BB+.ke for an organization or debt instrument rated in the Republic of Kenya. 4.1.2 The Benefits of Credit Ratings There are a number of benefits of having a formal credit rating. A formal credit rating: Provides an independent and objective evaluation of a WSP’s creditworthiness to banks, financial institutions, and other lenders. Has proven to be an accurate predictor of the risk of default. Allows a potential lender or investor to compare different WSPs or institutions with each other and assess their relative creditworthiness. Assists investors in pricing risk correctly, helping financial institutions decide whether to lend to the entity and calculate the cost (interest rate spread) for the borrower. Can improve the negotiating position of the WSP with its lenders, especially with regard to financing costs. 16 Creditworthiness Index Report Allows the rated entity to identify and focus on areas that reduce its creditworthiness and launch actions to address these issues. 4.2 Why a Creditworthiness Index Formal credit ratings can be relatively expensive (estimated around USD 15,000 from a regional agency and USD 40,000-60,000 from a global agency) as they depend on in-depth assessment and in-person due diligence and interviews. This cost is incurred annually by the borrower and is often not a realistic option for WSPs trying to finance smaller scale infrastructure development. This challenge gave rise to the concept of shadow ratings which are a less rigorous assessment and not publicly available. However, shadow ratings, while slightly cheaper, are still expensive relative to the average transactions in the Kenya water sector. The Creditworthiness Index offers a much simpler and affordable, though notably less sophisticated indication of a utility’s credit strength. 4.2.1 Purpose of the Creditworthiness Index The purpose of the Creditworthiness Index is to summarise the financial data of WSPs into a quick reference metric that can be easily integrated with the operational data reported in the sector Impact report. With the inclusion of the Creditworthiness Index, the Impact report will provide an annual snapshot of the performance of all WSPs’ operational and financial performance. 4.2.2 Limitations of the Creditworthiness Index Table 2: Characteristics of a Well-run Utility It must be stressed that the Creditworthiness Index is not a rating but an Characteristics Sample KPIs automated objective perspective of the financial creditworthiness of a WSP based purely on financial and operational data provided by the WSP. Data Effective • Quality of Water • Quantity of Water integrity is not guaranteed as only limited data verification (via random sampling after the rating process is concluded) is undertaken as part of data validation Equitable • % of population served by WASREB. • Diversity of Board Sustainable • % O&M coverage Furthermore, no qualitative parameters are incorporated in the Creditworthiness • % grant dependency Index. In particular, the creditworthiness does not consider or incorporate assessment of: Efficient • Staff per 1000 Management capacity, orientation, experience and qualification; connections • Non-Revenue Water Human resources attitude, orientation and performance; Stakeholder support and relations; Transparent • Customer Satisfaction Governance issues; • Frequency, quality and timeliness of financial Legislative and regulatory framework; and reporting Strength of the economic base. Replicable • Documentation of Commercial lenders will need to supplement the factual information contained processes, procedures in the Creditworthiness Index report with their own assessment of the non- Source: Richard Franceys, Managing and Financing World Water and Wastewater World Bank/WASREB 17 financial and operational components of risk. In particular, commercial lenders should take into account the endemic risks in the water sector before making a decision to lend to a WSP rated as credit worthy by the Index, including5: Capacity and Support: Strength, commitment and attitude of the WSPs’ board of directors and executive management. Sustainability: Capital investments for resource development is generally not recovered by the WSPs, nor are provisions made for capital replacement investments (depreciation). Accounts Receivable: WSPs traditionally have difficulties in collecting from public institutions (schools, hospitals, parastatals, County and National Government bodies) and as such public institutions account for a large proportion of WSPs’ receivables. However a denial in service to these institutions may lead to public health hazards and poor public relations. Ring-Fencing: The Water Act of 2002 provides for the ring-fencing of revenues generated by WSPs. This principle is also adhered to in the yet-to-be passed Water Bill of 2014. Failure to uphold this principle poses a risk to the continued commercial viability of a WSP. Constitutional Evolution: Following the promulgation of the new Constitution of Kenya in 2010, the responsibility of WSS services provision shifted to the County Governments. The current governing Act (Water Act of 2002) does not incorporate the devolved county structure and a new Water Bill 2014 aligning the Act to the Constitution is yet to be passed. This has created a lack of clarity with respect the Qualitative components specific roles of the water sector players. not considered in creditworthiness index: Cost Reflective Tariffs: Water affordability has to be balanced against the need to be cost reflective to ensure the WSPs’ operations are Management capacity sustainable and affordable. Tariffs are not regularly updated and are not Human resources always sufficient to cover costs. Stakeholder support Governance issues Government Support: It is currently unclear how Government and Legislative & regulatory donor grant support will be channelled to the WSPs and County framework governments. However, the right to water is promised to all in the Strength of the economic constitution placing responsibility on political decision makers to ensure base that the sector is sufficiently funded. Political Interference: Being publicly owned institutions, WSPs can face pressure from political representatives to keep tariffs at unsustainably low levels or fund non-viable projects. Management of the firm can also be subject to political interference. 5 For more information on lender guidance for the water sector see “Lender’s Manual for Commercial Financing of the Water and Sanitation Sector of Kenya” at www.wasreb.go.ke/publications 18 Creditworthiness Index Report Impact of Increased Coverage: As WSPs increase coverage, they often start providing services to less commercially viable areas, leading to lower levels of system utilisation (sometimes not even covering the costs). Willingness to Pay: Willingness to pay is not currently a big problem in Kenya. However, the introduction of higher tariffs in order to adjust to cost reflective levels coupled with extending coverage to poorer low consumption areas may put pressure on the consumers’ ability and willingness to pay. Legal and Regulatory Institutional Environment: Currently, WSPs can legally borrow provided they receive appropriate approvals from their Boards of Directors, their respective WSBs and provided that loan repayment is not met through public money. Currently tariffs are not included in the definition of public money; however, the legal status of these funds in the new Water Act is not known. Various roles are expected to be further defined once the 2014 Water Bill is enacted. Guidance manuals covering the roles and obligations involved in commercial financing of Kenya WSPs are available for lenders, utilities and County governments. These manuals can be downloaded from the regulator’s website (http://wasreb.go.ke/publications). 4.2.3 The Structure and Methodology Applied Figure 6: Methodology of Creditworthiness Index The Creditworthiness Index methodology used to calculate the individual ratings was adjusted from the initial shadow rating methodology previously 1. Wasreb annually collects used in the 2011 report. The Creditworthiness Index is simpler than the shadow operational & financial rating approach as the data collection is not as extensive. The Creditworthiness data from WSPs Index relies solely on data from the financial statements and operating statistics as reported by the WSPs in WASREBs reporting database, WARIS. Qualitative inputs cannot be automated and are therefore not included in the 2. Data is extracted and fed Creditworthiness Index results. into the Creditworthiness Index programme The index is calculated from 23 weighted indicators that are based on the initial objective indicators used in the shadow rating report, but tailored from consultations with local commercial lenders and the regulator. The approach 3. The Creditworthiness used in the shadow rating report was in turn based on the methodologies used Index is computed by GCR when performing the 7 formal ratings published in “African Water Utilities Regional Comparative Utility Creditworthiness Assessment Report: Individual credit assessment reports for seven African water utilities” (see section 2.1.1). GCR is a credit rating agency registered by the Financial Services Board of 4. The output is South Africa and licensed by the Capital Markets Authority of Kenya. incorporated into the regulator’s annual In developing and designing the index, the key challenge was not only selecting Impact report the specific and critical indicators necessary to estimate the creditworthiness of a WSP, but also to find indicators that would be readily and consistently World Bank/WASREB 19 available from the financial statements and operating data as reported by the WSPs in WASREB’s WARIS database. Table 3 below lists the indicators and weightings used in the index calculation. In consultation with local lenders, ranges of norms were established for each indicator, with scores of 0-4 allocated to each norm in order to align the rating with the Kenya business credit risk universe. The Creditworthiness Index result is therefore an aggregation of the weighted scoring with a maximum score of 100. A score of 85-100 would depict a highest credit quality in the Kenya business market. Table 4 provides a summary of the ranges and the indicative equivalent credit ratings. Table 3: Creditworthiness Indicators Indicator Definition Reason for Weighting Ranges and Scoring of Indicators inclusion in Index Technical indicators Poverty Rate County poverty rates Indicates the strength of 3% are derived by dividing the economic base of the the total number of poor WSP’s service coverage 4 3 2 1 0 people in each county in area. 0-20 20-40 40-60 60-80 80-100 by the total population in each county Sanitation Coverage Number of people with Indicates size of future 1% access to Sanitation challenges Services/ Population of 4 3 2 1 0 area 100 90-100 80-90 70-80 <70 Water Coverage Number of people served Indicates size of future 1% with Water Supply challenges Services/ Population of 4 3 2 1 0 area 100 90-100 80-90 70-80 <70 Non-Revenue Water Total Volume of Water Efficiency and credit 5% Lost from Commercial quality 4 3 2 1 0 and Physical Losses as a proportion of Water <20 20-30 30-40 40-50 >50 Produced Staff /1000 Number of Staff Efficiency 3% Connection Members divided by the 4 3 2 1 0 total number of 1000 <5 6 7 8 >8 Connections Financial Indicators Revenue Indicators Total Revenue Total revenue from water Indicates size of turnover ni & sewerage sales, other N/A income Revenue The scoring of this Indicates the degree of 6% Diversification indicator was done as the customer concentration difference between the % and the ability of the 4 3 2 1 0 residential revenue and % WSP to cross-subsidize. institutional <10% 10-30% 30-50% 50-70% >70% 20 Creditworthiness Index Report Indicator Definition Reason for Weighting Ranges and Scoring of Indicators inclusion in Index Average Tariff This indicator was scored Indicates whether the 8% Differential as the difference between utility is charging cost 4 3 2 1 0 Average tariff per cubic reflective tariffs >50% 35-50% 20-35% 5-20% <5% metre and Production cost per cubic metre. Cost Indicators Total OPEX Total Operational & Indicates size of turnover ni N/A Maintenance Expenditure Maintenance Costs Total Maintenance Costs Indicates whether the 3% /OPEX divided by total operations utility spends sufficiently and maintenance on maintaining 4 3 2 1 0 expenditure infrastructure. >8% 6-8% 6-4% 0-4% 0% Electricity Costs / Total Electricity Costs Indicates whether utility 2% OPEX divided by total operations is susceptible to changes 4 3 2 1 0 and maintenance in energy costs expenditure <10% 10-15% 15-20% 20-25% >25% Employee Costs / The employee Costs An indicator of efficiency 2% OPEX (inclusive of salary, pension and other employee 4 3 2 1 0 related benefits) as a % of Total OPEX <25% 25-30% 30-35% 35-40% >40% Cost Recovery Indicators O&M Coverage Total revenue from water Creditworthiness 4% and sewerage sales divided by total operations 4 3 2 1 0 and maintenance expenditure >130% 120-130% 110-120% 100-110% <100% EBITDA/Revenue Earnings Before Interest Credit quality 5% Tax, Depreciation & Amortization divided by 4 3 2 1 0 Revenue >25% 20-25% 15-20% 10-15% <10% Liquidity & Solvency Indicators Cash Reserves Cash reserves as % of Liquidity indicator 5% annual operating income 4 3 2 1 0 >25% 20-25% 15-20% 10-15% <10% Liquidity Ratio Liquidity ratio: Cash & Liquidity indicator 4% Near Cash Reserves/ 4 3 2 1 0 Current Liabilities >25% 20-25% 15-20% 10-15% <10% Debt Service Cash Flow Available Determines the debt 5% Coverage Ratio for Debt Service / Total service ability for a utility 4 3 2 1 0 Debt Service (Interest + Principal Repayments). >1.8 1.6-1.8 1.4-1.6 1.2-1.4 <1.2 World Bank/WASREB 21 Indicator Definition Reason for Weighting Ranges and Scoring of Indicators inclusion in Index Grant Dependency The proportion of OPEX An indicator of a utility’s 3% financed by income from ability to cater for its 4 3 2 1 0 Grants costs and remain solvent without government 0% 0-10% 10-15% 15-20% >20 assistance. Debt/Cash Available Total Debt/ Cash flow Determines utility’s ability 10% for Debt Service available to service debt to service debt payments (Net Operating 4 3 2 1 0 Cash flow + Interest <0.9 0.9-1.7 1.7-3.3. 3.3-6.3 >6.3 Repayments) Debt to Equity Total Debt/Total Equity Solvency 5% 4 3 2 1 0 <20% 20-25% 25-30% 30-35% >35% Debtor Days Average number of days Cash flow resilience. 5% it takes WSP to collect Measures the utility’s monies billed. ability to convert revenue into cash 4 3 2 1 0 Net billed amount <45 45-60 60-90 90-120 >120 outstanding/ Total annual Days Days Days Days Days operating revenues excluding grants and transfers *365 Reduction in Debtor % Change in debtor days Indicative of 5% Days over the last financial year. improvements/ deterioration in debtor (Debtor Days in Current days to eliminate legacy 4 3 2 1 0 Financial Year Less Debtor debt >25% 20-25% 15-20% 10-15% <10% Days in previous Financial Year)/Debtor Days in Current Financial Year Bad Debt Provision Cash provision for bad An indicator of credit 5% and doubtful debt / quality as it shows the 4 3 2 1 0 Consumer bad debt [ degree of management Number of days before the of debtor days. >60 >90 >180 >365 >5 provision made] Days Days Days Days years Billing Efficiency % Utilities ability to bill Efficiency 5% water produced/bought. 4 3 2 1 0 >95% 93-94% 90-92% 85-89% <85% Collection Efficiency Utilities ability to collect Efficiency 5% billed accounts. 4 3 2 1 0 Collection efficiency >95% 93-94% 90-92% 85-89% <85% :Utilities ability to collect billed accounts *”ni” indicates that the indicator data is collected and used to calculate other indicators but is not included in the rating calculation; N/A indicates the data information does not need a range. 22 Creditworthiness Index Report Table 10 in Annex D describes the alterations made from the WaterCAT methodologies to create the Creditworthiness Index. As the WaterCAT methodology relied heavily on qualitative analysis (management interviews, government support, staff capacity assessment, etc.), some indicators were introduced to the Creditworthiness Index to act as a proxy for qualitative analysis. Indicators, weightings and score ranges were retained from WaterCAT where applicable and available. Other indicators, weightings and score ranges were based on WaterCAT methodologies but also took into account input from local lenders’ credit views and global standards. Many of the weightings of the indicators had to be increased from WaterCAT in order to replace the weighting of qualitative indicators not applicable in the Creditworthiness Index. The rationale for allocating weights is that all indicators, although individually important, have varying importance when it comes to the overall credit assessment. See Table 3 above and Annexure A for respective weights. In addition to the weighting, there are performance ranges with different scoring points for each indicator. These were applied by awarding a score for different performance levels. The range of norms and points associated with the different performances are indicated in Annexure A. The rating rewarded for different scores, largely based on the previous ratings work in Kenya, are shown in the table below. The definitions associated with the different credit categories are as indicated in Table 4. World Bank/WASREB 23 Table 4: Creditworthiness Index Scoring Parameters Indicative Score Creditworthiness Description Level < 30 No Rating awarded Indicative of substantial to exceptionally high risk of default. Indicates that material default risk is present, but a limited margin of safety remains. Financial commitments are Lower- currently being met; however, capacity for continued 31 to 40 Creditworthy payment is vulnerable to deterioration in the business and economic environment. In a credit rating this definition is equivalent to a B rating. Indicates an elevated vulnerability to default risk, particularly in the event of adverse changes in business or economic conditions over time; however, business or 41 to 50 Low-Creditworthy financial flexibility exists which supports the servicing of financial commitments. In a credit rating this definition is equivalent to a BB rating. Indicates that expectations of default risk are currently low. Capacity for payment of financial commitments is 51 to 60 Creditworthy considered adequate but adverse business or economic conditions are more likely to impair this capacity. In a credit rating this definition is equivalent to a BBB rating. Denotes expectations of low default risk. Capacity for payment of financial commitments is considered strong. Capacity may, nevertheless, be more vulnerable to adverse 61 to 70 Creditworthy business or economic conditions than is the case for higher ratings. In a credit rating this definition is equivalent to an A rating. Denotes expectations of very low default risk. Very strong Highly capacity for payment of financial commitments. Not 71 to 85 Creditworthy significantly vulnerable to foreseeable events. In a credit rating this definition is equivalent to an AA rating. Denotes the lowest expectation of default risk. Assigned only in cases of exceptionally strong capacity for payment Very Highly > 85 of financial commitments. Highly unlikely to be adversely Creditworthy affected by foreseeable events. In a credit rating this definition is equivalent to an AAA rating. The data required for the computation of the indicators used to compute the index is extracted from WARIS. Whenever possible, the financial data inputs are based on financial statements audited by the Office of the Auditor General of Kenya. However, due to timing issues, the data utilized in populating the Creditworthiness Index is often sourced from management accounts that have been submitted to, but not yet audited by, the Auditor General for auditing. The data is validated by WASREB. Any inconsistencies are flagged by WASREB for the WSPs to review and remedy. Once audited reports are provided by the Officer of Auditor General, WSPs are required to update their records in WARIS for any changes arising. In line with the regulator’s Impact Report data verification procedure, WASREB will carry out annual in-depth verification on a sample of WSPs to ensure the data provided is up to standard. Therefore, any errors in data entry occurring in a particular year will be rectified before the annual data is reported as historical data in the following year’s report. 24 Creditworthiness Index Report 4.2.4 Important Note on First Year Methodology Fix The Creditworthiness Index was designed as a long term tool to measure objectively financial capacity of WSPs and award scores based on various indicators. The ability of a WSP to generate cash for debt service is one of the most critical indicators for creditworthiness. Unfortunately for the current year (2013-14), as this was the first year of data collection in WARIS, it was not possible to obtain accurate data on cash generated from operations as well as the amounts of cash used for debt service for many of the WSPs. To resolve this problem in the initial year (the year covered in this report), EBITDA was used as proxy for cash generated from operations, and levels of debt service were estimated for WSPs with debt based on amounts of loans in their books. This is a one-off measure. In the coming reporting cycles, cash flow information, including the data that was not collected in 2013-14, will be submitted to WASREB by the WSPs. In addition, most WSPs have nil or insignificant loans, mostly asset finance loans for vehicles where these existed. Only Nyeri, Eldoret and Kiamumbi have reported significant debt. Therefore, in this index, only three WSPs had debt service incorporated in their creditworthiness scores. All other WSPs did not have debt service indicators incorporated into their rating. Some WSPs have potential debt service obligations to their WSBs; however, these debts are not reported in the financial statements and are not included in the calculation of the Creditworthiness Index score for this year. However, during their credit analysis review, commercial lenders should investigate whether WSPs are servicing loans on infrastructure secured by their WSBs and not reported in the WSP annual financial statements. Going forward, cash flow information will be submitted into WARIS and the index will revert to using the Debt/CFADS and DSCR indicators. Moreover, as more WSPs access commercial financing, the debt indicators will become more significant in the industry and more useful. World Bank/WASREB 25 26 Creditworthiness Index Report 5 Results of the Creditworthiness Index Analysis This section of the report presents the results of the Creditworthiness Index Figure 7: Number of WSPs by Credit for the 41 best run WSPs. The section sums the Creditworthiness Index Index Scores scores and the distribution of WSPs into their respective categories of creditworthiness. Table 4 provides a description of the scores and description 18 of the creditworthiness range categories. The section also analyses the 16 15 individual key performance indicators for the WSPs under each of the key 14 parameters of the index. 12 12 Number of WSPs The analysis presented in this report is based on the financial and operational 10 8 data submitted by WSPs to WASREB for the 2013/2014 financial year. 8 Where possible, the data is reported from financial statements audited by 6 Office of the Auditor General of Kenya; however, due to timing issues, much 4 3 2 of the data is based on unaudited most recent management accounts. The 2 1 creditworthiness scores, shown in Table 5, are based on the financial and 0 technical parameters indicated in chapter 4 of this report. 71 to 85 61 to 70 51 to 60 41 to 50 31 to 40 In addition to creating the Creditworthiness Index, full shadow ratings have <30 Source: NWMP 2030 been performed for 10 of the 41 WSPs. To evaluate and verify the results of the index, the Creditworthiness Index results were compared to the shadow ratings results. Section 5.3 of this report provides a comparison of the Creditworthiness Index scores against their respective shadow credit ratings. 5.1 Overall Results The index indicates that thirteen of the WSPs have scores indicating they have high creditworthiness and could potentially receive an investment grade rating World Bank/WASREB 27 should they seek to obtain a formal rating. However, formal ratings performed The distribution of ratings scores by a rating agency may be significantly affected by non-financial and other of the 41 WSPs shows a mean operational considerations (such as quality of management, government of 47, implying that the average support, etc.), that are not considered in the Creditworthiness Index analysis. WSP is rated just below credit The WSPs with scores above 51 should able to service varying levels of debt worthy. A vast majority of WSPs and likely be considered for commercial finance (subject to further analysis are clustered within the “41-50” verifying any qualitative indicator weakness). to “51-60” range. Twenty seven WSPs are within the “30-40” and “41-50” low creditworthiness range. These are WSPs that are underperforming financially but many are relatively close to achieving high creditworthiness scores. Fourteen of the WSPs scored within the ‘41-50’ range. The higher scores indicate that these WSPs have the potential of achieving high creditworthiness with some improvement in key indicators. Thirteen WSPs still require considerable improvement in order to achieve high creditworthiness. The Index is designed to help identify these critical weaknesses. One WSP received a ‘no rating’ due to a lack of sufficient data to calculate an index. The individual WSP creditworthiness scores are indicated in Table 5. Table 5: WSPs Categorized by Creditworthiness Index Scores High Creditworthiness Low Creditworthiness WSP SCORE WSP* SCORE WSP SCORE Ruiru Juja 72 Kitui 50 Kikuyu 40 Nyeri 66 Kibwezi Makindu 50 Nairobi 40 Thika 65 Garissa 48 Nakuru 39 Kiamumbi 63 Mavoko Epza 48 Sibo 39 Meru 60 Oloolaiser 48 Kericho 39 Isiolo 58 Nyahururu 48 Nakuru Rural 38 Mathira 56 Kirinyaga 48 Tavevo 37 Nanyuki 55 Murang’a 47 Kwale 37 Kakamega Busia 55 Kisumu 45 Maralal 34 Karuri 54 Mombasa 45 Gusii 33 Embu 53 Limuru 44 Kilifi Mariakani 31 Nzoia. 53 Naivasha 44 Machakos 30 Kiambu 52 Narok 43 Tililbei No Score Malindi 43 Eldoret 40 *As indicated in section 5.1 above, WSPs that have scored within the range of 40-50 can be viewed as potentially creditworthy due to their ability to score within the high creditworthiness range if they were to undertake reforms to improve their operational and financial indicators 28 Creditworthiness Index Report Figure 8: Creditworthiness Index Scores by WSP  Rruiru Juja Water And Sewerage Co. Ltd Nyeri Water And Sewerage Company Thika Water And Sanitation Company Kiamumbi Water And Sanitation Company Meru Water And Sewerage Services Isiolo Water And Sewerage Company Mathira Water And Sewerage Company Nanyuki Water And Sewerage Company Kakamega Busia Water Services Company Karuri Water And Sanitation Company Embu Water And Sanitation Company Nzoia Water And Sanitation Company Ltd. Kiambu Water Ans Sewerage Co. Ltd Kitui Water And Sanitation Company Kibwezi Makindu Garissa Water And Sewerage Company Mavoko Epza Water And Sewerage Co. Oloolaiser Water And Sewerage Company Nyahururu Water And Sanitation Company Kirinyaga Water And Sanitation Company Murang’a Water And Sanitation Company Kisumu Water And Sewerage Company Mombasa Water Supply And Sanitation Company Limuru Water And Sewerage Co. Ltd. Naivasha Water And Sanitation Company Ltd. Narok Water And Sanitation Company Malindi Water And Sewerage Company Eldoret Water And Sanitation Company Kikuyu Water Company Ltd. Nairobi City Water And Sewerage Company Nakuru Water And Sanitation Company Ltd. Sibo Water And Sanitation Company Kericho Water And Sanitation Company Nakuru Rural Water And Sanitation Services Tavevo Water And Sewerage Company Kwale Water And Sewerage Company Maralal Water And Sanitation Company Gusii Water And Sanitation Company Kilifi Mariakani Water And Sewerage Company Machakos Water And Sewerage Ltd. - 10 20 30 40 50 60 70 80 World Bank/WASREB 29 Figure 9: Comparison between 2011 Shadow Rating & Creditworthiness Index 5.2 Comparison with 2011 Shadow Credit Rating Improved 12 There were 13 WSPs that were regarded as being creditworthy in the 2011 shadow credit rating versus 13 WSPs that are considered having high Unchanged 8 creditworthiness based on the Creditworthiness Index scores. Deteriorated 13 It is important to note that a direct comparison is not entirely valid as different New 8 parameters are being measured. In particular, the Creditworthiness Index has eliminated the more qualitative based parameters. Nevertheless, it is expected 0 5 10 15 that Creditworthiness Index scores should relatively translate into similar Number of WSPs shadow credit ratings as other financial and operational measures considered in both review similar WSPs’ efficiencies. Twelve WSPs have a higher index score than the 2011 rating, thirteen have lower scores, eight have obtained the similar ratings and seven new WSPs have been included in the current index report. One of the new WSP was not rated due to insufficient data. The elimination from the index of some of the more judgemental and discretionary indicators, as well as change in performance since 2011, is largely responsible for the movement. Table 6 below gives a comparison between the 2011 shadow ratings and a hypothetical estimated equivalent rating from the current Creditworthiness Index. Table 6: Comparison of Creditworthy WSPs under the Creditworthiness Index & 2011 Shadow Credit Rating Reviews WSP Previous 2011 Creditworthiness Creditworthiness Comment Shadow Rating Index Score Index Indicative Rating Ruiru Juja BBB 72 AA Notable improvement Nyeri A 66 A Stable Thika BBB 65 A Improvement Kiamumbi Not in 2011 report 63 A Not assessed in 2011 Meru BBB 60 BBB Stable Isiolo No Rating 58 BBB Substantial Improvement Mathira BB 56 BBB Improvement Nanyuki BBB 55 BBB Stable Kakamega No Rating 55 BBB Substantial Improvement Busia Karuri Not in 2011 report 54 BBB Not assessed in 2011 Embu BB 53 BBB Improvement 30 Creditworthiness Index Report WSP Previous 2011 Creditworthiness Creditworthiness Comment Shadow Rating Index Score Index Indicative Rating Nzoia BB 53 BBB Improvement Kiambu BB 52 BBB Improvement Kitui No Rating 50 BB Improvement Kibwezi Not in 2011 report 50 BB Not assessed in 2011 Makindu Oloolaiser BB 48 BB Stable Mavoko Epza BB 48 BB Stable Garissa Water BBB 48 BB Deterioration Kirinyaga BB 48 BB Stable Nyahururu BBB 48 BB Deterioration Murang’a BBB 47 BB Deterioration Kisumu BBB 45 BB Deterioration Mombasa No Rating 45 BB Improvement Limuru BB 44 BB Stable Naivasha Not in 2011 report 44 BB Not assessed in 2011 Narok BB 43 BB Stable Malindi BBB 43 BB Deterioration Eldoret BBB 40 B Deterioration Kikuyu BB 40 B Slight deterioration Nairobi City BBB 40 B Deterioration Nakuru BBB 39 B Deterioration Sibo No Rating 39 B Slight improvement Kericho BB 39 B Deterioration Nakuru Rural BB 38 B Deterioration Tavevo Not in 2011 report 37 B Not assessed in 2011 Kwale No Rating 37 B Improvement Maralal Not in 2011 report 34 B Not assessed in 2011 Gusii Not in 2011 report 33 B Not assessed in 2011 Kilifi Mariakani BB 31 B Deterioration Machakos No Rating 30 No Rating Stable Tililbei Not in 2011 report No Score No Rating Not rated due to insufficient data World Bank/WASREB 31 5.3 Comparison of Creditworthiness Index with 2015 Shadow Credit Rating Analysis of 10 WSPs As part of the Kenya Urban Water Utility Commercial Financing Project, shadow credit ratings were conducted on the ten WSPs most likely to seek and receive commercial financing. Despite currently pursuing a loan, the Nairobi Water and Sewerage Company (NWSC) was not selected to receive a shadow rating, due to the company’s size and complexity. However, NWSC is covered in the Creditworthiness Index. For the shadow rating evaluation, the WSPs offices and key installations such as water and sewerage treatment plants were visited in early 2015. Each WSP also provided their 5 year historical financial statements, operational and human resource data for analysis. The rating analysis was complimented by face-to-face interviews with senior management using the same methodology employed in the 2011 shadow credit rating exercise. The table below gives a comparison between the results of the shadow credit ratings and the Creditworthiness Index. The results are largely consistent between the Creditworthiness Index and the 2015 Shadow Ratings with only a few exceptions, mainly resulting from qualitative indicator analysis. The inclusion in the shadow credit rating of some of the qualitative indicators is largely responsible for any differences in ratings. Table 7: Comparison of Creditworthiness Index & 2015 Shadow Credit Rating WSP Creditworthiness Probable 2015 Shadow Comment Index Score Creditworthiness Credit Rating Index Rating Ruiru Juja 72 AA AA Same rating Nyeri 66 A A Same rating Thika A BB The qualitative interviews weighed heavily on the shadow rating resulting in a lower score. WASREB is also 65 reviewing the quality of the data submitted in WARIS as there seems to be some inconsistencies with the shadow rating data. Meru 60 BBB BBB Same rating Nanyuki 55 BBB BBB Same rating Embu 53 BBB BBB Same rating Murang’a 47 BB B Rated lower due to County government interference with the tariff setting process Eldoret 40 B BB Slight difference in rating. Utility has capable management but scores low on financial and operational indicators Kisumu 45 BB BB Same rating Malindi 43 BB B Rated lower due to lack of an MD in place for close to 3 years. Revenues are also highly dependent on volatile tourism industry. 32 Creditworthiness Index Report 5.4 Analysis of Key Indicators This section analyses how WSPs performed in key Creditworthiness Index indicators as well as assesses historical trends of indicators. The analysis is useful in helping WSPs benchmark their performance against the average WSPs within their category. As indicators determine the creditworthiness score, WSPs can use the individual indicator scores to assess their performance relative to sector averages and identify shortcomings to address to improve their financial management and creditworthiness. Note, the historical trends graphs and analysis starting in section 5.4.2 are broken into to high creditworthiness and low creditworthiness groups of WSPs as well as pre-2011 and post-2011. The pre- 2011 data is based on the 2011 Shadow Credit Report data which factored in qualitative indicators which are not included in the post- 2011 Creditworthiness Index data. In addition, a few of the WSPs have moved from creditworthy to low-creditworthy, and vice versa, under the different methodologies. 5.4.1 Overview of Indicator Table Table 8 shows a breakdown of how the WSPs have performed in each of the individual indicators. Note: the values in the table are not the ratio values but are calculated scores ranging from zero to the Maximum Score listed in the top row. Annexure E provides more explanation on these ranges and values. “No Score” (NS) score was allocated where there was no data provided. NS scores were prevalent on indicators involving debt and debt service, as the majority of WSPs have no borrowings. Therefore, the ratings for WSPs without debt cannot, and are not, scored out of the maximum 100. Indicators with ‘NS’ scores are deducted from the total score of 100. The aggregate score is then calculated from the pro rata adjusted total score to allow for comparison of WSPs. Note: Debt/EBITDA and EBITDA/ Debt Service Payments, marked with an asterisk, have been used on a one-off basis for this year’s data as proxy indicators for Debt/ Cash available for debt service (CFADS) and Debt Service Cover Ratio (DSCR) due lack of sufficient cash flow information. Going forward, the index will discard their use and revert to Debt/CFADS and DSCR. See section 4.2.4 Important Note on First Year Methodology Fix for more explanation. World Bank/WASREB 33 Table 8: Creditworthiness Index Score per WSP 34 WSP O&M Coverage Score Poverty Rate Sanitation Coverage Water Coverage NRW Staff per 1000 Connections Revenue Diversification Average tariff differential Maintenance costs as % of OPEX Electricity as % of OPEX Employee costs /Total OPEX Grant dependency for OPEX EBITDA/Revenue Liquidity reserves as % of annual OPEX Liquidity ratio EBITDA/ Debt Service Payment* Debt/EBITDA* Debt: Equity Ratio Debtor Days Reduction in debtor days Bad debt provision Billing Ratio Collection Efficiency Maximum Score > 100 3 1 1 5 3 6 8 3 2 2 4 3 5 5 4 5 10 5 5 5 5 5 5 Ruiru Juja Water And Sewerage Co. Ltd 71.9 2.3 0.5 0.0 3.8 3.0 0.0 6.0 3.0 1.5 1.0 2.0 3.0 1.3 5.0 4.0 NS NS 5.0 5.0 2.5 NS 3.8 3.8 Creditworthiness Index Report Nyeri Water And Sewerage Company 65.5 2.3 0.8 0.5 5.0 3.0 6.0 6.0 3.0 2.0 0.0 3.0 2.3 5.0 5.0 4.0 3.8 0.0 0.0 1.3 2.5 NS 5.0 5.0 Thika Water and Sanitation Company 65.3 2.3 0.0 0.8 2.5 2.3 0.0 6.0 2.3 1.5 0.0 2.0 3.0 1.3 5.0 0.0 NS NS 5.0 0.0 5.0 NS 2.5 5.0 Kiamumbi Water And Sanitation Company 63.1 2.3 0.8 0.8 2.5 0.0 0.0 8.0 3.0 1.5 2.0 3.0 3.0 5.0 5.0 0.0 0.0 5.0 3.8 5.0 NS NS 2.5 5.0 Meru Water And Sewerage Services 60.9 2.3 0.8 0.0 3.8 3.0 6.0 6.0 3.0 2.0 0.0 2.0 3.0 1.3 5.0 3.0 NS NS 5.0 0.0 0.0 NS 3.8 5.0 Isiolo Water And Sewerage Company 57.5 0.8 0.5 0.0 2.5 0.8 1.5 4.0 3.0 2.0 0.0 0.0 3.0 0.0 5.0 3.0 NS NS 5.0 2.5 5.0 NS 2.5 5.0 Mathira Water And Sewerage Company 55.9 2.3 0.0 0.0 0.0 0.0 1.5 8.0 0.0 2.0 0.0 2.0 2.3 2.5 0.0 0.0 NS NS 5.0 5.0 5.0 NS 0.0 5.0 Nanyuki Water And Sewerage Company 55.3 1.5 0.8 0.8 2.5 3.0 1.5 6.0 3.0 2.0 0.0 2.0 3.0 1.3 0.0 0.0 NS NS 5.0 0.0 0.0 NS 2.5 1.3 Kakamega Busia Water Services Company 55.0 1.5 0.5 0.3 2.5 3.0 4.5 8.0 1.5 1.5 0.0 2.0 3.0 2.5 5.0 0.0 NS NS 5.0 0.0 0.0 NS 2.5 5.0 Karuri Water And Sanitation Company 53.8 2.3 0.8 0.0 3.8 1.5 0.0 4.0 2.3 1.5 1.5 0.0 1.5 0.0 5.0 0.0 NS NS 5.0 2.5 2.5 NS 3.8 3.8 Embu Water And Sanitation Company 53.1 1.5 0.8 0.0 2.5 3.0 3.0 8.0 3.0 2.0 0.0 2.0 0.8 3.8 5.0 0.0 NS NS 5.0 0.0 0.0 NS 2.5 3.8 Nzoia Water And Sanitation Company Ltd. 53.0 1.5 0.5 0.5 2.5 1.5 6.0 4.0 1.5 1.5 0.0 0.0 3.0 0.0 2.5 0.0 NS NS 5.0 5.0 NS NS 2.5 3.8 Kiambu Water And Sewerage Co. Ltd 52.2 2.3 0.5 0.0 2.5 0.0 4.5 4.0 2.3 1.5 0.5 0.0 0.8 0.0 5.0 0.0 NS NS 5.0 5.0 5.0 NS 2.5 3.8 Kitui Water And Sanitation Company 50.6 0.8 0.0 0.0 0.0 0.0 4.5 6.0 1.5 1.5 2.0 0.0 0.8 0.0 5.0 0.0 NS NS 5.0 5.0 5.0 NS 0.0 5.0 Kibwezi Makindu 50.0 0.8 0.0 0.0 3.8 0.0 0.0 2.0 2.3 1.5 0.0 0.0 1.5 0.0 5.0 0.0 NS NS 5.0 2.5 3.8 NS 3.8 3.8 Garissa Water And Sewerage Company 48.1 1.5 0.8 0.0 1.3 0.0 6.0 6.0 3.0 1.5 1.0 0.0 3.0 0.0 5.0 4.0 NS NS 5.0 0.0 0.0 NS 1.3 5.0 Mavoko Epza Water And Sewerage Co. 48.1 1.5 0.3 0.0 1.3 0.0 3.0 6.0 3.0 2.0 1.0 1.0 3.0 0.0 5.0 0.0 NS NS 5.0 0.0 0.0 NS 1.3 3.8 Oloolaiser Water And Sewerage Company 48.1 3.0 0.0 0.0 1.3 0.0 4.5 6.0 1.5 1.5 0.5 0.0 2.3 0.0 5.0 0.0 NS NS 5.0 3.8 2.5 NS 1.3 5.0 Nyahururu Water And Sanitation Company 47.8 1.5 0.8 0.3 1.3 0.0 4.5 8.0 1.5 2.0 0.0 1.0 2.3 0.0 1.3 0.0 NS NS 5.0 1.3 0.0 NS 1.3 5.0 Kirinyaga Water And Sanitation Company 47.8 2.3 0.5 0.0 0.0 0.0 0.0 8.0 2.3 2.0 0.0 1.0 2.3 0.0 5.0 0.0 NS NS 5.0 0.0 NS NS 0.0 1.3 WSP O&M Coverage Score Poverty Rate Sanitation Coverage Water Coverage NRW Staff per 1000 Connections Revenue Diversification Average tariff differential Maintenance costs as % of OPEX Electricity as % of OPEX Employee costs /Total OPEX Grant dependency for OPEX EBITDA/Revenue Liquidity reserves as % of annual OPEX Liquidity ratio EBITDA/ Debt Service Payment* Debt/EBITDA* Debt: Equity Ratio Debtor Days Reduction in debtor days Bad debt provision Billing Ratio Collection Efficiency Maximum Score > 100 3 1 1 5 3 6 8 3 2 2 4 3 5 5 4 5 10 5 5 5 5 5 5 Murang’a Water And Sanitation Company 46.6 2.3 0.8 0.0 2.5 0.0 4.5 4.0 3.0 1.5 0.0 0.0 1.5 0.0 5.0 0.0 NS NS 5.0 1.3 0.0 NS 2.5 2.5 Kisumu Water And Sewerage Company 45.0 1.5 0.0 0.0 1.3 1.5 6.0 6.0 2.3 1.5 0.5 1.0 2.3 0.0 3.8 0.0 NS NS 5.0 0.0 0.0 NS 1.3 3.8 Limuru Water And Sewerage Co. Ltd 44.4 2.3 0.8 0.0 2.5 0.8 3.0 6.0 3.0 1.5 0.5 1.0 2.3 0.0 5.0 0.0 NS NS 5.0 0.0 0.0 NS 2.5 0.0 Naivasha Water And Sanitation Company Ltd 43.8 1.5 0.5 0.0 1.3 0.0 0.0 6.0 3.0 1.5 1.0 1.0 2.3 0.0 5.0 0.0 NS NS 5.0 0.0 0.0 NS 1.3 2.5 Narok Water And Sanitation Company 43.2 2.3 0.5 0.0 1.3 0.0 1.5 4.0 3.0 2.0 0.5 0.0 2.3 0.0 5.0 0.0 NS NS 5.0 1.3 0.0 NS 1.3 5.0 Malindi Water And Sewerage Company 42.8 0.8 0.5 0.5 2.5 0.8 0.0 4.0 0.8 2.0 0.0 1.0 2.3 0.0 5.0 0.0 NS NS 5.0 0.0 0.0 NS 2.5 5.0 Eldoret Water And Sanitation Company 40.3 1.5 0.8 0.3 2.5 3.0 3.0 6.0 2.3 2.0 0.0 1.0 3.0 0.0 5.0 0.0 NS 0.0 0.0 0.0 0.0 NS 2.5 2.5 Kikuyu Water Company Ltd 40.0 2.3 0.8 0.0 1.3 0.0 4.5 4.0 3.0 1.5 0.5 0.0 0.0 0.0 5.0 0.0 NS NS 5.0 2.5 0.0 NS 1.3 3.8 Nairobi City Water and Sewerage Company 39.7 2.3 0.3 0.3 2.5 2.3 1.5 4.0 0.0 2.0 0.0 0.0 2.3 0.0 0.0 0.0 NS NS 5.0 1.3 5.0 NS 2.5 5.0 Nakuru Water And Sanitation Company Ltd 38.7 1.5 0.8 0.8 2.5 2.3 4.5 4.0 0.8 1.5 0.5 0.0 3.0 0.0 3.8 0.0 NS NS 5.0 0.0 0.0 NS 2.5 5.0 Sibo Water And Sanitation Company 38.7 2.3 0.8 0.0 0.0 0.0 1.5 2.0 2.3 1.5 2.0 0.0 0.0 0.0 5.0 0.0 NS NS 5.0 0.0 NS NS 0.0 5.0 Kericho Water And Sanitation Company 38.5 1.5 0.0 0.0 1.3 0.0 4.5 6.0 1.5 2.0 0.0 1.0 3.0 0.0 0.0 0.0 NS NS 5.0 1.3 3.8 NS 1.3 5.0 Nakuru Rural Water and Sanitation Services 38.1 1.5 0.3 0.0 0.0 0.0 0.0 8.0 1.5 2.0 0.5 0.0 2.3 0.0 0.0 0.0 NS NS 5.0 0.0 0.0 NS 0.0 2.5 Tavevo Water And Sewerage Company 37.0 1.5 0.8 0.0 1.3 0.0 1.5 4.0 1.5 1.5 1.5 0.0 3.0 0.0 0.0 0.0 NS NS 5.0 5.0 NS NS 1.3 3.8 Kwale Water And Sewerage Company 36.9 0.8 0.3 0.0 2.5 0.0 0.0 4.0 3.0 1.5 1.0 0.0 0.8 0.0 1.3 0.0 NS NS 5.0 0.0 0.0 NS 2.5 3.8 Maralal Water And Sanitation Company 33.8 0.8 0.3 0.0 2.5 0.0 0.0 0.0 0.0 1.5 1.5 0.0 0.0 0.0 5.0 3.0 NS NS 5.0 2.5 0.0 NS 2.5 2.5 Gusii Water And Sanitation Company 33.0 1.5 0.0 0.0 1.3 0.8 0.0 4.0 0.0 1.5 1.0 0.0 0.8 0.0 5.0 0.0 NS NS 5.0 0.0 NS NS 1.3 1.3 Kilifi Mariakani Water And Sewerage Company 31.1 0.8 0.0 0.0 1.3 0.0 3.0 6.0 3.0 2.0 0.5 0.0 2.3 0.0 2.5 0.0 NS NS 5.0 0.0 0.0 NS 1.3 2.5 Machakos Water And Sewerage Ltd 30.9 1.5 0.0 0.0 0.0 0.0 0.0 8.0 2.3 1.5 0.5 0.0 2.3 0.0 0.0 0.0 NS NS 5.0 0.0 1.3 NS 0.0 3.8 World Bank/WASREB Tililbei Water And Sanitation Company NR 1.5 0.0 0.0 0.0 0.0 4.5 NS NS NS NS NS NS NS NS 0.0 NS NS NS 0.0 NS NS 0.0 3.8 * Debt/EBITDA and EBITDA/ Debt Service Payments have been used on a one-off basis as proxy indicators for Debt/ Cash available for debt service(CFADS) and Debt Service Cover Ratio (DSCR) due lack of sufficient cash- 35 flow information. Going forward, the index will discard their use and revert to Debt/CFADS and DSCR. 5.4.2 Net Profit Margin The ratio of profit or loss over the annual revenue indicates the profitability of the WSP. This is a key indicator of financial performance and ability to service debt. WSPs without surplus funds for debt service will be less creditworthy. There is a considerable difference between high scoring WSPs in the 71-80 category and the others. Figure 10: Net Profit (Loss) Margin by Credit Rating <30 1% 31 to 40 11% 41 to 50 8% 51 to 60 3% 61 to 70 14% 71 to 80 116% 0% 20% 40% 60% 80% 100% 120% 140% Average Annual Surplus/Deficit Figure 11: Average Operating Cost There has been an improvement of the performance of the high creditworthiness Recovery Ratio by Credit Index WSPs (51-85) when compared to 2011. The average surplus has increased from 2% to 45% for the WSPs ranked as creditworthy. However, it is noted that the 71-85 range consist of only 1 WSP, which has significantly outperformed others. 1.40 1.33 Low-creditworthy WSPs, on average, show a slight improvement to about 6%. 1.20 1.16 1.06 % O&Mm cover 1.00 0.98 0.80 0.92 5.4.3 Operating Cost Recovery Ratio 0.80 0.60 The annual operating cost recovery ratio measures a WSP’s ability to recover 0.40 operating costs from operating revenue. This is an important indicator 0.20 of creditworthiness as it reflects the amounts of free cash available, after - expenses, for investment and debt service. The operating surplus depicts the 71 to 85 61 to 70 51 to 60 41 to 50 31 to 40 <30 WSP’s ability to create reserves, write-off bad debts and service loans. The ratio is calculated by dividing the operating revenue by operating costs. 36 Creditworthiness Index Report There has been deterioration in this ratio from 2010, when the average for low creditworthiness WSPs was roughly 101% with the current level at about 88%. This indicates no major changes in the ability of WSPs to build reserves, undertake capital works from own resources or service debt. This ratio has remained fairly stable for high creditworthiness WSPs with 115% recorded in 2011 compared to the current of 118%. This indicates that the potential for better rated WSPs to service debt has remained strong. Figure 12: Average O&M Coverage by Credit Score 160 140 120 100 80 % 60 40 20 0 2006 2007 2008 2009 2010 2011 2012 2013 2014 Creditworthy (AA-BBB) (2011-2014) Potentially Creditworthy (BB-No Rating) (2011-2014) Creditworthy (AA-BBB) (2006-2010) Potentially Creditworthy (BB-No Rating) (AA-BBB) (2006-2010) 5.4.4 Debtor Days The debtor days measures the revenue not paid but owed to the Figure 13: Average Number of Debtor WSPs by debtors (accounts receivable) and indicates how quickly Days by Credit Index cash is being collected from billings. The longer it takes a WSP to collect accounts receivable, the greater the number of debtor days, and the less funds come into the firm. <30 557 31 to 40 75 Debtor days are a critical indicator of the cash flow position of a WSP. A WSP may be solvent in terms of having more assets than liabilities 41 to 50 142 but not in terms of its cash position if billings are not readily converted into cash. Debtor days therefore have substantial impact on the 51 to 60 196 liquidity of the WSP. 61 to 70 103 The average debtor days in 2011 assessment were 220 days. There 71 to 80 41 has been an improvement across the board with the average debtor 0 100 200 300 400 500 600 days at 188 days. The reduction in debtor days is encouraging. The Debtor Days average debtor days are however still far from the industry accepted norm of 45 to 60 days. WSPs with better index have lower debtor days. World Bank/WASREB 37 WSPs should seek to address outstanding debtors and institute provisioning for bad debts to improve their debtor days score. The Creditworthiness Index measures and gives higher scores for WSPs that have set bad debt provisioning policies. Furthermore, through the ‘reduction in the debtor days’ indicator, the Creditworthiness Index acknowledges and rewards improvements in collections and cleaning up of the debtors’ book. This emphasis is due to the high debtor days, mostly resulting from legacy debt inherited and mostly un-recoverable, affecting numerous WSPs. Efficient utilities would reduce this through collecting or writing off bad debt. Figure 14: Collection Ratio 2013/14 5.4.5 Collection Efficiency <30 89 Collection efficiency, the amount of cash collected against billing, measures 31 to 40 92 the efficiency with which a WSP converts revenue into cash. 41 to 50 94 As Figure 14 indicates, most WSPs are above the acceptable minimum 51 to 60 98 standard of 85% collection efficiency set by WASREB. It is worth noting that better rated WSPs have higher collection efficiencies. Figure 15 61 to 70 98 shows a historical trend of collection efficiency that indicates a steady 71 to 85 98 improvement across both high creditworthiness and low creditworthiness 80 85 90 95 100 105 WSPs. This could be attributable to an improvement in revenue collection % systems and WSPs more aggressively pursuing debtors. Figure 15: Average Collection Efficiency by Creditworthiness Index Rating 110 100 90 80 % 70 60 50 40 2009 2010 2011 2012 2013 2014 High Creditworthiness (2011-2014) Low Creditworthiness (2011-2014) High Creditworthiness (2011-2013) Low Creditworthiness (2006-2010) 38 Creditworthiness Index Report 5.4.6 Billing Efficiency Figure 16: Billing Ratio by Creditworthiness Index Rating for 2013/14 Billing efficiency measures the monetary amount of water billed against the monetary value of water produced. Billing efficiency directly affects the revenue <30 42% generation of the WSP. 31 to 40 57% 41 to 50 55% Figure 16 indicates a clear relationship between creditworthiness and a WSP’s billing efficiency, with higher rated WSPs having a better billing efficiency. 51 to 60 66% Figure 17 shows that billing efficiency is an area where WSPs can achieve 61 to 70 72% significant progress as there has been little improvement across both high 71 to 85 71% creditworthiness and low creditworthiness WSPs from 2009 to 2014. 0% 20% 40% 60% 80% Figure 17: Average Billing Efficiency by Creditworthiness Index Rating 80 70 60 % 50 40 2009 2010 2011 2012 2013 2014 High Creditworthiness (2011-2014) Low Creditworthiness (2011-2014) High Creditworthiness (2009-2010) Low Creditworthiness (2009-2010) 5.4.7 Non- Revenue Water NRW, water lost through administrative and commercial delivery (theft and Figure 18: Average Non-Revenue Water by Creditworthiness Index Rating physical losses), directly affects cost coverage and profitability. NRW is one of the target indicators to address operational and financial efficiency. Due to the high Impact on performance, most WSPs should aim at a <30 58% NRW ratio of 15% or less. 31 to 49 43% 41 to 50 45% NRW ratio is affected by a number of factors including the state of 51 to 60 34% infrastructure and information and monitoring systems of the WSP. For every WSP there will be a specific economic level of NRW where further 61 to 70 28% expenditure to reduce NRW is not justified in terms of the expected return. 71 to 85 24% 0% 20% 40% 60% 80% Despite general improvement, NRW in Kenya is still high. NRW reduction should remain one of the priority targets for interventions. This performance improvement is an area where the private sector can play a key role. World Bank/WASREB 39 Creditworthy WSPs have experienced greater reduction in NRW, justifying this indicator as one of the key contributing factors to the increase in operational surplus and creditworthiness. Figure 19: Average Non-Revenue Water by Creditworthiness Index Rating 60 50 40 % 30 20 10 0 2006 2007 2008 2009 2010 2011 2012 2013 2014 High Creditworthiness (2011-2014) Low Creditworthiness (2011-2014) High Creditworthiness (2006-2010) Low Creditworthiness (2006-2010) 5.4.8 Debt Service Cover Ratio Debt service coverage measures level at which a WSP can service existing debt payments. Currently, few WSPs have long term debt in their books. Figure 20: Average Liquidity Ratio by The inclusion of debt service index does therefore not have significant Creditworthiness Index Rating impact on the overall consolidated indexes. However, this indicator will become very important as more WSPs begin to borrow.   <30 9% 5.4.9 Cash Coverage Ratio 31 to 40 17% 41 to 50 24% Cash coverage ratio measures the cash available over the current liabilities. It measures the ability of a WSP to meet its cash requirements 51 to 60 45% in the short term. The better indexed WSPs show high liquidity ratios 61 to 70 116% while the less well performing WSPs have less flexibility and needs more careful cash management to be able to meet commitments. Figure 20 71 to 85 160% shows the liquidity of the companies with a sizable difference between 0% 50% 100% 150% 200% 250% high creditworthiness WSPs and the others. 40 Creditworthiness Index Report 5.4.10 Size Versus Rating Comparison Figure 21: Average Size of WSP per Creditworthiness Index Rating Comparing the average active number of connections per <30 4,911 creditworthiness rating seems to demonstrate a potential relationship between the size of a WSP with the creditworthiness. The 31-40 range 31 to 40 60,483 is noted to have a much higher average number of connections. This 41 to 50 13,363 is in part due to NWSC which is a much larger WSP by number of 51 to 60 16,672 connections than any other WSPs and distorts the data. It is also 23,045 noted that all very large utilities and many large utilities are in the 31- 61 to 70 50 range (see Table 9). 71 to 85 11,529 0 10,000 20,000 30,000 40,000 50,000 60,000 70,000 Table 9: Comparison between Size of WSP and Creditworthiness Number of Connections Number of WSPs by Size Rating Small Medium Large Very Large < 5,000 5,000 - 9,999 10,000-34,999 > =35,000 71 to 85 - - 1 61 to 70 1 - 2 - 51 to 60 - 4 5 0 41 to 50 3 4 7 - 31 to 40 1 5 3 3 <30 1 1 - - World Bank/WASREB 41 42 Creditworthiness Index Report 6 Conclusions An actual assessment of credit risk can only be achieved through proper credit rating analysis. However, the Creditworthiness Index provides the market with an affordable and sustainable overview credit screening of WSP universe. It is a useful initial tool for lenders in determining which WSPs a potential borrowers and merit further credit review. The Creditworthiness Index, in conjunction with the Impact report, provides lenders with a snap-shot of both the financial and operational performance of WSPs across the sector as well as insights into sector-wide trends and their key drivers. The Creditworthiness Index suggests that thirteen WSPs can be considered as creditworthy in the domestic market, with a reasonable expectation of being able to service debt. However further credit assessment must be done by lenders and the size of loans may be limited due to the thin margins of operating cost covers in most WSPs. The Creditworthiness Index provides WSPs a benchmark to measure overall creditworthiness as well as individual financial indicator performance against their peers. Further examination of the financial and operational indicators, in comparison to its peers, will assist WSPs to gauge performance and institute measures to improve business efficiency and creditworthiness. The Creditworthiness Index provides the regulator information to identify financial management weaknesses in specific WSPs as well identify systemic problems in the historical trends in the sector. World Bank/WASREB 43 Now that the index is established and incorporated in the annual sector reporting of the regulator, further analysis will be needed to verify the use and benefit by the three categories of stakeholders—utilities, lenders and governments/regulator. Once verified successful in Kenya, the benefits of the Creditworthiness Index should be replicable in other markets. 44 Creditworthiness Index Report 7 Annexure 7.1 Annexure A: The Ranges of Norms & Points Associated with the Different Performances Indicators weight Scoring     4 3 2 1 0 Technical Indicators             Poverty Rate 3 0-20 20-40 40-60 60-80 80-100 Sanitation coverage 1 100 90-100 80-90 70-80 <70 Water coverage 1 100 90-100 80-90 70-80 <70 NRW 5 <20% 20-30% 30-40% 40-50% >50% No of staff per 1000 connections 3 <5 6 7 8 >8 Financial Indicators Revenue Indicators Revenue Diversification 6 <10% 10-30% 30-50% 50-70% >70% Average tariff Differential 4 >50% 35-50% 20-35% 5-20% <5% Cost Indicators Production cost Differential 4 >-50% -35--50% -20--35% -5-20% >-5% Maintenance costs as % of OPEX 3 >8% 6-8% 6-4% 0-4% >0% Electricity as % of OPEX 2 <10% 10-15% 15-20% 20-25% >25% Employee costs /Total OPEX 2 <25% 25-30% 30-35% 35-40% >40% Percentage O&M coverage 4 >130% 120-130% 110-120% 100-110% <100% World Bank/WASREB 45 Indicators weight Scoring     4 3 2 1 0 Profitability Indicators EBITDA/Revenue 5 >25% 20-25% 15-20% 10-15% <10% Liquidity & Solvency Indicators Grant dependency for OPEX 3 0% 0-10% 10-15% 15-20% 20-25% Liquidity reserves as % of annual 5 >25% 20-25% 15-20% 10-15% <10% operating expenses Liquidity ratio 4 >1.6 1.5-1.6 1.4-1.3 1.2-1.3 <1 Debt Service Coverage Ratio 5 >1.8 1.5-1.8 1.3-1.5 1.2-1.3 <1.2 Debt/ Cash Flow Available for Debt 10 <0.9 0.9-1.7 1.7-3.3. 3.3-6.3 >6.3 Service Debt: Equity Ratio 5 <20% 20-30% 25-30% 30-35% >35% Debtor Days 5 <45 Days 45-60 Days 60-90 Days 90-120 >120 Day Days Reduction in debtor days over the 5 >25% 20-25% 15-20% 10-15% <10% last financial year Consumer bad debt provision% Cash 5 Provision for all Provision for all Provision for Ad hoc No provision for bad and doubtful debt debt older than debt older than all debt older limited provision 60 90 days than 365 provision days Billing Ratio 5 95% and above 93% to 94% 90% to 92% 85% to < 85% 89% Collection Efficiency 5 95% and above 93% to 94% 90% to 92% 85% to < 85% 89% 46 Creditworthiness Index Report 7.2 Annexure B: Historical Financials of Selected WSPs Eldoret Water & Sanitation Company  INCOME STATEMENT ( KES Millions) 2009 2010 2011 2012 2013 2014 Total Revenue 289 297 456 410 418 461 Total Operating And Maintenance Expenditure 245 258 373 375 418 431 EBITDA 44 39 84 35 0 31 Interest Expense 2 2 1 1 1 1 Finance Cost KFW 40 34 27 25 20 15 Depreciation 72 73 77 80 85 85 Total Expenditure 358 368 478 481 525 532 Profit/ (Loss) Before Income Tax (70) (70) (21) (71) (106) (71) Income Tax Expense/ Provision - - - - - - Profit/ (Loss) After Tax (70) (70) (21) (71) (106) (71)     BALANCE SHEET STATEMENT ( KES Millions) 2009 2010 2011 2012 2013 2014               Total non -current assets 2,169 2,153 2,130 2,244 2,232 2,187 Total current assets 309 345 408 442 448 498 Total assets 2,478 2,498 2,539 2,686 2,679 2,685 Short term borrowings (Interest and non-interest borrowing)             Other current liabilities 164 189 217 256 332 389 Long term borrowings (interest and non-interest bearing)             Other non-current liabilities             Equity and reserves 2,314 2,309 2,322 2,430 2,347 2,297 Total Equity and Liabilities 2,478 2,498 2,539 2,686 2,679 2,685     CASHFLOW STATEMENTS ( KES Millions) 2009 2010 2011 2012 2013 2014               Operating activities             Cash generated from operating activities (17) 22 (13) 9 25 12 Increase/ (Decrease ) in cash (17) 22 (13) 9 25 12 Movement in cash             At the start of the year 25 8 29 16 25 12 Increase/ (Decrease ) during the year 17 22 (13) 9 (13) (1) At the end of the year 8 29 16 25 12 11 World Bank/WASREB 47 Embu Water & Sanitation Company INCOME STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total Revenue 92 122 147 155 168 216 Total Operating And Maintenance Expenditure 66 97 128 119 134 184 Interest Expense 1 0 0 0 2 2 Depreciation 19 19 19 20 39 41 Total Expenditure 86 116 148 140 174 227 Surplus/Deficit Before Tax 5 5 (1) 15 (7) (11) Income Tax Expense/ Provision       - - - Profit/ (Loss) After Tax 5 5 (1) 15 (7) (11)     BALANCE SHEET (KES Millions) 2009 2010 2011 2012 2013 2014               Total non -current assets 139 140 152 261 310 300 Total current assets 67 84 93 98 128 169 Total assets 206 224 245 359 438 470 Short term borrowings (Interest and non-interest borrowing)             Other current liabilities 41 56 64 59 69 67 Long term borrowings (interest and non-interest bearing)             Other non-current liabilities             Equity and reserves 165 168 181 300 369 403 Total Equity and Liabilities 206 224 245 359 438 470     CASHFLOW STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Cash Generated From Operating Activities 23 20 21 26 15 4 Cash Generated From Investing Activities (18) (21) (31) (129) (88) (31) Cash Generated From Financing Activities (1) (1) 14 109 75 45 Cash And cash equivalent movements for the year 4 (1) 4 5 1 17 Cash And cash equivalent movements at the end of the year 4 3 8 13 14 31 48 Creditworthiness Index Report Kisumu Water & Sewerage Company INCOME STATEMENT 2009 2010 2011 2012 2013 2014               Total Revenue 239 286 322 386 399 441 Total operating and maintenance expenditure 225 268 306 372 382 426 Interest expense - - 1 1 5 3 Depreciation 6 6 8 7 9 8 Total expenditure 231 274 314 381 396 437 EBITDA 14 18 16 13 17 15 Margin             Surplus (Deficit) before tax for the year 8 12 8 5 3 4 Income tax expense/ provision 0 (4) (3) (2) (1) (2) Surplus (Deficit) after tax for the year 8 8 5 2 2 2     BALANCE SHEET STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total non -current assets 318 316 46 67 97 80 Total current assets 38 41 150 179 219 258 Total assets 356 356 196 246 316 338 Short term borrowings (Interest and non-interest borrowing) 0 - 2 4 7 9 Other current liabilities 204 192 120 154 191 213 Long term borrowings (interest and non-interest bearing) - - 3 0 9 8 Other non-current liabilities 144 148 71 87 106 103 Equity and reserves 8 16 1 1 3 6 Total Equity and Liabilities 356 356 196 246 316 338     CASH FLOW STATEMENT ( KES Millions) 2009 2010 2011 2012 2013 2014               Cash generated from Operating Activities 5 7 19 5 9 1 Cash generated from Investing Activities (9) (10) (19) (29) (38) 9 Cash generated from Financing Activities 4 3 13 16 25 (5) Cash and cash equivalent movements for the year (0) 0 13 (9) (4) 6 Cash and cash equivalent movements at the end of the year 1 1 15 6 3 9 World Bank/WASREB 49 Malindi Water & Sanitation Company INCOME STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total Net Revenue 128 169 226 219 171 181 Total operating and maintenance expenditure 122 152 206 248 180 181 Interest expense 0 0 0 0 0 0 Depreciation 5 5 6 6 5 5 Total expenditure 127 156 212 254 185 186 EBITDA 7 17 20 (29) (9) (0) Margin             Surplus (Deficit) before tax for the year 2 12 15 (35) (14) (5) Income tax expense/ provision 0 0 0 0 0 0 Surplus (Deficit) after tax for the year 2 12 15 (35) (14) (5)     BALANCE SHEET STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total non -current assets 115 115 120 122 122 121 Total current assets 75 103 146 158 190 233 Total assets 190 218 266 280 313 354 Short term borrowings (Interest and non-interest borrowing) 79 77 115 165 208 259 Other current liabilities 18 22 16 25 34 24 Long term borrowings (interest and non-interest bearing)             Other non-current liabilities 57 57 57 57 57 57 Equity and reserves 36 61 40 68 14 14 Total Equity and Liabilities 190 218 266 280 313 354     CASH FLOW STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Cash generated from Operating Activities 12 4 22 2 5 20 Cash generated from Investing Activities (14) (4) (12) (8) (5) (4) Cash generated from Financing Activities 13 0 2 (6) 0 0 Cash and cash equivalent movements for the year (2) 5 13 (16) (5) (21) Cash and cash equivalent movements at the end of the year 2 12 15 (35) (14) (5) 50 Creditworthiness Index Report Meru Water & Sewerage Services Trust  INCOME STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total Revenue 89 123 116 123 120 136 Total Operating And Maintenance Expenditure 101 106 91 106 108 115 Interest Expense - -         Depreciation 6 6 7 8 8 8 Total Expenditure 107 112 97 114 116 123 EBITDA (11) 17 25 17 12 21 Surplus (Deficit) before tax for the year (17) 11 18 8 4 12 Income Tax Expense/ Provision - - (6) (4) (2) (4) Surplus (Deficit) after tax for the year (17) 11 12 5 1 9     BALANCE SHEET STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total non -current assets 95 137 138 116 124 158 Total current assets 36 39 47 49 46 70 Total assets 130 175 186 165 171 228 Short term borrowings (Interest and non-interest borrowing) - - - - - - Other current liabilities 15 60 89 66 32 56 Long term borrowings (interest and non-interest bearing) - - - - - - Other non-current liabilities 44 38 12 8 7 32 Equity and reserves 71 116 84 91 131 140 Total Equity and Liabilities 130 213 186 165 171 228     CASH FLOW STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Cash generated from Operating Activities 29 25 (10) (29) 35 41 Cash generated from Investing Activities (4) (6) (14) (8) (3) (28) Cash generated from Financing Activities - 6 7 (2) 1 26 Cash and cash equivalent movements for the year 25 24 (7) (10) (2) 39 Cash and cash equivalent movements at the end of the year 59 83 65 26 58 98 World Bank/WASREB 51 Murang’a Water & Sanitation Company INCOME STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total Revenue 72 82 80 88 98 108 Total operating and maintenance expenditure 59 71 76 82 91 96 Interest expense - - - - - - Depreciation 4 5 5 6 8 12 Total expenditure 63 76 81 88 99 108 EBITDA 14 11 4 6 7 12 Surplus (Deficit) before tax for the year 0 6 (1) 1 (2) 1 Income tax expense/ provision 3   1     0 Surplus (Deficit) after tax for the year 7 6 0 1 (2) 1     BALANCE SHEET STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total non -current assets 27 38 45 67 94 12 Total current assets 25 23 21 28 38 38 Total assets 52 62 66 95 132 50 Short term borrowings (Interest and non-interest borrowing) - - - - - - Other current liabilities 12 17 12 19 27 35 Long term borrowings (interest and non-interest bearing) - - - - - - Other non-current liabilities - - - - - - Equity and reserves 41 45 54 75 105 114 Total Equity and Liabilities 52 62 66 95 132 150     CASH FLOW STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Cash generated from Operating Activities 19 12 5 7 3 16 Cash generated from Investing Activities (14) (16) (12) (28) (35) (29) Cash generated from Financing Activities 1 - 4 21 32 13 Cash and cash equivalent movements for the year 5 (4) (3) 1 (0) (0) Cash and cash equivalent movements at the end of the year 8 5 2 3 3 2 52 Creditworthiness Index Report Nanyuki Water & Sewerage Company INCOME STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total Revenue 136 131 232 243 236 250 Total operating and maintenance expenditure 100 122 171 154 236 257 Interest expense             Depreciation 9 10 12 17 18 27 Total expenditure 109 132 182 171 254 285 EBITDA 36 9 61 88 (0) (7) Surplus (Deficit) before tax for the year 27 (1) 50 71 (18) (35) Income tax expense/ provision 8   15 21 - - Surplus (Deficit) after tax for the year 19 (1) 35 50 (18) (35)     BALANCE SHEET STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total non -current assets 236 255 307 252 289 250 Total current assets 256 265 294 332 323 343 Total assets 492 520 601 584 612 593 Short term borrowings (Interest and non-interest borrowing) - - - - - - Other current liabilities 65 42 58 85 118 132 Long term borrowings (interest and non-interest bearing) - - - - - - Equity and reserves 427 478 543 499 495 460 Total Equity and Liabilities 492 520 601 584 612 593     CASH FLOW STATEMENT (KES Millions) 2009 2010 2011 2012 2013                 Cash generated from Operating Activities 28 33 20 31 (17)   Cash generated from Investing Activities (48) (19) (40) (84) (21)   Cash generated from Financing Activities 1 11 30 29 26   Cash and cash equivalent movements for the year (19) 25 9 (24) (12)   Cash and cash equivalent movements at the end of the year 2 15 37 13 1   World Bank/WASREB 53 Nyeri Water & Sewerage Company INCOME STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total Revenue 224 273 294 323 337 370 Total O&M expenditure 135 181 197 229 240 276 VAT Refunds 29 28 27 26 24 23 Interest expense 47 46 44 45 50 50 Depreciation 29 28 27 26 24 23 Total expenditure 211 255 268 299 314 349 EBITDA 89 92 97 94 96 94 Surplus (Deficit) before tax for the year 13 24 32 32 34 38 Income tax expense/ provision 4 7 - - - - Surplus (Deficit) after tax for the year 9 16 32 32 34 38     BALANCE SHEET STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total non -current assets 1,179 1,158 1,146 1,133 1,125 1,103 Total current assets 125 138 157 172 178 191 Total assets 1,304 1,296 1,302 1,305 1,303 1,294 Short term borrowings (Interest and non-interest borrowing) - - - - - - Other current liabilities 62 74 80 81 86 92 Long term borrowings (interest and non-interest bearing) 1,181 1,123 1,072 1,021 970 919 Other non-current liabilities   - - - - - Equity and reserves 61 99 150 203 247 283 Total Equity and Liabilities 1,304 1,296 1,302 1,305 1,303 1,294     CASH FLOW STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Cash generated from Operating Activities 63 102 86 79 101 95 Cash generated from Investing Activities (55) (52) (58) (54) (64) (49) Cash generated from Financing Activities 37 (37) (30) (31) (36) (46) Cash and cash equivalent movements for the year 45 14 (2) (6) 1 1 Cash and cash equivalent movements at the end of the year 18 67 65 59 60 61 54 Creditworthiness Index Report Ruiru Juja Water & Sewerage Company INCOME STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total Revenue 32 43 73 80 93 127 Total operating and maintenance expenditure 30 33 56 76 82 110 Interest expense - - - -  -  -  Depreciation 1 1 1 2 5 5 Total expenditure 31 34 57 78 86 115 EBITDA 2 10 17 4 11 17 Surplus (Deficit) before tax for the year 1 9 17 2 7 12 Income tax expense/ provision 0 3 6 1 3 5 Surplus (Deficit) after tax for the year 1 6 11 2 4 8     BALANCE SHEET STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Total non -current assets 6 8 36 22 46 43 Total current assets 8 16 15 44 44 68 Total assets 14 24 51 66 90 111 Short term borrowings (Interest and non-interest borrowing) 0 0 0 0 0 0 Other current liabilities 6 9 18 21 28 41 Long term borrowings (interest and non-interest bearing) 0 0 0 0 0 0 Other non-current liabilities 0 0 0 0 0 0 Equity and reserves 8 15 33 45 62 70 Total Equity and Liabilities 14 24 51 66 90 111     CASH FLOW STATEMENT (KES Millions) 2009 2010 2011 2012 2013 2014               Cash generated from Operating Activities 1 5 18 6 8 24 Cash generated from Investing Activities (2) (1) (2) (6) (28) (3) Cash generated from Financing Activities - - 0 7 13 0 Cash and cash equivalent movements for the year (0) 4 17 8 (7) 22 Cash and cash equivalent movements at the end of the year 2 6 23 30 23 45 World Bank/WASREB 55 Thika Water & Sewerage Company INCOME STATEMENT (KES Millions) 2010 2011 2012 2013 2014             Total Revenue 158 275 402 416 432 Expenditure           Total operating and maintenance expenditure 181 273 344 461 505 Interest expense - - - - - Depreciation 1 1 2 3 4 Total expenditure 182 274 346 463 508 EBITDA (24) 1 58 (45) (73) Surplus (Deficit) before tax for the year (24) 1 56 (48) (77) Income tax expense/ provision - - - - - Surplus (Deficit) after tax for the year (24) 1 56 (48) (77)     BALANCE SHEET STATEMENT (KES Millions) 2010 2011 2012 2013 2014             Total non -current assets 256 21 29 48 70 Total current assets 18 294 364 333 281 Total assets 274 315 393 381 351 Short term borrowings (Interest and non-interest borrowing) - - - - - Other current liabilities 75 111 119 169 215 Long term borrowings (interest and non-interest bearing) - - - - - Other non-current liabilities - 1 14 - - Equity and reserves 199 204 260 212 136 Total Equity and Liabilities 274 315 393 381 351     CASH FLOW STATEMENT (KES Millions) 2010 2011 2012 2013 2014             Cash generated from Operating Activities (204) 8 40 14 5 Cash generated from Investing Activities 205 (5) - 8 17 Cash generated from Financing Activities - - - - - Cash and cash equivalent movements for the year 1 3 29 21 22 Cash and cash equivalent movements at the end of the year 1 5 33 26 9 56 Creditworthiness Index Report 7.3 Annexure C: Key Indicators by WSP Water Service Provider Annual % O&M Debtor Collection Billing Liquidity Number of Surplus/Deficit Recovery Days Efficiency Ratio (Cash) Ratio Connections Nairobi City Water and Sewerage Company -5% 0.88 105.69 91.29 0.61 0% 522,141 Mombasa Water Supply and Sanitation Company 0% 0.92 216.93 90.81 0.52 2% 43,337 Eldoret Water And Sanitation Company -9% 1.07 348.92 99.73 0.65 12% 73,112 Nakuru Water And Sanitation Company Ltd 2% 0.96 252.16 95.14 0.68 6% 47,576 Thika Water and Sanitation Company 12% 1.13 173.71 99.81 0.68 5% 38,682 Nyeri Water And Sewerage Company 16% 1.47 108.48 100.24 0.81 273% 29,534 Meru Water And Sewerage Services 19% 1.16 679.51 116.18 0.71 151% 19,438 Nanyuki Water And Sewerage Company 7% 1.15 326.57 97.25 0.65 -30% 18,847 Embu Water And Sanitation Company 30% 1.30 189.36 80.98 0.64 52% 19,800 Murang’a Water And Sanitation Company 10% 0.99 99.54 97.36 0.65 10% 10,662 Malindi Water And Sewerage Company 3% 1.02 153.43 92.23 0.70 7% 18,594 Kisumu Water And Sewerage Company 2% 1.03 178.09 94.29 0.58 4% 42,839 Kakamega Busia Water Services Company -33% 1.24 206.46 92.70 0.61 5% 28,342 Garissa Water And Sewerage Company -11% 0.93 257.27 94.51 0.58 163% 10,752 Nyahururu Water And Sanitation Company 5% 1.05 118.02 97.25 0.51 4% 11,318 Nzoia Water And Sanitation Company Ltd. -12% 0.90 0.00 92.62 0.62 2% 30,033 Kikuyu Water Company Ltd 29% 0.83 89.90 107.94 0.54 15% 5,533 Kericho Water And Sanitation Company 0% 1.00 119.68 93.35 0.55 4% 16,361 Kirinyaga Water And Sanitation Company 14% 1.09 161.72 98.32 0.34 20% 15,284 Kilifi Mariakani Water And Sewerage Company 6% 0.92 186.27 100.04 0.56 4% 15,517 Gusii Water And Sanitation Company 1% 0.74 272.90 82.14 0.52 8% 16,393 Mathira Water And Sewerage Company 29% 1.20 0.00 85.59 0.35 1% 9,097 Tililbei Water And Sanitation Company ND ND 912.60 90.83 0.40 17% 3,883 Sibo Water And Sanitation Company -18% 0.49 162.50 93.19 0.47 5% 5,112 Tavevo Water And Sewerage Company -35% 0.77 0.00 78.43 0.57 0% 7,077 Kwale Water And Sewerage Company 15% 0.83 305.07 85.93 0.68 1% 7,178 Nakuru Rural Water and Sanitation Services -2% 0.81 632.00 95.14 0.36 0% 8,467 Ruiru Juja Water And Sewerage Co. Ltd 11% 1.16 40.98 98.42 0.71 160% 11,529 Limuru Water And Sewerage Co. Ltd 14% 1.05 156.24 86.74 0.68 58% 7,259 Mavoko Epza Water And Sewerage Co. 11% 1.06 153.93 92.99 0.54 17% 8,415 Isiolo Water And Sewerage Company -10% 0.91 89.27 105.37 0.65 144% 7,156 Kitui Water And Sanitation Company -4% 0.65 0.00 104.64 0.34 28% 7,571 Oloolaiser Water And Sewerage Company 3% 0.98 58.05 104.95 0.57 10% 6,126 Kiambu Water And Sewerage Co. Ltd 9% 0.86 0.00 105.17 0.62 22% 5,316 Machakos Water And Sewerage Ltd 1% 0.92 202.28 86.59 0.45 1% 5,939 Karuri Water And Sanitation Company 15% 0.93 79.54 92.46 0.75 18% 4,443 Kibwezi Makindu -2% 0.75 87.88 94.90 0.73 15% 4,389 Maralal Water And Sanitation Company 145% 0.31 87.36 86.52 0.60 146% 1,329 Naivasha Water And Sanitation Company Ltd 22% 1.00 392.66 83.13 0.60 5% 2,426 Narok Water And Sanitation Company 18% 0.90 90.32 89.39 0.59 17% 2,372 Kiamumbi Water And Sanitation Company ND 1.39 26.81 92.59 0.67 71% 919 World Bank/WASREB 57 7.4 Annexure D: Comparison between Creditworthiness Index Indicators and WaterCAT Table 10 describes the alterations made from the WaterCAT methodologies to create the Creditworthiness Index. As the WaterCAT methodology relied heavily on qualitative analysis (management interviews, government support, staff capacity assessment, etc.), some indicators were introduced to the Creditworthiness Index to act as a proxy for qualitative analysis. Indicators, weightings and score ranges were retained from WaterCAT where applicable and available. Other indicators, weightings and score ranges were based on WaterCAT methodologies but also took into account input from local lenders’ credit views and global standards. Many of the weightings of the indicators had to be increased from WaterCAT in order to replace the weighting of qualitative indicators not applicable in the Creditworthiness Index. Table 10: Comparison between Creditworthiness Index Indicators and WaterCAT Indicator Definition Reason for Weight Ranges of Indicator Scoring Comments inclusion Technical indicators Poverty Rate County poverty rates are Indicates the 3% This is a proxy for derived by dividing the total strength of Economic indicators number of poor people in the economic used in WaterCAT. It is each county in by the total base of the 4 3 2 1 0 subjectively used as an population in each county WSP’s service 0-20 20-40 40-60 60-80 80-100 indicator of challenges coverage area. that may be faced by the WSP in applying cost reflective tariffs and providing an indication Poverty Rate Indicator N/A of the general potential (from WaterCAT) not used in N/A economic activity in the WaterCAT area. Sanitation Number of people served Indicates size of 1% Indication of future Coverage with Sewerage Services/ future financial 4 3 2 1 0 funding required for Population of area burden increasing sanitation 100 90-100 80-90 70-80 <70 coverage. Indicators used are as a result of discussions between Sanitation Indicator used N/A consultants and Coverage (from in WaterCAT for WASREB indicators WaterCAT) informational N/A based on Kenyan purposes considerations. Water Coverage Number of people served Indicates size of 1% Indication of future with Water Supply Services/ future financial 4 3 2 1 0 funding required in Population of area burden increasing water 100 90-100 80-90 70-80 <70 coverage. Indicators used are as a result of discussions between Water Coverage Indicator used N/A consultants and (from WaterCAT) in WaterCAT for N/A WASREB indicators informational based on Kenyan purposes considerations. 58 Creditworthiness Index Report Indicator Definition Reason for Weight Ranges of Indicator Scoring Comments inclusion Non-Revenue Total Volume of Water Efficiency and 5% Indicators used are as Water Lost from Commercial credit quality; a result of discussions and Physical Losses as indicator of 4 3 2 1 0 between consultants a proportion of Water future funding and WASREB with Produced burden to 20 20-30 30-40 40-50 >50 indicators used being increase based on Kenyan efficiency and global standard considerations. Non-Revenue Total Volume of Water 4.4% Water (from Lost from Commercial WaterCAT) and Physical Losses as Similar ranges were a proportion of Water used in WaterCAT. Produced Staff /1000 Number of Staff Members Efficiency 3% This is a proxy for Connection divided by the total number WaterCAT’s staff of 1000 Connections 4 3 2 1 0 efficiency indicators i.e. Staff expenditure per <5 6 7 8 >8 1000 connections. Staff per 1000 connections was based WASREB’s Staff /1000 Indicator N/A standard derived from Connection not used in N/A globally accepted (from WaterCAT) WaterCAT norms Financial Indicators Revenue Indicators Total Revenue Total revenue from water Indicates size of For Full Correlation with & sewerage sales, other turnover info N/A WaterCAT. This income only indicator is not scored in the index. Total Revenue Total revenue from water Indicates size of For (from WaterCAT) & sewerage sales, other turnover info N/A income only Revenue The scoring of this indicator Indicates 6% This is a proxy for Diversification was done as the difference the degree financial indicators used between the % residential of customer in WaterCAT to show revenue and % institutional concentration 4 3 2 1 0 customer concentration and the ability <10% 10-30% 30-50% 50-70% >70% risk & cross- of the WSP subsidization. WaterCAT to cross- measured cross- subsidize. subsidization as the proportion of spending Revenue Indicator N/A on low income Diversification not used in households. The more (from WaterCAT) WaterCAT evenly the customer revenue is spread N/A between residential and institutional/ commercial revenue the higher the score for the indicator. Average Tariff This indicator scored as the Indicates 4% This is a proxy for Differential difference between average whether 4 3 2 1 0 financial indicators tariff per cubic metre and the utility is >50% 35-50% 20-35% 5-20% <5% used in WaterCAT to production cost per cubic charging cost show if tariff is cost metre. reflective tariffs reflective. The higher the difference between Average Tariff Indicator N/A average tariff per m3 Differential (from not used in and production cost per WaterCAT) WaterCAT N/A m3the higher the score for the indicator. World Bank/WASREB 59 Indicator Definition Reason for Weight Ranges of Indicator Scoring Comments inclusion Cost Indicators Total OPEX Total Operational & Indicates size of For For reporting only. Maintenance Expenditure turnover info N/A Not directly used only in WaterCAT or Creditworthiness Index. Total OPEX (from Total Operational & Indicates size of For WaterCAT) Maintenance Expenditure turnover info N/A only Production Cost This indicator scored as Indicates 4% This is a proxy for Differential the difference between whether utility is financial indicators production cost per cubic can sufficiently 4 3 2 1 0 used in WaterCAT to metre and the average tariff cover its costs show if tariff is cost >-50% -35--50% -20--35% -5-20% >-5% per cubic metre and. reflective. The higher the difference between production cost per m3 Production Cost Indicator N/A and the average tariff Differential (from not used in N/A per m3 the higher the WaterCAT) WaterCAT score for the indicator. Maintenance Total Maintenance Costs Indicates 3% Lower maintenance Costs /OPEX divided by total operations whether the expenditure is an and maintenance utility spends 4 3 2 1 0 indicator of likely expenditure sufficiently on deterioration in maintaining >8% 6-8% 6-4% 0-4% 0% infrastructure. This infrastructure. leads to future high rehabilitation and refurbishment costs Maintenance Total Maintenance Costs Indicates 2.7% Costs /OPEX divided by total operations whether the 8% is a commonly (from WaterCAT) and maintenance utility spends used norm in the civil expenditure sufficiently on engineering industry maintaining .WaterCAT also used infrastructure. the same approach but question was framed differently. Electricity Costs Total Electricity Costs Indicates 2% Higher electricity /OPEX divided by total operations whether utility 4 3 2 1 0 costs expose the and maintenance is susceptible utility to inflation and expenditure to changes in <10% 10-15% 15-20% 20-25% >25% forex pressure as energy costs these are passed on the end customer Electricity Costs Total Electricity Costs Indicates 1.4% by power utilities. /OPEX (from divided by total operations whether utility This is an important WaterCAT) and maintenance is susceptible risk component but expenditure to changes in can vary significantly energy costs with topographical differences. Employee Costs The employee costs ( An indicator of 2% Higher employee costs /OPEX inclusive of salary, pension efficiency indicate lower efficiency. and other employee related This indicator reflects 4 3 2 1 0 benefits) as a % of Total the target for larger OPEX <25% 25-30% 30-35% 35-40% >40% utilities as used by WASREB. WaterCAT had more differentiation based on size of the Employee Costs The employee costs ( An indicator of 3.5% utility. This was difficult /OPEX (from inclusive of salary, pension efficiency to differentiate in the WaterCAT) and other employee related index and weighting benefits) as a % of Total was lowered OPEX 60 Creditworthiness Index Report Indicator Definition Reason for Weight Ranges of Indicator Scoring Comments inclusion Profitability/ Cost Recovery Indicators Net Profit Margin Profit for the year divided Measures ni For reporting only. by Total Revenue profitability as a Not directly used N/A partial efficiency in WaterCAT or indicator. Creditworthiness Index. Net Profit Margin Profit for the year divided Measures ni (from WaterCAT) by Total Revenue profitability as a N/A partial efficiency indicator. Profit (Loss) Profit (loss) for the year Profitability and ni For reporting only. creditworthiness N/A Not directly used in WaterCAT or Profit (Loss) Profit (loss) for the year Profitability and ni Creditworthiness Index. (from WaterCAT) creditworthiness N/A Percentage O&M Total revenue from water Creditworthiness 4% The ranges stated with Coverage and sewerage sales divided a utility not generating by total operations and 4 3 2 1 0 reserves to service debt maintenance expenditure or finance extensions >130% 120-130% 110-120% 100-110% <100% awarded a 0. A norm of at least 130% was used as to highest Percentage O&M Total revenue from water Creditworthiness 4.4% benchmark. Beyond Coverage (from and sewerage sales divided this it may be indicative WaterCAT) by total operations and of tariffs being too maintenance expenditure high and generational inequity EBITDA/ Earnings Before Interest Credit quality 5% Proxy for financial 4 3 2 1 0 Revenue Tax, Depreciation & indicators used in Amortization divided by >25% 20-25% 15-20% 10-15% <10% WaterCAT to show Revenue profitability. This is also an indicator of a utility’s EBITDA/ Indicator not used in N/A N/A N/A ability to generate free Revenue WaterCAT cashflow that can be used to service debt. Liquidity & Solvency Indicators Cash Reserves Cash reserves Liquidity indicator 5% Correlated with as % of annual 4 3 2 1 0 WaterCAT. Reweighted operating due to importance in income >25% 20-25% 15-20% 10-15% <10% rating. Cash Reserves Cash reserves Liquidity indicator 3% (from WaterCAT) as % of annual operating income Liquidity Ratio Liquidity ratio: Liquidity indicator 4% This is a proxy for Cash & Near financial indicators 4 3 2 1 0 Cash Reserves/ used in WaterCAT to Current >25% 20-25% 15-20% 10-15% <10% show liquidity. This Liabilities is an indicator of the utilities ability to meet Liquidity Ratio Indicator not used in N/A N/A its immediate cash (from WaterCAT) WaterCAT requirements. World Bank/WASREB 61 Indicator Definition Reason for Weight Ranges of Indicator Scoring Comments inclusion Grant The proportion An indicator of a utility’s 3% High grant dependency Dependency of OPEX ability to cater for its costs for OPEX indicates the financed by and remain solvent without utility is unable to meet income from government assistance. 4 3 2 1 0 its revenue requirements Grants 0% 0-10% 10-15% 15-20% >25% and is unlikely to charge cost reflective tariffs. Grant The proportion An indicator of a utility’s Dependency of OPEX ability to cater for its costs. (from WaterCAT) financed by income from Grants Debt Service Cash Flow Determines the debt service 5% Correlated with Coverage Ratio Available for ability for a utility WaterCAT Debt Service / Total Debt 4 3 2 1 0 WaterCAT also used Service (Interest a figure of 1.8 as the + Principal >1.8 1.6-1.8 1.4-1.6 1.2-1.4 <1.2 highest benchmark Repayments). which is relatively Debt Service Cash Flow Determines the debt service 1.5% conservative as Coverage Ratio Available for ability for a utility the financial sector (from WaterCAT) Debt Service considers loans / Total Debt from 1.3 upwards. Service (Interest Re-weighted to + Principal compensate for removal Repayments). of qualitative WaterCAT questions. Debt/Cash Total Debt/ Determines utility’s ability to 10% An indicator of a utility’s available for Cash flow service debt ability to pay off its debt. Debt Service available to This is not much scored service debt in the Creditworthiness 4 3 2 1 0 payments (Net Index due to low Operating Cash <0.9 0.9-1.7 1.7-3.3. 3.3-6.3 >6.3 number of utilities with flow + Interest debt but will become Repayments) useful in the future as more utilities take on Debt/ Cash for Indicator not used in N/A debt. WaterCAT did not Debt Service WaterCAT consider this as debt (from WaterCAT) N/A was non-existent/ very low in 2010. Debt to Equity Total Debt/Total Solvency 5% This is a proxy for Equity financial indicators used in WaterCAT to 4 3 2 1 0 show solvency. This <20% 20-25% 25-30% 30-35% >35% is currently not critical as assets are not held on the utility’s balance Debt to Equity Indicator not used in N/A sheet but will become (from WaterCAT) WaterCAT N/A more important in future as the utility assumes more debt (and equity). 62 Creditworthiness Index Report Indicator Definition Reason for Weight Ranges of Indicator Scoring Comments inclusion Debtor Days Average Cash flow resilience. 5% Full Correlation with number of days Measures the utility’s ability WaterCAT and Industry it takes WSP to to convert revenue into standards. collect monies cash billed. Net billed 4 3 2 1 0 amount <45 45-60 60-90 90-120 >120 outstanding/ Days Days Days Days Days Total annual operating revenues excluding grants and transfers *365 Debtor Days Average Cash flow resilience. (from WaterCAT) number of days Measures the utility’s ability it takes WSP to to convert revenue into collect monies cash billed. Net billed amount 4 3 2 1 0 outstanding/ <45 45-60 60-90 90-120 >120 Total annual Days Days Days Days Days operating revenues excluding grants and transfers *365 Reduction in % Change in Indicative of improvements/ 5% This indicator is Debtor Days debtor days deterioration in debtor days used to determine over the last to eliminate legacy debt improvements in financial year. collections and cleaning up of the debtors’ book. (Debtor Days in Current It is specific to Kenya as Financial 4 3 2 1 0 it also to test whether Year Less to high debtor days are Debtor Days >25% 20-25% 15-20% 10-15% <10% due to so called legacy in previous debt inherited and Financial Year)/ mostly unrecoverable . Debtor Days Efficient utilities would in Current reduce this through Financial Year collecting or writing off bad debt. Reduction in Indicator not used in N/A N/A Debtor Days WaterCAT (from WaterCAT) Bad Debt Cash provision An indicator of credit quality 5% Correlated ranges Provision for bad and as it shows the degree of with WaterCAT with doubtful debt / management of debtor 4 3 2 1 0 adjustments to make Consumer bad days. the ranges in the debt [ Number >60 >90 >180 >365 >5 Creditworthiness Index of days before Days Days Days Days years simpler to automate. the provision Weighting reduced as made] reduction in outstanding debtors will impact on Bad Debt Cash provision An indicator of credit quality 1.5% 4 3 2 1 0 this indicator Provision (from for bad and as it shows the degree of WaterCAT) doubtful debt / management of debtor >60 90-365 >365 Adhoc No Provision Consumer bad days. Days Days Days Provision debt World Bank/WASREB 63 Indicator Definition Reason for Weight Ranges of Indicator Scoring Comments inclusion Billing Efficiency % Utilities Efficiency 5% Full Correlation of ability to 4 3 2 1 0 ranges with WaterCAT bill water produced/ >95% 93-94% 90-92% 85-89% <85% bought Billing Efficiency % Utilities Efficiency 1.5% (from WaterCAT) ability to bill water 4 3 2 1 0 produced/ >95% 93-94% 90-92% 85-89% <85% bought Collection Utilities ability Efficiency 5% Full Correlation of Efficiency to collect billed ranges with WaterCAT accounts. 4 3 2 1 0 Collection efficiency: >95% 93-94% 90-92% 85-89% <85% Utilities ability to collect billed accounts Collection Utilities ability Efficiency 3% Efficiency (from to collect billed WaterCAT) accounts. 4 3 2 1 0 Collection efficiency: >95% 93-94% 90-92% 85-89% <85% Utilities ability to collect billed accounts 64 Creditworthiness Index Report 7.5 Annexure E: Creditworthiness Index Model Statistical Analysis A regression analysis was performed to measure the interdependency between the indicator variables (see Annexure E) that create the overall Creditworthiness Index Score. The analysis segregated the variables to ensure they are independent of one another by dividing the test variables into two categories: the dependent variables: the ‘financial and credit management’ variables, which are largely based on data from utility financial statements, and the independent variables: the non-financial internal and external factors used as predictors. The independent variables selected were Poverty Rate, , Water Coverage, NRW, Staff per 1000 Connections, Revenue Diversification and Average Tariff Differential. The results of the statistical analysis on the model are shown in the table below: Table 11: Summary Output of the Statistical Test REGRESSION STATISTICS Multiple R 0.9786 R Square 0.9576 Adjusted R Square 0.9219 Standard Error 5.8495 Observations 40 ANOVA   df SS MS F Significance F Regression 6 26,250.2587 4,375.0431 127.8624 2.1265E-21 Residual 34 1,163.3713 34.2168 Total 40 27,413.6300         Coefficients Standard Error t stat p-value Intercept 0 #N/A #N/A #N/A Poverty Rate 3.5192 1.4257 2.4684 0.0188 Water Coverage 1.6184 4.0154 0.4030 0.6894 Reduction in NRW 5.7779 0.8907 6.4867 0.0000 Staff per 1000 Connections -2.6502 1.0679 -2.4817 0.0182 Revenue Diversification 0.1730 0.4264 0.4057 0.6875 Average tariff differential 1.8015 0.4044 4.4552 0.0001 World Bank/WASREB 65 The regression results show that 95.76% (R Square) of the variations in the financial scores are explained by the variations in the non-financial indicators selected. The model therefore provides a good fit with only a small variation (less than 4.3%) in financial scores that can be attributed to other factors other than the seven factors listed above. This is consistent with the F test, where critical F is estimated at 2.22, significantly less than the value for F shown in the ANOVA table above at 128. The significant F value is almost nil (2.1265E-20), consistent with good model fit. It is however important to look at the significance of the individual variable parameters effecting the financial score and hence the Creditworthiness Index. This can be deduced from the p values from the table above. At 95% confidence level, the model shows that the most significant factors are NRW (with a p value of 0.0001), tariff, number of staff and poverty rate in that order. Water coverage and revenue diversification (with p values close to 5%) are less significant and only explain about 1% of the variation (after a separate regression). This could be explained by the fact that none of the WSPs get significant revenues from other sources other than WSS charges. In addition, the WSS coverage, which is expressed by the percentage of the population served, appears to have low impact as WSP financial performance is affected more by water produced and sold irrespective of the population with access to WSS services. The statistical significance of poverty rate is largely attributable to better tariffs realisation likely occurring where the poverty index is low. The regression analysis therefore suggests that WSPs wishing to increase their Creditworthiness Index score would have best results if they sought to: 1. reduce non-revenue water (NRW) 2. increase tariffs 3. reduce number of staff and staff costs 66 Creditworthiness Index Report Water Services Regulatory Board Water and Sanitation Program NHIF Building, 5th floor Ngong Road The World Bank Group P.O. Box 4162-0010-GPO Delta Centre, Menengai Road, Upper Hill Nairobi, Kenya P.O. Box 30577 - 00100 Nairobi, Kenya Phone: 254 (0)20 273 3559/61 Email: info@wasreb.go.ke Phone: +254 20 293-6000 Web site: www.wasreb.go.ke E-mail: wspaf@worldbank.org Web sites: www.worldbank.org/water Design and Layout by Chai Baya www.wsp.org 68 Creditworthiness Index Report A publication of the Water Services Regulatory Board in collaboration with the World Bank Water Practice