The following answer the next question Assume that both bonds have a dollar face value of $1,000, but quotes are on the basis of 100 SYNOVUS FINL CORP Bond Center OVERVIEW Price Coupon (%) Maturity Date Yield to Mat (%) Current Yield (%) Fitch Ratings Coupon Payment Freq Callable GE CAPITAL INTERNOTES 102.62 4.750 15-May-2015 ? 5.125 15-Jun-2017 6.490 5.511 B Semi-Annual No 4.629 AA Semi-Annual Yes Q5. Calculate the yield-to-maturity (YTM) on the GE Capital loternetes bond assuming that it matures in 4.275 years. Place the appropriate values in the proper cells in row 19, given the columns as provided below. Provide the EXACT Excel function using cell references throughout. F Row Number 17 18 19 A Q5. B GE Capital #Yrs Column D Coupon Bond YTM Ann Rate PV E Con Rate PMT m FV EXACT Coupon Payment EXCEL EQUATION: EXACT YTM EXCEL FUNCTION: I The following answer the next question Assume that both bonds have a dollar face value of $1,000, but quotes are on the basis of 100 SYNOVUS FINL CORP Bond Center OVERVIEW Price Coupon (%) Maturity Date Yield to Mat (%) Current Yield (%) Fitch Ratings Coupon Payment Freq Callable GE CAPITAL INTERNOTES 102.62 4.750 15-May-2015 ? 5.125 15-Jun-2017 6.490 5.511 B Semi-Annual No 4.629 AA Semi-Annual Yes Q5. Calculate the yield-to-maturity (YTM) on the GE Capital loternetes bond assuming that it matures in 4.275 years. Place the appropriate values in the proper cells in row 19, given the columns as provided below. Provide the EXACT Excel function using cell references throughout. F Row Number 17 18 19 A Q5. B GE Capital #Yrs Column D Coupon Bond YTM Ann Rate PV E Con Rate PMT m FV EXACT Coupon Payment EXCEL EQUATION: EXACT YTM EXCEL FUNCTION