f. Now assume the date is 10/25/2014. Assume further that a 12%, 10-year bond was issued on 7/1/2014, pays interest semiannually (January 1 and July 1), and sells for $1,100. Use your spreadsheet to find the bond's yield 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: Basic info: Settlement (today) Maturity Coupon rate Current price (% of par) Redemption (% of par value) Frequency (or semiannual) Basis (360 or 365 day year) Call date Call price Yileld to Maturity:Hint Use the Yield function For dates, elther refer to cells D122 and D123, or enter the date in quotes, such as "10/252014 To find the yield to call, use the YIELD function, but with the call price rather than par value as the redemption Yield to call You could also use Excel's "Price" function to find the value of a bond between interest payment dates