CreditMetrics explained: measuring credit risk (Excel)

Подписаться 26 тыс.

Просмотров 12 тыс.

50% 1

How do financial institutions measure credit risk? One of the most common approaches to credit risk measurement is CreditMetrics, that has been routinely used in the industry since 1990s. Today we are investingating the CreditMetrics approach based on a simple example and discussing its advantages and limitations.
Don't forget to subscribe to NEDL and give this video a thumbs up for more videos in Banking!
Please consider supporting NEDL on Patreon: / nedleducation

Опубликовано:

6 янв 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 29

@NEDLeducation 3 года назад

You can find the spreadsheets for this video and some additional materials here: drive.google.com/drive/folders/1sP40IW0p0w5IETCgo464uhDFfdyR6rh7 Please consider supporting NEDL on Patreon: www.patreon.com/NEDLeducation

@bradyh2189 Год назад

Hey the google docs are private :/

@gaclima Год назад

Congratulations. The explanation using spreadsheet democratizes the understanding of models in such way that anyone can understand.

@NEDLeducation Год назад

Hi Gabriel, and many thanks for such kind words! This is one of the missions this channel had from the very beginning :)

@ryaannn8250 3 года назад

Thanks for the video! very helpful as always

@georgemathematician1186 3 года назад

Beautifully done !

@plazmafield 3 года назад

Hope your Christmas, etc. was great sir. Thank you for making these videos, I enjoy learning from them

@NEDLeducation 3 года назад

Hi Stephen, happy Christmas and New Year to you, too! Stay tuned for even more videos in 2021 and thanks for staying with NEDL :)

@gauravgambhir7702 3 года назад

Amazing video...Thank you so much. Looking forward to watch more of these knowledgeable videos from you sir.

@NEDLeducation 3 года назад

Hi Gaurav, many thanks for the feedback and glad you liked the video! More content on risk management will come around this week so stay tuned!

@surendrabarsode8959 Год назад

Very clearly explained and worked out in Excel. It would be interesting if you can explain various methods and calculations of Point in Time PIT PDs versus Through The Cycle TCC PDs as well as linkages between the two. For banks, PIT and TTC PDs are important from the IFRS 9 and Basel regulatory perspective. This will be certainly useful for a larger community of students of finance, banking and risk.

@aslivinschi Год назад

Sava, this is excellent! I was wondering about how do we stress a transition matrix? Let's say incorporating the market default/downgrades of 2008 financial crisis or any other crisis? I guess there is a powerful tool. Looking forward to become a member

@user-ku1dy2ir8q 8 месяцев назад

Hi. Very good explanation. Do you consider the credit VaR as the variance? How to expand your analisys from 2-bond portfolio to a, lets say, 10 bonds portfolio?

@kiris941 2 года назад

Hi Sava, found this very useful! Usually portfolios are larger than two assets / counterparties.. Do you have any idea how to calculate the joint transition probabilities for, let's say 20 positions?

@NEDLeducation 2 года назад

Hi, and glad you liked the video! As for your question, it is usually done by calculating default correlations and relating them to the impact of defaults on bond value. Might do a video on that at some point in the distant future!

@aslivinschi 2 года назад

Hi Sava! In the origina Credit metrics document they are talking about the default correlation between sectors, and I do not understand that. How can we avg. realised default correlation between 2 sectors? sounds tricky and apparently, a simple correlation does not work.

@NEDLeducation 2 года назад

Hi Alexei, and thanks for the excellent question! There is a proxy CreditMetrics suggests, and it is equal to sigma^2/(mu - mu^2), where mu is the default rate (percentage of obligors defaulting on average), and sigma is the standard deviation of it over the sample years. Alternatively, they also suggest a method that retrieves default correlations from asset return correlations.

@aslivinschi 2 года назад

@@NEDLeducation HI SAVA, THANK YOU VERY MUCH. REALLY APPRECIATED.

@michelleyang7554 2 года назад

Hi Sir, thanks for your video. How do you get the table by column "rating" and "value"?

@NEDLeducation 2 года назад

Hi Michelle, and thanks for the question! This is an example dataset. You can get data on bond prices and their credit ratings from specialised platforms (like Hargreaves Landsdown) and rating agencies (like S&P), respectively. Hope it helps!

@michelleyang7554 2 года назад

@@NEDLeducation Thanks!!

@thefuckingpearl 2 года назад

Nedl you are excellent at explaining things , but can you please post credit metrics using monte carlo simulation, there's no one that I can possibly find on the internet that explains complex concepts on excel as simply as you do! Please it's a request.

@NEDLeducation 2 года назад

Hi, and thanks for your suggestion! I was definitely planning to tackle Monte Carlo simulation applications for credit risk at some point so stay tuned!

@rameshkannan1075 3 года назад

Hi sir I.have a doubt in 6.43 once we find how many acc have moved from ccc to D rating. I need to know if we click that cell then all that data should be displayed. Is there any option

@NEDLeducation 3 года назад

Hi Ramesh, and thanks for the question! As a drop from CCC to D is three rating downgrades straight, it is very unlikely it would happen within a year, so this is why the data is as it is. Hope it helps!

@rameshkannan1075 3 года назад

@@NEDLeducation sir sorry to ask more questions. My question is to find the list of Accounts where credit rating has been changed. In the above transition matrix we can see the number of acc moved from CCC to CC but i need list of Accounts

@rameshkannan1075 3 года назад

And your tutorial is very much helpful sir...

@NEDLeducation 3 года назад

@@rameshkannan1075 Hi again Ramesh, and thanks for the follow-up question. You can find publicly available datasets of rating changes on rating agencies' websites, here is the link for Fitch as an example, similar disclosure is also provided by S&P and Moody's: www.fitchratings.com/ratings-history-disclosure

@rameshkannan1075 3 года назад

@@NEDLeducation sir thank or ur response..