Crystal Reports for Eclipse Designer Guide

DISC

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)
    • 1 - actual/actual
    • 2 - actual/360
    • 3 - actual/365
    • 4 - European 30/360
  • Returns
    Number value
    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.



    SAP BusinessObjects
    http://www.sap.com/sapbusinessobjects/
    Support services
    http://service.sap.com/bosap-support/
    Product Documentation on the Web
    http://help.sap.com/