 Formula Engine Reference Guide |
|
Back to Class Index
RECEIVED(S, M, I, D[, B])
Returns the value at maturity of a fully invested security. Dates must be entered as a serial date value.
Parameters
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
Example
RECEIVED(DATE(93, 1, 15), DATE(93, 6, 15), , 10000, 12.5%, 1) = 10545.323