a. Calculate the yield-to-maturity (YTM) of all the bonds in the data, including those on Sep 18, 2023. Assume the Treasury security pays coupon on a semi-annual basis if the coupon rate is not zero. Also assume that the face value of a bond is 100 (corresponding to $1,000 in actuality). Hint: you can use the yield function in Excel for this calculation. Produce a snippet of your results here. Please show step by step on how to do it in excel.

Date	Maturity	Maturity Date	CUSIP	Security Type	Coupon Rate	Price
2/3/22	1 Mo	3/8/22	912796S75	Treasury Bill	0	99.997333
2/3/22	2 Mo	4/5/22	912796T74	Treasury Bill	0	99.98
2/3/22	3 Mo	5/3/22	912796U72	Treasury Bill	0	99.956
2/3/22	6 Mo	8/4/22	912796S67	Treasury Bill	0	99.758667
2/3/22	1 Yr	1/31/23	91282CBG5	Treasury Note	0.00125	99.3125
2/3/22	2 Yr	1/31/24	9128285Z9	Treasury Note	0.025	102.5625
2/3/22	3 Yr	1/31/25	912828Z52	Treasury Note	0.01375	99.875
2/3/22	5 Yr	1/31/27	912828Z78	Treasury Note	0.015	99.25
2/3/22	7 Yr	1/31/29	91282CDW8	Treasury Note	0.0175	99.78125
2/3/22	10 Yr	11/15/31	91282CDJ7	Treasury Note	0.01375	96.03125
2/3/22	20 Yr	2/15/42	912810QU5	Treasury Bond	0.03125	115.34375
2/3/22	30 Yr	11/15/51	912810TB4	Treasury Bond	0.01875	94.0625
2/4/22	1 Mo	3/8/22	912796S75	Treasury Bill	0	99.996778
2/4/22	2 Mo	4/5/22	912796T74	Treasury Bill	0	99.979417
2/4/22	3 Mo	5/3/22	912796U72	Treasury Bill	0	99.948056
2/4/22	6 Mo	8/4/22	912796S67	Treasury Bill	0	99.728056
2/4/22	1 Yr	1/31/23	91282CBG5	Treasury Note	0.00125	99.21875
2/4/22	2 Yr	1/31/24	9128285Z9	Treasury Note	0.025	102.3125
2/4/22	3 Yr	1/31/25	912828Z52	Treasury Note	0.01375	99.5
2/4/22	5 Yr	1/31/27	912828Z78	Treasury Note	0.015	98.6875
2/4/22	7 Yr	1/31/29	91282CDW8	Treasury Note	0.0175	99.03125
2/4/22	10 Yr	11/15/31	91282CDJ7	Treasury Note	0.01375	95.125
2/4/22	20 Yr	2/15/42	912810QU5	Treasury Bond	0.03125	113.6875
2/4/22	30 Yr	11/15/51	912810TB4	Treasury Bond	0.01875	92.28125
9/18/23	1 Mo	10/17/23	912797HB6	Treasury Bill	0	99.588556
9/18/23	2 Mo	11/16/23	912797FK8	Treasury Bill	0	99.149333
9/18/23	3 Mo	12/19/23	912797HV2	Treasury Bill	0	98.660278
9/18/23	6 Mo	3/14/24	912797GX9	Treasury Bill	0	97.394167
9/18/23	1 Yr	9/15/24	91282CCX7	Treasury Note	0.00375	95.125
9/18/23	2 Yr	9/15/25	91282CFK2	Treasury Note	0.035	97.0625
9/18/23	3 Yr	9/15/26	91282CHY0	Treasury Note	0.04625	99.6875
9/18/23	5 Yr	8/31/28	91282CHX2	Treasury Note	0.04375	99.625
9/18/23	7 Yr	8/31/30	91282CHW4	Treasury Note	0.04125	98.3125
9/18/23	10 Yr	8/15/33	91282CHT1	Treasury Note	0.03875	96.46875
9/18/23	20 Yr	8/15/43	912810RC4	Treasury Bond	0.03625	87.125
9/18/23	30 Yr	8/15/53	912810TT5	Treasury Bond	0.04125	95.5625

b. Calculate the change in the YTM of each type of bond at Feb 4, 2022 relative to Feb 3, 2022, similar to what you did for the prices of these bonds in part a of Question 1 above. Then, put the changes in prices and the changes in YTM together. Produce a snippet of the results here. What can you conclude about the relationship between bond prices and YTM?