Previous Topic

Next Topic

oSWPcmd1_Price( ) 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 swap assuming a settlement date of 14 August 2003?

 

 

Function Specification

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

 

 

Parameter Name

Parameter Value

 

 

 

 

 

Swap Type

2

 

 

Value date

12/8/2003

 

 

Settlement Date

14/8/2003

 

 

Effective Date

20/4/2003

 

 

Maturity Date

20/4/2005

 

 

Fixed Leg Price

19.5

 

 

Fixed Leg Payment Frequency

3

 

 

Fixed Leg Business Day Convention

3

 

Floating Leg Forward Prices

P1:Q13

 

See Forward Price Curve

 

Floating Leg Payment Frequency

3

 

 

Floating Leg Business Day Frequency

1

 

 

Quantity

100000

 

 

Date Generation

2

 

 

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

$774,838.29

Fixed Leg Fair Value

$11,198,031.95

Floating Leg Fair Value

$11,972,870.29

Par Swap Price

$20.8493

 

 

 

 

Return to www.derivativepricing.com website

Copyright 2013 Hedgebook Ltd.