Title: Governance Study for the Florida Legislature - Workshop #2
CITATION THUMBNAILS PAGE IMAGE ZOOMABLE
Full Citation
STANDARD VIEW MARC VIEW
Permanent Link: http://ufdc.ufl.edu/WL00004711/00001
 Material Information
Title: Governance Study for the Florida Legislature - Workshop #2
Physical Description: Book
Language: English
Publisher: West Coast Regional Water Supply Authority
 Subjects
Spatial Coverage: North America -- United States of America -- Florida
 Notes
Abstract: Jake Varn Collection - Governance Study for the Florida Legislature - Workshop #2
General Note: Box 28, Folder 12 ( Governance Study for the Florida Legislature - Workshop #2 - Nov. 18, 1996 ), Item 1
Funding: Digitized by the Legal Technology Institute in the Levin College of Law at the University of Florida.
 Record Information
Bibliographic ID: WL00004711
Volume ID: VID00001
Source Institution: Levin College of Law, University of Florida
Holding Location: Levin College of Law, University of Florida
Rights Management: All rights reserved by the source institution and holding location.

Full Text


West Coast Regional


Water Supply Authority


Governance Study for the Florida Legislature
Work Shop # 2
Evaluation of Strategic Ownership Options


November 18,


1996


DRAFT
MKPWjVPeat Marwick LLP Page 1


r:~-i8~i~g"e~ I I IC"IIIC~I
~;'~ ~'' "' fir' ;. t ..


The AuaCi$s~






Agenda

* Introduction

* Review of Options 4, 5, 4/5

* Acquisition of member facilities

* Rate impacts of various options

* Key governance activities


MZ;P Peat Marwick LLP Page 2







Strategic Ownership Options
Strategic Ownership Options


Existing Water Contracts & Supplies


Master Water Plan .I Future Supplies


Option


1



2


3


4


5


System-wide service
(with no individual subscription or entitlement)


System-wide O&M
with Subscription
Service


-IM0: Peat Marwick LLP Page 3


Individual
member Existing contracts New sources
contracts dissolved independently pursued
dissolved
Individual
member contracts Existing contracts Subscription of supply needed
(status quo) (status quo) (with entitlement)

Individual
member contracts Existing contracts System-wide service
(status quo) (status quo) (with no subscription or entitlement)

System-wide service
(with no individual subscription or entitlement)

System-wide O&M Service
Subscription Service for Capital Costs
(with system entitlement)


4/5


t ----- -- --------------- -----~c~






Option # 4
System Wide Services With Uniform Rate

* Key Features
Contracts dissolved; Authority acquires members' wholesale
facilities
Uniform rates for all members & services

* All Capital and O&M costs are allocated to users
based on water usage:
existing Authority facilities
acquired facilities
the Master Water Plan and future projects


wK PtPeat Marwick LLP Page 4







Option 4: Expansion of Authority
System-Wide Services


Opportunities
* Encourages regional approaches &
alternative supplies (majority vote on
new supplies)
* Greater economies of scale
* Simpler management &
administration
* Enables system-wide financing
* Helps in equalizing costs among
users
* Unified strength/voice on water
issues


Obstacles
* Costs/efforts in dismantling
contracts & acquiring member
facilities
Cost impacts on selected
members
Loss of member control over
own facilities
Growth related costs are borne
equally among members


K- Af Peat Marwick LLP Page 5






Option # 5
System-Wide Subscription

Key Features
Contracts dissolved; Authority acquires members' wholesale
facilities
Uniform usage rate for operations & maintenance costs
Uniform capacity-based rate for debt service
Debt service (Capacity Rate)
existing Authority facilities, acquired facilities, the Master
Water Plan and future projects allocated based on member
capacity subscription
O&M costs (Usage Rate)
existing Authority facilities, acquired facilities, the Master
Water Plan and future projects allocated based on quantity
of water used
KM- Peat Marwick LLP Page 6





L, *. ;:*. s'xss^ Ksass^ .1 i:: i
Option 5: Expansion of Authority
System-Wide Subscription Service


Opportunities
* Greater economies of scale
* Capacity allocation for capital
costs account for growth
* Encourages regional approaches
& alternative supplies
* Helps in equalizing costs among
users
* Unified strength/voice on water
issues


Obstacles
* Costs/efforts in dismantling
contracts & acquiring
member facilities
Cost impacts on selected
members
Complexity of allocating
entitlement & system
rotational capacity
Loss of member control over
own facilities


M2; PReat Marwick LLP Page 7






Option 4/5


* Members could commit to Options 4 then Option 5 after
the Master Water Plan (or 85 mgd)

* Subscription Option after the Master Water Plan.
Each member pays new capital costs for its subscribed portion
of each increment of new water supply after the Master Water
Plan is completed.
O&M costs continued under uniform rate


KJP Peat Marwick LLP Page 8






Option 4/5: Option 4 for Master Water Plan
& Individual Subscription Thereafter


Opportunities
* Same as Option 4
* Provides limit for member
commitment to uniform rate &
related issues (e.g., allocating
costs of growth)
* Encourages balance between
supply & ecosystem with Master
Water Plan implementation
then subscription based on need
beyond 2015


Obstacles
* Same as Option 4
* Potential impacts from
individual subscription of
future supplies (after Master
Water Plan)
Transition from Option 4 to
Option 5


KP- r Peat Marwick LLP Page 9







Rate-Setting Under Option # 4


O&M
Costs


For existing and
future water supply


Total
Costs


Cost per
1,000 gal.


Member
Cost


Capital Costs
(Annual Debt
Service)

For existing and
future water supply


Water
Consumption
(all members)


Member
Water


-PMb9Peat Marwick LLP Page 10


I~sm~a~--n~:l---.7-i---'-~T-l ~'~~~~~-' I-----------?-------a~n








Rate-Setting Under Option # 5


Based on Actual
Water Usage


Capital Costs
(Annual Debt
Service)

Based on
Capacity
Entitlements


Cost per
1,000 gal.
(User Rate)


Water
Consumption
(all members)

Cost per
1,000 gal.
(Base Rate)


Water
Capacity
(all members)


Member
O&M Cost



Member
Water
Consumption


Member
Capital Cost
M


Member
Water
Entitlement


Kmm-P Peat MarwickLLP Page 11


Member
Total Cost


q


- --~ ---"







Example of Capacity Cost Allocation
Under Option 5

System Expanded by 40 mgd

Total System Capacity -New System Capacity
= 200 mgd = 240 mgd


Total Debt Service New Debt Service
= $15 million = $18 million


Member A (expands by 20 mgd)

Existing Capacity New Capacity
= 50 mgd or 25% = 70 mgd or 27%

Existing Debt Servic e ew Debt Service
= $3.75 million = $4.9 million


Member B (no expansion)

Existing Capacity New Capacity
= 50 mgd or 25% = 50 mgd or 23%

Existing Debt Service ew Debt Service
= $3.75 million = $4.1 million


KWV;[Peat Marwick LLP Page 12


-~'--- "





.o .

Acquisition of Member Facilities


Facilities
All member facilities
Only groundwater facilities (excluding Tampa reservoir &
treatment)
Excluding all Tampa facilities
Financing
Authority financing with long-term bonds
Authority internal financing (with credit to member water
costs)
Valuation
Replacement value
Outstanding debt, original cost, etc..


m PMtPeat Marwick LLP Page 13


y--~I-i~---=UYil~Yji-~i-L1P-UPiP-;~iii


__









Acquisition Options for Member Facilities

Major Water Supply Facilities Including all Excluding all City Excluding
Member Facilities of Tampa Tampa's Surface
Facilities Water Facilities
(Morris Bridge is
included)


All member groundwater facilities $ 190,580,000 $ 168,280,000 $ 190,580,000
Hillsborough River Reservoir $ 9,333,975 $
Hillsborough WTP $ 97,315,079 $
Total Acquisition Cost $ 297,229,054 $ 168,280,000 $ 190,580,000

Annual P + $ 24,556,951 $ 13,903,230 $ 15,745,647


Assumption:
[1] Acquisition of major water supply Facilities will be financed @ 7.25% interest, 30
year term, one P + I payment.
[2] Land acquisition will be financed through SWFWMD's land preservation program
funds.
Note: Acquisition values are preliminary & not based on KPMG studies.


v(WZ Peat Marwick LLP Page 14









Acquisition of Member Facilities

Value & Revenue Credit from Sales


Revenue by Member Governments
WF Land Water Supply Total Annual revenue Credit $/1000
Facilities credit from sale of gallons based on
Facilities 1995 water usage
Hillsborough County $ 68,000 $ $ 68,000 $ 5,618 0.00
City of Tampa Surface Water Facilities $ $ 106,649,054 $ 106,649,054 $ 8,811,304 0.36
City of Tampa Morris Bridge WF only $ $ 22,300,000 $ 22,300,000 $ 1,842,418 0.08
Pasco County $ 400,000 $ 13,200,000 $ 13,600,000 $ 1,123,627 0.22
City of New Port Richey $ $ 2,800,000 $ 2,800,000 $ 231,335 0.17
Pinellas County $ 19,000,000 $ 70,480,000 $ 89,480,000 $ 7,392,804 0.30
City of St. Petersburg $ 6,074,000 $ 81,800,000 $ 87,874,000 $ 7,260,116 0.56

Total $ 25,542,000 $ 297,229,054 $ 322,771,054 $ 26,667,222

Assumptions:
[1] Financing terms 30 years, one P + I payment per year, 7.25% interest
[2] North Pasco is owned by Pasco County (82.5%) and City of New Port Richey (17.5%)
[3] Groundwater Treatment Plants are not included in Water Supply Facilities



Note: Acquisition values are preliminary & not based on KPMG studies.



(A-PMGPeatMarwick L LP Page 15


LII I I 1 1 I I II [1






Projected Average Unit Costs Options # 4 & 5
Including all Member Facilities


Note: Costs are shown in 1995 dollars & before any member's credit for revenues from acquisition.


wKmkm Peat Marwick LLP Page 16


Year Average Cost of all Cost of Potential ad Total Costs
Rate for member Master valorem tax $/1000
existing Facilities Water Plan credit gallons
S Facilities acquisition Facilities
2000 $ 0.63 $ 0.25 $ 0.05 $ (0.08) $ 0.85
2005 $ 0.63 $ 0.25 $ 0.09 $ (0.07) $ 0.90
2010 $ 0.58 $ 0.27 $ 0.21 $ (0.07) $ 0.99
2015 $ 0.44 $ 0.32 $ 0.23 $ (0.07) $ 0.92


---"1-------*--9








Impact of Acquisition of City of Tampa's Facilities
Average $/1000 gallon consumption


$1.05

$1.00
$0.95

$0.90
$0.85
$0.80
$0.75
$0.70
$0.65


I


#2k.


I \-4~s -


C 0 0C 04 0


C 0 C C) CO i
CD CD CM CD CD CD
NN 04 N 4 0


Note: Costs are shown in 1995 dollars & before any member's credit for revenues from acquisition.
Future capital improvements related to Tampa's facilities are not included.
4 Including City of Tampa's Facilities -Excluding City of Tampa's Facilities
-l"-ncluding Morris Bridge WF only


K-PMk lPeat Marwick LLP Page 17


H


-~a"-~


k,_


-





~t-e*,


-A






t


Retail Rate Impacts Under Options # 4 & 5

Includes all Member Facilities


$18.00
$16.00
$14.00
$12.00
$10.00
$8.00
$6.00
$4.00
$2.00
$-


Hillsborough City of Pasco
County Tampa County

1995 Retail Rate 0 Option # 4 2000 Retail Rate


City of New
Port Richey


Pinellas
County

SOption # 5 2000 Retail Rate


Note: Year 2000 Retail Rates include acquisition costs for all member government facilities,
construction of the Master Water Plan projects through 2000, any member credits from asset sales
and 0.10 ad valorem tax ( Amounts are not adjusted for inflation).



KA Pkeat Marwick LLP Page 18


-A-


City of St.
Petersburg

n


_I_~~


-1_ 111_








Retail Rate Impacts Under Options # 4 & 5

Excludes Tampa's Surface Water Facilities




$18.00
$16.00
$14.00
8 $12.00

Z $10.00 --
$8.00
E $6.00 -_
$4.00
$2.00
$- -- 4_-
Hillsborough City of Pasco City of New Pinellas City of St.
County Tampa County Port Richey County Petersburg

1995 Retail Rate Il Option # 4 2000 Retail Rate a Option # 5 2000 Retail Rate


Note: Year 2000 Retail Rates include acquisition costs for all member government facilities,
construction of the Master Water Plan projects through 2000, any member credits from asset
sales and 0.10 ad valorem tax ( Amounts are not adjusted for inflation).



mK Peat Marwick LLP Page 19




iC


Acquisition of Tampa Facilities


Opportunities
* Major source of potable supply in
region
* Flexible permitting of wellfields is
possible from SWFWMD (more
rotational capacity)
* Opportunities for greater
integration of surface supplies -
Tampa By-Pass Canal,
Hillsborough Reservoir & Water
Reclamation Project


Obstacles
* High costs of acquisition
* Surface water treatment
capacity fully used by City
Water plant condition &
capital improvements
Tampa can meet existing &
future needs with own
facilities
Voting deadlock if Tampa
withdraws


KM pM Peat Marwick LLP Page 20








Key Governance Activities for Water Supply Development


Key Activity


Option
#4


Option


Mechanism for implementation


1. Procedures for resource development as well as for I/ / Interlocal agreements; Authority by-
voting, financing and rate-setting. laws
2. Development of resource development plans / / Board vote on project plans/phases &
contracts
3. Member request for additional capacity NA / Member initiate
4. Authority commitment to member's system entitlement NA / Interlocal agreements
5. Annual approval of capital plans and O&M budget / / Board vote
6. Approval of system-wide project financing / 1 Board vote
7. Project financing for individual member projects (if Board NA Interlocal agreements for Authority
votes against system-wide development or financing) development & financing
8. Approval of rates (annually) / / Board vote
9. Approval of design/construction contracts / / Board vote






7K-t 7Peat Marwick LLP Page 21







Attachments

1. Financial Calculations for Option # 4
2. Financial Calculations for Option # 5
3. Financial Analysis for each Member Governments:
Wholesale and Retail Water Rates Calculation are provided for
each Member Government with following scenarios:
Including all Member Facilities
Excluding City of Tampa Facilities
Including Tampa's Morris Bridge WF only


P6eat Marwick LLP Page 22




- -


Option 4








FINANCIAL ANALYSIS OF OPTION # 4 (including City of Tampa's Morris Bridge WF only)
WY AUTHORITY MANAGED FACILITIES MEMBER GOVERNMENTs ALL EXISTING SUPPLIES MASTER WATER PLAN PROJECTS TOTAL 0.10 mil ad UNIT COST
Year FACILITIES AFTER ACQUISITION ANNUAL valorem tax
EXPENSE revenues
Total Total Annual Projected $/1000 gallons Projected Annual Total Annual $/1000 Cumulative Annual debt Annual O&M Total Annual Projected $/1000 gallons
Outstanding Debt Payment Annual O&M for the Annual O&M Payment (P+I) Costs (O&M. gallons for all additional payments for costs for MWP Costs for all revenues from for all existing,
Debt as of (P+I) for Costs Authority Costs for acquisition Debt. and existing capacity construction of supplies existing & MWP 0.10 milage ad acquired and
Water Year Water Year managed of Member Facilities water through MWP supplies water supplies valorem tax MWP supplies
Facilities Government's Acquisition) supplies construction of charged by the
Facilities for all existing MWP supplies Authority
supplies (mgd)

1995 $113,460,893 $12,952,435 $16,929,239 $ 0.71 $ 4,982,582 $ $34,864,256 $ 0.61 0 $ $ $ 34,864.256 $ $ 0.61
1996 $112,075,875 $11,526,790 $16,929,239 $ 0.62 $ 4,982,582 $ $33,438,611 $ 0.53 0 $ 140,457 $ $ 33.579.068 $ $ 0.53
1997 $107,540,600 $12.192,833 $16,929,239 $ 0.63 $ 4,982,582 $15.745,647 $49,850,301 $ 0.78 4 $ 256,124 $ 424,300 $ 50,530,725 $ $- 0.78
1998 $103,484,330 $12,141.670 $16.929,239 $ 0.63 $ 4.982.582 $15,745,647 $49.799,138 $ 0.78 14 $ 1,708,481 $ 2,727,700 $ 54,235,319 $ (6,402,888) $ 0.71
1999 $ 99,177,845 $12,091,721 $16,929,239 $ 0.63 $ 4.982.582 $15,745,647 $49.749,189 $ 0.78 14 $ 1.708.481 $ 2,727,700 $ 54,185,370 $ (6,466,917) $ 0.71
2000 $ 94,645,227 $12,038,774 $16,929,239 $ 0.63 $ 4.982.582 $15,745,647 $49,696,242 $ 0.78 26 $ 6,622.240 $ 4,059,700 $ 60,378,182 $ (6,531,586) $ 0.76
2001 $ 89,881,662 $11,849.947 $16,929.239 $ 0.63 $ 4.982,582 $15,745.647 $49,507,415 $ 0.78 26 $ 6,622,240 $ 4,059,700 $ 60,189,355 $ (6,596.902) $ 0.76
2002 $ 84,837,103 $12,011,557 $16,929,239 $ 0.63 $ 4,982.582 $15,745,647 $49,669,025 $ 0.78 38 $ 10.155,632 $ 5,513,052 $ 65,337,709 $ (6,662,871) $ 0.79
2003 $ 79,466.562 $12,007,259 $16.929,239 $ 0.63 $ 4,982,582 $15,745,647 $49,664,727 $ 0.78 38 $ 10.155,632 $ 5,513.052 $ 65,333.411 $ (6,729,500) $ 0.79
2004 $ 73,760,106 $11.996,924 $16,929,239 $ 0.63 $ 4,982,582 $15.745,647 $49,654,392 $ 0.78 38 $ 10,155,632 $ 5,513,052 $ 65,323,076 $ (6,796,795) $ 0.79
2005 $ 67,697,847 $11,983,309 $16,929,239 $ 0.63 $ 4.982.582 $15.745.647 $49.640,777 $ 0.78 50 $ 13,493,903 $ 7,220,164 $ 70,354,844 $ (6,864,763) $ 0.82
2006 $ 61,250,003 $11.969,819 $16,929,239 $ 0.63 $ 4.982,582 $15,745,647 $49,627.287 $ 0.78 50 $ 13.493,903 $ 7,220,164 $ 70,341,354 $ (6,933,410) $ 0.82
2007 $ 54,396,766 $11.949,944 $16,929,239 $ 0.63 $ 4.982,582 $15,745,647 $49.607,412 $ 0.78 50 $ 13,493,903 $ 7,220,164 $ 70.321,479 $ (7,002,744) $ 0.82
2008 $ 47,803.990 $11,940,879 $16,929,239 $ 0.63 $ 4,982.582 $15,745.647 $49.598.347 $ 0.78 85 $ 19.586,134 $21,939,897 $ 91,124,378 $ (7,072,772) $ 0.97
2009 $ 43,318.960 $11,930,564 $16,929,239 $ 0.63 $ 4,982.582 $15,745.647 $49.588.032 $ 0.78 85 $ 19,586,134 $21,939,897 $ 91.114,063 $ (7,143,499) $ 0.97
2010 $ 40.409,592 $ 9,833,000 $16,929,239 $ 0.58 $ 4,982.582 $15,745,647 $47,490,468 $ 0.75 85 $ 19,586,134 $21,939,897 $ 89.016,499 $ (7,214,934) $ 0.94
2011 $ 37,161,898 $ 9,865,205 $16,929,239 $ 0.58 $ 4,982,582 $15,745,647 $47,522.673 $ 0.75 85 $ 19.586,134 $21.939,897 $ 89,048,704 $ (7,287,084) $ 0.94
2012 $ 34,901,793 $ 8,506,220 $16.929,239 $ 0.55 $ 4,982,582 $15,745,647 $46,163,688 S 0.73 85 $ 19,586,134 $21.939,897 $ 87,689,719 $ (7,359,955) $ 0.93
2013 $ 32.342,030 $ 8,481,350 $16,929,239 $ 0.55 $ 4,982,582 $15,745,647 $46,138,818 $ 0.73 85 $ 19,586.134 $21,939.897 $ 87,664,849 $ (7,433,554) $ 0.92
2014 $ 29,442,084 $ 8,469,863 $16,929,239 $ 0.55 $ 4,982,582 $15.745,647 $46,127,331 $ 0.73 85 $ 19,586,134 $21,939,897 $ 87,653,362 $ (7,507,890) $ 0.92
2015 $ 8,110,000 $ 3,400.613 $16,929,239 $ 0.44 $ 4.982,582 $15,745,647 $41,058,081 $ 0.65 85 $ 19,586,134 $21.939,897 $ 82,584,112 $ (7,582,969) $ 0.86

Assumptions:
[1] Acquisition of weltfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
(3] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[4] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
[5] Existing, acquired and the Master Water Plan Facilities will be operated @ 75% of permitted capacity, 25% rotational reserve
[6] ad valorem tax revenue is projected to increase at the rate of 1.0% per year starting WY 1998
[7] ad valorem tax revenues will be used for conservation, environmental mitigation and other environmentally beneficial uses








WCRWSA10.XLS





Option 4


FINANCIAL ANALYSIS OF OPTION # 4 (excluding all City of Tampa Facilities)
WY AUTHORITY MANAGED FACILITIES MEMBER GOVERNMENTs ALL EXISTING SUPPLIES MASTER WATER PLAN PROJECTS TOTAL 0.10 mil ad UNIT COST
Year FACILITIES AFTER ACQUISITION ANNUAL valorem tax
EXPENSE revenues
Total Total Annual Projected $/1000 gallons Projected Annual Total Annual $/1000 Cumulative Annual debt Annual O&M Total Annual Projected $/1000 gallons
Outstanding Debt Payment Annual O&M for the Annual O&M Payment (P+I) Costs (O&M. gallons for all additional payments for costs for MWP Costs for all revenues from for all existing,
Debt as of (P+I) for Costs Authority Costs for acquisition Debt, and existing capacity construction of supplies existing & MWP 0.10 milage ad acquired and
Water Year Water Year managed of Member Facilities water through MWP supplies water supplies valorem tax MWP supplies
Facilities Government's Acquisition) supplies construction of charged by the
Facilities for all existing MWP supplies Authority
supplies (mgd)

1995 $113,460,893 $12,952,435 $16.929,239 $ 0.71 $ 4,813,461 $ $34,695,135 $ 0.62 0 $ $ $ 34.695,135 $ $ 0.62
1996 $112,075.875 $11,526,790 $16,929,239 $ 0.62 $ 4.813,461 $ $33,269,490 $ 0.55 0 $ 140,457 $ $ 33,409,947 $ $ 0.55
1997 $107,540,600 $12,192,833 $16,929,239 $ 0.63 $ 4,813,461 $13,903,230 $47,838,763 $ 0.79 4 $ 256,124 $ 424,300 $ 48,519.187 $ $ 0.79
1998 $103,484,330 $12.141,670 $16,929.239 $ 0.63 $ 4,813,461 $13,903,230 $47,787,600 $ 0.79 14 $ 1,708,481 $ 2,727,700 $ 52,223,781 $ (6,402,888) $ 0.71
1999 $ 99,177,845 $12,091,721 $16,929,239 $ 0.63 $ 4,813,461 $13,903,230 $47,737,651 $ 0.79 14 $ 1,708,481 $ 2,727,700 $ 52,173,832 $ (6,466,917) $ 0.71
2000 $ 94,645,227 $12,038,774 $16,929,239 $ 0.63 $ 4,813,461 $13,903.230 $47,684,704 $ 0.79 26 $ 6,622.240 $ 4,059,700 $ 58,366,644 $ (6,531,586) $ 0.77
2001 $ 89,881,662 $11,849,947 $16,929,239 $ 0.63 $ 4,813,461 $13,903,230 $47,495,877 $ 0.78 26 $ 6,622,240 $ 4,059.700 $ 58,177,817 $ (6,596,902) $ 0.76
2002 $ 84,837,103 $12.011.557 $16,929,239 $ 0.63 $ 4,813,461 $13,903,230 $47,657.487 $ 0.79 38 $ 10,155,632 $ 5,513.052 $ 63,326,171 $ (6,662,871) $ 0.80
2003 $ 79,466,562 $12,007,259 $16,929,239 $ 0.63 $ 4,813,461 $13,903,230 $47,653,189 $ 0.79 38 $ 10,155,632 $ 5,513,052 $ 63,321,873 $ (6,729.500) $ 0.80
2004 $ 73,760,106 $11,996,924 $16,929.239 $ 0.63 $ 4,813,461 $13,903,230 $47,642.854 $ 0.79 38 $ 10,155,632 $ 5,513,052 $ 63,311,538 $ (6,796,795) $ 0.80
2005 $ 67,697,847 $11,983,309 $16,929,239 $ 0.63 $ 4,813,461 $13,903.230 $47,629,239 $ 0.79 50 $ 13,493.903 $ 7.220,164 $ 68,343,306 $ (6.864,763) $ 0.83
2006 $ 61,250,003 $11,969.819 $16,929,239 $ 0.63 $ 4.813,461 $13,903,230 $47,615,749 $ 0.79 50 $ 13,493,903 $ 7,220,164 $ 68,329,816 $ (6.933,410) $ 0.83
2007 $ 54,396,766 $11,949,944 $16,929,239 $ 0.63 $ 4,813.461 $13,903,230 $47,595,874 $ 0.79 50 $ 13,493,903 $ 7,220,164 $ 68,309,941 $ (7.002.744) $ 0.83
2008 $ 47,803,990 $11,940,879 $16,929,239 $ 0.63 $ 4,813,461 $13.903,230 $47,586,809 $ 0.79 85 $ 19,586,134 $21,939,897 $ 89.112,840 $ (7,072,772) $ 0.98
2009 $ 43,318,960 $11,930,564 $16,929,239 $ 0.63 $ 4,813,461 $13,903,230 $47,576,494 $ 0.79 85 $ 19,586,134 $21,939.897 $ 89,102,525 $ (7,143,499) $ 0.98
2010 $ 40,409,592 $ 9,833,000 $16,929.239 $ 0.58 $ 4.813,461 $13.903,230 $45,478,930 $ 0.75 85 $ 19.586,134 $21.939.897 $ 87,004,961 $ (7,214,934) $ 0.95
2011 $ 37,161,898 $ 9.865,205 $16,929,239 $ 0.58 $ 4,813.461 $13,903.230 $45,511,135 $ 0.75 85 $ 19,586,134 $21,939,897 $ 87,037,166 $ (7,287.084) $ 0.95
2012 $ 34,901,793 $ 8,506.220 $16,929,239 $ 0.55 $ 4.813,461 $13,903,230 $44,152.150 $ 0.73 85 $ 19,586.134 $21.939,897 $ 85,678,181 $ (7,359,955) $ 0.93
2013 $ 32,342,030 $ 8,481,350 $16,929,239 $ 0.55 $ 4.813.461 $13,903.230 $44,127,280 $ 0.73 85 $ 19,586.134 $21,939,897 $ 85,653,311 $ (7,433,554) $ 0.93
2014 $ 29,442,084 $ 8,469,863 $16,929,239 $ 0.55 $ 4,813,461 $13.903,230 $44,115,793 $ 0.73 85 $ 19,586,134 $21,939,897 $ 85,641,824 $ (7,507,890) $ 0.93
2015 $ 8,110,000 $ 3,400.613 $16,929,239 $ 0.44 $ 4.813,461 $13,903,230 $39,046,543 $ 0.65 85 $ 19,586,134 $21,939,897 $ 80,572,574 $ (7.582,969) $ 0.87

Assumptions:
(1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
(2] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[3] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[4] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
(5] Existing, acquired and the Master Water Plan Facilities will be operated @ 75% of permitted capacity, 25% rotational reserve
(6] ad valorem tax revenue is projected to increase at the rate of 1.0% per year starting WY 1998
[7] ad valorem tax revenues will be used for conservation, environmental mitigation and other environmentally beneficial uses








WCRWSA10.XLS
A-2





Option 4


FINANCIAL ANALYSIS OF OPTION # 4 (including all Member Facilities)
WY AUTHORITY MANAGED FACILITIES MEMBER GOVERNMENTs ALL EXISTING SUPPLIES MASTER WATER PLAN PROJECTS TOTAL 0.10 mil ad UNIT COST
Year FACILITIES AFTER ACQUISITION ANNUAL valorem tax
EXPENSE revenues
Total Total Annual Projected $/1000 gallons Projected Annual Total Annual $/1000 Cumulative Annual debt Annual O&M Total Annual Projected $/1000 gallons
Outstanding Debt Payment Annual O&M for the Annual O&M Payment (P+I) Costs (O&M. gallons for all additional payments for costs for MWP Costs for all revenues from for all existing,
Debt as of (P+I) for Costs Authority Costs for acquisition Debt, and existing capacity construction of supplies existing & MWP 0.10 milage ad acquired and
Water Year Water Year managed of Member Facilities water through MWP supplies water supplies valorem tax MWP supplies
Facilities Goverment's Acquisition) supplies construction of charged by the
Facilities for all existing MWP supplies Authority
supplies (mgd)

1995 $113,460,893 $12,952,435 $16.929.239 $ 0.71 $15,820.351 $ $45,702,025 $ 0.58 0 $ $ $ 45,702,025 $ $ 0.58
1996 $112,075,875 $11,526,790 $16.929.239 $ 0.62 $15,820,351 $ $44,276,380 $ 0.56 0 $ 140,457 $ $ 44,416,837 $ $ 0.56
1997 $107,540,600 $12,192,833 $16,929,239 $ 0.63 $15,820,351 $24,556,951 $69,499,374 $ 0.88 4 $ 256,124 $ 424,300 $ 70,179,798 $ $ 0.87
1998 $103,484,330 $12,141.670 $16,929,239 $ 0.63 $15,820,351 $24,556,951 $69,448,211 $ 0.88 14 $ 1,708.481 $ 2,727,700 $ 73.884.392 $ (6,402,888) $ 0.81
1999 $ 99.177,845 $12,091,721 $16,929,239 $ 0.63 $15,820.351 $24.556,951 $69.398,262 $ 0.88 14 $ 1,708,481 $ 2,727.700 $ 73,834,443 $ (6,466,917) $ 0.81
2000 $ 94.645,227 $12,038,774 $16,929,239 $ 0.63 $15.820,351 $24,556.951 $69,345,315 $ 0.88 26 $ 6,622.240 $ 4,059,700 $ 80,027,255 $ (6,531.586) $ 0.85
2001 $ 89,881.662 $11,849,947 $16,929,239 $ 0.63 $15,820.351 $24,556,951 $69,156,488 $ 0.87 26 $ 6,622,240 $ 4,059.700 $ 79,838,428 $ (6,596,902) $ 0.85
2002 $ 84,837,103 $12,011,557 $16.929,239 $ 0.63 $15,820,351 $24,556.951 $69,318,098 $ 0.88 38 $ 10.155,832 $ 5,513,052 $ 84,986,782 $ (6,662,871) $ 0.87
2003 $ 79.466,562 $12,007,259 $16,929,239 $ 0.63 $15,820,351 $24,556.951 $69,313,800 $ 0.88 38 $ 10.155.632 $ 5,513.052 $ 84,982,484 $ (6.729.500) $ 0.87
2004 $ 73,760,106 $11.996,924 $16,929,239 $ 0.63 $15,820,351 $24,556,951 $69,303,465 $ 0.88 38 $ 10.155,632 $ 5,513,052 $ 84,972,149 $ (6,796.795) $ 0.87
2005 $ 67,697.847 $11.983,309 $16,929,239 $ 0.63 $15,820,351 $24.556,951 $69,289,850 $ 0.88 50 $ 13,493,903 $ 7,220,164 $ 90,003.917 $ (6,864,763) $ 0.90
2006 $ 61.250,003 $11,969,819 $16,929.239 $ 0.63 $15.820,351 $24.556,951 $69,276,360 $ 0.88 50 $ 13.493.903 $ 7.220.164 $ 89,990,427 $ (6,933,410) $ 0.89
2007 $ 54.396.766 $11,949,944 $16.929,239 $ 0.63 $15,820,351 $24.556,951 $69,256,485 $ 0.87 50 $ 13,493,903 $ 7.220,164 $ 89,970,552 $ (7,002,744) $ 0.89
2008 $ 47,803,990 $11,940,879 $16,929,239 $ 0.63 $15,820,351 $24,556,951 $69,247,420 $ 0.87 85 $ 19,586,134 $21.939,897 $110.773,451 $ (7,072,772) $ 1.01
2009 $ 43,318.960 $11,930,564 $16,929,239 $ 0.63 $15,820.351 $24.556.951 $69,237,105 $ 0.87 85 $ 19,586.134 $21,939.897 $110,763,136 $ (7,143,499) $ 1.01
2010 $ 40,409,592 $ 9,833,000 $16,929,239 $ 0.58 $15,820,351 $24,556,951 $67,139,541 $ 0.85 85 $ 19,586,134 $21,939,897 $108.665,572 $ (7,214,934) $ 0.99
2011 $ 37,161,898 $ 9.865.205 $16,929,239 $ 0.58 $15,820,351 $24,556,951 $67.171,746 $ 0.85 85 $ 19.586,134 $21,939.897 $108,697,777 $ (7,287,084) $ 0.99
2012 $ 34,901,793 $ 8.506,220 $16,929,239 $ 0.55 $15,820.351 $24,556,951 $65,812,761 $ 0.83 85 $ 19,586.134 $21,939,897 $107,338,792 $ (7.359.955) $ 0.98
2013 $ 32,342,030 $ 8,481,350 $16,929.239 $ 0.55 $15,820,351 $24,556,951 $65.787,891 $ 0.83 85 $ 19,586,134 $21,939,897 $107.313,922 $ (7,433.554) $ 0.98
2014 $ 29,442.084 $ 8,469,863 $16,929,239 $ 0.55 $15,820,351 $24.556,951 $65,776.404 $ 0.83 85 $ 19,586,134 $21,939,897 $107,302,435 $ (7,507,890) $ 0.97
2015 $ 8,110,000 $ 3,400,613 $16,929,239 $ 0.44 $15,820,351 $24.556,951 $60,707.154 $ 0.77 85 $ 19,586,134 $21,939,897 $102,233,185 $ (7,582,969) $ 0.92

Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[3] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[4] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
[5] Existing, acquired and the Master Water Plan Facilities will be operated @ 75% of permitted capacity, 25% rotational reserve
[6] ad valorem tax revenue is projected to increase at the rate of 1.0% per year starting WY 1998
[7] ad valorem tax revenues will be used for conservation, environmental mitigation and other environmentally beneficial uses








WCRWSA10.XLS
A-3





Option 5


FINANCIAL ANALYSIS OF OPTION # 5 (including all Member Facilities)
WY Entitlement / Annual Debt Base Rate $11000 Water Usage Annual O&M User Rate $11000
Year Water Use Service gallons (mgd) Costs less ad gallons water
Permitted (mgd) entitlement valorem tax consumed
revenue
1995 289.14 $ 12,952,435 0.12 216.50 $ 32,749,590 0.41
1996 289.14 $ 11,667,247 0.11 216.86 $ 32,749,590 0.41
1997 293.14 $ 37,005,908 0.35 219.86 $ 33,173,890 0.41
1998 303.14 $ 38,407,102 0.35 227.36 $ 29,074,402 0.35
1999 303.14 $ 38,357,153 0.35 227.36 $ 29,010,373 0.35
2000 315.14 $ 43,217,965 0.38 236.36 $ 30,277,704 0.35
2001 315.14 $ 43,029,138 0.37 236.36 $ 30,212,388 0.35
2002 327.14 $ 46,724,140 0.39 245.36 $ 31,599,771 0.35
2003 327.14 $ 46,719,842 0.39 245.36 $ 31,533,142 0.35
2004 327.14 $ 46,709,507 0.39 245.36 $ 31,465,847 0.35
2005 339.14 $ 50,034,163 0.40 254.36 $ 33,104,991 0.36
2006 339.14 $ 50,020,673 0.40 254.36 $ 33,036,344 0.36
2007 339.14 $ 50,000,798 0.40 254.36 $ 32,967,010 0.36
2008 374.14 $ 56,083,964 0.41 280.61 $ 47,616,715 0.46
2009 374.14 $ 56,073,649 0.41 280.61 $ 47,545,988 0.46
2010 374.14 $ 53,976,085 0.40 280.61 $ 47,474,553 0.46
2011 374.14 $ 54,008,290 0.40 280.61 $ 47,402,403 0.46
2012 374.14 $ 52,649,305 0.39 280.61 $ 47,329,532 0.46
2013 374.14 $ 52,624,435 0.39 280.61 $ 47,255,933 0.46
2014 374.14 $ 52,612,948 0.39 280.61 $ 47,181,597 0.46
2015 374.14 $ 47,543,698 0.35 280.61 $ 47,106,518 0.46

Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[3] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[4] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
[5] Existing, acquired and the Master Water Plan Facilities will be operated @ 75% of permitted capacity, 25% rotational reserve
[6] Ad valorem tax revenue is projected to increase at the rate of 1.0% per year starting WY 1998
[7] ad valorem tax revenues will be used for conservation, environmental mitigation and other environmentally beneficial uses


WCRWSA10.XLS


A-4





Option 5


FINANCIAL ANALYSIS OF OPTION # 5 (excluding all City of Tampa Facilities)
WY Entitlement I Annual Debt Base Rate $11000 Water Usage Annual O&M User Rate $11000
Year Water Use Service gallons (mgd) Costs less ad gallons water
Permitted (mgd) entitlement valorem tax consumed
revenue
1995 221.04 $ 12,952,435 0.16 152.60 $ 21,742,700 0.39
1996 221.04 $ 11,667,247 0.14 165.78 $ 21,742,700 0.36
1997 225.04 $ 26,352,187 0.32 168.78 $ 22,167,000 0.36
1998 235.04 $ 27,753,381 0.32 176.28 $ 18,067,512 0.28
1999 235.04 $ 27,703,432 0.32 176.28 $ 18,003,483 0.28
2000 247.04 $ 32,564,244 0.36 185.28 $ 19,270,814 0.28
2001 247.04 $ 32,375,417 0.36 185.28 $ 19,205,498 0.28
2002 259.04 $ 36,070,419 0.38 194.28 $ 20,592,881 0.29
2003 259.04 $ 36,066,121 0.38 194.28 $ 20,526,252 0.29
2004 259.04 $ 36,055,786 0.38 194.28 $ 20,458,957 0.29
2005 271.04 $ 39,380,442 0.40 203.28 $ 22,098,101 0.30
2006 271.04 $ 39,366,952 0.40 203.28 $ 22,029,454 0.30
2007 271.04 $ 39,347,077 0.40 203.28 $ 21,960,120 0.30
2008 306.04 $ 45,430,243 0.41 229.53 $ 36,609,825 0.44
2009 306.04 $ 45,419,928 0.41 229.53 $ 36,539,098 0.44
2010 306.04 $ 43,322,364 0.39 229.53 $ 36,467,663 0.44
2011 306.04 $ 43,354,569 0.39 229.53 $ 36,395,513 0.43
2012 306.04 $ 41,995,584 0.38 229.53 $ 36,322,642 0.43
2013 306.04 $ 41,970,714 0.38 229.53 $ 36,249,043 0.43
2014 306.04 $ 41,959,227 0.38 229.53 $ 36,174,707 0.43
2015 306.04 $ 36,889,977 0.33 229.53 $ 36,099,628 0.43

Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[3] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[4] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
[5] Existing, acquired and the Master Water Plan Facilities will be operated @ 75% of permitted capacity, 25% rotational reserve
[6] Ad valorem tax revenue is projected to increase at the rate of 1.0% per year starting WY 1998
[7] ad valorem tax revenues will be used for conservation, environmental mitigation and other environmentally beneficial uses


WCRWSA10.XLS
A-5





Option 5


FINANCIAL ANALYSIS OF OPTION # 5 (including Tampa's Morris Bridge WF only)
WY Entitlement / Annual Debt Base Rate $11000 Water Usage Annual O&M User Rate $11000
Year Water Use Service gallons (mgd) Costs less ad gallons water
Permitted (mgd) entitlement valorem tax consumed
revenue
1995 232.19 $ 12,952,435 0.15 156.05 $ 21,911,821 0.38
1996 232.19 $ 11,667,247 0.14 174.14 $ 21,911,821 0.34
1997 236.19 $ 28,194,604 0.33 177.14 $ 22,336,121 0.35
1998 246.19 $ 29,595,798 0.33 184.64 $ 18,236,633 0.27
1999 246.19 $ 29,545,849 0.33 184.64 $ 18,172,604 0.27
2000 258.19 $ 34,406,661 0.37 193.64 $ 19,439,935 0.28
2001 258.19 $ 34,217,834 0.36 193.64 $ 19,374,619 0.27
2002 270.19 $ 37,912,836 0.38 202.64 $ 20,762,002 0.28
2003 270.19 $ 37,908,538 0.38 202.64 $ 20,695,373 0.28
2004 270.19 $ 37,898,203 0.38 202.64 $ 20,628,078 0.28
2005 282.19 $ 41,222,859 0.40 211.64 $ 22,267,222 0.29
2006 282.19 $ 41,209,369 0.40 211.64 $ 22,198,575 0.29
2007 282.19 $ 41,189,494 0.40 211.64 $ 22,129,241 0.29
2008 317.19 $ 47,272,660 0.41 237.89 $ 36,778,946 0.42
2009 317.19 $ 47,262,345 0.41 237.89 $ 36,708,219 0.42
2010 317.19 $ 45,164,781 0.39 237.89 $ 36,636,784 0.42
2011 317.19 $ 45,196,986 0.39 237.89 $ 36,564,634 0.42
2012 317.19 $ 43,838,001 0.38 237.89 $ 36,491,763 0.42
2013 317.19 $ 43,813,131 0.38 237.89 $ 36,418,164 0.42
2014 317.19 $ 43,801,644 0.38 237.89 $ 36,343,828 0.42
2015 317.19 $ 38,732,394 0.33 237.89 $ 36,268,749 0.42
Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[3] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[4] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
[5] Existing, acquired and the Master Water Plan Facilities will be operated @ 75% of permitted capacity, 25% rotational reserve
[6] Ad valorem tax revenue is projected to increase at the rate of 1.0% per year starting WY 1998
[7] ad valorem tax revenues will be used for conservation, environmental mitigation and other environmentally beneficial uses


WCRWSA10.XLS


A-6




Analysis 2


Financial Analysis for Hillsborough County
Includes all Member Facilities


$11000 gal. under OPTION # 4
Year Projected Uniform Acquisition Master ad Total Credit for Net Costs New New Retail 1995 % change
Water Rate for of all Water valorem Costs sale of $11000 Wholesale Rate $ / Retail in Retail
Usage existing Facilities Plan tax credit $11000 Facilities gallons Rate $ / month / Rate $ / Rates
(mgd) Facilities Facilities gallons month / residence month /
Residence residence
2000 42.73 $ 0.63 $ 0.25 $ 0.05 $ (0.08) $ 0.85 $(0.0004) $ 0.85 $ 5.36 $ 13.97 $ 16.10 -13.23%
2005 47.76 $ 0.63 $ 0.25 $ 0.09 $ (0.07) $ 0.90 $(0.0003) $ 0.90 $ 5.64 $ 14.24 $ 16.10 -11.52%
2010 52.63 $ 0.58 $ 0.27 $ 0.21 $ (0.07) $ 0.99 $(0.0003) $ 0.99 $ 6.24 $ 14.84 $ 16.10 -7.81%
2015 57.38 $ 0.44 $ 0.32 $ 0.23 $ (0.07) $ 0.92 $(0.0003) $ 0.92 $ 5.82 $ 14.42 $ 16.10 -10.40%

$/1000 gal. under OPTION # 5
Year Projected Rate for Acquisition Master ad Total Credit for Net Costs New New Retail 1995 % change
Water existing of all Water valorem Costs sale of $11000 Wholesale Rate $ / Retail in Retail
Usage Facilities Facilities Plan tax credit $11000 Facilities gallons Rate $ / month / Rate $ / Rates
(mgd) Facilities gallons month/ residence month /
residence residence
2000 42.73 $ 0.66 $ 0.27 $ 0.06 $ (0.08) $ 0.91 $(0.0004) $ 0.91 $ 5.73 $ 14.35 $ 16.10 -10.89%
2005 47.76 $ 0.66 $ 0.27 $ 0.10 $ (0.07) $ 0.96 $(0.0003) $ 0.96 $ 6.04 $ 14.65 $ 16.10 -9.01%
2010 52.63 $ 0.61 $ 0.29 $ 0.22 $ (0.07) $ 1.05 $(0.0003) $ 1.05 $ 6.63 $ 15.24 $ 16.10 -5.34%
2015 57.38 $ 0.45 $ 0.36 $ 0.24 $ (0.07) $ 0.98 $(0.0003) $ 0.98 $ 6.16 $ 14.77 $ 16.10 -8.23%

Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[3] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[4] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
[5] Existing, acquired and the Master Water Plan Facilities will be operated at 75% of permitted capacity, 25% rotational reserve
[6] Wholesale & Retail Water Rates are calculated based on 6,300 gallons per month per residence
[7] For Option # 5 1995 ratio of water usage to water entitlement is used for individual member government



WCRWSA10.XLS
A-7





Analysis


Water Rate Analysis for Hillsborough County


OPTION # 4 Wholesale Water Rates
Year 1995 Including % Change Excluding % Change Including % Change
Wholesale City of City of Morris
Rate Tampa's Tampa's Bridge WF
($/1000 Facilities Facilities only
gallons.)
2000 $ 1.19 $ 0.85 -28.41% $ 0.77 -35.59% $ 0.76 -35.98%
2005 $ 1.19 $ 0.90 -24.75% $ 0.83 -30.37% $ 0.82 -30.93%
2010 $ 1.19 $ 0.99 -16.76% $ 0.95 -19.97% $ 0.94 -20.83%
2015 $ 1.19 $ 0.92 -22.34% $ 0.87 -26.79% $ 0.86 -27.41%

OPTION # 4 Retail Water Costs
Year 1995 Retail Including % Change Excluding % Change Including % Change
Rate City of City of Morris
($/month/ Tampa's Tampa's Bridge WF
residence) Facilities Facilities only

2000 $ 16.10 $ 13.97 -13.23% $ 13.43 -16.57% $ 13.40 -16.75%
2005 $ 16.10 $ 14.24 -11.52% $ 13.82 -14.14% $ 13.78 -14.40%
2010 $ 16.10 $ 14.84 -7.81% $ 14.60 -9.30% $ 14.54 -9.70%
2015 $ 16.10 $ 14.42 -10.40% $ 14.09 -12.47% $ 14.04 -12.77%


____OPTION # 5 Wholesale Water Rates
Year 1995 Including % Change Excluding % Change Including % Change
Wholesale City of City of Morris
Rate Tampa's Tampa's Bridge WF
($/1000 Facilities Facilities only
gallons.)
2000 $ 1.19 $ 0.91 -23.38% $ 0.82 -30.76% $ 0.82 -31.10%
2005 $ 1.19 $ 0.96 -19.34% $ 0.89 -25.05% $ 0.89 -25.58%
2010 $ 1.19 $ 1.05 -11.47% $ 1.01 -14.78% $ 1.00 -15.61%
2015 $ 1.19 $ 0.98 -17.68% $ 0.92 -22.37% $ 0.92 -22.94%

OPTION # 5 Retail Water Costs
Year 1995 Retail Including % Change Excluding % Change Including % Change
Rate City of City of Morris
($/month/ Tampa's Tampa's Bridge WF
residence) Facilities Facilities only

2000 $ 16.10 $ 14.35 -10.89% $ 13.79 -14.32% $ 13.77 -14.48%
2005 $ 16.10 $ 14.65 -9.01% $ 14.22 -11.66% $ 14.18 -11.91%
2010 $ 16.10 $ 15.24 -5.34% $ 14.99 -6.88% $ 14.93 -7.27%
2015 $ 16.10 $ 14.77 -8.23% $ 14.42 -10.42% $ 14.38 -10.68%


Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] Credits for sale of Facilities is included in the wholesale and retail rates where applicable
[3] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[4] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[5] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
[6] Existing, acquired and the Master Water Plan Facilities will be operated at 75% of permitted capacity, 25% rotational reserve
[7] For Option # 5 1995 ratio of water usage to water entitlement is used for individual member government
[8] Wholesale & Retail Water Rates are calculated based on 6,300 gallons per month per residence







WCRWSA10.XLS
A-8


I




Analysis 2


Financial Analysis for City of Tampa
Includes all Member Facilities
$/11000 gal. under OPTION # 4
Year Projected Uniform Acquisition Master ad Total Credit for Net Costs New New Retail 1995 % change
Water Rate for of all Water valorem Costs sale of $11000 Wholesale Rate $ / Retail in Retail
Usage existing Facilities Plan tax credit $11000 Facilities gallons Rate $ / month I Rate $ / Rates
(mgd) Facilities Facilities gallons month / residence month /
__ residence residence
2000 71.88 $ 0.63 $ 0.25 $ 0.05 $ (0.08) $ 0.85 $ (0.41) $ 0.45 $ 2.81 $ 7.03 $ 7.56 -7.01%
2005 74.13 $ 0.63 $ 0.25 $ 0.09 $ (0.07) $ 0.90 $ (0.39) $ 0.50 $ 3.16 $ 7.38 $ 7.56 -2.35%
2010 76.18 $ 0.58 $ 0.27 $ 0.21 $ (0.07) $ 0.99 $ (0.38) $ 0.61 $ 3.83 $ 8.05 $ 7.56 6.45%
2015 78.68 $ 0.44 $ 0.32 $ 0.23 $ (0.07) $ 0.92 $ (0.37) $ 0.55 $ 3.48 $ 7.71 $ 7.56 1.93%

$11000 gal. under OPTION # 5
Year Projected Rate for Acquisition Master ad Total Credit for Net Costs New New Retail 1995 % change
Water existing of all Water valorem Costs sale of $11000 Wholesale Rate $ I Retail in Retail
Usage Facilities Facilities Plan tax credit $11000 Facilities gallons Rate $ / month / Rate $ / Rates
(mgd) Facilities gallons month / residence month /
__ residence residence
2000 71.88 $ 0.63 $ 0.25 $ 0.05 $ (0.08) $ 0.86 $ (0.41) $ 0.45 $ 2.84 $ 7.07 $ 7.56 -6.45%
2005 74.13 $ 0.63 $ 0.25 $ 0.09 $ (0.07) $ 0.90 $ (0.39) $ 0.51 $ 3.20 $ 7.43 $ 7.56 -1.75%
2010 76.18 $ 0.58 $ 0.27 $ 0.21 $ (0.07) $ 1.00 $ (0.38) $ 0.61 $ 3.86 $ 8.09 $ 7.56 7.04%
2015 78.68 $ 0.44 $ 0.33 $ 0.23 $ (0.07) $ 0.93 $ (0.37) $ 0.56 $ 3.52 $ 7.75 $ 7.56 2.45%

Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[3] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[4] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
[5] Existing, acquired and the Master Water Plan Facilities will be operated at 75% of permitted capacity, 25% rotational reserve
[6] Wholesale & Retail Water Rates are calculated based on 6,300 gallons per month per residence
[7] For Option # 5 1995 ratio of water usage to water entitlement is used for individual member government



WCRWSA10.XLS
A-9





Analysis


Water Rate Analysis for City of Tampa


OPTION # 4 Wholesale Water Rates
Year 1995 Including % Change Including % Change
Wholesale City of Morris
Rate Tampa's Bridge WF
($/1000 Facilities only
gallons.)
2000 $ 0.53 $ 0.45 -15.88% $ 0.46 -13.25%
2005 $ 0.53 $ 0.50 -5.33% $ 0.46 -12.85%
2010 $ 0.53 $ 0.61 14.60% $ 0.46 -12.50%
2015 $ 0.53 $ 0.55 4.37% $ 0.47 -12.10%

OPTION # 4 Retail Water Costs
Year 1995 Retail Including % Change Including % Change
Rate City of Morris
($/month/ Tampa's Bridge WF
residence) Facilities only

2000 $ 7.56 $ 7.03 -7.01% $ 7.12 -5.85%
2005 $ 7.56 $ 7.38 -2.35% $ 7.13 -5.67%
2010 $ 7.56 $ 8.05 6.45% $ 7.14 -5.52%
2015 $ 7.56 $ 7.71 1.93% $ 7.16 -5.35%


OPTION # 5 Wholesale Water Rates
Year 1995 Including % Change Including % Change
Wholesale City of Morris
Rate Tampa's Bridge WF
($/1000 Facilities only
gallons.)
2000 $ 0.53 $ 0.45 -14.60% $ 0.46 -12.48%
2005 $ 0.53 $ 0.51 -3.95% $ 0.47 -12.08%
2010 $ 0.53 $ 0.61 15.94% $ 0.47 -11.74%
2015 $ 0.53 $ 0.56 5.55% $ 0.47 -11.34%

OPTION # 5 Retail Water Costs
Year 1995 Retail Including % Change Including % Change
Rate City of Morris
($/month/ Tampa's Bridge WF
residence) Facilities only

2000 $ 7.56 $ 7.07 -6.45% $ 7.14 -5.51%
2005 $ 7.56 $ 7.43 -1.75% $ 7.16 -5.34%
2010 $ 7.56 $ 8.09 7.04% $ 7.17 -5.18%
2015 $ 7.56 $ 7.75 2.45% $ 7.18 -5.01%


Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] Credits for sale of Facilities is included in the wholesale and retail rates where applicable
[3] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[4] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[5] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan
[6] Existing, acquired and the Master Water Plan Facilities will be operated at 75% of permitted capacity, 25% rotational reserve
[7] For Option # 5 1995 ratio of water usage to water entitlement is used for individual member government
[8] Wholesale & Retail Water Rates are calculated based on 6,300 gallons per month per residence
[9] Calculations for Morris Bridge WF only does not include capital improvement at the City's Hillisborough Reservoir and WTP




WCRWSA10.XLS
A-10




Analysis 2


Financial Analysis for Pasco County
Includes all Member Facilities
$11000 gal. under OPTION # 4
Year Projected Uniform Acquisition Master ad Total Credit for Net Costs New New Retail 1995 % change
Water Rate for of all Water valorem Costs sale of $11000 Wholesale Rate $ / Retail in Retail
Usage existing Facilities Plan tax credit $11000 Facilities gallons Rate $ / month / Rate $ / Rates
(mgd) Facilities Facilities gallons month / residence month /
residence residence
2000 18.95 $ 0.63 $ 0.25 $ 0.05 $ (0.08) $ 0.85 $ (0.16) $ 0.69 $ 4.34 $ 16.86 $ 16.23 3.86%
2005 22.83 $ 0.63 $ 0.25 $ 0.09 $ (0.07) $ 0.90 $ (0.13) $ 0.76 $ 4.79 $ 17.31 $ 16.23 6.62%
2010 26.86 $ 0.58 $ 0.27 $ 0.21 $ (0.07) $ 0.99 $ (0.11) $ 0.88 $ 5.52 $ 18.03 $ 16.23 11.10%
2015 30.73 $ 0.44 $ 0.32 $ 0.23 $ (0.07) $ 0.92 $ (0.10) $ 0.82 $ 5.19 $ 17.70 $ 16.23 9.08%

$11000 gal. under OPTION # 5
Year Projected Rate for Acquisition Master ad Total Credit for Net Costs New New Retail 1995 % change
Water existing of all Water valorem Costs sale of $11000 Wholesale Rate $ / Retail in Retail
Usage Facilities Facilities Plan tax credit $/1000 Facilities gallons Rate $ / month / Rate $ / Rates
(mgd) Facilities gallons month / residence month /
__residence residence
2000 18.95 $ 0.67 $ 0.27 $ 0.06 $ (0.08) $ 0.92 $ (0.16) $ 0.76 $ 4.77 $ 17.29 $ 16.23 6.51%
2005 22.83 $ 0.66 $ 0.27 $ 0.10 $ (0.07) $ 0.97 $ (0.13) $ 0.83 $ 5.25 $ 17.77 $ 16.23 9.48%
2010 26.86 $ 0.61 $ 0.30 $ 0.23 $ (0.07) $ 1.06 $ (0.11) $ 0.95 $ 5.96 $ 18.48 $ 16.23 13.89%
2015 30.73 $ 0.45 $ 0.36 $ 0.25 $ (0.07) $ 0.99 $ (0.10) $ 0.89 $ 5.58 $ 18.10 $ 16.23 11.54%

Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[3] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[4] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
[5] Existing, acquired and the Master Water Plan Facilities will be operated at 75% of permitted capacity, 25% rotational reserve
[6] Wholesale & Retail Water Rates are calculated based on 6,300 gallons per month per residence
[7] For Option # 5 1995 ratio of water usage to water entitlement is used for individual member government



WCRWSA10.XLS
A-11












Water Rate Analysis for Pasco County


OPTION # 4 Wholesale Water Rates
Year 1995 Including % Change Excluding % Change Including % Change
Wholesale City of City of Morris
Rate Tampa's Tampa's Bridge WF
($/1000 Facilities Facilities only
gallons.)
2000 $ 0.59 $ 0.69 16.86% $ 0.60 2.38% $ 0.60 1.59%
2005 $ 0.59 $ 0.76 28.92% $ 0.69 17.58% $ 0.69 16.45%
2010 $ 0.59 $ 0.88 48.46% $ 0.84 42.00% $ 0.83 40.25%
2015 $ 0.59 $ 0.82 39.65% $ 0.77 30.69% $ 0.76 29.42%

OPTION # 4 Retail Water Costs
Year 1995 Retail Including % Change Excluding % Change Including % Change
Rate City of City of Morris
($/month/ Tampa's Tampa's Bridge WF
residence) Facilities Facilities only

2000 $ 16.23 $ 16.86 3.86% $ 16.32 0.54% $ 16.29 0.36%
2005 $ 16.23 $ 17.31 6.62% $ 16.88 4.03% $ 16.84 3.77%
2010 $ 16.23 $ 18.03 11.10% $ 17.79 9.62% $ 17.73 9.22%
2015 $ 16.23 $ 17.70 9.08% $ 17.37 7.03% $ 17.32 6.74%


OPTION # 5 Wholesale Water Rates
Year 1995 Including % Change Excluding % Change Including % Change
Wholesale City of City of Morris
Rate Tampa's Tampa's Bridge WF
($/1000 Facilities Facilities only
gallons.)
2000 $ 0.59 $ 0.76 28.44% $ 0.67 13.51% $ 0.67 12.84%
2005 $ 0.59 $ 0.83 41.38% $ 0.77 29.85% $ 0.76 28.78%
2010 $ 0.59 $ 0.95 60.64% $ 0.91 53.95% $ 0.90 52.27%
2015 $ 0.59 $ 0.89 50.38% $ 0.83 40.86% $ 0.82 39.73%

OPTION # 5 Retail Water Costs
Year 1995 Retail Including % Change Excluding % Change Including % Change
Rate City of City of Morris
($/month/ Tampa's Tampa's Bridge WF
residence) Facilities Facilities only

2000 $ 16.23 $ 17.29 6.51% $ 16.73 3.09% $ 16.71 2.94%
2005 $ 16.23 $ 17.77 9.48% $ 17.34 6.84% $ 17.30 6.59%
2010 $ 16.23 $ 18.48 13.89% $ 18.24 12.36% $ 18.17 11.97%
2015 $ 16.23 $ 18.10 11.54% $ 17.75 9.36% $ 17.71 9.10%


Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] Credits for sale of Facilities is included in the wholesale and retail rates where applicable
[3] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[4] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[5] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan
[6] Existing, acquired and the Master Water Plan Facilities will be operated at 75% of permitted capacity, 25% rotational reserve
[7] For Option # 5 1995 ratio of water usage to water entitlement is used for individual member government
[8] Wholesale & Retail Water Rates are calculated based on 6,300 gallons per month per residence








WCRWSA10.XLS
A-12





Analysis 2


Financial Analysis for City of New Port Richey
Includes all Member Facilities
$11000 gal. under OPTION # 4
Year Projected Uniform Acquisition Master ad Total Credit for Net Costs New New Retail 1995 % change
Water Rate for of all Water valorem Costs sale of $11000 Wholesale Rate $ / Retail in Retail
Usage existing Facilities Plan tax credit $/1000 Facilities gallons Rate $ / month / Rate $ / Rates
(mgd) Facilities Facilities gallons month I residence month /
residence residence
2000 5.53 $ 0.63 $ 0.25 $ 0.05 $ (0.08) $ 0.85 $ (0.11) $ 0.74 $ 4.65 $ 11.32 $ 10.27 10.26%
2005 5.53 $ 0.63 $ 0.25 $ 0.09 $ (0.07) $ 0.90 $ (0.11) $ 0.78 $ 4.92 $ 11.60 $ 10.27 12.94%
2010 5.53 $ 0.58 $ 0.27 $ 0.21 $ (0.07) $ 0.99 $ (0.11) $ 0.88 $ 5.52 $ 12.20 $ 10.27 18.77%
2015 5.53 $ 0.44 $ 0.32 $ 0.23 $ (0.07) $ 0.92 $ (0.11) $ 0.81 $ 5.10 $ 11.78 $ 10.27 14.69%

$11000 gal. under OPTION # 5
Year Projected Rate for Acquisition Master ad Total Credit for Net Costs New New Retail 1995 % change
Water existing of all Water valorem Costs sale of $11000 Wholesale Rate $ / Retail in Retail
Usage Facilities Facilities Plan tax credit $11000 Facilities gallons Rate $ / month / Rate $ / Rates
(mgd) Facilities gallons month / residence month /
residence residence
2000 5.53 $ 0.76 $ 0.35 $ 0.07 $ (0.08) $ 1.10 $ (0.11) $ 0.99 $ 6.21 $ 12.90 $ 10.27 25.63%
2005 5.53 $ 0.76 $ 0.35 $ 0.13 $ (0.07) $ 1.16 $ (0.11) $ 1.05 $ 6.60 $ 13.30 $ 10.27 29.47%
2010 5.53 $ 0.69 $ 0.38 $ 0.26 $ (0.07) $ 1.25 $ (0.11) $ 1.14 $ 7.17 $ 13.86 $ 10.27 34.93%
2015 5.53 $ 0.48 $ 0.46 $ 0.29 $ (0.07) $ 1.15 $ (0.11) $ 1.04 $ 6.55 $ 13.24 $ 10.27 28.93%

Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[3] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[4] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
[5] Existing, acquired and the Master Water Plan Facilities will be operated at 75% of permitted capacity, 25% rotational reserve
[6] Wholesale & Retail Water Rates are calculated based on 6,300 gallons per month per residence
[7] For Option # 5 1995 ratio of water usage to water entitlement is used for individual member government



WCRWSA10.XLS
A-13


..------





Analysis


Water Rate Analysis for City of New Port Richey


OPTION # 4 Wholesale Water Rates
Year 1995 Including % Change Excluding % Change Including % Change
Wholesale City of City of Morris
Rate Tampa's Tampa's Bridge WF
($/1000 Facilities Facilities only
gallons.)
2000 $ 0.57 $ 0.74 29.35% $ 0.65 14.36% $ 0.65 13.55%
2005 $ 0.57 $ 0.78 37.00% $ 0.71 25.26% $ 0.71 24.08%
2010 $ 0.57 $ 0.88 53.67% $ 0.84 46.98% $ 0.83 45.17%
2015 $ 0.57 $ 0.81 42.02% $ 0.76 32.74% $ 0.75 31.43%

OPTION # 4 Retail Water Costs
Year 1995 Retail Including % Change Excluding % Change Including % Change
Rate City of City of Morris
($/month/ Tampa's Tampa's Bridge WF
residence) Facilities Facilities only

2000 $ 10.27 $ 11.32 10.26% $ 10.79 5.02% $ 10.76 4.74%
2005 $ 10.27 $ 11.60 12.94% $ 11.18 8.83% $ 11.13 8.42%
2010 $ 10.27 $ 12.20 18.77% $ 11.96 16.43% $ 11.89 15.79%
2015 $ 10.27 $ 11.78 14.69% $ 11.45 11.45% $ 11.40 10.99%


OPTION # 5 Wholesale Water Rates
Year 1995 Including % Change Excluding % Change Including % Change
Wholesale City of City of Morris
Rate Tampa's Tampa's Bridge WF
($/1000 Facilities Facilities only
gallons.)
2000 $ 0.57 $ 0.99 73.30% $ 0.89 56.60% $ 0.89 56.25%
2005 $ 0.57 $ 1.05 84.28% $ 0.98 71.82% $ 0.97 70.89%
2010 $ 0.57 $ 1.14 99.90% $ 1.10 92.34% $ 1.09 90.80%
2015 $ 0.57 $ 1.04 82.74% $ 0.98 71.36% $ 0.97 70.56%

OPTION # 5 Retail Water Costs
Year 1995 Retail Including % Change Excluding % Change Including % Change
Rate City of City of Morris
($/month/ Tampa's Tampa's Bridge WF
residence) Facilities Facilities only

2000 $ 10.27 $ 12.90 25.63% $ 12.30 19.79% $ 12.29 19.67%
2005 $ 10.27 $ 13.30 29.47% $ 12.85 25.11% $ 12.82 24.79%
2010 $ 10.27 $ 13.86 34.93% $ 13.59 32.29% $ 13.53 31.75%
2015 $ 10.27 $ 13.24 28.93% $ 12.83 24.95% $ 12.80 24.67%


Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] Credits for sale of Facilities is included in the wholesale and retail rates where applicable
[3] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[4] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[5] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan Projects
[6] Existing, acquired and the Master Water Plan Facilities will be operated at 75% of permitted capacity, 25% rotational reserve
[7] For Option # 5 1995 ratio of water usage to water entitlement is used for individual member government
[8] Wholesale & Retail Water Rates are calculated based on 6,300 gallons per month per residence








WCRWSA10.XLS
A-14





Analysis 2


Financial Analysis for Pinellas County
Includes all Member Facilities


$11000 gal. under OPTION # 4
Year Projected Uniform Acquisition Master ad Total Credit for Net Costs New New Retail 1995 % change
Water Rate for of all Water valorem Costs sale of $11000 Wholesale Rate $ / Retail in Retail
Usage existing Facilities Plan tax credit $11000 Facilities gallons Rate $ / month / Rate $ / Rates
(mgd) Facilities Facilities gallons month / residence month /
___residence residence
2000 82.45 $ 0.63 $ 0.25 $ 0.05 $ (0.08) $ 0.85 $ (0.25) $ 0.61 $ 3.82 $ 13.55 $ 13.20 2.69%
2005 85.23 $ 0.63 $ 0.25 $ 0.09 $ (0.07) $ 0.90 $ (0.24) $ 0.66 $ 4.14 $ 13.88 $ 13.20 5.15%
2010 87.33 $ 0.58 $ 0.27 $ 0.21 $ (0.07) $ 0.99 $ (0.23) $ 0.76 $ 4.78 $ 14.51 $ 13.20 9.96%
2015 88.98 $ 0.44 $ 0.32 $ 0.23 $ (0.07) $ 0.92 $ (0.23) $ 0.70 $ 4.39 $ 14.12 $ 13.20 6.99%

$11000 gal. under OPTION # 5
Year Projected Rate for Acquisition Master ad Total Credit for Net Costs New New Retail 1995 % change
Water existing of all Water valorem Costs sale of $11000 Wholesale Rate $ / Retail in Retail
Usage Facilities Facilities Plan tax credit $/1000 Facilities gallons Rate $ / month / Rate $ / Rates
(mgd) Facilities gallons month / residence month /
___residence residence
2000 82.45 $ 0.60 $ 0.22 $ 0.05 $ (0.08) $ 0.79 $ (0.25) $ 0.54 $ 3.41 $ 13.15 $ 13.20 -0.37%
2005 85.23 $ 0.60 $ 0.22 $ 0.08 $ (0.07) $ 0.83 $ (0.24) $ 0.59 $ 3.70 $ 13.45 $ 13.20 1.86%
2010 87.33 $ 0.55 $ 0.24 $ 0.20 $ (0.07) $ 0.92 $ (0.23) $ 0.69 $ 4.35 $ 14.09 $ 13.20 6.74%
2015 88.98 $ 0.43 $ 0.29 $ 0.22 $ (0.07) $ 0.86 $ (0.23) $ 0.64 $ 4.01 $ 13.75 $ 13.20 4.16%

Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[3] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[4] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
[5] Existing, acquired and the Master Water Plan Facilities will be operated at 75% of permitted capacity, 25% rotational reserve
[6] Wholesale & Retail Water Rates are calculated based on 6,300 gallons per month per residence
[7] For Option # 5 1995 ratio of water usage to water entitlement is used for individual member government



WCRWSA10.XLS
A-15





Analysis


Water Rate Analysis for Pinellas County


OPTION # 4 Wholesale Water Rates
Year 1995 Including % Change Excluding % Change Including % Change
Wholesale City of City of Morris
Rate Tampa's Tampa's Bridge WF
($/1000 Facilities Facilities only
gallons.)
2000 $ 0.55 $ 0.61 10.23% $ 0.52 -5.30% $ 0.52 -6.15%
2005 $ 0.55 $ 0.66 19.61% $ 0.59 7.44% $ 0.58 6.23%
2010 $ 0.55 $ 0.76 37.92% $ 0.72 30.99% $ 0.71 29.12%
2015 $ 0.55 $ 0.70 26.63% $ 0.64 17.02% $ 0.64 15.66%

OPTION # 4 Retail Water Costs
Year 1995 Retail Including % Change Excluding % Change Including % Change
Rate City of City of Morris
($/month/ Tampa's Tampa's Bridge WF
residence) Facilities Facilities only

2000 $ 13.20 $ 13.55 2.69% $ 13.02 -1.39% $ 12.99 -1.61%
2005 $ 13.20 $ 13.88 5.15% $ 13.46 1.95% $ 13.42 1.63%
2010 $ 13.20 $ 14.51 9.96% $ 14.27 8.14% $ 14.21 7.64%
2015 $ 13.20 $ 14.12 6.99% $ 13.79 4.47% $ 13.74 4.11%


OPTION # 5 Wholesale Water Rates
Year 1995 Including % Change Excluding % Change Including % Change
Wholesale City of City of Morris
Rate Tampa's Tampa's Bridge WF
($/1000 Facilities Facilities only
gallons.)
2000 $ 0.55 $ 0.54 -1.42% $ 0.46 -16.50% $ 0.45 -17.47%
2005 $ 0.55 $ 0.59 7.08% $ 0.52 -4.90% $ 0.52 -6.18%
2010 $ 0.55 $ 0.69 25.67% $ 0.65 18.97% $ 0.64 17.02%
2015 $ 0.55 $ 0.64 15.84% $ 0.59 6.78% $ 0.58 5.29%

OPTION # 5 Retail Water Costs
Year 1995 Retail Including % Change Excluding % Change Including % Change
Rate City of City of Morris
($/month/ Tampa's Tampa's Bridge WF
residence) Facilities Facilities only

2000 $ 13.20 $ 13.15 -0.37% $ 12.63 -4.33% $ 12.59 -4.59%
2005 $ 13.20 $ 13.45 1.86% $ 13.03 -1.29% $ 12.99 -1.62%
2010 $ 13.20 $ 14.09 6.74% $ 13.86 4.98% $ 13.79 4.47%
2015 $ 13.20 $ 13.75 4.16% $ 13.43 1.78% $ 13.38 1.39%


Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] Credits for sale of Facilities is included in the wholesale and retail rates where applicable
[3] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[4] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[5] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan
[6] Existing, acquired and the Master Water Plan Facilities will be operated at 75% of permitted capacity, 25% rotational reserve
[7] For Option # 5 1995 ratio of water usage to water entitlement is used for individual member government
[8] Wholesale & Retail Water Rates are calculated based on 6,300 gallons per month per residence








WCRWSA10.XLS
A-16


~;;"~"





Analysis 2


Financial Analysis for City of St. Petersburg
Includes all Member Facilities
$11000 gal. under OPTION # 4
Year Projected Uniform Acquisition Master ad Total Credit for Net Costs New New Retail 1995 % change
Water Rate for of all Water valorem Costs sale of $11000 Wholesale Rate $ / Retail in Retail
Usage existing Facilities Plan tax credit $11000 Facilities gallons Rate $ / month / Rate $ / Rates
(mgd) Facilities Facilities gallons month / residence month /
residence residence
2000 39.90 $ 0.63 $ 0.25 $ 0.05 $ (0.08) $ 0.85 $ (0.50) $ 0.35 $ 2.23 $ 12.32 $ 11.61 6.15%
2005 41.03 $ 0.63 $ 0.25 $ 0.09 $ (0.07) $ 0.90 $ (0.48) $ 0.41 $ 2.59 $ 12.69 $ 11.61 9.26%
2010 41.90 $ 0.58 $ 0.27 $ 0.21 $ (0.07) $ 0.99 $ (0.47) $ 0.52 $ 3.25 $ 13.35 $ 11.61 14.97%
2015 43.00 $ 0.44 $ 0.32 $ 0.23 $ (0.07) $ 0.92 $ (0.46) $ 0.46 $ 2.91 $ 13.01 $ 11.61 12.02%

$11000 gal. under OPTION # 5
Year Projected Rate for Acquisition Master ad Total Credit for Net Costs New New Retail 1995 % change
Water existing of all Water valorem Costs sale of $11000 Wholesale Rate $ / Retail in Retail
Usage Facilities Facilities Plan tax credit $11000 Facilities gallons Rate $ / month / Rate $ / Rates
(mgd) Facilities gallons month / residence month /
__ residence residence_
2000 39.90 $ 0.63 $ 0.25 $ 0.05 $ (0.08) $ 0.86 $ (0.50) $ 0.36 $ 2.26 $ 12.37 $ 11.61 6.52%
2005 41.03 $ 0.63 $ 0.25 $ 0.09 $ (0.07) $ 0.90 $ (0.48) $ 0.42 $ 2.62 $ 12.73 $ 11.61 9.66%
2010 41.90 $ 0.58 $ 0.27 $ 0.21 $ (0.07) $ 1.00 $ (0.47) $ 0.52 $ 3.29 $ 13.39 $ 11.61 15.35%
2015 43.00 $ 0.44 $ 0.33 $ 0.23 $ (0.07) $ 0.93 $ (0.46) $ 0.47 $ 2.94 $ 13.05 $ 11.61 12.36%

Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[3] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[4] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
[5] Existing, acquired and the Master Water Plan Facilities will be operated at 75% of permitted capacity, 25% rotational reserve
[6] Wholesale & Retail Water Rates are calculated based on 6,300 gallons per month per residence
[7] For Option # 5 1995 ratio of water usage to water entitlement is used for individual member government




WCRWSA10.XLS
A-17






Analysis


Water Rate Analysis for City of St. Petersburg


OPTION # 4 Wholesale Water Rates
Year 1995 Including % Change Excluding % Change Including % Change
Wholesale City of City of Morris
Rate Tampa's Tampa's Bridge WF
($/1000 Facilities Facilities only
gallons.)
2000 $ 0.24 $ 0.35 47% $ 0.27 12% $ 0.26 10%
2005 $ 0.24 $ 0.41 71% $ 0.34 43% $ 0.34 40%
2010 $ 0.24 $ 0.52 115% $ 0.48 99% $ 0.47 95%
2015 $ 0.24 $ 0.46 92% $ 0.41 70% $ 0.40 67%

OPTION # 4 Retail Water Costs
Year 1995 Retail Including % Change Excluding % Change Including % Change
Rate City of City of Morris
($/month/ Tampa's Tampa's Bridge WF
residence) Facilities Facilities only

2000 $ 11.61 $ 12.32 6% $ 11.79 2% $ 11.76 1%
2005 $ 11.61 $ 12.69 9% $ 12.26 6% $ 12.22 5%
2010 $ 11.61 $ 13.35 15% $ 13.11 13% $ 13.04 12%
2015 $ 11.61 $ 13.01 12% $ 12.67 9% $ 12.63 9%


OPTION # 5 Wholesale Water Rates
Year 1995 Including % Change Excluding % Change Including % Change
Wholesale City of City of Morris
Rate Tampa's Tampa's Bridge WF
($/1000 Facilities Facilities only
gallons.)
2000 $ 0.24 $ 0.36 50% $ 0.27 14% $ 0.27 12%
2005 $ 0.24 $ 0.42 74% $ 0.35 46% $ 0.34 43%
2010 $ 0.24 $ 0.52 118% $ 0.48 102% $ 0.47 98%
2015 $ 0.24 $ 0.47 95% $ 0.41 73% $ 0.41 70%

OPTION # 5 Retail Water Costs
Year 1995 Retail Including % Change Excluding % Change Including % Change
Rate City of City of Morris
($/month/ Tampa's Tampa's Bridge WF
residence) Facilities Facilities only

2000 $ 11.61 $ 12.37 7% $ 11.83 2% $ 11.80 2%
2005 $ 11.61 $ 12.73 10% $ 12.31 6% $ 12.27 6%
2010 $ 11.61 $ 13.39 15% $ 13.15 13% $ 13.09 13%
2015 $ 11.61 $ 13.05 12% $ 12.71 9% $ 12.66 9%


Assumptions:
[1] Acquisition of wellfields will be financed @ 7.25% interest, 30 year term, one P + I payment
[2] Credits for sale of Facilities is included in the wholesale and retail rates where applicable
[3] O&M for the Authority managed, acquired and the Master Water Plan Facilities are not adjusted for inflation
[4] Wellfield land will be purchased by the Authority using SWFWMD's land preservation program funds
[5] 85 million gallons of new capacity will be added between 1997-2008 through construction of the Master Water Plan projects
(6] Existing, acquired and the Master Water Plan Facilities will be operated at 75% of permitted capacity, 25% rotational reserve
[7] For Option # 5 1995 ratio of water usage to water entitlement is used for individual member government
[8] Wholesale & Retail Water Rates are calculated based on 6,300 gallons per month per residence







WCRWSA10.XLS
A-18




University of Florida Home Page
© 2004 - 2010 University of Florida George A. Smathers Libraries.
All rights reserved.

Acceptable Use, Copyright, and Disclaimer Statement
Last updated October 10, 2010 - - mvs