babymore87
MyBoerse.bz Pro Member
Free Download IFRS 9 PIT PD Credit Risk Modeling in Excel
Published 10/2025
Created by Taipa Gibon Huchu
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English | Duration: 120 Lectures ( 8h 29m ) | Size: 3.38 GB
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
repare 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
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
No Password - Links are Interchangeable
