Home
/
Retail Banking Operations
/
Mission 26
caseSQL
Retail Banking Operations Path · Mission 26 of 30
Master
Branch-level P&L with FTP overlay
FTP curve join + per-branch NII decomposition with category pivot
Unlock with Pro
→
Back to Retail Banking Operations
The Brief
You'll practice
FTP curve join
Per-branch NII pivot
← Previous
Mission 25
Next →
Mission 27
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