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		6%
Costs and benefits of options
		Costs and benefits £
	Do Nothing	Maintain	FSA (Wetland 100 year)
PV costs PVc	0	81,867	1,822,393
PV damage PVd	5,648,696	138,660	13,434
PV damage avoided		5,510,036	5,635,262
PV assets Pva	0	0	0
PV asset protection benefits		0	0
Total PV benefits PVb		5,510,036	5,635,262
Net Present Value NPV		5,428,169	3,812,869
Average benefit/cost ratio		67.3	3.1
Incremental benefit/cost ratio			0.1
		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		5,648,696		138,660		13,434					Checked date
Discount rate			6%				PV benefits				5,510,036		5,635,262
		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,082,992	0	0	10,082,992	5,648,696	414,961	0	0	414,961	138,660	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
1	0.943	8,299			8,299	7,829	8,299			8,299	7,829	327			327	308
2	0.890	8,299			8,299	7,386	8,299			8,299	7,386	327			327	291
3	0.840	8,299			8,299	6,968	8,299			8,299	6,968	327			327	274
4	0.792	8,299			8,299	6,574	8,299			8,299	6,574	327			327	259
5	0.747	8,299			8,299	6,202	8,299			8,299	6,202	327			327	244
6	0.705	8,299			8,299	5,851	8,299			8,299	5,851	327			327	230
7	0.665	8,299			8,299	5,519	8,299			8,299	5,519	327			327	217
8	0.627	8,299			8,299	5,207	8,299			8,299	5,207	327			327	205
9	0.592	8,299			8,299	4,912	8,299			8,299	4,912	327			327	193
10	0.558	10,000,000			10,000,000	5,583,948	8,299			8,299	4,634	327			327	183
11	0.527				0	0	8,299			8,299	4,372	327			327	172
12	0.497				0	0	8,299			8,299	4,124	327			327	162
13	0.469				0	0	8,299			8,299	3,891	327			327	153
14	0.442				0	0	8,299			8,299	3,671	327			327	145
15	0.417				0	0	8,299			8,299	3,463	327			327	136
16	0.394				0	0	8,299			8,299	3,267	327			327	129
17	0.371				0	0	8,299			8,299	3,082	327			327	121
18	0.350				0	0	8,299			8,299	2,908	327			327	115
19	0.331				0	0	8,299			8,299	2,743	327			327	108
20	0.312				0	0	8,299			8,299	2,588	327			327	102
21	0.294				0	0	8,299			8,299	2,441	327			327	96
22	0.278				0	0	8,299			8,299	2,303	327			327	91
23	0.262				0	0	8,299			8,299	2,173	327			327	86
24	0.247				0	0	8,299			8,299	2,050	327			327	81
25	0.233				0	0	8,299			8,299	1,934	327			327	76
26	0.220				0	0	8,299			8,299	1,824	327			327	72
27	0.207				0	0	8,299			8,299	1,721	327			327	68
28	0.196				0	0	8,299			8,299	1,624	327			327	64
29	0.185				0	0	8,299			8,299	1,532	327			327	60
30	0.174				0	0	8,299			8,299	1,445	327			327	57
31	0.164				0	0	8,299			8,299	1,363	327			327	54
32	0.155				0	0	8,299			8,299	1,286	327			327	51
33	0.146				0	0	8,299			8,299	1,213	327			327	48
34	0.138				0	0	8,299			8,299	1,145	327			327	45
35	0.130				0	0	8,299			8,299	1,080	327			327	43
36	0.123				0	0	8,299			8,299	1,019	327			327	40
37	0.116				0	0	8,299			8,299	961	327			327	38
38	0.109				0	0	8,299			8,299	907	327			327	36
39	0.103				0	0	8,299			8,299	855	327			327	34
40	0.097				0	0	8,299			8,299	807	327			327	32
41	0.092				0	0	8,299			8,299	761	327			327	30
42	0.087				0	0	8,299			8,299	718	327			327	28
43	0.082				0	0	8,299			8,299	677	327			327	27
44	0.077				0	0	8,299			8,299	639	327			327	25
45	0.073				0	0	8,299			8,299	603	327			327	24
46	0.069				0	0	8,299			8,299	569	327			327	22
47	0.065				0	0	8,299			8,299	537	327			327	21
48	0.061				0	0	8,299			8,299	506	327			327	20
49	0.058				0	0	8,299			8,299	478	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 (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		81,867		1,822,393					Checked date
Discount rate			6%
		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	81,867	1,669,461	374,850	123,938	2,168,249	1,822,393
	Discount
year	Factor
0	1.000				0	0		4,900		4,900	4,900		4,900	123,938	128,838	128,838
1	0.943				0	0		4,900		4,900	4,623	1,669,461	7,550		1,677,011	1,582,086
2	0.890				0	0		4,900		4,900	4,361		7,550		7,550	6,719
3	0.840				0	0		4,900		4,900	4,114		7,550		7,550	6,339
4	0.792				0	0		4,900		4,900	3,881		7,550		7,550	5,980
5	0.747				0	0		4,900		4,900	3,662		7,550		7,550	5,642
6	0.705				0	0		4,900		4,900	3,454		7,550		7,550	5,322
7	0.665				0	0		4,900		4,900	3,259		7,550		7,550	5,021
8	0.627				0	0		4,900		4,900	3,074		7,550		7,550	4,737
9	0.592				0	0		4,900		4,900	2,900		7,550		7,550	4,469
10	0.558				0	0		4,900		4,900	2,736		7,550		7,550	4,216
11	0.527				0	0		4,900		4,900	2,581		7,550		7,550	3,977
12	0.497				0	0		4,900		4,900	2,435		7,550		7,550	3,752
13	0.469				0	0		4,900		4,900	2,297		7,550		7,550	3,540
14	0.442				0	0		4,900		4,900	2,167		7,550		7,550	3,339
15	0.417				0	0		4,900		4,900	2,045		7,550		7,550	3,150
16	0.394				0	0		4,900		4,900	1,929		7,550		7,550	2,972
17	0.371				0	0		4,900		4,900	1,820		7,550		7,550	2,804
18	0.350				0	0		4,900		4,900	1,717		7,550		7,550	2,645
19	0.331				0	0		4,900		4,900	1,620		7,550		7,550	2,495
20	0.312				0	0		4,900		4,900	1,528		7,550		7,550	2,354
21	0.294				0	0		4,900		4,900	1,441		7,550		7,550	2,221
22	0.278				0	0		4,900		4,900	1,360		7,550		7,550	2,095
23	0.262				0	0		4,900		4,900	1,283		7,550		7,550	1,977
24	0.247				0	0		4,900		4,900	1,210		7,550		7,550	1,865
25	0.233				0	0		4,900		4,900	1,142		7,550		7,550	1,759
26	0.220				0	0		4,900		4,900	1,077		7,550		7,550	1,660
27	0.207				0	0		4,900		4,900	1,016		7,550		7,550	1,566
28	0.196				0	0		4,900		4,900	959		7,550		7,550	1,477
29	0.185				0	0		4,900		4,900	904		7,550		7,550	1,393
30	0.174				0	0		4,900		4,900	853		7,550		7,550	1,315
31	0.164				0	0		4,900		4,900	805		7,550		7,550	1,240
32	0.155				0	0		4,900		4,900	759		7,550		7,550	1,170
33	0.146				0	0		4,900		4,900	716		7,550		7,550	1,104
34	0.138				0	0		4,900		4,900	676		7,550		7,550	1,041
35	0.130				0	0		4,900		4,900	638		7,550		7,550	982
36	0.123				0	0		4,900		4,900	601		7,550		7,550	927
37	0.116				0	0		4,900		4,900	567		7,550		7,550	874
38	0.109				0	0		4,900		4,900	535		7,550		7,550	825
39	0.103				0	0		4,900		4,900	505		7,550		7,550	778
40	0.097				0	0		4,900		4,900	476		7,550		7,550	734
41	0.092				0	0		4,900		4,900	449		7,550		7,550	692
42	0.087				0	0		4,900		4,900	424		7,550		7,550	653
43	0.082				0	0		4,900		4,900	400		7,550		7,550	616
44	0.077				0	0		4,900		4,900	377		7,550		7,550	581
45	0.073				0	0		4,900		4,900	356		7,550		7,550	549
46	0.069				0	0		4,900		4,900	336		7,550		7,550	517
47	0.065				0	0		4,900		4,900	317		7,550		7,550	488
48	0.061				0	0		4,900		4,900	299		7,550		7,550	461
49	0.058				0	0		4,900		4,900	282		7,550		7,550	434