how do i fill out the blank part with excel please using the formulas can the tutors put the result using excel as it shows on the picture. the redemption price of call is 100

B ormat Panier Formatting - Clipboard Alignment EX Future Value Coupon Rate Semiannual Coupon Payment Years to Maturity 1,000 6.50% 10.00 Market Rate 8% A) Fair Bond Value 0 2 B) Current Yield 3 14 C) Total Return 15 Bond Value in one Year 17 Capital Gains/Loss Yield (one year period) 18 Current Yield (from b) 19 Total Return 20 21 D) YTM 25 Future Value (includes call premium) 26 Semiannual Coupon Payment 27 Years to call 28 N 29 Bond Value (at time of purchase see a)) 31 E) YTC 33 34 F) If the market interest rates remain unchanged, do you think it is likely that the bond Student Into A to F G H Read CA 1 fe 17 Capital Gains/Loss Yield (one year period) 18 Current Yield (from b) 19 Total Return 21 D) YTM 25 Future Value (includes call premium) 26 Semiannual Coupon Payment 27 Years to call 28 N 29 Bond Value (at time of purchase see a)) 31 E) YTC 34 F) If the market interest rates remain unchanged, do you think it is likely that the bond 35 will be called in three years? Why or why not? B ormat Panier Formatting - Clipboard Alignment EX Future Value Coupon Rate Semiannual Coupon Payment Years to Maturity 1,000 6.50% 10.00 Market Rate 8% A) Fair Bond Value 0 2 B) Current Yield 3 14 C) Total Return 15 Bond Value in one Year 17 Capital Gains/Loss Yield (one year period) 18 Current Yield (from b) 19 Total Return 20 21 D) YTM 25 Future Value (includes call premium) 26 Semiannual Coupon Payment 27 Years to call 28 N 29 Bond Value (at time of purchase see a)) 31 E) YTC 33 34 F) If the market interest rates remain unchanged, do you think it is likely that the bond Student Into A to F G H Read CA 1 fe 17 Capital Gains/Loss Yield (one year period) 18 Current Yield (from b) 19 Total Return 21 D) YTM 25 Future Value (includes call premium) 26 Semiannual Coupon Payment 27 Years to call 28 N 29 Bond Value (at time of purchase see a)) 31 E) YTC 34 F) If the market interest rates remain unchanged, do you think it is likely that the bond 35 will be called in three years? Why or why not