Watters Umbrella Corp. issued 15-year bond two years ago at a coupon rate of 6.8 percent. The bonds make semi annual payments.
What is the bonds price per $100 face value?
If these bonds currently sell for 105 percent of par value, what is the YTM?
Please explain how to setup in Microsoft Excel formula or format?