Previous Topic

Next Topic

oSWPcmd1_Price_FL( ) Example

specification

Consider a 2-year payer swap for 100,000 units of a commodity. The Swap has a valuation date of 12 August 2003, an effective date of 20 April 2003, and a maturity date of 20 April 2005.

The fixed leg of the swap is paid quarterly and has a price of $19.50 per unit and a Business Day Convention of 'following day'. The floating leg of the swap is also paid quarterly and has no Business Day adjustment. The reset cycle is computed backwards from the maturity date.

What is the fair value for the floating leg assuming a settlement date of 14 August 2003?

 

 

Function Specification

=oSWPcmd1_Price_FL("12/8/2003", "14/8/2003", "20/4/2003", "20/4/2005", P1:Q13, 3, 100000, 1, 1, 1, J1:L24, N1:N75, 0)

 

 

Parameter Name

Parameter Value

 

 

 

 

 

Value Date

12/8/2003

 

 

Settlement Date

14/8/2003

 

 

Effective Date

20/4/2003

 

 

Maturity Date

20/4/2005

 

 

Forward Prices

P1:Q13

See Forward Price Curve

 

Payment Frequency

3

 

 

Quantity

100000

 

Business Day Convention

1

 

 

Date Generation

1

 

 

Interpolation Method

1

 

 

Zero Curve

J1:L24

See Zero Curve

 

Holiday Schedule

N1:N75

See Holiday Schedule

 

Output Flag

0

 

 

 

Solution

The following results are obtained:

Fair Value

$11,972,870.29

Par Swap Price Numerator

$11,972,870.29

 

 

Return to www.derivativepricing.com website

Copyright 2013 Hedgebook Ltd.