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.
very easy way to understand the duration concept in case on fixed income instruments like bonds
Congratulations @canitinsurana! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Click on the badge to view your Board of Honor.
If you no longer want to receive notifications, reply to this comment with the word
STOPDo not miss the last post from @steemitboard!
Participate in the SteemitBoard World Cup Contest!
Collect World Cup badges and win free SBD
Support the Gold Sponsors of the contest: @good-karma and @lukestokes
@canitinsurana nice information upvotes and comments accepted just as i did!
@canitinsurana also anything funded should have a service life that exceeds bond duration. there's a reason we dont take a 10 year loan on a car. your blog make it more simple @canitinsurana
Congratulations @canitinsurana! You received a personal award!
You can view your badges on your Steem Board and compare to others on the Steem Ranking
Vote for @Steemitboard as a witness to get one more award and increased upvotes!