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) 6.600 Jan 15, 2032 94.303 ?? 57,374 Kenny Corp. (KCC) 7.240 Jan 15, 2031 ?? 5.38 48,953 Williams Co. (WICO) ?? Jan 15, 2038 94.855 7.08 43,814
What price would you expect to pay for the Kenny Corp. bond? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Price $
What is the bond’s current yield? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Current yield %
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
As nothing was mentioned excel is used. If you need with financial formula, let me know, will do that also. Thank you.