Help for these questions, step by step. Use excel please.

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 years to KLX's maturity when first issued. This suggests that, for example, bond III was issued in 2012. bonds pay interest semiannually, and each bond has a par value of $1000. Table Coupon Rate Years to Maturity BondPrice per bond Maturity Year 930.52 1108.08 3.75% 6.50 9.25 2022 2027 2032 10 15 As of January 1, 2017. Given the above information, George asked you to calculate: The nominal annual yield to maturity (YTM) of each bond .The effective annual YTM of each bond .The current yield of each bond . The expected price of each bond on January 1, 2018, assuming interest rates do not change . The capital gains (losses) yield of each bond for 2017, assuming interest rates do not change . The total expected return of each bond for 2017, assuming interest rates do not change .The interest rate risk of each bond (George has asked you tabulate and graph your results) .The 3-year holding period return of each bond for an investor who buys the bond orn January 1, 2019 and reinvests all coupon interest payments at 3% until the end of the 3- year investment horizon, assuming bond yields have dropped to 7.2% at the end of the 3- year holding period The yield to call for bond II, assuming it can be called after 4 years at $1050. From past experience George knows that attendees raise several questions during his presentations. So, once he reviewed your calculations, George asked you to prepare answers to the following questions