|
 
|
      
|
|
|
|
Compare residential and non-residential stormwater fees charged in 2012 by GA stormwater utilities. Comparisons are made across subgroups of
utilities with similar characteristics, such as location, EPA phase,
rate structure, and customer income levels. Fees in terms of customer income
are also provided. Fees from 2010 are included to allow for historic
comparisons.
Flash file, 3 Mb.  Get Adobe Flash Player.
|
|
Enter in all capital projects and this tool will project
your fund balance (revenues, expenses and reserves), and necessary rate increases for the
next 20 years, and more! Data entry requirements are minimal. Intended for small systems.
How to use the CIP tool:
Start by entering basic information on a utility's rate
structure, customer base and current fiscal year financials.
Then enter the capital projects for the next 20 years, choose project start
and end dates and costs, and select a financing method
for each project (cash financed or debt financed).
The tool will calculate annual rate increases necessary to
cover capital reserve allocations and debt service
over a 20-year planning period, while restricting your reserves from
increasing perpetually. Results are displayed in
tables and easy-to-read graphics.
MS Excel file, 805 Kb.
|
|
- Easy-to-use, simplified cash flow model
- Input current rates, number of accounts, growth rate, average consumption, expenses
- Adjust rates
- Computes net profit/losses for 20 years
MS Excel file, 350 Kb.
|
|
Select your utility's rates, or enter in your new rate structure's charges for 0 - 15,000 gallons/month
for residential customers, and select the range of system sizes (number of accounts) you would like to
benchmark your rates to. Five charts compare your rates and the ratio of your fixed (based, or "minimum")
charges to the variable charges (those that are determined from the actual water volume use of the customer).
The majority of your utility' expenses are fixed, but maximizing your base charges may lead to affordability
issues since everyone pays the base charge. Balancing your fixed revenue and variable revenue is critical for
your financial stability and customer service goals. This tool provides you information about your
current (or proposed) rate structure's balance of those two revenues from residential customer charges,
while benchmarking against other utilities of the same size.
MS Excel file, 966 Kb.
|
|
This interactive tool has been created
for water utility managers and other water resource
managers to use in considering options for generating
local funds for watershed protection. The tool includes
a "slider" that can be manipulated to show how much
revenue can be generated by raising water rates. It
also includes other options such as creating a "watershed
fee" through property tax bills instead of the utility
bill. Funds generated by these options can be used as
a match for grants that require a cost-share. Alternatively,
the funds can be used to amortize a loan, since the
tool demonstrates to lenders how the funds will be generated
for loan repayment.
Flash file, 1.2 Mb. Get Adobe Flash Player.
|
|
Compare residential and non-residential stormwater fees charged in 2010 (and in 2012 - beta version)
by all of the NC stormwater utilities. Comparisons are made across subgroups of
utilities with similar characteristics, such as location, EPA phase,
rate structure, and customer income levels. Fees in terms of customer income
are also provided. Fees from 2006 are included to allow for historic
comparisons.
Flash file, 2 Mb. Get Adobe Flash Player.
|
|
This tool provides you with the ability to calculate and perform
sensitivity tests around the cash flows and economic benefits of
subsidized loans and grant funding. Subsidized interest rates, principal
forgiveness and the structure of payments are all considered. Use this
tool to determine whether the subsidized funding package that is being
offered to you makes economic sense to accept.
Flash file, 710 Kb. Get Adobe Flash Player.
|
|
Establishing capital reserves represents a balance between
saving for future capital and spending for current needs. A large
capital reserve can be a great tool for mitigating the impact of
large capital projects on utility rates, but it is not always clear
whether it is better to spend all cash reserves up front thereby
reducing the amount of debt principle incurred, or spend only a
portion and use it over time to pay debt service. If the ultimate
goal is to spread out rate increases over time, the right strategy
will depend on the size of the capital project and the terms of
debt. Use this simple tool to determine which balance works
best for your capital project. With this tool, a user can
adjust the amount of debt incurred (whatever is not paid for out
of reserves) and adjust rate increases over a five year period
to make sure fund balances stay in the black.
Flash file, 330 Kb. Get Adobe Flash Player.
|
|
Estimate the direct program costs of a customer
assistance program. The tool is designed on the assumption that
customers in need can access a fund a certain number of times per
year, to help them pay utility bills when necessary. The user can
adjust eligibility criteria and the amount of customer assistance
per customer in a given year to determine direct program costs. It
is built using Census information on communities in North Carolina,
but could easily be replicated for other states.
MS Excel file, 1023 Kb.
|
|
- Compare user rates for water and wastewater utilities
- Analyze rates alongside key financial performance indicators, system characteristics,
customer base socioeconomics and conservation price signaling
- Compare user rates for various levels of consumption
|
|
- Planning a system upgrade or capital improvement project
- Providing loans to individual system users
- Borrowing at a low rate (i.e. SRF loan) and passing this advantage on to your users
- Mixing different funding sources
MS Excel file, 93 Kb.
|
|
- Finance your next project with a loan
- Determine the cost for each user
- Compare different loan terms
As inputs, the model needs a loan amount, period, interest rate, and number
of users (or connections). The output of the model is the annual cost
for each user, for either declining or equal payments.
MS Excel file, 51 Kb.
|
|
- Template for the basic requirements of Phase II
- Commentary providing context for its various provisions
- Analytical framework by which each local government may develop a unique and comprehensive program appropriate
|
|
This tool can help you choose
and analyze fleet vehicles based on cost and carbon output.
Flash file, 233 Kb. Get Adobe Flash Player.
|
|
This tool allows you to view the flow of trash to
and the estimated capacity of private landfills in the state.(Click
on blue stars to watch the transfer).
Flash file, 255 Kb. Get Adobe Flash Player.
|
|
|
|
