Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS - FINAL REPORT
BURTON & ASSOCIATES 200 Business Park Circle, Suite 101 St. Augustine, Florida 32095 Phone (904) 247-0787 Fax (904) 241-7708 E-mail: aburnham@burtonandassociates.com Final Report June 3, 2011 City of Clearwater FY 2011 Solid Waste & Recycling Revenue Sufficiency Analysis Prepared by: BURTON & ASSOCIATES 200 Business Park Circle, Suite 101 St. Augustine, Florida 32095 Phone (904) 247-0787 Fax (904) 241-7708 E-mail: aburnham@burtonandassociates.com June 3, 2011 Mr. Earl Gloster Director Solid Waste & General Services City of Clearwater 1701 N. Hercules Ave. Clearwater, Florida 33765 Re: FY 2011 Solid Waste & Recycling Revenue Sufficiency Analysis – Final Report Dear Mr. Gloster: Burton & Associates is pleased to present this Final Report of the FY 2011 Revenue Sufficiency Analysis that we have performed for the City’s Solid Waste (Fund 424) and Recycling (Fund 426) Utility Enterprise Funds. We appreciate the fine assistance provided by you, your staff and all of the members of City staff who participated in the analysis. If you have any questions, please do not hesitate to call me at (904) 247-0787. Very truly yours, Andrew J. Burnham Senior Vice President FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS TABLE OF CONTENTS BURTON & ASSOCIATES City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report Table of Contents SECTION 1. INTRODUCTION ........................................................................................................... 1 1.1 BACKGROUND ................................................................................................................................... 1 1.2 OBJECTIVE ........................................................................................................................................ 1 1.3 STUDY PROCEDURES ......................................................................................................................... 2 SECTION 2. SOLID WASTE FUND RSA ........................................................................................... 4 2.1 ASSUMPTIONS ................................................................................................................................... 4 2.2 RESULTS ........................................................................................................................................... 6 2.3 CONCLUSIONS ................................................................................................................................... 7 2.4 RECOMMENDATIONS ......................................................................................................................... 8 SECTION 3. RECYCLING FUND RSA .............................................................................................. 9 3.1 ASSUMPTIONS ................................................................................................................................... 9 3.2 RESULTS ..........................................................................................................................................12 3.3 CONCLUSIONS ..................................................................................................................................12 3.4 RECOMMENDATIONS ........................................................................................................................13 APPENDIX A – SOLID WASTE FUND ...................................................................................................14 APPENDIX B – RECYCLING FUND ......................................................................................................36 FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS INTRODUCTION BURTON & ASSOCIATES 1 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report SECTION 1. INTRODUCTION This Report presents the results of a Solid Waste & Recycling Revenue Sufficiency Analysis (RSA) that Burton & Associates conducted for the City of Clearwater’s Solid Waste Utility System (Utility). The Utility is comprised of two enterprise funds, the Solid Waste (Solid Waste Fund) and Recycling (Recycling Fund) Enterprise Funds. 1.1 BACKGROUND The City last completed a rate study for the Utility during 2007 using the data from FY 2006. Per that study, the City adopted multi-year plans of solid waste & recycling rate adjustments necessary to generate sufficient revenues to satisfy the projected requirements of the Utility through FY 2012. As the Utility is nearing the implementation of the final approved solid waste and recycling rate adjustments for FY 2012, the City requested that Burton & Associates assist in the development of updated financial management plans for each of the enterprise funds of the Utility. 1.2 OBJECTIVE The objective of this RSA was to evaluate the sufficiency of the Utility’s FY 2012 approved solid waste and recycling rate increases1 and to develop an alternative plan of near-term and future increases that would provide adequate revenue to fund the respective Solid Waste and Recycling Fund cost requirements over a multi-year projection period. 1 The approved FY 2012 solid waste and recycling rate increases are 5.0% and 11.0% respectively. FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS INTRODUCTION BURTON & ASSOCIATES 2 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report 1.3 STUDY PROCEDURES During the conduct of this RSA, we developed separate financial management plans for the Solid Waste and Recycling Enterprise Funds of the Utility by examining the impact of key parameters (such as increases to certain expenditure components, alternative funding sources for certain capital projects, reserve targets, etc.) upon important financial indicators by use of graphical representations projected on a large viewing screen from our computer rate models. In this way, we evaluated the adequacy of the Utility’s current approved solid waste and recycling rate increases to provide sufficient revenues to fund the Utility’s cost requirements in FY 2012 and identified alternative plans of equal annual solid waste and recycling increases over the entire projection period that would meet the financial requirements, goals, and objectives of each enterprise fund of the Utility. In order to initiate the RSA, we obtained the Utility’s historical and budgeted financial information regarding the operation of the Solid Waste and Recycling Enterprise Funds. We also obtained the Utility’s multi-year capital improvement program (CIP) and counseled with City staff regarding other assumptions and policies that would affect the Utility such as required levels of reserves, interest earnings rates, escalation rates for operating costs, etc. All of this information was entered into two separate versions of our Financial Analysis and Management System (FAMS) interactive model (one for each enterprise fund). The FAMS model produces a multi-year projection of the sufficiency of each enterprise fund’s revenues to meet all of its current and projected financial requirements and determines the level of rate revenue increases necessary in each year to provide sufficient revenues to fund all of the enterprise fund’s requirements. FAMS also utilizes all available and unrestricted funds in each year of the projection period to pay for capital projects, in accordance with the cash application rules in the model as defined with City staff. This produces a detailed summary of the funding sources to be used for each project in the CIP. To the extent that current revenues and unrestricted reserves are not adequate to fund all capital projects in any year of the projection period, the FAMS model identifies a FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS INTRODUCTION BURTON & ASSOCIATES 3 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report borrowing requirement to fund those projects or portions thereof that are determined to be eligible for borrowing. In this way, the FAMS model is used to develop a borrowing program that includes the required borrowing amount by year and the resultant annual debt service obligations for each year in the projection period. FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS SOLID WASTE FUND BURTON & ASSOCIATES 4 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report SECTION 2. SOLID WASTE FUND RSA This section presents the results of the analysis and the financial management plan developed during the conduct of this RSA for the Solid Waste Enterprise Fund. The first sub-section presents a description of the base data, assumptions, and policies of the RSA. The second sub-section provides the results of the RSA, while Appendix A includes detailed financial analysis schedules supporting the financial management plan identified herein for the Solid Waste Enterprise Fund of the Utility. 2.1 ASSUMPTIONS During the conduct of the RSA, we communicated with City staff regarding various data and assumptions used in the development of the financial management plan presented herein. The base data, assumptions, and policies included in the RSA are as follows: Beginning Fund Balances - The Solid Waste Fund RSA was performed using both historical and projected information. The FY 2010 CAFR and supporting detail provided by City staff identifying individual account balances as of September 30, 2010 were used to establish the beginning FY 2011 balances for each of the various funds for this system. Base Revenues - The revenues utilized in the RSA are based upon actual results for FY 2010, and the FY 2011 Budget. Revenues consist of retail rate revenue, interest income, and other minor revenue from miscellaneous service charges. Residential, commercial, and roll-off rate revenues are based on FY 2010 actual results adjusted to reflect adopted rate increases and assumed customer growth. All other non-rate revenues were based upon the FY 2011 Budget and escalated annually based upon discussions with City staff, excluding interest earnings (which were calculated annually based upon projected average fund balances and assumed interest rates). Base Operating Expenditures - The FY 2011 revenue requirements are based upon the FY 2011 Budget and include all operating and maintenance (O&M) expenses, debt service requirements, inter-fund transfers, and minor capital outlay. After FY 2011, FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS SOLID WASTE FUND BURTON & ASSOCIATES 5 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report expenditures were projected based upon assumed cost escalation factors for individual expense categories and assumed execution levels (O&M expenses were assumed to be executed at 96% of projected amounts based upon a historical spending analysis). Payment in Lieu of Taxes Calculation - The annual calculation of the payment in lieu of taxes transfer is based upon 5.50% of the prior year’s total operating revenues in each year of the projection period. Cost Escalation – Annual cost escalation factors for the various types of operating and maintenance expenses were provided by City staff and applied in each year of the projection period beginning in FY 2012. The specific factors can be seen on Schedule 1A included in Appendix A of this report. Borrowing Assumptions – To the extent new debt would be required in any year of the projection period, the FAMS model calculates debt service based on the following terms: Table 1. Borrowing Assumptions Long-Term Financing Interim Financing Short Term Financing Term: 30 Years 20 Years 5 Years Interest Rate: 5.00% 2.00% 2.00% Debt Service Reserve: 1 Yr. of Debt Service N/A N/A Price Elasticity – A price elasticity adjustment was incorporated into the analysis for roll- off service revenue to reflect that as rates increase, roll-off services will likely decline given the competitive market for such service. The price elasticity adjustment reduces roll-off revenues by the product of the annual rate increase and the annual assumed elasticity coefficient. In each year of the projection period, the price elasticity coefficient is 0.10, which means that for every 10% increase in price, the RSA reflects a 1% reduction in roll-off service revenues. Growth – Based upon discussions with City staff, no residential or roll-off customer growth was assumed during the projection period. However, given the recent decline in the number of commercial customers due to the current economic conditions, a modest FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS SOLID WASTE FUND BURTON & ASSOCIATES 6 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report amount of commercial account growth (10 new accounts per year) is assumed in the analysis beginning in FY 2014. Minimum Working Capital – As a policy, the City currently targets a minimum Working Capital Reserve for all its enterprise funds equal to three months of operating expenses. However, due to the nature of Solid Waste Services, retaining a higher Working Capital Reserve was discussed with City Staff. Events such as a hurricane typically cause a significant amount of near-term expenditures associated with debris removal outside of normal annual expenditure levels. As a result, solid waste utility systems typically maintain a higher amount of reserves than other enterprise funds to be able to pay for these expenses. As such, the financial management plan developed for the Solid Waste Fund reflects a minimum Working Capital Reserve fund balance in an amount equal to 6- months of O&M expenses. Minimum Capital Reserves - The financial management plan in this report assumes that the Solid Waste Fund will maintain a minimum Capital Reserve fund balance equal to approximately 1 year of average capital improvement plan expenses, or $650,000. Capital Improvement Program – The capital improvement program was provided by City staff through FY 2021 and includes an estimated $15 million for the capital cost requirements associated with a new transfer station. It is important to note that a 3.04% per year compounded construction cost inflation factor (based upon the 5-year average annual increase in the Engineering News-Record Construction Cost Index) was applied to the CIP (excluding the transfer station costs) starting in FY 2013 to account for construction cost inflation in the future. The CIP utilized in this analysis is described in more detail on Schedule 3 of Appendix A. It is also important to note that no borrowing is required to fund the Solid Waste Enterprise Fund CIP during the projection period. 2.2 RESULTS The results of this analysis determined a comprehensive financial management plan and plan of annual rate adjustments that would ensure adequate revenues to fund current projections of the Solid Waste Enterprise Fund’s future cost requirements. The FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS SOLID WASTE FUND BURTON & ASSOCIATES 7 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report recommended plan is based upon the revenue and expense information, beginning balances, assumptions, and plan of finance as described in this section. Since the previous rate study, The Solid Waste Fund has seen reserves grow beyond projections primarily due to cost savings from Pinellas County dump fees. The fees were projected to increase at a rate of 3.0% - 3.5% annually, when the actual costs have gone down since FY 2006 due to a reduction in tonnage and the absence of rate increases. The dump fees represent approximately 30% of the Solid Waste Fund’s annual operating costs; therefore the significant cost savings has resulted in unrestricted reserves greater than anticipated. As a result, the Solid Waste Enterprise Fund has sufficient reserves to fully fund its capital improvement program (including a new transfer station), and maintain a higher level of liquidity to address high expenditure requirements in times of natural disasters. Moreover, the reduced expenses have improved the annual cash flow for the Solid Waste Fund such that the previously approved rate adjustment for FY 2012 is not required. In fact, based upon the RSA presented herein, the Solid Waste Fund does not require a rate increase until FY 2021. Appendix A includes several detailed schedules presenting key aspects of the financial management plan for the Solid Waste Fund, while the corresponding annual rate adjustment plan is presented in the table below: Table 2. Recommended Plan of Solid Waste Rate Revenue Increases FY 12 FY 13 FY 14 FY 15 FY 16 Effective Date 10/1/10 10/1/11 10/1/12 10/1/13 10/1/14 Solid Waste Rate Revenue Increases 0.00 % 0.00% 0.00% 0.00% 0.00% FY 17 FY 18 FY 19 FY 20 FY 21 Effective Date 10/1/10 10/1/11 10/1/12 10/1/13 10/1/14 Solid Waste Rate Revenue Increases 0.00% 0.00% 0.00% 0.00% 6.87% 2.3 CONCLUSIONS We have reached the following conclusions regarding the sufficiency of the current solid waste rates over the projection period: FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS SOLID WASTE FUND BURTON & ASSOCIATES 8 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report Based upon the assumptions and base data described herein, current Solid Waste rates will generate sufficient revenue to satisfy annual operating expenses, capital expenditures, and working capital reserve targets through FY 2020. The Solid Waste Fund has sufficient resources to fully fund its capital improvement program (including a new transfer station) while maintaining an adequate level of reserves for working capital for a solid waste utility system. 2.4 RECOMMENDATIONS Based upon the analysis presented herein and the conclusions presented in the prior subsection, we recommend the following: The City should repeal the approved 5% rate increase for FY 2012. The City should update this analysis periodically to ensure that the revenue provided by its current rates will continue to meet its ongoing financial requirements. Doing so will allow for the incorporation of updated revenue and expense information and changes in economic conditions into the financial management plan for the Solid Waste Fund so that appropriate adjustments can be made as necessary to meet its requirements during the projection period and minimize rate impacts to customers from future events which occur differently than currently projected. FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS RECYCLING FUND BURTON & ASSOCIATES 9 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report SECTION 3. RECYCLING FUND RSA This section presents the results of the analysis and the financial management plan developed during the conduct of this RSA for the Recycling Enterprise Fund. The first sub-section presents a description of the base data, assumptions, and policies of the RSA. The second sub-section provides the results of the RSA, while Appendix B includes detailed financial analysis schedules supporting the financial management plan identified herein for the Recycling Enterprise Fund of the Utility. 3.1 ASSUMPTIONS During the conduct of the RSA, we communicated with City staff regarding various data and assumptions used in the development of the financial management plan presented herein. The base data, assumptions, and policies included in the RSA are as follows: Beginning Fund Balances - The Recycling Fund RSA was performed using both historical and projected information. The FY 2010 CAFR and supporting detail provided by City staff identifying individual account balances as of September 30, 2010 were used to establish the beginning FY 2011 balances for each of the various funds for this system. Base Revenues - The revenues utilized in the RSA are based upon actual results for FY 2010, and the FY 2011 Budget. Revenues consist of retail rate revenue, interest income, revenue from the sale of recyclable material, and other minor revenue from miscellaneous service charges. Residential, multi-family, and commercial rate revenues are based on FY 2010 actual results adjusted to reflect adopted rate increases and assumed customer growth. All other non-rate revenues (excluding revenue from the sale of recyclable material) were based upon the FY 2011 Budget and escalated annually based upon discussions with City staff. Interest earnings were calculated annually based upon projected average fund balances and assumed interest rates. Annual projections of revenue from the sale of recyclable materials (starting in FY 2012) are based upon the FY 2011 Budget amounts and are assumed to remain constant FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS RECYCLING FUND BURTON & ASSOCIATES 10 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report throughout the projection period. It is important to note that these revenues are substantial and have a high degree of uncertainty due to the potential variability in the recycling market (ranging from $700,000 to $2,000,000 annually over the past four years). To the extent that the actual revenues collected from the sale of recyclable materials differ from current projections, it could have a material effect on the financial results for this enterprise fund as presented in this report. Base Operating Expenditures - The FY 2011 revenue requirements are based upon the FY 2011 Budget and include all operating and maintenance (O&M) expenses, debt service requirements, inter-fund transfers, and minor capital outlay. After FY 2011, expenditures were projected based upon assumed cost escalation factors for individual expense categories and assumed execution levels (O&M expenses were assumed to be executed at 98.5% of projected amounts based upon a historical spending analysis). Annual Transfer to the Solid Waste Fund - On an annual basis, the Recycling Fund transfers monies to the Solid Waste Fund for the cost of administrative services/provided by the Solid Waste Fund that benefit the Recycling Fund. Based upon a detailed cost of service analysis, it was determined that the annual transfer should be reduced from $256,000 in FY 2011 to approximately $229,000 in FY 2012, escalating each year thereafter based upon annual increases in cost for the Administration Department of the Solid Waste Fund. Payment in Lieu of Taxes Calculation - The annual calculation of the payment in lieu of taxes transfer is based upon 5.50% of the prior year’s total operating revenues in each year of the projection period. Cost Escalation – Annual cost escalation factors for the various types of operating and maintenance expenses were provided by City staff and applied in each year of the projection period beginning in FY 2012. The specific factors can be seen on Schedule 1A included in Appendix B of this report. Borrowing Assumptions – To the extent new debt would be required in any year of the projection period, the FAMS model calculates debt service based on the following terms: FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS RECYCLING FUND BURTON & ASSOCIATES 11 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report Table 1. Borrowing Assumptions Long-Term Financing Interim Financing Short Term Financing Term: 30 Years 20 Years 5 Years Interest Rate: 5.00% 2.00% 2.00% Debt Service Reserve: 1 Yr. of Debt Service N/A N/A Growth – Based upon discussions with City staff, no residential or multi-family customer growth was assumed during the projection period. However, given the recent decline in the number of commercial customers due to the current economic conditions, a modest amount of commercial account growth (5 new accounts per year) is assumed in the analysis beginning in FY 2014. Minimum Working Capital – As a policy, the City currently targets a minimum Working Capital Reserve for all its enterprise funds equal to three months of operating expenses. However, given the volatility of 40% of the Recycling Fund’s revenue stream (i.e. the revenue from the sale of recyclable material), a higher Working Capital Reserve was discussed with City Staff. As such, the financial management plan developed for the Recycling Fund reflects a minimum Working Capital Reserve fund balance in an amount equal to 6-months of O&M expenses. Minimum Capital Reserves - The financial management plan in this report assumes that the Recycling Fund will maintain a minimum Capital Reserve fund balance equal to approximately 1 year of average capital improvement plan expenses, or $300,000. Capital Improvement Program – The capital improvement program was provided by City staff through FY 2021. It is important to note that a 3.04% per year compounded construction cost inflation factor (based upon the 5-year average annual increase in the Engineering News-Record Construction Cost Index) was applied to the CIP starting in FY 2013 to account for construction cost inflation in the future. The CIP utilized in this analysis is described in more detail on Schedule 3 of Appendix B. FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS RECYCLING FUND BURTON & ASSOCIATES 12 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report 3.2 RESULTS The City’s Recycling Fund has observed higher reserves than previously projected due to higher than forecast revenue from the sale of recyclable material in FY 2007 and FY 2008. As such, the financial management plan developed in this RSA reflects smaller, inflationary-like rate adjustments instead of the 11.00% annual increases identified in the prior rate study. The financial management plan identified herein balances two objectives during the projection period: 1) gradually increases revenues so that they become sufficient to meet annual expenditure requirements by the end of the projection period, and 2) utilizing excess reserves down to the Working Capital Reserve target. Appendix B includes several detailed schedules presenting key aspects of the financial management plan, while the required rate adjustment plan is presented in the table below: Table 4. Recommended Plan of Recycling Rate Revenue Increases FY 12 FY 13 FY 14 FY 15 FY 16 Effective Date 10/1/10 10/1/11 10/1/12 10/1/13 10/1/14 Recycling Rate Revenue Increases 3.50 % 3.50 % 3.50 % 3.50 % 3.50 % FY 17 FY 18 FY 19 FY 20 FY 21 Effective Date 10/1/10 10/1/11 10/1/12 10/1/13 10/1/14 Recycling Rate Revenue Increases 3.50 % 3.50 % 3.50 % 3.50 % 3.50 % 3.3 CONCLUSIONS We have reached the following conclusions regarding the sufficiency of the current recycling rates over the projection period: Based upon the assumptions and base data described herein, the current recycling rates will not generate sufficient revenue to satisfy the Recycling Fund’s annual operating expenses, capital expenditures, and targeted working capital reserve targets through FY 2021. Based upon the analysis presented herein, annual inflationary-like rate revenue increases of 3.50% starting in FY 2012 will provide sufficient revenue to meet the current projection of the future cost requirements during the projection period. FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS RECYCLING FUND BURTON & ASSOCIATES 13 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report 3.4 RECOMMENDATIONS Based upon the analysis presented herein and the conclusions presented in the prior subsection, we recommend the following: The City should repeal the approved 11.00% recycling rate increase for FY 2012 and adopt 3.50% annual recycling rate adjustments from FY 2012 – FY 2016. The City should update this analysis periodically to ensure that the revenue provided by its current rates will continue to meet its ongoing financial requirements. Doing so will allow for the incorporation of updated revenue and expense information and changes in economic conditions into the financial management plan for the Recycling Fund so that appropriate adjustments can be made as necessary to meet its requirements during the projection period and minimize rate impacts to customers from future events which occur differently than currently projected. FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 14 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report Appendix A – Solid Waste Fund Supporting Schedules for the Revenue Sufficiency Analysis Schedules 1 through 5 present detailed schedules of the inputs and assumptions utilized in the RSA Schedules 1A & 1B: contain the assumptions of the analysis Schedule 2: contains the end of FY 2010 fund balances that serve as the FY 2011 beginning balances of the analysis Schedule 3: provides a listing of the CIP that was utilized in this analysis Schedule 4: contains a detailed list of all projected cash inflows from FY 2011 through FY 2021 Schedule 5: contains a detailed list of all projected cash outflows from FY 2011 through FY 2021 Schedules 6 through 9 identify the results of the financial management plan Schedule 6: contains the FAMS Control Panel that presents a summary of the financial management plan, including annual rate increases, debt service coverage ratios, total CIP spending levels, customer impacts, and fund balances Schedule 7: is the Pro Forma schedule that presents a projected income statement, debt service coverage analysis, and cash flow analysis Schedule 8: shows a summary of the funding sources utilized to pay for CIP Schedule 9: presents a fund-level cash flow reconciliation, providing the beginning balance in each year, the amount utilized for project funding or payment of debt service, interest calculations, and the end of year fund balance FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 1 - Assumptions APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 15 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 1 - Assumptions APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 16 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 2 – Beginning Balances APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 17 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 3 – Capital Improvement Plan APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 18 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 4 – Projection of Cash Inflows APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 19 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 6 – FAMS-XL Control Panel APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 20 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 6 – FAMS-XL Control Panel APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 21 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 6 – FAMS-XL Control Panel APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 22 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 6 – FAMS-XL Control Panel APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 23 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 6 – FAMS-XL Control Panel APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 24 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 6 – FAMS-XL Control Panel APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 25 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 6 – FAMS-XL Control Panel APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 26 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 6 – FAMS-XL Control Panel APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 27 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 6 – FAMS-XL Control Panel APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 28 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 6 – FAMS-XL Control Panel APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 29 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 6 – FAMS-XL Control Panel APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 30 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 7 – Forecast of Net Revenues and Debt Service Coverage APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 31 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 7 – Forecast of Net Revenues and Debt Service Coverage APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 32 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 8 – Capital Project Funding Summary APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 33 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 9 – Funding Summary by Fund APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 34 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 9 – Funding Summary by Fund APPENDIX A – SOLID WASTE FUND BURTON & ASSOCIATES 35 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 36 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report Appendix B – Recycling Fund Supporting Schedules for the Revenue Sufficiency Analysis Schedules 1 through 5 present detailed schedules of the inputs and assumptions utilized in the RSA Schedules 1A & 1B: contain the assumptions of the analysis Schedule 2: contains the end of FY 2010 fund balances that serve as the FY 2011 beginning balances of the analysis Schedule 3: provides a listing of the CIP that was utilized in this analysis Schedule 4: contains a detailed list of all projected cash inflows from FY 2011 through FY 2021 Schedule 5: contains a detailed list of all projected cash outflows from FY 2011 through FY 2021 Schedules 6 through 9 identify the results of the financial management plan Schedule 6: contains the FAMS Control Panel that presents a summary of the financial management plan, including annual rate increases, debt service coverage ratios, total CIP spending levels, customer impacts, and fund balances Schedule 7: is the Pro Forma schedule that presents a projected income statement, debt service coverage analysis, and cash flow analysis Schedule 8: shows a summary of the funding sources utilized to pay for CIP Schedule 9: presents a fund-level cash flow reconciliation, providing the beginning balance in each year, the amount utilized for project funding or payment of debt service, interest calculations, and the end of year fund balance FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 1 - Assumptions APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 37 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 1 - Assumptions APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 38 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 2 – Beginning Balances APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 39 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 3 – Capital Improvement Program APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 40 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 4 – Projection of Cash Inflows APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 41 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 5 – Projection of Cash Outflows APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 42 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 5 – Projection of Cash Outflows APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 43 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 5 – Projection of Cash Outflows APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 44 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 5 – Projection of Cash Outflows APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 45 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 5 – Projection of Cash Outflows APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 46 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 6 – FAMS-XL © Control Panel APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 47 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 7 – Forecast of Net Revenues and Debt Service Coverage APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 48 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 7 – Forecast of Net Revenues and Debt Service Coverage APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 49 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 8 – Capital Projects Funding Sources APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 50 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report FY 2011 SOLID WASTE & RECYCLING REVENUE SUFFICIENCY ANALYSIS Schedule 9 – Funding Summary by Fund APPENDIX B – RECYLING FUND BURTON & ASSOCIATES 51 City of Clearwater Utility Rates ▪ Assessments ▪ Financial Planning Final Report