Join Ryan O'Connell, CFA, FRM, as he dives deep into Calculating Macauley, Modified, and Effective Bond Durations using Excel. Starting with the basics of calculating the present value of a semi-annual bond, this tutorial will guide you step-by-step through the intricacies of bond duration calculations. Bond duration is a key concept for understanding interest rate risk. Whether you're a finance professional or just keen to learn, this video offers valuable insights and hands-on techniques. Don't forget to like, share, and subscribe for more expert finance tutorials!

💾 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 - Intro to Calculating Bond Durations in Excel
0:13 - Calculating the Present Value of Semi-Annual Bond
2:37 - Calculate Macauley Duration
4:05 - Calculate Modified Duration
5:21 - Calculate Effective Duration

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.