5/7 - Google Sheets

	A	B	C	D	E	G	H	I	J	K
1	Date	LIBOR 6m		YC on 1/1/2016		Date	Fixed	Floating
2	1/1/2016	0.37%		1y	0.61%	1/1/2016	$1,000,000	$1,000,000
3	7/1/2016	0.41%		2y	1.02%	7/1/2016	$1,023,377	$1,019,147
4	1/1/2017	0.70%		3y	1.31%	1/1/2017	$1,047,300	$1,038,860
5	7/1/2017	1.17%		5y	1.73%	7/1/2017	$1,071,782	$1,060,426
6	1/1/2018	1.44%				1/1/2018	$1,096,837	$1,084,915	$1,000,000	$1,000,000
7	7/1/2018	1.93%		Spread Fixed	3%	7/1/2018	$1,122,478	$1,111,379	$1,025,700	$1,024,393
8	1/1/2019	2.39%		Spread Floating	3.50%	1/1/2019	$1,148,718	$1,141,154	$1,052,061	$1,051,837
9	7/1/2019	2.36%		Amount	$1,000,000	7/1/2019	$1,175,571	$1,174,263	$1,079,099	$1,082,355
10	1/1/2020	1.54%				1/1/2020	$1,203,052	$1,208,180	$1,106,832	$1,113,617
11	7/1/2020	0.08%		FR Fixed 2-5	2.21%	7/1/2020	$1,231,176	$1,238,257	$1,135,278	$1,141,340
12	1/1/2021					1/1/2021	$1,259,956	$1,260,209	$1,164,455	$1,161,574
13
14
15	5/7/2021	Swap Rate	YC
16	1	0.21%	0.10%
17	2	0.28%	0.11%
18	3	0.46%	0.16%
19	5	0.91%	0.36%
20	7	1.25%	0.64%
21	10	1.56%	0.93%
22	15	1.67%	1.20%
23	30	1.98%	1.66%
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