please show work on excel

NAME 1 N 2 3 3 5 KO is planning to sell a bond that he wwwns. This bond has four years to maturity and pays a coupon of 10 percent on a semiannual basis. Similat bonds in the current market have a yield to maturity of 12 percent. What will be the price that he will get for his boed? (Do not round intermediate computations, Round your final answer to the A) $1,044 B) C) 5970 D) $1,102 $938 SHOW YOU CALCULATIONS. DO YOUR CALCULATIONS IN EXCEL