How does one calculate the 5-year swap rate (par coupon) if we begin on November 15, 2017 using this data? Please help, it is now due in 24 hrs.

2. Use the November 15, 2017 U.S. Treasury quotes from the Wall Street Journal shown below to calculate the spot rate for each date given in the table. Solution: The discount factors are built successively as shown on slide 17 of lecture 0. The spot rates follow from the discount factors as shown in slide 18 of lkecture 9, Maturity Coupn Price Disount Factor Spot Rate 1 998125 1.25 99.6611 5/15/19 0.875 98.8672 1 98.6328 15 99.3828 1.75 99.8359 5/15/21 3.125 104.2266 2 100.2734 1.75 98.9844 11/15/22 .625 98.0391 050316 0.98428 0.97575 0.96673 0.95725 0.94739 0.93662 0.92586 0.91458 .90316 1.38 1.59 1.64 1.70 1.76 1.81 1.88 1.94 1.99 2.05 11/15/18 11/15/19 5/15/20 11/15/20 11/15/21 Coupon and spot rate i%/yeur, price as percent of par. 3. The current Fed Finds rate band is 1.25%/year - 1.50%/year. At what price would the Federal Reserve Bank of New York agree to repurchase USD 10 million worth of bonds in an overnight (Le., one day) repo trade so that the overnight repo rate is 1.5%/year Solution: Given our expression for the repo rate: Pi -Po 2. Use the November 15, 2017 U.S. Treasury quotes from the Wall Street Journal shown below to calculate the spot rate for each date given in the table. Solution: The discount factors are built successively as shown on slide 17 of lecture 0. The spot rates follow from the discount factors as shown in slide 18 of lkecture 9, Maturity Coupn Price Disount Factor Spot Rate 1 998125 1.25 99.6611 5/15/19 0.875 98.8672 1 98.6328 15 99.3828 1.75 99.8359 5/15/21 3.125 104.2266 2 100.2734 1.75 98.9844 11/15/22 .625 98.0391 050316 0.98428 0.97575 0.96673 0.95725 0.94739 0.93662 0.92586 0.91458 .90316 1.38 1.59 1.64 1.70 1.76 1.81 1.88 1.94 1.99 2.05 11/15/18 11/15/19 5/15/20 11/15/20 11/15/21 Coupon and spot rate i%/yeur, price as percent of par. 3. The current Fed Finds rate band is 1.25%/year - 1.50%/year. At what price would the Federal Reserve Bank of New York agree to repurchase USD 10 million worth of bonds in an overnight (Le., one day) repo trade so that the overnight repo rate is 1.5%/year Solution: Given our expression for the repo rate: Pi -Po