 Formula Engine Reference Guide |
|
Back to Class Index
DISC(S, M, P, R, B)
This function returns the discount rate of a security.
Parameters
S
Settlement date
M
Maturity date
P
Price per $100
R
Redemption value per $100
B
(Optional) The day count basis to be used:
0 or omitted 30/360
1 Actual/actual
2 Actual/360
3 Actual/365
Examples
DISC(DATE(93, 1, 10), DATE(93, 7, 20), 97.375, 100, 3) = 0.05016
DISC(DATE(93, 1, 10), DATE(93, 7, 20), 97.375, 100) = 0.04974