HomeMy WebLinkAboutWater Rates Analysis Report - 11/7/2012Oro Valley Water Utility Commission
Water Rates Analysis Report
November 7, 2012
TOWN OF ORO VALLEY
WATER UTILITY COMMISSION
WATER RATES ANALYSIS REPORT
NOVEMBER 7, 2012
ORO VALLEY TOWN COUNCIL
Satish Hiremath, Mayor
Lou Waters, Vice Mayor
Brendan Burns, Council Member
Bill Garner, Council Member
Joe Hornat, Council Member
Mary Snider, Council Member
Mike Zinkin, Council Member
ORO VALLEY WATER UTILITY COMMISSION
Robert Milkey, Chair
Winston Tustison, Vice Chair
Richard Davis, Commissioner
John Hoffmann, Commissioner
Richard Reynolds, Commissioner
Elizabeth Shapiro, Commissioner
Richard Verlaque, Commissioner
TOWN STAFF
Greg Caton, Town Manager
Stacey Lemos, Finance Director
Philip C. Saletta, P.E., Water Utility Director
Shirley Seng, Water Utility Administrator
TABLE OF CONTENTS
SECTION TITLE PAGE
Index of Appendices i
List of Acronyms ii
Executive Summary 1
Introduction 3
Water Use Trends 4
Growth Trends 5
Vacant Homes and/or Disconnected Meters 6
Debt Service Coverage Requirements 6
Operating Fund 7
Alternative Water Resources Development Impact Fee Fund 11
Potable Water System Development Impact Fee Fund 13
Preferred Financial Scenario 15
Recommendation on Water Rates, Fees & Charges 16
Other Service Fees & Charges
Cost of Service Study
Conclusion
Appendices
IE?
W.,
WPI
INDEX OF APPENDICES
APPENDIX
A. Assumptions for Preferred Financial Scenario
n A-1 Operating Fund
l A-4 Alternative Water Resources Development Impact Fee Fund
A-5 Potable Water System Development Impact Fee Fund
B. Preferred Financial Scenario
B-1 Operating Fund
B-3 Alternative Water Resources Development Impact Fee Fund
J B-4 Potable Water System Development Impact Fee Fund
B-5 Summary of all Funds
C. Rate Schedules & Tables for Bill Comparisons for Preferred Financial Scenario
C-1 Potable & Reclaimed Water Rates
C-2 Tables for Bill Comparisons by Meter Size
I
LIST OF ACRONYMS
LIST OF ACRONYMS USED IN THIS REPORT
AF
Acre Feet
AWRDIF
Alternative Water Resources Development Impact Fee
AWWA
American Water Works Association
CAGRD
Central Arizona Groundwater Replenishment District
CAP
Central Arizona Project
COLA
Cost Of Living Allowance
EDU
Equivalent Dwelling Unit
FY
Fiscal Year
GPF
Groundwater Preservation Fee
LTS
Long Term Storage
O&M
Operating and Maintenance
PWSDIF
Potable Water System Development Impact Fee
WIFA
Water Infrastructure Finance Authority
TOWN OF ORO VALLEY
WATER UTILITY COMMISSION
WATER RATES ANALYSIS REPORT
NOVEMBER 7, 2012
EXECUTIVE SUMMARY
The functions and duties of the Oro Valley Water Utility Commission include reviewing and
developing recommendations for water revenue requirements, water rates and fee
structures. The Commission annually evaluates staff recommendations based on a rates
I l analysis to assure the recommendations meet Town policies and bond covenants. Water
I 1 rates and charges shall be reviewed annually under Mayor and Town Council Water Policies
— ILA. 2.b(4).
1 The Utility has based its financial analysis on the American Water Works Association
(AWWA) Cash Needs Approach. The AWWA is the largest national organization that
develops water and wastewater policies, specifications and rate setting guidelines accepted
by both government -owned and private water and wastewater utilities worldwide.
This Water Rates Analysis Report contains detailed information on the three funds that
comprise the Oro Valley Water Utility:
➢ Operating Fund
➢ Alternative Water Resources Development Impact Fee Fund
➢ Potable Water System Development Impact Fee Fund
1 Each fund is individually analyzed with regard to revenue and revenue requirements. The
Utility is an enterprise of the Town and receives its revenues predominately from rates, fees
and charges and does not receive revenues from any taxes or payments from the General
? Fund.
The assumptions used to prepare this report are similar to prior years and include water use
1 trends, vacant homes and/or disconnected meters, growth trends and debt service coverage
requirements. All of these will be addressed within this report.
The Water Utility Commission has made a recommendation for a Preferred Financial
Scenario. The Preferred Financial Scenario generates the revenue needed to maintain an
adequate cash balance of $4.8 million for the Operating Fund over the projected five year
period. The Preferred Financial Scenario includes future financing for capital projects.
The Preferred Financial Scenario also builds the cash balance of the Alternative Water
Resources Development Impact Fee Fund over the five year period while continuing to pay
off current debt on the reclaimed water delivery system. Building this cash balance will be
important as the Town moves forward with the delivery of Central Arizona Project (CAP)
water.
The Preferred Financial Scenario includes five year projections for each fund. This allows
the Utility to evaluate the impact of future costs and the revenue sources that will be
required to meet those costs. Based on the data contained within the Preferred Financial
- 1 -
Scenario, the Water Utility Commission has made recommendations on water rates for FY
2012-13.
Those recommendations are as follows:
➢ No increase in the monthly base rates for potable and reclaimed water use.
➢ No increase in the tiered commodity rates for potable and reclaimed water use.
➢ No change in the water use contained within the 4 tiers for all meter sizes
➢ No increase in the potable or reclaimed Groundwater Preservation Fee.
➢ No increase in potable or reclaimed construction water rates
Due to sound fiscal and water resource management, it is projected that the Utility will meet
revenue requirements with no proposed water rate increases for the base and commodity
rates in FY 2012-13.
In May 2012 the Utility refunded the majority of the Series 2003 Senior Lien Bonds. Funds
from the Potable Water System Development Impact Fee Fund were used to pay down the
debt in the amount of $3 million. Reduction of the Utility's outstanding debt continues to
improve the debt service coverage ratio which is a key factor in the water rates analysis.
Debt balance and the debt service coverage ratio have been a main driver for water rate
increases in the past.
Additionally, management of water resources as it relates to delivery of CAP and reclaimed
water, recovery wells, long term storage credits and groundwater extinguishment credits has
reduced the Utility's obligation to the Central Arizona Groundwater Replenishment District.
The substantial savings realized from these actions contribute to the recommendation for no
proposed increases for the base and commodity rates for FY 2012-13. It is important to
understand that each year the water rates analysis is prepared based on the most up-to-
date information available for a 5-year projection period. Operational needs and capital
improvement requirements change annually and are carefully evaluated when they are
included in the analysis. It is important that the Utility perform the required water rates
analysis every year because increases in debt, operating or capital cost could result in the
need for a rate increase.
Included in the Utility's budget for FY 2012-13 are funds to perform a Cost -of -Service Study.
This study will evaluate the different user classifications with regard to rate structure. The
study will begin in January and should be completed by June 2013. The results of the study
will aid the Utility in rate design for FY 2013-14 and beyond.
The Commission presents this Water Rates Analysis Report for the review and
consideration of the Mayor and Council. The Commission and Water Utility Staff are
available to discuss this report in greater detail at the Council's request.
The Oro Valley Water Utility Commission is proud to serve the Town of Oro Valley, its
citizens and the customers of its water utility. The Commission extends their appreciation to
the Mayor and Council for their consideration and guidance and looks forward to their
continued direction.
-2-
I 11591TA ki[o] &Q:li>%\44=0
WATER UTILITY COMMISSION
WATER RATES ANALYSIS REPORT
NOVEMBER 7, 2012
INTRODUCTION
The Oro Valley Water Utility was established in 1996 as a self-supporting enterprise of the
Town. The Utility is comprised of three separate funds that have been established for
specific purposes. The Funds are as follows:
➢ Operating Fund
➢ Alternative Water Resources Development Impact Fee Fund
j ➢ Potable Water System Development Impact Fee Fund
The Operating Fund is the primary fund for the Utility. The expenditures managed from this
fund include personnel, operations and maintenance for both potable and reclaimed water
systems, capital costs for existing potable water system improvements and related debt
service. Revenue for this fund includes water sales, service fees and miscellaneous
charges and interest income. The Utility does not receive any revenues from taxes or
J money from the Town General Fund. The Utility does pay the General Fund for services
including finance, human resources, fleet services, information technology, legal, insurance
and rental of office space.
The Alternative Water Resources Development Impact Fee Fund was established in 1996 to
manage capital expenditures related to alternative water resources including reclaimed
water and Central Arizona Project (CAP) water. Expenditures include acquisition of water
rights required for growth and capital costs, including debt service, to deliver reclaimed
1 water and CAP water to the Town. Revenue for this fund is received from impact fees
J collected at the time water meters are purchased and from interest income. Additionally, the
Groundwater Preservation Fees, which are collected through the Operating Fund, are
l transferred to the Alternative Water Resources Development Impact Fee Fund to pay for
J capital costs and debt service.
The Potable Water System Development Impact Fee Fund was established in 1996 to
J manage capital expenditures related to expansion or growth -related potable water capital
projects and related debt service. These projects include wells, pump stations, reservoirs
and mains for the potable water system. Revenue for this fund is received from impact fees
J collected at the time water meters are purchased and from interest income.
The revenue and expenditures of all three funds are combined primarily to determine if the
1 Utility meets the debt service coverage requirement established in the Mayor and Town
Council Water Policies and the 2003 Bond Covenants. Otherwise, each fund is independent
with regard to revenue and expenses. The revenue from the individual impact fee funds
may not be consolidated nor used for any purpose other than for which they were originally
established. Each fund is addressed in more detail in the report. Figure 1 illustrates the
relationship between the three funds.
-3-
Figure 1
Operating Fund
AWRDIF Fund
PWSDIF Fund
Rev: Water sales, service
Rev: AWRDIF impact
Rev: PWSDIF impact
fees and charges
fees & groundwater
fees
preservation fees
Exp: Operating costs,
Exp: Alternative water
Exp: Growth related
existing system capital
resources (CAP &
potable water capital
improvements and
reclaimed water), related
improvements and
debt service
capital improvements &
related debt service
debt service
Summary of All Funds
The Utility combines all funds to
determine the overall debt service
coverage ratio required by Town Policy &
bond covenants.
The assumptions used to prepare this report are similar to prior years and include water use
trends, vacant homes and/or disconnected meters, growth trends and debt service coverage
requirements. All of these are addressed within this report.
WATER USE TRENDS
The Utility has experienced an overall reduction in water use, both potable and reclaimed,
over the last seven years. The chart below illustrates a 9.2% reduction in total water use
from FY 2005-06 through FY 2011-12. The reduction in water use may be a result of a
combination of occurrences including conservation, reduction in growth, vacant homes
and/or disconnected meters and under registering meters. There was a 1.3% decrease in
water use during FY 2011-12 from the previous year. The average single family residential
customer with a 5/8 x 3/4 inch water meter decreased their monthly water use to 8,200
gallons, down from 8,400 gallons last year. For the analysis in this report, the average
monthly water use for a single family residential customer with a 5/8 x 3/4 inch water meter
will be calculated at 8,000 gallons per month. This amount was used for revenue
projections in this analysis.
I
-4-
I
WATER USE HISTORY
POTABLE & RECLAIMED WATER
3,500,000,000
3,394,664,000
3,400,000,000
3,300,000,000
N 3,190,671,000
Z 3,200,000,000
O 3,161 384 000
3,096,242,000 3,111,492,000
Q 3,100,000,000 _
0 3,021,805,000
3,000,000,000 -
2,900,000,000 —
2,800,000,000
2005-06 2006-07 2007-08 2008-09 2009-10 2010-11 2011-12
GROWTH TRENDS
j The Utility's growth rates have decreased significantly over the past several years. The
growth projections used for this report are based on recent trends. The chart below
1 illustrates the Utility's growth rate based on new metered connections over the last 7 years.
J Seventy (70) new metered connections are projected annually from FY 2012-13 through FY
2016-17.
HISTORICAL GROWTH RATES
600
2
500 508
O
F
U
z
400
O
368 346
U
p
300
rc
196
w
200
i
3
z
97
100
68 61
0
2005-06
2006-07 2007-08 2008-09 2009-10 2010-11 2011-12
-5-
VACANT HOMES AND/OR DISCONNECTED METERS
To better understand declining water use, the Utility's customer base was analyzed. The
analysis revealed that 255 meters were disconnected or had the water service turned off
and locked as of June 30, 2012. The following is the classification of those meters:
➢ Residential
137
➢ Commercial
10
➢ Irrigation
95
➢ Construction
10
Each account was categorized by user classification and meter size and then analyzed to
project if and when the water service would be restored. For this analysis it was assumed
that 5% of all residential meters would be re -activated annually beginning in FY 2012-13.
After review, it was determined that all construction meters were homes that were under
construction when the water service was disconnected thus it was assumed that 5% of
these meters would also be re -activated annually. Analysis of the commercial accounts
revealed that it was highly unlikely that any of these meters would be re -activated. Likewise,
the majority of irrigation meters were for common areas which are not likely to be re-
activated in the near future.
These meters are not being billed; therefore, there has been a corresponding reduction in
water sales revenue and the Groundwater Preservation Fees (GPF) revenue factored into
the 5 year projections.. The total revenue reduction for FY 2012-13 is projected to be
$305,267. As the meters are projected to be re -activated, the reduction in revenue is
adjusted proportionately based on the number of meters, meter size, average water use and
projected water rates on an annual basis.
DEBT SERVICE COVERAGE REQUIREMENTS
During this water rates analysis process, staff applied the method for calculating the debt
service coverage ratio pursuant to Town Financial and Budgetary Policies adopted by the
Town Council in 2008. Section CA — Debt Capacity, Issuance & Management states the
following with respect to debt service coverage ratios:
"When utility revenues are pledged as debt service payments, the Town will strive to
maintain a 1.3 debt service coverage ratio or the required ratio in the bond indenture
(whichever is greater) to ensure debt coverage in times of revenue fluctuation."
The Water Utility currently pays debt service on a number of outstanding debt issuances
and loans. For the Series 2003 Senior Lien Water Revenue Bonds, the 2007 and 2009
Water Infrastructure Finance Authority (WIFA) Loans, water utility revenues are specifically
pledged as the repayment source for these obligations at 1.3 times coverage per the Town's
adopted financial policy.
The remaining outstanding debt obligations of the Water Utility are excise tax pledged
obligations meaning that the Town's unrestricted sources of sales taxes, fines, permit fees
and state shared revenues are pledged as the repayment sources for these bonds in the
M
bond indentures. Even though the bond indentures pledge these excise taxes as the
repayment source, the Water Utility will continue to be responsible for and budget for these
- debt service payments at a calculated debt service coverage ratio of 1.0 rather than the 1.3
times coverage. This is to avoid double coverage when calculating the debt service
coverage ratio for the water rates analysis.
It is important to note that the bond indentures for the excise tax -backed bonds require that
the Town's excise tax collections each fiscal year total at least 2.5 times the annual debt
service requirements in order to avoid having to fund a debt service reserve fund. These
conditions have been met annually in the past and are expected to continue in the future.
For FY 2011-12 the debt service coverage ratio was 6.98 for the General Fund.
This methodology of segregating the water utility revenue -pledged debt from the excise tax -
pledged debt in the rates analysis process is an accepted practice in the industry and has
been reviewed by the Town's Finance Director and the Town's financial advisors with Stone
and Youngberg.
The debt service coverage ratio is determined by dividing the annual net operating revenue
by the annual debt service payments. Using the methodology described above is in
accordance with the 2008 policy and reduces the amount of the debt service coverage
requirement amount.
OPERATING FUND
REVENUE
The Operating Fund had a cash balance of $10 million at the beginning of FY 2012-13.
Operating funds may be used for operating costs including personnel, operations and
maintenance, capital improvements for the existing potable water system and debt service.
The following table provides the Utility's budgeted revenue compared to the actual revenue
for FY 2011-12:
Revenue Source
FY 2011-12
Budgeted
FY 2011-12
Actual
Difference
Over (Under)
Water Sales
$ 11,682,799
$ 11,885,133
$ 202,334
Service Fees/Charges
$ 445,200
$ 549,815
$ 104,615
Other Income
$ 100,000
$ 242,211
$ 142,211
Interest Income
$ 16,300
$ 125,912
$ 109,612
Total
$ 12,244,299
$ 12,803,071
$ 558,772
The increase in other income represents funds received from an insurance claim. The
increase in interest income is a result of higher interest rates on funds invested with PFM
Asset Management rather than the Local Government Investment Pool. The majority of the
Town's money, including Water Utility cash, is investing with PFM Asset Management.
-7-
Revenues projected for FY 2012-13 were based on anticipated annual growth in the
customer base of 70 single family residential customers and water consumption patterns
similar to FY 2011-12. Analysis of the water use trends for FY 2011-12 indicated the
average monthly use for a single family residence with a 5/8 x 3/4 inch water meter
decreased from 8,400 gallons to 8,200 gallons per month. For this analysis, 8,000 gallons
per month was used to project water sales revenue. The vacant and/or disconnected
metered accounts were taken into consideration when projecting future water sales revenue.
The following table indicates the amount of water sales revenue that would be realized with
the existing rate structure and no water rate increase:
FY 2011-12
FY 2012-13
Difference
Actual Water Sales
Projected Water Sales
Increase (Decrease)
Revenue
Revenue
$ 11,885,133
$ 11,793,297
($ 91,836 )
The projected revenue decrease may be a result of the need to account for vacant and/or
disconnect homes which increased slightly from last year. For this analysis, it is projected
that only 5% of the residential accounts will have service restored on an annual basis.
REVENUE REQUIREMENTS
The following table is a comparative summary of operating expenses for the Water Utility
Operating Fund. Actual expenses (excluding depreciation and amortization) for FY 2011-12
are compared to the projected expenses for FY 2012-13 used in the financial analysis:
Utility
Expenditures
FY 2011-12
Actual
FY 2012-13
Projected
Difference
Increase(Decrease)
Personnel
$
2,445,315
$
2,547,472
$
102,157
O & M
$
2,998,852
$
3,955,156
$
956,304
CAP Recharge &
Wheeling Costs
$
759,183
$
1,492,945
$
733,762
Groundwater
Extinguishment Credits
$
0
$
405,000
$
405,000
CAGRD
$
251,771
$
289,164
$
37,393
Debt Service
$
2,805,717
$
2,825,953
$
20,236
Subtotal Expenditures
$
9,260,838
$
11,515,690
$
2,254,852
Capital Outlay
$
3,628,815
$
3,184,500
( $
444,315)
Total Expenditures
$12,889,653
$ 14,700,190
$ 1,810,537
we
Projected personnel costs do not include any new personnel; however, a 2.5% Cost of
Living Allowances (COLA) was approved by the Town Council for FY 2012-13. The
projected increase of $102,157 is due to the COLA and an increase in retirement benefits
for existing personnel.
The projected operations and maintenance (O&M) costs include the O&M costs for both the
potable water system and the reclaimed water system. The projected increase of $956,304
includes the addition of $100,000 for the cost of service study; an increase of $58,000 for
Town services received by the Utility; an increase of $40,000 for fleet services; and $40,000
for an impact fee analysis
The increase of $733,762 for CAP recharge and wheeling costs reflects one full year of
wheeling costs whereas in FY 11-12 there were less than 6 months of charges. CAP
deliveries began late in January of 2012. The timing for CAP water deliveries to recharge is
scheduled on a calendar year basis and occasionally the costs related to the deliveries
cross into two different fiscal years. The Utility recharged 5,000 AF in CY 2011 and will
recharge 5,000 AF in CY 2012. In CY 2013 the Utility is proposing to recharge 7,000 AF of
CAP water.
Included in the budget for FY 2012-13 is $405,000 for the purchase of groundwater
extinguishment credits. The Utility uses groundwater extinguishment credits to offset
groundwater pumping. It is anticipated that the Utility will purchase approximately 3,000
j acre feet of extinguishment credits in FY 2012-13.
Although Central Arizona Groundwater Replenishment District (CAGRD) costs are included
1 in the O&M budget for the Operating Fund, they are itemized in the table above because of
_J the significant cost of the line item. The Utility is limited in the amount of control it has over
these specific costs. The rates are set by the CAGRD and are assessed on the volume of
1 excess groundwater pumped and the minimum payment requirements pursuant to our
J agreement with CAGRD. The Utility will use Long Term Storage (LTS) credits to offset a
portion of the costs charged by the CAGRD through permitted recovery wells. In addition,
the Utility will transfer LTS credits directly to the CAGRD to further reduce the financial
obligations. Reducing payments to CAGRD is a critical component of both our financial and
water resource management.
There are a number of other annual O&M expenses that the Utility has the least control over
and therefore is unable to reduce anticipated expenditures. In addition to the CAP and
I CAGRD costs, some of the other expenses that the Utility has the least control over include:
J electrical power for pumping, water quality testing, chemicals for disinfection, CAP wheeling
costs and reclaimed water purchased from other providers. These specific costs are
determined by the volume of water pumped to meet customer demands. Other costs over
J which the Utility has least control include software maintenance on existing software,
regulatory permits, insurance, office lease, services provided by other Town departments
and costs directly related to billing. The billing costs include printing of the billing forms,
envelopes, postage, outsource vendor for bill insertion and delivery to post office, lockbox
and other bank charges for processing payments. Where applicable, the materials and/or
services have been bid or quotes have been received to assure the lowest price.
In addition to CAP water recharge costs, the O&M expenses that the Utility has minimal
control over include maintenance on production and distribution facilities such as wells,
boosters, reservoirs, and water mains. The Utility includes known preventative maintenance
1111292
costs in the budget as well as contingency funds for unknown repairs and maintenance.
The majority of these facilities are underground which allows for unforeseen malfunctions.
Additionally, water mains develop leaks that must be repaired immediately. The Utility
budgets for these specific items based on historical data; however, it is difficult to predict the
exact amount that may be spent in any given year.
The O&M expenses that the Utility has the most control over include the purchase of l
groundwater extinguishment credits, office supplies, field supplies, memberships and
subscriptions, printing, telecommunications, uniforms, rentals, training, conservation
education and outside professional services.
Debt service payments are established by debt amortization schedules prepared by the
Town's Bond Underwriters for all past bond issues. Likewise, WIFA also provides debt
amortization schedules that the Utility must adhere to. All debt service payments are pre-
defined for any given fiscal year unless funds are available to pay off the debt as the Utility
has done in the past.
The chart below illustrates the O&M costs with regard to the level of control the Utility has
over these costs.
OPERATING EXPENSES FY 2012-13
(excludes capital outlay)
O&M Least
Control
$4,156,094
37%
Debt Service
$2,825,953
25%
O&M Minimal
Control
$916,529
8%
Personnel O&M Most Control
$2,547,472 $936,547
22% 8%
Projected capital outlay for existing system improvements in FY 2012-13 in the amount of
$3,184,500 includes the replacement of 2900 water meters and installation of AMI
equipment in the Oro Valley water service area; replacement of well meters, water main
replacements; and the construction of a chlorine storage facility. Capital outlay also
includes the purchase of vehicles, SCADA and security equipment.
Projected expenditures in the Operating Fund are proposed to be funded with revenue
generated from water rates, fees, charges, and cash reserves.
-10-
ALTERNATIVE WATER RESOURCES DEVELOPMENT IMPACT FEE FUND
REVENUE
i The Alternative Water Resources Development Impact Fee Fund (AWRDIF) had a cash
balance of $1.6 million at the beginning of FY 2012-13. AWRDIF funds may be used for
capital expenditures related to alternative water resources including reclaimed water and
CAP water. The revenue sources for the AWRDIF Fund are from impact fees collected
when a water meter is purchased and from interest earned on cash balances. The
Groundwater Preservation Fees (GPF) collected through the Operating Fund are transferred
to the AWRDIF Fund to help repay outstanding debt for the reclaimed water delivery system
and for future debt on the CAP water delivery system. The following table provides the
budgeted revenue for FY 2011-12 compared to the actual revenue for FY 2011-12:
Revenue Source
FY 2011-12
Budgeted
FY 2011-12
Actual
Difference
Over Under
Impact Fees
$
219,200
$
759,958
$ 540,758
GPF
$
2,423,500
$
2,365,968
($ 57,532)
Interest Income
$
2,684
$
1,229
( $ 1,455)
Total Revenue
$
2,645,384
$
3,127,155
$ 481,771
The increase in impact fee revenue occurred as a result of a increase in the number of
meters that were purchased over what was projected.
The decrease in GPF revenue was a result of delaying the implementation of the approved
increase until October 2011.
Revenues projected for FY 2012-13 were based on anticipated annual growth in the
customer base of 70 new connections or 88 Equivalent Dwelling Units (EDUs). An EDU is
equivalent to one single family residence with a 5/8 x 3/4 inch meter. For impact fee
projections, the Utility converts the estimated new connections to EDUs at a ratio of 1.25
EDUs to 1 new connection based on historical trends and to take into consideration larger
commercial and irrigation meters. In FY 2011-12 the actual growth rate was 154 EDUs as
compared to the projected 44 EDUs.
The following table indicates the amount of impact fee and GPF revenue that would be
realized with the current impact fees and no increase to the GPF:
Revenue Source
FY 2012-13
Revenue Projection
Existing Im act Fees & GPF
Impact Fees
$ 438,416
GPF
$ 2,404,608
Total Revenue
$ 2,843,024
- 11 -
REVENUE REQUIREMENTS
The following table is a comparative summary of expenditures for the AWRDIF Fund. The
following table provides the budgeted expenditures for FY 2011-12 compared to the actual
expenditures for FY 2011-12:
Expenditures
FY 2011-12
Budget
FY 2011-12
Actual
Difference
Over (Under)
Professional Services
$
60,200
$
8,558
( $
51,642)
CAP Capital Costs
$
154,575
$
154,575
$
0
Repay Operating Fund
$
100,000
$
100,000
$
0
Capital Improvements
$
515,000
$
547,920
$
32,920
Debt Service
$
1,789,978
$
1,789,978
$
0
Total
$
2,619,753
$
2,601,031
( $
18,722)
The professional services are expenses incurred for renewable water planning studies
including the CAP water pilot study for treatment techniques. The CAP water pilot project
was completed and dismantled in FY 2011-12.
Repayment of funds borrowed from the Operating Fund will be completed over a period of 5
years at $100,000 per year. Funds were borrowed from the Operating Fund to help pay
debt service prior to the increase in the impact fees.
The capital improvements in FY 2011-12 represent costs for the facilities constructed to
deliver CAP water.
The debt service includes repayment of the portion of the Series 2003 Bonds used to
finance phase 1 of the reclaimed water delivery system and the 2007 WIFA loan used to
finance phase 2 of the reclaimed water delivery system.
Projected expenditures in the AWRDIF Fund are proposed to be funded with revenue
generated from impact fees, groundwater preservation fees and interest income. In the
table below, actual expenses for FY 2011-12 are compared to the projected expenses for
FY 2012-13 used in the financial analysis.
Expenditures
FY 2011-12
Actual
FY 2012-13
Projected
Difference
Increase (Decrease)
Professional Services
$
8,558
$
70,300
$
61,742
CAP Capital Costs
$
154,575
$
154,575
$
0
Capital Improvements
$
547,920
$
100,000
( $
447,920)
Repay Operating Fund
$
100,000
$
100,000
$
0
Debt Service
$
1,789,978
$
1,765,869
( $
24,109)
Total
$
2,601,031
$
2,190,744
( $
410,287)
-12-
The professional services are projected to increase as the Utility begins planning studies on
blending of CAP water and water quality related to recharging in Red Rock and the Lower
Santa Cruz recharge facilities.
The CAP capital costs are projected to remain the same based on established CAP rates.
n
The $100,000 in capital improvements identified above represent the funds needed to begin
engineering design for a booster pump station that would be used to blend CAP water within
the potable water distribution system.
^! As stated above, the repayment of funds to the Operating Fund will continue for the next five
years.
The decrease in debt service is a result of the refunding of the Series 2003 Senior Lien
Bonds.
POTABLE WATER SYSTEM DEVELOPMENT IMPACT FEE FUND
REVENUE
The Potable Water System Development Impact Fee Fund (PWSDIF) had a cash balance of
$3.4 million at the beginning of FY 2012-13. The revenue sources for the PWSDIF Fund are
from impact fees collected when a water meter is purchased and from interest earned on
cash balances. The Town Council adopted new impact fees in 2007. These new fees
became effective in September 2007. The following table provides the budgeted revenue
compared to the actual revenue for FY 2011-12:
Revenue Source
FY 2011-12
Budgeted
FY 2011-12
Actual
Difference
Over Under
Impact Fees
$ 114,255
$ 462,762
$ 348,507
Interest Income
$ 13,323
$ 5,467
( $ 7,856)
Total
$ 127,578
$ 468,229
( $ 340,651 )
l Revenues were projected for FY 2012-13 based on anticipated annual growth in the
J customer base of 70 new connections or 88 EDUs. An EDU is equivalent to one single
family residence with a 5/8 x 3/4 inch meter. For impact fee projections, the Utility converts
l the estimated new connections to EDUs at a ratio of 1.25 EDUs to 1 new connection based
J on historical trends and to take into consideration larger commercial and irrigation meters.
The following table indicates the amount of impact fee revenue that is projected for FY
2012-13 compared to actual revenue received in FY 2011-12:
FY 2011-12
Actual Revenue
FY 2012-13
Projected Revenue
Difference
Increase (Decrease)
$ 462,762
$ 225,896
($ 236,866)
In FY 2011-12 the actual growth rate was 154 EDUs. As stated above, the projected EDUs
for FY 2012-13 are 88 which is lower than what was actually realized in FY 2011-12.
-13-
REVENUE REQUIREMENTS
Growth -related potable water system improvements are managed through the PWSDIF
Fund. These improvements include new potable water reservoirs, pump stations, water
mains and wells that are required to meet the demands of new customers. The following
table is a comparative summary of expenditures for the PWSDIF Fund and provides the
budgeted expenditures compared to the actual expenditures for FY 2011-12:
Expenditures
FY 2011-12
Budgeted
FY 2011-12
Actual
Difference
Over (Under)
Capital Improvements
$ 740,000
$ 505,946
($ 234,054)
Debt Service
$ 639,920
$ 3,639,920
$ 3,000,000
Total
$ 1,379,920
$ 4,145,866
$ 2,765,946
The capital improvements for FY 2011-12 include the completion of a 3-million gallon
reservoir and related piping that began in FY 2010-11. The $3,000,000 difference above is
a result of the recent bond refunding to reduce debt balance in this fund.
In the table below, actual expenses for FY 2011-12 are compared to the projected
expenses for FY 2012-13 used in the financial analysis.
Expenditures
FY 2011-12
Actual
FY 2012-13
Projected
Difference
Increase(Decrease)
Capital Improvements
$ 505,946
$ 0
( $ 505,946)
Debt Service
$ 3,639,920
$ 632,645
( $ 3,007,275)
Total
$ 4,145,866
$ 632,645
( $ 3,513,221)
No additional capital improvements planned for this fund during the 5-year projection period.
All improvements identified in the 2006 Master Plan have been constructed relative to the
anticipated growth for the next 5 years.
Included with the refunding of the Series 2003 Senior Lien Bonds, the principal balance of
the bonds attributable to the PWSDIF was paid down in the amount of $3 million. With
lower growth, the revenue stream for this fund is diminished. By paying down the principal
coupled with lower interest rates, the debt service in this fund will be reduced by almost 50
percent.
-14-
PREFERRED FINANCIAL SCENARIO
Prior to developing financial forecasts, financial considerations were evaluated relating to
proposed future operating costs, significant short and long term capital expenditures, the
Utility's existing cash reserves, existing outstanding debt, proposed future debt and the
related debt service payments. To arrive at a Preferred Financial Scenario, the goals of the
Commission were to ensure that all existing rate setting policies were met, cash reserves
were utilized to minimize future debt and if there were to be proposed rate increases, those
n increases would not result in rate shock. In prior years, a key component in the rate setting
process was the calculation of the debt service coverage ratio. A 1.3 debt service coverage
I J ratio was established by Council policy with the adoption of Resolution No. (R)05-09.
n,
The Water Utility Commission has made a recommendation for a Preferred Financial
Scenario. The Preferred Financial Scenario generates the revenue needed to maintain an
adequate cash balance in all funds over the projected five year period. Additionally, the
Preferred Financial Scenario reduces the amount of future financing by using available cash
for capital projects. The Preferred Financial Scenario meets the debt service coverage
requirements in all five years of the projection period.
The Preferred Financial Scenario also builds the cash balance of the Alternative Water
Resources Development Impact Fee Fund over the five year period while continuing to pay
off the current debt on the reclaimed water delivery system. Building this cash balance will
be important as the Town moves forward with increased deliveries of CAP water.
The following are key assumptions used to develop the financial projections contained in the
J
Preferred Financial Scenario. The entire set of assumptions may be found in Appendix A.
➢ Annual growth is estimated at 70 new connections annually which equates to 88
EDUs annually.
➢ Water use patterns remain constant throughout the 5 year period and are based on
actual water use for FY 2011-12.
➢ Vacant homes and/or disconnected residential meters will be re -activated at 5% per
year beginning in FY 2012-13.
➢ All 18-hole golf courses will be delivered reclaimed water throughout the 5 year
Jprojection
period.
➢ Projected operating costs in FY 2012-13 are similar to the Utility's budget. Future
years include 2% annual inflation factors after one time expenditures have been
deducted.
J
➢ Delivery of 1500 AF of CAP water annually throughout the projection period.
➢ The Potable Water System Development Impact Fees are projected to remain the
J
same within the 5 year projection period.
➢ The Alternative Water Resources Development Impact Fees are projected to remain
I
the same within the 5 year projection period.
y
Analysis of the Preferred Financial Scenario indicates that the Operating Fund can utilize
cash reserves to finance the existing system capital improvements for FY 2012-13. With the
exception of the AM[ and meter replacement project, the Preferred Financial Scenario
proposes using cash to finance existing system capital improvements for the following three
years of the projection period. It has been assumed that the Utility finance $1,290,000
-15-
r
I
through WIFA for capital projects in FY 2016-17. The projections also include financing the
AMI meter replacement project in FY 2013-14 with a loan from WIFA.
These financing assumptions result in a slow decline of the Utility's projected cash balance.
The projected ending cash balance of the Operating Fund at the end of the five year
analysis period is $4.8 million.
The O&M portion of the wheeling costs for delivery of CAP water will be paid through water
rates; however, the capital component of the wheeling costs will be funded with revenue
derived from Groundwater Preservation Fees and Alternative Water Resources
Development Impact Fees.
The financial projections detailed in the Preferred Financial Scenario for the PWSDIF Fund ('
assume no new capital growth -related projects throughout the projection period. This will be
reviewed annually for changes, but until the growth rate changes, it is unlikely that the Utility
will need to construct growth -related facilities. Debt service for previously constructed
growth -related facilities will be paid from revenues collected from impact fees and use of the
fund balance. The Potable Water System Development Impact Fees are not projected to
increase or decrease during the five year period.
The projections for the Operating Fund, AWRDIF Fund and the PWSDIF Fund were
combined to evaluate the overall debt service coverage at the end of each fiscal year.
Analysis indicates that, under the Preferred Financial Scenario, the Utility will meet the debt
service coverage requirement established by the Mayor and Council Water Polices and
Bond Covenants for all five years. Proformas for the Preferred Financial Scenario may be
found in Appendix B.
RECOMMENDATION ON WATER RATES, FEES & CHARGES
After reviewing the analysis of the three funds and their respective revenue requirements
contained in the Preferred Financial Scenario, the Water Utility Commission is
recommending:
➢ No increase in the monthly base rates for potable or reclaimed water use.
➢ No increase the commodity rates for potable or reclaimed water use.
➢ No change in the water use contained within the 4 tiers for all meter sizes.
➢ No increase in the potable or reclaimed construction water rate.
➢ No increase in the Groundwater Preservation Fee for potable water use.
➢ No increase in the Groundwater Preservation Fee for reclaimed water use.
The detailed schedule of the existing water rates may be found in Appendix C.
The following table illustrates the proposed water rates for a single family residential
customer with a 5/8 x 3/4 inch water meter. Approximately 87% of the customers fall into
this category. Other water providers in the region are included for comparison. Tucson
Water's commodity rates are assessed on the use of 100 cubic feet which is equivalent to
748 gallons. To simplify the comparison, the rates for Tucson Water have been converted to
represent the charge for 1,000 gallons.
NM.
J
Water Provider
Monthly
Base Rate
Tier 1
Cost Per
1,000 Gals.
Tier 2
Cost Per
1,000 Gals.
Tier 3
Cost Per
1,000 Gals.
Tier 4
Cost Per
1,000 Gals.
Oro Valley Current
14.19
2.20
2.99
4.03
5.38
Oro Valley ProposedL4.12.20
2.99
4.03
5.38
Metro Water
2.00
2.70
4.05
5.40
Marana Water
2.46
3.43
4.46
5.50
Tucson Water
1.69
3.28
8.64
14.00
rj A table providing proposed rates for all Oro Valley Water Utility meter sizes may be found in
11 Appendix C. Tables that calculate monthly bills under the existing rates may also be found
in Appendix C. Monthly bill amounts are calculated in 1,000 gallon increments for the 5/8 x
1 3/4 inch meters and a variety of increments for larger meter sizes.
Oro Valley, Metro and Marana all assess their rates on usage of 1,000 gallons whereas
Tucson Water assesses their rates on cubic feet. Additionally, the tiered rate structures for
all the utilities vary with regard to the number of tiers and the volume of water included in
each tier.
For comparison purposes, the following table provides a calculation of a monthly bill
amount for a single family residential customer with a 5/8 x 314 inch meter for the water
utilities surrounding the Oro Valley Water Utility service area. Direct comparison of raw
_t base rates and commodity rates is less effective because of the varying rate structures of
each utility. A better comparison is to calculate the cost for specific consumption levels for
one month. Please note that these charges only reflect water use fees and specifically
exclude taxes, Groundwater Preservation Fees and similar renewable water resource fees
charged by other water providers.
Water Utility
Cost for
8,000 Gallons
Cost for
15,000 Gallons
Cost for
25,000 Gallons
Cost for
40,000 Gallons
Oro Valley - Current
32.58
53.51
92.77
164.02
Oro Valley - Proposed
32.58
53.51
92.77
164.02
Metro Water
36.30
1 64.65
114.60
215.85
Marana Water
34.80
56.87
96.32
173.62
Tucson Water
23.38
67.78
170.26
380.26
This report does not contain an alternate financial scenario. Due to sound fiscal and water
resource management, it is projected that the Utility will meet revenue requirements with no
proposed water rate increases in FY 12-13. It is projected that nominal rate increases will be
required annually over the following 4 years of the projection period.
J
-17-
Reduction of the Utility's outstanding debt has improved the debt service coverage ratio
which has been a key factor in the water rates analysis. This has been a main driver for
water rate increases in the past. Additionally, management of water resources as it relates
to the use of CAP and reclaimed water, recovery wells, long term storage credits and
groundwater extinguishment credits has reduced the Utility's financial obligation to the
CAGRD.
It is important to understand that each year the water rates analysis is prepared based on
the most up-to-date information available. Operational needs and capital improvement
requirements change annually and are carefully evaluated when they are included in the
analysis. It is important that the Utility perform a water rates analysis every year because
any increases in debt service, operating or capital cost could result in the need for a rate
increase.
OTHER SERVICE FEES & CHARGES
The Preferred Financial Scenarios does not include increases in other service fees and
charges. These fees and charges are evaluated annually to determine if any adjustments
are needed.
COST OF SERVICE STUDY
Funds were approved in the FY 2012-13 budget to conduct a comprehensive cost of service
study. The purpose of the study is to evaluate the design of the rate structure to determine
if the existing rate design is providing cost recovery equitably across all user classifications.
Additionally, it may be beneficial to further evaluate the rate design specific to commercial
accounts. Within the industry, it is common to design water rates for commercial accounts
based on a flat rate rather than a tiered rate structure. The cost of service study would be
instrumental in creating an equitable rate design for all customer classifications. It is
anticipated that the study will be completed by June 2013.
CONCLUSION
The Commission presents this Water Rates Analysis Report for the review and
consideration of the Mayor and Council. The Commission and Water Utility Staff are
available to discuss this report in greater detail at Council's request. Utility Staff will be
requesting Council's acceptance of the Water Rates Analysis Report on November 7, 2011.
The Oro Valley Water Utility Commission is proud to serve the Town of Oro Valley, it citizens
and the customers of its water utility. The Commission extends their appreciation to the
Mayor and Council for their consideration and guidance and looks forward to their continued
direction.
sm
an \ .
Assumptions for Preferred Financial Scenario
A-1 Enterprise Fund
A-3 Alternative Water Resources Development Impact Fee Fund
A-4 Potable Water System Development Impact Fee Fund
PREFERRED FINANCIAL SCENARIO
ASSUMPTIONS FOR OPERATING FUND
Growth
70 new metered connections for water rates each year for 5 years
Growth rates are based on historic trends for past 3 years.
Water Rate Structure
4 Tiers for each meter size — all usage in each tier to remain the same.
Water Rate Increases
The overall increase and monthly impact are representative of a residential customer
with a 5/8 x 3/4 inch water meter averaging 8,000 gallons of water use per month.
1
Base
Overall
Monthly
Rate
Tier 1
Tier 2
Tier 3
Tier4
Increase
Impact
FY 12-13
N/A
N/A
N/A
N/A
N/A
N/A
N/A
FY 13-14
1%
1%
2%
4%
6%
0.8%
$0.34
FY 14-15
1%
1%
2%
4%
6%
0.9%
$0.35
FY 15-16
1%
1%
2%
4%
6%
1.0%
$0.41
-1 FY 16-17
1%
1%
2%
4%
6%
0.9%
$0.36
Construction Water Rate
1 The construction water rate is $1.00 more than the Tier 4 rate in each year. There
are no tiers for construction water.
Potable GPF Rates (cost per 1,000 gallons)
No increase in potable GPF in all 5 years of the projection period.
Reclaimed GPF Rates (cost per 1,000 gallons)
No increase in reclaimed GPF in all 5 years of the projection period.
Water Use Trends
1 Projections include similar water use trends as those in FY 11-12. The average monthly
J water use for a residential customer with a 5/8 x 3/4 inch water meter decreased to 8,200
gallons per month in FY 11-12 from 8,400 gallons in FY 10-11. For this analysis 8,000
gallons was used as the average monthly water use.
Vacant Homes and/or Disconnected Meters
There were 255 known vacant home and/or disconnected meters at 6/30/12. The residential
& construction (147) are projected to be re -activated at 5% per year beginning in
FY 2012-13. The remaining commercial & irrigation (105) are projected to remain
disconnected.
J Other Revenue
Other revenue is based on FY 11-12 proposed budget except for sewer billing fees. It is
anticipated that the Utility will get an increase in the per account billed rate. Did not project
J increases in other misc. charges as they fluctuate annually. (NSF fees, reconnect fees, new
service establishment fees, stormwater billing, plan review)
A-1
I
PREFERRED FINANCIAL SCENARIO
ASSUMPTIONS FOR OPERATING FUND
(continued)
Beginning Cash Balance
Taken from 6/30/12 Balance Sheet of respective funds (MUNIS reports dated 7/31/12)
Interest Income
The interest rate for all 5 years in the analysis period is projected to be 0.60%. Information
provided by S. Lemos, Finance Director, on 8/08/12.
Personnel Costs
No new employees were added over the 5 year projection period.
FY 12-13 includes a 2.5% COLA plus a 1 % increase for retirement benefits.
FY 13-14 includes a 3.5% pay increase plus .5% increase for retirement benefits.
FY 14-15 includes a 3.5% pay increase plus .5% increase for retirement benefits.
FY 15-16 includes a 4.0% pay increase plus .5% increase for retirement benefits.
FY 16-17 includes a 4.0% pay increase plus .5% increase for retirement benefits.
These costs were provided by S. Lemos, Finance Director and is consistent with overall
Town planning.
Potable O&M
Based on Utility's proposed budget for FY 12-13 updated with the most recent information;
2.0% inflation annually for all remaining years. Projected a 15% increase in power costs
based on Tucson Electric's rate application filed in April of 2012.
Reclaimed O&M
Based on Utility's proposed budget for FY 12-13; 2.0% inflation annually for all remaining
years. Projected a 15% increase in power costs based on Tucson Electric's rate application
filed in April of 2012.
Water Resource Management Costs
J Costs are for the purchase of groundwater extinguishment credits. These credits will be
pledged to the Groundwater Allowance Account to help maintain a balance that will
facilitate growth in the water service area. FY 12-13 costs are based on purchasing
3,000 AF at $135/AF. Costs for the remaining years are based on the purchase of
2,000 AF at $150/AF.
J CAP Wheeling Costs
Costs include the CAP water delivery costs — rates adopted by CAP on 6/7/12. Costs also
include the O&M portion ($428.71 / AF) of the fees charged by Tucson Water to wheel the
CAP water through their recharge and recovery system.
JCAP Recharge Costs
Based on the rate schedule adopted by CAP 6//712. Recharge 6,000 AF in FY 12-13.
Assumed recharge of 7,000 AF annually for remaining years:
-J 2,500 AF with Kai Farms and 2,000 AF with Tucson Water and
2,500 AF with CAWCD at and additional $15/AF
A-2
PREFERRED FINANCIAL SCENARIO
ASSUMPTIONS FOR OPERATING FUND
(continued)
7
CAGRD Costs
Based on S. Seng worksheet and rate schedule adopted by CAP 6/7/12.
CAGRD Savings
Savings for CAGRD costs are based on what costs to CAGRD would be if we were not
taking direct delivery of CAP less what the CAGRD costs are when we do take direct
delivery of CAP water.
Power Savings
Savings are based on power costs not incurred directly by the Utility by not pumping
groundwater equal to the volume of CAP water that is delivered. Savings for power costs
estimated at $88.73 per AF.
Debt Service
P&I debt service for 2003 Excise Tax Bonds taken from amortization schedules
provided by Stone &Youngberg (S&Y).
P&I debt service for 2003 Sr. Lien Bonds taken from amortization schedules
provided by S&Y.
P&I debt service for 2005 Excise Tax Bonds taken from amortization schedules
provided by S&Y.
P&I debt savings for 2007 Excise Tax Bonds taken from schedules provided by S&Y.
P&I debt service for 2009 WIFA loan taken amortization schedule provided by WIFA
on 8/7112.
P&I debt service for 2012 Sr. Lien Bonds taken from amortization schedules
provided by S&Y with pro -rated debt service by S. Seng.
P&I debt service for proposed 2013 WIFA loan was estimated by S. Seng — $4,500,000
at 3.25% interest for 20 years.
P&I debt service for proposed 2016 WIFA loan was estimated by S. Seng — $1,290,000
at 3.25% interest for 20 years.
_i
Debt Service Coverage
1.30 debt service coverage ratio for 2003 & 2012 Sr. Lien Bonds & WIFA Loans
1.00 debt service coverage ratio for all Excise Tax Pledged Bonds
_J
Capital Improvements
Projects are identified in 5-Year CIP dated 9/01/12. The projects have been updated with
current information. As included in the budget for FY 12-13, the capital projects for
this fiscal year will be funded with cash. In FY 13-14 it is assumed the Utility will finance
$4.5 million for meter replacement & AMI installation that will be completed over 4 years.
For the remaining capital projects in FY 13-14, FY 14-15 and FY 15-16 it is assumed the
Utility will finance the projects with cash. In FY 16-17 the Utility will finance the projects
j through a loan from WIFA.
J
A-3
PREFERRED FINANCIAL SCENARIO
ASSUMPTIONS FOR AWRDIF FUND
Growth
70 new connections for water rates for all years, 88 EDUs for impact fees (70 x 1.25 = 88)
Growth rates are based on historic trends for past 3 years.
AWRD Impact Fees
Increased to $4,982 per EDU, Ordinance No. (0) 08-14, effective 12/2/08
Not projected to increase in the 5 year projection period.
Revenue
Revenue for all years derived from 88 EDUs at $4,982.
Potable GPF Rates (cost per 1,000 gallons)
No increase in the Potable GPF for the 5 year projection period.
Reclaimed GPF Rates (cost per 1,000 gallons)
No increase in the Reclaimed GPF for the 5 year projection period.
Beginning Cash Balance
Taken from 6/30/12 Balance Sheet of respective funds (MUNIS reports dated 7/31/12).
Interest Income
The interest rate for all 5 years in the analysis period is projected to be 0.60%. Information
provided by S. Lemos, Finance Director, on 8/08/12.
CAP Capital Costs
Based on 10,305 AF at rate schedule adopted by CAP 6/7/12.
Debt Service
P&I debt service for 2003 Sr. Lien Bonds (reclaimed phase 1) taken from amortization
schedules provided by Stone & Youngberg.
P&I debt service for 2007 WIFA Loan (reclaimed phase 2) provided by WIFA.
P&I debt service for 2012 Sr. Lien Bonds (refunding of 2003 bonds) taken from
amortization schedule provided by Stone & Youngberg & pro -rated by S. Seng.
Debt Service Coverage
1.30 debt service coverage ratio for 2003 & 2012 Sr. Lien Bonds and the WIFA Loan
Capital Improvements
Capital improvements in FY 12-13 include design engineering costs for a booster station
that would facilitate blending of CAP water in the potable water distribution system.
Capital improvements in FY 15-16 and 16-17 include funds for expansion of the CAP
distribution system.
E,
PREFERRED FINANCIAL SCENARIO
ASSUMPTIONS FOR PWSDIF FUND
Growth
70 new connections for water rates for all years, 88 EDUs for impact fees (70 x 1.25 = 88)
Growth rates are based on historic trends for past 3 years.
PWSD Impact Fees
Increased impact fees to $2,567 per EDU effective 10/01/07, Ordinance No. (0) 07-31.
Not projected to increase in the five year projection period.
Revenue
Revenue derived from 88 EDUs at $2,567 for all years in the projection period.
Beginning Cash Balance
Taken from 6/30/12 Balance Sheet of respective funds. (MUNIS reports dated 7/31/12).
Interest Income
The interest rate for all 5 years in the analysis period is projected to be 0.60%. Information
provided by S. Lemos, Finance Director, on 8/08/12.
Debt Service
P&I debt service for 2003 Sr. Lien Bonds (expansion related projects) taken from
amortization schedules provided by Stone & Youngberg.
P&I debt service for 2012 Sr. Lien Bonds (expansion related projects) taken from
amortization schedule provided by Stone & Youngberg and pro -rated by S. Seng.
Debt Service Coverage
1.30 debt service coverage ratio for 2003 and 2012 Sr. Lien Bonds
Capital Improvements
No capital projects were identified in the 5-year CIP dated 9/01/12.
A-5
APPENDIX B
Preferred Financial Scenario
B-1 Enterprise Fund
B-3 Alternative Water Resources Development Impact Fee Fund
B-4 Potable Water System Development Impact Fee Fund
B-5 Summary of All Funds
W,
O) CO r r n V
N Q) r 01 O] O O N
A O r f0 O ifl r
a CO
00 V'
�_
C M N W O W M
N O df 66 M Co
O W M O fp M N
O- O
O N
v O W
N N
M M co v N<
LL c
c
<
(A
1A
IA
IA f9
M A <t r rm
rn—MMO O M
M N Mw O
O
In O N <{ N O
W �_ '!l O N N
MO NMO
V M( O M N N V V
O N
NN
N N
N O
ar( (o
N
- O a-- N O M N
L n 0 O O V N( M O
O
N O M N N n 0
N
W N A r
V N M N O O M
V NM �(1
c In r M 0 O O P V"
N
OJ (O M 01 D7 M In O
(O
N W
t0
W
LL O v O W
N N
M W N M v N<
a
c
FA
19
M
M IA
C r r 0 N W
M Q1 r OJ V O O O
M A V [O O R O r N N
M O
O M
r-
LL G N O) r N 01
N O V N b W
'Q N 0 0 V
A N N In O r M r M
'Q '�f
W
O
M
NM
N N
M W M �
M L N M [V
M M
W OJ
O
M
W A
LL c�
`d
a
O
r n N M N
r Ol O O r
N N n r o O Q) M
O O
O
m
M Ld h m r M
W M M
O to �_ r M O N N
n M M M N
O Ol 6 d"i N
IA Ci
M
c
� � (p to O N N
N O � 01 O M r
W t1 O) Ql O M O Q7 � W
M
C
1D V
V O
N N M N N r<
V — M M (O
N 0 0 V
O NM
M
c c V M O N N r N
(D V M M W M 7 N
M N
tD M
N
W v
} CT— ' -
N N
M N M N
O
LL
ate--
<
f»
w
w
vi w
� u�m ro rn
N O N r< W
invmrnoovM
O O) r Ol M O O M
m N �n ono v'nrno
t0 N r W O V 0 (O m N
0 r
<
A A
N M (O O V A M
N a- OJ N O N r
M V V O V 'O a O V
V f0
lD O
O (D Lo lD (D
M O N m O co V71
M C0 r (D N O N Q] M N
M M
0p N
V V N
N N
N
Cq
M 4 NM
Y3
N
U
C p d
U d a
> d E L m
L O O d D a
Q�C.7 y C
d d
m 0 p p d d dd LL y
d d d C
wU' 'w+U LiLLLL m❑ 2'
E 9 O ° o 0 0 Mc
x d O m y c. >
m—> m m m E Q
m wmm:: cn y�mmaZi ,.�° o o,
U) (n (n U) 02 am
O C d d
u �`, 2a� a' m .mod. •r-
U)'- m m m m a m .m. `w `m `m E> o
ZN d d d dn. EF40aa-c ��( y9
ad+ lY y0 Y9 (Y w m d d J 3 J d
w m 0 0 0 0 0 d~ 'O O O O a d L d
wR, i-w 0(D(70(7=05
0
U ❑^
N a.
y
y U U LL y C
0+ n N y d
U 3 d w
d N c d 0 y x d m y
0 LU
N WCl) a O d 9
U m❑ C W C` y
U)x m ` c
Z W@ y> A C 6
UX
mW E rm m❑wy3m coavi o `p
n E
c
O
O Z c0 M.6W
QOy dsO
C E�0
o
o � ErnM f Qw RoR
d UUUdIrO aa O� E U I- O F�0-
B-1
A
m m M (O M M N
N
0 0 0 '
O
m
M M
m
— O c r m 1 N
h
0 0 0
O
O
M O
M
w
' m M V N 1 N
M
0 0 0
O
N
(O m
O
O
r0 (n Mm r06
CS
000
O
0
Mm
M
N
N m N v M W
A
M N m
V'
0
W M
W
LL
(W0
M
V7
V
H
H
H
H
H
H
O
W- m N N M
W
00000
O
M O
M
I
I N O N W O
w
cocoa
O
M O
M
(0
I r v M N I '
N
00000
t 0-
m
O O Moi Nr
v
000((>(9
Cli
Oi M(O
N
(0 VV W O
V
M (0 m N
(O
m
(�m
m
N N m M
w
O,
N
O N
O
Q
Z
W
H
H
H
H
(A
H
U
m
9
m O '0 O m M
O
00000
O
M O
M
J
C
N W i moA
00000
'
�cM
Q
V
' m W N MV
;r '
M
00000
I�
m
U
LL
C
W O W O) I�
w
0 0 0(
w
w
� M
m
N
M m m V m 0
M m m W
N
O
m 0(
z
C
u'1�I��mM
N
NOD
r
mnm
Q
z
-
q
LL
e-
M
.-
�r
`.
r.: -7
N
LL
y
❑
o-
O
W
K
H
H
H
H
H
H
W
O m O N R
N
cocoa
N
0N
M
LL
M
M m M m I� O
M V V m V'1� 10
0
O O O O
cocoa
O
M
1.
OM(
Nrr
W
0
(7 17 47 M O N
O
O O (n (n
O
(O
N (O
m
LL
N
(O Vm o m
M N f� N
w
m
M N W -
O<
m
m
V
m m
O M
m
m
H
(A
H
H
H
H
O O O O
O
a
O
O N (0
N
O O O O
O
( O
I� m
0
N
m m 0 W( ' '
W
0 0 (0 O
(0
W
M W
c0
M- O W M
N
W N Ilic O
w
M
Cl
N
m (O m m
N
O m O m
m
M
m
w
m
m
0
W O)
O
M
m
Of
0 0)
o
O
H
H H
H
H H
r
n 0
C
O
O O
m
d
N M
p N N p
E Q
N
LL d d LL d
d
c
y c� C5 U m E U
m"oomEUn)
(n
bJ
Q
c
c
o
wcw �drnad
06
V
m x CULL' W x
�`
F W N N d y W d y❑
O C C
C
a w w w
LL E c"
law d
c
7
d o 0 o ,Ed,
c Mm
A
m
y
0, m m m d
d a d
cd'E
E
E d
,d.a
wodxxc0ccr
E_
o
tod
3 N
V mC H H J m J J d
N W O 0
x
N N NQ �Q Q L
O1 d as a
d 9
W J LL J LL LL
d N E
R
C R V
A
x U U
yinHwwIL
N N w
o� c d-O
m
.c rn
ta
W MW o
d 0
oLL
o(LMCLMMLLMLLf
oiim>Ui-
z
mzw
B-2
W,
z
z
w
U
y
J
Q
U
Z
Z
LL
w
It
w
LL
w
a.
a
mm
vcoom
o0000
r m
m n o r rn o
m
� CO
W Ld O
l0 Y1 O fD N O
N
N
LLN
N M
�
f9
1R
O M
M V O r 0) O
O
Ifl V'
0 V V
OD N O r V O
N
c �
� or
n m oco �oo�i
N M
v
M V N
a In
N O OJ O W O
In o �
n
a
LL
N
N M
»
w
mm
v
�� oolno
C W
W V N
CD N O (O N O
N M
V
M M N
V N
N T OJ O r O
N to
i
N
N N
LL
M V
V N N
V Ono O r M O
LL
N
N N
M
�
N V
V V N
16 M r� O
o mm
olovo
N V
V N—
Mv
m r 0 O
LL
N
N N
H3
1R
In
o
0
0
o
co o
co
o�v
ni
o0
o
ror
M O
V
V
n
ro r
V
F 0K< O0F
B-3
rnkn
mmw
N
N
N
c N
}
LL
C
m
en
N
N v
�
v�
rom
rn
ko
N
c N
IL
O
}
N
LL
Q,
w
N y
m
m
r
n M
J
E
V
01
W
Of
M
M
N
M c
N
Q
n
U O
O
kCi
N
LO
N
V
N
N
z
LL
z Q
LL
❑ E
w
W y
M
M
m
W
O
LL
M
mw
mae
r
W
O
N
N
Ld
Y1
�p
C
N
N
c N
3
}
N
LL
a
0
0
ll.
E9
t9
M k
N
ro
M
C)
N
G
�
N
OCT
O V
LL
EA
k9
H k
d
C
N
W
N
�
N
O)
E
v
y
d o
w
N
N
> >
Z
6
�X
a
w
d
add
jp N
t a
E C O C
X
W
m
C
USW
N
Z
N
O n O n
H
a
m m
z
W o 0 y a 0
O
O m
> > ys N.'9
W
A
Oa
ai
w 0 o
w1) O- F
a?
OzF
o
r
n
N
C N
N
r
n
kn
rrnm
�v
a
M
mr
N
hl
!A
V1
M
fA fA
f9
N
N
O
ro O
r
v
v
kn
rn m
r
ri
ce
o
r
N
N
W
m ro
M
M
V
V
N
N
kn
w
w
EA �
sv
01
!n
1p
M (O
N
�
YI
N
O N
ro
01
kn
W
ro ro
kP
N
N
W
m m
m
N
N
vi
w
w
EA k»
v3
M r
m
o
ro o
m
ror"
nrn
m
m
leo
W N
m 0
W
v�
ko
v,
rnvin
N
N
yr
vi
w
EA k»
EA
N
N
DD
m m
O
(MD
kMD
M
M M
00l
19
k9
(H
f9 f9 f9
O -
O O
N_ N_
N N
@ 0
N N
K �
V
c C
0 0
2
N
N
N
O
O
o. x
w w
ku
y a c
ku
c d
❑
zN.00
a
Aao
w w
E
O H
O
A O
E
m E m
Vmm
>.
0 0
ii
�LLm
c c
y
J o c 0
ku
U N z
5 i
LU
m
O E
Fv n
3
W�ao
m
Em�
W
F
W cZj q$
O
m O
d
W N C
❑ a a
F
O U F
z
m z W
B-4
W rn m N M r
m V M
m W 0 0
O0,
m oM,
o
M
MM-fMVW
nmoo
c
t0
V N
w
MN .-,TO' O
N
?
M N N O O-i
v M
w
i0 N M M
-
W
0 M ` ui rf0 M
w- O
Ci W
N
M'
W W N
b
N M O r
O
O W N W r W
N W
M O
LL
O N
� y N
T M r
� a-
N
�
NV'NVM
N
�
N
�
O r O r rn -
M M 1--
0 W
b
m r
T
H
H
H
H M
O
N W N rn W W
V V r
a0
W W O r
m
V
W W o M O O M r
a N
N-
M V V r N rn
V r r
0
M- O W
M
T
M u O M W o V W
A V
V N
N
rnN V N(Ou
N-u
m
W V NMO
O
00 OV W N V
M NN
-
vr W W r
V� <0�r
N W M V
11
C
rn00a--N N(0M
M
N M O r
V
w
r �- O N W 10 O V'
o
w r
0
LL
W N
O N
W m r
N -7
0
N
NV N
N
1
N
Is
W r M 0 .- rn W 1f1
N M
N
0
w T
Oi
z
Z
W y
H
H
w
w N
U o
OW O r
0
O
W W � O r N
0 N
N E
J LL
r r 0 �0 rn
O r W
t0
rn O
N
QJ
V O O W O r N
M V O N N O M
O
v V
O A
U au
O
(V rn r V W
N - rn
tC
a0 W M rn
tC-
N-
LO of o r N t0 O f+l
O- Na
M
fO V N W
N W W
A
N M O r
V
N
N M O r c W r
A
lww
V
Z
N
A M W
N
A
V
N V a0
r
N C6
W
Ol
LL A
wEH
w
w
ww
w r
Cf W
V O V N W rn
A V
N
W W O O
N
V
O O O W
N N
N A
W
r r N M r rn
N r
w
M 0 0
f0
1� r 0 W O M M
O W
w w
a1
M
(6 W r N r
A rn
W
W V N M
W
b
M W O rp W N
CO -
h M
Ld
1
NMOm
W
W
IT
N
W
a
N
aMN��NM(r0M
N V N
A
;%oCo 00�,w
o M rn- W M V
V W
N
W N
N M
CD
Ci
H
w
w
w w
r
W LL� W r W rn
N v r
b
W W O
M
m
N C O lfJ l[1 O 'V N
10
� A
u�ONra0mf0r
W
N
�"M
0
r W O�rOf0rn�
ww"
N
W W O V M W
��MA
W
W V NMCO
w
N
.trONa0 �.-Ot0
W
NN
a
L6a-a0 My N
MW
a0NM
O-
r_f0 N r_ NT Mm
w
W w
N
V •- V N W
O W N
M
N M O
W
A
V N O V N W M
W o
O W
LL
N N
O v N
M M f 0
N-
N V a 0
N
-
W
'
N N V rn W N
N M
O r
W
A W
W
H
w
w
ww
d
d
u
C y
� U
�
m
>
y
m
o y t E
0 0 d c
y
tg L d IV
C
00 + 0 y d
N
Oa
a w
0
c9
N
wd
? E 0 E
EO
W y
C.00
xV
D Od0
LL a+
w
rn
9 d
d d d 0'
O.
m x
rn
d m v a C G C, d
2
N
E E
y y f/l y
d d d d d
LL d+ l U) d
O E 6
w tM
N y N CO d Y
�� W
�._
•d e
y
n n nin E
as
o 3 0 `d N
c �d
c1
W
0.l3 o A..�
U a MO d m c'
6
3 w y
m da m
adna3'
md
d d
E=
d
U y
c
d
oRj rn
LLJ
' dm
td_�Ea_rum
tm
ooc�i
e6'6
O
d
-
am
—
Oyd C
cCO
UXa E
waa—a'm o
o
ma19=°mm0
�
ax
E2a d
a: C9(99h(D x
3:aaaa
OaQO-
O a
aOa.011
3L) 0 ci 0wOi-F-
B-5
A
W rn M LO M M N
N r
A
N
N
0 0 0
CC
V
0 0 r rn 10 N
A r
' V
A W
V '' 'p N'
A
O
N
GI
0 0 0
0 0 0
0
" 0
0
0
N
O
13�v r W
0
M
n N V
M
N
0 0 0
0
0
W
N
o o v w
'O V O W
M
m
Ni or
v
u
M 'p W
O
a
V
LL
N t p M
N N
A M
of
M M O
V
N
N
V
N
r
H H
N H
H
H
H
H
H
w
W -O) NO M
M V
V ON
N
V
000
0 00
S
r NON W' O
t 0 N
N M r
O
0O
O O
O Co
N
'
N ' V
V " r M '
e-
A
000
0100
0
C
O O t h O i N l l
a r
r W.-
c
Ir
O O O
N O
N
N
N
N V V W O
V N
N W o
M
O
Moo
N CO
A
N- N- N M
10 00
no
It
a
K
Q
Z
W y
H H
N H
N
N
H
H
H
U a
W e
��.
W O 'O W W M
O rn
N N V
A
b
O O O
O
O
r
J �y
V
A
'
W
"
Yl
ao
O O O
O
0
W
Q-
D W NMVO
W W N M V r'
M rn(
MM
M
W W'
A
O
0 0 0
O"
O
V
N
O
W O W Oiwr
10
W
N
N
O O O
N
N
w
N
M- W- W O
N
N"
N
N 0
N
A
M �O W
W
N
W
Z
Z
Q O
LL
-7 'OM
.-
w
cl MM
M
n
M O
V
N
n
W
W
d
Zr
LL d
o E
W E
H H
H H
N
N
H
H
H
� O
K N
0 W O N- V
N M r
0 M O V
w
w
000
O
O
0W
LL
th
MT M W r O
M V V W V r"
M Now
O r M
N �00
w W' O M '
O
O
w
A
000
000
O
O"
O
O
O
N
W
K
Oi O CIZ
rl:
0" O OiN
NWO
eF
o
N m—
M
MOoOWN
W
>
Ir
�
a-
LL
H H
w H
w
w
e»
H
H
'O
V rn r 0
O
fp
O O O
O 00
N
W W 00M"'
M 06
t0 V' N"
M
V'
0 0 �Il
O ow
t0
w
c0
M N CT W N
N N
lx
N N
N
0
V
o
O
C
N
N
W WW
N M
M r 0
D O
W
0
A
VN-r-
W W
0 won
A
N
rn .-
rn
H H H H N
N
H3
H
H
d
d
d
C
c
N N
O � O Z w a
N
c p' d 7
E
y E 0— E ++ d d cry
a
Td c� d do_
d
°i
min cdiUin E V oK 0LM an.a W
d
p
M
co co M E E C o o m w w w d d a
Q
N
E c` c aEi E E y 0
Z
d
xi
y
fd Gxy d >G y Nx@xdd N
XN O6p�0
W
rn
G
yc
ma
WKm>n
d
a
`Cy
w NC WW pK 0
N
yN
0
O
0
>
Q
a
arwC
00
EuKNGddi
0 0 W Way y y y d
CO m '0%o c c
E
E0
E
m mwmw3
mm m2
C a
E u
E2
NdL�m
d
3dm
~
d ~JJJ
W
.?MocCO
a
O
LLE
daad
O0
JWy
Ny
Ny LLN
dd in3cX
C
p N O
u fLwU))IO
OK
0m(niww
0
¢add°dd.
x
m
n w L' 0 TsOa°O`.
coaaaaaaa(I CLIL oaaaaai°
12
022>ci �
z
B-6
W
L
1
U
_T
t
C
E
E
0 0 0 0
C
A
M V'
O t O 1 V'
N
O
fA
W
N
A tV Y)
fp r
N
W
LL
A
M
tp
0) A A
� N
W N M A
V' N N N
f9
bi
di f9
fR fA
a e e�
tD
ON
tM W NN
e
006
� O
to
al
oc M
W 1
VNN
Cl N
M O M
M A N
N N M
1O
N
O
N
V
M w
W N
N
m
N
W c0m
-
V V (V �
Q
Z
W y
M
to
fA di
f9 di
U 'a
A
M
m
Q LL
V
0066
N
tD VV Cl
NA C''1
V
{V
U l0
O
M
O
N W M
tM m M
Z
N N W
0 m V' M
0
LL
t0
c N
N V7 N N
Z
LL A
p E
W E
LL
M
o O C 0
O �.,
oc
M N W
A N W
t0
N
0
0000
N
N
a
LL
A
O
t0
M N
C6 M
N N N N
r th (V th
M
«i
f9 f9
(A fR
O
r
O
N
N O
r M O
O Ct M O
N
O O O
0 0 0 0
M
c
M
N O R M
O
V
N o
O
W NON
N
two
N
O
LL
w
t0
O N M
L6-7 M
O N M M
W N IV M
IA
1R
fA fA
69 M
41
v
Fi
01
o
y D
C
U22
O LL_
6
W y
o
E
2
y
X
O
M
E
2 0
o
p
a
E
w
O E
m
C
M w
d
d
❑
U
e
G
E
C
16LL
E y
C
p
E A
d d N
d
A a
U
9QrO
N0.2 LLm
W
Z
y N
L
U�
ALL
U
,
M
N
O O N
U c
d 0)
U 0 y
IL N m C
x
?
y°�'
EaV
ofd
m
s
woo
m m
do
N
a-
W
ow
j a m
o
m
O
,c m
m❑
a m
D o m
o
d 0
u W
u m c
n 3 3 o
o o
O a a
0
S .S
K D
❑ o
m z w
O¢ a H
V U
B-7
APPENDIX C
Preferred Financial Scenario
Rate Schedules & Tables for Bill Comparisons
C-1 Potable & Reclaimed Water Rates
C-2 Tables for Bill Comparisons by Meter Size
ORO VALLEY WATER UTILITY
EXISTING RATE SCHEDULE - NO PROPOSED CHANGES
POTABLE WATER RATES
MONTHLY BASE RATES & COMMODITY CHARGES
METER
SIZE
CURRENT
BASE RATE
(includes 0 gallons)
COMMODITY
TIER 1
$2.20
PER 1000 GALS.
COMMODITY
TIER 2
$2.99
PER 1000 GALS.
COMMODITY
TIER 3
$4.03
PER 1000 GALS.
COMMODITY
TIER 4
$5.38
PER 1000 GALS.
5/8 x 3/4
$ 14.19
0 - 7,000
7,001 - 16,000
16,001 - 32,000
over 32,000
3/4 x 3/4
$ 21.29
0 - 10,000
10,001 - 24,000
24,001 - 48,000
over 48,000
1
$ 35.48
0 - 17,000
17,001 - 40,000
40,001 - 80,000
over 80,000
1.5
$ 70.95
0 - 35,000
35,001 - 80,000
80,001 - 160,000
over 160,000
2
$ 113.53
0 - 56,000
56,001 - 128,000
128,001 - 256,000
over 256,000
3
$ 227.05
0 - 112,000
112,001 - 256,000
256,001 - 512,000
over 512,000
4
$ 354,77
0 - 175,000
175,001 - 400,000
400,001 - 800,0110
over 800,000
6
$ 709.54
0 - 860,000
860,001 - 2,000,000
2,000,001 - 3,500,000
over 3,500,000
8
$ 1,135.26
0 - 860,000
860,001-2,000,000
2,000.001-3,500,000
over 3,500,000
RECLAIMED WATER RATES
MONTHLY BASE RATES & COMMODITY CHARGES
METER
SIZE
CURRENT
BASE RATE
(includes 0 gallons)
COMMODITY
TIER 1
$2.20
PER 1000 GALS.
COMMODITY
TIER 2
$2.99
PER 1000 GALS.
COMMODITY
TIER 3
$4.03
PER 1000 GALS.
COMMODITY
TIER 4
$5.38
PER 1000 GALS.
5/8 x 3/4
$ 14.19
All Usage
N/A
N/A
N/A
3/4 x 3/4
$ 21.29
All Usage
N/A
N/A
N/A
1
$ 35.48
All Usage
N/A
N/A
N/A
1.5
$ 70.95
All Usage
N/A
N/A
N/A
2
$ 113.53
All Usage
N/A
N/A
N/A
3
$ 227.05
All Usage
N/A
N/A
N/A
4
$ 354.77
All Usage
N/A
N/A
N/ A
6
$ 709.54
All Usage
N/A
N/A
N/A
8
$ 1,135.26
All Usage
N/A
N/A
N/A
Groundwater Preservation Fees - Potable
Groundwater Preservation Fees - Reclaimed
Construction Water Rate - Potable
Construction Water Rate - Reclaimed
C-1
$ 0.95 per 1,000 gallons
$ 0.50 per 1,000 gallons
$ 6.38 per 1,000 gallons
$ 2.20 per 1,000 gallons
P
ll
IrlI
`J
Z
O
In
a
0
O
U
W
w
U
Z
I-
Z
W
U
LU Of
W w
06
EL
W
co n
W
0 "v
Cr M
Qx
2
U
J Q
2 =
Z
03
�M
a w
O 2
W p
CO CO
J I-
Q 7
F- U
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
J Z w
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
LL,N
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
F-
z
LL
Tcl
O`d'p�
R
m'at
N
N
NO
N(O
O
N(O
<NON(O
V
N
N
V
NON
Q}
�
V
N
I�
m
O
N
�
�
O
O
m
q
OR
N
i-
r
N
(O
N
(D
N
��
to
�
U
N
V: ��
7
V
V
M
r-
J�=J
V
I�OMWCA(h
W
Op
W(V(DOi
MI��
W�W�W�(O�
W
(O�W�W�I�
m
0
Q 0
>- w
00000000000000
00000000000000000000
o
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
6
0
6
0
0
0
6
0
6
0
0
0
0
0
6
0
0
0
6
0
6
0
6
0
0
0
0
0
6
0
0
0
0
0
6
0
6
Q= Q
o
0
0
Z LU
O w
1- 00
� Z
LL
O
O
O
O
O
O
O
O
O
O
O
O
O
O
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Q N
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ZQ LL
LLLLII a
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
O
i z
Z Z
O
O
In
O
l(I
ONO
N
O
�I1
O
M
O
(n
0
ONO
(n
0
(n
0
0
to
O
N
O
(n
0
(n
O W p
O
MgNN
r
(O(O
N
77
M
('M
NN
-:00
q
CAN
NIA
rN
Nto
LL]
V
M
W Q F
OO,
NM
V
(nNr
W
M
C14
M
V
(n
W
I�NCA
W
O
N
N
fV
....
ai
V
(n
NC`N
N
N
N
CAO
N
M
M
� 3 j w
O
W LL
O
X O W
IL w w
� a
O
O
O
(A
o
(l
O
O
(n
O
((1
O
(n
O
(n
O
(n
O
(n
O
M
O
(n
O
(n
O
(n
O
O
N
w 0
00101N
N
1,
r(O
(O
N
(n
V
'1�M
MNN
0
0
m
w
Nhh
(O(O
v
vm
r
Q Z
OO
—
<V
M
V
co(�
1`
W
W
Oa-(V
M
V
(O
W
IN
N66c;
N
M
V
(D(O
1�
oD
OiO
W
W
W
CY Z W LL
W
O
U w
a
�
O
e
e
e
e
o
0
0
o
a
o
0
o
a
a
o
a
o
0
o
e
e
o
o
e
e
o
a
a
e
o
a
o
o
e
Z W g
o
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
U
o
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
w Ir A
a z 3
LL
o
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0LLJo
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
F
o
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
�z3
Q -
WIQ-
Cn
CA
CA
CAMNm
MN
f�
N
M
N
OM
NfnN
�N
hhh
71�
OMNm
N
(ANN
❑
w
�(M(n
rO�
M(N(O
N(n
0.
N
Lq(n(n
Lq
Lq(n
N
N(D
N
N
OR
N
M
W
OM
K
V
W
W
O
N
(fi
I�
W
(V
(O
W
—
V
O
M
(D
O
V
W
(V
W
0
V
W
N
(O
O
V
W
NN
CO
0
CO
LU
o H
a 4
a 3
W
CA
CA
W
to
CA
W
Cn
CA
N
f�
N
NAM
N
OMN
ON((�N
n
�I�OMN
CAN
LL)NN
m
M
N
(n
M
LqU�
N
(fi
m
4?
(A
(O
(O
N
N
n
n
N
N
N
N
Cn
M
W
M
Z
--NON
N
r
m
N(n
N
V'
h
O
MN
Od'
W
N(DO
V
OJ
N(OO
V'
N
N(OO(D
W w
—
W no
W W
c�i 3
0
0
0
0
0
0
0
o
0
o
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
(�
o
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
z p
Q W
o
0
NM
0
0
7NrN—O
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
N
0
M"NN"N"M
0
0
0
0
0
0
0
0
0
N
M
0
M
J M
Q D
N
N
N
N
N
N
N
N
N
N
M
M
M
Q
C.-2
I
,I
U
1
O
0
z z o
Z Z o
OOOp
J (�() W
U (9000
'
O O
Q O N Od Q
a U)
o o
0
O O
N Q
� K R K
0000
w
w
U O W M 00
Z No) o M
r CV IV 'i N
Z
Kw vi b9 b9 fA
wW
a2
v if u u n
¢
00 M < N M V
w x W W W W
1
Q M r r r r
2 a rn
U 2 N
J ' N
Lij
N r
b9 g
OO Fw-Q
l
�0
W
J
m1:U�
F-- U
U. 00FU
\°
r w
Z
0
00
0
0
0
0
LLI N¢
0
0
0
0
0
OKW
r W U
a Z
O J
O
N
M
r
t `
W<
M
Q r 2 J<M
co
O Z m
N
V
O
N
N
r00
Y w
00000
o
0
0
0
0
a= a
0
0
0
0
0
O Z K
roz
0 W
o
0
0
0
0
Z �ryoo00o
a
U
O
2 Z
Q —
W Z
0
O
(Oo
7
f0o
N
I-
y a Q
O
co
ocon
<
N
a Z w
Z LL
O w
a
� �
W Z
o
CR
V:<OoM
r r
z a a
OcdOcdr
<
N
V
w
w
y
U 0 w
a
�
O
o
0
0
0
0
Z W .m.0
000
0
U In
O
o
0
0
0
m
a z 3
0 W m
r
z �
O
Ja
2 z 3
¢ -
W❑
= W
O
"W
W
aD
N
n
N
M
D
M
I-, 0 F
N
'Od'
O
oNi
J 0
J a.
m a
W
r
m
N
O
to
O
n
N
M
tO
F F
N
M
't
O
m
w
J �
U
mto
0
0
0
0
0
Z z F
O
O
o
C
w 0
r<NLLOO
C (n 2
U
U
Z
0
Q
U U o
Z Z o
000�
J W
U C7oo0
N O O O W
Q O V m a
0 O O J
O y t
op
0000
z N N O M
Z
w
U
wwc».nus
a
Qw II II II II
w H < N M V
W
(w') W W W W
=a00
�3di
r
M
fn
0 aLL a
w U W
m f)
�09OU
o
e
e
o
e
J Z w
O
O
O
O
O
y
0
0
0
0
0
W
FO
o. Z
O Y
Q)
w
M
�
N
OD Z m
M
N
N
r
N
r00
¢
Y w
y
0
o
0
0
0
0
0
0
0
0
J=
0
0
0
0
0
O Z K
r2z
0 y
o
0
0
0
0
ZQ LL
LL a
0
0
0
0
0
(.)
O
2 Z
Q —
p W Zp
oN
CR
O<M
LLIN a Q
o w
O
--
N
M
V
p
O;WLL
N
a
rc z
� a
F Zp
0
ON
o
n
co<<n
o
0
r
Z a Q
W
O
N
M
LL
it Z W
Uw
c7 a
r w
o
0
0
0
0
Y
00000
U Q K
0
0
0
0
0
W Lug
q
az3
0 W m
rco A
Z �
i z 3
=w
vcooro-,crom
r 0 W
N
O
N
c<
r O r
M
p
M
o
J O
J Y
m a
w
r
F Z
mmoon
gcor-mrn
0
O
u�
W
F
b
M
(V
r
Q
J �
[L
O
O
O
O
O
Z Z r
o
0
615
OO Z
aCO 0
oraoo
<
N
M
N
D
U <
C-3
N
z
O
Q
U'
U o
O
Zoo
Z OJ J O
0
J (�O
O C7oo0
fA OCT CTO W
Ix Q O MLci
O Q
a M
o a�D
0 o J
O Mw<
w
U cc w w
0000
U orn M OO
Z N W O M
r (V N q u
Z
W
Kf»vJ fn f»
W
aLU
p W
F-
Z W II II II II
Q N M t
W N W W W W
2� F-rrr
U 2 w _ J3o
1toW
J 2 2
W U UJ N2
ma'g
�OQLL MO
eves°
r w
O
O
O
O
O
Q W co
0
0
0
0
0
W
U
a Z
O J
r
u)
M
N
O
000
V
n
w
Q S J
0
M
u)
W
CV
a j Z m
n
rn
N
v
vo
r00
Q
Y W
0
o
0
0
0
0
0
0
0
0
J¢ = ado
0
0
0
O Z K
~
z
z
OW
O
O
O
O
O
Z¢ LL
ILL a
0
0
0
0
0
U O
O
2 z
Q
p w Zp
o�
mu0i1�-
N Q Q
OM
COO
o00-
d Z LL
N
a o
s
r, a
W p
O
O
O
O
OJ
O
O
u)
1•
r
r
Lu
oM�mui�
U O w
a
�
p
r
o
0
0
0
0
W«
W��Dd000
o
0
0
0
0
L K
a z 3
LL
ONs
r��
O g
a z 3
WO
M
T
N
W
w
O
a
W
m
c0
r y W
0
co
V'
cV
M
r O r
r�
N
M
to
J W
m a
W
r
F Z
u)
rnrn
N
O
to
O
oo
u)
oo
O
n
c
M
N
M
Q w r
M
N
M
J
J
O
L
0
0
0
0
0
ZZF
000a
M')
(`
CD
M
C-4
QN 0
S
O
N
z
0
O
U) Z o
ZOo
0 J U)
J Q 0
N
S60W
LLI
O
C7 1 d 0
D
LL
O w o W
O C-4 N U
O
�ooD
' O J
O M N Q
y
K w
Q
0000
to
LLLLLLLL
K
U
z
O W M W
N M O M
r
N N N
z
W
U
W
IL
p
Q W
II II II II
N M
W ..
of w
.
W W W _W
f V
r r r r
QW
Q
= M
}~�J
M
W
fA
22
O y rQ
K�
p
W C.)LU
m 0 y
OU
FQ-aro
oa000
J ZW
0
0
0
0
0
N
O
O
O
O
O
Or CC
W
M Z
p
M
I R
CR
r
N
J J
r
u)
OR
cO
7
N
Q 2 J
M
M
M
r0 Z
NN�(�O_
O m
r2�
Q
Y w
0
0
q
0
c
0
0
0
a=
o
0
0
0
0
Z LU
O w
F O U
O W
O
O
O
O
O
Za LL
1ILL a
0
0
0
0
0
70 U O
2 z
Q _
0 w Z 0
o�c0o,
Lqr
cn Q 6
O
N
N
M
O
O o> w
N
M
0 M w
CL
c7 a
r W o
O
O
c
O
(D
0
u)
U)
r
O
M
N
W 3 Q W
N
M
LL Z W LL
U � �
c7 a
p
e
e
o
e
e
Z W
0
o
0
6
0
6
0
6
0
6
W W WO
w m
W z 3
p W
m
A
r
z �
O K «
az3
W O
M
n
O
cr00
r N W
M
M
N
M
M
0 r
Q
N
V
rn
M
m a
W
NnO
�00
FZWMM04MM
Q WF-
N
V
m
M
�
J
J 7
U
m
O
Z z F
0000
Opz
nob
O
N
.
Q N
O
N
M
O
C-4
�i
1
-1
1
N
Z
"1 O
I
0
Z Z O O
NOOo
N
Oa LU
u
1 Z iJ 00�
J O
-Q� O N N Qq
N_
1 O OWN a
LU Of w w w
0 0 0 0
K
U O O M N
Z N M O M
r N N V Lfi
Z
W
d' fH fA fA f9
W
a
QW II II II II
W N Cl) V
�� wwww
Q , Prrr
=ate
J ' N
N
2 Ill
fA
r
O 0 Lu
r
LL wv�2
R ] 0 N 0
Q LL m 00
e
e
o
e
e
r W
0
0
0
0
0
J Z y
0
0
0
0
0
w O
0O
a Z
z
O J
N
N
n
M
M
O
NU�
M
CM
Q r 2
Z
V
m
co
N
I- r J
7 Z
N
O
N
w
w
0 p,NMnMM
r
N
0 0
Q
% W
0
0
0
0
0
0
0
0
0
0
a=a00000
w
p Z
~
Z
2
O N
0
0
0
0
0
Z a LL
IILL a
0
0
0
0
0
00
2 Z
Q
w Zo
ovoi
oo
❑
Lq
h a
O
r
Q
3p
'nd"Nd'
CC
0 > W
u
N
V
O H
a
rc rc
0 a
ZO
0
0
0
0
0
w
r
O
O
M
N
V
O
N
O
LU
W Z w LL
U O w
a
0
❑
�
o
0
0
0
r g
w
o
0
a
0
0
0
ci
V W A
LU Z 3
LL
y S
rO
O w
Z 3
Q _
W ❑
u'i
�nnMM
2
O
O
O
M ,
Cl?
r 0 w
r
r
h
r O rN
M
OD
00
M
0.
N
M
lA
O
N
J O
J jr
m a
w
000c�M
N
n
M
M
r w W
N
M
W
W
m
a K
�
N
M
O
O
O
J
J
U
0]
0
0
0
0
0
z z F
O
O
O
O
0
m
a m
M
U)
Z
0
Z Z o0
N006
0
0za
LU
Z
U O O
O
O V W LU
0C
0
Ld J
U
O VO Q
LLI
0 0 0 0
K
U
z
o M M m
N O o M
r
N N It U)
z
W
2'
b fA fA M
W
a
❑ w
Q
II II II
IIui
H
N M V
w
W W W W
=an
U = r
M
N
r
0 LU
00 r
p
w
VU
J
m0(n0
ar 0 QU
O
\°
J Z w
O
O
O
O
O
LU COO
OO
OO
OO
OO
O K
rwL)
a Z
n
N
N
N
N
J O J
r
n
LO
M
N
0
2 J4
Z
C6
Oi6
r J
7 Z
N
M
M
M
C M
M
N
N
O
O m
r 0 0
Q
-
N
M
V
LU
O
0000
0
0
0
0
0
<= Q
o
0
0
0
0
Z LU
O w
~
Z
2
OLU
O
O
O
O
O
ZQ W
I9 a
0
0
0
0
0
U
O U
z
Q _
w Z0
0
o
N
o
N
❑
w a
Oui
N
vin
j
N
W
D O IW
t00
O 5 w
4
a
w rc
O a
w=
O
O�
O
Z 6
O
w
N
O
NI,:
N
F
W i j W
N
IN
(00
M
LL
M Z w
U K rc
C9 a
❑
e
e
e
o
0
Z Ws
o
0
0
0
0
LLI
x
0
0
L
W
a Z 3
0 w m
r Q m
Z ul �
O Q d
2 Z ;
Q
W❑
n
N
N
N
N
2
n
M
O
N
0
r 0 W
>
r
M
rM
0(NON
Q a
J 0
••
N
IV
M
J fL
M a
W
n
n
N
Un
N
O
N
in
N
Un
F Z w
v
M
M
rLLI rM�
O
CNON
J ?
N
N
M
J U
[0
0
0
0
0
0
Z= F
O
O
O
O
O O Z
O
O
O
O
Q N
M
n
CO
C7
C-5
_,
U
Z
O
J
to QO
Z
zOo
Oro
a o
< Uin
z
Z
O 0 o M
J o O LU
Q O O W
Z
C70o%
ooaiW
O N O
a
O
000�
O
U
O O J
O p o J
M N Q
W
�
v z
0000
LL LL LL LL
IY
U
Z
o rn M m
N W O M
N N V LO
Z
W
W
a
❑
QW
II 11 II II
N M V
W
W W W W
w
io
F- F F- F-
=a22
�30
r
N
111
V3
w0Lu
}
oyeQs
L U w
m a (1)
LLm
OU
FQ
a
I
o
e
e
o
Z W
J Z
0
0
0
0
0
LLI
a Z
z
LL }
O J
N
N
Q Z 2 J
Z J
O
m
0
0
0
H
0 Z
Z
0
r
v
o
r
rn
v
rn
rn
O m
F X. 2
Q
Cirri
} w
O
0
O
0
O
0
O
0
O
0
= a
o
0
0
0
0
O Z w
~
Z
O w
0
0
0
0
0
Z Q W
IILL a
0
0
0
0
0
U O
O
Z
Q
❑ F O
o
o
0
0
w a
a
jai
o
L6
°Z�LL
O
vrnvrn
O
N
O
W
a
rc z
c7 a
Wo
0rl:000
F
H
O
G
V
m
7
W
K w
O' Z W LL
U z W
� a
F- ❑
o
0
0
0
0
W«
o
0
0
0
0
w W rc
o
0
0
0
0
W A
aZ3
LLO W y
z m
Z �
p m
00
3
wp
vvvvv
N
F- M W
M
It
O
O
F- O F-
Qa
0
r
v
CO
N
O
e-
m
e-
O
K K
1Mv
tO
J
m a
F
F Z
a
O
O
W
0
Or
J?
co'
1
OmO
M
v
m
O
tl
z z F=-00000
O W O
N
O
O
O
a M
v
0
!
O
N
Z
O
J
J
�
z o (D
0
Oro
0
O
o 0 o C
J o W
Q O O W
0 o o LR
U) o 4 0 w
O N 0
O
a 000ai�
O O D
0
OU o m o
W m N Q
Ix w x w
0000
W W U. LL
K
U O m M m
z N O O Cl?
F- N (V V m
Z
W
U
Q' f9 tH fA 64
W
a
❑ Q
QLU II II II II
N M
W W W W W
Qao F- F- F- F-
= a o
U="
} F m
J3
Z O ~Q
v� K
F
W
oU 22
F OLL m O
O
o
0
0
0
0
J Z w
0
0
0
0
0
m
0
0
0
0
0
0a�
Z
O }
CO
moo
J
z 2 J
v
N
N
N
0 7 Z m
m
a--_
v
M
M
M
F-Q 0
Nvom
w
0
0
0
0
0
0
0
0
0
0
-
J= n
0
0
0
0
0
U
0
O U
O
O
O
O
O
Za LL
LL a
0
0
0
0
0
U
O
i Z
Q
o
❑ O
0
0
0
w a
jai
o
vio
O G W
7
m
v
W
0 W LL
O w
a w rc
t7 a
0
F-F 0
Z a Q
O
M
o
Om
0
o
O
w O
a
m
W
V
W
a Z W LL
O
U w
a
F p«
o
o
e
e
e
z w A
co
o
0
0
0
0
s
U
o
0
0
0
0
w rt
a Z 3
0 W 9
a
Z ul
0 K
i z 3
Q -
W ❑
to
o
o
o
0
N
N
m
m
m
F' N W
vi
Otri
00
I-O F-�rvvM
Q
o
v
C
v
m
J
N
Cl)
I
m
0
m a
W
m
N
m
N
m
m
m
m
m
m
H Z
W
�[io
vio
vi
W
F-� F-�Ovrn
M
r
v
v
M
v_
U
m
0
N Z 2
Z F-
0
0000
0
0
0
O p Z
J W O
f j
N
0
O
0
O
0
O
a m
v
0
LL
O
0
N
C-6
w
Z U)
O
U) w
W
a
W J
0=
COW 0
QLL
Z O N w Z Z Z
(V
Wg
WW
a�
O
Qw n u u n
(nw NM d
= a v
>-30
Er
F
to
N
O Lu
O F p
LL 0
w w
Q 090
H LL U
0
e
e
e
e
e
W
o
0
0
0
0
Q W Q WQ
~O W
0
0
0
0
0
W
O
a z
J
�vvvv
In
In
In
IA
In
Q z 2 JOppOJo
Z
F Jp�OOOO
z
O7 mhNhNl�
~22
Q
`tNvu`ri
W
J J
2
p z w
~
z
LL
OafQ
O
z W LL
a
O
O U
i z
QIr -
O w O
LU
p
�0000
o
0
0
0
0
0
0
0
Oa. O W
004�0
O 7 N
a
rc
(7 a
Wo
�0000
o
W 3] W
It c rc w
M
O
N
O
w = W LL
N
U)
I.
O
U O w
K C
� a
O
o
0
0
0
ww�00000
V0) rc
o
0
0
0
0
m
IL z 3
LL
O W �
z K
_�«
$3
Q-
w
v
v
v
v
F w
�o0)
M
m
w
of
of
of
of
of
F F
0
o
0
0
0
0
N
M
J
m a
W
Z
�Z
�m.m0)ci
00000
V
a
V
wW00000
J 7
U
N
M
V
ro
p
N Z S
o
0
0
0
0
0
0
0
OJ p z
o
0
0
0
D
O
N
N
c-%