2
$\begingroup$

how do i calculate the CECL? The equation for the Expected Loss Model (ECL) is:

$ EL=PD*EAD*LGD$ (Lifetime ECL for Stage 2 & 3)

I would like to do a comparative calculation for my bachelor thesis. I have already calculated all impairments for the incurred and expected loss model. (Table is in German: Risikovorsorge = Loan loss provision; Zeitpunkt = Time)

Can someone show me how to calculate the CECL?

Nominal amount: 1.000.000€

Duration: 4 Years

Interest rate: 5%

enter image description here enter image description here

Improve this question
$\endgroup$
2
  • 2
    $\begingroup$ You may find the references here quant.stackexchange.com/questions/59233/… helpful $\endgroup$
    – Dimitri Vulis
    Dec 12, 2020 at 16:11
  • $\begingroup$ hey, thank you for the literature tips! They have definitely brought me further. Unfortunately, I still haven't quite solved the problem and need help with the calculation in Excel. $\endgroup$
    – user51037
    Dec 13, 2020 at 8:24

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.