How can this be done in excell please provide steps!

2) As an investor, you are considering buying a bond that pays 7% semiannual coupon. This bond has a $10,000 face value and will mature in 25 years. If your required rate of return is 5.8% for bonds in this risk class, what is the highest price you would be willing to pay? 3 Assuming required rate of return remains at 5.8%. What would you expect the price of his bond to be in 4 years