Spreadsheet: 34634178-85f9-406a-a696-d419205d4317
Sheet: Overall CnB Analysis

 | Arcata Rail with Trail Connectivity Project - Summary of Cost Benefit Analysis
 |  | 1 | 2 | 3 |  | 4 | 5 | 6 |  | 7 | 8 | 9 | 10
 | Twenty-Year Project  Span | Population Estimates | Gas Saved in gallons | Cost Savings from Avoided Gas | Safety Costs Avoided | Avoided Greenhouse Gas Emissions (CO2) | Community Health Benefits from [NAME] Only | Community Recreational Benefits | Community Economic Benefits | Project Construction Cost | Maintenance and Operational Cost | Undiscounted Net Benefits | Discounted at 7%
 | 2009/2011 | 17834 |  |  |  |  |  |  |  | 1065000 |  | -1065000
 | 2012 |  |  |  |  |  |  |  |  | 500000 |  | -500000
 | 2013 |  |  |  |  |  |  |  |  | 6854000 |  | -6854000
 | 2014 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2015 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2016 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2017 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2018 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2019 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2020 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2021 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2022 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2023 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2024 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2025 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2026 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2027 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2028 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2029 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2030 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2031 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2032 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | 2033 |  | 25599 | 99681 |  | 236.76 | 681336 | 19124996
 | Totals
 | For details on Cost Benefit Analysis and Background Calculations see  http://www.cityofarcata.org/departments/public-works/parks/rail-with-trail
 | 1: Population estimates are based on 2010 Census with a 0.35% increase per year based on average from 2000-2010.
 | 2:  Gallons of gas is averaged at 20.3mpg using EPA MOBILE6.2 Fuel economy calculation.
 | 3: Gas is calculated at $3.90/gallon - current Humboldt County Price is $4.03/gallon.
 | 4: (VMT/passenger vehicle avg. MPG) x CO2 per [NAME] (100/95) /1000 = (12,000/20.3) x 8.8 x (100/95)/1000 = 5.48 metric tons CO2e for the average passenger vehicle (1.49 metric tons CE)
 | 5. Annual Health Benefit is conservatively calculated as the number of new bicyclists x $128 (the median value per capita costs savings from physical activity of 10 studies per NCHRP Report 552 Appendix E)
 | 6. Annual Recreational/Commuter Benefit is conservatively calculated at the number of new cyclists (both recreational and commuter) x $10 per day of value x 365 days for recreational use and 260 days for commuter use.
 | 7: Projected Construction Cost.  Project costs breakdown is available at  http://www.cityofarcata.org/departments/public-works/parks/rail-with-trail
 | 8: Maintenance and Operational Costs are estimated based on current City of Arcata trail and transportation maintenance and management averages
 | 9: Undiscounted Net Benefits
 | 10: Net Benefits discounted at 7% over 20 years