Suppose that it is January, and your bank makes a $1 million loan with a one-year maturity and carries 4% fixed interest rate. The bank initially finances the loan by issuing a $1 million 3-month Eurodollar CD paying 2.5%. After the first three months, the bank expects to finance the loan by issuing another $1 million 3-month Eurodollar CD in April (assume the rate becomes 2.9%), and another $1 million 3-month Eurodollar CD in June (assume the rate becomes 2.4%), and another $1 million 3month Eurodollar CD in Sept. (assume the rate becomes 3.25%).Suppose that you want to hedge the interest rate risk through options on financial futures. Your bank decides to buy one put option on each of the June, September, and December Eurodollar futures at 97.5 strike price. The option premium paid for June is .35; for September .75; and for December is 1.12.

Suppose also that on June, the Eurodollar future rate becomes 3.1% and the put option premium becomes .55. In Sept., the Eurodollar future rate becomes 2.8% and the put option premium becomes .45. In Dec., Eurodollar future rate becomes 4.3% and the put option premium becomes 1.95

You need to set-up a table that shows (1) profit and loss profile of your bank hedge operation; (2) the effective average cost of your bank CD

I NEED IT AS A TABLE PLEASE