Syntax: @INTRATE(S, M, I, R[, B])
S = Settlement date, date of purchase
M = Maturity date
I = Investment amount
R = Redemption amount
B = (Optional) Day count basis as follows:
0 or omitted | 30/360 |
1 | Actual/actual |
2 | Actual/360 |
3 | Actual/365 |
@INTRATE returns the interest rate for a fully invested investment.
Example:
@INTRATE(@DATE(93, 1, 15), @DATE(93, 6, 15), 10000, 10545) = 0.1317