Question

You find the following corporate bond quotes. To calculate the number of years until maturity, assume that it is currently January 15, 2019 and the bonds have a par value of $2,000. Last Price 94.213 Company (Ticker) Coupon Xenon, Inc. (XIC) 5.700 Kenny Corp. (KCC) 7150 Williams Co. (WICO) ?? Yield Maturity Jan 15, 2026 Jan 15, 2023 Jan 15, 2029 EST $ Vol (000's) 57,365 48.944 43,805 ?? 96.765 6.08 .33 6 What is the coupon rate for the Williams Co. bond? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Coupon rate

Answer 1

Case 1:
Assuming semi annual coupons
=PMT(6.33%/2,2*10,-96.765,100)*2/100
=5.89%

Case 2:
Assuming annual coupons
=PMT(6.33%,10,-96.765,100)/100
=5.88%