Bond Duration explained (calculation and concept) - part 2

in #excel6 years ago

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.

Sort:  

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) :

Award for the number of comments

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 STOP

Do 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


Do you like SteemitBoard's project? Then Vote for its witness and get one more award!

@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!

Happy Birthday! - You are on the Steem blockchain for 1 year!

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!

Coin Marketplace

STEEM 0.28
TRX 0.12
JST 0.033
BTC 66858.35
ETH 3088.97
USDT 1.00
SBD 3.72