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.