1 / 29

Existing Financial and Utility Management Tools

Existing Financial and Utility Management Tools. Funding Coordination and Financial Training for Small Water Systems Stacey Isaac Berahzer January 29th, 2013 Alabama State University Montgomery, AL. Outline. Rate Setting Tools Asset Management Tools Capital Planning Tools

Sophia
Download Presentation

Existing Financial and Utility Management Tools

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Existing Financial and Utility Management Tools Funding Coordination and Financial Training for Small Water Systems Stacey Isaac Berahzer January 29th, 2013 Alabama State University Montgomery, AL

  2. Outline • Rate Setting Tools • Asset Management Tools • Capital Planning Tools • More Resources for Finding Tools

  3. Rate setting tools

  4. Water and Sewer Rates Analysis Model http://efc.unc.edu/tools/Rate_Analysis-version2.xlsx Instructions

  5. Water and Sewer Rates Analysis Model http://efc.unc.edu/tools/Rate_Analysis-version2.xlsx Data Input 1

  6. Water and Sewer Rates Analysis Model http://efc.unc.edu/tools/Rate_Analysis-version2.xlsx Data Input 2

  7. Water and Sewer Rates Analysis Model http://efc.unc.edu/tools/Rate_Analysis-version2.xlsx Charts

  8. Water and Sewer Rates Analysis Model • Results are Excel Spreadsheet with: • The Fund Balance Under Existing Rates • The Fund Balance Under Proposed Rates …Projected for the next 20 years

  9. “One-on-one” Assistance http://efcnetwork.org/one-on-one/

  10. Asset management tools

  11. Sample EPA Guides Asset Management: A Best Practices Guide http://water.epa.gov/infrastructure/drinkingwater/pws/cupss/upload/guide_smallsystems_assetmanagement_bestpractices.pdf Asset Management for Local Officials http://water.epa.gov/infrastructure/drinkingwater/pws/cupss/upload/guide_smallsystems_assetmanagement_localofficials.pdf

  12. Sample EPA Guides Building an Asset Management Team http://water.epa.gov/infrastructure/drinkingwater/pws/cupss/upload/guide_smallsystems_assetmanagement_teammanagement.pdf Setting Small Drinking Water System Rates for a Sustainable Future - STEP Guide Series http://water.epa.gov/infrastructure/drinkingwater/pws/cupss/upload/guide_smallsystems_final_ratesetting_guide.pdf

  13. http://www.epa.gov/safewater/smallsystems/pdfs/guide_smallsystems_asset_mgmnt.pdfhttp://www.epa.gov/safewater/smallsystems/pdfs/guide_smallsystems_asset_mgmnt.pdf

  14. Software:CAPFinance (EFC @ Boise State) CAPFinance is a user-friendly Program designed for Windows PCs http://efc.boisestate.edu/efc/Tools/tabid/58/Default.aspx

  15. Software: CUPSS (EPA) http://www.epa.gov/cupss/

  16. Software: CUPSS (EPA)

  17. Software: CUPSS (EPA)

  18. Software: CUPSS (EPA)

  19. Software: CUPSS (EPA) http://www.epa.gov/cupss/

  20. capital planning tools

  21. CIP Tool in MS Excel (EFC @ UNC) http://www.efc.unc.edu/tools.htm#CIPTool Instructions

  22. CIP Tool in MS Excel (EFC @ UNC) http://www.efc.unc.edu/tools.htm#CIPTool Data Input 1

  23. CIP Tool in MS Excel (EFC @ UNC) http://www.efc.unc.edu/tools.htm#CIPTool Data Input 2

  24. CIP Tool in MS Excel (EFC @ UNC) http://www.efc.unc.edu/tools.htm#CIPTool 20-Year Projections

  25. CIP Tool in MS Excel (EFC @ UNC) http://www.efc.unc.edu/tools.htm#CIPTool Dashboard Dashboard for Town of Anytown's 20-year Water and Sewer C.I.P. starting in FY15

  26. More EFC Related tools efc.unc.edu/tools.htm Tools Developed by the EFC at UNC • Capital Improvement Plan (CIP) Tool for Water and Wastewater Utilities, version 2.0 • Water & Sewer Rates Analysis Model, version 2.0 • Dashboard for Using Capital Reserve Fund to Avoid Rate Shock • Customer Assistance Program Costing Tool • Rates Dashboards for NC, GA, SC and VA Water and Wastewater Utilities • Revolving Fund Model • Loan Assistance Program

  27. More EPA Tools – Small Public Water Systems and Capacity Development Website: http://water.epa.gov/type/drink/pws/smallsystems/ Contains Info on: • State Guidance • Regulations • Compliance Help • Technical Help • Financial Help • Partners • Publications

  28. Example: “Gaining Operational and Managerial Efficiencies Through Water System Partnerships” • From: http://water.epa.gov/type/drink/pws/smallsystems/ • Case Studies on: • Informal Cooperation • Contractual Assistance • Interconnection of Stand-alone Systems • Joint Powers Agency with Interconnections • Ownership Transfer with Interconnection

  29. Will post materials to:http://efc.unc.edu/training.html Stacey Isaac Berahzer Senior Project Director Environmental Finance Center PO Box 671346 Marietta, GA 30066 berahzer@unc.edu T: 770.509.3887     F: 770.509.9539

More Related