please use excel or formula to calculate it.

Bond prices and maturity dates. Les Company is about to issue a bond with annual coupon payments, an annual coupon rate of 9%, and a par value of $5,000. The yield to maturity for this bond is 7%. a. What is the price of the bond if it matures in 15, 20, 25, or 30 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 15 years? $ (Round to the nearest cent.) What is the price of the bond if it matures in 20 years? (Round to the nearest cent.) What is the price of the bond if it matures in 25 years? (Round to the nearest cent.) What is the price of the bond if it matures in 30 years? (Round to the nearest cent.) b. What do you notice about the price of the bond in relationship to the maturity of the bond? (Select the best response.) O A. As the time to maturity increases, the price of the bond decreases first and then increases. O B. As the time to maturity increases, the price of the bond increases first and then decreases. OC. As the time to maturity increases, the price of the bond increases. D. As the time to maturity increases, the price of the bond decreases