please provide excel calculation

required rate of retum on securities of similar-tiak gacle is 6.76%. Given Data secrion. Io I)0 a. What is the value of this corporate botid today? b. What is the cisrent yield for the JRW Wond? c. In the case of the H\&W bond fros question a, if the bond makes coupon pryments semiannally, what would be the value of this securty 10dx ? d. How would the price of the H\&W bend react to changing market anterest rater? To find oit, determine how the jrice of the issee reacts to ehangis ar the bend's yicit to matirity. Find the valse of the security when the YTM is (1) 5.625%6,(2)8.0%, and (3) 4.595. Label your findines as beins a peeminth, par, or diseouat bont. c. The Jay \& Austin Company has a bond issue outstanding with the following characteristics par of $1,000, a semianusal-pay coupon of 6 . 54 , tenuaing maturing of 22 years, aad a current price of 5878.74. What is the bond's YTM? a. What th the salae of this corporate boed todyy? Asuntal coupod payment Value of the bond b. What is the current yield for the H\&W bond? Current yitil years, and a curreat price of 5978,74 . What is the bond' YTM