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.363 Last Yield Company (Ticker) Coupon Xenon, Inc. (XIC) 7.200 Kenny Corp. (KCC) 7.300 Williams Co. (WICO) ?? Maturity Jan 15, 2041 Jan 15, 2038 Jan 15, 2044 EST $ Vol (000's) 57,380 48,959 43,820 ?? 96.915 6 6.38 .63 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

Here coupon payment frequency is not given

CASE 1: ASSUMING SEMIANNUAL COUPONS
=PMT(6.63%/2,(2044-2019)*2,-96.915,100)*2/100
=6.37566%

CASE 2: ASSUMING ANNUAL COUPONS
=PMT(6.63%,(2044-2019),-96.915,100)/100
=6.37404%