💾 Download Free Excel File: ► Grab the file from this video here: ryanoconnellfinance.com/product/microsoft-excel-template-for-key-rate-duration-key-rate-shifts/ 🔑 Join this channel to get access to perks & support my work: kzbin.info/door/Akyj2N9kd0HtKhCrejsYWQjoin
@zactucci67672 ай бұрын
What happened to your website
@RyanOConnellCFAАй бұрын
Hell, are you not able to access my site? It should be working fine
@suibo7776 Жыл бұрын
THANK YOU, RYAN!!! I've had difficulties visualizing this topic from online resources but your videos have really helped me
@RyanOConnellCFA Жыл бұрын
Happy to help!
@kunal_nandurkar21 Жыл бұрын
You're an amazing teacher! I couldn't thank you enough. Your videos on Fixed Income subject area helped me a lot.
@RyanOConnellCFA Жыл бұрын
You are so welcome! Really happy to hear it
@msppg769 Жыл бұрын
Wonderful video. Im so thankful that I can watch it for free. Thank you Ryan
@RyanOConnellCFA Жыл бұрын
Thank you for watching and for taking the time to leave a nice comment
@JamesReynolds-z8b Жыл бұрын
This was a very straightforward and helpful explanation. Thank you Ryan!
@RyanOConnellCFA Жыл бұрын
Thank you for the positive feedback James!
@Ramses-fw8id2 жыл бұрын
You explain so well, you are smart
@RyanOConnellCFA Жыл бұрын
Thank you Ramses, it is more about having spent lots of time on the topics rather than being smart haha
@downy3267 ай бұрын
Thank you! that was really helpful
@RyanOConnellCFA7 ай бұрын
It is my pleasure!
@hernanalzate15828 ай бұрын
Hi Ryan, thx for sharing your models with us; just a minor comment regarding KRDs; it seem you have a 'sumproduct' calculation in cell C10, rather than the KRD calculation presented in the formula on the left, where KRD = [P_ + P+ / 2*0.01*P0]
@RyanOConnellCFA13 күн бұрын
Hey Hernan, this video actually used to be longer and I did a calculation in a way that I believed to be incorrect so I ended up cutting that part of the video which had that incorrect sumproduct formula
@tinayang53422 жыл бұрын
Thank you Ryan for explaining this. Really helpful!
@RyanOConnellCFA2 жыл бұрын
My pleasure Tina!
@alanoliveiramoreno23092 жыл бұрын
Ryan, I really enjoy our content really bring to life the topics cover in CFA. in this topic I only make one adjustment. When you are calculating the duration, you are calculating the Mac Duration. One additional adjustment is calculate the YMT for the original curve, then calculate the Duration= Mac Dur/ (1+YTM). And the hole point about calculating Duration is to estimate the impact on Price of a bond without the actual calculation. So for the test consistency for your calculation, the real calculation (column J8) need to be very closer to the x% expected shift yield curve multiply by Duration multiply by the original present value of column f. Calculating the impact on present value of a bond without the adjustment for YTM can be very different from the real calculation.
@RyanOConnellCFA2 жыл бұрын
Thank you for the contribution Alan, really appreciate it! It will be helpful for others to read about the nuances of the concept in your comment
@vivian54482 жыл бұрын
very well explained
@RyanOConnellCFA2 жыл бұрын
You're welcome!
@thatquantguy2 жыл бұрын
Yesssss you uploaded!!
@RyanOConnellCFA2 жыл бұрын
Your avatar is amazing Josh! I finally got back on the video grind and have been uploading 2 videos per week. Going to try to stay very consistent now
@marlowisws2 жыл бұрын
Hi Ryan, This was very clearly explained, but I'm still a bit confused. I thought Key Rate Duration was the duration at a key rate, that is, the 3 year rate or the 2 year rate. So the 2 year Key Rate Duration is XYZ, showing investors what a change to the 2 year spot rate would be to the bond. But you have explained it as an entire curve-concept. Or am I misunderstanding? Thanks!
@RyanOConnellCFA2 жыл бұрын
Hey Chris, I think for most intents and purposes (most tests or classes) they will be referring to Key Rate Duration as as just a single rate like you mentioned. That is likely the extent of the concept you'll need to understand if you were watching this video for a test or certificate I'd imagine
@oea89642 жыл бұрын
@@RyanOConnellCFA KRD = sumproduct of adjustment with Period*Weight, it does NOT look right. You should use PV in F5 as the original and get a new PV with Shifted Curve for KRD
@machoasp Жыл бұрын
Key rate duration of 7.67..how can you intepret it
@RyanOConnellCFA Жыл бұрын
I think of it as an overall measure of the ratio of how much the price will change for a given change in interest rates
@luisramos2583 Жыл бұрын
Amazing Video. Thank you very much Ryan.
@RyanOConnellCFA Жыл бұрын
Much appreciated Luis!
@machoasp Жыл бұрын
Hello..I have a detailed query..can I mail you the same
@RyanOConnellCFA Жыл бұрын
Please feel free to send it to the email in the description Anoop