hi pleasw do thia on excel and clear filling out the blenk spots thank you a lot

D -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 W 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