Fill in the blanks with the correct excel formula for Bond Valuation.

B C 1,000 6.50% 10.00 8% A 1 Future Value 2 Coupon Rate 3 Semiannual Coupon Payment 4 Years to Maturity 5 N 6 Market Rate 7 8 9 A) Fair Bond Value 10 11 12 B) Current Yield 13 14 C) Total Return 15 Bond Value in one Year 16 17 Capital Gains/Loss Yield (one year period) 18 Current Yield (from b) 19 Total Return 20 21 D) YTM 22 23 24 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)) 30 31 E) YTC 32 33 3