please help gow to do thi on excel and please try to do it clear and show how you got everything and do it on excel please!!

thank you a lot

-Show all your work. No credit will be given for answers (even correct answers) if the work is not shown -If you use Excel, I will not accept answers that are not accompanied by the detailed work associated with them (so no use of Excel functions except you may use =SQRT to find the square root of the variance) For Problems #1 and #2 you only need to write in the discount formula once (on the first line) - IF YOU COMPLETE THE EXAM IN EXCEL SUBMIT THE FILE IN EXCEL FORMAT IF YOU COMPLETE THE EXAM BY HAND YOU MAY SUBMIT IT HANDWRITTEN, BUT BE SURE TO SHOW ALL OF YOUR WORK INCLUDING FORMULAS YOU ARE USING Problem #2 UST 10 Year bond matures on May 13, 2023 Coupon (contractual) interest rate on Bond is 4 % The bond pays interest semi-annually Face (par) value of the bond is $10,000 If the current UST 2 year market rate is 1%., what is the current market value of this bond? Period PV FV Discount Factor Discount Formula Total