Horizontal Analysis
Condensed Balance Sheet
PT XL AXIATA Tbk Condensed Balance Sheet (in millions of Rupiah) 31 Desember Increase or (Decr 2011 2010
2011
Amount
Assets
Current asset
2,228,017
3,387,237
1,159,220
25,023,264
27,783,417
2,760,153
27,251,281
31,170,654
3,919,373
Long-term liabilities
10,973,174
8,749,930
-2,223,244
Short-term liabilities
4,563,033
8,728,212
4,165,179
Total liabilities
15,536,207
17,478,142
1,941,935
850,800
851857
1,057
Additional paid-in capital
5,356,332
5,414,099
57,767
Retained earnings
5,507,942
7,426,556
1,918,614
Total stockholder's equity
11,715,074
13,692,512
1,977,438
Total liabilities & stockhorder's equity
27,251,281
31,170,654
3,919,373
Plant asset Total assets Liabilities
Stockholer's Equity
Common stock, Rp. 100 par
Horizontal Analysis
Condensed Balance Sheet PT XL AXIATA Tbk Condensed Balance Sheet (in millions of Rupiah) 31 Desember Increase or (Dec 201 2011
2012
Amount
Assets
Current asset
3,387,237
3,658,985
271,748
27,783,417
31,796,720
4,013,303
31,170,654
35,455,705
4,285,051
Long-term liabilities
8,749,930
11,345,673
2,595,743
Short-term liabilities
8,728,212
8,739,996
11,784
Total liabilities
17,478,142
20,085,669
2,607,527
851857
852,628
771
Additional paid-in capital
5,414,099
5,454,351
40,252
Retained earnings
7,426,556
9,063,057
1,636,501
Total stockholder's equity
13,692,512
15,370,036
1,677,524
Total liabilities & stockhorder's equity
31,170,654
35,455,705
4,285,051
Plant asset Total assets Liabilities
Stockholer's Equity
Common stock, Rp. 100 par
Horizontal Analysis
Condensed Income Statement PT XL AXIATA Tbk Condensed Income Statement (in millions of Rupiah) For The Year Ended 31 December, 2011 Increase or (Decrease) 2011 2010
2011
Net Sales
17,057,760
18,260,144
1,202,384
Operating expenses
12,072,835
13,816,781
1,743,946
4,984,925
4,443,363
-541,562
111,660
176,066
64,406
Finance cost
1,228,604
754,786
-473,818
Income before income tax
3,867,981
3,864,643
-3,338
976,720
1,034,542
57,822
2,891,261
2,830,101
-61,160
Income from operation
Amount
Other revenues and gains
Finance income Other exppenses and loses
Income tax expenses Net income
P
Horizontal Analysis
Condensed Income Statement PT XL AXIATA Tbk Condensed Income Statement (in millions of Rupiah) For The Year Ended 31 December, 2012 Increase or (Decrease 2011 2011
2012
Net Sales
18,260,144
20,969,806
2,709,662
Operating expenses
13,816,781
16,617,343
2,800,562
4,443,363
4,352,463
-90,900
176,066
181,292
5,226
754,786
782,334
27,548
Income before income tax
3,864,643
3,751,421
-113,222
Income tax expenses
1,034,542
986,774
-47,768
Net income
2,830,101
2,764,647
-65,454
Income from operation
Amount
Other revenues and gains
Finance income Other exppenses and loses
Finance cost
Vertical Analysis
Condensed Balance Sheet PT XL AXIATA Tbk Condensed Balance Sheet (Rp Miliar) 31 Desember 2012 Amount
201 Percent
Amount
Assets
Current Assets
3659
10.32%
3387
Plant Assets
31797
89.68%
27783
Total Assets
35456
100%
31170
8740
24.65%
8728
Long-term Liabilities
11346
32.00%
8750
Total Liabilities
20086
57%
17478
Share Capital and additional paid in capital
6307
17.79%
6266
Retained Earning
9063
25.56%
7427
Total Equity
15370
43%
13693
Total Liabilities and Stockholders'Equity
35456
100%
31170
Liabilities
Current Liabilities
Stockholders' Equity
Vertical Analysis
Condensed Income Statement PT XL AXIATA Tbk Condensed Income Statement (Rp Miliar) For the year ended December 31 2012 Amount
2011 Percent
Amount
Percent
Net Sales
20969806
100%
18260144
10
Operating Expense
16617343
79.24%
13816781
75.6
4352463
20.76%
4443363
24.3
181292
0.86%
176066
0.9
782334
3.73%
754786
4.1
3751421
17.89%
3864643
21.1
986774
4.70%
1034542
5.6
2764647
13.19%
2830101
15.5
Income from operation Other Revenues and Gains
Finance Income Other Expenses and Losses
Finance Cost Income Before Income Tax
Income Tax Expenses Net Income
Solvency Ratio Th 2012
Debt to Total Assets Ratio
= Total Debt/Total Asset * 100% = 20086/35456 * 100% = 57%
Th 2011
Debt to Total Assets Ratio
= Total Debt/Total Asset * 100% = 17478/31170 * 100% = 56%
Th 2010
Debt to Total Assets Ratio
= Total Debt/Total Asset * 100% = 15536/27251 * 100%
= 57%
Profitability Ratio Th 2012
Profit Margin = Net Income/Net Sales * 100% = 2764647/ 20969806 * 100% = 13.9% Assets Turnover
= Net Sales/Average Assets = 20969806/ ((35456+31170)/2) = 20969806/33313 = 629.48
Return on Assets
= Net Income/Average Assets = 2764647/33313 = 82.99
Th 2011
Profit Margin = Net Income/Net Sales * 100% = 2830101/ 18260144 * 100% = 15.5% Assets Turnover
= Net Sales/Average Assets = 18260144/ ((27251+31171)/2)
= 18260144/29211 = 625.11 Return on Assets = Net
Income/Average Assets = 2830101/29211 = 96.88
Th 2010
Profit Margin = Net Income/Net Sales * 100% = 2891261/17057760 * 100% = 16.95% Liquidity Ratio
a.
Current Ratio
= Current Assets / Current Liabilities
Tahun 2010
= 2228017/4563033 =0,48827545
Tahun 2011
= 3387237/8728212 = 0.388079139
Tahun 2012
= 3658985/8739996 =0.418648361
b.
Receivable Turnover
= Net Credit sales/ Average Net Receivable (angka dalam miliar
rupiah)
Tahun 2011
= 18260 / 602 = 30,33
Tahun 2012
= 20970 / 599 = 35
c.
Average Collection Period
= 365 hari/Receivable Turnover
Tahun 2011
= 365 hari/30
= 12 hari
Tahun 2012
= 365 hari/35 = 10 hari
