Just need the Excel formula and answers thanks!

1. Hamilton, Inc. bonds have an 8 percent coupon rate. The interest is paid semiannually, and the bonds mature in 5 years. Their par value is $1,000.

a. If your required rate of return is 10 percent, what is the value of the bond?

b. If your required rate of return is 10 percent and interest is paid annually, what is the value of the bond?

2. ABC bonds have an annual coupon rate of 8 percent and a par value of $800 and will mature in 20 years. If you require a return of 7.25 percent, what price would you be willing to pay for the bond? What happens if you pay more for the bond? What happens if you pay less for the bond?

3. You own a bond that pays $55 in annual interest, with a $1,000 par value.It matures in 17 years and your required rate of return is 7 percent.What is the value of the bond?

4. XYZ Corp plans on issuing bonds that pay no interest but can be converted into $2,200 (you receive when bond matures), 12 years from their purchase. It is determined that they should yield 6.5%, compounded annually.What price should XYZ Corp sell the bonds?