A 10% new-issued coupon bond with semi-annual payments purchased on Valentine's Day of 2019 matures on Valentine's Day of 2027. The Par value is $1,000.00 and is guaranteed at the end of the maturity period. If the bond was first sold for $1000.00, then this bond is classified under which category?

Click on the required answer cell highlighted in yellow (cell E24), and then use the drop-down menu (downward-pointing arrow) to select the correct answer. Do not change the formatting of any cell.

how to calculate in excel?

Input Data Purchase Date February 14, 2019 Call Date February 14, 2027 Coupon Payment Frequency = Semi-Annual Par Value in $100 Increments = $100.00 Annual Coupon Payment = $100.00 Coupon Rate = 10.00% Number of Years to Maturity = 8 Days Since Last Payment N/A Yield-to-Maturity = N/A Bond Price in $100 Increments = $100.00 Current Yield = 10.00%