YIELDMAT

Syntax:

YIELDMAT ( settlement , maturity , issue , rate , pr [ , [ basis ] ] )

Description: Computes the annual yield of a security that pays interest at maturity.

Arguments:

Name	Type	Description
settlement	number	The security's settlement date.
maturity	number	The security's maturity date.
issue	number	The security's issue date.
rate	number	The security's interest rate.
pr	number	The security's price.
basis	number	The truncated integer type of day count basis to use, as follows: Value Day Count Basis 0 or omitted US (NASD) 30/360 1 Actual/actual 2 Actual/360 3 Actual/365 4 European 30/360

 

Time information in the date arguments is ignored.

Return Type and Value: number – The annual yield of a security that pays interest at maturity.

However, if

• settlement, maturity, or issue is out of range for the current date base value, #NUM! is returned.

• settlement ≥ maturity, #NUM! is returned.

• rate or pr ≤ 0, #NUM! is returned.

• basis < 0 or basis > 4, #NUM! is returned.

[Example:

YIELDMAT(DATE(2008,3,15),DATE(2008,11,3),DATE(2007,11,8),0.0625,
100.0123,0) results in 6.0954%

end example]