MUST BE ANSWERED USING EXCEL!!! I will happily up vote if the answer is detailed and ONLY IF IT IS DONE USING EXCEL!!!! Please explain if possible.

5. A bond's credit rating provides a guide to its price. Assume Aaa bonds yield 3.7% and Baa bonds yield 4.7%. Assume a 10% five-year bond with annual coupons and a face value of $1,000. a) What is the bond's price if it is rated as Aaa? b) What is the bond's price if it is rated as Baa