Spreadsheet: 09279f50-ca70-4529-a1b2-2d9bb8cc538b
Sheet: Overall CnB Analysis

Arcata Rail with Trail Connectivity Project - Summary of Cost Benefit Analysis |  |  |  |  |  |  |  |  |  |  |  | Arcata Rail with Trail Connectivity Project - Summary of Cost Benefit Analysis
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W
Twenty-Year Project  Span | Population Estimates | Gas Saved in gallons | Cost Savings from Avoided Gas | Cost Savings from Avoided Auto Ownership | Avoided Greenhouse Gas Emissions (CO2) | Value of CO2 Emission Reductions (3% Avg SCC) | Value of Emissions Reductions (VOC's, NOx, PM, Sox) | Community Health Benefits from [NAME] Only | Community Recreational Benefits | Value of Reduced Accidents both Fatalities and Injuries | Non-CO2 Benefits (2010$) (D,E,H,I,J,K) | Project Construction Cost  (2013$) | Maintenance and Operational Cost | 7% Discounted Direct Project Costs (Construction & O&M with Salvage) | 3% Discounted Direct Project Costs (Construction & O&M with Salvage) | Non-CO2 Undiscounted Net Benefits (L) | Project Year | 7% NPV Non-CO2 Benefits   [Q/1.07^R] | 3% NPV Non-CO2 Benefits   [Q/1.03^R] | NPV CO2 Costs @ 3% Avg SCC  [G/1.03^R] | 7% NPV Total Benefits [S+U] | 3% NPV Total Benefits [T+U]
2009/2011 | 17834 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1065000 |  |  |  | 0 | 0
2012/2013 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 535000 |  |  |  | 0 | 1
2014 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 6400000 |  |  |  | 0 | 2
2015 |  | 25599 | 99681 |  | 236.76 |  | 86184 | 681336 | 2399372 | 5041400 |  |  |  |  |  |  | 3
2016 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 4
2017 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 5
2018 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 6
2019 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 7
2020 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 8
2021 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 9
2122 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 10
2023 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 11
2024 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 12
2025 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 13
2026 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 14
2027 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 15
2028 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 16
2029 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 17
2030 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 18
2031 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 19
2032 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 20
2033 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 21
2034 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 22
2024 |  |  |  |  |  |  |  |  |  | 5041400 |  |  |  |  |  |  | 23
Totals
For details on Cost Benefit Analysis and Background Calculations see  http://www.cityofarcata.org/departments/public-works/parks/rail-with-trail |  |  |  |  |  |  |  |  |  |  |  | For details on Cost Benefit Analysis and Background Calculations see  http://www.cityofarcata.org/departments/public-works/parks/rail-with-trail
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Excluding CO2 SCC Adjustment |  |  | Including CO2 SCC Adjustment
B: Population estimates are based on 2010 Census with a 0.35% increase per year based on average from 2000-2010. |  |  |  |  |  |  |  |  |  |  |  | M: Projected Construction Cost (ith salvage vaalue for steel bridges).  Project costs breakdown is available at: |  |  |  |  |  | 7% Discount | 3% Discount | ARwT Project | 7% Discount | 3% Discount
C:  Gallons of gas is averaged at 20.3mpg using EPA MOBILE6.2 Fuel economy calculation. |  |  |  |  |  |  |  |  |  |  |  | http://www.cityofarcata.org/departments/public-works/parks/rail-with-trail |  |  |  |  | Net Benefits |  |  | Net Benefits
D: Gas is calculated at $3.90/gallon - current Humboldt County Price is $4.03/gallon. |  |  |  |  |  |  |  |  |  |  |  | N: Maintenance and Operational Costs are estimated based on current City of Arcata trail and transportation |  |  |  |  | Net Costs |  |  | Net Costs
E: Arcata households average 11,500 miles/auto with ownership costs of $5,640 annually; miles saved=20.4* gas gallons saved; [NAME] saved annually; ~$0.50/mile ownership cost |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NPV |  |  | NPV
F: (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 |  |  |  |  |  |  |  |  |  |  |  | maintenance and management averages |  |  |  |  | B/C |  |  | B/C
passenger vehicle (1.49 metric tons CE) |  |  |  |  |  |  |  |  |  |  |  | N: Non-CO2 undiscounted Net Benefits
[NAME] for reduced CO2 emissions are generated using the Recommended Monetized Values listed in the TIGER BCA Resource Guide |  |  |  |  |  |  |  |  |  |  |  | O: Project Costs Discounted at 7%
Page 6 -Social Cost of Carbon |  |  |  |  |  |  |  |  |  |  |  | P: Project Costs Discounted at 3%
H. Values provided for reduced emissions are generated using the Recommended Monetized Values listed in the TIGER BCA Resource Guide Page 5 |  |  |  |  |  |  |  |  |  |  |  | Q: Undiscounted benefits all non-CO2 project benefits
I: Annual Health Benefit is conservatively calculated as the number of new bicyclists x $128 (the median value per capita costs savings from physical Appendix E) |  |  |  |  |  |  |  |  |  |  |  | R: Project Year for Discounting
activity of 10 studies per NCHRP Report 552 |  |  |  |  |  |  |  |  |  |  |  | S: Benefits discounted at 7% over 20 years post construction for all non-CO2 project benefits
J: Annual Recreational/Commuter Benefit is conservatively calculated at the number of new cyclists (both recreational and commuter) x $10 per day of for commuter use. |  |  |  |  |  |  |  |  |  |  |  | T: Benefits discounted at3% over 20 years post construction for all non-CO2 project benefits
value x 365 days for recreational use and 260 days |  |  |  |  |  |  |  |  |  |  |  | U: Revised SCC Adjustment
K: Value of Statistical Life has been derived from the Treatment of the economic Value of a Statistical Life in Departmental Analyses |  |  |  |  |  |  |  |  |  |  |  | V: Project Benefit Value at 7% Discount
(2008 revised guidance and 2011 update) as  outlined on page 2 of the TIGER BCA Resource Guide |  |  |  |  |  |  |  |  |  |  |  | W: Project Benefit Value at 3% Discount
L: Sum of (D,E,G,H,I,J)