IFRS 9 PIT PD: Credit Risk Modeling in Excel
Learn IFRS 9 PD & ECL modeling using Excel. Automate end-to-end calculations for accurate credit loss assessments.
Course Content
IFRS 9 PIT PD: Credit Risk Modeling in Excel is an intermediate-level Udemy course taught by Taipa Gibon Huchu. It runs 10h 16m, is taught in English, and includes a certificate of completion. Learners rate it 4.0 out of 5 from 1 review, with 31 students enrolled. It is a paid course, first published October 2025.
Ready to advance your credit risk expertise? This comprehensive course empowers you to master IFRS 9 credit risk modeling using Microsoft Excel.
Gain a practical, hands-on framework for building, validating, and automating Probability of Default (PD) and Expected Credit Loss (ECL) models, fully compliant with IFRS 9 regulations. No complex coding required!
Here's what you'll learn:
- Data Preparation & Cleaning: Learn to prepare and clean real-world loan and macroeconomic data effectively within Excel.
- PD Model Building: Develop Point-in-Time (PIT) PD models step-by-step, leveraging Excel formulas, pivot tables, and regression techniques.
- Model Validation: Apply essential model validation techniques (KS, Gini, ROC, PSI) directly in Excel to ensure model reliability.
- Forward-Looking Analysis: Perform robust forward-looking calibration and scenario analysis using Excel's Data Tables and Scenario Manager.
- IFRS 9 Staging & SICR: Implement IFRS 9 staging rules (Stage 1, 2, 3) and Significant Increase in Credit Risk (SICR) triggers using Excel formulas.
- Lifetime PD Curve Development: Develop lifetime PD curves using cohort, survival, and transition matrix methods.
- ECL Calculation & Reporting: Accurately calculate and report Expected Credit Loss (ECL) using ready-to-use Excel templates for regulatory disclosure.
- Automation with Excel: Automate key processes with dynamic Excel dashboards, powerful formulas, and VBA macros for efficient monitoring and reporting.
By the end of this course, you'll possess a fully functional IFRS 9 Excel model capable of transforming raw data into clear, auditable PD and ECL outputs.
This course is perfect for credit risk analysts, finance professionals, and students seeking to master IFRS 9 modeling without needing to learn complex coding platforms like SAS or Python. Learn to confidently manage and report on credit risk using the familiar and powerful tool of Microsoft Excel.
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.