Please show all work in excel, thanks!

A bond with face value $1,000 has a current yield of 6.4% and a coupon rate of 8.4%. a. If interest is paid annually, what is the bond's price? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. b. If the bond is selling at $966, is its yield to maturity more or less than 8.4%