please use excel and the formulas used

31. HMK Enterprises would like to raise $10 to issue five-year bonds with a face v to raise $10 million to invest in capital expenditures. The company plans year bonds with a face value of $1000 and a coupon rate of 6.5% (annual payments). The following table summarizes the yield to matury coupon corporate bonds of various ratings: summarizes the yield to maturity for five-year (annual-pay AAA AA BBB Rating BB YTM 6.00% 6.20% 6.50% 7.00% 7.50% a. Assuming the bonds will be rated AA. what will the price of the bonds be w much total principal amount of these bonds must HMK issue to raise $10 min assuming the bonds are AA rated? (Because HMK cannot issue a fraction of a bond, as that all fractions are rounded to the nearest whole number.) C. What must the rating of the bonds be for them to sell at par? u suppose that when the bonds are issued, the price of each bond is $1,012.57. What is the ke rating of the bonds? Are they junk bonds