Manuals/calci/DISC
DISC(settle, M, P, R, basis)
Where 'settle' is the security's settlement date, 'M' is the security's maturity date, 'P' is the security's price, 'R' is the security's redemption value, and 'basis' is the type of day count basis to use.
This function calculates the discount rate for a security.
- DISC calculates the error value when settlement or maturity is not a valid or settlement ≥ maturity.
- 'P' and 'R' must be grater than or equal to zero.
- Basis value should between 0 and 4.
- DISC is calculated as follows:
where:
B = number of days in a year, depending on the year basis.
DSM = number of days between settlement and maturity.
DISC
Lets see an example,
DISC(settle, M, P, R, basis)
B
June 9, 2010
November 19, 2010
97.975
100
1
=DISC(B2,B3,B4,B5,B6) is 0.0456
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | June 9, 2010 | |||
| Row2 | November 19, 2010 | |||
| Row3 | 97.975 | |||
| Row4 | 100 | |||
| Row5 | 1 | |||
| Row6 | 0.045563 |
