all elements to answer this question are present

please complete the question

6. Interest Rate Collar: A corporate treasurer is issuing a floating rate bond offering LIBOR+2.5% per year. The corporate treasurer buys a cap at 7% for 3 years with a premium of 3%, and sells a floor 4% for 3 years at a premium of 1.5%. Complete the table below. Year end LIBOR at year Net payments by corporate treasurer end 4.5% 2 8% 1% Year Show the details of components of net payments by the Treasurer here end 2 3