H19 X fx ESEF 1 Given the following... Show in excel what happens when the bond is sold at par value. 2 Face Value $2,000 3 Yearly Interest Rate 10% 4 Coupon Rate 5% 5 Frequency of Payments Semi-Annual 6 Payments/year 7 Number of Payments 8 Maturity Date 1-Jul-50 9 a. Show how the order of YTM, Coupon rate and Current Yield changes when the bond is sold at a discount. 10 b. Show how the order of YTM, Coupon rate and Current Yield changes when the bond is sold at a premium. 11 c. Show what happens when the bond is sold at par value. 12 13 Price @ Jul-01-2020 14 YTM (function) 15 Current Yield 16 Coupon Rate