HomeMy WebLinkAboutAGENDA REPORT 2003 1105 CC REG ITEM 09AMOORPARK CITY COUNCIL
AGENDA REPORT
ITEM Q . A.
CITY (IF '�MORPVR , CAUL INTA
C Cmincji lice mg
TO: Honorable City Council
FROM: Cynthia L. Borchard, Administrative Services Director op
Ken Gilbert, Public Works Director w,/,
DATE: October 17, 2003 (CC meeting of November 5, 2003)
SUBJECT: GASB Statement No. 34 Infrastructure Inventory Final
Report
SUMMARY
The following presents Harris & Associates summary information
provided in their Final Report on the valuation of each
Subsystem of Infrastructure Asset for the purpose of reporting
in financial statements in accordance with Government Accounting
Standards Board (GASB) Statement No. 34 and for use in the
City's accounting records. Below is the overall summary of the
current Net Book Value of the infrastructure assets by
Subsystem, Network and grand total. Total current Net Book
Value through 6/30/2003 of all assets inventoried and valued in
this project is $222,027,514 (See Page 12 of the report for
detail) .
BACKGROUND
By release of Statement 34 on June 30, 1999, the Governmental
Accounting Standards Board, a national non - profit organization,
requires that states, local governments and other public
agencies annually report (full disclosure) the net value of all
capital assets, including infrastructure assets, in order to
achieve GAAP (generally accepted accounting principles). GASB
34 defines infrastructure assets as "...long -lived capital
assets that are stationary in nature and normally can be
preserved for a significantly greater number of years than most
capital assets. Examples of infrastructure assets include
roads, bridges, tunnels, drainage systems, water and sewer
Honorable City Council
November 5, 2003
Page 2
systems, dams and lighting systems...". Land is also reported
as a Capital Asset. The asset values are to be reflected in the
City's accounting documents and are subject to audit by the
City's independent auditor. Further, these values are to be
reported in the City's Comprehensive Annual Financial Report
(CAFR) .
DISCUSSION
GASB 34 provides public agencies with two options for valuation
and reporting the value of assets.
1.Basic Approach:
• Up -to -date inventories must be
accomplished /maintained
• Acquisition dates or estimated acquisition dates
must be applied
• Original acquisition costs or estimated
acquisition costs must be applied
• Depreciation must be applied to historical values
2. Modified Approach:
• Up -to -date inventories must be
accomplished /maintained
• Original acquisition costs or estimated costs
must be applied
• Asset management systems must be put in place and
include condition level assessment and setting
every three years with costs budgeted to match
condition level policies
GASB 34 requires compliance by certain dates based upon annual
revenues of public agencies. The City of Moorpark is what is
called a Phase II agency, which had annual revenue of between
$10 million and $100 million on July 1, 1999. This requires the
City to begin reporting assets for the fiscal year ending June
30, 2003.
The City provided directions with respect to approach and
methodology for GASB 34 infrastructure valuation and reporting,
which include the following:
M.1 1
Honorable City Council
November 5, 2003
Page 3
• All infrastructure assets will be capitalized and
depreciated, rather than using the "modified
approach ". (This latter approach would involve asset
management and imply significant financial commitment
at this point to maintain asset condition levels).
• Straight line depreciation will be used to arrive at
Net Book Value.
• All significant costs associated with infrastructure
assets are to be capitalized, including Engineering
Design, Construction Management, or other soft costs.
• All such assets are to be capitalized from date of
acquisition or estimated date of acquisition.
• Reasonable estimation techniques to arrive at
estimated acquisition dates historical costs (using
standard industry price indexes) for such assets are
acceptable.
Harris & Associates was retained to prepare a comprehensive
infrastructure valuation for the purpose of reporting the
current Net Book Value of Infrastructure Assets (assets) in
compliance with GASB 34.
Using source file information and inventories as well as
information obtained from City staff, the work involved the
review or completion of certain inventories, determination of
historical costs and acquisition dates (estimated and actual)
for assets.
In addition, useful life determinations were made so that
depreciation can be calculated (using the Basic Approach
prescribed in GASB 34) to arrive at current Net Book Value (also
expressed as residual value). This information will be used to
prepare a Statement of Net Fixed Assets for our financial
reports. Depreciation is not a cash item in our accounting
system. It is only used to expense the asset over time and
reflect the net value of the asset on an annual basis. This
annual depreciation amount should be spent on replacement if
possible. The accumulated depreciation amount also is used to
gage when various systems need to be upgraded /replaced.
The summary on page 12 of the report indicates that the City's
current total accumulated depreciation for all assets is $20.6
million dollars (original cost less current net value). This
reflects that 9% of the City's total assets are depreciated due
Honorable City Council
November 5, 2003
Page 4
to age. Subtracting land and rights -of -way that do not
depreciate, the percentage of assets depreciated due to age is
23 %. Although the ideal situation would be to be able to fund
the total replacement cost, it is really not feasible and is
unlikely that any city can afford to budget for this expense.
The City will annually evaluate its ability to fund a portion of
the replacement cost as part of the budget process.
The minimum requirement for compliance with GASB Statement 34 is
to provide infrastructure valuations for all assets constructed,
acquired, or placed into service on or after July 1, 1980. Each
asset was reviewed to determine the adequacy of the data to
value the asset to the date of the City's incorporation - -July,
1983.
The following assets were included in the valuation:
NETWORK
SUBSYSTEM
Land
Land
Rights -of -Way
Storm Drainage System
Pipes
Park & Recreation Facilities
Bike Path
Roadways /Streets
Pavement (AC)
Curb and Gutter
Sidewalks
Traffic Regulatory Signs
Traffic Signals
Street Trees
Bridges
Parking Lots (Pavement)
Medians and Parkways
In accordance with GASB 34, the City is required to disclose its
policy for estimating the "useful lives" of Networks and
Subsystems of Infrastructure and Capital Assets. Use of the
Basic Approach (depreciation methodology) of valuing such assets
requires a determination of useful life of each type of asset in
order to properly complete the formula for determining
depreciation and arriving at Net Book Value. Based upon the
consultant firm's experience, utilization of industry standards,
and consideration of conditions unique to the City, the
Honorable City Council
November 5, 2003
Page 5
following have been determined to be the useful life of each
relevant Capital /Infrastructure Asset:
* Note: Trees are estimated to increase in value as they age therefore
a useful life is not established for depreciation purposes.
FISCAL IMPACT:
Acceptance by the City Council of Harris & Associates' Final
Report on GASB 34 Compliance has no fiscal impact on the City,
per se. This impact was assessed as part of the approval of the
firm to perform the work several months ago. The City will
receive the data from Harris on CD -rom and will be responsible
for keeping the data up -to -date. The required and continued
implementation of GASB 34 will somewhat impact the staff in
terms of increased workload; however, it will be absorbed by
existing staff.
STAFF RECOMMENDATION:
Accept Harris and Associates Final Report, dated October 27,
2003, and entitled "Final Report, GASB 34 Infrastructure
Valuation Services."
ATTACHMENT: Harris & Associates Infrastructure Valuation
Report
USEFUL
NETWORK
SUBSYSTEM
LIFE
Roadways /Streets
Pavement (AC)
30
Curb & Gutter
100
Sidewalks
100
Traffic Signals
25
Traffic Regulatory Signs
7
Street Trees
N/A
Bridges
100
Parking Lots (Pavement)
30
Medians and Parkways
100
Storm Drainage System
Pipes
100
Park & Recreation
Bike Path
50
Land
N/A
N/A
Rights -of -Way
N/A
N/A
* Note: Trees are estimated to increase in value as they age therefore
a useful life is not established for depreciation purposes.
FISCAL IMPACT:
Acceptance by the City Council of Harris & Associates' Final
Report on GASB 34 Compliance has no fiscal impact on the City,
per se. This impact was assessed as part of the approval of the
firm to perform the work several months ago. The City will
receive the data from Harris on CD -rom and will be responsible
for keeping the data up -to -date. The required and continued
implementation of GASB 34 will somewhat impact the staff in
terms of increased workload; however, it will be absorbed by
existing staff.
STAFF RECOMMENDATION:
Accept Harris and Associates Final Report, dated October 27,
2003, and entitled "Final Report, GASB 34 Infrastructure
Valuation Services."
ATTACHMENT: Harris & Associates Infrastructure Valuation
Report
sw a a
l
e
l
Harris & Associates
� ates
Program Managers
Construction Managers
Civil Engineers
October 27, 2003
Cynthia L. Borchard
Administrative Services Director
City of Moorpark
799 Moorpark Avenue
Moorpark, CA 93021
Subject: Final Report — GASB 34 Infrastructure Valuation Services
Dear Ms. Borchard:
Transmitted herewith is the Final Report in conjunction with the GASB 34 Infrastructure
Valuation Services project.
The information contained in this report presents the findings from our valuation of the City's
infrastructure assets as they pertain to the requirements of GASB 34. The Final Report also
contains the necessary support documentation and methodologies that were used to develop the
historic costs and current net book values. We are confident that the approach and methodologies
embodied in this report meet the rigors of GASB 34 and that of your independent auditor.
We really enjoyed working with you and your staff on this project! Should you have any
questions or need additional information, please contact me at (800) 860 -3625 X536.
H is & ssociates
on d Creagh f'
GASB 3 Group Manager
c : Jeffrey M. Cooper, P.E. Senior -Vice President
Dennis A. Anderson, Project Engineer /Associate
000018
34 Executive Park, Suite 150 Irvine, California 92614 -4705 949.655.3900 FAX 949.655.3995 Irvine @harris- assoc.com
I
Draft Report: GASB Statement 34 October 27, 2003
Infrastructure Valuation Services Page i
TABLE OF CONTENTS
Page
SUMMARY OF GASB 34 REQUIREMENTS AND DEADLINES... .................................... ...................
I
BACKGROUND AND INTRODUCTION ............................... - ........................ ............... ......._._....
2
PROJECT UNDERSTANDING ..--------••-----•-----•--------------•-.........._............. ...............................
3
SCOPE OF SERVICES ........................................
4
DETERMINATIONS RE: GASB 34 REQUIREMENTS ............................................ .............................10
Assetsto be Reported ...... ............ . .. .......•---------------•--........._..............-----------.......-•---- ...................._........10
ReportingMethod ..............••-----..........................--••----------•---•-•-----............................. ..................•-----
.....10
GASB34 Reporting Level ....---••-------•-------------•--......_.._..----•----.......--------..............----. ........•- •- •- ...............10
CapitalizationPolicy . .. ...............•-•-------........._....--------------........-•---......-.--•-----.. .......•- ••-- ..................
..10
Useful Life of Infrastructure Assets ---• ...................................................................... •- ••----------- ••......--
-• -.10
ValuationMethodology ..........................................................................................................................
1 I
Valuation of Pre -1980 Infrastructure Assets ....................... ..•-- ....................................... .•-- ...------------
....11
ENRIndexing and Units Costs ...............................................................................................................
11
SUMMARYOF FINDINGS ........................... ..........................................•--•-•--.......------ ......................--
• -..12
✓+
Streets/Roadways Network—Pavement ........................................ ........................... ................... ..........13
Streets/Roadways Network --Curb and Gutter .......................................................... ............ .. ...............14
Streets /Roadways Network— Sidewalks ................ ..................................................
15
Streets/Roadways Network — Traffic Signals ............... ............................... _..................__....16
Streets/Roadways Network — Traffic Regulatory Signs ............................................ .............................17
Streets/Roadways Network — Street Trees ................................................................ .............................18
Streets/Roadways Network — Bridges .............................
Streets/Roadways Network — Parking Lots (Pavement). ........................................................................ 20
Streets/Roadways Network — Medians and Parkways Landscaping ......................... .............................21
Storm Drain Network — Pipes .....................
.....22
k
Parks & Recreation Network —Bike Path.. .............................. ................................. .................
......... 23
LandNetwork ........ ............................................................................................................... - - -••-
.........24
PROCEDURES FOR CAPTURING FUTURE GASB 34 INFORMATION ............... .............................25
PROCEDURES FOR UPDATING THE ASSET MODULES ...................... .............................26
APPENDIX (Exhibits A - P)
_
000019
QWoorparkfinal Report.doc
j
Harris & Associates
Draft Report: GASB Statement 34
Infrastructure Valuation Services
October 27, 2003
Page 1
SUMMARY OF GASB 34 REQUIREMENTS AND DEADLINES
By release of Statement 34 on June 30, 1999, the Governmental Accounting Standards Board, a national
non -profit organization, now requires that states, local governments and other public agencies annually
report (full disclosure) the net value of all capital assets, including infrastructure assets, in order to
achieve GAAP (generally accepted accounting principles). GASB 34 defines infrastructure assets as
"...long -lived capital assets that are stationary in nature and normally can be preserved for a
significantly greater number ofyears than most capital assets_ Examples of infrastructure assets include
roads, bridges, tunnels, drainage systems, water and sewer systems, dams and lighting systems._. " In
addition, land is to be valued at original cost without depreciation.
• Basic Approach:
gZZ
• Up -to -date inventories must be accomplished/maintained
Original acquisition costs or estimated costs must be applied
• Depreciation must be applied to historical values
• Modified Approach:
• Up to date inventories must be accomplished/maintained
• Original acquisition costs or estimated costs must be applied
• Asset management systems must be put in place and include condition level assessment and
setting every three years with costs budgeted to match condition level policies.
GASB 34 requires compliance by certain dates based upon annual revenues of public agencies. The City
of Moorpark is what is called a Phase II agency, which had annual revenue of between $10 million and
$100 million on July 1, 1999. This requires that the City begin reporting assets for the fiscal year ending
June 30, 2003. A four -year "grace /transition period" is allowed for reporting "major general
infrastructure assets" under certain conditions.
Note: The City selected the `Basic Approach" to be applied to all infrastructure assets.
QAMoorparffinal Report.doc
1 00002N 0
Harris & Associates
Draft Report: GASB Statement 34
Infrastructure Valuation Services
BACKGROUND AND INTRODUCTION
October 27, 2003
Page 2
Harris & Associates was retained by the City of Moorpark to prepare a comprehensive infrastructure
valuation for the purpose of reporting the current Net Book Value of Infrastructure Assets (assets) in
compliance with GASB 34.
Infrastructure Inventory and Valuation
Using source file information and inventories as well as information obtained from City staff, the work
involved the review or completion of certain inventories, determination of historical costs and acquisition
dates (estimated and actual) for assets_ In addition, useful life determinations were made so that
depreciation can be calculated (using the Basic Approach prescribed in GASB 34) to arrive at current Net
Book Value (also expressed as residual value). The minimum requirement for compliance with GASB
Statement 34 is to provide infrastructure valuations for all assets constructed, acquired, or placed into
service on or after July 1, 1980. Relevant assets were valued to one of two dates: 1) the original date of
construction, if available, or 2) the incorporation date of the City (1983). Each asset was reviewed to
determine the adequacy of the data to value the asset prior to July 1, 1980 (see the individual asset
summaries for these determinations).
Valuations are provided, as requested by your auditor, for June 30, 2002 and June 30, 2003. This gives
you asset value balances for the end of FY2001 -02 and the beginning of FY2002 -03 as well as ending
balances for FY2002 -03 and the beginning of FY2003 -04. These separate valuations are noted on the
valuation summaries in the text of the report and the supporting spreadsheets (asset modules).
Initially, Street Lights were to be inventoried and valued. However, the City owns only a few street lights
which was determined not be material for reporting purposes.
�rltr
QAMoorparffinai Report.doc
� Harris &Associates
BR
Draft Report: GASB Statement 34 October 27, 2003
Infrastructure Vatuation Services Page 3
PROJECT UNDERSTANDING
City Guidance and Direction
The City Council has made decisions and provided directions with respect to approach and methodology
for GASB 34 infrastructure valuation and reporting, which include the following:
• All infrastructure assets will be capitalized and depreciated, rather than using the "modified
approach."
• Straight -line depreciation will be used to arrive at Net Book Value.
• All significant costs associated with infrastructure assets are to be capitalized, including
Engineering Design, Construction Management, or other soft costs.
• All such assets are to be capitalized from date of acquisition or estimated date of acquisition.
• Reasonable estimation techniques to arrive at estimated acquisition dates historical costs (using
standard industry price indexes) for such assets are acceptable.
Networks and Subsystems
The following are the Networks and Subsystems of Infrastructure Assets included in the valuation work.
Network
Subsystem
Roadways /Streets
Pavement (AC)
Curb & Gutter
Sidewalks
Traffic Signals
Traffic Regulatory Signs
Street Trees
Bridges
Parking Lots (Pavement)
Medians and Parkways
Storm Drainage System
Pipes
Parks & Recreation Facilities
Bike Path
Land
Land
Rights -of -Way
QAMoorparffina9 Reportdoc
000022
Harris & Associates
Draft Report: GASB Statement 34
Infrastructure Valuation Services
SCOPE OF SERVICES
Project Approach
October 27, 2003
Page 4
The following represents our approach to the Infrastructure Inventory and Valuation project in order to
achieve the City's internal objectives as well as GASB 34. compliance. In essence, it served as our
proposed "Scope of Services" for the project and provided you with a narrative of what we believed were
essential tasks, detailed tasks, steps, and methodologies for phases and components that were proposed to
accomplish the project.
Essential Tasks
These were the essential tasks performed for the inventory and valuation of assets for the project:
Determined the adequacy of existing inventories and other City records for availability of Network
and Subsystem information on assets, including quantity, location, acquisition dates, historical
costs.
Assembled and analyzed detailed inventories of the relevant Infrastructure assets by type and
components /features.
Compiled inventories based upon City records and other source data for utilization of the Basic
Approach (depreciation).
Determined the classification of assets and the reporting level for asset type: Network or
Subsystem.
Evaluated and provided advice with respect to appropriate capitalization level policy /threshold for
infrastructure assets.
• Determined actual acquisition (or placed in service) date, or estimated the acquisition date.
• Determined useful life of assets by asset type.
• Established unit cost(s) of assets (by Network and Subsystem) and component parts/features to
establish replacement cost, and utilize composite cost methodology when necessary and
appropriate. Actual costs were used when available.
• Found actual historical cost or applied the ENR Construction Cost Index to arrive at estimated
historical cost when actual cost is not available.
• Utilized "straight line" depreciation to arrive at Net Book Value of assets. The depreciation
formula used is as follows:
E,�rr
Q.Wtoorparffinal Report.doc M I Harris & Associates
Draft Report: GASB Statement 34 October 27, 2003
Infrastructure Valuation Services Page 5
Straight -Line Depreciation Formula
Step l:
Estimated Historical Cost / Estimated Useful Life = Annual Depreciation
Step 2:
Annual Depreciation x Current Age = Accumulated Depreciation
Step 3:
Estimated Historical Cost - Accumulated Depreciation = Current Net Book Value
Work Plan by Tasks and Methodologies
This provided the City with the necessary inventory, source data analysis and valuation work for the
selected assets. The level of effort included those tasks specifically required by the City in the Request
for Proposal. The deliverable will be a Final Report that contains a Master File inclusive of all necessary
inventory, historical cost, acquisition dates, depreciation schedules, methodologies, calculations, and Net
Book Value.
Task No. 1: Review CompletenesslAdequacy of City Inventories and Records
This involved a preliminary review of City - provided information, including existing inventories, bond
records, subdivision and parcel maps, PMS (Pavement Management System), GIS (Geographic
Information System), Capital Improvement Programs, and civil improvement plans to determine the
extent to which sufficient records exist which contain actual acquisition dates and historical costs on
assets and what "information gaps" exist. This was necessary to determine their reliability for use and the
extent to which estimates of acquisition dates and historical costs needed to be used. This also assisted in
determining whether information should be collected and/or estimated on the Network or Subsystem level
for which assets and whether sufficient information was available to report the value of assets acquired
prior to July 1, 1980.
We met with City staff to review the preliminary findings and recommendations so that determinations
could be made on the best methodologies to be used for the valuation work on each of the asset types and
components.
Task No. 2: Inventory Research
Step 1. In -depth Review of Inventories and City Records:
A. Use of Existing Inventories/Records: This methodology was to be used for all assets. The
examination included review of GIS and PMS data, existing inventories, master plans, bond records,
"as- builts," engineering information, and other documents. These materials primarily assisted in
determining the date of acquisition (construction or placed into service), and the data gleaned served
as the basis for determining historical costs.
'00002
QAMoorparkTinai Reportdoc Harris & Associates
Draft Report: GASB Statement 34
Infrastructure Valuation Services
October 27, 2003
Page 6
B. Where historical data was unavailable or required substantial research to complete, we used
statistically representative sampling techniques to arrive at estimates of acquisition dates as well as
asset value using unit costs, composite costing and composite depreciation.
Step 2. Determine Asset Classification and Network/Subsystem Reporting Level:
Based upon the nature, extent, and detail of data reviewed, recommendations were made for the purposes
of identifying and classifying relevant assets. In particular, this effort was focused on identifying GASB
34 Networks and Subsystems of the assets as well as the level of asset component that was utilized for
inventory and asset management purposes.
Step 3. Determination of Useful Life:
Based upon the appropriate classification and level of asset component desired for asset management and
GASB 34 reporting purposes, recommendations were prepared with respect to the useful life of assets
(and asset components). These determinations were necessary in order to calculate the annual
depreciation assets. When joined with the acquisition date and historical cost, accumulated depreciation
and Net Book Value could be determined.
Step 4. Evaluation of Existing and Appropriate Capitalization Level Policy
We evaluated the existing capitalization level policy and provided advice on an appropriate threshold
level for capital and infrastructure assets, which typically have substantially more value than "fixed
assets" (building contents, equipment, fleet, etc.).
Task No. 3: Acquisition and Valuation Effort
This involved the multiple tasks of retrieving or estimating asset acquisition dates and historical costs
when necessary and calculating depreciation based upon these factors as well as useful life in accordance
with the formula shown earlier. The following provides the methodologies used to achieve these
calculations and arriving at Net Book Value.
Acquisition Date Methodology: Actual acquisition dates were used for all asset types, or estimates were
made based upon available data. Estimated acquisitions were used when "actuals" were not available.
Q \Moorparffinal Reportdoc
� Barris &Associates
Draft Report: GASB Statement 34 October 27, 2003
Infrastructure Valuation Services Page 7
Costing Methodology: The "composite cost" method was used to establish historical cost where actual
original cost could not be determined. In these situations, replacement value was determined on a current
unit cost basis_ Unit costs were applied to appropriate asset components and Subsystems in terms of total
square footage, linear footage, or other appropriate unit measurement.
Valuation Methodology: Actual historical costs were used when available in City records. The ENR
Construction Cost Index was applied to arrive at estimated historical cost, when necessary. Straight -line
depreciation was applied to the useful life for the assets, and "composite depreciation" was used in
conjunction with composite costing, as necessary and based upon lack of available actual data. This
achieved historical cost as well as current/replacement cost, accumulated depreciation, annual
depreciation and resulted in current Net Book Value.
Task No. 4: Comprehensive Maintenance and Perpetuation Procedures
Step 1. Establish Asset Modules via Microsoft Excel for Networks /Subsystems:
These modules provide the following detailed information: Asset description, component and Subsystem,
quantities, historical cost, acquisition date, unit cost, replacement cost, useful life, annual depreciation,
accumulated depreciation, and calculations of salvage /residual (Net Book Value).
This information was documented in spreadsheets and appears in the Draft Final Report Appendices.
They are also available in electronic form (Microsoft Excel) via CD -ROM. These spreadsheets (Asset
Modules) will be helpful in future years in that "future" asset data (quantities, costs, acquisition dates, and
useful Iife) can be input into the Asset Modules, and the computer program will perform the calculations
for annual depreciation, accumulated depreciation, and Net Book Value. These data will serve as the
City's Master File for GASB 34 reporting purposes.
Step 2. Preparation of an Administrative Instruction and Form for Capturing Future Asset
Information:
An "Administrative Instruction" memorandum was prepared along with a one -page form, which can be
used (electronically or hard copy) by applicable City divisions and departments in capturing infrastructure
asset information in future years, both for asset management and GASB 34 reporting purposes.
Suggested instructions are provided on what and when such information should be collected. The form
provides the format for the information detail (asset /asset component, location, quantity, cost, acquisition
date, etc.) such that it can be easily transferred to the Asset Modules (Master File) and City
accounts /financial records /statements.
Task No. S: Project Planning and Coordination
City staff was periodically provided with the following communications on the progress of the project:
Project Orientation- Kickoff Meeting: This initial meeting introduced the City staff and Harris
team. Discussion items included initial review of inventories and other source data, location of
this information, in -house work area for research, discussion of methodologies, classification of
assets, designation of Networks /Subsystems, capitalization policies, project contacts, and project
work schedule.
Verbal communication as often as necessary in order to verify, refine, and complete the project
and review project progress.
002
QAMoorparffinai Report. doc
� � Harris &Associates
Draft Report: GASB Statement 34 October 27, 2003
Infrastructure Vatuation Services Page 8
Task No. 6: Preparation of GASB 34 Final Reports)
Step 1: Prepare Summary of Findings:
We view this as a "Draft Final Report" document that can be easily reviewed and understood by City
Council staff, the general public and the City's independent auditor. This report contains and is formatted
in the following manner:
A. General Summary: This provides a summary of the project, GASB 34 requirements, information
sources, basic recommendations and determinations, methodologies (procedures and definitions)
used, and a listing of asset/asset components categorized with Networks and Subsystems.
B. Separate Sections for each Asset (by component classification and Subsystem): Each Section is
organized in a manner that the City can report either by Network or Subsystem and includes the
following information:
• Asset name or description, within designated reporting category of Network or Subsystem.
• Summary inventory of Asset, identifying major components.
• Listing of resources (City records) used to assemble /compile inventories.
• Location (address or to /from) if available.
• Quantities (appropriate unit measurements).
• Replacement cost and unit cost.
• Methodologies used to determine acquisition dates.
• Useful life of each Asset by type /subsystem.
• Methodology used to determine acquisition date.
• Methodology used to determine historical cost, including calculations.
• Formula/methodologies for applying depreciation (straight -line) to determine Net Book Value,
including calculations.
• Net Book Value of each asset/asset component by Subsystem, as of July 1, 2002 and June 30,
2003.
C. Appendices /Spreadsheets: Detailed spreadsheets documenting all asset components, with quantities,
historical costs, cost indexes, useful life(s), depreciation (accumulated and annual), and salvage/
residual value (Net Book Value results) showing all calculations. This document, along with the
narrative Final Report constitutes the "Master File" for the production of required GASB 34 financial
records and statements.
Step 2. Review Results with, and Presentation to City Project Team:
Q kMoorparffinat Report.doc
Harris & Associates
Draft Report: GASB Statement 34
Infrastructure Valuation Services
October 27, 2003
Page 9
We met with the designated City staff and others (such as the City's auditor) to present, review, and
clarify any aspects of the "Draft Final Report." This meeting is in addition to the Progress Meetings
referenced earlier.
Step 3. Final Report:
The Final Report and Appendices contain all necessary historical cost, useful life, replacement value, unit
cost, and depreciation information for the identified assets in the format described in Task No_ 6, Step 1
(above). All support documentation is provided electronically and by hard copy. This allows for prompt
and efficient implementation in the City's accounting records and for production of GASB 34- compliant
financial statements.
Q:IMoorparffinal Report.doc Harris & Associates
Draft Report: GASB Statement 34 October 27, 2003
Infrastructure Valuation Services Page 10
DETERMINATIONS RELATIVE TO
GASB 34 REQUIREMENTS
Recommendations were provided and determinations were made by the City relative to certain GASB 34
requirements and options. They are as follows:
Assets to be Reported
Those Infrastructure Assets are listed on Page 3 of this report.
Reporting Method
The Basic Approach. This involves establishing the acquisition date, historical cost, useful life and
applying a depreciation method to arrive at Net Book Value. The straight -line depreciation method is
being used for all Infrastructure Assets.
GASB 34 Reporting Level
GASB 34 allows public agencies to report the Net Current Value of assets at the Network, Subsystem or
Individual level. The City has determined that it wishes infrastructure assets to be reported at the
Subsystem level. As defined by GASB, a Network is composed of subsystems and component parts of
infrastructure. In the immediate case, historical data has been collected, and in many cases estimated, for
Infrastructure Assets at the Subsystem Level. As a result, reporting can be made at either the Subsystem
or Network Ievel.
Capitalization Policy
GASB 34 requires public agencies to establish and disclose the "capitalization policy" for capital and
infrastructure assets. It sets forth the dollar value above which such assets acquisitions are added to the
capital asset accounts, and below which such assets acquisitions are not required to be reported. The
recommended dollar value is $100,000 based on current replacement cost. It recognizes the significantly
higher value of infrastructure as opposed to "fixed assets" (typically building contents). This seemingly
high value threshold does not mean that individual assets below this level have not been, and will not be,
counted. As reflected in the attached inventory and valuation information, individual and subsystem
components have and will continue to be counted below the $100,000 threshold value so long as the
relevant data can be readily captured.
Useful Life of Infrastructure Assets
Use of the Basic Approach of valuing capital assets requires a determination of useful life of each type of
asset in order to properly complete the formula for determining depreciation and arriving at Net Book
Value. Based upon our firm's experience, utilization of industry standards, and consideration of
conditions unique to the City, the following have been determined to be the useful life of the relevant
Infrastructure Assets:
QAMoorparffinai Report.doc
� Harris &Associates
Draft Report: GASB Statement 34 October 27, 2003
Infrastructure Valuation Services Page 11
Network
Subsystem
Useful Life
Roadways /Streets
Pavement (AC)
30
Curb & Gutter
100
Sidewalks
100
Traffic Signals
25
Traffic Regulatory Signs
7
Street Trees
N/A
Bridges
100
Parking Lots (Pavement)
30
Medians and Parkways
100
Storm Drainage System
Pipes
100
Parks & Recreation Facilities
Bike Path
50
Land
Land
N/A
Rights -of -Way
N/A
Valuation Methodology
In order to supplement data collection and expedite analysis wherever possible, and where information was
not reasonably available in files or existing software programs, historical costs were achieved through
estimates, and based upon inventory deficiencies, some acquisitions dates were also estimated. This
methodology is permissible under GASB 34. Current replacement unit costs (Year 2002 -2003) were
established for each applicable asset. These unit costs were developed from bid tabulations,- industry
standard costing documents and project team experience. Devaluation models were created to convert
replacement costs to estimated original costs. These models are based on the appropriate Engineering News
Record Cost Index (as shown in the Appendices). Depreciation models were created to calculate
depreciation on assets using the useful life(s) of assets. The "straight line" depreciation method was used on
a half -year convention (calculated through June 30, 2002 - 2003). The formula is presented on page 5 of this
report.
Valuation of Pre -1980 Infrastructure Assets
GASB 34 allows governments to report the historical or estimated historical cost of Infrastructure Assets
that were acquired, reconstructed or significantly improved in fiscal years ending after June 30, 1980 (FY
1979 -80). The summaries and appendices reflect this information. The City was incorporated in 1983.
Therefore, the data was gathered and valuations were made for assets going back to this date. In some
cases, values were established prior to this date to reflect the discounted value of existing assets that the
City acquired on the date of incorporation.
ENR Indexing and Unit Costs
Exhibit "A" provides a spreadsheet reflecting the ENR (Engineering News Record) Construction Cost
Index data which has been used in a number of situations to determine historical value of the assets. In a
slumber of cases, where actual historical cost was not available, replacement value unit costs were
applied, and the unit cost was indexed back to the appropriate year of actual /estimated construction.
1. 1 1 i C
QAMoorparffinal Report.doc
� Harris &Associates
Draft Report; GASB Statement 34 October 27, 2003
Infrastructure Vatuation Services Page 12
SUMMARY OF FINDINGS
The following will present summary information on the valuation of each Subsystem of Infrastructure
Asset for the purpose of reporting in financial statements in accordance with GASB 34 and for use in the
City's accounting records. Shown below, and on Exhibit "B ", is an overall summary of the current Net
Book Value of the infrastructure assets by Subsystem, Network and grand total. Total current Net Book
Value of all assets inventoried and valued in this project for,Year 2002 is $218,444,737 and for Year
2003 is $222,027,514.
Current
Original
Current
Replacement
Estimated
Net Value
Network Subsystem
Cost
Cost
(thru 613012002)
Roadway /Streets
Pavement
$
42,213,735
$
31,818,622
$
20,172,399
Curb & Gutter
$
17,050,176
$
12,370,671
$
10,835,279
Sidewalk
$
15,155,712
$
10,996,152
$
9,631,359
.ry �.
Traffic Signals
$
2,945,305
$
2,194,075
$
1,235,748
Traffic Regulatory Signs
$
279,392
$
159,985
$
26,248
Street Trees
$
2,040,200
$
1,282,533
$
1,282,533
Bridges
$
9,006,552
$
7,200,000
$
6,513,000
Parking Lots (Pavement)
$
1,912,580
$
1,440,334
$
876,512
Medians and Parkways
$
18,447,660
$
13,384,608
$
11,723,372
Sub -total
$
109,051,312
$
80,846,978
$
62,296,450
Storm Drainage System
,
Pipes
$
1,790,750
$
1,619,399
$
1,548,061
Parks & Recreation
Bike Path
$
194,390
$
156,727
$
126,949
Land Network
Land
NIA
$
31,406,446
$
31,406,446
Rights -of -Way
NIA
$
123,066,830
$
123,066,830
Sub -total
N/A
$
154,473,276
$
154,473,276
Grand Total
$
111,036,452
$
237,096,381
$
218,444,737
of
It
Current
Original
Current
Replacement
Estimated
Net Value
Network Subsystem
Cost
Cost
(thru 6130/2003)
Roadway /Streets
Pavement
$
46,507,562
$
35,117,479
$
22,356,376
Curb & Gutter
$
18,559,411
$
13,465,689
$
11,659,732
Sidewalk
$
16,497,254
$
11,969,501
$
10,364,206
Traffic Signals
$
3,200,000
$
2,394,075
$
1,346,673
Traffic Regulatory Signs
$
296,225
$
171,630
$
30,009
Street Trees
$
2,040,200
$
1,282,533
$
1,282,533
Bridges
$
9,006,552
$
7,200,000
$
6,441,000
Parking Lots (Pavement)
$
1,912,580
$
1,440,334
$
828,501
Medians and Parkways
$
18,447,660
$
13,384,608
$
11,589,525
Sub -total
$
116,467,445
$
86,425,848
$
65,898,556
Storm Drainage System
Pipes
$
1,790,750
$
1,619,399
$
1,531,867
Parks & Recreation
Bike Path
$
198,000
$
156,727
$
123,815
Land Network
Land
NIA
$
31,406,446
$
31,406,446
Rights -of -Way
N/A
$
123,066,830
$
123,066,830
Sub -total
NIA
$
154,473,276
$
154,473,276
Grand Total
$
118,456,195
$
242,675,251
$
222,027,514
00003
QAMoorparUinal Report.doc
Harris &Associates
Draft Report: GASB Statement 34 October 27, 2003
Infrastructure Valuation Services Page 13
STREETS/ROADWAYS NETWORK
Subsystem: Pavement
Reporting Level
Subsystem, for pavement
Useful Life of Asset
30 years for asphalt concrete
Inventory/Valuation Data Sources
The City's Pavement Management System was last updated Year 1995. Pavement data since that date
was obtained from the Public Works Department staff. Replacement unit costs were estimated by Harris
and discussed with City staff. The PMS system utilizes dates as early as 1971.
Methodologies Used to Determine Historical Cost, Acquisition Dates, and Values:
Current replacement costs were determined to be $475,000 per mile_ Based on 1995 Pavement
Management System Report, average reconstruction of $400,000 per mile was indexed forward to year
2003. Historical costs were determined by using the City's existing PMS and ENR Construction Cost
Index to establish the historical unit cost by year of construction/improvement. The useful life of 30 years
is standard, and was verified by Harris PMS and Design Group specialists. The total length of pavement
valued was 97 miles. The value of the pavement increased from 2002 to 2003 due to the large amount of
rehabilitation and new streets constructed in 2003, which outpaced annual depreciation.
Net Book Value
The figures below provide all the essential information needed for the City's Comprehensive Annual
Financial Report (CAFR) and associated financial statements relative to the Net Book Value of pavement.
The Net Book Value for Year 2002 is $20,172,399 and for Year 2003 is $22,356,376. In addition, and
based upon the methodologies described above, you will find information in Exhibits "Cl" and "C2"
about asset quantity, historic values, annual depreciation and accumulated depreciation_
Total Current Original
Accumulated
Current
Length Replacement Estimated
Annual Depreciation
Net
Year (mi) Cost Cost
Depreciation (thru 6130)
Value
2002 89.70 $ 42,213,735 $ 31,818,622
$ 1,060,621 $ 11,646,222 $
20,172,399
2003 97.64 $ 46,507,562 $ 35,117,479
$ 1,170,583 $ 12,761,102 $
22,356,376
- Valuations of Pre -1980 Infrastructure Assets: Pavement was valued back to 1971 to reflect
the
discounted value of the asset when the City acquired
the pavement upon incorporation in 1983.
QWoorparkTinal. Report.doc
Harris & Associates
Draft Report: GASS Statement 34 October 27, 2003
Infrastructure Valuation Services Page 14
STREETS/ROADWAYS NETWORK
Subsystem: Curb and Gutter
Reporting Level
Subsystem, for curb and gutter
Useful Life of Asset
100 years for Portland Cement Concrete (PCC)
Inventory/Valuation Data Sources
Curb and gutter lengths were estimated using data from the City's Pavement Management System. It was
estimated that 90% of the streets in the City have curb and gutter. In order to establish an estimated total
length for curb and gutter, the total length of streets was multiplied by 2 (both sides of the street), and
then multiplied by 90 %. In order to estimate the amount of curb and gutter constructed by year, the total
Iength of curb and gutter was multiplied by the percentage of population growth for each year.
Population growth figures were obtained from the State of California, and were available back to 1985.
Replacement unit costs were estimated by Harris and discussed with City staff.
Methodologies Used to Determine Historical Cost, Acquisition Dates, and Values:
Current replacement costs were determined to be $20.00 per linear foot of PCC curb and gutter. A useful
life of 100 years was implemented for PCC curb and gutter. Historical costs were determined by using
the estimations described above and ENR Construction Cost Index to establish the historical unit cost by
year of construction.
Net Book Value
The figures below provide all the essential information needed for the City's Comprehensive Annual
Financial Report (CAFR) and associated financial statements relative to the Net Book Value of this asset
subsystem. The Net Book Value for Year 2002 is $10,835,279 and for Year 2003 is $11,659,732. In
` 7, addition, and based upon the methodologies described above, you will find information in Exhibits "D1"
and "D2" about asset quantity, historic values, annual depreciation and accumulated depreciation.
Total
Current
Original
Accumulated
Current
Length
Replacement
Estimated
Annual
Depreciation
Net
Year (LF)
Cost
Cost
Depreciation
(thru 6/30)
Value
2002 852,509
$ 17,050,176
$ 12,370,671
$ 123,707
$ 1,535,391
$ 10,835,279
2003 927,971
$ 18,559,411
$ 13,465,689
$ 134,657
$ 1,805,957
$ 11,659,732
Valuations of Pre -1980 Infrastructure Assets: PCC Curb and gutter were valued back to 1985_
000033
QAMwparffinal Reportdoc
� Harris &Associates
Draft Report: GASB Statement 34 October 27, 2003
Infrastructure Valuation Services Page 15
STREETS/ROADWAYS NETWORK
Subsystem: Sidewalks
Reporting Level
Subsystem, for sidewalks
Useful Life of Asset
100 years for Portland Cement Concrete (PCC)
Inventory/Valuation Data Sources
Sidewalk lengths were estimated using data from the City's Pavement Management System. It was
estimated that 80% of the streets in the City have sidewalks. In order to establish an estimated total
length for sidewalks, the total length of streets was multiplied by 2 (both sides of the street), then
multiplied by 4 (standard width of sidewalks, in feet), and then multiplied by 80 %. In order to estimate
the amount of sidewalks constructed by year, the total length of sidewalks was multiplied by the
percentage of population growth for each year. Population growth figures were obtained from the State
of California, and were available back to 1985. Replacement unit costs were estimated by Harris and
discussed with City staff.
Methodologies Used to Determine Historical Cost, Acquisition Dates, and Values:
Current replacement costs were determined to be $5.00 per square foot of PCC sidewalk. A useful life of
100 years was implemented for PCC sidewalks. Historical costs were determined by using the
estimations described above and ENR Construction Cost Index to establish the historical unit cost by year
of construction.
Net Book Value
The figures below provide all the essential information needed for the City's Comprehensive Annual
Financial Report (CAFR) and associated financial statements relative to the Net Book Value of this asset
subsystem. The Net Book Value for Year 2002 is $9,631,359 and for Year 2003 is $10,364,206. in
addition, and based upon the methodologies described above, you will find information in Exhibits "El"
and "E2" about asset quantity, historic values, annual depreciation and accumulated depreciation.
Valuations of Pre -1980 Infrastructure Assets: PCC Sidewalks were valued back to 1985.
Q:1Moorparffinal Report.doc
� � Harris &Associates
Current
Original
Accumulated
Current
Total Area
Replacement
Estimated
Annual
Depreciation
Net
Year (SF)
Cost
Cost
Depreciation
(thru 6130)
Value
2002 3,031,142
$ 15,155,712
$ 10,996,152
$ 109,962
$ 1,364,792
$ 9,631,359
2003 3,299,451
$ 16,497,254
$ 11,969,501
$ 119,695
$ 1,605,295
$ 10,364,206
Valuations of Pre -1980 Infrastructure Assets: PCC Sidewalks were valued back to 1985.
Q:1Moorparffinal Report.doc
� � Harris &Associates
Draft Report: GASB Statement 34
Infrastructure Vatuation Services
STREETS/ROADWAYS NETWORK
Subsystem: Traffic Signals
Reporting Level
Subsystem, for traffic signals
Useful Life of Asset
October 27, 2003
Page 16
25 years, based upon replacement system estimated by the Harris Design Group and reviewed by the
Public Works Department.
Inventory/Valuation Data Sources
Traffic signal locations, quantities, percent ownership and approximate construction dates were
established by the City's Public Works Department.
Methodologies Used to Determine Historical Cost, Acquisition Dates, and Values:
Current replacement costs were estimated to be $200,000 for each traffic signal (which_ includes the
interconnect). Approximate construction date was established by the City. The replacement value of
signals was indexed back to the appropriate date(s) to arrive at estimated historical cost and then
depreciated based upon age to arrive at current Net Book Value.
Net Book Value
The figures below provide all the essential information needed for the City's Comprehensive Annual
Financial Report (CAER) and associated financial statements relative to the Net Book Value of this asset
subsystem. The Net Book Value for Year 2002 is $1,235,748 and for Year 2003 is $1,346,673. In
addition, and based upon the methodologies described above, you will find information in Exhibits "Fl"
and "F2" about asset quantity, historic values, annual depreciation and accumulated depreciation.
Current
Original
Accumulated
Current
Replacement
Estimated
Annual
Depreciation
Net
Year Qty Cost
Cost
Depreciation
(thru 6 130)
Value
2002 15 $ 2,945,305
$ 2,194,075
$ 87,763
$ 958,327
$ 1,235,748
2003 16 $ 3,200,000
$ 2,394,075
$ 95,763
$ 1,047,401
$ 1,346,673
Valuations of Pre -1980 Infrastructure Assets: Only one traffic signal existed prior to 1980, or have not
been modified or replaced since 1980, so therefore it was given its actual construction date.
Q \Moorparffinal Repod -doc
Harris & Associates
Draft Report: GASB Statement 34 October 27, 2003
Infrastructure Valuation Services Page 17
STREETS/ROADWAYS NETWORK
Subsystem: Traffic Regulatory Signs
Reporting Level
Subsystem, for traffic regulatory signs
Useful Life of Asset
7 years, based upon replacement system estimated by the Harris Design Group and reviewed by the
Public Works Department.
Inventory/Valuation Data Sources
City of Moorpark provided the basic source of information for determining the quantities and locations
of regulatory signs. Approximate construction dates were determined by the City.
Methodologies Used to Determine historical Cost, Acquisition Dates, and Values:
Current replacement costs were estimated to be $85.00 for each traffic regulatory sign. The.approximate
installation dates were established by the City. The replacement value of signs was indexed back to the
appropriate date(s) to arrive at estimated historical cost and then depreciated based upon age to arrive at
current Net Book .Value.
Net Book Value
The figures below provide all the essential information needed for the City's Comprehensive Annual
Financial Report (CAFR) and associated financial statements relative to the Net Book Value of this asset
subsystem. The Net Book Value for Year 2002 is $26,248 and for Year 2003 is $30,009. In addition,
and based upon the methodologies described above, you will find information in Exhibits "Gl" and
"G2" about asset quantity, historic values, annual depreciation and accumulated depreciation.
Current
Original
Accumulated
Current
Replacement
Estimated
Annual
Depreciation
Net
Year Qty Cost
Cost
Depreciation
(thru 6130)
Value
2002 3,348 $ 279,392
$ 159,985
$ 22,855
$ 133,736
$ 26,248
2003 3,485 $ 296,225
$ 171,630
$ 24,519
$ 141,621
$ 30,009
Valuations of Pre -1980 Infrastructure Assets: Due to the relatively short Iife expectancy of signs, only
the last 7 years of sign construction/installation have been valued.
C1:UnoorparkTina! fteport.doc Harris & Associates
Draft Report: GASB Statement 34
Infrastructure Valuation Services
ROADWAY NETWORK
Subsystem: Street Trees
Reporting Level
Subsystem, for street trees
Useful Life of Asset
October 27, 2003
Page 18
Street trees are not being depreciated, rather they are being valued at replacement cost since trees grow
and, as a result, gain value as they mature.
Inventory/Valuation Data Sources
City of Moorpark provided the basic source of information for determining the quantities and locations of
trees.. Approximate construction dates were established by the City.
Methodologies Used to Determine Historical Cost, Acquisition Dates, and Values:
The current replacement value was determined to be $200.00 each.
Net Book Value
The figures below provide all the essential information needed for the City's Comprehensive Annual
Financial Report (CAFR) and associated financial statements relative to the Net Book Value of this asset
subsystem. The Net Book Value is $1,282,533. In addition, and based upon the methodologies described
above, you will find information in Exhibit "H" about asset quantity and replacement values.
Current
Total No. of Replacement
Trees Cost
10,201 $ 2,040,200
Original
Current
Estimated
Net
Cost
Value
1,282,533 $
1,282,533
Valuations of Pre -1980 Infrastructure Assets: In some cases, the trees were planted prior to the 1983,
incorporation date of the City. They were valued back to this date_
QAMoorparffinai Reportdoc
� Harris &Associates
Draft Report: GASB Statement 34
Infrastructure Valuation Services
STREETS/ROADWAYS NETWORK
Subsystem: Bridges/Pedestrian Crossing
Reporting Level
Subsystem, for bridges /pedestrian crossing
Useful Life of Asset
October 27, 2003
Page 19
100 years, based upon replacement system estimated by the Harris Design Group and reviewed by the
Public Works Department.
Inventory/Valuation Data Sources
Bridges/Pedestrian crossing locations, costs and construction dates were established by the City.
Methodologies Used to Determine Historical Cost, Acquisition Dates, and Values:
A useful life of 100 years was implemented for bridges /pedestrian crossing. Historical costs and
acquisition dates were established by the City. Current replacement cost were determined using ENR
Construction Cost Index, historical costs was indexed forward to the current year.
Net Book Value
The figures below provide all the essential information needed for the City's Comprehensive Annual
Financial Report (CAFR) and associated financial statements relative to the Net Book Value of this asset
subsystem. The Net Book Value for Year 2002 is $6,513,000 and for Year 2003 is $6,441,000. In
addition, and based upon the methodologies described above, you will find information in Exhibits "Il"
and "I2" about asset quantity, historic values, annual depreciation and accumulated depreciation.
Current
Original
Accumulated
Current
Replacement
Estimated
Annual
Depreciation
Net
Year Qty Cost
Cost
Depreciation
(thru 6/30)
Value
2002 3 $ 9,006,552
$ 7,200,000
$ 72,000
$ 687,000
$ 6,513,000
2003 3 $ 9,006,552
$ 7,200,000
$ 72,000
$ 759,000
$ 6,441,000
Valuations of Pre -1980 Infrastructure Assets: All Bridges/Pedestrian Crossing was constructed after
1980.
t 'sN 1 i
QAMoorparffinai Report.doc
� Harris & Associates
Draft Report: GASB Statement 34
Infrastructure Valuation Services
STREETS/ROADWAYS NETWORK
Subsystem: Parking Lots
Reporting Level
Subsystem, for parking lots
Useful Life of Asset
October 27, 2003
Page 20
30 years for asphalt concrete
Inventory/Valuation Data Sources
Parking lots locations, quantities and construction dates were established by the City.
Methodologies Used to Determine Historical Cost, Acquisition Dates, and Values:
Current replacement costs were estimated to be $4.00 per square foot. The approximate construction
dates were established by the City. The Current replacement value was indexed back to the appropriate
date(s) to arrive at estimated historical cost and then depreciated based upon age to arrive at current Net
Book Value
Net Book Value
The figures below provide all the essential information needed for the City's Comprehensive Annual
Financial Report (CAFR) and associated financial statements relative to the Net Book Value of pavement.
The Net Book Value for Year 2002 is $876,512 and for Year 2003 is $828,501. In addition, and based
upon the methodologies described above, you will find information in Exhibits "JI" and "J2" about
asset quantity, historic values, annual depreciation and accumulated depreciation.
Valuations of Pre -1980 Infrastructure Assets: Parking lots information was available pre -1980,
therefore all parking lots were valued.
Q:Voorparffinal Report.doc
Harris &Associates
Current
Original
Accumulated
Current
Total Area
Replacement
Estimated
Annual
Depreciation
Net
Year (SF)
Cost
Cost
Depreciation
(thru 6130)
Value
2002 478,145
$ 1,912,580
$ 1,440,334
$ 48,011
$ 563,822
$ 876,512
2003 478,145
$ 1,912,580
$ 1,440,334
$ 48,011
$ 611,833
$ 828,501
Valuations of Pre -1980 Infrastructure Assets: Parking lots information was available pre -1980,
therefore all parking lots were valued.
Q:Voorparffinal Report.doc
Harris &Associates
Draft Report: GASS Statement 34 October 27, 2003
Infrastructure Vatuation Services Page 21
STREETSIROADWAYS NETWORK
Subsystem: Landscaped Medians and Parkways
Reporting Level
Subsystem, for landscaped medians and parkways
Useful Life of Asset
100 years, based upon replacement system estimated by the Harris Design Group and reviewed by the
Public Works Department.
Inventory/Valuation Data Sources
City of Moorpark estimated the area for medians and parkways. Replacement unit costs were estimated
by the Harris and discussed with City staff.
Methodologies Used to Determine Historical Cost, Acquisition Dates, and Values:
Current replacement costs were determined to be $5.00 per square foot. The total medians and parkways
area valued was 3,689,532 square feet. In order to estimate the amount of medians and parkways
constructed by year, the total area of medians and parkways was multiplied by the percentage of
population growth for each year. Population growth figures were obtained from the State of California.
The Current replacement value was indexed back to the appropriate date(s) to arrive at estimated
historical cost and then depreciated based upon age to arrive at current Net Book Value
Net Book Value
The figures below provide all the essential information needed for the City's Comprehensive Annual
Financial Report (CAFR) and associated financial statements relative to the Net Book Value of this asset
subsystem. The Net Book Value for Year 2002 is $11,723,372 and for Year 2003 is $11,589,525. In
addition, and based upon the methodologies described above, you will find information in Exhibits "KI"
and "K2" about asset quantity, historic values, annual depreciation and accumulated depreciation. This
information will be helpful as the base data for the City's following CAFR for FY 2002 -2003.
Valuations of Pre4980 Infrastructure Assets: Landscaped Medians and Parkways were valued back to
1985.
Q kMoorparklFinal Report.doc
000040
Harris & Associates
Current
Original
Accumulated
Total Area
Replacement
Estimated
Annual
Depreciation
Current Net
Year (SF)
Cost
Cost
Depreciation
(thru 6/30)
Value
2002 3,689,532
$ 18,447,660
$ 13,384,608
$ 133,846
$ 1,661,237
$ 11,723,372
2003 3,689,532
$ 18,447,660
$ 13,384,608
$ 133,846
$ 1,795,083
$ 11,589,525
Valuations of Pre4980 Infrastructure Assets: Landscaped Medians and Parkways were valued back to
1985.
Q kMoorparklFinal Report.doc
000040
Harris & Associates
Draft Report: GASB Statement 34
Infrastructure Valuation Services
STORM DRAIN NETWORK
Subsystem: Pipes
Reporting Level
Subsystem, for pipes
Useful Life of Asset
100 years for concrete pipes
Inventory/Valuation Data Sources
October 27, 2003
Page 22
Storm Drain Pipe types, quantities and construction dates were established by the City's Public Works
Department.
Methodologies Used to Determine Historical Cost, Acquisition Dates, and Values:
Current replacement cost and useful life were recommended by the Harris Design Group and accepted by
the Public Works Department. Unit costs were indexed back to the appropriate year" to determine
estimated historical cost, and then depreciation was applied to achieve Net Book Value.
Net Book Value
The figures below provide all the essential information needed for the City's Comprehensive Annual
Financial Report (CAFR) and associated financial statements relative to the Net Book Value of this asset
subsystem. The Net Book Value for Year 2002 is $1,548,061 and for Year 2003 is $1,531,867. In
addition, and based upon the methodologies described above, you will find information in Exhibits "Ll"
and "L2" about asset quantity, historic values, annual depreciation and accumulated depreciation.
Current
Original
Accumulated
Current
Replacement
Estimated
Annual
Depreciation
Net
Year Cost
Cost
Depreciation
(thru 6/30)
Value
2002 $ 1,790,750
$ 1,619,399
$ 16,194
$ 71,338
$ 1,548,061
2003 $ 1,790,750
$ 1,619,399
$ 16,194
$ 87,532
$ 1,531,867
Valuations of Pre -1980 Infrastructure Assets: All Storm Drain Pipes appear to have been constructed
after 1980_
01 .1=.5
owoorpaMFinai Report.doc
� Harris &Associates
Draft Report: GASB Statement 34
Infrastructure Vatuation Services
PARKS & RECREATION NETWORK
Subsystem: Bike Path
Reporting Level
Subsystem, for improvements that are part of the parks & recreation network
Useful Life of Asset
50 years
Inventory/Valuation Data Sources
October 27, 2003
Page 23
Bike Path quantities and construction dates were established by the City's Public Works Department.
Methodologies Used to Determine Historical Cost, Acquisition Dates, and Values:
The useful life of 50 years was established for improvements. Current replacement costs were estimated
to be $4.00 per square foot. The Current replacement value was indexed back to the appropriate date(s) to
arrive at estimated historical cost and then depreciated based upon age to arrive at current Net Book
Value
Net Book Value
The figures below provide all the essential information needed for the City's Comprehensive Annual
Financial Report (CAFR) and associated financial statements relative to the Net Book Value of this asset
subsystem. The Net Book Value for Year 2002 is $126,949 and for Year 2003 is $123,815. In addition,
and based upon the methodologies described above, you will find information in Exhibits "Ml" and
"M2" about asset quantity and replacement values.
Valuations of Pre -1980 Infrastructure Assets: Bike Path was constructed after 1980.
O I N 1
Q:Noorparffinal Reportdoc
Harris &Associates
Current
Original
Accumulated
Current
Total Area
Replacement
Estimated
Annual
Depreciation
Net
Year (SF)
Cost
Cost
Depreciation
(thru 6130)
Value
2002 49,500
$ 194,390
$ 156,727
$ 3,135
$ 29,778
$ 126,949
2003 49,500
$ 198,000
$ 156,727
$ 3,135
$ 32,913
$ 123,815
Valuations of Pre -1980 Infrastructure Assets: Bike Path was constructed after 1980.
O I N 1
Q:Noorparffinal Reportdoc
Harris &Associates
Draft Report: GASB Statement 34 October 27, 2003
Infrastructure Valuation Services Page 24
LAND NETWORK
Subsystem: Land and Ril4hts -of -Way
Reporting Level
Network. This asset category includes individual properties owned by the City, ,which comprise the Land
Network.
Useful Life of Asset
Not applicable. In accordance with GASB 34, Land is not depreciated. It is a permanent asset that has an
inexhaustible useful life.
Inventory/Valuation Data Sources
The City's "Fixed Assets Land List" was used as the basic source of information for determining the
inventory and valuation of City -owned land. Ventura County Assessor's data (representative sample of
values) were also used to provide additional inventory for establishing estimated historical costs of land
within Rights of Way, whether acquired by easement or in fee simple. A current per acre cost was
derived from the sample. This was discounted by 2% per year back to the estimated year of acquisition
(using the Pavement Management System) to arrive at the estimated current net book value. No fair -
market appraisals were performed.
Methodologies Used to Determine Historical Cost, Acquisition Dates, and Values:
Land owned by the City is listed in Exhibit N. Land with Rights -of -Way is listed in Exhibit O. Historical
values for both categories of land have been reflected without depreciation, in accordance with the
provisions of GASB 34.
Net Book Value
The figures below provide all the essential information needed for the City's Comprehensive Annual
Financial Report (CAFR) and associated financial statements relative to the Net Book Value of this asset
network. Values for each individual property are provided. The Total Net Book Value is $154,473,276.
In addition, you will find information in Exhibits "N" and Exhibits "O" about asset quantity (acreage),
location of property and name.
Current Original Current
Replacement Estimated
Cost Cost
Land N/A $ 31,406,446
Rights -of -Way N/A $ 123,066,830
Total N/A $ 154,473,276
Valuations of Pre -1980 Infrastructure Assets: Land informati(
land was valued.
QAMoorparkTinal Report.doc
Net
Value
$ 31,406,446
$ 123,066,830
$ 154,473,276
)n was available pre -1980, therefore all
00,003
Harris & Associates
Draft Report: GASB Statement 34 October 27, 2003
Infrastructure Valuation Services Page 25
PROCEDURES FOR CAPTURING FUTURE GASB 34 INFORMATION
Exhibit "P" provides an essentially generic form and accompanying "administrative instruction," which
should be helpful in capturing critical data for reporting of infrastructure assets in the future. This form is
proposed to be used by the various City departments and divisions when assets are acquired, constructed
or placed into service (and when assets are disposed of or removed/demolished). We have not included in
the instructions which City staff members in the organization would complete the matrix, since that is a
more internal operational decision. The "instruction" includes when this information should be collected
and returned to the Finance Department. Below are some suggestions on timing and other important
considerations.
♦ These forms should be completed throughout the fiscal year as asset acquisition and dispositions are
completed, and not be left for completion at the end of the fiscal year.
♦ Information should be collected for both City projects (CIP projects and the like) as well as
developer -built and dedicated/donated infrastructure improvements, whether it is parks, streets, etc.
♦ If infrastructure improvements are disposed of, eliminated or removed, their value should be deducted
from asset value. If such improvements have to be removed or eliminated as a function of
constructing new improvements, the value of the portion removed should be deducted, and the value
of the improvements constructed should be added to asset value.
♦ The most critical pieces of information are the quantities, acquisition dates and costs. Once these
forms are completed and submitted to the Administrative Services Department, they should be
compiled, categorized into the appropriate subsystems, and totaled. This information can then be
entered in the appropriate Asset Module (spreadsheet) for the fiscal year. Once entered, the Asset
Module will electronically perform the calculations to update the annual depreciation, accumulated
depreciation and Net Book Value.
♦ Quantity information can be obtained from as -built drawings, and should be done upon receipt of as-
built. Cost data may be obtained through unit costs, developer information, final invoice data,
Council - accepted project totals (in progress work is not counted; improvements must be complete) or
other means.
♦ In using the Basic Approach (depreciation), there should be a distinction made between routine
maintenance costs, which are not reported per GASB 34 vs. replacement, improvement and
preservation costs, which should be reported per GASB 34. "Preservation" costs, as the GASB 34
Implementation Guide defines them, are those cost outlays that extend the useful life (assuming
normal routine maintenance) of an asset beyond its original estimated useful life. Also, if the
capacity or efficiency of an asset has been increased by a cost outlay (such as a road widening or
weight capacity), the costs associated with such improvements should be reported.
♦ Where appropriate, certain ancillary project costs should also be captured for reporting purposes.
These can include design, construction management, fees, transportation and administrative overhead
charges_
The City may wish to include all or part of this information in their "instruction" to staff members to
assist them in completing the form. Hopefully, this will be helpful to the City. Certainly, the City can
modify and/or fine -tune the system/form for maximum use and benefit.
4:Woorparffinai Reportdoc
000044
Harris & Associates
te-
Draft Report: GASB Statement 34 October 27, 2003
Infrastructure Valuation Services Page 26
PROCEDURES FOR UPDATING THE ASSET MODULES
The asset module (spreadsheet) is where all of the detailed information regarding current and historical
costs as well as net book value. These spreadsheets need to be updated with all of the current
construction information to be able to report the GASB 34 information in future years. While all of the
spreadsheets differ slightly in format due to the diversity of the assets being reported the general updates
for each of the spreadsheets is relatively similar.
First, gather all of the information for new construction and removals since the last update using the
Infrastructure Inventory Valuation Form and Administrative Instructions provided in Exhibit X or another
method. The first step is to update all of the ENR Cost Indices to reflect the current years information.
To do this copy the previous years information and past it into a new row. In this row you need to update
the Year, the ENR Cost Index, and all of the current unit cost information. Information regarding the
Construction Cost index can be found at
http: / /enr.construction.com/ features /conEco /costlndexes /constlndexHist asp. After all of the current
information is entered the previous years information needs to be updated. To do this copy and paste all
of the cells which contain formulas from an older row into the previous years rows. Once this is finished
the ENR Cost Indices have been updated and you can now update the individual modules.
After all of the Cost Indices have been updated you can begin updating the individual spreadsheets. First
you should delete all of the items that have been taken out of service or removed since the last update.
All of the removals should be given in the correct "unit ", for example the total amount of pavement
removed should be in square feet. If you are estimating which items were taken out of service delete the
items with the least remaining useful life. If you know the exact item or original year of construction of
the item, delete the correct items or items from the correct year of construction. Once you identify the
correct item to be removed you should do a quick hand calculation to determine the total original cost of
the item to be removed. The total quantity of the item being removed should be subtracted out of the
quantity column and the original cost of the item being removed should be subtracted out of the total
original cost. Once all of the removals are complete all of the new construction can be added in. To do
this, first adjust the current year and the current unit price. Doing this will update the current replacement
value, accumulated depreciation, and net book value. To add in the additional work copy the last row into
the row below. You will also need to modify the original unit cost lookup formulas to include the newest
construction cost indices that were entered for the current year. Generally whenever there is a lookup
formula it will need to be updated. Adding one more cell to the lookup formula can usually do this. Refer
to the example below.
Previous Years Formula
L00KUP(A32,Exhib1tW 1 !$A$4:$A$100,ExhibitW 1 !$F$4:$F$100)
Modified to be the Current Years Formula
= LOOKUP(A32,ExhibitW 1 ! $A$4: $A$ l01,ExhibitW 1 !$F$4:$F$101)
Once all these formulas are updated the GASB 34 Asset Modules should be updated.
000045
0AMoorparkTina! Report.doc
I Barris & Associates
APPENDIX
City
of Moorpark
GASB -34 Valuations
10/27/2003
Exhibit "A"
- ENR ( Engineering News Record)
ANNUAL
Increase /
YEAR
AVG
Decrease
Factor
Unit
1908
97
0.00%
100.00%
6414.43%
1909
91
-6.19%
100.00%
6414.43%
1910
96
5.49%
93.81%
6837.36%
1911
93
-3.13%
105.49%
6481.25%
1912
91
- 2.15%
96.88%
6690.32%
1913
100
9.89%
97.85%
6837.36%
1914
89
- 11.00%
109.89%
6222.00%
1915
93
4.49%
89.00%
6991.01%
1916
130
39.78%
104.49%
6690.32%
1917
181
39.23%
139.78%
4786.15%
1918
189
4.42%
139.23%
3437.57%
1919
198
4.76%
104.42%
3292.06%
1920
251
26.77%
104.76%
3142.42%
1921
202
- 19.52%
126.77%
2478.88%
1922
174
- 13.86%
80.48%
3080.20%
1923
214
22.99%
86.14%
3575.86%
1924
215
0.47%
122.99%
2907.48%
1925
207
- 172%
100.47%
2893.95%
1926
208
0.48%
96.28%
3005.80%
1927
206
-0.96%
100.48%
2991.35%
1928
207
0.49%
99.04%
3020.39%
1929
207
0.00%
100.49%
3005.80%
1930
203
-1.93%
100.00%
3005.80%
1931
181
- 10.84%
98.07%
3065.02%
1932
157
- 13.26%
89.16%
3437.57%
1933
170
8.28%
86.74%
3963.06%
1934
198
16.47%
108.28%
3660.00%
1 935
196
-1.01%
116.47%
3142.42%
1936
206
5.10%
98.99%
3174.49%
1937
235
14.08%
105.10%
3020.39%
1938
236
0.43%
114.08%
2647.66%
1939
236
0.00%
100.43%
2636.44%
1940
242
2.54%
100.00%
2636.44%
1941
258
6.61%
102.54%
2571.07%
1942
276
6.98%
106.61%
2411.63%
1943
290
5.07%
106.98%
2254.35%
1944
299
3.10%
105.07%
2145.52%
1945
308
3.01%
103.10%
2080.94%
1946
346
12.34%
10101%
2020.13%
1947
413
19.36%
112.34%
1798.27%
1948
461
11.62%
119.36%
1506.54%
1949
477
3.47%
111.62%
1349.67%
1950
510
6.92%
103.47%
1304.40%
1951
543
6.47%
106.92%
1220.00%
1952
569
4.79%
106.47%
1145.86 %
1953
600
5.45%
104.79%
1093.50%
1954
628
4.67%
105.45%
1037.00%
Page 1 of 2
Exhibit "A"
City of Moorpark
GASB -34 Valuations
10/27/2003
ANNUAL
Increase I
YEAR
AVG
Decrease
Factor
1955
660
5.10%
104.67 %
990.76%
1956
692
4.85%
105.10%
942.73%
1957
724
4.62%
104.85%
899.13%
1958
759
4.83%
104.62%
859.39%
1959
797
5.01% <
104.83%
819.76%
1960
824
3.39 %
105.01%
780.68%
1961
847
2.79%
103.39%
755.10%
1962
872
2.95%
102.79%
734.59%
1963
901
3.33%
102.95%
713.53%
1964
936
3.88%
103.33%
690.57%
1965
971
3.74%
10188%
664.74%
1966
1019
4.94%
103.74%
640.78%
1967
1074
5.40%
104.94 %
610.60%
1968
1155
7.54%
105.40%
579.33%
1969
1269
9.87%
107.54%
538.70%
1970
1381
8.83%
109.87%
490.31%
1971
1581
14.48%
108.83%
450.54%
1972
1753
10.88%
114.48%
393.55%
1973
1895
8.10%
110.88%
354.93%
1974
2020
6.60%
108.10%
328.34%
1975
2212
9.50%
106.60%
308.02%
1976
2401
8.54%
109.50%
281.28%
1977
2576
7.29%
108.54%
259.14%
1978
2776
7.76%
107.29%
241.54%
1979
3003
8.18%
107.76%
224.14%
1980
3237
7.79%
108.18%
207.19%
1981
3535
9.21%
107.79%
192.22%
1982
3825
8.20%
109.21%
176.01%
1983
4066
6.30%
108.20%
162.67%
1984
4146
1.97%
106.30%
15103%
1985
4195
1.18%
101.97%
150.07%
1986
4295
2.38%
101.18%
148.32%
1987
4406
2.58%
102.38%
144.87%
1988
4519
2.56%
102.58%
141.22%
1989
4615
112%
102.56%
137.69%
1990
4732
2.54%
102.12%
134.82%
1991
4835
2.18%
102.54%
131.49%
1992
4985
3.10%
102.18%
128.69%
1993
5210
4.51%
103.10%
124.81%
1994
5408
3.80%
104.51%
119.42 %
1995
5471
1.16%
103.80%
115.05%
1996
5620
2.72%
101.16%
113.73%
1997
5825
3.65%
102.72%
110.71%
1998
5920
1.63%
10165%
106.82%
1999
6060
2.36%
101.63%
105.10%
2000
6222
2.67%
102.36%
102.67%
2001
6342
1.93%
102.67 %
104,65%
2002
6462
1.89%
101.93%
106.63%
2003
6582
1.86%
101.89%
10&61%
2004
101.86%
108.61%
000,048
Page 2 of 2
Exhibit "A"
City of Moorpark
GASB -34 Valuations
Exhibit °B"
Summary of Asset Values - Year 11
Current
Replacement
Network Subsystem Cost
10/27/2003
Original Accumulated Current
Estimated Annual Depreciation Net Value
Cost Depreciation (thru 6/3012002) (thru 6/3012002)
A Pavement
$
42,213,735
$
31,818,622
$
1,060,621
$
11,646,222
$
20,172,399
Curb & Gutter
$
17,050,176
$
12,370;671
$
123,707
$
1,535,391
$
10,835,279
Sidewalk
$
15,155,712
$
10,996,152
$
109,962
$
1,364,792
$
9,631,359
Traffic Signals
$
2,945,305
$
2,194,075
$
87,763
$
958,327
$
1,235,748
Traffic Regulatory Signs
$
279,392
$
159,985
$
22,855
$
133,736
$
26,248
Street Trees
$
2,040,200
$
1,282,533
N/A
N/A
$
1,282,533
Bridges
$
9,006,552
$
7,200,000
$
72,000
$
687,000
$
6,513,000
Parking Lots (Pavement)
$
1,912,580
$
1,440,334
$
48,011
$
563,822
$
876,512
Medians and Parkways
$
18,447,660
$
13,384,608
$
133,846
$
1,661,237
$
11,723,372
Sub -total
$
109,051,312
$
80,846,978
$
1,658,764
$
18,550,528
$
62,296,450
Storm Drainage System
Pipes
$
1,790,750
$
1,619,399
$
16,194
$
71,338
$
1,548,061
Parks & Recreation
Bike Path
$
194,390
$
156,727
$
3,135
$
29,778
$
126,949
Land Network
Land
N/A
$
31,406,446
N/A
NIA
$
31,406,446
Rights -of -Way
N/A
$
123,066,830
N/A
N/A
$
123,066,830
Sub -total
N/A
$
154,473,276
NIA
N/A
$
154,473,276
Grand Total
$
111,036,452
$
237,096,381
$
1,678,093
$
18,651,644
$
218,444,737
Summary of Asset Values Year
2003
Current
Original
Accumulated
Current
Replacement
Estimated
Annual
Depreciation
Net Value
Network Subsystem
Cost
Cost
Depreciation
(thru 6/3012003)
(thru 6130/2003)
Roadway /Streets
Pavement
$
46,507,562
$
35,117,479
$
1,170,583
$
12,761,102
$
22,356,376
Curb & Gutter
$
18,559,411
$
13,465,689
$
134,657
$
1,805,957
$
11,659,732
Sidewalk
$
16,497,254
$
11,969,501
$
119,695
$
1,605,295
$
10,364,206
Traffic Signals
$
3,200,000
$
2,394,075
$
95,763
$
1,047,401
$
1,346,673
Traffic Regulatory Signs
$
296,225
$
171,630
$
24,519
$
141,621
$
30,009
Street Trees
$
2,040,200
$
1,282,533
N/A
N/A
$
1,282,533
Bridges
$
9,006,552
$
7,200,000
$
72,000
$
759,000
$
6,441,000
Parking Lots (Pavement)
$
1,912,580
$
1,440,334
$
48,011
$
611,833
$
828,501
Medians and Parkways
$
18,447,660
$
13,384,608
$
133,846
$
1,795,083
$
11,589,525
Sub -total
$
116,467,445
$
86,425,848
$
1,799,073
$
20,527,292
$
65,898,556
Storm Drainage System
Pipes
$
1,790,750
$
1,619,399
$
16,194
$
87,532
$
1,531,867
Parks & Recreation
Bike Path
$
198,000
$
156,727
$
3,135
$
32,913
$
123,815
Land Network
Land
N/A
$
31,406,446
NIA
N/A
$
31,406,446
Rights -of -Way
N/A
$
123,066,830
N/A
N/A
$
123,066,830
Sub -total
N/A
$
154,473,276
NIA
NIA
$
154,473,276
Grand Total
$
118,456,195
$
242,675,251
$
1,818,402
$
20,647,737
$
222,027,514
Page 1 of 1 Exhibit "B"
Exhibit "Cl" - Pavement (AC)
Year - 2002
City of Moorpark
GASB -34 Valuations
Current Original
10/27/2003
Accumulated Current
Condition
Approx.
Replacement
Estimated
Annual
Depreciation
Net
Rating
Length ( mi )
Const. Date
Age
Cost
Cost
Depreciation
(thru 6/3012002)
Value
Alley
0.60
1997
5
$
279,804
$
252,222
$
8,407
$
46,241
$
205,981
Overlay
3.00
2001
1
$
1,471,688
$
1,406,248
$
46,875
$
70,312
$
1,335,936
N.S. /Overlay
4.56
1999
3
$
2,436,031
$
2,317,792
$
77,260
$
270,409
$
2,047,383
New Street
0.06
1998
4
$
28,828
$
26,989
$
900
$
4,048
$
22,940
100
9.95
1995
7
$
4,640,083
$
3,928,489
$
130,950
$
982,122
$
2,946,367
98
0.53
1994
8
$
247,160
$
206,847
$
6,895
$
58,607
$
148,240
95
9.02
1992
10
$
4,206,387
$
3,244,946
$
108,165
$
1,135,731
$
2,109,215
93
15.67
1993
9
$
7,307,548
$
5,891,725
$
196,391
$
1,865,713
$
4,026,012
91
11.75
1991
11
$
5,479,495
$
4,099,870
$
136,662
$
1,571,617
$
2,528,253
89
8.68
1989
.13
$
4,047,831
$
2,890,861
$
96,362
$
1,300,887
$
1,589,973
87
9.59
1988
14
$
4,472,201
$
3,127,495
$
104,250
$
1,511,623
$
1,615,873
84
5.37
1986
16
$
2,504,246
$
1,664,459
$
55,482
$
915,453
$
749,007
80
2.07
1985
17
$
965,324
$
626,669
$
20,889
$
365,557
$
261,112
77
0.61
1984
18
$
284,467
$
182,513
$
6,084
$
112,550
$
69,963
75
1.71
1983
19
$
797,441
$
501,764
$
16,725
$
326,146
$
175,617
72
1.66
1982
20
$
774,124
$
458,221
$
15,274
$
313,118
$
145,103
69
0.89
1981
21
$
415,043
$
227,047
$
7,568
$
162,717
$
64,330
66
0.76
1980
22
$
354,418
$
177,538
$
5,918
$
133,154
$
44,385
61
0.71
1979
23
$
331,101
$
153,868
$
5,129
$
120,530
$
33,338
58
0.53
1978
24
$
247,160
$
1 06,177
$
3,539
$
86,711
$
19,466
55
0.45
1977
25
$
209,853
$
83,655
$
2,789
$
71,107
$
12,548
52
0.77
1976
26
$
359,082
$
133,419
$
4,447
$
117,854
$
15,566
44
0.26
1975
27
$
121,248
$
41,504
$
1,383
$
38,046
$
3,459
38
0.32
1974
28
$
149,229
$
46,648
$
1,555
$
44,316
$
2,332
30
0.09
1972
30
$
41,971
$
11,386
$
380
$
11,386
$
-
24
0.09
1971
31
$
41,971
$
10,269
$
342
$
10,269
$
-
89.70 Miles
$
42,213,735
$
31,818,622
$
1,060,621
$
11,646,222
$
20,172,399
473,616
Feet
Page 1 of 1
Exhibit "C1"
Page 1 of 1
Exhibit "C2"
City of Moorpark
GASB-34 Valuations
1U/27/20O3
Exhibit ^C2'-
Pavement (AC)
Year -2O03
Current
Original
Accumulated
Current
Condition
Approx.
Replacement
Estimated
Annual
Dmprwc{et|mm
Net
Rating
Length mi) Const. Date
Age
Cost
Cost
Depreciation
(thru 6/30/2003)
Value
(}v*r|8y
3.00
2001
2
$
1.471.688
$ 1.406.248
$
48.875
$
117`187
$
1'289'061
N.S./Overlay
4.56
1999
4
$
2.430.031
$ 2.317.782
$
77.280
$
347.669
$
1.970.123
New Street
0.06
1888
5
$
28.828
$ 26.988
$
SDO
$
4.948
$
22.041
100
9.95
1995
8
$
4.728.250
$ 3.928,489
$
130.950
$
1.113'073
$
2.815.417
98
0.53
1994
9
$
251'750
$ 206,847
$
6.885
$
65.501
$
141.345
85
9.02
1992
11
$
4'284.500
$ 3.244.946
$
108.165
$
1.243.898
$
2.001.050
93
15.67
1893
10
$
7.443.250
$ 5.881.725
$
196.301
$
3.062.104
$
3.828.621
91
11.75
1991
12
$
5'581'250
$ 4.089.870
$
136'662
$
1'708.279
$
2'391.591
88
8.68
1089
14
$
4.123'000
$ 2.890.861
$
96.382
$
1.337.249
$
1.483.611
87
9.59
1988
15
$
4'555.250
$ 3'127.495
$
104,250
$
1.815.873
$
1.511.623
84
5.37
1986
17
$
2'550.750
$ 1.864.459
$
55'482
$
870.835
8
693.525
88
2.07
1985
18
$
983.250
$ 826.680
$
20.889
$
388.446
$
240.223
77
0.61
1984
18
$
288'750
$ 182'513
$
6'884
$
118.634
$
63.880
75
1.71
1983
20
$
812'250
$ 501.704
$
16,725
$
342.872^
$
158.892
72
1.68
1082
21
$
788'500
$ 458.221
$
15.274
$
328'392
$
129.829
69
0.89
1981
22
$
422.750
$ 227.047
$
7.588
$
170.285
$
56'762
86
0.76
1980
23
$
361,000
Q 177,538
$
5.918
$
139.072
$
38.487
61
0.71
1979
24
$
337'250
$ 153'868
$
5.128
$
125.659
$
28.209
58
0.53
1978
25
$
251'750
$ 106.177
$
3.538
$
90.251
$
15.927
65
0.45
1977
26
$
213.750
$ 83.655
$
2.789
$
73.898
$
9.760
52
0.77
1970
27
$
365.750
$ 133.419
$
4.447
$
122.301
$
11'118
44
0.26
1975
28
$
123.500
$ 41'504
$
1.383
$
30.429
$
2.075
38
0.32
1874
29
$
152.000
$ 46'848
$
1.555
$
45.871
$
777
30
0.09
1872
31
$
42.750
$ 11.380
$
380
$
11.386
$
-
515.539 Feet
Page 1 of 1
Exhibit "C2"
City of Moorpark
GASB -34 Valuations
Exhibit "D1" - Curb & Gutter
Year-2002
Page 1 of 1
10/27/2003
Exhibit "D1"
Total
Current
Original
Accumulated
Length
Replacement
Estimated
Annual
Depreciation
Current Net
Year
(LF)
Age
Cost
Cost
Depreciation
(thru 6/30/2002)
Value
1985
134,734
17
$
2,694,675
$
1,728,994
$
17,290
$
302,574
$
1,426,420
1986
92,098
16
$
1,841,957
$
1,210,035
$
12,100
$
199,656
$
1,010,379
1987
87,111
15
$
1,742,219
$
1,174,093
$
11,741
$
181,984
$
992,108
1988
221,035
14
$
4,420,698
$
3,055,542
$
30,555
$
443,054
$
2,612,488
1989
79,542
13
$
1,590,845
$
1,122,935
$
11,229
$
151,596
$
971,339
1990
31,303
12
$
626,070
$
453,130
$
4,531
$
56,641
$
396,489
1991
18,038
11
$
360,765
$
266,794
$
2,668
$
30,681
$
236,113
1992
13,215
10
$
264,294
$
201,515
$
2,015
$
21,159
$
180,356
1993
15,875
9
$
317,498
$
253,008
$
2,530
$
24,036
$
228,972
1994
16,963
8
$
339,267
$
280,629
$
2,806
$
23,854
$
256,776
1995
9,679
7
$
193,580
$
161,988
$
1,620
$
12,149
$
149,839
1996
20,480
6
$
409,592
$
352,081
$
3,521
$
22,885
$
329,196
1997
29,248
5
$
584,953
$
521,161
$
5,212
$
28,664
$
492,497
1998
24,322
4
$
486,445
$
440,464
$
4,405
$
19,821
$
420;643
1999
11,163
3
$
223,268
$
206,944
$
2,069
$
7,243
$
199,701
2000
8,557
2
$
171,136
$
162,864
$
1,629
$
4,072
$
158,793
2001
7,374
1
$
147,470
$
143,049
$
1,430
$
2,146
$
140,904
2002
31,772
0
$
635,445
$
635,445
$
6,354
$
3,177
$
632,267
852,509
$ 17,050,176
$
12,370,671
$
123,707
$
1,535,391
$
10,835,279
Page 1 of 1
10/27/2003
Exhibit "D1"
Year -2003
Page 1 of 1
10/27/2003
Exhibit "D2"
Total
Current
Original
Accumulated
Length
Replacement
Estimated
Annual
Depreciation
Current Net
Year
(LF)
Age
Cost
Cost
Depreciation
(thru 6/30/2003)
Value
1985
146,660
18
$
2,933,201
$
1,882,040
$
18,820
$
348,177
$
1,533,862
1986
100,250
17
$
2,005,002
$
1,317,144
$
13,171
$
230,500
$
1,086,644
1987
94,822
16
$
1,896,436
$
1,278,020
$
12,780
$
210,873
$
1,067,147
1988
240,600
15
$
4,812,006
$
3,326,010
$
33,260
$
515,532
$
2,810,479
1989
86,583
14
$
1,731,662
$
1,222,334
$
12,223
$
177,238
$
1,045,096
1990
34,074
13
$
681,488
$
493,240
$
4,932
$
66,587
$
426,652
1991
19,635
12
$
392,699
$
290,410
$
2,904
$
36,301
$
254,109
1992
14,384
11
$
287,688
$
219,352
$
2,194
$
25,226
$
194,127
1993
17,280
10
$
345,602
$
275,404
$
2,754
$
28,917
$
246,486
1994
18,465
9
$
369,298
$
305,470
$
3,055
$
29,020
$
276,450
1995
10,536
8
$
210,715
$
176,326
$
1,763
$
14,988
$
161,339
1996
22,292
7
$
445,848
$
383,246
$
3,832
$
28,743
$
354,503
1997
31,837
6
$
636,732
$
567,293
$
5,673
$
36,874
$
530,419
1998
26,475
5
$
529,503
$
479,452
$
4,795
$
26,370
$
453,083
1999
12,152
4
$
243,031
$
225,262
$
2,253
$
10,137
$
215,126
2000
9,314
3
$
186,284
$
177,281
$
1,773
$
6,205
$
171,076
2001
8,026
2
$
160,524
$
155,712
$
1,557
$
3,893
$
151,819
2002
34,585
1
$
691,692
$
691,692
$
6,917
$
10,375
$
681,317
927,971
$ 18,559,411
$
13,465,689
$
134,657
$
1,805,957
$11,659,732
Page 1 of 1
10/27/2003
Exhibit "D2"
I.
a.
City of Moorpark
GASB -34 Valuations
1 0/27/2003
Exhibit "E1" - Sidewalk
Year - 2002
Page 1 of 1
Exhibit "E1"
Current
Original
Accumulated
Total Area
Replacement
Estimated
Annual
Depreciation
Current Net
Year
(SF)
Age
Cost
Cost
Depreciation (thru 6/30/2002)
Value
1985
479,053
17
$
2,395,267
$
1,536,884
$
15,369
$
268,955
$
1,267,929
1986
327,459
16
$
1,637,295
$
1,075,586
$
10,756
$
177,472
$
898,115
1987
309,728
15
$
1,548,639
$
1,043,638
$
10,436
$
161,764
$
881,874
1988
785,902
14
$
3,929,509
$
2,716,037
$
27,160
$
393,825
$
2,322,212
1989
282,817
13
$
1,414,084
$
998,165
$
9,982
$
134,752
$
863,412
1990
111,301
12
$
556,507
$
402,782
$
4,028
$
50,348
$
352,434
1991
64,136
11
$
320,680
$
237,150
$
2,372
$
27,272
$
209,878
1992
46,986
10
$
234,928
$
179,124
$
1,791
$
18,808
$
160,316
1993
56,444
9
$
282,221
$
224,896
$
2,249
$
21,365
$
203,531
1994
60,314
8
$
301,571
$
249,448
$
2,494
$
21,203
$
228,245
1995
34,414
7
$
172,071
$
143,989
$
1,440
$
10,799
$
133,190
1996
72,816
6
$
364,081
$
312,961
$
3,130
$
20,342
$
292,618
1997
103,992
5
$
519,958
$
463,254
$
4,633
$
25,479
$
437,775
1998
86,479
4
$
432,395
$
391,523
$
3,915
$
17,619
$
373,905
1999
39,692
3
$
198,460
$
183,950
$
1,840
$
6,438
$
177,512
2000
30,424
2
$
152,121
$
144,768
$
1,448
$
3,619
$
141,149
2001
26,217
1
$
131,085
$
127,155
$
1,272
$
1,907
$
125,248
2002
112,968
0
$
564,840
$
564,840
$
5,648
$
2,824
$
562,015
3,031,142
$ 15,155,712
$ 10,996,152
$
109,962
$
1,364,792
$
9,631,359
Page 1 of 1
Exhibit "E1"
City of Moorpark
GASB -34 Valuations
Exhibit "E2" - Sidewalk
Year-2003
10/27/2003
Page 1 of 1 Exhibit "E2"
Current
Original
Accumulated
Total Area
Replacement
Estimated
Annual
Depreciation
Current
Net
Year
(SF)
Age
Cost
Cost
Depreciation
(thru 6130/2003)
Value
1985
521,458
18
$
2,607,289
$
1,672,924
$
16,729
$
309,491
$
1,363,433
1986
356,445
17
$
1,782,224
$
1,170,794
$
11,708
$
204,889
$
965,905
1987
337,144
16
$
1,685,720
$
1,136,018
$
11,360
$
187,443
$
948,575
1988
855,468
15
$
4,277,339
$
2,956,454
$
29,565
$
458,250
$
2,498,203
1989
307,851
14
$
1,539,255
$
1,086,519
$
10,865
'$
157,545
$
928,974
1990
121,153
13
$
605,767
$
438,435
$
4,384
$
59,189
$
379,246
1991
69,813
12
$
349,066
$
258,142
$
2,581
$
32,268
$
225,874
1992
51,145
11
$
255,723
$
194,980
$
1,950
$
22,423
$
172,557
1993
61,440
10
$
307,202
$
244,803
$
2,448
$
25,704
$
219,099
1994
65,653
9
$
328,265
$
271,529
$
2,715
$
25,795
$
245,734
1995
37,460
8
$
187,302
$
156,735
$
1,567
$
13,322
$
143,412
1996
79,262
7
$
396,309
$
340,663
$
3,407
$
25,550
$
315,113
1997
113,197
6
$
565,984
$
504,260
$
5,043
$
32,777
$
471,484
1998
94,134
5
$
470,670
$
426,180
$
4,262
$
23,440
$
402,740
1999
43,205
4
$
216,027
$
200,233
$
2,002
$
9,010
$
191,223
2000
33,117
3
$
165,586
$
157,583
$
1,576
$
5,515
$
152,067
2001
28,538
2
$
142,688
$
138,410
$
1,384
$
3,460
$
134,950
2002
122,968
1
$
614,838
$
614,838
$
6,148
$
9,223
$
605,615
3,299,451
$ 16,497,254
$ 11,969,501
$
119,695
$
1,605,295
$
10,364,206
10/27/2003
Page 1 of 1 Exhibit "E2"
i
Page 1 of 1
Exhibit "F1"
Current
Original
Accumulated
Current
Replacement
Estimated
Annual
Depreciation
Net
Locations
Qty
Year
Age
Cost
Cost
Depreciation
(thru 6/30/2002)
Value
Tierra Rejada Rd and Countrywood Dr
1
1991
11
$
196,354
$
146,916
$
5,877
$
67,581
$
79,335
Tierra Rejada Rd and High School Entrance
1
1991
11
$
196,354
$
146,916
$
5,877
$
67,581.
$
79,335
Tierra Rejada Rd and Mountain Trail St
1
1991
11
$
196,354
$
146,916
$
5,877
$
67,581
$
79,335
Tierra Rejada Rd and Mountain Meadow Dr
1
1989
13
$
196,354
$
140,231
$
5,609
$
75,725
$
64,506
Tierra Rejada Rd and Walnut Creek Rd
1
1988
14
$
196,354
$
137,314
$
5,493
$
79,642
$
57,672
Tierra Rejada Rd and Peach Hill Rd
1
1985
17
$
196,354
$
127,469
$
5,099
$
89,228
$
38,241
Tierra Rejada Rd and Spring Rd
1
1990
12
$
196,354
$
143,786
$
5,751
$
71,893
$
71,893
Tierra Rejada Rd and Moorpark Rd
1
1997
5
$
196,354
$
176,998
$
7,080
$
38,940
$
138,058
Tierra Rejada Rd and Sunset Valley Rd
1
1995
7
$
196,354
$
166,241
$
6,650
$
49,872
$
116,369
Peach Hill Rd and Spring Rd
1
1992
10
$
196,354
$
151,474
$
6,059
$
63,619
$
87,855
Peach Hill Rd and Miller Parkway
1
1998
4
$
196,354
$
179,885
$
7,195
$
32,379
$
147,505
High St and Spring Rd
1
1975
27
$
196,354
$
67,214
$
2,689
$
67,214
$
-
Condor Dr and Los Angeles Ave
1
1992
10
$
196,354
$
151,474
$
6,059
$
63,619
$
87,855
Campus Park Dr and Collins Dr
1
1994
8
$
196,354
$
164,327
$
6,573
$
55,871
$
108,456
Campus Park Dr Delfen St
1
1991
11
$
196,354
$
146,916
$
5,877
$
67,581
$
79,335
15
$
2,945,305
$
2,194,075
$
87,763
$
958,327
$
1,235,748
i
Page 1 of 1
Exhibit "F1"
Exhibit "F2" - Traffic Signals
Year -2003
City of Moorpark
GASB -34 Valuations
10/27/2003
Current Original Accumulated Current
Replacement Estimated Annual Depreciation Net
Locations
Qty
Year
Age
Cost
Cost
Depreciation
(thru 613012003)
Value
Tierra Rejada Rd and Countrywood Dr
1
1991
12
$
200,000
$
146,916
$
5,877
$
73,458
$
73,458
Tierra Rejada Rd and High School Entrance
1
1991
12
$
200,000
$
146,916
$
5,877
$
73,458
$
73,458
Tierra Rejada Rd and Mountain Trail St
1
1991
12
$
200,000
$
146,916
$
5,877
$
73,458
$
73,458
Tierra Rejada Rd and Mountain Meadow Dr
1
1989
14
$
200,000
$
140,231
$
5,609
$
81,334
$
58,897
Tierra Rejada Rd and Walnut Creek Rd
1
1988
15
$
200,000
$
137,314
$
5,493
$
85,135
$
52,179
Tierra Rejada Rd and Peach Hill Rd
1
1985
18
$
200,000
$
127,469
$
5,099
$
94,327
$
33,142
Tierra Rejada Rd and Spring Rd
1
1990
13
$
200,000
$
143,786
$
5,751
$
77,644
$
66,142
Tierra Rejada Rd and Moorpark Rd
1
1997
6
$
200,000
$
176,998
$
7,080
$
46,019
$
130,978
Tierra Rejada Rd and Sunset Valley Rd
1
1995
8
$
200,000
$
166,241
$
6,650
$
56,522
$
109,719
Peach Hill Rd and Spring Rd
1
1992
11
$
200,000
$
151,474
$
6,059
$
69,678
$
81,796
Peach Hill Rd and Miller Parkway
1
1998
5
$
200,000
$
179,885
$
7,195
$
39,575
$
140,310
High St and Spring Rd
1
1975
28
$
200,000
$
67,214
$
2,689
$
67,214
$
-
Condor Dr and Los Angeles Ave
1
1992
11
$
200,000
$
151,474
$
6,059
$
69,678
$
81,796
Campus Park Dr and Collins Dr
1
1994
9
$
200,000
$
164,327
$
6,573
$
62,444
$
101,883
Campus Park Dr Delfen St
1
1991
12
$
200,000
$
146,916
$
5,877
$
73,458
$
73,458
Millard St and Patriot St
1
2003
0
$
200,000
$
200,000
$
8,000
$
4,000
$
196,000
16
$
3,200,000
$
2,394,075
$
95,763
$
1,047,401
$
1,346,673
0
0
0
0
Page 1 of 1
Exhibit "F2"
I
City of Moorpark
GASB -34 Valuations
Exhibit "G1" - Traffic Regulatory Signs
Year -2002
10/27/2003
Page 1 of 1
Exhibit "G1"
Current
Original
Accumulated
Current
Replacement
Estimated
Annual
Depreciation
Net
Total Qty
Year
Age
Cost
Cost
Depreciation
(thru 6/30/2002)
Value
77
2002
0
$
6,426
$
6,426
$
918
$
459
$
5,967
72
2001
1
$
6,008
$
5,897
$
842
$
1,264
$
4,633
135
2000
2
$
11,266
$
10,847
$
1,550
$
3,874
$
6,973
108
1999
3
$
9,013
$
8,452
$
1,207
$
4,226
$
4,226
86
1998
4
$
7,177
$
6,575
$
939
$
4,227
$
2,348
94
1997
5
$
7,844
$
7,071
$
1,010
$
5,556
$
1,515
113
1996
6
$
9,430
$
8,201
$
1,172
$
7,615
$
586
157
1993
9
$
13,102
$
10,563
$
1,509
$
10,563
$
-
4
1992
10
$
334
$
258
$
37
$
258
$
-
18
1991
11
$
1,502
$
1,124
$
161
$
1,124
$
-
93
1990
12
$
7,761
$
5,683
$
812
$
5,683
$
-
398
1988
14
$
33,213
$
23,227
$
3,318
$
23,227
$
-
662
1986
16
$
55,244
$
36,718
$
5,245
$
36,718
$
-
257
1985
17
$
21,447
$
13,923
$
1,989
$
13,923
$
-
134
1980
22
$
11,182
$
5,602
$
800
$
5,602
$
-
155
1975
27
$
12,935
$
4,428
$
633
$
4,428
$
-
72
1970
32
$
6,008
$
1,284
$
183
$
1,284
$
-
528
1950
52
$
44,062
$
3,477
$
497
$
3,477
$
-
185
1910
92
$
15,438
$
229
$
33
$
229
$
-
3,348
279,392
159,985
22,855
133,736
26,248
Page 1 of 1
Exhibit "G1"
i
AI
City of Moorpark
GASB -34 Valuations
Exhibit "G2" - Traffic Regulatory Signs
Year -2003
10/27/2003
Page 1 of 1
Exhibit "G2"
Current
Original
Accumulated
Current
Replacement
Estimated
Annual
Depreciation
Net
Total Qty
Year
Age
Cost
Cost
Depreciation
(thru 6130/2003)
Value
137
2003
0
$
11,645
$
11,645
$
1,664
$
832
$
10,813
77
2002
1
$
6,545
$
6,426
$
918
$
1,377
$
5,049
72
2001
2
$
6,120
$
5,897
$
842
$
2,106
$
3,791
135
2000
3
$
11,475
$
10,847
$
1,550
$
5,424
$
5,424
108
1999
4
$
9,180
$
8,452
$
1,207
$
5,433
$
3,019
86
1998
5
$
7,310
$
6,575
$
939
$
5,166
$
1,409
94
1997
6
$
7,990
$
7,071
$
1,010
$
6,566
$
505
113
1996
7
$
9,605
$
8,201
$
1,172
$
8,201
$
-
157
1993
10
$
13,345
$
10,563
$
1,509
$
10,563
$
-
4
1992
11
$
340
$
258
$
37
$
258
$
-
18
1991
12
$
1,530
$
1,124
$
161
$
1,124
$
-
93
1990
13
$
7,905
$
5,683
$
812
$
5,683
$
-
398
1988
15
$
33,830
$
23,227
$
3,318
$
23,227
$
-
662
1986
17
$
56,270
$
36,718
$
5,245
$
36,718
$
-
257
1985
18
$
21,845
$
13,923
$
1,989
$
13,923
$
-
134
1980
23
$
11,390
$
5,602
$
800
$
5,602
$
-
155
1975
28
$
13,175
$
4,428
$
633
$
4,428
$
-
72
1970
33
$
6,120
$
1,284
$
183
$
1,284
$
-
528
1950
53
$
44,880
$
3,477
$
497
$
3,477
$
-
185
1910
93
$
15,725
$
229
$
33
$
229
$
-
3,485
$
296,225
$
171,630
$
24,519
$
141,621
$
30,009
Page 1 of 1
Exhibit "G2"
City of Moorpark
GASB -34 Valuations
Exhibit "H" - Street Trees
10/27/2003
STREET NAME
Year
Age
Current
Replacement
Cost
Original
Estimated
Cost
Current
Net
Value
Qty
ADLENA PL Total
1983
20
$
2,400
$
1,463.06
$
1,463.06
12
ADONIS PL Total
1983
20
$
2,200
$
1,341.14
$
1,341.14
11
ALANDIA CT Total
1990
13
$
1,400
$
99634
$
996.74
7
AMBERWCK LN Total
1983
20
$
2,200
$
1,341.14
$
1,341.14
11
AMHERST ST Total
1983
20
$
5,400
$
3,291.88
$
3,291.88
27
AMHERST ST /N Total
1983
20
$
7,200
$
4,389.17
$
4,389.17
36
ANNETTE ST /E Total
1983
20
$
1,200
$
731.53
$
731.53
6
AUBURN CIR /N Total
1983
20
$
6,000
$
3,657.64
$
3,657.64
30
BAMBI CT Total
1985
18
$
1,400
$
880.99
$
880.99
7
BARD ST Total
1983
20
$
12,400
$
7,559.13
$
7,559.13
62
BAYLOR CIR Total
1983
20
$
2,400
$
1,463.06
$
1,463.06
12
BELLA VISTA DR Total
1983
20
$
12,400
$
7,559.13
$
7,559.13
62
BENWOOD DR Total
1985
18
$
1,200
$
755.14
$
755.14
6
BERKELEY CIR Total
1983
20
$
8,400
$
5,120.70
$
5,120.70
42
BLAIRWOOD DR Total
1990
13
$
4,800
$
3,417.40
$
3,417.40
24
BLOSSOMWOOD CT Total
1986
17
$
4,600
$
2,965.37
$
2,965.37
23
BODEGA PL Total
1983
20
$
1,600
$
975.37
$
975.37
8
BONITA HEIGHTS ST Total
1983
20
$
6,800
$
4,145.33
$
4,145.33
34
BONNIE VIEW ST Total
1983
20
$
1,600
$
975.37
$
975.37
8
BROOKDALE LN Total
1983
20
$
2,800
$
1,706.90
$
1,706.90
14
BROOKHURST CT Total
1990
13
$
600
$
427.17
$
42717
3
BUTTER CREEK RD Total
1990
13
$
400
$
284.78
$
284.78
2
BUTTERFIELD LN Total
1983
20
$
2,800
$
1,706.90
$
1,706.90
14
CAMBRIDGE ST Total
1983
20
$
6,800
$
4,145.33
$
4,145.33
34
CAMPUS PARK DR Total
1983
20
$
69,000
$
42,267.48
$
42,267.48
345
CAMPUS PARK DR /N Total
1983
20
$
12,200
$
7,437.21
$
7,437.21
61
CANARIO CT Total
1986
17
$
800
$
515.72
$
515.72
4
CASEY RD Total
1983
20
$
3,200
$
1,950.74
$
1,950.74
16
CHARLES ST Total
1983
20
$
33,400
$
20,360.88
$
20,360.88
167
CHRISTIAN BARRETT DR Total
1986
17
$
3,000
$
1,933.94
$
1,933.94
15
CIVIC CENTER COMPLEX Total
1983
20
$
21,200
$
12,923.67
$
12,923.67
106
COLIBRI CT Total
1990
13
$
1,200
$
854.35
$
854.35
6
COLLEGE HEIGHTS DR Total
1991
12
$
200
$
145.56
$
145.56
1
COLLINS DR Total
1985
18
$
4,800
$
3,020.54
$
3,020.54
24
COLUMBIA AV Total
1983
20
$
5,800
$
3,535.72
$
3,53532
29
CONDOR DR Total
1983
20
$
8,200
$
4,998.78
$
4,998.78
41
CORNELL CIR Total
1983
20
$
4,600
$
2,804.19
$
2,804.19
23
CORNETT AV Total
1983
20
$
5,800
$
3,535.72
$
3,535.72
29
CREIGHTON CIR /N Total
1983
20
$
3,800
$
2,316.51
$
2,316.51
19
DARTMOUTH CIR Total
1991
12
$
1,000
$
727.80
$
727.80
5
DEEPWELL LN Total
1983
20
$
2,600
$
1,584.98
$
1,584.98
13
DIABLO AV Total
1983
20
$
5,800
$
3,535.72
$
3,535.72
29
DOROTHY AV Total
1983
20
$
13,000
$
7,924.89
$
7,924.89
65
DUKE ST Total
1983
20
$
6,400
$
3,901.49
$
3,901.49
32
ELDERBERRY AV Total
1983
20
$
16,200
$
9,875.63
$
9,875.63
81
ESTHER AV Total
1983
20
$
2,200
$
1,341.14
$
1,341.14
11
EVERETT ST Total
1983
20
$
15,800
$
9,631.79
$
9,63139
79
FAIRBROOK LN Total
1983
20
$
2,600
$
1,584.98
$
1,584.98
13
FIRESIDE LN Total
1983
20
$
3,200
$
1,950.74
$
1,950.74
16
FIRST ST Total
1983
20
$
9,200
$
5,608.39
$
5,608.39
46
FLORY AV Total
1983
20
$
9,200
$
5,608.39
$
5,608.39
46
GABBERT RD Total
1983
20
$
36,000
$
21,945.86
$
21,945.86
180
GOLDMAN AV Total
1983
20
$
2,400
$
1,463.06
$
1,463.06
12
GOLONDRINA ST Total
1983
20
$
400
$
243.84
$
243.84
2
GRANADILLA DR Total
1990
13
$
800
$
569.57
$
569.57
400006()
Page 1
of 3
Exhibit "H"
City of Moorpark
GASB -34 Valuations
10/27/2003
Page 2 of 3 Exhibit "H"
Current
Original
Current
Replacement
Estimated
Net
STREET NAME
Year
Age
Cost
. Cost
Value
Qty
HARRY ST Total
1983
20
$
7,800
$
4,754.94
$
4,754.94
39
HARTFORD ST Total
1983
20
$
6,000
$
3,657.64
$
3,657.64
30
HARVARD ST IN Total
1983
20
$
18,600
$
11,338.69
$
11,338.69
93
HEDYLAND CT Total
1983
20
$
F 4,400
$
2,682.27
$
2,682.27
22
HIGH ST Total
1983
20
$
20,400
$
12,435.98
$
12,435.98
102
HONEYBEE ST /E Total
1983
20
$
1,000
$
609.61
$
609.61
5
INGLEWOOD ST Total
1986
17
$
1,200
$
773.58
$
773.58
6
KIMBERWICK LN Total
1983
20
$
2,600
$
1,584.98
$
1,584.98
13
KNOTTY PINE ST Total
1983
20
$
800
$
487.69
$
487.69
4
LANTERN LN Total
1983
20
$
2,600
$
1,598.89
$
1,598.89
13
LAURELHURST RD Total
1983
20
$
8,600
$
5,242.62
$
5,242.62
43
LOS ANGELES AV /E Total
1983
20
$
18,400
$
11,216.77
$
11,216.77
92
LOYOLA ST Total
1983
20
$
10,400
$
6,339.91
$
6,339.91
52
MAGNOLIA ST Total
1983
20
$
6,800
$
4,145.33
$
4,145.33
34
MAUREEN LN Total
1983
20
$
1,800
$
1,097.29
$
1,097.29
9
MCFADDEN AV Total
1983
20
$
7,000
$
4,267.25
$
4,267.25
35
MESA VERDE DR Total
1983
20
$
800
$
487.69
$
487.69
4
METROLTNK STATION Total
1983
20
$
9,400
$
5,730.31
$
5,730.31
47
MILLARD ST Total
1983
20
$
7,800
$
4,754.94
$
4,754.94
39
MILLERTON RD /E Total
1983
20
$
1,200
$
731.53
$
731.53
6
MOORPARK AV Total
1983
20
$
10,600
$
6,461.84
$
6,461.84
53
MOUNTAIN MEADOW DR Total
1986
17
$
30,200
$
19,468.32
$
19,468.32
151
MOUNTAIN TRAIL ST Total
1986
17
$
50,600
$
33,953.52
$
33,953.52
253
NEW LOS ANGELES AV /E Total
1983
20
$
1,000
$
609.61
$
609.61
5
NEW LOS ANGELES AV 1W Total
1983
20
$
11,400
$
6,949.52
$
6,949.52
57
OXFORD CIR Total
1983
20
$
2,400
$
1,463.06
$
1,463.06
12
PALOMAR AV Total
1983
20
$
2,600
$
1,584.98
$
1,584.98
13
PEACH HILL RD Total
1988
15
$
29,400
$
19,967.51
$
19,967.51
147
PEACH HILL WASH Total
1983
20
$
110,000
$
67,056.78
$
67,056.78
550
PECAN AV Total
1985
18
$
1,200
$
755.14
$
755.14
6
PEPPER MILL ST Total
1985
18
$
3,200
$
2,013.69
$
2,013.69
16
PEPPERDINE CIR IN Total
1983
20
$
5,400
$
3,291.88
$
3,291.88
27
POINDEXTER AV Total
1983
20
$
52,200
$
31,821.49
$
31,821.49
261
PRINCETON AV Total
1983
20
$
17,000
$
10,363.32
$
10,363.32
85
PURDUE ST /E Total
1983
20
$
8,000
$
4,876.86
$
4,876.86
40
QUAIL SUMMIT Total
1983
20
$
7,400
$
4,511.09
$
4,511.09
37
RAND ST Total
1983
20
$
7,000
$
4,267.25
$
4,267.25
35
RIVA CT Total
1983
20
$
1,800
$
1,097.29
$
1,097.29
9
ROBERTS AV Total
1983
20
$
2,400
$
1,463.06
$
1,463.06
12
RUTGER CIR Total
1983
20
$
4,400
$
2,682.27
$
2,682.27
22
RUTH AV Total
1983
20
$
12,000
$
7,315.29
$
7,315.29
60
SARAH AV Total
1983
20
$
14,000
$
8,534.50
$
8,534.50
70
SCIENCE DR Total
1983
20
$
79,400
$
48,402.80
$
48,402.80
397
SECOND ST Total
1983
20
$
25,200
$
15,362.10
$
15,362.10
126
SHADYRIDGE DR Total
1993
10
$
11,800
$
9,281.94
$
9,281.94
59
SHASTA AV Total
1983
20
$
23,400
$
14,264.81
$
14,264.81
117
SHERMAN AV Total
1983
20
$
600
$
365.76
$
365.76
3
SIERRA AV Total
1983
20
$
16,400
$
9,997.56
$
9,997.56
82
SILVER CREEK ST Total
1986
17
$
600
$
386.79
$
386.79
3
SIR GEORGE CT Total
1983
20
$
6,000
$
3,657.64
$
3,657.64
30
SPRING RD Total
1988
15
$
94,000
$
62,589.62
$
62,589.62
470
STANFORD ST /E Total
1983
20
$
18,400
$
11,216.77
$
11,216.77
92
STANLEY CT Total
1985
18
$
15,800
$
9,942.61
$
9,942.61
79
SUSAN AV Total
1983
20
$
13,200
$
8,046.81
$
8,046.81
66
TECOLOTE CT Total
1990
13
$
800
$
569.57
$
569.57
4
THIRD ST Total
1983
20
$
4,400
$
2,682.27
$
2,682.27
22
TIERRA REJADA RD /E Total
1986
17
$
624,400
$
402,517.14
$
402,517.14
312A
Page 2 of 3 Exhibit "H"
City of Moorpark
GASB -34 Valuations
10/2712003
Page 3 of 3 Exhibit "H"
Current
Original
Current
Replacement
Estimated
Net
STREET NAME
Year
Age
Cost
Cost
Value
Qty
TIERRA REJADA RD IN Total
1983
20
$
58,600
$
35,722.98
$
35,722.98
293
TULANE AV IN Total
1983
20
$
5,400
$
3,291.88
$
3,291.88
27
VALLEY RD Total
1983
20
$
8,400
$
5,120.70
$
5,120.70
42
VASSAR CIR IN Total
1983
20
$
4,200
$
2,560.35
$
2,560.35
21
VILLA CAMPESINA AV Total
1983
20
$
16,800
$
10,241.40
$
10,241.40
84
VISTA DEL VALLE DR Total
1983
20
$
4,000
$
2,438.43
$
2,438.43
20
VISTA LEVANA DR Total
1983
20
$
7,800
$
4,754.94
$
4,754.94
39
WALNUT ST Total
1983
20
$
8,600
$
5,242.62
$
5,242.62
43
WARREN CIR Total
1983
20
$
1,000
$
609.61
$
609.61
5
WESTGATE RD Total
1983
20
$
600
$
365.76
$
365.76
3
WESTWOOD ST IE Total
1983
20
$
13,600
$
8,290.66
$
8,290.66
68
WESTWOOD ST IN Total
1983
20
$
3,400
$
2,072.66
$
2,072.66
17
WHITNEY AV Total
1983
20
$
9,800
$
5,974.15
$
5,974.15
49
WICKS RD Total
1983
20
$
16,000
$
9,753.71
$
9,753.71
80
WILLIAMS RANCH RD Total
1990
13
$
10,400
$
7,404.36
$
7,404.36
52
WOODGLEN DR Total
1983
20
$
7,400
$
4,511.09
$
4,511.09
37
YALE AV Total
1983
20
$
5,000
$
3,048.04
$
3,048.04
25
Grand Total
$
2,040,200
$
1,282,533
$
1,282,533
10,201
Page 3 of 3 Exhibit "H"
w
City of Moorpark
GASB -34 Valuations
10/27/2003
Exhibit "11" - Bridges /Pedestrian Crossing
Year-2002
Page 1 of 1
Exhibit 11"
Current
Original
Accumulated
Current
Replacement
Estimated
Annual
Depreciation
Net
Locations
Year Age Cost
Cost
Depreciation
(thru
613012002)
Value
Tierra Rejada Bridge
1988 14 $ 5,648,661
$
4,000,000
$ 40,000
$
580,000
$
3,420,000
Spring Rd Bridge
2,000 2 $ 2,361,485
$
2,300,000
$ 23,000
$
57,500
$
2,242,500
AVCP Pedestrian Crossing
1997 5 $ 996,406
$
900,000
$ 9,000
$
49,500
$
850,500
$ 9,006,552
$
7,200,000
$ 72,000
$
687,000
$
6,513,000
Page 1 of 1
Exhibit 11"
Page 1 of 1
Exhibit "12"
City of Moorpark
GASB -34 Valuations
10/27/2003
Exhibit "12" - Bridges /Pedestrian
Crossing
Year -2003
Current Original
Accumulated
Current
Replacement Estimated
Annual
Depreciation
Net
Locations
Year Age
Cost Cost
Depreciation
(thru 6/30/2003)
Value
Tierra Rejada Bridge
1988 15
$ 5,648,661 $ 4,000,000
$
40,000
$ 620,000
$
3,380,000
Spring Rd Bridge
2000 3
$ 2,361,485 $ 2,300,000
$
23,000
$ 80,500
$
2,219,500
AVCP Pedestrian Crossing
1997 6
$ 996,406 $ 900,000
$
9,000
$ 58,500
$
841,500
$ 9,006,552 $ 7,200,000
$
72,000
$ 759,000
$
6,441,000
Page 1 of 1
Exhibit "12"
Exhibit "J1" - Parking lots
Year - 2002
City of Moorpark
GASB -34 Valuations
Current Original
10/27/2003
Accumulated Current
Page 1 of 1
1
Exhibit "J1"
Total Area
Year
Replacement
Estimated
Annual
Depreciation
Net
Parking lots
(SF)
Acquired
Age
Cost
Cost
Depreciation
(thru
6130/2002)
Value
Arroyo Vista Community Park
191,900
1993
9
$
767,600
$
618,879
$
20,629
$
195,978
$
422,901
Community Center Park/City Hall
32,200
1983
19
$
128,800
$
81,043
$
2,701
$
52,678
$
28,365
Country Trail Park
10,125
1995
7
$
40,500
$
34,289
$
1,143
$
8,572
$
25,717
College View Park
103,680
1983
19
$
414,720
$
260,949
$
8,698
$
169,617
$
91,332
Miller Park
21,000
2002
0
$
84,000
$
84,000
$
2,800
$
1,400
$
82,600
Monte Vista Nature Park
15,000
1990
12
$
60,000
$
43,937
$
1,465
$
18,307
$
25,630
Mountain Meadows Park
16,830
1987
15
$
67,320
$
45,901
$
1,530
$
23,715
$
22,185
Peach Hill Park
32,500
1988
14
$
130,000
$
90,911
$
3,030
$
43,941
$
46,971
Poindexter Park
23,925
1996
6
$
95,700
$
83,230
$
2,774
$
18,033
$
65,197
Tierra Rejada Park
24,345
1991
11
$
97,380
$
72,862
$
2,429
$
27,930
$
44,931
Park Campesina
6,640
1998
4
$
26,560
$
24,332
$
811
$
3,650
$
20,682
478,145
1,912,580
1,440,334
48,011
563,822
876,512
Page 1 of 1
1
Exhibit "J1"
w
r ,
City of Moorpark
GASB -34 Valuations
10/27/2003
Exhibit "J2" - Parking Lots
Year -2003
Page 1 of 1
Exhibit "J2"
Current
Original
Accumulated
Current
Total Area
Year
Replacement
Estimated
Annual
Depreciation
Net
Parking Lots
(SF)
Acquired Age
Cost
Cost
Depreciation
(thru 6/30/2003)
Value
Arroyo Vista Community Park
191,900
1993
10
$
767,600
$
618,879
$
20,629
$
216,608
$
402,271
Community Center Park/City Hall
32,200
1983
20
$
128,800
$
81,043
$
2,701
$
55,379
$
25,664
Country Trail Park
10,125
1995
8
$
40,500
$
34,289
$
1,143
$
9,715
$
24,574
College View Park
103,680
1983
20
$
414,720
$
260,949
$
8,698
$
178,315
$
82,634
Miller Park
21,000
2002
1
$
84,000
$
84,000
$
2,800
$
4,200
$
79,800
Monte Vista Nature Park
15,000
1990
13
$
60,000
$
43,937
$
1,465
$
19,772
$
24,165
Mountain Meadows Park
16,830
1987
16
$
67,320
$
45,901
$
1,530
$
25,246
$
20,655
Peach Hill Park
32,500
1988
15
$
130,000
$
90,911
$
3,030
$
46,971
$
43,941
Poindexter Park
23,925
1996
7
$
95,700
$
83,230
$
2,774
$
20,808
$
62,423
Tierra Rejada Park
24,345
1991
12
$
97,380
$
72,862
$
2,429
$
30,359
$
42,503
Park Campesina
6,640
1998
5
$
26,560
$
24,332
$
811
$
4,461
$
19,871
478,145
$
1,912,580
$ 1,440,334
$
48,011
$
611,833
$
828,501
Page 1 of 1
Exhibit "J2"
1 1
S
City of Moorpark
GASB -34 Valuations
Exhibit "K1" - Landscaped Medians and Parkways
Year-2002
Accumulated
Current Original Depreciation
3,689,532 $ 18,447,660 $13,384,608 $ 133,846 $ 1,661,237 $11,723,372
Page 1 of 1
10/27/2003
Exhibit "K1"
Total Area
Replacement
Estimated
Annual
(thru
Current Net
Year
(SF)
Age
Cost
Cost
Depreciation
6130/2002)
Value
1985
583,108
17
$
2,915,539
$
1,870,708
$
18,707
$
327,374
$
1,543,334
1986
398,586
16
$
1,992,930
$
1,309,213
$
13,092
$
216,020
$
1,093,193
1987
377,003
15
$
1,885,017
$
1,270,325
$
12,703
$
196,900
$
1,073,424
1988
956,606
14
$
4,783,032
$
3,305,983
$
33,060
$
479,368
$
2,826,616
1989
344,247
13
$
1,721,235
$
1,214,974
$
12,150
$
164,022
$
1,050,953
1990
135,477
12
$
677,384
$
490,270
$
4,903
$
61,284
$
428,986
1991
78,067
11
$
390,334
$
288,661
$
2,887
$
33,196
$
255,465
1992
57,191
10
$
285,956
$
218,031
$
2,180
$
22,893
$
195,138
1993
68,704
9
$
343,521
$
273,745
$
2,737
$
26,006
$
247,740
1994
73,415
8
$
367,074
$
303,631
$
3,036
$
25,809
$
277,822
1995
41,889
7
$
209,446
$
175,265
$
1,753
$
13,145
$
162,120
1996
88,633
6
$
443,163
$
380,938
$
3,809
$
24,761
$
356,177
1997
126,580
5
$
632,898
$
563,877
$
5,639
$
31,013
$
532,864
1998
105,263
4
$
526,315
$
476,566
$
4,766
$
21,445
$
455,120
1999
48,313
3
$
241,567
$
223,906
$
2,239
$
7,837
$
216,069
2000
37,033
2
$
185,163
$
176,213
$
1,762
$
4,405
$
171,808
2001
31,911
1
$
159,557
$
154,774
$
1,548
$
2,322
$
152,453
2002
137,506
0
$
687,528
$
687,528
$
6,875
$
3,438
$
684,090
3,689,532 $ 18,447,660 $13,384,608 $ 133,846 $ 1,661,237 $11,723,372
Page 1 of 1
10/27/2003
Exhibit "K1"
re
apt,
City of Moorpark
GASB -34 Valuations
Exhibit "K2" - Landscaped Medians and Parkways
Year -2003
Page 1 of 1
10/27/2003
Exhibit "K2"
r �.w
Accumulated
Current
Original
Depreciation
Total Area
Replacement
Estimated
Annual
(thru
Current
Net
Year
(SF)
Age
Cost
Cost
Depreciation
6/3012003)
Value
1985
583,108
18
$
2,915,539
$
1,870,708
$
18,707
$
346,081
$
1,524,627
1986
398,586
17
$
1,992,930
$
1,309,213
$
13,092
$
229,112
$
1,080,101
1987
377,003
16
$
1,885,017
$
1,270,325
$
12,703
$
209,604
$
1,060,721
1988
956,606
15
$
4,783,032
$
3,305,983
$
33,060
$
512,427
$
2,793,556
1989
344,247
14
$
1,721,235
$
1,214,974
$
12,150
$
176,171
$
1,038,803
1990
135,477
13
$
677,384
$
490,270
$
4,903
$
66,186
$
424,083
1991
78,067
12
$
390,334
$
288,661
$
2,887
$
36,083
$
252,579
1992
57,191
11
$
285,956
$
218,031
$
2,180
$
25,074
$
192,958
1993
68,704
10
$
343,521
$
273,745
$
2,737
$
28,743
$
245,002
1994
73,415
9
$
367,074
$
303,631
$
3,036
$
28,845
$
274,786
1995
41,889
8
$
209,446
$
175,265
$
1,753
$
14,897
$
160,367
1996
88,633
7
$
443,163
$
380,938
$
3,809
$
28,570
$
352,368
1997
126,580
6
$
632,898
$
563,877
$
5,639
$
36,652
$
527,225
1998
105,263
5
$
526,315
$
476,566
$
4,766
$
26,211
$
450,354
1999
48,313
4
$
241,567
$
223,906
$
2,239
$
10,076
$
213,830
2000
37,033
3
$
185,163
$
176,213
$
1,762
$
6,167
$
170,046
2001
31,911
2
$
159,557
$
154,774
$
1,548
$
3,869
$
150,905
2002
137,506
1
$
6.87,528
$
687,528
$
6,875
$
10,313
$
677,215
3,689,532
$ 18,447,660
$13,384,608
$
133,846
$
1,795,083
$ 11,589,525
Page 1 of 1
10/27/2003
Exhibit "K2"
r �.w
City of Moorpark
GASB-34 Valuations
10/27/2003
Exhibit "Ll" - Storm Drain Pipelines
Year -2002
Page 1 of 1
Exhibit "L1"
Current
Original
Accumulated
Current
Replacement
Estimated
Annual
Depreciation
Net
Year
Age
Cost
Cost
Depreciation
(thru 6/3012002)
Value
1995
7
$
36,000
$
29,923
$
299
$
2,244
$
27,679
1997
5
$
861,250
$
762,197
$
7,622
$
41,921
$
720,276
1998
4
$
-
$
-
$
-
$
-
$
1999
3
$
705,000
$
649,088
$
6,491
$
22,718
$
626,370
2000
2
$
188,500
$
178,190
$
1,782
$
4,455
$
173,735
$
1,790,750
$
1,619,399
$
16,194
$
71,338
$
1,548,061
Page 1 of 1
Exhibit "L1"
City of Moorpark
GASB -34 Valuations
10/27/2003
Exhibit "12" - Storm Drain Pipelines
Year - 2003
Page 1 of 1
Exhibit "12"
Current
Original
Accumulated
Current
Replacement
Estimated
Annual
Depreciation
Net
Year
Age
Cost
Cost
Depreciation
(thru 6130/2003)
Value
1995
8
$ 36,000
$
29,923
$
299
$
2,543
$
27,380
1997
6
$ 861,250
$
762,197
$
7,622
$
49,543
$
712,654
1998
5
$ -
$
-
$
-
$
-
$
-
1999
4
$ 705,000
$
649,088
$
6,491
$
29,209
$
619,879
2000
3
$ 188,500
$
178,190
$
1,782
$
6,237
$
171,953
$ 1,790,750
$
1,619,399
$
16,194
$
87,532
$
1,531,867
Page 1 of 1
Exhibit "12"
A
City of Moorpark
GASB-34 Valuations
10/27/2003
Exhibit "MI" - Bike Path
Year -2002
Current Original Accumulated Current
Total Area Replacement Estimated Annual Depreciation Net
(SF) Year Age Cost Cost Depreciation (thru 6/30/2002) Value
Class I Bike Path 49,500 1993 9 $ 194,390 $ 156,727 $ 3,135 $ 29,778 $ 126,949
Exhibit "M2" - Bike Path
Year -2003
Current
Original
Accumulated
Current
Total Area Replacement
Estimated
Annual Depreciation
Net
(SF) Year Age Cost
Cost
Depreciation (thru 6/3012003)
Value
Class I Bike Path 49,500 1993 10 $ 198,000
$ 156,727
$ 3,135 $ 32,913
$ 123,815
Page 1 of 1
Exhibits "MI"- "M2"
City of Moorpark
GASB-34 Valuations
1O/27/2
10/27/2,003
Exhibit°N^-Land
Original
Curreot
Year
Estimated
Net
Acquired
Cost
Value
ARROYO VISTA COMMURITY PARK
Land, Access Rd-O.35acres
1983
$
113.400
$
113.400
Land, Park Site -3O.44acres
1984
$
5.708.300
$
5.708.300
Land, Park Site '27.4acres
1988
$
4.066.200
$
4.066.200
Land, Access Rd-1.5Oacres
1992
$
33[i900
$
330.900
Land, Access Rd-OJ4acres
1996
$
280.800
$
290.800
CAMPUS PARK
Land. Park site -O.7 ounao
1984
$
249'500
$
249.580
Land, Park site ' 1.83 acres
1987
$
279.800
$
279.800
CAMPUS CANYON PARK
Land, Park Site -8.Oacres
1986
$
1.110.600
$
1.110.600
COUNTRY TRAIL PARK
Land, Park Site -7.5acres
1985
$
900,000
$
900.000
COLLEGE VIEW PARK
Land, Park Site -4.33acres
1884
$
643.000
$
643.000
GLENVVOQD PARK
^
Land, Park Site -4.44acres
1984
$
659.300
$
659.300
MILLER PARK
Land, Park Site '7.23acres
1968
$
283.400
8
283.400
Land, Park Site -8.U1 aonao
1068
$
353.200
$
353.200
K8ONTE VISTA NATURE PARK
Land, Park Site -8.O8acres
1990
$
800.000
$
800.000
MOUNTAIN MEADOWS PARK
Land, Park Site -8.Oacres
1807
$
1.223.200
$
1.228.200
PEACH HILL PARK
Land, Park Site -9.2Oacres
1984
$
1.375.100
$
1.375.100
PC]|NDEXTER PARK
Land, Park Site -7.18acres
1996
$
1.172.000
$
1.172.000
T|ERRAFkEJADAPARK
Land, Park Site -7.5acres
1992
$
880.000
$
QOO'OOO
VIRGINIA COLONY PARK
Land, Park Site
1996
$
300.000
$
300.000 '
VILLA CAK8PES/NAPARK
"=
Land. Park Site - 1-1Qacres
1898
$
188.200
$
199.200
Page I of 2
Exhibit "N"
City of Moorpark
GASB -34 Valuations
Original Current
Year Estimated Net
Page 2 of 2
$ 31,406,446 $ 31,406,446
10/27/2003
Exhibit "N"
Acquired
Cost
Value
CITY LAND
Land, Daisy /Peppermill - 3.19 acres
1984
$
473,700
$
473,700
Land, Peppermill St - 5.98 acres
1984
$
888,000
$
888,000
Land, LA Ave Fwy Row - 0.31 acres
1993
$
113,800
$
113,800
Land, Home Acres Buff - 1.53 acres
1994
$
263,900
$
263,900
Land
2001
$
74,324
$
74,324
Land
2001
$
176,962
$
176,962
Land Parcel
1997
$
139,500
$
139,500
Land, Regal Park Condo - 1.15 acres
1992
$
170,100
$
170,100
Land, LA Ave Fwy Ease Land - 0.13 acres
1996
$
51,100
$
51,100
Land, LA Ave Future - 0.95 acres
1997
$
9,900
$
9,900
Land, Science Dr Ease - 0.06 acres
1998
$
24,200
$
24,200
Land Parcel
1994
$
600
$
600
Land Parcel, W /House
1999
$
11,727
$
11,727
Land, Civic Center - 3.1 acres
1984
$
460,400
$
460,400
Land, Access Rd & Parks - 0.89 acre
1984
$
313,600
$
313,600
Land Parcel
1994
$
147,000
$
147,000
Land Parcel
1993
$
231,500
$
231,500
Land Parcel
1993
$
334,000
$
334,000
Land
2001
$
1,859,114
$
1,859,114
Land Parcel W/ House
1994
$
105,169
$
105,169
Land, Mobile Home
2001
$
883,244
$
883,244
Land, W /Buildings
2002
$
917,692
$
917,692
Land, W /Buildings
2000
$
110,737
$
110,737
Land, W /Buildings
2000
$
110,737
$
110,737
Land Parcel
1993
$
376,240
$
376,240
Building, Improvement
1995
$
48,922
$
48,922
Land, Gisler Field
1993
$
1,500,000
$
1,500,000
Land, Gisler ROW
2001
$
7,780
$
7,780
Land, W /House
2001
$
221,320
$
221,320
Land, W /Buildings
2001
$
363,278
$
363,278
Page 2 of 2
$ 31,406,446 $ 31,406,446
10/27/2003
Exhibit "N"
City of Moorpark
GASB -34 Valuations
Exhibit "0" - Rights -of -Way
Year 2002 and 2003
Notes: The acreage totals and value totals for FY ending 2003 are the same as
FY ending 2002, since no new Rights -of -Way were accepted in 2003.
O
O
O
O
Page 1 of 1
10/27/2003
Exhibit "O"
Total Area
Total Area
0riginal
Current Net
Year
Age
(SF)
(Acre)
Estimated Cost
Value
1985
18
6,073,281
139.42
$
3,812,787
$ 3,812,787
1986
17
4,151,419
95.30
$
3,649,376
$ 3,649,376
1987
16
3,926,627
90.14
$
4,738,539
$ 4,738,539
1988
15
9,963,405
228.73
$
16,182,110
$ 16,182,110
1989
14
3,585,459
82.31
$
7,683,774
$ 7,683,774
1990
13
1,411,041
32.39
$
3,911,756
$ 3,911,756
1991
12
813,095
18.67
$
2,858,745
$ 2,858,745
1992
11
595,667
13.67
$
2,603,991
$ 2,603,991
1993
10
715,580
16.43
$
3,813,257
$ 3,813,257
1994
9
764,643
17.55
$
4,869,649
$ 4,869,649
1995
8
436,292
10.02
$
3,255,501
$ 3,255,501
1996
7
923,141
21.19
$
7,912,428
$ 7,912,428
1997
6
1,318,372
30.27
$
12,725,677
$ 12,725,677
1998
5
1,096,353
25.17
$
11,684,069
$ 11,684,069
1999
4
503,202
11.55
$
5,804,796
$ 5,804,796
2000
3
385,707
8.85
$
4,721,748
$ 4,721,748
2001
2
332,370
7.63
$
4,233,182
$ 4,233,182
2002
1
1,432,170
32.88
$
18,605,445
$ 18,605,445
38,427,825
882.18
$
123,066,830
$ 123,066,830
Notes: The acreage totals and value totals for FY ending 2003 are the same as
FY ending 2002, since no new Rights -of -Way were accepted in 2003.
O
O
O
O
Page 1 of 1
10/27/2003
Exhibit "O"
EXHIBIT P
(City of Moorpark)
[Ili <16Wh_ff ��Al
To:
From: Cynthia L. Borchard, Administrative Services Director.
Re: Instructions for Capturing Acquisition and Cost Information for GASB, 34
Date:
Introduction
The Governmental Accounting Standards Board, is a nationally- recognized non - profit
organization which prescribes standards for accounting practices and financial
statements for states and local governments. In June9999, this board adopted
Statement 34 (GASB 34), which requires that these units of government disclose the Net
Book Value of capital assets, including Infrastructure Assets. The values of these assets
must be reported in annual financial statements. In our case, these statements are
included in the City's Comprehensive Annual Financial Report (CAFR).
GASB 34 Requirements and Maintenance Management
GASB 34 requires that the value of assets be reported using the Basic Approach. This
requires that we determine Net Book Value (current) by capturing the actual historical
cost of assets (of particular concern are Infrastructure Assets) and the acquisition date
(which may be date of construction completion or date placed into service) and then
applying a straight -line depreciation formula using an estimated useful life. GASB 34
allows agencies to use the "Modified Approach" where asset management systems are
being employed; however the City of Moorpark is utilizing the Basic Approach for all
Infrastructure Assets. It is critical that accurate cost and acquisition information be
collected and recorded for our Infrastructure Assets for the purpose of GASB 34
reporting and to keep our records system up to date for on -going maintenance
management.
111 1�
1
Infrastructure Assets
Cost and acquisition data is to be collected and reported for the following Assets:
Network
Subsystem
Roadways /Streets
Pavement (AC)
Curb & Gutter
Sidewalks
Traffic Signals
Traffic Regulatory Signs
Street Trees
Bridges
Parking Lots (Pavement)
Medians and Parkways
Storm Drainage System
Pipes
Parks & Recreation Facilities
Bike Path
Land
Land
Rights -of -Way
Instructions /Procedures for Capturing Future GASB 34 Information
The attached form (" GASB Infrastructure Inventory Valuation Form ") provides a format
with which to supply the necessary information. The following includes important
guidance on when /how to complete the form.
♦ These forms should be completed for Asset information by fiscal year beginning with
FY2002 -2003, and every fiscal year thereafter until further advised.
♦ The forms should be completed throughout the fiscal year as asset acquisitions
(such as new construction and replacement construction) occur, or when dispositions
occur (an asset is sold, demolished or removed). This task should not be left until
the end of the fiscal year
�, wp
♦ Information should be collected on City - initiated projects (CIP Projects and the like)
as well as developer -built and dedicated /donated infrastructure improvements,
whether it is parks, streets, signals, etc.
♦ Acquisition /improvement dates and costs are needed for physical improvements.
These kinds of projects (replacement, improvement and preservation costs) should
be distinguished from routine maintenance costs, which are not reported under
GASB 34. "Preservation" costs are cost outlays that extend the useful life of an
asset (assuming routine maintenance) beyond its original estimated useful life. Also,
if the capacity or efficiency of an asset has been increased by a cost outlay (such as
a road widening, adding weight capacity or a resurfacing), the costs associated with
such improvements should be reported. Based upon the list of infrastructure assets
itemized above, here are some examples of what cost outlays should /should not be
reported:
is r r r
Streets /Roadways:
1. Pavement: New streets, street overlays, pavement widening, adding
weight capacity or resurfacing through City CIP efforts. This will also
include improved streets dedicated by developers. Paving or
repaving of alleys is also to be included. Slurry, fog seal, and other
maintenance applications would not be reported.
2. Curb, gutter and sidewalk: Replacements of curb, gutter and
sidewalk are to be reported by deducting the depreciated value of the
old material and adding in the actual cost of the new material and
installation costs. New curb, gutter, sidewalk added by developer
dedications are to reported. Patching and cleaning are maintenance
activities and should not be reported.
3. Traffic Signals: New signals and signal modifications that add more
lights /turning movements, replace controller boxes, and those that
are a part of intersection widening and /or improvement should be
reported. Routine signal maintenance is not to be reported.
4. Traffic Signs: Replacements would be reported at current actual
replacement cost, along with deducting the depreciated value of any
;
a signs replaced due to age, damage or vandalism.
5. Bridges: New bridges or major improvement, rehabilitation, retrofit or
modification projects. Routine maintenance does not qualify for
reporting.
6. Street Trees: These are not depreciated, so no useful life is assigned
to trees. In filling out the form annually, the appropriate party should
estimate the number of trees that have been removed or replaced
each year along with any new trees planted. The asset modules will
perform the value calculation accordingly.
7. Parking Lots: The amount of any new parking lot improvements
(pavement) for parks or other City facilities are to be captured.
Further, any re- pavements /overlays for existing parking lots are to be
included.
Storm Drains:
1. Pipes: New pipes either installed /dedicated by developers or by the
City, as well as pipe replacement. Old pipe that has been replaced
should be given a depreciated value and reported along with the new
value of the replacement pipe. Patching and routine maintenance or
cleaning are routine maintenance activities and are not to be
reported.
2. Structures: These could include basins, catch basins, manholes,
culverts, inlet/outlet structures, concrete channels and the like.
Follow the guidelines for pipes.
000077
Parks and Recreation Facilities:
1. Improvements: General park facility improvements to be reported
would include irrigation system additions /replacements as well as turf,
fencing, bench, walkway, tree replacements. Replacements are to be
valued at current cost, and removals are to valued at depreciated
values. Special Facilities, such °as tennis, basketball and other special
courts, picnic structures, playground facilities and the like are to be
reported. Again, replacements or removals are to be reported at
depreciated values, with any replacement or remodeled facilities to be
reported at actual, current value.
2. Buildings: This includes any new habitable structures constructed on
park property as well as any additions, remodeling or rehab of existing
structures. For remodels and rehab, deduct the depreciated value of
what was replaced and add the actual, current cost of the new
installations. Routine maintenance such as painting, cleaning and
normal repair work are not to be reported.
Land: This includes raw land acquired or disposed of other than road /street
right of way. Any new land acquired is to be reported at purchase cost or fair
market value (if a developer dedication or donation). Any land disposed of by
sale or exchange is to be reported and valued at the actual or estimated fair
market value at the time it was originally acquired.
�y
Land within Rights -of -Way: This includes land acquired either by easement
=.' or in "fee simple" dedicated through developers or acquired by purchase by
the City. It should be recorded at the purchase cost. In the event a
developer dedicates this land, it should be recorded at the cost the developer
paid for it, or failing this information, at fair market value based upon the
value of abutting /nearby land.
o Please remember that the value of "projects in progress" should be reported to the
extent that they are complete. This information can be obtained by reviewing
Progress Payments to date for C1P projects.
e The most critical pieces of information are quantities, acquisition /disposition dates
and costs. Please complete these portions of the form in thorough fashion.
♦ Quantity information can be obtained from as -built drawings, bid documents and
other related sources. This information should be collected and reported on the form
as soon as built are received. Cost data can be obtained through unit costs (if
estimating), developer information, Council- accepted project totals, progress
payments, final invoices or other means.
® Administrative Services Department: The most convenient and acceptable way to
eliminate the value of assets that are demolished, removed or replaced is for the
appropriate department/division to identify the asset on the attached form and enter
the quantity (whether number of signs, linear feet of certain material, etc.)
removed /eliminated. Then go to the appropriate Asset Module and eliminate the
same amount(s) from the oldest dates /years. Basically, this will eliminate the oldest
0000178
assets, and the departments do not have to track which specific assets (with
corresponding age) were removed.
It is important that we capture all relevant information and report it. Failure to comply
with GASB 34 will result in the City receiving a "qualified" opinion from our independent
auditor, and it may have a negative affect our credit/bond rating.
Thank you for your cooperation.
CITY OF MOORPARK
GASB 34
INFRASTRUCTURE INVENTORY VALUATION FORM
Department: Division:
Prepared By: Phone /Extension:
Date Prepared:
Description of the Asset:
Date ❑Acquired ❑Constructed ❑Removed:
Basis of Valuation: (Please check one)
❑ Actual Cost (should include design, construction mgmt, fees, transportation, etc.)
❑ Estimated Cost
If Estimated Cost, describe the method used:
Quantity: (Example: 35,000 SF of concrete sidewalk)
Source Document / Information:
Total Valuation Amount: $