please use Excel

Egis Securities, Inc. provides financial analysis and information about publicly traded securities. You work as an analyst for Egis. The firm's owner, George Stein, is preparing to make a presentation to the firm's clients and has asked you to provide some input regarding the securities of KLX, a publically traded company. To simplify calculations, assume that it currently is January 1, 2017. Regarding KLX's existing bonds, George wants you to concentrate on the mortgage bonds in the Table below. These bonds were issued at different times but each one of them had 20 ycars to maturity when first issued. This suggests that, for example, bond III was issued in 2012. KLX's bonds pay interest semiannually, and each bond has a par value of $1000. Table Years to Maturity* 10 15 Bond Price per bond Coupon Rate Maturity Year 930.52 1108.08 3.75% 6.50 9.25 2022 2027 2032 As of January 1, 2017