I need help with question #2. The input needs to be in the yellow spaces

HW-session7-Ch10Bonds-stu-2020 Q Search Sheet Home Insert Page Layout Formulas Data Review View 9+ Share Cut AutoSum Calibri (Body) 11 A- A- Wrap Text General 49 Copy Fill Paste Merge & Center $ % ) .00 2.0 .00 Insert Format Delete Sort & Format Conditional Format Formatting as Table Cell Styles Clear Filter K18 x fx B D E F G H 1 K Asked Yield Maturity Chg Coupon Bid 6/30/29 5.000 101.0134 Asked 101.0145 n/a 20 21 22 #2 23 24 25 26 26 27 27 20 28 Here is a T-bond listing in the form of the wsj.com listings we saw in the videos. You are going to find the Asked Yield here. Assume that today (the date of the information in the listing) is June 30, 2020 a) In what months does this bond pay coupons? 29 30 b) How many coupon periods remain to be paid? 31 DODON c) At what price would an investor have purchased this bond? d) What is the semi-annual coupon payment? 32 33 34 35 36 37 38 29 e) Find the ytm using your bond pricing techniques of Ch 10! Sheet1 + Ready + 100% HW-session7-Ch10Bonds-stu-2020 Q Search Sheet Home Insert Page Layout Formulas Data Review View 9+ Share Cut AutoSum Calibri (Body) 11 A- A- Wrap Text General 49 Copy Fill Paste Merge & Center $ % ) .00 2.0 .00 Insert Format Delete Sort & Format Conditional Format Formatting as Table Cell Styles Clear Filter K18 x fx B D E F G H 1 K Asked Yield Maturity Chg Coupon Bid 6/30/29 5.000 101.0134 Asked 101.0145 n/a 20 21 22 #2 23 24 25 26 26 27 27 20 28 Here is a T-bond listing in the form of the wsj.com listings we saw in the videos. You are going to find the Asked Yield here. Assume that today (the date of the information in the listing) is June 30, 2020 a) In what months does this bond pay coupons? 29 30 b) How many coupon periods remain to be paid? 31 DODON c) At what price would an investor have purchased this bond? d) What is the semi-annual coupon payment? 32 33 34 35 36 37 38 29 e) Find the ytm using your bond pricing techniques of Ch 10! Sheet1 + Ready + 100%