Bond Valuation in Excel

Поділитися
Вставка
  • Опубліковано 30 вер 2024

КОМЕНТАРІ • 10

  • @harrycox6978
    @harrycox6978 6 років тому +2

    How do I use this method to find the value of a bond semi-annually?

    • @RonaldMoy
      @RonaldMoy  6 років тому +1

      Double the number of periods and cut the interest payment in half. In the above example, you'll have 10 six month periods and you'll receive $30 every six months in interest.

  • @rossfehily5354
    @rossfehily5354 6 років тому +1

    Whats the difference for yield rate and coupon rate, good video by the way

    • @RonaldMoy
      @RonaldMoy  6 років тому +3

      The coupon rate is the percentage of the par value that is paid each year in interest. The yield is the return that the bond pays that accounts for the coupons and the price paid for the bond.

    • @antoniobutler7129
      @antoniobutler7129 3 роки тому

      @@RonaldMoy so how would you calculate it

  • @saranakaona2728
    @saranakaona2728 4 роки тому

    Thank you so much this was very helpful

  • @joshtooley9441
    @joshtooley9441 3 роки тому

    Thanks for the upload

  • @jamaicahsosa3222
    @jamaicahsosa3222 3 роки тому

    is this a lattice model

  • @devez7
    @devez7 6 років тому

    1:59 you should discount by the coupon rate

    • @RonaldMoy
      @RonaldMoy  6 років тому

      No, you should discount by the yield to maturity. The coupon rate doesn't change.