Now assume the date is 10/25/2014. Assume further that a 12%, 10-year bond was issued on 7/1/2014, pays interest semiannual (January 1 and July 1), and sells for $1, 100. Use your spreadsheet to find the bond's Refer to this chapter's Tool Kit for information about how to use Excel's bond valuation functions. The model finds the price of a bond, but the procedures for finding the yield are similar. Begin by setting up the input data as shown below: Now assume the date is 10/25/2014. Assume further that a 12%, 10-year bond was issued on 7/1/2014, pays interest semiannual (January 1 and July 1), and sells for $1, 100. Use your spreadsheet to find the bond's Refer to this chapter's Tool Kit for information about how to use Excel's bond valuation functions. The model finds the price of a bond, but the procedures for finding the yield are similar. Begin by setting up the input data as shown below