10 What is the YTM of a $100 face value 15-year bond paying 7.5% annual coupons and priced at 102.45? Use either the YIELD or the IRR function in Excel. Bond data Years to maturity Settlement date Maturity date Coupon Frequency Face value Face Price Price Yield (Excel YIELD function) 15 1/1/2016 1/1/2031 7.5% 1 $100 $102.45 7.23% Using Excel IRR Function 14 Year Cash flows 0 $7.50 1 $7.50 2 $7.50 3 $7.50 4 $7.50 5 $7.50 6 $7.50 7 $7.50 8 $7.50 9 $7.50 10 $7.50 11 $7.50 12 $7.50 13 $7.50 15 $7.50 $7.50 IRR #NUM! 10 What is the YTM of a $100 face value 15-year bond paying 7.5% annual coupons and priced at 102.45? Use either the YIELD or the IRR function in Excel. Bond data Years to maturity Settlement date Maturity date Coupon Frequency Face value Face Price Price Yield (Excel YIELD function) 15 1/1/2016 1/1/2031 7.5% 1 $100 $102.45 7.23% Using Excel IRR Function 14 Year Cash flows 0 $7.50 1 $7.50 2 $7.50 3 $7.50 4 $7.50 5 $7.50 6 $7.50 7 $7.50 8 $7.50 9 $7.50 10 $7.50 11 $7.50 12 $7.50 13 $7.50 15 $7.50 $7.50 IRR #NUM