Documentation/Calc Functions/PRICEMAT

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

PRICEMAT

Category:

Financial Analysis

Summary:

Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date.

Syntax:

PRICEMAT(Settlement; Maturity; Issue; Rate; Yield; Basis)

Returns:

Arguments:

Settlement is the date of purchase of the security.

Maturity is the date on which the security matures (expires).

Issue is the date of issue of the security.

Rate is the interest rate of the security on the issue date.

Yield is the annual yield of the security.

Basis (optional) is chosen from a list of options and indicates how the year is to be calculated.

Basis Calculation
0 or missing US method (NASD), 12 months of 30 days each
1 Exact number of days in months, exact number of days in year
2 Exact number of days in month, year has 360 days
3 Exact number of days in month, year has 365 days
4 European method, 12 months of 30 days each

Additional details:

Examples:

Settlement date: February 15 1999, maturity date: April 13 1999, issue date: November 11 1998. Interest rate: 6.1 per cent, yield: 6.1 per cent, basis: 30/360 = 0.

The price is calculated as follows:

=PRICEMAT("1999-02-15";"1999-04-13";"1998-11-11"; 0.061; 0.061;0) returns 99.98449888.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: