Using Excel, calculate the yield to maturity of a 7-year $1,000 par value bond with a fixed annual coupon rate of 6.6250% and a current price of $920.00. Provide the solutions for both annual and semi-annual payments of interest. Comment on the relationship between the yield to maturity and the frequency of interest payments, providing an appropriate table or graph.