1. Terrapins has a bond issue outstanding with 9 years remaining to maturity, a coupon rate of 10% with interest paid semi-annually, and a par value of $1,000. If the current market price of the bond issue is $814.45, what is the yield to maturity?

2. What is the price of a bond with a coupon rate of 4.50%, a yield to maturity of 4.25%, a future value of $1000, semi-annual coupon payments, and 9 years until maturity?

3. What is the coupon rate on a bond with a par value of $1,000, semi-annual coupons, 8 years until maturity, yield to maturity of 8.50 %, and price of $925.64?

Please show all excel formula