Vertical Analysis PDF
Vertical Analysis PDF
Vertical Analysis PDF
Balance Sheet
2013
Assets
Cash
with treasury banks
and
2012
Vertical Analysis
157,229,517
7.99%
9.76%
4 7,980,032
3.34%
2.97%
balance
135,476,687
57,341,769
35,271,477
2 4,828,255
2.1%
1.54%
Investments
826,062,308
797,094,548
48.17%
49.49%
Advances
563,700,737
4 99,817,906
32.86%
31.03%
25,706,315
2 3,632,324
1.5%
1.46%
Other assets
66,609,013
5 3,835,409
3.88%
3.34%
6 ,056,483
0.29%
0.376%
5,103,072
1,715,271,378
1 ,610,474,474
100.00%
100.00%
Bills payable
19,422,316
18,943,207
1.23 %
1.28%
Borrowings
107,864,424
196,588,138
6.85%
13.30%
1,401,229,814
1,214,963,700
89.08%
82.21%
Sub-ordinate loan
2,633,115
5 ,440,654
0.167%
0.368%
Other liabilities
41,687,455
4 1,809,119
2.65%
2.829%
Total Liabilities
1,572,837,124
1,477,744,818
100%
100%
Net Assets
142,434,254
132,729,656
Share Capital
13,335,023
12,122,748
Reserves
43,550,373
3 9,379,354
Inappropriate Profit
73,748,915
67,215,111
Total equity
130,634,311
1 18,717,213
9,913,827
1 2,785,236
1,886,116
1,227,207
142,434,254
132,729,656
Liabilities
Vertical analysis
Income Statement
Rs in thousand
2013
2012
Vertical 2013
Vertical
2012
Markup/return/interest
earned
120,222,773
116,772,653
100.00
100.00
Markup/return/interest
expensed
65,207,109
59,012,392
54.23%
50.53%
Net
Markup/return/interest
earned income
55,015,664
57,760,261
45.76%
49.46%
Provision
against
performing loans and advances
1,602,738
7 ,243,887
1.33%
6.20%
22,427
7,015
0.018%
0.0060%
(225,306)
(483,865)
-0.187%
-0.14%
Total provision
1,399,859
6,767,037
1.16%
5.79%
5 3,615,805
50,993,224
44.59%
43.66%
8,291,686
6 ,785,687
42.91%
42.51%
1,785,462
1,690,100
9.1%
10.58%
Dividend income
759,345
490,213
3.93%
3.07%
2 ,299,131
2,568,079
11.90%
16.09%
2,313,847
1,360,596
11.97%
8.52%
(12,815)
25,253
-0.066%
0.158%
Other income
3,886,624
3 ,040,178
20.11%
19.05%
Net
markup/interest
after provisions
Non-markup/interest
income
Fee,
commission
brokerage income
non-
income
and
100%
100%
30,381,020
156.81%
133.299%
(48,390)
277,848
0.210%
1.219
Other charges
23,175
18,285
0.1..%
0.080%
7 21,115
714,420
3.13%
3.13%
36,805,757
31,391,573
159.83%
137.73%
36,133,328
35,561,757
156.91%
156.03%
current
10,610,047
12,812,589
46.07%
56.21%
Prior years
(117,510)
4 21,210
-0.51%
1.85%
deferred
2,613,696
(463,640)
11.35%
-2,03%
Total taxation
13,106,233
12,770,159
56.91%
56.03%
23,027,095
22,791,598
100%
100%
22,863,123
22,691,922
Non-controlling interest
(75,652)
(56,174)
239,624
155,850
23,027,095
22,791,598
17.15
17.02
1 9,323,280
15,960,106
Overall earning
72,939,085
66,953,330
Administrative expenses
36,109,857
Taxation
HORIZONTAL ANALYSIS
Balance Sheet
Assets
Cash
with treasury banks
and
2013
2012
Horizontal Analysis
135,476,687
157,229,517
(21752830)
-13.8%
9361737
19.51%
balance
57,341,769
35,271,477
2 4,828,255
10443222
42.06%
Investments
826,062,308
797,094,548
28967760
3.63%
Advances
563,700,737
4 99,817,906
63882831
12.78%
25,706,315
2 3,632,324
2073991
8.77%
Other assets
66,609,013
5 3,835,409
12773604
23.72%
6 ,056,483
(953411)
-15.7%
5,103,072
4 7,980,032
1,715,271,378
1 ,610,474,474
104796904
6.5%
Bills payable
9,422,316
18,943,207
Borrowings
107,864,424
196,588,138
(88723714)
-45.1%
1,401,229,814
1,214,963,700
186266114
15.3%
Sub-ordinate loan
2,633,115
5 ,440,654
(2807539)
-51.6%
Other liabilities
41,687,455
4 1,809,119
( 121664)
-0.29%
Total Liabilities
1,572,837,124
1,477,744,818
95092306
6.4%
Net Assets
142,434,254
132,729,656
Share Capital
13,335,023
12,122,748
1212275
10%
Reserves
43,550,373
3 9,379,354
4171019
10.59%
Inappropriate Profit
73,748,915
67,215,111
6533804
9.7%
Liabilities
479109
9704598
2.5%
7.3%
Total equity
130,634,311
1 18,717,213
11917098
10.03%
9,913,827
1 2,785,236
(2871409)
-22.4%
1,886,116
1,227,207
658909
53.69%
142,434,254
132,729,656
9704598
7.311%
Horizontal analysis
Income Statement
Rs in thousand
2013
2012
Horizontal
analysis
Markup/return/interest
earned
120,222,773
116,772,653
3450120
2.95%
Markup/return/interest
exp
65,207,109
59,012,392
6194717
10.49%
Net
Markup/return/interest
earned income
55,015,664
57,760,261
(2744597)
-4.75%
Provision
against
performing loans and advances
1,602,738
7 ,243,887
(5641149)
-77.87%
22,427
7,015
15412
219.7%
(225,306)
(483,865)
(258559)
53.4%
Total provision
1,399,859
6,767,037
(5367178)
-79.31
5 3,615,805
50,993,224
2622581
5.14%
8,291,686
6 ,785,687
1505999
22.19%
1,785,462
1,690,100
95362
5.64%
Dividend income
759,345
490,213
269132
54.90%
2 ,299,131
2,568,079
(268948)
-10.47%
Net
markup/interest
after provisions
Non-markup/interest
income
Fee,
commission
brokerage income
non-
income
and
2,313,847
1,360,596
953251
70.06%
(12,815)
25,253
(12483)
-49.25%
Other income
3,886,624
3 ,040,178
846446
27.8%%
1 9,323,280
15,960,106
3363174
21.07%
72,939,085
66,953,330
5985755
8.94%
Administrative expenses
36,109,857
30,381,020
5728837
18.86%
(48,390)
277,848
(326238)
117.41%
Other charges
23,175
18,285
4890
26.74%
7 21,115
714,420
6695
0.937%
36,805,757
31,391,573
5414184
17.25%
36,133,328
35,561,757
571571
1.60%
current
10,610,047
12,812,589
(2202542)
-17.19%
Prior years
(117,510)
4 21,210
(538720)
127.89%
deferred
2,613,696
(463,640)
2150056
463.73%
Total taxation
13,106,233
12,770,159
336074
2.63%
23,027,095
22,791,598
235497
1.033%
22,863,123
22,691,922
171201
0.75%
Non-controlling interest
(75,652)
(56,174)
19478
34.67%
239,624
155,850
83774
53.75%
23,027,095
22,791,598
235497
1.033%
17.15
17.02
Taxation
RATIO ANALYSIS
1)LIQUIDITY RATIO
=(Current assets/ current liabilities)
2012
2013
Current assets
230037804
228089933
Current Liabilities
1430495045
1528516554
Liquidity Ratio
0.16
0.14
Interpretation :
Current ratios are the relationship between current asset and current liabilities and show the
ability of the company to pay back its current liabilities by utilizing its current assets. The current
ratio for HBL in 2012 was 0.14 that increases in 2013 to 0.16.
2012
Total Debt
1,572,837,124
1,477,744,818
Total assets
1,715,271,378
1 ,610,474,474
0.916
0.9175
ratio
Interpretation:
Total debt includes both the current liabilities and long term debt. The table shows that in 2013
debt ratio was less and its was 0.916 which means that total debt are lower then total assets
.
2012
Total Debt
1,572,837,124
1,477,744,818
Total equity
130,634,311
1 18,717,213
12.04
12.44
Interpretation :
Debt equity ratio indicates the relationship between long term debt and the total equity of the
bank. In 2012 this ratio was 12.44 which decreases in 2013 to 12.04.
2012
Fixed assets
25,706,315
2 3,632,324
Total equity
130,634,311
1 18,717,213
0.196
0.199
Interpretation:
This ration shows the relationship between fix assets and the equity held by the bank. This ratio
shows that how much times your fixed asset are of your equity. This ration stands at 0.199 in
2013 which means that the fixed asset are 0.199 time of the equity of bank.
5)WORKING CAPITAL
= (Current assets current liabilities )
2013
2012
Current assets
228089933
230037804
Current liability
1528516554
1430495045
Working capital
(1300426621)
(1200457241)
Interpretation
This ration is the difference between the current asset and current liabilities. That is the amount
used for day to day operations of the company. The ratio was less in 2012 while increase in
2013. It is good for the bank if the bank treats it like a reserve account.
6) RETURN ON ASSETS
2012
Net Income
23,027,095
22,791,598
Total assets
1,715,271,378
1 ,610,474,474
Return on assets
1.34%
0.14%
Interpretation
This ration indicates the relationship between net profit and total assets. The main objective of an
organization is to maximize its return on assets. The ROA is maximum in 2013.
23,027,095
No of outstanding shares
1342688
EPS
17.15
2012
22,791,598
1339107
17.02
Interpretation
This ration indicates the relationship between number of outstanding shares and earning on them.
The main objective of an organization is to maximize return on shares. The EPS is maximum in
2013.
8) RETURN ON DEPOSIT:
= ( N.P.A.T * 100/Total Deposit)
2013
2012
Net income
23,027,095
22,791,598
Total deposits
1401230
1214964
ROD
1643.34
1875.90
Interpretation
This ration indicates the relationship between net profit and total deposits. The main objective of
an organization is to maximize its return on deposits. The ROA is maximum in 2012.
9)CASH/DEPOSIT RATIO:
= (cash/current liabilities) or (cash/current deposits)
2013
2012
cash
135,476,687
157,229,517
Total deposits
1401230
1214964
COD
96.68
129.410
Interpretation:
This ratio shows that the cash is enough for payment of current liabilities or not.
2012
Interest income
72,939,085
66,953,330
Total income
23,027,095
22,791,598
3.167
2.93
Interpretation:
This ratio describes the relationship between total interest earned and net income. The table
shows that ratio is greater in 2013.
2013
2012
Net profit
23,027,095
22,791,598
Noof branches
1594
1540
14446.1072
14799.73
Interpretation:
This ratio describe the average profit per branch as number of branches increases in 2013
so there is a little decrease in average profit.