Previous Topic

Next Topic

oBond1_CFM( ) Example

Description

Consider a 10-year bond that has a semi-annual coupon of 8.25%, a dated date of 1 June 1998, a maturity date of 1 June 2008, and a face value of $100,000. The bond discounts all cash flows on an Actual/365 JGB basis and accrues interest on a Actual/Actual (bond) basis. Yield is calculated on an annual compounding basis.

There is no ex-dividend period, cash flows are rounded to 12dp, and cash flows that fall on a non-business day are not adjusted. Coupons are equal and the bond is priced using the ISMA formula.

Generate the cash flow map of this bond assuming a settlement date of 1 March 2003.

 

 

Function Specification

=oBond1_CFM("1/3/2003", "1/6/1998", "1/6/2008", 100000, 0.0825, 2,{6, 2}, 0)

 

 

 

Parameter Name

Parameter Value

 

 

 

 

 

Settlement Date

1/3/2003

 

 

Dated Date

1/6/1998

 

 

Maturity Date

1/6/2008

 

 

Face Value

100000

 

 

Coupon Rate

0.0825

 

 

Coupon Frequency

2

 

 

Discount Basis

6

 

 

Accrual Basis

2

 

 

Output Flag

0

 

 

 

Solution

The following results are obtained:

 

Nominal Date

Actual
Date

 

Coupon Amount ($)

Face
Value ($)

Total Cash Flow ($)

Number of Days

 

1/6/03

1/6/03

4,125.0000

0.0000

4,125.0000

182

1/12/03

1/12/03

4,125.0000

0.0000

4,125.0000

183

1/6/04

1/6/04

4,125.0000

0.0000

4,125.0000

183

1/12/04

1/12/04

4,125.0000

0.0000

4,125.0000

183

1/6/05

1/6/05

4,125.0000

0.0000

4,125.0000

182

1/12/05

1/12/05

4,125.0000

0.0000

4,125.0000

183

1/6/06

1/6/06

4,125.0000

0.0000

4,125.0000

182

1/12/06

1/12/06

4,125.0000

0.0000

4,125.0000

183

1/6/07

1/6/07

4,125.0000

0.0000

4,125.0000

182

1/12/07

1/12/07

4,125.0000

0.0000

4,125.0000

183

1/6/08

1/6/08

4,125.0000

100,000.0000

104,125.0000

183

 

 

 

 

 

 

 

Return to www.derivativepricing.com website

Copyright 2013 Hedgebook Ltd.