hi can you resolve this for me please all i need here is the formula that you will use on excel. the formulatext so that is can do it myself

Quection 2 (35 pountr) Grven the information below for Bond A and Bood B, do the following questices and dusplay formalw usad (1) Calculate coupos amount and beod price for Hood A and Boond B. (10 pouits) (4) Whach bond has geater interet rate rekk and wby? Answer thas pat in the given lexa box (5 pointi) Quetion 2 (35 pount) Grven the information below for Bood A and Bood B; do the following questionir and display formalis used (1) Calculate coopon amoust and bond price for Bond A and H ond B (10 points) (2) Calculae the Macaulay duration for Bond A usine tho "strp-by-step" maethod and the Macarlay buration for Besd B uring the Ercel built-in functioo (10 pounte) (4) Which boed has gieater inerest rate rek and why? Answer this part in the priven lext bok. (5 poins) Quection 2 (35 pountr) Grven the information below for Bond A and Bood B, do the following questices and dusplay formalw usad (1) Calculate coupos amount and beod price for Hood A and Boond B. (10 pouits) (4) Whach bond has geater interet rate rekk and wby? Answer thas pat in the given lexa box (5 pointi) Quetion 2 (35 pount) Grven the information below for Bood A and Bood B; do the following questionir and display formalis used (1) Calculate coopon amoust and bond price for Bond A and H ond B (10 points) (2) Calculae the Macaulay duration for Bond A usine tho "strp-by-step" maethod and the Macarlay buration for Besd B uring the Ercel built-in functioo (10 pounte) (4) Which boed has gieater inerest rate rek and why? Answer this part in the priven lext bok. (5 poins)