Six-day masterclass · Kigali, Rwanda · 2026
Financial Modelling for Credit Risk
Build and use financial models to make credit decisions: from a borrower’s statements to cash flow, debt capacity, rating, expected loss, stress testing and risk-adjusted pricing.
Four levels of mastery
How the week works
Decision cases
Each level opens with a case: a protagonist, a deadline, a decision. You take a position before the method is taught.
Build it the same day
Every concept becomes a working Excel model. No session is slides only.
Learning teams
Cross-functional teams of four or five, fixed for the week, with a rotating lead.
Simulations
Credit committee panels and Board Risk Committee briefings under time pressure.
All borrowers, banks and figures on this site are fictional and synthetic. Delivered by Shalton Ogola for Ikhaya Credit Analytics and Matengo & Associates.
Programme
Six days, four levels
Choose a level to see its days, sessions and case. Standard day 08:30 to 16:30, 39 contact hours in total.
Daily rhythm
| Time | Block | Purpose |
|---|---|---|
| 08:30 – 09:00 | Cold open | Retrieval quiz on the previous day; overnight questions |
| 09:00 – 10:30 | Session 1 | Usually the case discussion |
| 10:45 – 12:30 | Session 2 | Method and guided build |
| 13:30 – 15:00 | Session 3 | Build |
| 15:15 – 16:15 | Session 4 | Application, simulation or presentation |
| 16:15 – 16:30 | Exit ticket | Five questions; next day’s case handed out |
Assessment
| Component | Description | Weight |
|---|---|---|
| Conceptual understanding | Daily exit tickets and the post-course assessment | 20% |
| Applied technical work | Daily workbooks and level deliverables | 40% |
| Simulation performance | Credit committee panels and Board Risk Committee | 20% |
| Capstone | Board pack and panel defence | 20% |
Certificate of completion at 70% overall, distinction at 85%. The Applied Practitioner endorsement follows a 90-day project in your own institution.
Level I · Foundation · Day 1
The Structural Blueprint
Reading a borrower’s financial statements the way a lender must: quality of earnings, the ratios that matter for repayment, and the walk from profit to cash available for debt service.
Case · Wednesday, 18 March 2026
Profit Up, Cash Down
Nyabarongo Building Supplies Ltd, a Kigali distributor of cement, steel and roofing, grew sales by 30% and profit by 18% in FY2025. Its relationship manager at Inzira Commercial Bank wants the overdraft raised from RWF 1.5 billion to RWF 2.5 billion by Friday: “Best year they have ever had… This should be straightforward.”
Senior credit analyst Aline Uwase opens the balance sheet and stops. Where did the cash go, and would the extra billion come back?
Your decision: support the request, cut it, or restructure it?
Nyabarongo, Inzira and every person in the case are fictional.
Interactive · Level I
Cash Flow Lab: Nyabarongo FY2025
Move the drivers and watch profit, cash, covenants and the overdraft respond. It starts at the audited FY2025 position.
Covenants
What is the working capital funding?
Simplified model: opex at 10.4% of revenue, D&A 170, interest 330, tax 28%, capex 900, dividends 150, term loan drawn 800 and repaid 200, year-end cash held at 47. At the starting position it matches the workbook to within rounding.
Day 1 · Exit ticket
Five questions, ten minutes
Answer each question; you see the explanation straight away. Your score is not stored.
Resources
Materials
Programme document
Four levels, six days, assessment and certificationLevel I case: Profit Up, Cash Down
Read before Day 1Day 1 workbook (participant)
Excel; complete the yellow cellsDays 2 to 6
Cases and workbooks are released the evening before each dayRecommended reading
- Ganguin and Bilardello, Standard & Poor’s Fundamentals of Corporate Credit Analysis (Levels I–IV)
- Glantz and Mun, Credit Engineering for Bankers, 2nd edition (Levels I–IV)
- Sundarka, Financial Modelling (Levels I–II)
- Zebralearn, The Industry Handbook (Level II)
- Goel, Financial Statements Analysis: Cases from Corporate India (Level I)
- Scalia (ed.), Corporate Credit Analysis and AI (Level III)
- Davis and Sihler, Financial Turnarounds: Preserving Enterprise Value (Level IV)
Regulatory references
- BNR Regulation No. 86/2024 on credit facilities classification and provisioning for banks
- BNR Guidelines on IFRS 9 (2023)
- BNR Regulation No. 80/2023 on related party transactions and credit concentration risk
- IFRS 9 Financial Instruments; IFRS 7 Financial Instruments: Disclosures