Microsoft Office Tutorials and References
In Depth Information
DURATION
DURATION
DURATION returns the Macauley duration for an assumed par value.
=DURATION(settlement,maturity,coupon,yield,frequency,basis)
Notice that in Figure 6.16 the bond settlement date (the date a buyer purchases a coupon
such as a bond) is 5/15/1999 and the maturity date (the date the bond expires) is 7/13/2007.
The securities annual coupon rate is 8.7%. The securities annual yield is 9.2%. The frequency
is semiannual and the basis is Actual/actual. The weighted average equals 5.89 years. By
using cell referencing instead of applying the dates in the formula, your formula becomes
more flexible.
The security’s settlement date. This is the date after the issue date
when the security is traded to the buyer.
SETTLEMENT
The security’s maturity date. The date when the security expires.
MATURITY
The security’s annual coupon rate.
COUPON
The security’s annual yield.
YIELD
The number of payments per year—Annual = 1; Semiannual = 2;
Quarterly = 4.
FREQUENCY
The day count basis to use.
BASIS
Figure 6.16
The DURATION method
is the weighted average
of the present value of
the cash flows and is
used as a measure of a
bond’s price response
to changes in the yield.
A
The function
built with cell
referencing
EFFECT
EFFECT returns the effective interest rate annually. This is based on the nominal annual
interest rate and the number of compounding periods per year.
=EFFECT(nominal_rate,npery)
Search JabSto ::




Custom Search