Implement your formulation in Excel and show formula used

Given the following data, calculate the YTM, all 4 years of YTC, YTW and Current Yield: INPUT Issuance Date= Settlement Date= Maturity Date= Current Market Price= Coupon Rate= Redemption value at Maturity %= Coupon Pmts per year= 6/11/17 11/1/18 6/11/27 95 7.500% 100 2 ANSWERS YTM= Call Price Provision (I.E. EN TER 9/15/2018) INPUT Year Call Price Dates YTC One year from Issuance Date= 104 Two years from Issuance Date= 103 Three years from Issuance Date= 102 Four years from Issuance Date= 101 YTW = Current Yield = Given the following data, calculate the YTM, all 4 years of YTC, YTW and Current Yield: INPUT Issuance Date= Settlement Date= Maturity Date= Current Market Price= Coupon Rate= Redemption value at Maturity %= Coupon Pmts per year= 6/11/17 11/1/18 6/11/27 95 7.500% 100 2 ANSWERS YTM= Call Price Provision (I.E. EN TER 9/15/2018) INPUT Year Call Price Dates YTC One year from Issuance Date= 104 Two years from Issuance Date= 103 Three years from Issuance Date= 102 Four years from Issuance Date= 101 YTW = Current Yield =