YIELD(S, M, R, PR, RD, F [, B])

 

Description

This function returns the yield at maturity of a security that pays periodic interest.  All dates must be entered as datetime values.

 

Parameters

 

S

Settlement date.

 

M

Maturity date.

 

R

Annual coupon rate of the security.

 

PR

The price of the security per $100 face value.

 

RD

Redemption value of the security at maturity per $100 face value.

 

F

The number of coupon payments per year.

 

B

(Optional)  The day count basis to be used:

 

 

Examples

 

YIELD(DATE(91, 3, 15), DATE(98, 10, 15), 6%, 94.1854, 100, 2, 0) = 0.07