Overview

Sheet 1: Summary

Flood Storage Area (Wetland) - 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 (Wetland 100 year)
PV costs PVc	0	118,955	1,917,582
PV damage PVd	7,232,062	402,953	31,816
PV damage avoided		6,829,109	7,200,247
PV assets Pva	0	0	0
PV asset protection benefits		0	0
Total PV benefits PVb		6,829,109	7,200,247
Net Present Value NPV		6,710,154	5,282,665
Average benefit/cost ratio		57.4	3.8
Incremental benefit/cost ratio			0.2
		Highest b/c	-
Brief description of options:
Do Nothing	Do nothing walk away
Maintain	Maintain existing regime
FSA (Wetland 100 year)	Storage Reservoir to 100 year standard of protection providing wetland



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 (Wetland 100 year)					Prepared by		MDG
Base date for estimates (year 0)			Oct-2002						Do Nothing		Maintain		FSA (Wetland 100 year)					Checked by
Scaling factor (e.g. £m, £k, £)			£				PV losses		7,232,062		402,953		31,816					Checked date
Discount rate			3.5%				PV benefits				6,829,109		7,200,247
		Do Nothing					Maintain					FSA (Wetland 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	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
1	0.966	16,598			16,598	16,037	16,598			16,598	16,037	654			654	632
2	0.934	16,598			16,598	15,495	16,598			16,598	15,495	654			654	610
3	0.902	16,598			16,598	14,971	16,598			16,598	14,971	654			654	590
4	0.871	16,598			16,598	14,465	16,598			16,598	14,465	654			654	570
5	0.842	16,598			16,598	13,975	16,598			16,598	13,975	654			654	550
6	0.814	16,598			16,598	13,503	16,598			16,598	13,503	654			654	532
7	0.786	16,598			16,598	13,046	16,598			16,598	13,046	654			654	514
8	0.759	16,598			16,598	12,605	16,598			16,598	12,605	654			654	496
9	0.734	16,598			16,598	12,179	16,598			16,598	12,179	654			654	480
10	0.709	10,000,000			10,000,000	7,089,188	16,598			16,598	11,767	654			654	463
11	0.685				0	0	16,598			16,598	11,369	654			654	448
12	0.662				0	0	16,598			16,598	10,985	654			654	433
13	0.639				0	0	16,598			16,598	10,613	654			654	418
14	0.618				0	0	16,598			16,598	10,254	654			654	404
15	0.597				0	0	16,598			16,598	9,907	654			654	390
16	0.577				0	0	16,598			16,598	9,572	654			654	377
17	0.557				0	0	16,598			16,598	9,249	654			654	364
18	0.538				0	0	16,598			16,598	8,936	654			654	352
19	0.520				0	0	16,598			16,598	8,634	654			654	340
20	0.503				0	0	16,598			16,598	8,342	654			654	329
21	0.486				0	0	16,598			16,598	8,060	654			654	317
22	0.469				0	0	16,598			16,598	7,787	654			654	307
23	0.453				0	0	16,598			16,598	7,524	654			654	296
24	0.438				0	0	16,598			16,598	7,269	654			654	286
25	0.423				0	0	16,598			16,598	7,024	654			654	277
26	0.409				0	0	16,598			16,598	6,786	654			654	267
27	0.395				0	0	16,598			16,598	6,557	654			654	258
28	0.382				0	0	16,598			16,598	6,335	654			654	250
29	0.369				0	0	16,598			16,598	6,121	654			654	241
30	0.356				0	0	16,598			16,598	5,914	654			654	233
31	0.344				0	0	16,598			16,598	5,714	654			654	225
32	0.333				0	0	16,598			16,598	5,520	654			654	217
33	0.321				0	0	16,598			16,598	5,334	654			654	210
34	0.310				0	0	16,598			16,598	5,153	654			654	203
35	0.300				0	0	16,598			16,598	4,979	654			654	196
36	0.290				0	0	16,598			16,598	4,811	654			654	189
37	0.280				0	0	16,598			16,598	4,648	654			654	183
38	0.271				0	0	16,598			16,598	4,491	654			654	177
39	0.261				0	0	16,598			16,598	4,339	654			654	171
40	0.253				0	0	16,598			16,598	4,192	654			654	165
41	0.244				0	0	16,598			16,598	4,051	654			654	160
42	0.236				0	0	16,598			16,598	3,914	654			654	154
43	0.228				0	0	16,598			16,598	3,781	654			654	149
44	0.220				0	0	16,598			16,598	3,653	654			654	144
45	0.213				0	0	16,598			16,598	3,530	654			654	139
46	0.205				0	0	16,598			16,598	3,410	654			654	134
47	0.199				0	0	16,598			16,598	3,295	654			654	130
48	0.192				0	0	16,598			16,598	3,184	654			654	125
49	0.185				0	0	16,598			16,598	3,076	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 (Wetland 100 year)					Prepared by		MDG
Base date for estimates (year 0)			Oct-2002						Do Nothing		Maintain		FSA (Wetland 100 year)					Checked by
Scaling factor (e.g. £m, £k, £)			£				PV total costs		0		118,955		1,917,582					Checked date
Discount rate			3.5%
		Do Nothing			TOTALS:		Maintain			TOTALS:		FSA (Wetland 100 year)			TOTALS:					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	1,669,461	374,850	123,938	2,168,249	1,917,582
	Discount
year	Factor
0	1.000				0	0		4,900		4,900	4,900		4,900	123,938	128,838	128,838
1	0.966				0	0		4,900		4,900	4,734	1,669,461	7,550		1,677,011	1,620,300
2	0.934				0	0		4,900		4,900	4,574		7,550		7,550	7,048
3	0.902				0	0		4,900		4,900	4,420		7,550		7,550	6,810
4	0.871				0	0		4,900		4,900	4,270		7,550		7,550	6,579
5	0.842				0	0		4,900		4,900	4,126		7,550		7,550	6,357
6	0.814				0	0		4,900		4,900	3,986		7,550		7,550	6,142
7	0.786				0	0		4,900		4,900	3,851		7,550		7,550	5,934
8	0.759				0	0		4,900		4,900	3,721		7,550		7,550	5,734
9	0.734				0	0		4,900		4,900	3,595		7,550		7,550	5,540
10	0.709				0	0		4,900		4,900	3,474		7,550		7,550	5,352
11	0.685				0	0		4,900		4,900	3,356		7,550		7,550	5,171
12	0.662				0	0		4,900		4,900	3,243		7,550		7,550	4,996
13	0.639				0	0		4,900		4,900	3,133		7,550		7,550	4,828
14	0.618				0	0		4,900		4,900	3,027		7,550		7,550	4,664
15	0.597				0	0		4,900		4,900	2,925		7,550		7,550	4,507
16	0.577				0	0		4,900		4,900	2,826		7,550		7,550	4,354
17	0.557				0	0		4,900		4,900	2,730		7,550		7,550	4,207
18	0.538				0	0		4,900		4,900	2,638		7,550		7,550	4,065
19	0.520				0	0		4,900		4,900	2,549		7,550		7,550	3,927
20	0.503				0	0		4,900		4,900	2,463		7,550		7,550	3,794
21	0.486				0	0		4,900		4,900	2,379		7,550		7,550	3,666
22	0.469				0	0		4,900		4,900	2,299		7,550		7,550	3,542
23	0.453				0	0		4,900		4,900	2,221		7,550		7,550	3,422
24	0.438				0	0		4,900		4,900	2,146		7,550		7,550	3,307
25	0.423				0	0		4,900		4,900	2,073		7,550		7,550	3,195
26	0.409				0	0		4,900		4,900	2,003		7,550		7,550	3,087
27	0.395				0	0		4,900		4,900	1,936		7,550		7,550	2,982
28	0.382				0	0		4,900		4,900	1,870		7,550		7,550	2,881
29	0.369				0	0		4,900		4,900	1,807		7,550		7,550	2,784
30	0.356				0	0		4,900		4,900	1,746		7,550		7,550	2,690
31	0.344				0	0		4,900		4,900	1,687		7,550		7,550	2,599
32	0.333				0	0		4,900		4,900	1,630		7,550		7,550	2,511
33	0.321				0	0		4,900		4,900	1,575		7,550		7,550	2,426
34	0.310				0	0		4,900		4,900	1,521		7,550		7,550	2,344
35	0.300				0	0		4,900		4,900	1,470		7,550		7,550	2,265
36	0.290				0	0		4,900		4,900	1,420		7,550		7,550	2,188
37	0.280				0	0		4,900		4,900	1,372		7,550		7,550	2,114
38	0.271				0	0		4,900		4,900	1,326		7,550		7,550	2,043
39	0.261				0	0		4,900		4,900	1,281		7,550		7,550	1,974
40	0.253				0	0		4,900		4,900	1,238		7,550		7,550	1,907
41	0.244				0	0		4,900		4,900	1,196		7,550		7,550	1,842
42	0.236				0	0		4,900		4,900	1,155		7,550		7,550	1,780
43	0.228				0	0		4,900		4,900	1,116		7,550		7,550	1,720
44	0.220				0	0		4,900		4,900	1,079		7,550		7,550	1,662
45	0.213				0	0		4,900		4,900	1,042		7,550		7,550	1,606
46	0.205				0	0		4,900		4,900	1,007		7,550		7,550	1,551
47	0.199				0	0		4,900		4,900	973		7,550		7,550	1,499
48	0.192				0	0		4,900		4,900	940		7,550		7,550	1,448
49	0.185				0	0		4,900		4,900	908		7,550		7,550	1,399