Please answer parts A AND B. Show work in excel.

Bond prices and maturity dates. Moore Company is about to issue a bond with semiannual coupon payments, an annual coupon rate of 8%, and a par value of $5,000. The yield to maturity for this bond is 11%. a. What is the price of the bond if it matures in 10,15,20, or 25 years? b. What do you notice about the price of the bond in relationship to the maturity of the bond? a. What is the price of the bond if it matures in 10 years? (Round to the nearest cent) What is the price of the bond if it matures in 15 years? (Round to the nearest cent.)