Please solve for the empty highlighted boxes. Add the calculations you entered in the excel cells, to receive the answers. (#6-10 for cells F9-11, weren't able to fit in this photo.)(For cell I4, it says "Note, in the final period, you also get the call price ($1040) in addition to the coupon)

C D G H Instructions: 1) Solve for the Yield to Maturity (YTM) in cell C17. 2) Solve for the Yield to Maturity (YTC) in cell C18. 3) Use the YTM and YTC to calculate the Discount Factors in rows 10 and 16, respectively. 4) Apply the Discount Factor to the Cash Flow. Solve for the Yield using the following data: Frequency Sem If Held to Maturity Coupon 7% Cash Flow (coupon payment) 10 Maturity 5 Discount Factor = 1/(1+YTM/2)' 11 Par Value 1,000 PV of CF = CF x DF 12 Current Price 1,047 PV if held to Maturity S 13 Call Price 1,040 14 Years til Call If Called 15 Cash Flow (coupon payment) Note: In final p 16 use =rate(...)* Discount Factor = 1/(1+YTC/2)' 17 Yield to Maturity PV of CF = CF x DF 18 Yield to Call PV if called S 19 "don't forget to x2 20 21