Previous Topic

Next Topic

oBond1_EYield( ) Example

Description

Consider a 12-year bond trading at a price of $101.25 with an annual coupon of 6.75%, a dated date of 20 April 1996, a maturity date of 20 April 2008, and a face value of $75,000. The discount and accrual bases are 30/360 ISDA. Domestic yield is expressed with annual compounding.

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.

What are the equivalent yields of this bond assuming a settlement date of 1 November 2003?

 

 

Function Specification

=oBond1_EYield(1, 101.25, "1/11/2003", "20/4/1996", "20/4/2008", 75000, 0.0675, 1, 1, 7, , 0)

 

 

 

Function Parameter

Parameter Value

 

 

.

.

 

 

Price Method

1

 

 

Price or Yield

101.25

 

 

Settlement Date

1/11/2003

 

 

Dated Date

20/4/1996

 

 

Maturity Date

20/4/2008

 

 

Face Value

75000

 

 

Coupon Rate

0.0675

 

 

Coupon Frequency

1

 

 

Business Day Convention

1

 

 

Discount Basis

7

 

 

Accrual Basis

7

 

 

Holiday Schedule

 

 

 

Output Flag

0

 

 

 

Solution

The following results are obtained from setting the output flag to 0.

Domestic Yield

0.0640577

Annually Compounded Yield

0.0640577

Semi-Annually Compounded Yield

0.0630634

Quarterly Compounded Yield

0.0625740

Monthly Compounded Yield

0.0622505

True Yield

0.0640577

US Street Yield

0.0631003

US Treasury Yield

0.0629729

JGB Simple Yield

0.0639021

Money Market actual/360 Yield

0.0630324

Money Market actual/365 Yield

0.0639079

 

 

 

Return to www.derivativepricing.com website

Copyright 2013 Hedgebook Ltd.