Paul

Consider the following scenario: a bank enters an interest rate swap in which it pays firm "A" a floating rate and receives a fixed rate. To hedge the risk of firm "A" going bankrupt, the bank enters a credit default swap. How much insurance is the bank looking for in this credit default swap; that is, what are they trying to insure?

For instance, let's say the bank receives a fixed rate from "A" of 6.5%. The bank is willing to pay a fixed rate of 6.45% to a firm on an opposite interest rate swap. Therefore, the banks spread is 5 basis points. Does the bank do a credit default swap for the 6.5% they would have received from firm "A"? Does it do a credit default swap for the spread, .05%? How much insurance does the bank need??

I created a userform in VBA that has checkboxes and textboxes. I want the user to only see the textbox in the userform when he/she checks the checkbox. For example, Label 1 asks "Do you want to buy the stock?" Next to Label 1 is checkbox 1. Then there is Label 2 that says "Stock Price", then textbox 1, where the user enters the stock price. What is the code for controlling label 2 and textbox 1 with checkbox 1; that is, I want label 2 and textbox 1 hidden until the user checks checkbox 1.

One way around this is obviously creating a userform for every option the user can choose, but i would like eight options, and therefore eight checkboxes controlling eight labels and textboxes, on one userform.