Existing Financial and Utility Management Tools Funding Coordination

  • Slides: 29
Download presentation
Existing Financial and Utility Management Tools Funding Coordination and Financial Training for Small Water

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

Outline • • Rate Setting Tools Asset Management Tools Capital Planning Tools More Resources

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

RATE SETTING TOOLS 3

RATE SETTING TOOLS 3

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

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

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

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

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

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

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

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

Water and Sewer Rates Analysis Model • Results are Excel Spreadsheet with: – The

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 8

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

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

ASSET MANAGEMENT TOOLS 10

ASSET MANAGEMENT TOOLS 10

Sample EPA Guides Asset Management: A Best Practices Guide http: //water. epa. gov/infrastructure/drinkingw ater/pws/cupss/upload/guide_smallsystem

Sample EPA Guides Asset Management: A Best Practices Guide http: //water. epa. gov/infrastructure/drinkingw ater/pws/cupss/upload/guide_smallsystem s_assetmanagement_bestpractices. pdf Asset Management for Local Officials http: //water. epa. gov/infrastructure/drinkingw ater/pws/cupss/upload/guide_smallsystem s_assetmanagement_localofficials. pdf 11

Sample EPA Guides Building an Asset Management Team http: //water. epa. gov/infrastructure/drinkingwater/ pws/cupss/upload/guide_smallsystems_assetm anagement_teammanagement.

Sample EPA Guides Building an Asset Management Team http: //water. epa. gov/infrastructure/drinkingwater/ pws/cupss/upload/guide_smallsystems_assetm anagement_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_r atesetting_guide. pdf 12

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

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

Software: CAPFinance (EFC @ Boise State) CAPFinance is a user-friendly Program designed for Windows

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 14

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

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

Software: CUPSS (EPA) 16

Software: CUPSS (EPA) 16

Software: CUPSS (EPA) 17

Software: CUPSS (EPA) 17

Software: CUPSS (EPA) 18

Software: CUPSS (EPA) 18

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

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

CAPITAL PLANNING TOOLS 20

CAPITAL PLANNING TOOLS 20

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

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

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

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

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

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

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

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

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

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

More EFC Related tools efc. unc. edu/tools. htm Tools Developed by the EFC at

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 26

More EPA Tools – Small Public Water Systems and Capacity Development Website: http: //water.

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 27

Example: “Gaining Operational and Managerial Efficiencies Through Water System Partnerships” • From: http:

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 28

Will post materials to: http: //efc. unc. edu/training. html Stacey Isaac Berahzer Senior Project

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 www. efc. unc. edu

UTILITY COORDINATION Afternoon session Utility Coordination changes ProcessUTILITY COORDINATION Afternoon session Utility Coordination changes Process
Utility Maximization Utility and Consumption Utility is aUtility Maximization Utility and Consumption Utility is a
Utility Buying Motives Utility n Utility the addedUtility Buying Motives Utility n Utility the added
Chapter Four Utility Utility Functions u A utilityChapter Four Utility Utility Functions u A utility
Utility Cart Training Utility Cart Definition Utility cartsUtility Cart Training Utility Cart Definition Utility carts
2 3 3 Utility Programs Utility Programs Utility2 3 3 Utility Programs Utility Programs Utility
Chapter 4 Utility Utility n n Utility levelChapter 4 Utility Utility n n Utility level
Utility 2 5 Utility Theory Utility is aUtility 2 5 Utility Theory Utility is a
Chapter 15 Utility Terminations Overview Utility Terminations UtilityChapter 15 Utility Terminations Overview Utility Terminations Utility
Utility Coordination and Subsurface Utility Engineering Working TogetherUtility Coordination and Subsurface Utility Engineering Working Together
LPA and Utility Coordination LPA Program with UtilityLPA and Utility Coordination LPA Program with Utility
Utility Coordination Certification and Utility Special Provisions LearningUtility Coordination Certification and Utility Special Provisions Learning
IDM Chapter 104 Utility Coordination Gail Lee UtilityIDM Chapter 104 Utility Coordination Gail Lee Utility
LPA Utility Coordination Natalie Parks P E UtilityLPA Utility Coordination Natalie Parks P E Utility
FINANCIAL MANAGEMENT Definition of financial management Financial managementFINANCIAL MANAGEMENT Definition of financial management Financial management
Financial Management Accounting Financial Management Accounting Financial ManagementFinancial Management Accounting Financial Management Accounting Financial Management
Financial Management Financial Management Financial Management is broadlyFinancial Management Financial Management Financial Management is broadly
COORDINATION COMPOUNDS Chemistry of Coordination Compounds Coordination CompoundsCOORDINATION COMPOUNDS Chemistry of Coordination Compounds Coordination Compounds
Financial Tools and Technology SELECT FINANCIAL TOOLS ANDFinancial Tools and Technology SELECT FINANCIAL TOOLS AND
Financial Tools and Technology SELECT FINANCIAL TOOLS ANDFinancial Tools and Technology SELECT FINANCIAL TOOLS AND
Financial Tools and Technology SELECT FINANCIAL TOOLS ANDFinancial Tools and Technology SELECT FINANCIAL TOOLS AND
Barnet School Funding Funding Spreadsheet Guidance Funding ProcessBarnet School Funding Funding Spreadsheet Guidance Funding Process
Leisure Provision Funding Types of Funding Public FundingLeisure Provision Funding Types of Funding Public Funding
Financial Management Concepts Tools Exercises Does financial managementFinancial Management Concepts Tools Exercises Does financial management