Home › Excel case studies › Loan Portfolio Delinquency Risk Review
Loan Portfolio Delinquency Risk Review
A community bank needs a delinquency review across loan types and branches before the board meeting. Practice risk-rate calculations, at-risk dollar exposure by branch, and portfolio-vs-at-risk value comparisons. **What you'll learn:** - Risk-rate calculations across categorical and geographic dimensions - Working with real dollar-value exposure, not just counts - Building the kind of portfolio-health summary delivered to a board
Open this Excel case study
Work on a realistic business scenario for data analytics and business analytics practice. See the full details and get the assignment on Cellgrids.
View case study → Free Excel formula practiceAll Excel case studies · Excel interview prep · Excel formulas