Manuals/calci/PRICEMAT
Jump to navigation
Jump to search
PRICEMAT(settle, M, I, R, yield, basis)
Where 'settle' is the security's settlement date, 'M' is the security's maturity date, 'I' is the security's issue date, 'R' is the security's interest rate, 'yield' is the security's annual yield, and 'basos' is the type of day count basis to use.
This function computes the price per $100 face value of a security that pays interest.
- PRICEMAT shows the error value, when 'settle', 'M', 'I', or 'I' is not a valid date or 'R' or 'Yield' < 0.
- Basis must between 0 and 4.
- PRICEMAT counts the error value when settle ≥ M.
PRICEMAT
Lets see an example,
PRICEMAT(settle, M, I, R, yield, basis)
B
03-20-2008
05-18-2008
12-12-2007
6%
6%
0
=PRICEMAT(B2,B3,B4,B5,B6,B7) is 99.9844
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 03-20-2008 | 99.984362 | ||
| Row2 | 05-18-2008 | |||
| Row3 | 12-12-2007 | |||
| Row4 | 6% | |||
| Row5 | 6% | |||
| Row6 | 0 |
