Geo
Return Button
Analytica

WATER Power Tools™ v1.0 for Microsoft Excel®


FINANCIAL Capacity Pages

This section of WATER Power Tools™ contains tools and programs to help you manage the financial operations of your water system. These tools have been selected and designed to help you better measure, analyze, and understand the financial resources and capacities within your system. You will also gain new insight into current and future fiscal demands as WPT™ guides you through a systematic analysis of important monetary elements of your municipality. A sample of some of the questions you will be able to answer include -

How much amortization should I record for various system elements? What would be the impact of using different depreciation methods?

What is the cost of the water my system provides? How does that cost change if elements in my system change?

What is the value of my spare parts and equipment inventory? How can I plan for the replacement of major pieces of equipment?

What elements should I include in an impact fee, and what should the overall amount of the impact fee be?

WATER Power Tools™ will help you answer these questions and many more as you input your system information into the WPT™ Financial Capacity pages. A summary listing of the individual pages within this section follows this paragraph. Where there are sections with similar pages, only one representative example may be shown.


C1.0 Amortization Calculator
C2.0 Water Cost Analysis Worksheet
C3.0 Water Rate Development System
  C3.1   Modeled Water Rates and Core Assumptions
  C3.2   Water Rate Analysis and Modeling Summary
  C3.3   Water Revenue and Consumption Chart
  C3.4   Water Rate Model for the Existing -
  C3.5   Water Rate Model for the Existing -
  C3.6   Water Rate Model for the Existing -
  C3.7   Water Rate Model for the Existing -
  C3.8   Water Rate Model for the Existing -
  C3.9   Water Rate Model for the Proposed -
  C3.10   Water Rate Model for the Proposed -
  C3.11   Water Rate Model for the Proposed -
  C3.12   Water Rate Model for the Proposed -
  C3.13   Water Rate Model for the Proposed -
  C3.14   Water Rate Model for the Proposed -
  C3.15   Water Rate Model for the Proposed -
  C3.16   Water Rate Model for the Proposed -
  C3.17   Water Rate Model for the Proposed -
  C3.18   Water Rate Model for the Proposed -
  C3.19   Water Rate Model for the Proposed -
 
C3.20
  License Agreement
C4.0 Water Rate Implementation Model
 
C4.1
  Rate Query and Analysis by Customer
 
C4.2
  Rate Structure
 
C4.3
  Annual Customer Usage Data and Rate Application
 
C4.4
  Current Consumption Data
 
C4.5
  Revenue from Current and Proposed Rates
 
C4.6
  Rate Revenue Comparisons by Area Chart
 
C4.7
  Rate Revenue Comparisons by Type Chart
 
C4.8
  Water Consumption by Area Pie Chart
 
C4.9
  Water Consumption by Type Pie Chart
 
C4.10
  Monthly Water Consumption by Area Chart
 
C4.11
  Monthly Water Consumption by Type Chart
 
C4.12
  License Agreement
C5.0 Spare Parts Inventory
C6.0 Equipment and Plant Inventory
C7.0 Depreciation Schedules
C8.0 Asset Management System
 
C8.1
  Asset Management Program Summary
 
C8.2
  Asset Management Plan Detail #1
 
C8.3...
  Asset Management Plan Detail # 2 - #20
C9.0 Water Plant or Facility Value and Life Cycle Analysis
C10.0 Impact Fee Analysis
  C10.1   Current Water Source Production Data
  C10.2   Water and Sewer Capital Facilities and Impact Fee Analysis
  C10.3   Capital Facility Summary & Impact Fee Analysis Desc. of Calculations
  C10.4   License Agreement
C11.0 Impact Fee Ledger

Somel of the sections listed above may have more pages that those listed above. The list shows an example of each type of page. The menu page for each section gives a full list of all of the pages in each section.

NOTE: the features and specifications of WATER Power Tools™ are subject to change at any time without notice. GeoAnalytica, Inc. is not responsible for any consequences resulting from changes in the features or functionality of WATER Power Tools™.