please answer using excel.

YIELD TO MATURITY Heymann Company bonds have 4 years left to maturity. Interest is paid annually, and the bonds have a $1,000 par value and a coupon rate of 9%. a. What is the yield to maturity at a current market price of (1) $829 and (2) $1,104? b. Would you pay $829 for each bond if you thought that a "fair" market interest rate for such bonds was 12%that is, if ra = 12%? Explain your answer. PRICE AND YIELD An 8% semiannual coupon bond matures in 5 years. The bond has a face value of $1,000 and a current yield of 8.21%. What are the bond's price and YTM? (Hint: Refer to footnote 7 for the definition of the current yield and to Table 7.1.)