• views: 132
• date: 8 October 2025
• posted by: voska89

Master IFRS 9 Probability of Default (PD) & Expected Credit Loss (ECL) modelling with Excel , end-to-end automation
What you'll learn
Build and validate Point-in-Time (PIT) Probability of Default (PD) models in Excel using real credit risk data.
Apply IFRS 9 staging rules and SICR assessments (Stage 1, 2, 3) with Excel formulas and logic.
Perform forward-looking calibration and scenario analysis by integrating macroeconomic variables in Excel.
Design and implement Lifetime PD models (cohort, survival, transition matrix approaches) in Excel.
Design and implement Lifetime PD models (cohort, survival, transition matrix approaches) in Excel.
Automate credit risk modelling workflows in Excel with dashboards and pivot tables
Requirements
A basic working knowledge of Microsoft Excel (formulas, pivot tables, charts).
A general understanding of finance or banking concepts (loans, credit risk, defaults) is helpful but not mandatory.
Microsoft Excel 2016 or later (or Office 365) installed on your computer.
No prior programming or advanced statistics knowledge required — all modelling is done step-by-step in Excel.
Description
This course contains the use of artificial intelligence.Are you ready to take your credit risk skills to the next level?This flagship course, IFRS 9 PIT PD: Credit Risk Modeling in Excel, provides a complete, hands-on framework for building, validating, and automating Probability of Default (PD) and Expected Credit Loss (ECL) models in line with IFRS 9 regulations — all within Microsoft Excel.You will learn how to:Prepare and clean real-world loan and macroeconomic data in Excel.Build Point-in-Time (PIT) Probability of Default (PD) models step-by-step using Excel formulas, pivot tables, and regression tools.Apply model validation techniques (KS, Gini, ROC, PSI) directly in Excel.Perform forward-looking calibration and scenario analysis using Excel's Data Tables and Scenario Manager.Implement IFRS 9 staging rules (Stage 1, 2, 3) and Significant Increase in Credit Risk (SICR) triggers with Excel formulas.Develop Lifetime PD curves using cohort, survival, and transition matrix methods.Calculate and report Expected Credit Loss (ECL) with Excel templates ready for regulatory disclosure.Automate processes with Excel dashboards, formulas, and VBA macros for monitoring and reporting.By the end of this course, you will have a fully functional IFRS 9 Excel model that transforms raw data into clear, auditable PD and ECL outputs.This course is ideal for credit risk analysts, finance professionals, and students who want to master IFRS 9 modelling without relying on complex coding platforms like SAS or Python.
Who this course is for
Credit Risk Analysts who want to build IFRS 9 Probability of Default (PD) and Expected Credit Loss (ECL) models directly in Excel.
Finance and Accounting Professionals seeking practical skills to apply IFRS 9 impairment requirements without coding.
Auditors, Risk Managers, and Regulators who need to understand, validate, and challenge IFRS 9 models.
Students and Graduates in finance, banking, or data-related fields looking to gain hands-on IFRS 9 modelling skills for career advancement.
Anyone interested in mastering IFRS 9 credit risk modelling in a clear, Excel-based environment without relying on complex programming.
Homepage
https://www.udemy.com/course/ifrs-9-pit-pd-credit-risk-modeling-in-excel/




   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.