how do I solve this problem while using excel?

c Understanding the yield to maturity and its relationship to the coupon of a bond. What is the coupon rate for a bond with 4 years to maturity, a price of a yield to maturity of 3.1% 1,000 and 1,000 4 3.1% Current market price Term to maturity= Yield to maturity= Annuity factors PV face value= Annual coupons Coupon rate= d Understanding the effect of semi-annual coupon payments. What is the yield to maturity for a bond with a coupon rate of a current price of 975, with 3 4.3% semi-annual coupon payments, years to maturity? 975 4.3% Period Current price Annual coupon rate= Semi-annual coupon rate= Annual coupons Semi-annual coupon= Annual term to maturity= Semi-annual term to maturity= Cash Flows 0 1 2 3 4 5 3 years half years Yield to maturity (YTM)=