Claire’s issued a 7 year, 6.125% coupon bond with a $100 par value in January 2013 that matures in January 2020. The table below has the price of the bond when issued and for the past four Januaries. Determine the yield to maturity for each of the dates.

If an investor bought this bond January 2015 and sold it in January 2017 (receiving two coupon payment) what would be the return on investment?

Price Jan-13 $100.00

Jan-14 $70.00

Jan-15 $30.00

Jan-16 $17.50

Jan-17 $50.00

If you can use excel that would be much appreciated!