ABC Industrial previously issued two bonds (Bond A and Bond B), both have 10 years to maturity and a face value of $1000. Coupon payments are made bi-annually (every two years) and a coupon payment was just made for both bonds. Bond A pays coupon payments of $100 and Bond B pays coupon payments of $150. ABC Industrial just issued a new bond (Bond C) at par value with ten years to maturity, a face value of $1000 and a coupon rate of 12% APR with semi-annual compounding. Coupon payments are made semi-annually for Bond C.

The effective annual rate for Bond B is?

The effective bi-annual rate for Bond B is?

*Please show the formula for excel