This is a Retail Banking Balanced Scorecard Report, it is one of reports that Balanced Scorecard Designer can generate for Retail Banking scorecard. With this software you can also design your own KPIs, Balanced Scorecards and metrics.


Retail Banking

Report includes: 1 month(s) 49 day(s), from 05.04.2008 to 24.05.2008

  Name Start value End value Dynamic Contains
Root Retail Banking 46,48 % 47,48 % + 1 %
Income metrics(38,7%, -0,3%Down)
Investment return metrics(34,6%, -20,27%Down)
Cost metrics(73,8%, 23,77%Up)
Interest margin metrics(43,7%, 16%Up)
Company assets metrics(41,5%, -2,02%Down)
Risk metrics(52,6%, -11,2%Down)

Graph for Retail Banking

Graph for Retail Banking

Data for Retail Banking

DatesValue
05.04.200846,48
12.04.200853,55
19.04.200838,46
26.04.200845,09
03.05.200850,55
10.05.200854,93
17.05.200849,85
24.05.200847,48

Income metrics

  Name Start value End value Dynamic Parent Contains
Root Income metrics 39,02 % 38,72 % -0,3% Retail Banking
Indicators
Non-interest income level
Fee income level
Gross profit
Interest spread *
* - Information for this metric is limited in sample report

Graph for Income metrics

Graph for Income metrics

Data for Income metrics

DatesValueWeight
05.04.200839,021
12.04.200867,951
19.04.200855,721
26.04.200844,351
03.05.200837,71
10.05.200833,071
17.05.200823,031
24.05.200838,721

Non-interest income level

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Non-interest income level 15,165 24,735 + 9,57 % Maximize Income metrics
Description Non-interest income divided by operating income, multiplied by 100

Graph for Non-interest income level

Graph for Non-interest income level

Data for Non-interest income level

DatesWeightMinMaxValue
05.04.20082157015,165
12.04.20082157051,85
19.04.20082157025,505
26.04.20082157047,285
03.05.20082157023,635
10.05.20082157034,36
17.05.20082157034,8
24.05.20082157024,735

Fee income level

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Fee income level 41,58 25,76 -15,82 % Maximize Income metrics
Description Fee income divided by operating income, multiplied by 100

Graph for Fee income level

Graph for Fee income level

Data for Fee income level

DatesWeightMinMaxValue
05.04.2008207041,58
12.04.2008207055,79
19.04.2008207062,3
26.04.2008207031,78
03.05.2008207041,37
10.05.2008207010,29
17.05.200820704,06
24.05.2008207025,76

Gross profit

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Gross profit 10,548 19,626 + 9,078 Score Maximize Income metrics
Description Sales minus cost of sales
Target description Mln. USD

Graph for Gross profit

Graph for Gross profit

Data for Gross profit

DatesWeightMinMaxValue
05.04.2008132010,548
12.04.2008132010,021
19.04.200813208,593
26.04.200813203,68
03.05.2008132011,653
10.05.2008132017,773
17.05.200813207,403
24.05.2008132019,626

Investment return metrics

  Name Start value End value Dynamic Parent Contains
Root Investment return metrics 54,9 % 34,63 % -20,27% Retail Banking
Indicators
Return on capital employed
Return on operating capital
Return on Equity

Graph for Investment return metrics

Graph for Investment return metrics

Data for Investment return metrics

DatesValueWeight
05.04.200854,91
12.04.200848,971
19.04.200820,631
26.04.200850,461
03.05.200852,031
10.05.200854,641
17.05.200880,771
24.05.200834,631

Return on capital employed

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Return on capital employed 19,962 8,016 -11,95 % Maximize Investment return metrics
Description Earnings before interest and tax (EBIT) divided by the total capital employed (shareholders funds + debt), multiplied by 100

Graph for Return on capital employed

Graph for Return on capital employed

Data for Return on capital employed

DatesWeightMinMaxValue
05.04.2008332519,962
12.04.2008332514,44
19.04.200833257,136
26.04.2008332522,184
10.05.200833258,654
17.05.2008332521,92
24.05.200833258,016

Return on operating capital

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Return on operating capital 3,198 5,398 + 2,2 % Maximize Investment return metrics
Description Earnings before interest and tax (EBIT) divided by the total capital employed minus investments, multiplied by 100

Graph for Return on operating capital

Graph for Return on operating capital

Data for Return on operating capital

DatesWeightMinMaxValue
05.04.200823253,198
12.04.2008232517,652
19.04.200823256,696
26.04.200823259,776
03.05.200823257,378
10.05.2008232524,956
17.05.2008232524,274
24.05.200823255,398

Return on Equity

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Return on Equity 20,12 20,22 + 0,1 % Maximize Investment return metrics
Description Net income after tax divided by average ordinary capital, multiplied by 100

Graph for Return on Equity

Graph for Return on Equity

Data for Return on Equity

DatesWeightMinMaxValue
05.04.2008252520,12
12.04.2008252510,36
19.04.2008252510,44
26.04.200825258
03.05.2008252511,28
10.05.2008252515,58
17.05.2008252516,4
24.05.2008252520,22

Cost metrics

  Name Start value End value Dynamic Parent Contains
Root Cost metrics 50,03 % 73,8 % + 23,77% Retail Banking
Indicators
Cost to assets ratio
Overhead cost ratio
Cost to Income

Graph for Cost metrics

Graph for Cost metrics

Data for Cost metrics

DatesValueWeight
05.04.200850,031
12.04.200871,541
19.04.200811,271
26.04.200830,461
03.05.200869,271
10.05.200851,191
17.05.200852,391
24.05.200873,81

Cost to assets ratio

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Cost to assets ratio 6,014 3,356 -2,658 % Minimize Cost metrics
Description Operating expenses divided by average assets over the period, multiplied by 100

Graph for Cost to assets ratio

Graph for Cost to assets ratio

Data for Cost to assets ratio

DatesWeightMinMaxValue
05.04.20083286,014
12.04.20083283,872
19.04.20083287,826
26.04.20083284,904
03.05.20083283,614
10.05.20083283,32
17.05.20083282,588
24.05.20083283,356

Overhead cost ratio

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Overhead cost ratio 2,8897 2,8061 -0,0836 % Minimize Cost metrics
Description Sales, general and administrative costs divided by the total costs, multiplied by 100

Graph for Overhead cost ratio

Graph for Overhead cost ratio

Data for Overhead cost ratio

DatesWeightMinMaxValue
05.04.200812,24,12,8897
12.04.200812,24,13,91
19.04.200812,24,13,9005
26.04.200812,24,14,0791
03.05.200812,24,12,4679
10.05.200812,24,13,8872
17.05.200812,24,13,6763
24.05.200812,24,12,8061

Cost to Income

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Cost to Income 52,56 46,74 -5,82 % Minimize Cost metrics
Description Operating expenses divided by operating income, multiplied by 100

Graph for Cost to Income

Graph for Cost to Income

Data for Cost to Income

DatesWeightMinMaxValue
05.04.20083309052,56
12.04.20083309033,12
19.04.20083309078,06
26.04.20083309078,54
03.05.20083309054,06
10.05.20083309067,38
17.05.20083309075,24
24.05.20083309046,74

Interest margin metrics

  Name Start value End value Dynamic Parent Contains
Root Interest margin metrics 27,7 % 43,7 % + 16% Retail Banking
Indicators
Profit margin
Operating margin
Interest margin

Graph for Interest margin metrics

Graph for Interest margin metrics

Data for Interest margin metrics

DatesValueWeight
05.04.200827,71
12.04.200821,961
19.04.200847,881
26.04.200871,61
03.05.200845,761
10.05.200848,091
17.05.200818,711
24.05.200843,71

Profit margin

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Profit margin 2,4848 2,5784 + 0,0936 % Maximize Interest margin metrics
Description Profit divided by sales, multiplied by 100

Graph for Profit margin

Graph for Profit margin

Data for Profit margin

DatesWeightMinMaxValue
05.04.200831,73,52,4848
12.04.200831,73,51,799
19.04.200831,73,52,3606
26.04.200831,73,52,5784
03.05.200831,73,52,7566
10.05.200831,73,52,015
17.05.200831,73,51,7738
24.05.200831,73,52,5784

Operating margin

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Operating margin 4,012 8,544 + 4,532 % Maximize Interest margin metrics
Description Operating profit divided by sales, multiplied by 100

Graph for Operating margin

Graph for Operating margin

Data for Operating margin

DatesWeightMinMaxValue
05.04.200833254,012
12.04.2008332511,58
19.04.2008332520,314
26.04.2008332524,428
03.05.200833259,6
10.05.2008332522,932
17.05.200833259,028
24.05.200833258,544

Interest margin

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Interest margin 5,695 7,466 + 1,771 % Maximize Interest margin metrics
Description Interest income minus interest expense, divided by average interest earning assets, multiplied by 100

Graph for Interest margin

Graph for Interest margin

Data for Interest margin

DatesWeightMinMaxValue
05.04.200823105,695
12.04.200823104,477
19.04.200823104,288
26.04.200823107,697
03.05.200823106,5
10.05.200823105,114
17.05.200823104,932
24.05.200823107,466

Company assets metrics

  Name Start value End value Dynamic Parent Contains
Root Company assets metrics 43,5 % 41,48 % -2,02% Retail Banking
Indicators
Non-performing assets
Reserve requirement
Return on average assets

Graph for Company assets metrics

Graph for Company assets metrics

Data for Company assets metrics

DatesValueWeight
05.04.200843,51
12.04.200823,051
19.04.200850,581
26.04.200821,41
03.05.200832,221
10.05.200879,681
17.05.200871,931
24.05.200841,481

Non-performing assets

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Non-performing assets 35,4 29,1 -6,3 % Minimize Company assets metrics
Description The amount of non-performing loans divided by the total amount of loans, multiplied by 100

Graph for Non-performing assets

Graph for Non-performing assets

Data for Non-performing assets

DatesWeightMinMaxValue
05.04.20081106035,4
12.04.20081106029,4
19.04.20081106051,8
26.04.20081106038,35
03.05.20081106016,4
10.05.20081106012,6
17.05.20081106032,2
24.05.20081106029,1

Reserve requirement

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Reserve requirement 13,76 13,55 -0,21 % Maximize Company assets metrics
Description A proportion of deposits that must be held by a bank (not lent to borrowers)

Graph for Reserve requirement

Graph for Reserve requirement

Data for Reserve requirement

DatesWeightMinMaxValue
05.04.2008151513,76
12.04.200815156,18
19.04.200815157,13
26.04.200815159,19
03.05.200815155,29
10.05.2008151511,87
17.05.2008151514,39
24.05.2008151513,55

Return on average assets

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Return on average assets 0,34294 0,17647 -0,166 % Maximize Company assets metrics
Description Net profit divided by average assets, multiplied by 100

Graph for Return on average assets

Graph for Return on average assets

Data for Return on average assets

DatesWeightMinMaxValue
05.04.200820,011,80,34294
12.04.200820,011,80,18184
19.04.200820,011,81,48317
26.04.200820,011,80,01358
03.05.200820,011,80,35726
10.05.200820,011,81,39904
17.05.200820,011,81,24689
24.05.200820,011,80,17647

Risk metrics

  Name Start value End value Dynamic Parent Contains
Root Risk metrics 63,75 % 52,55 % -11,2% Retail Banking
Indicators
Value at risk
Capital adequacy ratio

Graph for Risk metrics

Graph for Risk metrics

Data for Risk metrics

DatesValueWeight
05.04.200863,751
12.04.200887,851
19.04.200844,71
26.04.200852,251
03.05.200866,31
10.05.200862,951
17.05.200852,251
24.05.200852,551

Value at risk

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Value at risk 10,072 11,548 + 1,476 Score Minimize Risk metrics
Description The largest amount of capital that a company risks losing with a given level of confidence
Target description Mln

Graph for Value at risk

Graph for Value at risk

Data for Value at risk

DatesWeightMinMaxValue
05.04.2008381210,072
12.04.200838128,968
19.04.2008381211,52
26.04.200838129,66
03.05.200838129,256
10.05.2008381210,788
17.05.200838128,88
24.05.2008381211,548

Capital adequacy ratio

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Capital adequacy ratio 16,895 19,07 + 2,175 % Maximize Risk metrics
Description The amount of capital that must be held in relation to risk-weighted assets

Graph for Capital adequacy ratio

Graph for Capital adequacy ratio

Data for Capital adequacy ratio

DatesWeightMinMaxValue
05.04.2008352016,895
12.04.2008352019,985
19.04.2008352016,61
26.04.2008352011,9
03.05.2008352014,6
10.05.2008352019,34
17.05.200835208,975
24.05.2008352019,07
Created by: AKS-Labs
Report created with Balanced Scorecard Designer at 28.04.2008 23:58:01

Copyright © 2000-2008 AKS-Labs. All rights reserved.