create a spreadsheet to model and answer the following bond valuation questions.

A) one of the bond issues outstanding by H&W Corporation has an annual-pay coupon of 5.625% plus a par value of $1000 at maturity. This bond has a remaining maturity of 23 years. The required rate of return on securities of similar-risk grade is 6.76%. What is the value of this corporate bond?

CHAPTER 11 | BOND VALUATION b. What is the current yield for the H&W bond? c. In the case of the H&W bond issue from question a, if the coupon interest payment is com- pounded on a semiannual basis, what would be the value of this security today? d. How would the price of the H&W bond react to changing market interest rates? To find out, determine how the price of the issue reacts to changes in the bond's yield-to-maturity (YTM). Find the value of the security when the YTM is (1) 5.625%, (2) 8.0%, and (3) 4.5%. Label your findings as being a premium, par, or discount bond; comment on your findings. e. The Jay & Austin Company has a bond issue outstanding with the following characteristics: par of $1,000, a semiannual-pay coupon of 6.5%, remaining maturity of 22 years, and a cur- rent price of $878.74. What is the bond's yield-to-maturity (YTM)