Financial Toolbox    
acrudisc

Accrued interest of discount security paying at maturity

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.
Discount
Discount rate of the security. Enter as decimal fraction.
Period
(Optional) Coupons per year. An integer. Default = 2.
Basis
(Optional) Day-count basis: 0 = actual/actual (default), 1 = 30/360, 2 = actual/360, 3 = actual/365.

Description

AccruInterest = acrudisc(Settle, Maturity, Face, Discount, Period, Basis) returns the accrued interest of a discount security paid at maturity.

Examples

See Also

acrubond, prdisc, prmat, ylddisc, yldmat

References

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


  acrubond amortize