The Visual Cash Flow Pro forma comprises enterprise-level revenue suﬃciency cash ﬂow projections with drill-down granularity on demand. All elements related to organizing the ﬁnancial projections are dynamic, using a powerful chart of accounts structure. To facilitate analysis, cash ﬂow projections are generally calculated as two separate projection schedules:
Full Ratio Analysis is built into the Visual Cash Flow Proforma and can be calculated based on a deﬁned formula. These financial analysis metrics are Excel like to set up by an administrator but standardize analysis across your enterprise. Ratio analysis is extremely valuable in supporting bond covenants and measuring the ﬁnancial strength of cash ﬂow projections. Ratio analysis, combined with the following platform capabilities, makes it possible to perform a documented bond feasibility study. The types of ratios include:
Using the Rates Timing Visualizer, users can 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. Computed rates can be inserted back into the revenue suﬃciency cash ﬂow projections and ratio analysis. Scenarios include:
Automatically calculate and set aside reserves in the cash ﬂow projections and apply them in any period!
A dashboard is a powerful analytical tool with content setup based upon user preferences. Think about a dashboard as a canvas on which meaningful analysis can be placed. Graphical content on the dashboard is referred to as a widget. Setting up a widget is as easy as clicking on a line item on the Visual Cashﬂow pro forma. Widgets include:
As a financial manager, you are tasked with answering critical questions regarding future ﬁnancial operations and avoiding rate shock: 1. Revenue sufficiency: Can rates support the operations budget now and in the future? 2. Rate increases: How can you plan rates that recapture costs associated with capital infrastructure, O&M, and debt ﬁnancing? 3. Document your ﬁndings: How can you create a comprehensive multi-year cost of service analysis to document and completely prove the need for a target rate structure? And most importantly, how you can you, the financial utility manager, get hands on - yourself - to make decisions that impact the future?
Create and maintain a comprehensive financial plan including reserve fund planning for rate stabilization, capital expenditures, and emergencies. Experiment with the timing of rate increases with the Rates Visualizer. Perform what-if analysis by applying reserves to delay a rate increase. Test out the impact of a CIP master plan on cash flow and rates. Develop a CIP ﬁnancing plan and automatically perform a bond feasibility study. Instantly calculate a comprehensive cost of service analysis with any scenario. Paint the ﬁnancial future of your utility operations on a canvas and securely share with colleagues or with the Board.
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. For instance, click on the growth rates folder clone button - now experiment with alternative growth rates for customer classes - view the impact on cash ﬂow projections in seconds! Click on the clone button for the CIP master plan - experiment with alternative project start dates - view the impact on the cost of service analysis in seconds! Develop more confidence about the future by taking a hands-on approach to financial planning!
To support the cost of service analysis, all cash flow accounts can be allocated in terms of direction of costs. Each account can be explicitly allocated by percentage for recapture of the cost by rates by:
This core methodology for the allocation of costs is extremely robust and can accommodate any rate or fee structure.
Access these mission critical applications on a PC, Mac, IPAD or another hand-held device 24/7. Securely access these powerful capabilities on various devices from anywhere on the planet. The PLANNER APPLICATION FRAMEWORK is the common technology core utilized by:
Spreadsheets represent personalized, compartmentalized, non-enterprise data. Typically, these models are maintained on the desktop of an expert in your organization or a consultant. Harness the power to make better decisions by moving to enterprise level data and analysis. Get your data when you need it - the Links Feature makes it possible to export data out to Excel on demand!
Our cutting edge UTILITY RATE AND FINANCIAL ANALYSIS SOFTWARE utilizes Microsoft technology Our technology architecture and deployment stresses security, reliability and performance. Our security framework includes robust user authentication, user access control , and data encryption.