Previous Topic

Next Topic

oSWPcmd1_Price_FX( ) 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 fixed leg assuming a settlement date of 14 August 2003?

 

 

Function Specification

=oSWPcmd1_Price_FX("12/8/2003", "14/8/2003", "20/4/2003", "20/4/2005", 19.5, 3, 100000, 3, 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

 

 

Price

19.50

 

 

Payment Frequency

3

 

 

Quantity

100000

 

Business Day Convention

3

 

 

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,198,031.9506

Par Swap Rate Denominator

$574,258.0488

Par Swap Price Adjustment

$0.00

 

 

Return to www.derivativepricing.com website

Copyright 2013 Hedgebook Ltd.