How would I work this out in Excel?

c Understanding the yield to maturity and its relationship to the coupon of a bond. 4 years to maturity, a price of 1,000 What is the coupon rate for a bond with a yield to maturity of 3.1% and 1,000 4 3.1% Current market price= Term to maturity= Yield to maturity= Annuity factors PV face value= Annual coupon Coupon rate=1 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 years half years O WON 4 5 Yield to maturity (YTM)=