MacaulayMacaulay duration approximates the yield elasticity of bond price. Since its introduction in 1938 researchers have sought a more accurate formula. This article demonstrates Macaulay's formula gives accurate results if applied appropriately. A bond with maturity n has n solutions for yield, one...
Macaulay Durationis the weighted average number of years an investor must maintain his or her position in the bond where the present value (PV) of the bond’s cash flow equals the amount paid for the bond. In other words, it is the time it would take for an investor to retrieve the m...
Named after Frederick Macaulay, Macaulay’s Duration is the measure of the bond’s sensitivity to changes in interest rates.It is the weighted averagenumber of days for which the investor has to hold the bond to make the present value of all the cash flows equal to the amount paid for the...
Macaulay duration is calculated by finding out the time till each cash flow, weighting it by the proportion of the present value of that cash flow to the present value of all cash flows and then summing the weighted-average time. Following is the formula for Macaulay duration:Macaulay Duration...
Presumably, you are asking about the Excel DURATION function (click here). As usual, the Excel help page is woefully inadequate. According to the help page, Excel DURATION calculates the Macaulay duration (click here). If you are unfamiliar with the financial concept, be sure to also read th...
Convexity of a bond is the phenomena that causes the increase in bond price due to a decrease in interest rates to be higher than the decrease in bond price owing to an increase in interest rates. It represents the change in duration that occurs due to c
The function returns a duration of 6.46831 years. As we omitted the basis argument, the DURATION function took the days count as US(NASD) 30/360. As it uses Macaulay Duration, the formula used is: Things to remember about the DURATION Function: ...
Macaulay Duration=∑t=1nt×C(1+y)t+n×M(1+y)nCurrent Bond Pricewhere:t=Respective time periodC=Periodic coupon paymenty=Periodic yieldn=Total number of periodsM=Maturity value\begin{aligned}&\text{Macaulay Duration} = \frac{ \sum_{t = 1} ^ {n} \frac{ t \times C }{ (1 + y...
measure the sensitivity of a bond to changes in interest rates. Macaulay duration calculates the weighted average time before a bondholder receives the bond's cash flows. In order to calculate modified duration, the Macaulay durationmust first be calculated. The formula for the Macaulay duration is...
formulae