Overview:
This module applies Excel specifically to financial data analysis in the FinTech sector, focusing on retail lending portfolios and credit risk management. Participants will gain hands-on experience with financial modeling, portfolio analysis, and reporting, enhancing their analytical skills in the context of credit risk and financial health assessment.
Topics to Cover:
- Financial modeling techniques in Excel for credit risk analysis
- Creating and interpreting Roll Rate Reports to track delinquency trends
- Generating Loss Provisioning Reports for estimating credit loss allowances
- Performing Vintage Analysis to generate time-based insights on account performance
- Visualizing financial data with charts for reporting and decision-making
- Analyzing credit portfolio health and investment opportunities using Excel tools