[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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]