How to Calculate a Bond's Yield to Maturity (Using Excel)

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

КОМЕНТАРІ • 27

  • @BrandonPowell-th5xv
    @BrandonPowell-th5xv 5 місяців тому +3

    I hate knowing im missing something but the step by step instructions you give tells me ppl like you are missing from the world and we need more people like you thank you.

  • @aviadrotem6927
    @aviadrotem6927 5 місяців тому +2

    i was stuck on a problem for hours and couldn't get the right answer. 5 minutes into your video and I solved it. what an absolute legend. you earned a new subscriber!!

    • @GodsChosen46
      @GodsChosen46 4 місяці тому

      Same!!!!😢😊and I tried everything!!

  • @goodrap1
    @goodrap1 Місяць тому +1

    Terrific explation. You deserve a teaching award

    • @professorikram
      @professorikram  21 день тому

      🙂 That’s very kind of you! Thank you.

  • @knownguy5940
    @knownguy5940 15 днів тому

    Hi! I wanted to know if im using information online for price of the bond do I consider the dirty price of it?

  • @joshuaalfred8307
    @joshuaalfred8307 Рік тому +1

    Incredible video. Theory and practical application. Love it. Thank you!

  • @simonegiuliani4913
    @simonegiuliani4913 Рік тому +1

    You are an angel! Many thanks! Best video on youtube on bonds!

  • @Lakshayop4
    @Lakshayop4 3 місяці тому +1

    Great Work Sir

  • @petopotamus
    @petopotamus Рік тому +1

    Amazing! Couldn't find my final yield anywhere on Vanguard after buying a 30yr US T-bond at auction...only saw the indicative yield when entering bid.

  • @hime6596
    @hime6596 26 днів тому +1

    YOU ARE AMAZING

  • @mikeyhernandez9895
    @mikeyhernandez9895 8 місяців тому +1

    This is great, God bless you!!

  • @yakhshibayevjakhangir-by5vt
    @yakhshibayevjakhangir-by5vt 15 днів тому +1

    Mr. how to calculate if coupon payments pay monthly ?

    • @professorikram
      @professorikram  15 днів тому +1

      That’s unusual. But take the coupon rate, divide my 12 to get the monthly coupon rate, and then multiply that by Face Value to get the monthly coupon payment.

    • @yakhshibayevjakhangir-by5vt
      @yakhshibayevjakhangir-by5vt 15 днів тому

      Thank you very much Mr I have calculated using your method and it has been very useful. I will watch your all videos

  • @AlinaPulfrey
    @AlinaPulfrey 5 місяців тому +1

    thanks for the video, any way you can share the template?

  • @ThomasHUA-u9n
    @ThomasHUA-u9n 27 днів тому +1

    Thank you !

  • @julie_00
    @julie_00 Рік тому +2

    Thank you for this video 🙏

  • @AlinaPulfrey
    @AlinaPulfrey 5 місяців тому +1

    thanks for the video, any way you can send me that template?

  • @udcreation92
    @udcreation92 Рік тому +1

    how to calculate monthly coupon freq. coupon payment in excel ?

  • @ron3252
    @ron3252 Рік тому +2

    Great!

  • @SphereofTime
    @SphereofTime 4 місяці тому

    1:00

  • @vascogouveia373
    @vascogouveia373 Рік тому +1

    I am sorry but the semi annual coupon example is wrong, we should assume continuously compounding and therefore we should not multiply by 2 but do (1+ semi-annual rate)^2 - 1

    • @professorikram
      @professorikram  Рік тому

      Thanks Vasco! Would you care to elaborate WHY continuous compounding should be used here, as opposed to semi-annual compounding?

    • @NMG717
      @NMG717 5 місяців тому

      May be because the coupons are cumulative and interest is compounding on the unpaid coupons too. But if they are paid when accrued then no need for compounding.