Guidebook Download

The research team developed asset value calculation templates for bridges and for ancillary assets as a part of NCHRP Project 20-44(46). These tools supplement the written guidance within the new case studies and allow readers to use them as resources for doing their own asset valuation calculations.

An Excel spreadsheet for calculating bridge asset value using bridge inventory and condition data and parameters defined by the calculating agency. In addition to calculating replacement value, the template calculates remaining (or current) asset value using two approaches: composite rating and age-based. The template also yields costs to maintain value and asset consumption ratios for each of the three approaches.

• Download the Bridge Value Calculation Template.

An Excel spreadsheet for calculating ancillary asset value using inventory, age data, and parameters defined by the calculating agency. This template is intended to be used with assets with limited available data. In addition to calculating replacement value, the template calculates remaining (or current) asset value, cost to maintain value, and asset consumption ratio.

• Download the Ancillary Asset Calculation Template.

Note that Section 3.3 Establish the Asset Hierarchy discusses different considerations in establishing what asses classes to consider when performing the asset valuation calculation, and discusses different asset classes. The following additional resources discuss asset management strategies related to ancillary assets such as: signs, signals, guardrail, culverts, lighting, pavement markings, retaining walls, curb ramps, and noise walls.

• Allen, B.; Ram, P.; Koonce, J.; Raj, D.; Burns, S.; Zimmerman, K.; Smadi, O.; and Mugabe, K. Handbook for Including Ancillary Assets Transportation Asset Management Programs. FHWA, Report FHWA-HIF-19-068, 2019. Available at the following URL accessed September 17, 2025: https://www.fhwa.dot.gov/publications/research/infrastructure/19068/19068.pdf.
• FHWA. Transportation Asset Management Plans: Case Study 7 – Managing Assets Beyond Pavements and Bridges. FHWA, Report FHWA-HIF-20-092, 2020. Available at the following URL accessed September 17, 2025: https://www.fhwa.dot.gov/asset/pubs/hif20092.pdf.
• Spy Pond Partners, LLC; Applied Pavement Technology, Inc.; and WSP. AASHTO Transportation Asset Management Guide: A Focus on Implementation, Second Edition. AASHTO, 2020.
• Sturgill, R.; Harper, C.; Tran, D.; and Smadi, S. Management Practices for Ancillary Transportation Assets: A Synthesis of Highway Practice. NAS, NCHRP Synthesis 647, 2025. Available at the following URL accessed September 17, 2025: https://nap.nationalacademies.org/catalog/29059/management-practices-for-ancillary-transportation-assets.

This work was sponsored by the American Association of State Highway and Transportation Officials, in cooperation with the Federal Highway Administration, and was conducted in the National Cooperative Highway Research Program (NCHRP), which is administered by the Transportation Research Board of the National Academies of Sciences, Engineering, and Medicine.

This is an uncorrected draft as submitted by the research team.

This material is based upon work supported by the FHWA under Agreement No. 693JJ32350025. Any opinions, findings, and conclusions or recommendations expressed or implied in this document are those of the researchers who performed the research and are not necessarily those of the Transportation Research Board; the National Academies of Sciences, Engineering, and Medicine; the FHWA; or the program sponsors.

No warranty is made by the developers or their employer as to the accuracy, completeness, or reliability of this software and its associated equations and documentation. No responsibility is assumed by the developers for incorrect results or damages resulting from the use of this software.

This material and the copyrights therein are owned by the National Academies of Sciences, Engineering, and Medicine.