Calculate Bond Convexity and Duration in Excel | Interest Rate Risk

In this insightful tutorial, Ryan O'Connell, CFA, FRM delves deep into the concepts of "Bond Convexity and Duration in Excel" to give you a robust understanding of these critical interest rate risk parameters. Whether you are a seasoned investor or just starting your journey in the financial markets, this tutorial is designed to equip you with the skills to analyze bonds like a pro using Excel. You will see how to calculate both bond duration and bond convexity using Excel. Join as we unpack the intricate dynamics of bond investments, one formula at a time.

💾 Purchase the file created in this video here: https://ryanoconnellfinance.com/produ...

🎓 Tutor With Me: 1-On-1 Video Call Sessions Available
► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/

👨‍💼 My Freelance Financial Modeling Services:
► Custom financial modeling solutions tailored for your needs: ryanoconnellfinance.com/freelance-finance-services/

📚 CFA Exam Prep Discount - AnalystPrep:
► Get 20% off CFA Level 1, 2, and 3 complete courses with promo code "RYAN20". Explore here: analystprep.com/shop/all-3-levels-of-the-cfa-exam-complete-course-by-analystprep/?ref=mgmymmr

📘 FRM Exam Prep Discount - AnalystPrep:
► Get 20% off FRM Part 1 and Part 2 complete courses with promo code "RYAN20". Explore here: analystprep.com/shop/frm-part-1-and-part-2-complete-course-by-analystprep/?ref=mgmymmr

Chapters:
0:00 - How to Calculate Bond Duration in Excel
2:21 - What Bond Duration Means for Bond Prices
2:56 - How to Calculate Bond Convexity in Excel
6:27 - Calculate Changes in Bond Prices Based on Convexity
9:33 - Convexity Changes at Different Interest Rates

Disclosure: This is not financial advice and should not be taken as such. The information contained in this video is an opinion. Some of the information could be wrong. This channel is owned and operated by Portfolio Constructs LLC. Some of the links above are affiliate links, meaning, at no additional cost to you, I will earn a commission if you click through and make a purchase.