Overview

Sheet 1: Summary

Flood Storage Area (Flood Defence) - Project Summary Sheet
Client/Authority				Prepared (date)	10/28/02
Environment Agency				Printed	03/03/03
Project name				Prepared by	MDG
Bin Brook Pre-feasibility Study				Checked by
Project reference		WNCBIN		Checked date
Base date for estimates (year 0)		Oct-2002
Scaling factor (e.g. £m, £k, £)		£	(used for all costs, losses and benefits)
Principle land use band		A	(A to E)
Discount rate		6%
Costs and benefits of options
		Costs and benefits £
	Do Nothing	Maintain	FSA (50 year)	FSA (100 year)
PV costs PVc	0	81,867	580,130	675,690
PV damage PVd	5,648,696	138,660	17,300	13,434
PV damage avoided		5,510,036	5,631,395	5,635,262
PV assets Pva	0	0	0	0
PV asset protection benefits		0	0	0
Total PV benefits PVb		5,510,036	5,631,395	5,635,262
Net Present Value NPV		5,428,169	5,051,265	4,959,572
Average benefit/cost ratio		67.3	9.7	8.3
Incremental benefit/cost ratio			0.2	0.04
		Highest b/c	-	-
Brief description of options:
Do Nothing	Do nothing walk away
Maintain	Maintain existing regime
FSA (50 year)	Storage Reservoir to 50 year standard of protection (Flood Defence Only)
FSA (100 year)	Storage Reservoir to 100 year standard of protection (Flood Defence Only)


Notes:
1) Benefits will normally be expressed either in terms of damage avoided or asset values protected. Care is needed to avoid double counting
2) PV damage avoided is calculated as PV damage (No Project) - PV damage (Option)
PV asset protection benefits are calculated as PVa (Option) - PVa (No Project)
PV benefits calculated as PV damage avoided + PV asset protection benefits
3) Incremental benefit/cost ratio is calculated as:
(PVb(current option) - PVb(previous option))/(PVc(current option) - PVc(previous option))

Sheet 2: PVlosses

									Present Value Losses and Benefits
Client/Authority
Environment Agency
Project name									Results £									Prepared (date)		10/28/02
Bin Brook Pre-feasibility Study																		Printed		03/03/03
Project reference			WNCBIN						Do Nothing		Maintain		FSA (50 year)		FSA (100 year)			Prepared by		MDG
Base date for estimates (year 0)			Oct-2002						Do Nothing		Maintain		FSA (50 year)		FSA (100 year)			Checked by
Scaling factor (e.g. £m, £k, £)			£				PV losses		5,648,696		138,660		17,300		13,434			Checked date
Discount rate			6%				PV benefits				5,510,036		5,631,395		5,635,262
		Do Nothing					Maintain					FSA (50 year)					FSA (100 year)
		loss	loss	loss	TOTALS	PV	loss	loss	loss	TOTALS	PV	loss	loss	loss	TOTALS	PV	loss	loss	loss	TOTALS	PV
	cash sum	10,082,992	0	0	10,082,992	5,648,696	414,961	0	0	414,961	138,660	36,378	0	0	36,378	17,300	24,316	0	0	24,316	13,434
	Discount
year	Factor
0	1.000	8,299			8,299	8,299	8,299			8,299	8,299	8,299			8,299	8,299	8,299			8,299	8,299
1	0.943	8,299			8,299	7,829	8,299			8,299	7,829	573			573	541	327			327	308
2	0.890	8,299			8,299	7,386	8,299			8,299	7,386	573			573	510	327			327	291
3	0.840	8,299			8,299	6,968	8,299			8,299	6,968	573			573	481	327			327	274
4	0.792	8,299			8,299	6,574	8,299			8,299	6,574	573			573	454	327			327	259
5	0.747	8,299			8,299	6,202	8,299			8,299	6,202	573			573	428	327			327	244
6	0.705	8,299			8,299	5,851	8,299			8,299	5,851	573			573	404	327			327	230
7	0.665	8,299			8,299	5,519	8,299			8,299	5,519	573			573	381	327			327	217
8	0.627	8,299			8,299	5,207	8,299			8,299	5,207	573			573	360	327			327	205
9	0.592	8,299			8,299	4,912	8,299			8,299	4,912	573			573	339	327			327	193
10	0.558	10,000,000			10,000,000	5,583,948	8,299			8,299	4,634	573			573	320	327			327	183
11	0.527				0	0	8,299			8,299	4,372	573			573	302	327			327	172
12	0.497				0	0	8,299			8,299	4,124	573			573	285	327			327	162
13	0.469				0	0	8,299			8,299	3,891	573			573	269	327			327	153
14	0.442				0	0	8,299			8,299	3,671	573			573	253	327			327	145
15	0.417				0	0	8,299			8,299	3,463	573			573	239	327			327	136
16	0.394				0	0	8,299			8,299	3,267	573			573	226	327			327	129
17	0.371				0	0	8,299			8,299	3,082	573			573	213	327			327	121
18	0.350				0	0	8,299			8,299	2,908	573			573	201	327			327	115
19	0.331				0	0	8,299			8,299	2,743	573			573	189	327			327	108
20	0.312				0	0	8,299			8,299	2,588	573			573	179	327			327	102
21	0.294				0	0	8,299			8,299	2,441	573			573	169	327			327	96
22	0.278				0	0	8,299			8,299	2,303	573			573	159	327			327	91
23	0.262				0	0	8,299			8,299	2,173	573			573	150	327			327	86
24	0.247				0	0	8,299			8,299	2,050	573			573	142	327			327	81
25	0.233				0	0	8,299			8,299	1,934	573			573	134	327			327	76
26	0.220				0	0	8,299			8,299	1,824	573			573	126	327			327	72
27	0.207				0	0	8,299			8,299	1,721	573			573	119	327			327	68
28	0.196				0	0	8,299			8,299	1,624	573			573	112	327			327	64
29	0.185				0	0	8,299			8,299	1,532	573			573	106	327			327	60
30	0.174				0	0	8,299			8,299	1,445	573			573	100	327			327	57
31	0.164				0	0	8,299			8,299	1,363	573			573	94	327			327	54
32	0.155				0	0	8,299			8,299	1,286	573			573	89	327			327	51
33	0.146				0	0	8,299			8,299	1,213	573			573	84	327			327	48
34	0.138				0	0	8,299			8,299	1,145	573			573	79	327			327	45
35	0.130				0	0	8,299			8,299	1,080	573			573	75	327			327	43
36	0.123				0	0	8,299			8,299	1,019	573			573	70	327			327	40
37	0.116				0	0	8,299			8,299	961	573			573	66	327			327	38
38	0.109				0	0	8,299			8,299	907	573			573	63	327			327	36
39	0.103				0	0	8,299			8,299	855	573			573	59	327			327	34
40	0.097				0	0	8,299			8,299	807	573			573	56	327			327	32
41	0.092				0	0	8,299			8,299	761	573			573	53	327			327	30
42	0.087				0	0	8,299			8,299	718	573			573	50	327			327	28
43	0.082				0	0	8,299			8,299	677	573			573	47	327			327	27
44	0.077				0	0	8,299			8,299	639	573			573	44	327			327	25
45	0.073				0	0	8,299			8,299	603	573			573	42	327			327	24
46	0.069				0	0	8,299			8,299	569	573			573	39	327			327	22
47	0.065				0	0	8,299			8,299	537	573			573	37	327			327	21
48	0.061				0	0	8,299			8,299	506	573			573	35	327			327	20
49	0.058				0	0	8,299			8,299	478	573			573	33	327			327	19

Sheet 3: PVCosts

									Present Value Costs for all options
Client/Authority
Environment Agency
Project name									Results £									Prepared (date)		10/28/02
Bin Brook Pre-feasibility Study																		Printed		03/03/03
Project reference			WNCBIN						Do Nothing		Maintain		FSA (50 year)		FSA (100 year)			Prepared by		MDG
Base date for estimates (year 0)			Oct-2002						Do Nothing		Maintain		FSA (50 year)		FSA (100 year)			Checked by
Scaling factor (e.g. £m, £k, £)			£				PV total costs		0		81,867		580,130		675,690			Checked date
Discount rate			6%
		Do Nothing			TOTALS:		Maintain			TOTALS:		FSA (50 year)			TOTALS:		FSA (100 year)			TOTALS:
		Capital	Maint.	Other	Cash	PV	Capital	Maint.	Other	Cash	PV	Capital	Maint.	Other	Cash	PV	Capital	Maint.	Other	Cash	PV
	cash sum	0	0	0	0	0	0	245,000	0	245,000	81,867	443,094	374,850	38,625	856,569	580,130	537,430	374,850	45,188	957468.00	675689.60
	Discount
year	Factor
0	1.000				0	0		4,900		4,900	4,900		4,900	38,625	43,525	43,525		4,900	45,188	50,088	50,088
1	0.943				0	0		4,900		4,900	4,623	443,094	7,550		450,644	425,136	537,430	7,550		544,980	514,132
2	0.890				0	0		4,900		4,900	4,361		7,550		7,550	6,719		7,550		7,550	6,719
3	0.840				0	0		4,900		4,900	4,114		7,550		7,550	6,339		7,550		7,550	6,339
4	0.792				0	0		4,900		4,900	3,881		7,550		7,550	5,980		7,550		7,550	5,980
5	0.747				0	0		4,900		4,900	3,662		7,550		7,550	5,642		7,550		7,550	5,642
6	0.705				0	0		4,900		4,900	3,454		7,550		7,550	5,322		7,550		7,550	5,322
7	0.665				0	0		4,900		4,900	3,259		7,550		7,550	5,021		7,550		7,550	5,021
8	0.627				0	0		4,900		4,900	3,074		7,550		7,550	4,737		7,550		7,550	4,737
9	0.592				0	0		4,900		4,900	2,900		7,550		7,550	4,469		7,550		7,550	4,469
10	0.558				0	0		4,900		4,900	2,736		7,550		7,550	4,216		7,550		7,550	4,216
11	0.527				0	0		4,900		4,900	2,581		7,550		7,550	3,977		7,550		7,550	3,977
12	0.497				0	0		4,900		4,900	2,435		7,550		7,550	3,752		7,550		7,550	3,752
13	0.469				0	0		4,900		4,900	2,297		7,550		7,550	3,540		7,550		7,550	3,540
14	0.442				0	0		4,900		4,900	2,167		7,550		7,550	3,339		7,550		7,550	3,339
15	0.417				0	0		4,900		4,900	2,045		7,550		7,550	3,150		7,550		7,550	3,150
16	0.394				0	0		4,900		4,900	1,929		7,550		7,550	2,972		7,550		7,550	2,972
17	0.371				0	0		4,900		4,900	1,820		7,550		7,550	2,804		7,550		7,550	2,804
18	0.350				0	0		4,900		4,900	1,717		7,550		7,550	2,645		7,550		7,550	2,645
19	0.331				0	0		4,900		4,900	1,620		7,550		7,550	2,495		7,550		7,550	2,495
20	0.312				0	0		4,900		4,900	1,528		7,550		7,550	2,354		7,550		7,550	2,354
21	0.294				0	0		4,900		4,900	1,441		7,550		7,550	2,221		7,550		7,550	2,221
22	0.278				0	0		4,900		4,900	1,360		7,550		7,550	2,095		7,550		7,550	2,095
23	0.262				0	0		4,900		4,900	1,283		7,550		7,550	1,977		7,550		7,550	1,977
24	0.247				0	0		4,900		4,900	1,210		7,550		7,550	1,865		7,550		7,550	1,865
25	0.233				0	0		4,900		4,900	1,142		7,550		7,550	1,759		7,550		7,550	1,759
26	0.220				0	0		4,900		4,900	1,077		7,550		7,550	1,660		7,550		7,550	1,660
27	0.207				0	0		4,900		4,900	1,016		7,550		7,550	1,566		7,550		7,550	1,566
28	0.196				0	0		4,900		4,900	959		7,550		7,550	1,477		7,550		7,550	1,477
29	0.185				0	0		4,900		4,900	904		7,550		7,550	1,393		7,550		7,550	1,393
30	0.174				0	0		4,900		4,900	853		7,550		7,550	1,315		7,550		7,550	1,315
31	0.164				0	0		4,900		4,900	805		7,550		7,550	1,240		7,550		7,550	1,240
32	0.155				0	0		4,900		4,900	759		7,550		7,550	1,170		7,550		7,550	1,170
33	0.146				0	0		4,900		4,900	716		7,550		7,550	1,104		7,550		7,550	1,104
34	0.138				0	0		4,900		4,900	676		7,550		7,550	1,041		7,550		7,550	1,041
35	0.130				0	0		4,900		4,900	638		7,550		7,550	982		7,550		7,550	982
36	0.123				0	0		4,900		4,900	601		7,550		7,550	927		7,550		7,550	927
37	0.116				0	0		4,900		4,900	567		7,550		7,550	874		7,550		7,550	874
38	0.109				0	0		4,900		4,900	535		7,550		7,550	825		7,550		7,550	825
39	0.103				0	0		4,900		4,900	505		7,550		7,550	778		7,550		7,550	778
40	0.097				0	0		4,900		4,900	476		7,550		7,550	734		7,550		7,550	734
41	0.092				0	0		4,900		4,900	449		7,550		7,550	692		7,550		7,550	692
42	0.087				0	0		4,900		4,900	424		7,550		7,550	653		7,550		7,550	653
43	0.082				0	0		4,900		4,900	400		7,550		7,550	616		7,550		7,550	616
44	0.077				0	0		4,900		4,900	377		7,550		7,550	581		7,550		7,550	581
45	0.073				0	0		4,900		4,900	356		7,550		7,550	549		7,550		7,550	549
46	0.069				0	0		4,900		4,900	336		7,550		7,550	517		7,550		7,550	517
47	0.065				0	0		4,900		4,900	317		7,550		7,550	488		7,550		7,550	488
48	0.061				0	0		4,900		4,900	299		7,550		7,550	461		7,550		7,550	461
49	0.058				0	0		4,900		4,900	282		7,550		7,550	434		7,550		7,550	434