please use formula or excel formula. explain me as much possible please

Treasury notes and bonds. Use the information in the following table: Assume a $100,000 par value. What is the yield to maturity of the August 2005 Treasury bond with semiannual payment? Compare the yield to maturity and the current yield. How do you explain this relationship? What is the yield to maturity of the August 2005 Treasury bond? 3.819 % (Round to three decimal places.) Compare the yield to maturity and the current yield. How do you explain this relationship? (Select the best response.) O A. If a bond sells for its par value, the yield to maturity is greater than the current yield. B. There is no certain relationship between the yield to maturity and the current yield. C. If a bond sells at a discount, the yield to maturity is greater than the current yield. D. If a bond sells at a premium, the yield to maturity is greater than the current yield. Data Table - X (Click on the following icon in order to copy its contents into a spreadsheet.) Today is February 15, 2008 Price (per Issue Type $100 par Date value) Bond Aug 2005 97.37 Coupon Rate Maturity Date YTM Current Yield Rating 3.50% 8-15-2015 3.595% AAA Print Done