Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date.
PRICEMAT(Settlement; Maturity; Issue; Rate; Yield; Basis)
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.
|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|
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.