2021 Wirral

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE
1		DCLG code	Local Authority	Ref code	Principal (£)	Initial Counterparty	Most recent Counterparty	Counterparty in 2020/21	Drawdown Date	Maturity Date	Term (years)	Lender's option period (m)	Type	Date start teaser rate	Teaser Rate (%)	Date start iniatial rate	Initial rate (%)	Date first option	Has option been excerised	Date when interest changed to current rate	Interest rate in 2020/21 (%)	Total Interest over the term of the loan	Total interest as % of loan	Fairvalue 2015/16 (£)	Fairvalue 2016/17 (£)	Fairvalue 2017/18 (£)	Fairvalue 2018/19 (£)	Fairvalue 2019/20 (£)	Fairvalue 2020/21 (£)	Fairvalue 2015/16 as % of Principle	Fairvalue 2016/17 as % of Principle	Fairvalue 2017/18 as % of Principle	Fairvalue 2018/19 as % of Principle	Fairvalue 2019/20 as % of Principle	Fairvalue 2020/21 as % of Principle	TMA Name	BROKER Name	BROKER Fee	BROKER Fee as % of principle	refinanced, restructured or term ended since 2015?	How?	Date of restructure	Breakage cost for restructure	Breakage cost as % of principle	Principal of new loan	Maturity date of new loan	Interest rate of new loan	Fairvalue 2018/19 for new loan	Fairvalue 2019/20 for new loan	Fairvalue 2020/21 for new loan	Advisor for restructure	Advisor's fee for restructure	Contract link	Broker invoice link	Restructured contract link	Restructuring FOI link	Notes
2					137,000,000	Eurohypo	EEP und Kommunalkredit	Commerzbank														418,332,454	111 - 489	271,941,000	284,905,000	271,544,000	258,024,000	267,383,000	264,390,302	121 - 273	136 - 289	117 - 277	114 - 270	109 - 292	105 - 274			0

3	E4305-01	E4305	Wirral	W046	2,000,000	Bayerische LB	Bayern LB	Bayern LB	18/02/02	19/08/41	40	6	Vanilla	-	-	18/02/02	5.50	18/08/02	No	-	5.50	4,403,616	220	3,256,000	3,405,000	3,197,000	3,181,000	3,193,000	3,196,347	163	170	160	159	160	160		Martin Brokers (UK)			-		-											https://drive.google.com/file/d/0B9WrsrhmRHz1RW14WTF5cU14M0E/view?usp=sharing&resourcekey=0-3A_gW_Uepu13uQ1AmkKhDw
4	E4305-02	E4305	Wirral	W063	6,000,000	Barclays	KA Finanz AG	-	30/08/02	29/08/42	40	6	Vanilla stepped	30/08/02	3.95	30/08/06	4.75	30/08/06	No	-	-	11,214,896	187	9,604,000	9,466,000	8,962,000	-	-	-	160	158	149	-	-	-					Yes	Repaid with PWLB	14/02/19	1,360,000	0.23	600,000	29/08/42	2.16	6,133,474	5,844,690	5,621,992	Arlinglose	withheld	https://drive.google.com/file/d/0B9WrsrhmRHz1REVoeEVJNUZkaEk/view?usp=sharing&resourcekey=0-ORsivmKJePnhjOQVH2biTA
5	E4305-03	E4305	Wirral	W069	6,000,000	Depfa	FMS -Wertmanagement	FMS -Wertmanagement	12/01/01	12/01/22	21	6	Vanilla	-	-	12/01/01	5.29	12/01/11	No	-	5.29	6,669,748	111	7,285,000	8,138,000	7,039,000	6,831,000	6,529,000	6,316,917	121	136	117	114	109	105					-		-											https://drive.google.com/file/d/1pc3cruL36MwMVqGaIVWO8icTlJ25lp7V/view?usp=sharing
6	E4305-04	E4305	Wirral	W072	5,000,000	Depfa	FMS -Wertmanagement	FMS -Wertmanagement	19/09/01	19/03/26	25	6	Vanilla stepped	19/09/01	4.95	19/03/05	6.50	19/03/05	No	-	6.50	7,819,705	156	7,091,000	7,842,000	6,810,000	6,728,000	6,424,000	6,382,430	142	157	136	135	128	128					-		-											https://drive.google.com/file/d/0B9WrsrhmRHz1MjhEenI1Zm85Ymc/view?usp=sharing&resourcekey=0-LB6NygJ_idnRvkdqtUM7HA
7	E4305-05	E4305	Wirral	W073	2,500,000	Depfa	FMS -Wertmanagement	FMS -Wertmanagement	30/09/01	11/06/35	34	1 day	Vanilla	-	-	30/09/01	5.25	30/09/01	No	-	5.25	4,597,346	184	3,630,000	4,011,000	3,662,000	3,661,000	3,626,000	3,618,966	145	160	146	146	145	145					-		-											https://drive.google.com/file/d/0B9WrsrhmRHz1MVJDMHNpV0F0X3c/view?usp=sharing&resourcekey=0-Eo7q2Sezjn4uaUQBFi2T3Q
8	E4305-06	E4305	Wirral	W077	5,000,000	Dresdner	KA Finanz AG	Just Retirement Ltd	29/01/03	29/01/43	40	6	Vanilla stepped	29/01/03	2.25	30/01/06	4.90	30/01/06	No	-	4.90	9,405,812	188	8,732,000	8,069,000	7,643,000	7,581,000	7,671,000	7,723,136	175	161	153	152	153	154		Prebon Marshall Yamane			-		-											https://drive.google.com/file/d/0B9WrsrhmRHz1Ni1ZTzlnWTFsVjg/view?usp=sharing&resourcekey=0-3YFi1NsEH4iW-cmnjrm_NA
9	E4305-07	E4305	Wirral	W080	6,000,000	Rheinhyp	EEP und Kommunalkredit	Commerzbank	31/07/02	31/07/42	40	6	Vanilla stepped	31/07/02	3.57	30/04/06	4.99	30/04/06	No	-	4.99	15,111,988	252	9,995,000	11,144,000	10,732,000	10,532,000	11,136,000	11,078,324	167	186	179	176	186	185		Tradition			-		-											https://drive.google.com/file/d/0B9WrsrhmRHz1NHdYWHhPazZrN2s/view?usp=sharing&resourcekey=0-2tSGiCdVx-yHrYQMhlFBBQ
10	E4305-08	E4305	Wirral	W085	10,000,000	Barclays	Barclays	Barclays	05/04/04	06/04/54	50	6	Vanilla stepped	05/04/04	3.75	05/04/10	4.75	05/04/10	No	-	4.75	23,165,069	232	15,907,000	16,700,000	16,062,000	15,937,000	16,391,000	16,522,730	159	167	161	159	164	165		Tradition			Yes	Option removed	29/06/16											https://drive.google.com/file/d/0B9WrsrhmRHz1UF9Jd3pzU2hMSmc/view?usp=sharing&resourcekey=0-h_2pQQyBMDJzhFh1N970Vg
11	E4305-09	E4305	Wirral	W094	6,000,000	Barclays	Barclays	Barclays	08/02/05	08/02/55	50	6	Vanilla stepped	08/02/05	4.05	08/02/08	4.68	08/02/08	No	-	4.68	13,935,832	232	9,418,000	9,870,000	9,487,000	9,417,000	9,695,000	9,780,302	157	165	158	157	162	163					Yes	Option removed	29/06/16											https://drive.google.com/file/d/0B9WrsrhmRHz1eGNxbHEzQVhId2s/view?usp=sharing&resourcekey=0-duP6qLbOIa6DxHF9Q11jNQ
12	E4305-10	E4305	Wirral	W096	10,000,000	Bayerische LB	Bayern LB	Bayern LB	20/03/01	22/03/55	54	6	Vanilla stepped	20/03/01	2.95	20/03/08	5.90	20/03/06	No	-	5.90	30,218,178	302	18,173,000	20,212,000	19,398,000	19,174,000	20,095,000	19,912,652	182	202	194	192	201	199					-		-											https://drive.google.com/file/d/0B9WrsrhmRHz1TjBKNXBuRHhRNVE/view?usp=sharing&resourcekey=0-7YhmaMHaZv9R9z9P_7PCqQ				intermediate step up to 4.9% between 20/03/06 and 20/03/08
13	E4305-11	E4305	Wirral	W100	4,000,000	Barclays	Barclays	Barclays	15/08/05	13/08/65	60	6	Vanilla stepped	15/08/05	3.80	13/08/09	4.95	13/08/09	No	-	4.95	11,789,578	295	6,963,000	7,492,000	7,206,000	7,003,000	7,298,000	7,353,619	174	187	180	175	182	184					Yes	Option removed	29/06/16											https://drive.google.com/file/d/0B9WrsrhmRHz1NXQwdWhmeWFjUUk/view?usp=sharing&resourcekey=0-bSPFpwqLnL6gSGE5u_iIzg				Additional step of 4.52% between 13/8/2006 and 13/8/2009
14	E4305-12	E4305	Wirral	W101	8,500,000	Eurohypo	EEP und Kommunalkredit	Commerzbank	15/08/05	18/08/65	60	6	Vanilla stepped	15/08/05	6.25	15/08/08	8.00	18/08/08	No	-	8.00	40,385,654	475	21,398,000	24,538,000	23,503,000	22,925,000	24,781,000	23,307,458	252	289	277	270	292	274		Prebon Marshall Yamane			-		-											https://drive.google.com/file/d/1UtUd47xyXrlUW6GjKeEebicU4o2uofZM/view?usp=sharing
15	E4305-13	E4305	Wirral	W104	5,000,000	Eurohypo	EEP und Kommunalkredit	Commerzbank	12/07/05	13/07/54	49	60	Vanilla stepped	12/07/05	6.85	14/07/08	7.85	14/07/08	No	-	7.85	19,096,069	382	11,307,000	12,526,000	11,888,000	11,885,000	12,300,000	11,947,474	226	251	238	238	246	239					-		-											https://drive.google.com/file/d/1UtUd47xyXrlUW6GjKeEebicU4o2uofZM/view?usp=sharing
16	E4305-14	E4305	Wirral	W105	5,000,000	Eurohypo	EEP und Kommunalkredit	Commerzbank	12/07/05	13/07/54	49	60	Vanilla stepped	12/07/05	5.95	12/07/07	7.80	12/07/07	No	-	7.80	18,938,890	379	11,248,000	12,461,000	11,949,000	11,824,000	12,239,000	11,887,270	225	249	239	236	245	238					-		-											https://drive.google.com/file/d/1UtUd47xyXrlUW6GjKeEebicU4o2uofZM/view?usp=sharing
17	E4305-15	E4305	Wirral	W106	5,000,000	Eurohypo	EEP und Kommunalkredit	Commerzbank	12/07/05	13/07/54	49	60	Vanilla stepped	12/07/05	4.45	12/07/06	7.75	12/07/07	No	-	7.75	18,836,301	377	11,190,000	12,398,000	12,011,000	11,765,000	12,179,000	11,827,065	224	248	240	235	244	237					-		-											https://drive.google.com/file/d/1UtUd47xyXrlUW6GjKeEebicU4o2uofZM/view?usp=sharing
18	E4305-16	E4305	Wirral	W107	9,500,000	Eurohypo	EEP und Kommunalkredit	Commerzbank	12/09/05	12/09/43	38	6	Vanilla	-	-	12/09/05	4.64	12/09/07	No	-	4.64	16,763,684	176	25,959,000	14,908,000	14,148,000	13,975,000	14,224,000	14,355,468	273	157	149	147	150	151					-		-											https://drive.google.com/file/d/1UtUd47xyXrlUW6GjKeEebicU4o2uofZM/view?usp=sharing
19	E4305-17	E4305	Wirral	W109	15,000,000	Bank of Scotland	Dresdner	Commerzbank	18/10/04	16/10/54	50	6	Vanilla stepped	18/10/04	6.25	18/10/06	7.85	18/10/06	No	-	7.85	58,427,260	390	34,295,000	37,963,000	36,418,000	36,048,000	37,328,000	36,239,144	229	253	243	240	249	242					-		-											https://drive.google.com/file/d/0B9WrsrhmRHz1elZZTnpFMktVclk/view?usp=sharing&resourcekey=0-UMlJwEhUUzEY6RXGUspbYg
20	E4305-18	E4305	Wirral	W110	18,500,000	Barclays	Barclays	Barclays	23/01/08	23/01/78	70	6	Vanilla	-	-	23/01/08	6.98	23/01/09	No	-	6.98	90,458,218	489	44,435,000	50,286,000	48,563,000	46,762,000	49,069,000	49,671,448	240	272	263	253	265	268		Tullet Prebon			Yes	Option removed	29/06/16											https://drive.google.com/file/d/0B9WrsrhmRHz1T1FMbC1RSXRwaE0/view?usp=sharing&resourcekey=0-gwFzI0yTbLRDzOxHWhiqsA
21	E4305-19	E4305	Wirral	W111	8,000,000	Dresdner	EEP und Kommunalkredit	Commerzbank	07/01/04	07/01/49	45	6	Vanilla stepped	07/01/04	3.95	07/04/09	4.85	07/04/09	No	-	4.85	17,094,608	214	12,055,000	13,476,000	12,866,000	12,795,000	13,205,000	13,269,554	151	168	161	160	165	166		Prebon Marshall Yamane					-											https://drive.google.com/file/d/1UtUd47xyXrlUW6GjKeEebicU4o2uofZM/view?usp=sharing
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100