Consider that you have all the data you need to calculate the yield on a fixed income security: Hint: Enter value rounded to two decimal places. 1 2 3 4 5 6 7 8 9 10 A Data Settlement date of the bond sale Maturity date of the bond Rate at which coupons will be paid Price you paid for the bond per $100 face value Redemption value Frequency of coupon payments Basis YIELD B Description August 15, 2013 July 15, 2018 4.2% $97.25 $100 2 0 = YIELD(B2, B3, B4, B5, B6, B7, B8) = % Suppose you did not have data for price an investor paid for the bond but you knew that the bond generated a yield of 5%. C would pay on the bond using the corresponding function.

Consider that you have all the data you need to calculate the yield on a fixed income security: Hint: Enter value rounded to two decimal places. Suppose you did not have data for price an investor paid for the bond but you knew that the bond generated a yield of 5%. would pay on the bond using the corresponding function