In: Finance
You find the following corporate bond quotes. To calculate the number of years until maturity, assume that it is currently January 15, 2016. The bonds have a par value of $2,000. Company (Ticker) Coupon Maturity Last Price Last Yield EST $ Vol (000’s) Xenon, Inc. (XIC) 5.600 Jan 15, 2022 94.203 ?? 57,364 Kenny Corp. (KCC) 7.140 Jan 15, 2021 ?? 5.18 48,943 Williams Co. (WICO) ?? Jan 15, 2028 94.755 6.88 43,804
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -