I am having trouble getting to understand these questions of this problem situation case. I am currently working with an excel worksheet to get the answers but, if prefer to work with the formulas I am ok with, as long as it is clear for me to actually understand what calculation are being made and why. Thank you for the help. A great answer that is clear and easy to understand I will thumbs up and leave a comment.

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,2018 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 maturity when first issued. This suggests that, for example, bond III was issued in 2013. KLX's bonds pay interest semiannually, and each bond has a par value of $1000 Table Coupon Rate Price per bond Maturity Year Years to Maturity* Bond S 825.00 930.52 1108.08 3.75% 6.50 9.25 2023 2028 2033 10 15 *As of January 1, 2018