Question 1

Swap代写
Swap代写

Swap代写 Let be a set of dates, on which payments of the floating leg of an interest rate swap occur. The payoff of the floating leg of the swap at time

Let  be a set of dates, on which payments of the floating leg of an interest rate swap occur. The payoff of the floating leg of the swap at time  is  where  is the reference rate of the floating leg and s is a constant spread. For simplicity, assume that the floating and fixed payments happen on the same dates. Also,  is the risk-free rate on the same tenor. Let N be the notional of the swap.

1) what is the fixed semiannual swap rate calculated from the risk-free rates? Please specify mathematical formula (no need for exact numerical result at the point).

2) Let the semiannual swap rate calculated in 1) be the fixed leg payment of the swap. What is the constant spread s which sets the present value of the swap position to be zero? Please specify mathematical formula (no need for exact numerical result at this point).Swap代写

 

Sol: 1) as  is spot rate of risk-free rate. based on two simultaneous bond positions, let’s donate the fixed semimanual swap rate by c.

Swap代写
Swap代写

At inception of the swap, it is convention to select the fixed payment, so that .

Then we can get,

2) at the inception of the swap, the value of the swap

What means,

Swap代写
Swap代写

Then we can get,

 

Question 2 Swap代写

The risk-free curve and reference curve data can be found in the Excel file. Let’s support the analysis date is 12 June 2013 and both fixed and floating payment happens semiannually, with the first payment date half year from analysis date. The swap notional equals to USD 100,000, the maturity of the swap is 5 years, and the swap currency is USD.

Please provide a MATLAB code or Excel spreadsheet that computes…

1) the answer for the first two questions based on the input data given in the attached Excel file.

2) the PV of the swap position on 12 August 2013. Swap代写

3) the PV of the swap position on 12 February 2014.

Sol: 1) the semiannual swap rate is: 0.0072847;

the constant spread is: -0.0016834;

2) the value of IRS on 12 August 2013 is: 3025.5464

3) the value of IRS on 12 February 2014 is: 3047.2092

Swap代写
Swap代写

 

Swap代写
Swap代写

 

Swap代写
Swap代写

 

Swap代写
Swap代写

Swap代写
Swap代写

更多其他:prensentation代写 文学论文代写 商科论文代写 Case study代写 Essay代写 研究论文代写 期末论文代写 毕业论文代写 论文代写

合作平台:天才代写 幽灵代写 写手招聘