please answer and explanations( if you can please use excel)

HMK Enterprises would like to raise $11 million to invest in capital expenditures. The company plans to issue five-year bonds with a face value of $1,000 and a coupon rate of 8.7% (annual payments). The following table summarizes the yield to maturity for five-year (annual-pay) coupon corporate bonds of various ratings. . BBB Rating YTM (%) AAA 8.1 BB 9.3 8.3 8.7 8.9 a. Assuming the bonds will be rated AA, what will the price of the AA-rated bonds be? b. How much total principal amount of these bonds must HMK issue to raise $11 million today, assuming the bonds are AA rated? (Because HMK cannot issue a fraction of a bond, assume all fractions are rounded to the nearest whole number.) c. What must the rating of the bonds be for them to sell at par? d. Suppose that when the bonds are issued, the price of each bond is $976.84. What is the likely rating of the bonds? Are they junk bonds? Note: Assume annual compounding. a. Assuming the bonds will be rated AA, what will the price of the AA-rated bonds be? The price of the bonds will be $ . (Round to the nearest cent.) b. How much total principal amount of these bonds must HMK issue to raise $11 million today, assuming the bonds are AA rated? (Because HMK cannot issue a fraction of a bond, assume all fractions are rounded to the nearest whole number.) Total principal necessary to raise $11 million is $ (Round to the nearest dollar.) c. What must the rating of the bonds be for them to sell at par? (Select the best choice below.) A. BBB O B. BB O C. AA