next up previous contents index
Next: PRODUCT Up: A. Function Reference Previous: PRICEDISC   Contents   Index


PRICEMAT

Syntax: PRICEMAT(S, M, I, R, Y[, B])

S = settlement date
M = maturity date
I = issue date
R = annual coupon rate of the security
Y = annual yield of the security
B = (Optional) the day count basis to be used:

0 or omitted 30/360
1 actual/actual
2 actual/360
3 actual/365

PRICEMAT returns the price per $100 face value of a security that pays interest at maturity.

Example:

PRICEMAT(DATE(93, 3, 1), DATE(93, 6, 15), DATE(92, 11, 1), 6.5%, 0) = 101.8778

Excel function: N/A


next up previous contents index
Next: PRODUCT Up: A. Function Reference Previous: PRICEDISC   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003