hi please help me on thjs and if you do it in excel to send me all the steps

The Course Male -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 #1 UST 30 Year bond matures on May 13, 2025 Coupon (contractual) interest rate on Bond is 6% The bond pays interest semi-annually Face (par) value of the bond is $20,000 If the current UST 4 year market rate is 2%., What is the current market value of this bond? Period PV FV Discount Factor Discount Formula Total