Bond Duration explained (calculation and concept) - part 1

[canitinsurana]

Calculation explained about the Duration and Mduration formula of MS-Excel, Also include some fundamental concepts.
The Macaulay duration is the weighted average term to maturity of the cash flows from a bond. The weight of each cash flow is determined by dividing the present value of the cash flow by the price