AQUA RATES PLANNER STORY

---

Background and High Level Review

• The Visual Cash Flow Pro forma comprises enterprise-level revenue sufficiency cash flow projections with drill-down granularity on demand
• Full ratio analysis is built into the Visual Cash Flow Proforma and can be calculated based on a defined formula
• Reserves are automatically set aside based on a formula and available for application on demand

• Develop the O&M budget and automatically include in scenario calculations
• Completely flexible chart of accounts organized in a hierarchy 
• Create & maintain multiple versions of O&M budgets and include in a scenario on demand
• Clone a budget version and test on revenue sufficiency and rate calculations
• Experiment with projection growth assumptions

• Develop a comprehensive CIP master plan 
• Manage multiple CIP master plan versions
• Model incremental O&M associated with each CIP project
• Model sources of financing for generation of the capital financing plan
• Clone the CIP master plan and perform what-if analysis including the impact on revenue sufficiency and rate calculations

• Create a comprehensive financing plan in minutes
• Finance with bonds, revolving credit facility or equity
• Automatically calculate full debt service amortization schedules  
• Model pay as you go applying specific capital reserve funds 
• Tie into revenue sufficiency and rates 
• Perform a bond feasibility study

• Structure any rate design with products, cost pools and service classes
• Model fixed, variable, uniform, decreasing block, increasing block, seasonal, surcharge rates or any kind of rate design / service class combination
• Experiment with service class connection projections and volume growth rates and tie into revenue sufficiency and rate calculations

• Using the Rates Timing Visualizer, click on rate increase years and automatically recalculate rates across customer service classes 
• The rate calculations are based on a complete and granular cost-of-service analysis
• Direction of cost allocations, resulting in full cost recovery from rates, are well organized and easy to use
• Automated calculations based on all directions of cost allocation factors are fully integrated with revenue sufficiency analysis

• Think about a dashboard as a canvas on which meaningful analysis can be placed 
• The software package is remarkably easy to use and puts the financial manager hands-on to experiment and immediately view the impact on revenue sufficiency and rates 
• Paint the financial future of your utility operations on a canvas and securely share with colleagues or with the Board

• Easily export all data back out to Excel for analysis, on demand, its your data
• Simplify the management of data with  separate financial plans
• Run on various devices including a PC, Mac, IPAD or smart phone
• Services to get you implemented, including data uploads and keying in data
• Things that inspire us