Please help with Excel

A Cameron Corp. bond has a $1,000 par value, a 5 percent coupon rate paid semiannually, and nine years until maturity. If similar investments yield 6%, what is the current value of Cameron Corp. bonds?

McLaren Motors just issued a series of $1,000.00 bonds with a 10-year maturity and an 8% coupon rate, paid quarterly. If you purchase a McLaren bond at a price of $920.00, what is your required rate of return?

Three years ago, Petty Partners Inc. issued 15-year, $1,000 bonds that are currently priced at $911.37. If the prevailing rate of return on similar investments is 5%, what is the coupon rate on Petty Partners bonds, and what is the annual interest payment?