Bond Duration explained (calculation and concept) - part 2

in excel •  6 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.

excel educational duration risk bonds
6 years ago by

Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

  • Disagreement on rewards
  • Fraud or plagiarism
  • Hate speech or trolling
  • Miscategorized content or spam

Submit
$0.00
    2 votes
    5
    Authors get paid when people like you upvote their post.
    If you enjoyed what you read here, create your account today and start earning FREE STEEM!
    Sort Order:  
  • Trending
    • [-]
      ·  6 years ago 

    very easy way to understand the duration concept in case on fixed income instruments like bonds

    Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

    • Disagreement on rewards
    • Fraud or plagiarism
    • Hate speech or trolling
    • Miscategorized content or spam

    Submit
    $0.00
      1 vote
      [-]
        ·  6 years ago 

      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!

      Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

      • Disagreement on rewards
      • Fraud or plagiarism
      • Hate speech or trolling
      • Miscategorized content or spam

      Submit
      $0.00
        [-]
          ·  6 years ago 

        @canitinsurana nice information upvotes and comments accepted just as i did!

        Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

        • Disagreement on rewards
        • Fraud or plagiarism
        • Hate speech or trolling
        • Miscategorized content or spam

        Submit
        $0.00
          [-]
            ·  6 years ago 

          @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

          Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

          • Disagreement on rewards
          • Fraud or plagiarism
          • Hate speech or trolling
          • Miscategorized content or spam

          Submit
          $0.00
            [-]
              ·  5 years ago 

            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!

            Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

            • Disagreement on rewards
            • Fraud or plagiarism
            • Hate speech or trolling
            • Miscategorized content or spam

            Submit
            $0.00