I need help with solving this using an Excel Formula.

Question 10, P6-20 (simil... Part 1 of 2 > HW Score: 88.64%, 48.75 of 55 points Points: 0 of 5 Save 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? % (Round to three decimal places) Get More Help Clear All Check Answer 11 Type here to search O RE - What is the yield to maturity of the August 2005 Treasury bond? % (Round to three decimal places.) Data Table Today is February 15, 2008 Price (per $100 par Issue Date Type Coupon Rate Maturity Date YTM cy value) 94.43 Bond Aug 2005 4.75% 8-15-2015 5.( Print Done Get More Help Clear All Check Answer A