I understand how to figure out the below answer manually, but am trying to accomplish the same calculations in excel to do them faster, but cannot formulate the calculations from the information given. can someone explain/demonstrate how to answer this kind of problem in excel?

A General Power bond carries a coupon rate of 9.9%, has 9 years until maturity, and sells at a yield to maturity of 8.9%. (Assume annual interest payments.)

a.What interest payments do bondholders receive each year?

b.At what price does the bond sell?

c.What will happen to the bond price if the yield to maturity falls to 7.9%?