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