Given a series of semi annual paying bonds, all having a coupon rate of 5% and a face value of $1000. When the yield to maturity increases from 7% to 10%, which one of the following bonds will exhibit the largest decrease in price. Show excel formula for answer

Options:

Bonds with 10 years to maturity

Bond with 3 years to maturity

Bond with 20 years to maturity

Bond with 5 years to maturity