Home
/
Retail Banking Operations
/
Mission 28
caseSQL
Retail Banking Operations Path · Mission 28 of 30
Master
NSF/OD fee cap scenario by FICO band
Scenario modeling with LEAST + per-segment impact decomposition
Unlock with Pro
→
Back to Retail Banking Operations
The Brief
You'll practice
LEAST scenario operator
Segment impact
← Previous
Mission 27
Next →
Mission 29
All 30 missions in Retail Banking Operations Path
↓
1.
Peek at the customer book
2.
Product taxonomy inventory
3.
Open accounts right now
4.
Active deposit customers by state
5.
Net new checking accounts this week
6.
Branch 13 missing transactions
7.
CD maturity wall (next 90 days)
8.
Primary banking relationship classification
9.
NSF / OD fee revenue by FICO band
10.
ATM in-network vs foreign economics
11.
Deposit beta on MMAs (cycle-to-date)
12.
Rate-tier balance distribution
13.
Average daily balance for fee waivers
14.
Dormant account audit (180+ days silent)
15.
Onboarding funnel: 90-day primary-relationship rate
16.
Monthly interest income by product category
17.
Branch consolidation candidate score
18.
2025 closed-account exit cohort with tenure
19.
Loan-to-Deposit ratio by region
20.
Cross-sell candidate model: cash-back card
21.
Deposit balance by acquisition channel
22.
Tier-break top-up candidates (Savings/MMA)
23.
FDIC insurance bucket stress test
24.
Reg E dispute aging report
25.
Customer 360 — top depositors
26.
Branch-level P&L with FTP overlay
27.
Deposit beta by product subcategory
28.
NSF/OD fee cap scenario by FICO band
29.
Treasury daily liquidity dashboard
30.
Retail Ops capstone scorecard