I need to know the formula to use in excel.

Chapter6 What is the bond quote for a $1,000 face value bond with an 8 percent coupon rate (paid semiannually) anda required return of 7.5 percent, if the bond is 6.48574, 8.47148, 10.519, and 14.87875 years from maturity? Select the red highlighted items below for tips and suggestions to complete this problem Enter today's date to use as the bond's settlement date Years from Maturit Bond Value FUNCTION Percent of Maturity Annual Coupon Required=> Date 04/06/24 03/22/26 03/28/28 07/15/32 Payment (% 5% 6% 8% 6% Face Value Retur 100 100 100 100 6.48574 8.47148 10.51900 14.87875 Bond value 102-17% Bond value = 103.03% Bond value = 103-1996 Bond value = 104-14% For help with the PRICE unction click here 759 5% 759