Description
DISC returns the discount rate for a security, given the settlement and maturity dates, and the security's value at those times.
Overloads
DISC (settlementDate, maturityDate, price, redemptionPrice)
DISC (settlementDate, maturityDate, price, redemptionPrice, basis)
Arguments
settlementDate is a
Date or
DateTime specifying when the security was purchased.
maturityDate is a
Date or
DateTime after the settlement date specifying when the security matures.
price is a positive number or currency specifying the value of the security when it was purchased.
redemptionPrice is a positive number or currency specifying the value of the security at maturity.
basis is an optional number specifying the day basis system to use. The following types are supported:
0 - American 30/360 (default)
Action
DISC returns the discount rate for a security, given the settlement and maturity dates, and the security's value at those times.
Examples
Suppose a security was purchased on April 15, 2000 for $96.25. The security matures on November 1, 2000 with a redemption value of $100. A 30/360 basis is used as it is common for many securities.
DISC (DateValue(2000, 4, 15),DateValue(2000,11,1),96.25,100,0)
Returns 0.0689 (rounded to four decimal places) corresponding to a discount rate of 6.89%.
Comments
This function is designed to work like the Excel function of the same name.