Financial Toolbox
  Go to function:
    Search    Help Desk 
discrate    Examples   See Also

Discount rate of a security.

Syntax

Arguments

sd
Settlement date. Enter as serial date number or date string. sd must be earlier than or equal to md.
md
Maturity date. Enter as serial date number or date string.
rv
Redemption (par, face) value.
price
Price of the security.
basis
Day-count basis: 0 = actual/actual (default), 1 = 30/360,
2 = actual/360, 3 = actual/365.

Description

d = discrate(sd, md, rv, price, basis) finds the discount rate of a security.

Example

returns

a discount rate of 5.03%.

See Also

acrudisc, fvdisc, prdisc, ylddisc

Reference

Mayle, Standard Securities Calculation Methods, Volumes I-II, 3rd edition. Formula 1.



[ Previous | Help Desk | Next ]