2021 Fife

	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	Loan Code	DCLG code	Local Authority	Ref code	Principal (£)	Initial Counterparty	Counterparty in 2018/19	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					347,350,000																	879,982,980	140 - 317	503,111,582	587,499,885	577,620,889	586,197,008	577,620,889	558,815,784	124 - 214	86 - 243	85 - 236	86 - 244	85 - 236	88 - 198	Butlers	ICAP Plc	694,700	0.20

3	S8301-01	S8301	Fife	500001330	1,000,000	Dresdner Bank	Commerzbank	Commerzbank	19/12/07	18/09/23	16	6	Vanilla	-	-	19/12/07	11.800	17/09/98	NO	-	11.800	1,859,551	186	1,693,175	1,655,832	1,517,088	1,447,783	1,517,088	1,269,393	169	166	152	145	152	127	Butlers	ICAP Plc	2,000	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=1HeUMEQcchZx31A7irlqkSOIvZR5Frk9W
4	S8301-02	S8301	Fife	500001335	1,000,000	Dresdner Bank	Commerzbank	Commerzbank	18/09/02	20/10/42	40	6	Vanilla	-	-	18/09/02	6.400	18/10/04	NO	-	6.400	2,567,364	257	1,617,191	1,757,583	1,740,339	1,767,960	1,740,339	1,758,588	162	176	174	177	174	176	Butlers	ICAP Plc	2,000	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=1sUHukgEFVX3PMc9FrjVpvH_9wJgcCEbL
5	S8301-03	S8301	Fife	500001369	6,100,000	Dexia Public Finance Bank	Dexia	Dexia	28/12/05	28/12/63	58	6	Vanilla stepped	28/12/05	4.40	28/12/07	4.745	28/12/07	NO	-	4.745	16,745,720	275	8,910,715	10,555,923	10,335,094	10,477,575	10,335,094	10,849,140	146	173	169	172	169	178	Butlers	ICAP Plc	12,200	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyNjhqU05oWWNLVEE
6	S8301-04	S8301	Fife	500001370	8,400,000	Eurohypo	Commerzbank	Commerzbank	20/03/06	20/03/66	60	6	Vanilla stepped	20/03/06	4.25	20/03/08	4.500	20/03/08	NO	-	4.500	22,638,000	270	11,760,437	14,056,236	13,780,056	13,956,716	13,780,056	14,550,730	140	167	164	166	164	173	Butlers	ICAP Plc	16,800	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyT2pIa2VfQ2R1Zzg
7	S8301-05	S8301	Fife	500001372	8,100,000	Dresdner Bank AG London Branch	Commerzbank	Commerzbank	18/09/02	18/09/42	40	once	Vanilla	-	-	18/09/02	4.580	18/03/05	NO	-	4.580	14,839,200	183	11,509,510	13,747,618	13,476,701	13,647,407	13,476,701	14,223,029	142	170	166	168	166	176	Butlers	ICAP Plc	16,200	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyVE9aU2hsTEpTM1E
8	S8301-06	S8301	Fife	500001373	4,800,000	Eurohypo	Commerzbank	Commerzbank	18/10/05	18/10/62	57	6	Vanilla	-	-	18/10/05	4.650	18/10/08	NO	-	4.650	12,722,400	265	6,908,301	8,160,706	7,990,340	8,096,540	7,990,340	8,320,931	144	170	166	169	166	173	Butlers	ICAP Plc	9,600	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zySklVWnl4MS1iWVE
9	S8301-07	S8301	Fife	500001374	6,000,000	Eurohypo	Commerzbank	Commerzbank	18/10/05	18/10/62	57	6	Vanilla	-	-	18/10/05	4.750	18/10/08	NO	-	4.750	16,245,000	271	8,788,552	5,186,909	5,078,302	5,144,766	5,078,302	5,285,114	146	86	85	86	85	88	Butlers	ICAP Plc	12,000	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyOFhoT09UVl83MTg
10	S8301-08	S8301	Fife	500001375	6,000,000	Eurohypo	Commerzbank	Commerzbank	18/10/05	18/10/62	57	6	Vanilla	-	-	18/10/05	4.750	18/10/08	NO	-	4.750	16,245,000	271	8,788,552	5,186,909	5,078,302	5,144,766	5,078,302	5,285,114	146	86	85	86	85	88	Butlers	ICAP Plc	12,000	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyOFhoT09UVl83MTg
11	S8301-09	S8301	Fife	500001379	10,000,000	Barclays	Commerzbank	Commerzbank	14/11/05	14/11/65	60	6	Vanilla stepped	14/11/05	5.00	14/05/08	5.300	14/05/08	NO	-	5.300	31,725,000	317	16,226,273	19,215,971	18,834,738	19,042,710	18,834,738	19,764,486	162	192	188	190	188	198	Butlers	ICAP Plc	20,000	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zySmxKczhxYzQ3Ums
12	S8301-10	S8301	Fife	500001380	18,440,000	Dexia Credit Local	Dexia	Dexia	10/08/05	10/08/65	60	6	Vanilla	-	-	10/08/05	5.080	10/08/09	NO	-	5.080	56,205,120	305	28,585,396	33,905,702	33,321,391	33,605,123	33,321,391	34,601,695	155	184	181	182	181	188	Butlers	ICAP Plc	36,880	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyZlJXd2wxLTJvU2M
13	S8301-11	S8301	Fife	500001381	2,700,000	Bayerische Landesbank	Bayerische Landesbank	Bayerische Landesbank	29/03/01	31/03/31	30	6	Vanilla	-	-	29/03/01	4.650	29/03/05	NO	-	4.650	3,766,500	140	3,348,249	3,546,367	3,398,026	3,494,099	3,398,026	3,448,282	124	131	126	129	126	128	Butlers	ICAP Plc	5,400	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyOUhDWXpqT1FKYjQ
14	S8301-12	S8301	Fife	500001382	7,500,000	Barclays	Commerzbank	Commerzbank	15/08/05	15/08/65	60	6	Vanilla stepped	15/08/05	2.90	15/02/07	4.500	15/02/07	NO	-	4.500	20,070,000	268	10,494,116	12,504,031	12,253,020	12,420,785	12,253,020	12,916,882	140	167	163	166	163	172	Butlers	ICAP Plc	15,000	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zybXhEZWdFQXVPRHM
15	S8301-13	S8301	Fife	500001383	9,000,000	Dexia Public Finance Bank	Dexia	Dexia	18/08/05	18/08/64	59	6	Vanilla stepped	18/08/05	3.15	19/02/07	4.500	19/02/07	NO	-	4.500	23,712,750	263	12,399,679	14,918,445	14,607,872	14,821,989	14,607,872	15,377,021	138	166	162	165	162	171	Butlers	ICAP Plc	18,000	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyNjFPZFBOTWpUWDg
16	S8301-14	S8301	Fife	500001384	20,000,000	Dresdner Bank AG London Branch	Commerzbank	Commerzbank	19/12/07	06/08/66	59	6	Vanilla stepped	19/12/07	3.50	06/08/09	4.875	06/08/09	NO	-	4.875	57,112,500	286	30,060,389	35,795,678	35,087,440	35,510,525	35,087,440	36,952,518	150	179	175	178	175	185	Butlers	ICAP Plc	40,000	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyZDBzb3ZST2ptYTA
17	S8301-15	S8301	Fife	500001385	25,000,000	Eurohypo	Commerzbank	Commerzbank	02/06/06	05/06/66	60	6	Vanilla stepped	06/02/06	3.25	06/02/08	4.875	06/02/08	NO	-	4.875	72,312,500	289	37,135,293	44,745,792	43,859,300	44,388,156	43,859,300	46,190,648	149	179	175	178	175	185	Butlers	ICAP Plc	50,000	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyZUhfMXhQb1Y3RW8
18	S8301-16	S8301	Fife	500001386	5,200,000	Barclays	Dexia	Dexia	03/10/03	03/10/46	43	6	Vanilla stepped	03/10/03	3.50	03/10/07	4.875	03/10/07	NO	-	4.875	10,614,500	204	7,853,760	9,300,286	9,085,868	9,209,499	9,085,868	9,471,415	151	179	175	177	175	182	Butlers	ICAP Plc	10,400	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zycC1rSmcyb0NWaWs
19	S8301-17	S8301	Fife	500001387	15,000,000	Barclays	Dexia	Dexia	16/08/05	16/08/65	60	6	Vanilla stepped	16/08/05	3.77	16/02/09	4.680	16/02/09	NO	-	4.680	41,642,250	278	21,432,836	25,808,477	25,282,682	25,616,442	25,282,682	26,621,658	143	172	169	171	169	177	Butlers	ICAP Plc	30,000	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyUVlhd2xsMVRYajQ
20	S8301-18	S8301	Fife	500001388	9,310,000	Barclays	Dexia	Dexia	27/09/05	27/09/65	60	6	Vanilla stepped	27/09/05	4.25	27/09/14	5.000	27/09/14	NO	-	5.000	27,301,575	293	14,018,842	16,857,666	16,510,021	16,722,488	16,510,021	17,354,407	151	181	177	180	177	186	Butlers	ICAP Plc	18,620	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyWkJ5enBuTlE4MXM
21	S8301-19	S8301	Fife	500001390	43,400,000	Dresdner Bank AG London Branch	Commerzbank	Commerzbank	12/12/05	12/12/64	59	60	Vanilla stepped	12/12/05	3.00	12/12/09	4.375	12/12/09	NO	-	4.375	109,639,250	253	59,202,558	70,005,216	68,617,498	69,557,768	68,617,498	72,317,323	136	161	158	160	158	167	Butlers	ICAP Plc	86,800	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyQnk3M29ULWV4cFk
22	S8301-20	S8301	Fife	500001391	25,000,000	Dresdner Bank AG London Branch	KBC	KBC	12/12/05	12/12/65	60	60	Vanilla stepped	12/12/05	3.00	12/12/09	4.375	12/12/09	NO	-	4.375	64,250,000	257	34,012,075	41,060,629	40,263,714	40,776,844	40,263,714	42,493,217	136	164	161	163	161	170	Butlers	ICAP Plc	50,000	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyQnk3M29ULWV4cFk
23	S8301-21	S8301	Fife	500001392	45,400,000	Barclays	Bayerische Landesbank	Bayerische Landesbank	17/07/06	17/07/67	61	48	Vanilla	-	-	17/07/06	3.950	17/07/10	NO	-	3.950	109,391,300	241	57,366,831	68,199,839	67,815,662	68,566,460	67,815,662	71,043,829	126	150	149	151	149	156	Butlers	ICAP Plc	90,800	0.20	NO	-	-	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zya3E4R1BtOHBJMW8
24	S8301-22	S8301	Fife	500001393	25,000,000	Barclays	Barclays	Barclays	30/03/07	30/03/76	69	60	Vanilla	-	-	30/03/07	4.290	01/04/01	NO	-	4.290	74,002,500	296	34,281,302	41,446,647	41,350,670	42,088,216	41,350,670	44,434,705	137	166	165	168	165	178	Butlers	ICAP Plc	50,000	0.20	YES	Option Removed	2016	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyOFM1QlFjN2lQMVU
25	S8301-23	S8301	Fife	500001394	25,000,000	Barclays	Barclays	Barclays	30/03/07	30/03/77	70	60	Vanilla	-	-	30/03/07	4.250	01/04/01	NO	-	4.250	74,375,000	298	34,007,607	41,251,300	41,156,302	41,905,167	41,156,302	44,285,659	136	165	165	168	165	177	Butlers	ICAP Plc	50,000	0.20	YES	Option Removed	2016	-	-	-	-	-	-	-	-	-		https://drive.google.com/open?id=0B-LcvUI3I5zyUW9oZWMyVXQ1dEE
26	S8301-24	S8301	Fife	500001411	20,000,000	Royal Bank of Scotland	Royal Bank of Scotland	-	25/02/12	25/02/60	48		Inverse Floater	25/02/12	2.000	25/02/14	8.99 - 10yr GBP ISDA	25/02/16	No	-	-	Missing	Missing	42,709,943	48,630,123	47,180,464	48,787,225	47,180,464	-	214	243	236	244	236	-	Butlers	ICAP Plc	40,000	0.20	YES	Repaid with PWLB	02/07/19	18,454,078	92		11/15/2059	2.19	N/A	18,800,759	18,800,759	Link Asset Services
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