💾 Download Free Excel File: ► Grab the file from this video here: ryanoconnellfinance.com/product/microsoft-excel-template-for-key-rate-duration-key-rate-shifts/ 🎓 Tutor With Me: 1-On-1 Video Call Sessions Available ► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/
@hernanalzate15825 ай бұрын
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]
@tinayang53422 жыл бұрын
Thank you Ryan for explaining this. Really helpful!
@RyanOConnellCFA2 жыл бұрын
My pleasure Tina!
@suibo777610 ай бұрын
THANK YOU, RYAN!!! I've had difficulties visualizing this topic from online resources but your videos have really helped me
@RyanOConnellCFA10 ай бұрын
Happy to help!
@kunal_nandurkar2111 ай бұрын
You're an amazing teacher! I couldn't thank you enough. Your videos on Fixed Income subject area helped me a lot.
@RyanOConnellCFA11 ай бұрын
You are so welcome! Really happy to hear it
@vivian54482 жыл бұрын
very well explained
@RyanOConnellCFA2 жыл бұрын
You're welcome!
@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
@oea8964 Жыл бұрын
@@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 Жыл бұрын
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
@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!
@downy3264 ай бұрын
Thank you! that was really helpful
@RyanOConnellCFA4 ай бұрын
It is my pleasure!
@Ramses-fw8id Жыл бұрын
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
@Ramses-fw8id Жыл бұрын
What a nice gentleman, you are
@RyanOConnellCFA Жыл бұрын
I appreciate it Ramses!
@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
@muforlife7460 Жыл бұрын
Mr, Iloveyou
@RyanOConnellCFA Жыл бұрын
Haha thank you!
@alanoliveiramoreno2309 Жыл бұрын
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.
@RyanOConnellCFA Жыл бұрын
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
@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