Overview

Sheet 1: Summary

Channel Enlargement - 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	Channel Enlargement (50 year)
PV costs PVc	0	118,955	572,422
PV damage PVd	7,232,062	402,942	104,896
PV damage avoided		6,829,120	7,127,166
PV assets Pva	0	0	0
PV asset protection benefits		0	0
Total PV benefits PVb		6,829,120	7,127,166
Net Present Value NPV		6,710,165	6,554,744
Average benefit/cost ratio		57.4	12.5
Incremental benefit/cost ratio			0.7
		Highest b/c	-
Brief description of options:
Do Nothing	Do nothing walk away
Maintain	Maintain existing regime
Channel Enlargement (50 year)	Enlarge Channel to provide 50 year standard of protection



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		Channel Enlargement (50 year)					Prepared by		MDG
Base date for estimates (year 0)			Oct-2002						Do Nothing		Maintain		Channel Enlargement (50 year)					Checked by
Scaling factor (e.g. £m, £k, £)			£				PV losses		7,232,062		402,942		104,896					Checked date
Discount rate			3.5%				PV benefits				6,829,120		7,127,166
		Do Nothing					Maintain					Channel Enlargement (50 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,900	0	0	829,900	402,942	202,476	0	0	202,476	104,896
	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	3,793			3,793	3,665
2	0.934	16,598			16,598	15,495	16,598			16,598	15,494	3,793			3,793	3,541
3	0.902	16,598			16,598	14,971	16,598			16,598	14,970	3,793			3,793	3,421
4	0.871	16,598			16,598	14,465	16,598			16,598	14,464	3,793			3,793	3,306
5	0.842	16,598			16,598	13,975	16,598			16,598	13,975	3,793			3,793	3,194
6	0.814	16,598			16,598	13,503	16,598			16,598	13,502	3,793			3,793	3,086
7	0.786	16,598			16,598	13,046	16,598			16,598	13,046	3,793			3,793	2,982
8	0.759	16,598			16,598	12,605	16,598			16,598	12,605	3,793			3,793	2,881
9	0.734	16,598			16,598	12,179	16,598			16,598	12,178	3,793			3,793	2,783
10	0.709	10,000,000			10,000,000	7,089,188	16,598			16,598	11,767	3,793			3,793	2,689
11	0.685				0	0	16,598			16,598	11,369	3,793			3,793	2,598
12	0.662				0	0	16,598			16,598	10,984	3,793			3,793	2,510
13	0.639				0	0	16,598			16,598	10,613	3,793			3,793	2,426
14	0.618				0	0	16,598			16,598	10,254	3,793			3,793	2,344
15	0.597				0	0	16,598			16,598	9,907	3,793			3,793	2,264
16	0.577				0	0	16,598			16,598	9,572	3,793			3,793	2,188
17	0.557				0	0	16,598			16,598	9,248	3,793			3,793	2,114
18	0.538				0	0	16,598			16,598	8,936	3,793			3,793	2,042
19	0.520				0	0	16,598			16,598	8,634	3,793			3,793	1,973
20	0.503				0	0	16,598			16,598	8,342	3,793			3,793	1,906
21	0.486				0	0	16,598			16,598	8,060	3,793			3,793	1,842
22	0.469				0	0	16,598			16,598	7,787	3,793			3,793	1,780
23	0.453				0	0	16,598			16,598	7,524	3,793			3,793	1,720
24	0.438				0	0	16,598			16,598	7,269	3,793			3,793	1,661
25	0.423				0	0	16,598			16,598	7,023	3,793			3,793	1,605
26	0.409				0	0	16,598			16,598	6,786	3,793			3,793	1,551
27	0.395				0	0	16,598			16,598	6,556	3,793			3,793	1,498
28	0.382				0	0	16,598			16,598	6,335	3,793			3,793	1,448
29	0.369				0	0	16,598			16,598	6,120	3,793			3,793	1,399
30	0.356				0	0	16,598			16,598	5,914	3,793			3,793	1,352
31	0.344				0	0	16,598			16,598	5,714	3,793			3,793	1,306
32	0.333				0	0	16,598			16,598	5,520	3,793			3,793	1,262
33	0.321				0	0	16,598			16,598	5,334	3,793			3,793	1,219
34	0.310				0	0	16,598			16,598	5,153	3,793			3,793	1,178
35	0.300				0	0	16,598			16,598	4,979	3,793			3,793	1,138
36	0.290				0	0	16,598			16,598	4,811	3,793			3,793	1,099
37	0.280				0	0	16,598			16,598	4,648	3,793			3,793	1,062
38	0.271				0	0	16,598			16,598	4,491	3,793			3,793	1,026
39	0.261				0	0	16,598			16,598	4,339	3,793			3,793	992
40	0.253				0	0	16,598			16,598	4,192	3,793			3,793	958
41	0.244				0	0	16,598			16,598	4,050	3,793			3,793	926
42	0.236				0	0	16,598			16,598	3,913	3,793			3,793	894
43	0.228				0	0	16,598			16,598	3,781	3,793			3,793	864
44	0.220				0	0	16,598			16,598	3,653	3,793			3,793	835
45	0.213				0	0	16,598			16,598	3,530	3,793			3,793	807
46	0.205				0	0	16,598			16,598	3,410	3,793			3,793	779
47	0.199				0	0	16,598			16,598	3,295	3,793			3,793	753
48	0.192				0	0	16,598			16,598	3,184	3,793			3,793	728
49	0.185				0	0	16,598			16,598	3,076	3,793			3,793	703

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		Channel Enlargement (50 year)					Prepared by		MDG
Base date for estimates (year 0)			Oct-2002						Do Nothing		Maintain		Channel Enlargement (50 year)					Checked by
Scaling factor (e.g. £m, £k, £)			£				PV total costs		0		118,955		572,422					Checked date
Discount rate			3.5%
		Do Nothing			TOTALS:		Maintain			TOTALS:		Channel Enlargement (50 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	436,859	245,000	31,381	713,240	572,422
	Discount
year	Factor
0	1.000				0	0		4,900		4,900	4,900		4,900	31,381	36,281	36,281
1	0.966				0	0		4,900		4,900	4,734	436,859	4,900		441,759	426,820
2	0.934				0	0		4,900		4,900	4,574		4,900		4,900	4,574
3	0.902				0	0		4,900		4,900	4,420		4,900		4,900	4,420
4	0.871				0	0		4,900		4,900	4,270		4,900		4,900	4,270
5	0.842				0	0		4,900		4,900	4,126		4,900		4,900	4,126
6	0.814				0	0		4,900		4,900	3,986		4,900		4,900	3,986
7	0.786				0	0		4,900		4,900	3,851		4,900		4,900	3,851
8	0.759				0	0		4,900		4,900	3,721		4,900		4,900	3,721
9	0.734				0	0		4,900		4,900	3,595		4,900		4,900	3,595
10	0.709				0	0		4,900		4,900	3,474		4,900		4,900	3,474
11	0.685				0	0		4,900		4,900	3,356		4,900		4,900	3,356
12	0.662				0	0		4,900		4,900	3,243		4,900		4,900	3,243
13	0.639				0	0		4,900		4,900	3,133		4,900		4,900	3,133
14	0.618				0	0		4,900		4,900	3,027		4,900		4,900	3,027
15	0.597				0	0		4,900		4,900	2,925		4,900		4,900	2,925
16	0.577				0	0		4,900		4,900	2,826		4,900		4,900	2,826
17	0.557				0	0		4,900		4,900	2,730		4,900		4,900	2,730
18	0.538				0	0		4,900		4,900	2,638		4,900		4,900	2,638
19	0.520				0	0		4,900		4,900	2,549		4,900		4,900	2,549
20	0.503				0	0		4,900		4,900	2,463		4,900		4,900	2,463
21	0.486				0	0		4,900		4,900	2,379		4,900		4,900	2,379
22	0.469				0	0		4,900		4,900	2,299		4,900		4,900	2,299
23	0.453				0	0		4,900		4,900	2,221		4,900		4,900	2,221
24	0.438				0	0		4,900		4,900	2,146		4,900		4,900	2,146
25	0.423				0	0		4,900		4,900	2,073		4,900		4,900	2,073
26	0.409				0	0		4,900		4,900	2,003		4,900		4,900	2,003
27	0.395				0	0		4,900		4,900	1,936		4,900		4,900	1,936
28	0.382				0	0		4,900		4,900	1,870		4,900		4,900	1,870
29	0.369				0	0		4,900		4,900	1,807		4,900		4,900	1,807
30	0.356				0	0		4,900		4,900	1,746		4,900		4,900	1,746
31	0.344				0	0		4,900		4,900	1,687		4,900		4,900	1,687
32	0.333				0	0		4,900		4,900	1,630		4,900		4,900	1,630
33	0.321				0	0		4,900		4,900	1,575		4,900		4,900	1,575
34	0.310				0	0		4,900		4,900	1,521		4,900		4,900	1,521
35	0.300				0	0		4,900		4,900	1,470		4,900		4,900	1,470
36	0.290				0	0		4,900		4,900	1,420		4,900		4,900	1,420
37	0.280				0	0		4,900		4,900	1,372		4,900		4,900	1,372
38	0.271				0	0		4,900		4,900	1,326		4,900		4,900	1,326
39	0.261				0	0		4,900		4,900	1,281		4,900		4,900	1,281
40	0.253				0	0		4,900		4,900	1,238		4,900		4,900	1,238
41	0.244				0	0		4,900		4,900	1,196		4,900		4,900	1,196
42	0.236				0	0		4,900		4,900	1,155		4,900		4,900	1,155
43	0.228				0	0		4,900		4,900	1,116		4,900		4,900	1,116
44	0.220				0	0		4,900		4,900	1,079		4,900		4,900	1,079
45	0.213				0	0		4,900		4,900	1,042		4,900		4,900	1,042
46	0.205				0	0		4,900		4,900	1,007		4,900		4,900	1,007
47	0.199				0	0		4,900		4,900	973		4,900		4,900	973
48	0.192				0	0		4,900		4,900	940		4,900		4,900	940
49	0.185				0	0		4,900		4,900	908		4,900		4,900	908