Fill in the orange blanks with correct excel formula to get Bond Valuation.

B A 1 2 Purchase Date 3 Maturity Date 4 Call Date 5 Coupon Rate 6 Market Rate 7 8 Redemption Value 9 Note: Semiannual Coupon paymei 7/30/2019 7/30/2029 7/30/2022 6.50% 8% 100 2. 10 11 Call Value 103 12 GIA) Fair Bond Value 13 G/D) YTM 14 G/E) YTC 15