Ryan O'Connell, CFA, FRM explains how to calculate Probability of Default (PD), Loss Given Default (LGD), and Expected Loss (EL) in Microsoft Excel.

Chapters:
0:00 Calculate Present Value of Risky Corporate Bond
0:57 Calculate the Yield to Maturity (YTM) of the Risk Free Bond
3:12 Calculate the Credit Spread
3:59 Calculate Probability of Default (PD)
4:18 Calculate Loss Given Default (LGD)
5:06 Calculate Expected Loss (EL)

Download Free Excel File:
► Grab the file from this video here: https://ryanoconnellfinance.com/produ...

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

‍ Freelance Financial Modeling Services:
► Custom financial modeling solutions tailored for your needs: ryanoconnellfinance.com/freelancefinanceservices/

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/all3levelsofthecfaexamcompletecoursebyanalystprep/?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/frmpart1andpart2completecoursebyanalystprep/?ref=mgmymmr

*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.