Dashboard Target Setting

2024 Annual Target Setting

Target Calculation Progress
1
Historical Analysis
Completed
2
Threshold Calculation
Completed
3
Baseline Computation
87% Complete
4
Projection Integration
Pending
5
Final Target Generation
Pending
Target Distribution Analysis
Achievable Targets: 89% (139 RMs)
Stretch Targets: 11% (17 RMs)
Avg Increase vs 2023: +1.8%
Risk-Adjusted Distribution
Data Validation Status
Finance Projections ✓ Validated
Historical RAROC ✓ Validated
Asset Projections ⚠ 3 Missing CIDs
RM Hierarchy ✓ AD Synced
Maker-Checker Workflow
Maker: John Smith
Completed: 2024-01-15
Checker: Sarah Wilson
Status: Pending Review
McKinsey Methodology Reverse Engineering & Advanced Analytics

Methodology Components

Sub-segment Thresholds ✓ Active
Baseline Computation ✓ Live
Mid-Year Recalibration ⚡ Ready

System Integrations

RAROC MIS ✓ Connected
CIBG Performance ✓ Live
Active Directory 🔄 Auto-Sync

File Format Support

Excel (xlsx, xls) ✓ Supported
CSV & TXT ✓ Supported
Direct DB Connection ✓ Available

Historical vs Simulation Tracking

Track correlation between simulated and actual RAROC for retrospective analysis
Correlation Accuracy: 87.3%
MCC Reports Tracked: 1,247

Risk Concentration Alerts

Monitor portfolio concentration risks across segments and geographies
Trade Finance Concentration: 34.2% ⚠
Geographic Risk (Asia): 18.7% ✓
Sub-Segment Thresholds (AI Calculated)
Segment 2023 Actual Threshold Recommended Adjustment
Corporate Banking 18.5% 16.2% 17.8%
17.8%
SME Banking 15.2% 14.1% 15.5%
15.5%
Trade Finance 21.3% 18.9% 20.1%
20.1%
Project Finance 12.8% 11.5% 13.2%
13.2%

Hierarchical Drill-Down Analysis

Organizational Hierarchy
Segment → Division Head → Regional Manager → Unit Manager → RM → Customer → Products → Deal
Cross-Dimensional Analysis
Product × Performance × Location × Geography × Tenure × Risk Rating
Economic Projections Integration
Data Source: CIBG Performance Team File: Economic_Projections_2024.xlsx ✅ Validated

Key Assumptions:

  • GDP Growth: 3.2% → 2.8% (Q4 adjustment)
  • Interest Rates: Base rate +50bps expected
  • Credit Losses: 15% increase in Stage 2 migrations
  • Asset Growth: 8% overall, 12% in trade finance

Multi-Format Data Upload & Validation

Finance Projections
Economic_Projections_2024.xlsx
✓ 15,247 records validated
Asset Projections
CIBG_Assets_Q1_2024.csv
⚠ 3 CIDs require attention
Preliminary Target Results
AI Analysis
Confidence Level: 78% - Targets are achievable based on historical performance and market conditions.
Stress Test: Targets remain valid under 2 of 3 adverse scenarios.
Risk Alert: 🔴 High concentration in Trade Finance - consider diversification targets.
156
Total RMs
18.2%
Avg Target

RM Level Targets (Sample)

Sarah Johnson
Corporate Banking | vs 2023: 18.5%
19.2%
🎯 Achievable
David Park
Corporate Banking | vs 2023: 17.9%
18.8%
🎯 Achievable
Mike Chen
SME Banking | vs 2023: 14.2%
15.8%
📈 Stretch Target
Lisa Wong
Trade Finance | vs 2023: 19.8%
20.5%
🎯 Achievable
MCC Repository & Historical Tracking
Complete repository of RAROC reports presented at MCC with CID-based historical tracking
Total MCC Reports: 1,247
Historical Accuracy: 87.3%
Mid-Year Recalibration Available
New concentration capital rules effective Q3. Click to recalibrate targets while keeping thresholds constant.
Status: Ready for CIBG Review
Next: CIBG Approval → Final Publication → RM Communication