need an explanatjon in excel and formulas for it

on problem 4

insert Draw Design Layout References Mailings Review Palatino 12 - A- A AX- B be XX START USING BLUE BOOK #2 1 4. Bond Valuation (17 points) I These are the bond quotations for three companies. Assume each bond has a $1,000 par value and issues semi-annual payments. Assume that today is January 15, 2016.1 Company Coupon Maturity Last Last Estimate Price: Yield Trade Volume ($,000) 5.400 Jan. 15, 2020 96.153A ?? 57,362 Xenon, Inc. Kenny Corp. 7.125 Jan. 15, 2021?? 6.0248,9419 Williams Co. ?? Jan 15, 2028 94.735 6.85% 43,802 a. What is the Yield to Maturity (YTM) of the bond issued by Xenon, Inc...29 b. What price would you expect to pay for the Kenny Corp. bond...21 c. What is the current yield of the Kenny Corp. bond...?! d. What is the coupon rate for the Williams Co. bond...? 5. Stock Valuation (17 points) Burton Corp. is growing quickly. Dividends are expected to grow at a rate of 25 percent for the next three years, with the growth rate falling 1100 Forus 20