Financial Toolbox    
discrate

Bank discount rate of a money market security

Syntax

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

Description
DiscRate = discrate(Settle, Maturity, Face, Price, Basis) finds the bank discount rate of a security. The bank discount rate normalizes by the face value of the security (e.g., U. S. Treasury Bills) and understates the true yield earned by investors.

Examples

returns

a discount rate of 5.01%.

See Also
acrudisc, fvdisc, prdisc, ylddisc

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


 disc2zero effrr