Consider the following floater:

Maturity= 6 years Coupon rate = reference rate plus 80 basis point resets every six months Maturity value = \($100\) Market price = \($99.1381\) Reference rate = 10%

Using an Excel spreadsheet, calculate the discount margin.