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		6%
Costs and benefits of options
		Costs and benefits £
	Do Nothing	Maintain	Channel Enlargement (50 year)
PV costs PVc	0	81,867	525,379
PV damage PVd	5,648,696	138,660	38,092
PV damage avoided		5,510,036	5,610,604
PV assets Pva	0	0	0
PV asset protection benefits		0	0
Total PV benefits PVb		5,510,036	5,610,604
Net Present Value NPV		5,428,169	5,085,225
Average benefit/cost ratio		67.3	10.7
Incremental benefit/cost ratio			0.2
		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		5,648,696		138,660		38,092					Checked date
Discount rate			6%				PV benefits				5,510,036		5,610,604
		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,082,992	0	0	10,082,992	5,648,696	414,961	0	0	414,961	138,660	101,238	0	0	101,238	38,092
	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	1,897			1,897	1,789
2	0.890	8,299			8,299	7,386	8,299			8,299	7,386	1,897			1,897	1,688
3	0.840	8,299			8,299	6,968	8,299			8,299	6,968	1,897			1,897	1,593
4	0.792	8,299			8,299	6,574	8,299			8,299	6,574	1,897			1,897	1,502
5	0.747	8,299			8,299	6,202	8,299			8,299	6,202	1,897			1,897	1,417
6	0.705	8,299			8,299	5,851	8,299			8,299	5,851	1,897			1,897	1,337
7	0.665	8,299			8,299	5,519	8,299			8,299	5,519	1,897			1,897	1,261
8	0.627	8,299			8,299	5,207	8,299			8,299	5,207	1,897			1,897	1,190
9	0.592	8,299			8,299	4,912	8,299			8,299	4,912	1,897			1,897	1,123
10	0.558	10,000,000			10,000,000	5,583,948	8,299			8,299	4,634	1,897			1,897	1,059
11	0.527				0	0	8,299			8,299	4,372	1,897			1,897	999
12	0.497				0	0	8,299			8,299	4,124	1,897			1,897	943
13	0.469				0	0	8,299			8,299	3,891	1,897			1,897	889
14	0.442				0	0	8,299			8,299	3,671	1,897			1,897	839
15	0.417				0	0	8,299			8,299	3,463	1,897			1,897	791
16	0.394				0	0	8,299			8,299	3,267	1,897			1,897	747
17	0.371				0	0	8,299			8,299	3,082	1,897			1,897	704
18	0.350				0	0	8,299			8,299	2,908	1,897			1,897	665
19	0.331				0	0	8,299			8,299	2,743	1,897			1,897	627
20	0.312				0	0	8,299			8,299	2,588	1,897			1,897	591
21	0.294				0	0	8,299			8,299	2,441	1,897			1,897	558
22	0.278				0	0	8,299			8,299	2,303	1,897			1,897	526
23	0.262				0	0	8,299			8,299	2,173	1,897			1,897	497
24	0.247				0	0	8,299			8,299	2,050	1,897			1,897	468
25	0.233				0	0	8,299			8,299	1,934	1,897			1,897	442
26	0.220				0	0	8,299			8,299	1,824	1,897			1,897	417
27	0.207				0	0	8,299			8,299	1,721	1,897			1,897	393
28	0.196				0	0	8,299			8,299	1,624	1,897			1,897	371
29	0.185				0	0	8,299			8,299	1,532	1,897			1,897	350
30	0.174				0	0	8,299			8,299	1,445	1,897			1,897	330
31	0.164				0	0	8,299			8,299	1,363	1,897			1,897	312
32	0.155				0	0	8,299			8,299	1,286	1,897			1,897	294
33	0.146				0	0	8,299			8,299	1,213	1,897			1,897	277
34	0.138				0	0	8,299			8,299	1,145	1,897			1,897	262
35	0.130				0	0	8,299			8,299	1,080	1,897			1,897	247
36	0.123				0	0	8,299			8,299	1,019	1,897			1,897	233
37	0.116				0	0	8,299			8,299	961	1,897			1,897	220
38	0.109				0	0	8,299			8,299	907	1,897			1,897	207
39	0.103				0	0	8,299			8,299	855	1,897			1,897	195
40	0.097				0	0	8,299			8,299	807	1,897			1,897	184
41	0.092				0	0	8,299			8,299	761	1,897			1,897	174
42	0.087				0	0	8,299			8,299	718	1,897			1,897	164
43	0.082				0	0	8,299			8,299	677	1,897			1,897	155
44	0.077				0	0	8,299			8,299	639	1,897			1,897	146
45	0.073				0	0	8,299			8,299	603	1,897			1,897	138
46	0.069				0	0	8,299			8,299	569	1,897			1,897	130
47	0.065				0	0	8,299			8,299	537	1,897			1,897	123
48	0.061				0	0	8,299			8,299	506	1,897			1,897	116
49	0.058				0	0	8,299			8,299	478	1,897			1,897	109

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		81,867		525,379					Checked date
Discount rate			6%
		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	81,867	436,859	245,000	31,381	713,240	525,379
	Discount
year	Factor
0	1.000				0	0		4,900		4,900	4,900		4,900	31,381	36,281	36,281
1	0.943				0	0		4,900		4,900	4,623	436,859	4,900		441,759	416,754
2	0.890				0	0		4,900		4,900	4,361		4,900		4,900	4,361
3	0.840				0	0		4,900		4,900	4,114		4,900		4,900	4,114
4	0.792				0	0		4,900		4,900	3,881		4,900		4,900	3,881
5	0.747				0	0		4,900		4,900	3,662		4,900		4,900	3,662
6	0.705				0	0		4,900		4,900	3,454		4,900		4,900	3,454
7	0.665				0	0		4,900		4,900	3,259		4,900		4,900	3,259
8	0.627				0	0		4,900		4,900	3,074		4,900		4,900	3,074
9	0.592				0	0		4,900		4,900	2,900		4,900		4,900	2,900
10	0.558				0	0		4,900		4,900	2,736		4,900		4,900	2,736
11	0.527				0	0		4,900		4,900	2,581		4,900		4,900	2,581
12	0.497				0	0		4,900		4,900	2,435		4,900		4,900	2,435
13	0.469				0	0		4,900		4,900	2,297		4,900		4,900	2,297
14	0.442				0	0		4,900		4,900	2,167		4,900		4,900	2,167
15	0.417				0	0		4,900		4,900	2,045		4,900		4,900	2,045
16	0.394				0	0		4,900		4,900	1,929		4,900		4,900	1,929
17	0.371				0	0		4,900		4,900	1,820		4,900		4,900	1,820
18	0.350				0	0		4,900		4,900	1,717		4,900		4,900	1,717
19	0.331				0	0		4,900		4,900	1,620		4,900		4,900	1,620
20	0.312				0	0		4,900		4,900	1,528		4,900		4,900	1,528
21	0.294				0	0		4,900		4,900	1,441		4,900		4,900	1,441
22	0.278				0	0		4,900		4,900	1,360		4,900		4,900	1,360
23	0.262				0	0		4,900		4,900	1,283		4,900		4,900	1,283
24	0.247				0	0		4,900		4,900	1,210		4,900		4,900	1,210
25	0.233				0	0		4,900		4,900	1,142		4,900		4,900	1,142
26	0.220				0	0		4,900		4,900	1,077		4,900		4,900	1,077
27	0.207				0	0		4,900		4,900	1,016		4,900		4,900	1,016
28	0.196				0	0		4,900		4,900	959		4,900		4,900	959
29	0.185				0	0		4,900		4,900	904		4,900		4,900	904
30	0.174				0	0		4,900		4,900	853		4,900		4,900	853
31	0.164				0	0		4,900		4,900	805		4,900		4,900	805
32	0.155				0	0		4,900		4,900	759		4,900		4,900	759
33	0.146				0	0		4,900		4,900	716		4,900		4,900	716
34	0.138				0	0		4,900		4,900	676		4,900		4,900	676
35	0.130				0	0		4,900		4,900	638		4,900		4,900	638
36	0.123				0	0		4,900		4,900	601		4,900		4,900	601
37	0.116				0	0		4,900		4,900	567		4,900		4,900	567
38	0.109				0	0		4,900		4,900	535		4,900		4,900	535
39	0.103				0	0		4,900		4,900	505		4,900		4,900	505
40	0.097				0	0		4,900		4,900	476		4,900		4,900	476
41	0.092				0	0		4,900		4,900	449		4,900		4,900	449
42	0.087				0	0		4,900		4,900	424		4,900		4,900	424
43	0.082				0	0		4,900		4,900	400		4,900		4,900	400
44	0.077				0	0		4,900		4,900	377		4,900		4,900	377
45	0.073				0	0		4,900		4,900	356		4,900		4,900	356
46	0.069				0	0		4,900		4,900	336		4,900		4,900	336
47	0.065				0	0		4,900		4,900	317		4,900		4,900	317
48	0.061				0	0		4,900		4,900	299		4,900		4,900	299
49	0.058				0	0		4,900		4,900	282		4,900		4,900	282