Udemyintermediateen

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.

4.0(1)
31students
10h 16m
Certificate
Taipa Gibon Huchu
Taipa Gibon HuchuCredit Risk Modeler and Data Scientist

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.

$ whoami — the devs behind tutorialsearch.io

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.

5.0(11)
1h 33m
all

Pitching Perfection

by Rosie Bell

5.0(3)
55m
beginner
5.0(9)
1h 15m
beginner