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		3.5%
Costs and benefits of options
		Costs and benefits £
	Do Nothing	Maintain	FSA (50 year)	FSA (100 year)
PV costs PVc	0	118,955	647,373	745,082
PV damage PVd	7,232,062	402,953	43,275	31,816
PV damage avoided		6,829,109	7,188,787	7,200,247
PV assets Pva	0	0	0	0
PV asset protection benefits		0	0	0
Total PV benefits PVb		6,829,109	7,188,787	7,200,247
Net Present Value NPV		6,710,154	6,541,414	6,455,164
Average benefit/cost ratio		57.4	11.1	9.7
Incremental benefit/cost ratio			0.7	0.1
		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		7,232,062		402,953		43,275		31,816			Checked date
Discount rate			3.5%				PV benefits				6,829,109		7,188,787		7,200,247
		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,165,984	0	0	10,165,984	7,232,062	829,922	0	0	829,922	402,953	72,756	0	0	72,756	43,275	48,633	0	0	48,633	31,816
	Discount
year	Factor
0	1.000	16,598			16,598	16,598	16,598			16,598	16,598	16,598			16,598	16,598	16,598			16,598	16,598
1	0.966	16,598			16,598	16,037	16,598			16,598	16,037	1,146			1,146	1,107	654			654	632
2	0.934	16,598			16,598	15,495	16,598			16,598	15,495	1,146			1,146	1,070	654			654	610
3	0.902	16,598			16,598	14,971	16,598			16,598	14,971	1,146			1,146	1,034	654			654	590
4	0.871	16,598			16,598	14,465	16,598			16,598	14,465	1,146			1,146	999	654			654	570
5	0.842	16,598			16,598	13,975	16,598			16,598	13,975	1,146			1,146	965	654			654	550
6	0.814	16,598			16,598	13,503	16,598			16,598	13,503	1,146			1,146	932	654			654	532
7	0.786	16,598			16,598	13,046	16,598			16,598	13,046	1,146			1,146	901	654			654	514
8	0.759	16,598			16,598	12,605	16,598			16,598	12,605	1,146			1,146	870	654			654	496
9	0.734	16,598			16,598	12,179	16,598			16,598	12,179	1,146			1,146	841	654			654	480
10	0.709	10,000,000			10,000,000	7,089,188	16,598			16,598	11,767	1,146			1,146	812	654			654	463
11	0.685				0	0	16,598			16,598	11,369	1,146			1,146	785	654			654	448
12	0.662				0	0	16,598			16,598	10,985	1,146			1,146	758	654			654	433
13	0.639				0	0	16,598			16,598	10,613	1,146			1,146	733	654			654	418
14	0.618				0	0	16,598			16,598	10,254	1,146			1,146	708	654			654	404
15	0.597				0	0	16,598			16,598	9,907	1,146			1,146	684	654			654	390
16	0.577				0	0	16,598			16,598	9,572	1,146			1,146	661	654			654	377
17	0.557				0	0	16,598			16,598	9,249	1,146			1,146	639	654			654	364
18	0.538				0	0	16,598			16,598	8,936	1,146			1,146	617	654			654	352
19	0.520				0	0	16,598			16,598	8,634	1,146			1,146	596	654			654	340
20	0.503				0	0	16,598			16,598	8,342	1,146			1,146	576	654			654	329
21	0.486				0	0	16,598			16,598	8,060	1,146			1,146	557	654			654	317
22	0.469				0	0	16,598			16,598	7,787	1,146			1,146	538	654			654	307
23	0.453				0	0	16,598			16,598	7,524	1,146			1,146	520	654			654	296
24	0.438				0	0	16,598			16,598	7,269	1,146			1,146	502	654			654	286
25	0.423				0	0	16,598			16,598	7,024	1,146			1,146	485	654			654	277
26	0.409				0	0	16,598			16,598	6,786	1,146			1,146	469	654			654	267
27	0.395				0	0	16,598			16,598	6,557	1,146			1,146	453	654			654	258
28	0.382				0	0	16,598			16,598	6,335	1,146			1,146	437	654			654	250
29	0.369				0	0	16,598			16,598	6,121	1,146			1,146	423	654			654	241
30	0.356				0	0	16,598			16,598	5,914	1,146			1,146	408	654			654	233
31	0.344				0	0	16,598			16,598	5,714	1,146			1,146	395	654			654	225
32	0.333				0	0	16,598			16,598	5,520	1,146			1,146	381	654			654	217
33	0.321				0	0	16,598			16,598	5,334	1,146			1,146	368	654			654	210
34	0.310				0	0	16,598			16,598	5,153	1,146			1,146	356	654			654	203
35	0.300				0	0	16,598			16,598	4,979	1,146			1,146	344	654			654	196
36	0.290				0	0	16,598			16,598	4,811	1,146			1,146	332	654			654	189
37	0.280				0	0	16,598			16,598	4,648	1,146			1,146	321	654			654	183
38	0.271				0	0	16,598			16,598	4,491	1,146			1,146	310	654			654	177
39	0.261				0	0	16,598			16,598	4,339	1,146			1,146	300	654			654	171
40	0.253				0	0	16,598			16,598	4,192	1,146			1,146	289	654			654	165
41	0.244				0	0	16,598			16,598	4,051	1,146			1,146	280	654			654	160
42	0.236				0	0	16,598			16,598	3,914	1,146			1,146	270	654			654	154
43	0.228				0	0	16,598			16,598	3,781	1,146			1,146	261	654			654	149
44	0.220				0	0	16,598			16,598	3,653	1,146			1,146	252	654			654	144
45	0.213				0	0	16,598			16,598	3,530	1,146			1,146	244	654			654	139
46	0.205				0	0	16,598			16,598	3,410	1,146			1,146	235	654			654	134
47	0.199				0	0	16,598			16,598	3,295	1,146			1,146	228	654			654	130
48	0.192				0	0	16,598			16,598	3,184	1,146			1,146	220	654			654	125
49	0.185				0	0	16,598			16,598	3,076	1,146			1,146	212	654			654	121

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		118,955		647,373		745,082			Checked date
Discount rate			3.5%
		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	118,955	443,094	374,850	38,625	856,569	647,373	537,430	374,850	45,188	957,468	745,082
	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.966				0	0		4,900		4,900	4,734	443,094	7,550		450,644	435,405	537,430	7,550		544,980	526,551
2	0.934				0	0		4,900		4,900	4,574		7,550		7,550	7,048		7,550		7,550	7,048
3	0.902				0	0		4,900		4,900	4,420		7,550		7,550	6,810		7,550		7,550	6,810
4	0.871				0	0		4,900		4,900	4,270		7,550		7,550	6,579		7,550		7,550	6,579
5	0.842				0	0		4,900		4,900	4,126		7,550		7,550	6,357		7,550		7,550	6,357
6	0.814				0	0		4,900		4,900	3,986		7,550		7,550	6,142		7,550		7,550	6,142
7	0.786				0	0		4,900		4,900	3,851		7,550		7,550	5,934		7,550		7,550	5,934
8	0.759				0	0		4,900		4,900	3,721		7,550		7,550	5,734		7,550		7,550	5,734
9	0.734				0	0		4,900		4,900	3,595		7,550		7,550	5,540		7,550		7,550	5,540
10	0.709				0	0		4,900		4,900	3,474		7,550		7,550	5,352		7,550		7,550	5,352
11	0.685				0	0		4,900		4,900	3,356		7,550		7,550	5,171		7,550		7,550	5,171
12	0.662				0	0		4,900		4,900	3,243		7,550		7,550	4,996		7,550		7,550	4,996
13	0.639				0	0		4,900		4,900	3,133		7,550		7,550	4,828		7,550		7,550	4,828
14	0.618				0	0		4,900		4,900	3,027		7,550		7,550	4,664		7,550		7,550	4,664
15	0.597				0	0		4,900		4,900	2,925		7,550		7,550	4,507		7,550		7,550	4,507
16	0.577				0	0		4,900		4,900	2,826		7,550		7,550	4,354		7,550		7,550	4,354
17	0.557				0	0		4,900		4,900	2,730		7,550		7,550	4,207		7,550		7,550	4,207
18	0.538				0	0		4,900		4,900	2,638		7,550		7,550	4,065		7,550		7,550	4,065
19	0.520				0	0		4,900		4,900	2,549		7,550		7,550	3,927		7,550		7,550	3,927
20	0.503				0	0		4,900		4,900	2,463		7,550		7,550	3,794		7,550		7,550	3,794
21	0.486				0	0		4,900		4,900	2,379		7,550		7,550	3,666		7,550		7,550	3,666
22	0.469				0	0		4,900		4,900	2,299		7,550		7,550	3,542		7,550		7,550	3,542
23	0.453				0	0		4,900		4,900	2,221		7,550		7,550	3,422		7,550		7,550	3,422
24	0.438				0	0		4,900		4,900	2,146		7,550		7,550	3,307		7,550		7,550	3,307
25	0.423				0	0		4,900		4,900	2,073		7,550		7,550	3,195		7,550		7,550	3,195
26	0.409				0	0		4,900		4,900	2,003		7,550		7,550	3,087		7,550		7,550	3,087
27	0.395				0	0		4,900		4,900	1,936		7,550		7,550	2,982		7,550		7,550	2,982
28	0.382				0	0		4,900		4,900	1,870		7,550		7,550	2,881		7,550		7,550	2,881
29	0.369				0	0		4,900		4,900	1,807		7,550		7,550	2,784		7,550		7,550	2,784
30	0.356				0	0		4,900		4,900	1,746		7,550		7,550	2,690		7,550		7,550	2,690
31	0.344				0	0		4,900		4,900	1,687		7,550		7,550	2,599		7,550		7,550	2,599
32	0.333				0	0		4,900		4,900	1,630		7,550		7,550	2,511		7,550		7,550	2,511
33	0.321				0	0		4,900		4,900	1,575		7,550		7,550	2,426		7,550		7,550	2,426
34	0.310				0	0		4,900		4,900	1,521		7,550		7,550	2,344		7,550		7,550	2,344
35	0.300				0	0		4,900		4,900	1,470		7,550		7,550	2,265		7,550		7,550	2,265
36	0.290				0	0		4,900		4,900	1,420		7,550		7,550	2,188		7,550		7,550	2,188
37	0.280				0	0		4,900		4,900	1,372		7,550		7,550	2,114		7,550		7,550	2,114
38	0.271				0	0		4,900		4,900	1,326		7,550		7,550	2,043		7,550		7,550	2,043
39	0.261				0	0		4,900		4,900	1,281		7,550		7,550	1,974		7,550		7,550	1,974
40	0.253				0	0		4,900		4,900	1,238		7,550		7,550	1,907		7,550		7,550	1,907
41	0.244				0	0		4,900		4,900	1,196		7,550		7,550	1,842		7,550		7,550	1,842
42	0.236				0	0		4,900		4,900	1,155		7,550		7,550	1,780		7,550		7,550	1,780
43	0.228				0	0		4,900		4,900	1,116		7,550		7,550	1,720		7,550		7,550	1,720
44	0.220				0	0		4,900		4,900	1,079		7,550		7,550	1,662		7,550		7,550	1,662
45	0.213				0	0		4,900		4,900	1,042		7,550		7,550	1,606		7,550		7,550	1,606
46	0.205				0	0		4,900		4,900	1,007		7,550		7,550	1,551		7,550		7,550	1,551
47	0.199				0	0		4,900		4,900	973		7,550		7,550	1,499		7,550		7,550	1,499
48	0.192				0	0		4,900		4,900	940		7,550		7,550	1,448		7,550		7,550	1,448
49	0.185				0	0		4,900		4,900	908		7,550		7,550	1,399		7,550		7,550	1,399