please use spread sheet and show formulas

Price = $ 985.00 21 Since last coupor 81 18.00 Invoice Prices 1,003.00 Accu Interest -40 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Question 4 (20 points) Given the following data, using Excel formulas, calculate the YTM, all 4 years of YTC, YTW and Current Yield: FREE CALCULATION AREA BOND CONTRACTUAL INFO: Issuance Date 6/15/19 Face Value Per Bond= 1,000 Annual Coupon Payment $= $ 80.00 Term (years from Issuance) 10 Redemption value at Maturity %= 100 Coupon Pmts per year= 2 Call Price Provision ILE. ENTER 9/15/2018 Enter Dates 36 Call Price 37 Year Year 1 from Issuance Date= = Year 2 from Issuance Date 104 38 103 39 Year 3 from Issuance Date= 102 40 Year 4 from Issuance Date= 4 101 41 42 43 BOND TRADING INFORMATION: Trading Dates Monday, November 23, 2020 44 45 46 47 48 Settlement Date enter date i.e. 9/12/2020)= Current Market Price- 96.00 Enter Answers Enter Answers 49 YTM= YTC1- 50 YTW YTC2- 51 YTC3= 52 Current Yield = YTC4= 53 54 Question 5 (10 points) Price = $ 985.00 21 Since last coupor 81 18.00 Invoice Prices 1,003.00 Accu Interest -40 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Question 4 (20 points) Given the following data, using Excel formulas, calculate the YTM, all 4 years of YTC, YTW and Current Yield: FREE CALCULATION AREA BOND CONTRACTUAL INFO: Issuance Date 6/15/19 Face Value Per Bond= 1,000 Annual Coupon Payment $= $ 80.00 Term (years from Issuance) 10 Redemption value at Maturity %= 100 Coupon Pmts per year= 2 Call Price Provision ILE. ENTER 9/15/2018 Enter Dates 36 Call Price 37 Year Year 1 from Issuance Date= = Year 2 from Issuance Date 104 38 103 39 Year 3 from Issuance Date= 102 40 Year 4 from Issuance Date= 4 101 41 42 43 BOND TRADING INFORMATION: Trading Dates Monday, November 23, 2020 44 45 46 47 48 Settlement Date enter date i.e. 9/12/2020)= Current Market Price- 96.00 Enter Answers Enter Answers 49 YTM= YTC1- 50 YTW YTC2- 51 YTC3= 52 Current Yield = YTC4= 53 54 Question 5 (10 points)