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

Macaulay and modified durations.

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.
cpn
Coupon rate. Enter as a decimal fraction.
yld
Yield. Enter as a decimal fraction.
per
Coupons per year. An integer. Default = 2.
basis
Day-count basis: 0 = actual/actual (default), 1 = 30/360,
2 = actual/360, 3 = actual/365.

Description

[d, m] = bonddur(sd, md, rv, cpn, yld, per, basis) finds the Macaulay duration d and modified duration m in years for a security with periodic interest payments.

Example

Given this data for a security:

Settlement date01-Dec-1994
Maturity date01-Jan-2000
Par value$100.00
Coupon rate5%
Yield4.34%
Coupons per year2 (semi-annual)
Basisactual/actual

Find the durations:

See Also

bondconv, cfconv, cfdur, datenum

Reference

Mayle, Standard Securities Calculation Methods, Volumes I-II, 3rd edition. Formulas 5, 6.



[ Previous | Help Desk | Next ]