Model BCR
Calculation of Benefit Cost Ratio for the Appraisal Summary Table
Core Investment Programme | Road Accidents | Street Crime | Total 'Potential' Benefits | CIP Investment NPV | BCR For AST | ||||||||||
Average Night-time Accidents pa | Assumed Reduction from Lighting | 'Potential' Benefits per annum | NPV of Benefits over 25 yrs | 'Tangible' Loss per annum | Assumed Reduction from Lighting | 'Potential' Benefits per annum | NPV of Benefits over 25 years | ||||||||
A | B | C | D | E | F | G | H (F*G*A) | I | J (E+I) | K | L (J/K) | ||||
75% | 600 | 15% | £4,725,000.00 | £69,048,295 | £6,878,100 | 15% | £773,786 | £11,307,645 | £80,355,940 | £18,000,000 | 4.46 | ||||
Notes 1. Figures in columns A and K should be based on data from the OBC and should relate to lighting columns only (i.e. should exclude illuminated signs) 2. Potential Benefits from reduction in night-time accidents (column D) based on average cost of accident during hours of darkness (Source - DfT Economics Note ) - I.e. 3. NPV calculations (columns E and I) based on 25 years, 3.5% discount rate and assumes benefits accrue at 20%, 40%, 60%, and 80% during years 1 to 4 respectively 4. For calculation of 'Tangible Loss' from Street Crime (Column F) see Analysis of Crime Data in figure 2.2.3 |
| ||||||||||||||