How would you calculate these using excel? What are the formulas?

Question 1. GTF Corporation has 5 percent coupon bonds on the market with a par of S1,000 and 15 years left to maturity. The bonds make annual interest payments. If the market interest rate on these bonds is 6 percent, what is the current bond price? Question 2. MTV Corporation has 6 percent coupon bonds on the market with a par o $1,000 and 8 years left to maturity. The bonds make semi-annual interest payments. If the market interest rate on these bonds is 5 percent, what is the current bond price? ann Question 3. Jones Corporation has zefo coupon bonds on the market with a par of $1,000 and 10 years left to maturity. If the market interest rate on these bonds is 6 percent, what is the current bond price? (Use the semi-annual interest payment model.) Question 4. Wilson Corporation has 5 percent coupon bonds on the market with a par of $1,000 and 10 years left to maturity. The bonds make annual interest payments. If these bonds currently sell for $800, what is its yield to maturity (YTM)? Question 5. Linville Corporation issued 15-year, par $1,000 bonds ten years ago at a coupon rate of 6 percent. The bonds make semi-annualpayments. If these bonds currently sell for 90 percent of par value, what is its yield to maturity (YTM)? Question 6. Pecos Company has just issued a 10-year, 9 percent coupon rate, $1,000- par bond that pays interest semiannually. Three years later, if the going rate of interest on the bond falls to 8 percent, what is the value of the bond? Question 7. Karen just bought a 10-year, 5% coupon bond with $1,000 par for $825. If she sells this bond three years later for $950, what is the realized yield per year for her 3 year holding (with semi-annual interests)