next up previous contents index
Next: REGEX Up: A. Function Reference Previous: RATE   Contents   Index


RECEIVED

Syntax: RECEIVED(S, M, I, D[, B])

S = Settlement date, date of purchase
M = Maturity date
I = Investment amount
D = Discount rate
B = Day count basis as follows:

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

RECEIVED returns the value at maturity of a fully invested security. Dates must be entered as a serial date value.

Example:

RECEIVED(DATE(93, 1, 15), DATE(93, 6, 15), , 10000, 12.5%, 1) = 10545.323

Excel function: N/A


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