An insider's view of Basel 3 Derivative capital in MS Excel
Launch your career in Investment Bank Risk & Capital Management. This course equips professionals with essential skills for this in-demand role.
Course Content
An insider's view of Basel 3 Derivative capital in MS Excel is an all-levels Udemy course taught by Sumit Chakravarty PRM, MBA. It runs 3h 49m, is taught in English, and includes a certificate of completion. Learners rate it 4.5 out of 5 from 102 reviews, with 524 students enrolled. It is a paid course, first published February 2021.
Unlock a High-Return Investment with this practical Basel 3 course! Forget theoretical concepts – gain real-world skills applicable immediately. Developed over 10 years of risk management consulting experience across major Investment Banks in Basel 3 and Capital Optimization, this course provides hands-on knowledge using MS Excel.
Experience what it's like to work on a bank's risk management desk. We analyze real data, just like professionals. You'll learn, understand, and simulate key derivative capital calculations in Excel, breaking down Exposure at Default (EAD) into its core components:
- Notional Amount
- Mark to Market
- Gross/Net EAD
- Gross/Net PFE (Potential Future Exposure)
- Incurred CVA (Credit Value Adjustment)
- Risk Weighted Assets (RWA)
Understand the Capital Impact under the Standardised (STND) Approach, utilized by 50% of banks. We'll explore a lookup table based on counterparty exposure class (Sovereign, Institutions, Corporates) and external ratings from agencies like Moody's, S&P, and Fitch, as well as internal ratings.
Then, delve into the more advanced Internal Rating Based (IRB) Approach, employed by the remaining 50% of large banks (requiring regulator approval). Learn to calculate Risk Weighted Assets (RWA) and Capital Impact using:
- Probability of Default (PD)
- Loss Given Default (LGD)
- Weighted Average Maturity (WAM)
Master these critical risk management concepts and gain a competitive edge.
This course provides a deep dive into capital optimization strategies for reducing RWA and improving capital ratios. Benefit from insights into capital management techniques currently used in most banks – a crucial KPI for the future.
Premium Lectures: Explore advanced risk modelling concepts and derive internal rating risk weights in Excel for all counterparties. We'll use Merton & Vasicek models for credit risk, step-by-step, ensuring complete clarity.
No prior Basel 3 or capital management knowledge is required – only basic Excel skills are needed. This course is designed for beginners.
Career Opportunities: Upon completion, you'll be well-prepared for a rewarding career in Risk/Capital Management at top Investment Banks or Commercial Banks. Even if you don't pursue a career in risk, you'll gain invaluable knowledge of this vital banking industry topic.
Start your journey to mastering Basel 3, risk management, and capital optimization today!
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.