YIELDMAT(S, M, I, R, PR [, B])

 

Description

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

 

Parameters

 

S

Settlement date.

 

M

Maturity date.

 

I

Issue date.

 

R

Interest rate at date of issue.

 

PR

The price of the security per $100 face value.

 

B

(Optional)  The day count basis to be used:

 

 

Examples

 

YIELDMAT(DATE(93, 3, 1), DATE(93, 10, 1), DATE(92, 11, 5), 6.5%, 99.875, 0) = 0.06585