Get documents about "Ifrs Financial Statement Xl
Description
Ifrs Financial Statement Xl document sample
Document Sample
Facts and figures Q3 2010 External
Results and KPIs for the period ending 30 September 2010
Index of sheets
- Income statement, cash flows and balance sheet
- Revenues breakdown
- Expenses breakdown
- Profit and margin breakdown
- FTE & MTA impact
- KPN The Netherlands: Consumer market KPI's
- KPN The Netherlands: Business market KPI's
- KPN The Netherlands: Wholesale & Operations KPI's
- KPN The Netherlands: Getronics & iBasis KPI's
- Mobile International: Germany, Belgium, Rest of World KPI's
- Cash flow statement, Capex and Debt summary
- Bond overview
- Wireline tariff list
- Revenues breakdown (Old)
- Expenses breakdown (Old)
- Profit and margin breakdown (Old)
For further information please contact
KPN Investor Relations
Phone +31 70 44 60986
Fax +31 70 44 60593
ir@kpn.com
www.kpn.com/ir
Safe harbor
Non-GAAP measures and management estimates
This financial report contains a number of non-GAAP figures, such EBITDA and free cash flow. These non-GAAP figures should not be viewed as a
substitute for KPN’s GAAP figures. KPN defines EBITDA as operating result before depreciation and impairments of PP&E and amortization and
impairments of intangible assets. Note that KPN’s definition of EBITDA deviates from the literal definition of earnings before interest, taxes, depreciation
and amortization and should not be considered in isolation or as a substitute for analyses of the results as reported under IFRS. In the net debt/EBITDA
ratio, KPN defines EBITDA as a 12 month rolling average excluding book gains, release of pension provisions and restructuring costs, when over EUR
20m. Free cash flow is defined as cash flow from operating activities plus proceeds from real estate, minus capital expenditures (Capex), being
expenditures on PP&E and software and excluding tax recapture regarding E-Plus. The term service revenues refers to wireless service revenues. All
market share information in this financial report is based on management estimates based on externally available information, unless indicated otherwise.
KPN Investor Relations Index Q3 2010
``
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Income statement YTD% Q3%
Revenues 9,954 3,335 3,348 3,271 -1.5% 0.8% 13,451 3,348 10,103 3,307 3,408 3,388
Other income 55 43 6 6 57.1% 79.2% 58 23 35 24 3 8
Revenues and other income 10,009 3,378 3,354 3,277 -1.3% 1.4% 13,509 3,371 10,138 3,331 3,411 3,396
Salaries and social security contributions 1,470 471 493 506 -7.5% -6.2% 2,115 526 1,589 502 541 546
Cost of materials 630 226 199 205 -1.4% 9.2% 852 213 639 207 223 209
Work contracted out and other expenses 3,420 1,160 1,144 1,116 -3.7% 2.0% 4,686 1,136 3,550 1,137 1,182 1,231
Own work capitalized (73) (24) (25) (24) 4.3% 14.3% (98) (28) (70) (21) (28) (21)
Other operating expenses 445 137 157 151 -18.3% -22.6% 762 217 545 177 171 197
Depreciation1 1,052 353 351 348 -9.9% -8.1% 1,550 383 1,167 384 391 392
Amortization1 586 208 196 182 -1.0% 7.8% 792 200 592 193 189 210
Total operating expenses 7,530 2,531 2,515 2,484 -6.0% -1.9% 10,659 2,647 8,012 2,579 2,669 2,764
Operating profit 2,479 847 839 793 16.6% 12.6% 2,850 724 2,126 752 742 632
Finance costs - net (696) (310) (194) (192) 22.5% 71.3% (808) (240) (568) (181) (212) (175)
Share of the profit of associates and joint ventures (38) (17) (11) (10) >500% >200% (6) - (6) (5) (2) 1
Profit before income tax 1,745 520 634 591 12.4% -8.1% 2,036 484 1,552 566 528 458
Income taxes (425) (114) (169) (142) -9.6% -33.3% 139 609 (470) (171) (158) (141)
Profit for the period 1,320 406 465 449 22.0% 2.8% 2,175 1,093 1,082 395 370 317
Profit attributable to minority shareholders 2 - 1 1 n.m. n.m. (3) 1 (4) (3) (1) -
Profit attributable to equity shareholders of parent 1,318 406 464 448 21.4% 2.0% 2,178 1,092 1,086 398 371 317
Earnings per share (non-diluted) 2 0.84 0.27 0.29 0.28 27.3% 8.0% 1.33 0.67 0.66 0.25 0.22 0.19
Earnings per share (fully-diluted) 0.84 0.27 0.29 0.28 29.2% 12.5% 1.33 0.68 0.65 0.24 0.22 0.19
Dividend per share 0.27 - 0.27 - 17.4% n.m. 0.69 0.46 0.23 - 0.23 -
- of which interim dividend 0.27 - 0.27 - 17.4% n.m. 0.23 - 0.23 - 0.23 -
1
Including impairments, if any
2
Calculated by deducting the year-to-date earnings per share of the preceding quarter from the year to date earnings per share of the current year
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Cash flow YTD% Q3%
Net cash flow from operating activities 2,362 1,061 1,072 229 0.4% -9.6% 3,776 1,423 2,353 1,174 1,120 59
Net cash flow from investing activities (1,485) (484) (636) (365) 21.8% 41.9% (1,829) (610) (1,219) (341) (405) (473)
Net cash flow from financing activities (2,412) (1,033) (1,183) (196) n.m. >200% (67) (190) 123 (181) (858) 1,162
Changes in cash and cash equivalents (1,535) (456) (747) (332) n.m. n.m. 1,880 623 1,257 652 (143) 748
-
Tax recapture E-Plus 327 - - 327 0.0% n.m. 343 16 327 - - 327
Free cash flow1 1,616 681 707 228 7.0% -17.7% 2,446 936 1,510 827 739 (56)
Financing policy
Net debt/ EBITDA 2 2.3 2.3 2.3 2.2 2.1 2.1 2.3 2.3 2.3 2.3
1
Net cash flow from operating activities plus proceeds from real estate minus Capex, excluding tax recapture at E-Plus
2
Based on 12 month rolling average excluding book gains/losses, release of pension provisions and restructuring costs, all over € 20m
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Balance sheet
Goodwill 5,766 5,766 5,770 5,765 5,769 5,769 5,672 5,672 5,671 5,670
Licences 2,901 2,901 2,981 2,776 2,853 2,853 2,929 2,929 3,006 3,080
1
Software 778 778 763 766 783 783 718 718 706 691
Other intangibles 381 381 392 409 427 427 455 455 488 532
Property, plant and equipment 7,357 7,357 7,387 7,450 7,523 7,523 7,579 7,579 7,691 7,777
Other non-current assets2 2,523 2,523 2,714 2,636 2,807 2,807 2,068 2,068 2,109 2,300
Current assets 3,706 3,706 4,252 5,086 4,689 4,689 5,252 5,252 4,666 5,072
- of which cash and cash equivalents 1,335 1,335 1,622 2,365 2,690 2,690 2,815 2,815 1,919 1,995
Total assets 23,412 23,412 24,259 24,888 24,851 24,851 24,673 24,673 24,337 25,122
3
Group equity 3,321 3,321 3,481 4,183 3,841 3,841 2,943 2,943 3,238 3,724
Non-current liabilities 13,981 13,981 15,543 15,538 15,756 15,756 16,738 16,738 15,130 15,831
- of which provisions 1,044 1,044 1,073 1,088 1,131 1,131 1,252 1,252 1,315 1,374
Current liabilities 2, 4 6,110 6,110 5,235 5,167 5,254 5,254 4,992 4,992 5,969 5,567
Total equity and liabilities 23,412 23,412 24,259 24,888 24,851 24,851 24,673 24,673 24,337 25,122
1
Including development costs software
2
Including deferred tax assets and assets held for sale
3
Including minority interest
4
Current liabilities include approximately € 0.2bn of non-netted cash balances per Q3 ’10
KPN Investor Relations P&L Q3 2010
``
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Revenues and other income YTD% Q3%
Germany 2,421 850 803 768 1.3% 3.8% 3,181 791 2,390 819 797 774
Belgium 595 192 201 202 0.0% -4.0% 802 207 595 200 204 191
Rest of World (including eliminations) 108 45 34 29 68.8% 80.0% 95 31 64 25 23 16
Mobile International 3,124 1,087 1,038 999 2.5% 4.1% 4,078 1,029 3,049 1,044 1,024 981
Consumer 2,950 991 990 969 -4.6% -2.7% 4,095 1,004 3,091 1,018 1,042 1,031
Business 1,815 577 604 634 -2.8% -4.2% 2,491 624 1,867 602 631 634
Wholesale & Operations (national) 2,119 711 704 704 -2.1% 0.7% 2,879 714 2,165 706 724 735
Other (including eliminations) (1,620) (532) (539) (549) -4.2% -4.3% (2,251) (560) (1,691) (556) (559) (576)
Dutch Telco business 5,264 1,747 1,759 1,758 -3.1% -1.3% 7,214 1,782 5,432 1,770 1,838 1,824
iBasis 678 248 237 193 21.9% 37.8% 719 163 556 180 177 199
Getronics 1,428 476 478 474 -8.5% -2.3% 2,097 537 1,560 487 531 542
Other gains and losses, eliminations (406) (138) (135) (133) -10.2% -6.1% (585) (133) (452) (147) (153) (152)
Of which: Real estate 6 - 4 2 -64.7% -100% 39 22 17 7 3 7
The Netherlands 6,964 2,333 2,339 2,292 -1.9% 1.9% 9,445 2,349 7,096 2,290 2,393 2,413
Other activities 66 16 24 26 -40.0% -52.9% 143 33 110 34 36 40
Intercompany revenues (145) (58) (47) (40) 23.9% 56.8% (157) (40) (117) (37) (42) (38)
Revenues and other income 10,009 3,378 3,354 3,277 -1.3% 1.4% 13,509 3,371 10,138 3,331 3,411 3,396
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
of which : Revenues YTD% Q3%
Germany 2,417 848 801 768 1.2% 3.7% 3,180 791 2,389 818 797 774
Belgium 594 191 201 202 -0.2% -4.5% 802 207 595 200 204 191
Rest of World (including eliminations) 109 46 34 29 70.3% 76.9% 95 31 64 26 22 16
Mobile International 3,120 1,085 1,036 999 2.4% 3.9% 4,077 1,029 3,048 1,044 1,023 981
Consumer 2,949 990 990 969 -4.6% -2.8% 4,094 1,003 3,091 1,018 1,042 1,031
Business 1,815 577 604 634 -2.8% -4.2% 2,491 624 1,867 602 631 634
Wholesale & Operations (national) 2,080 674 704 702 -3.2% -2.2% 2,862 714 2,148 689 724 735
Other (including eliminations) (1,620) (531) (540) (549) -4.2% -4.3% (2,250) (559) (1,691) (555) (560) (576)
Dutch Telco business 5,224 1,710 1,758 1,756 -3.5% -2.5% 7,197 1,782 5,415 1,754 1,837 1,824
iBasis 678 248 237 193 21.9% 37.8% 719 163 556 180 177 199
Getronics 1,424 473 477 474 -8.7% -2.9% 2,097 537 1,560 487 531 542
Other gains and losses, eliminations (412) (139) (137) (136) -12.2% -10.3% (624) (155) (469) (155) (154) (160)
Of which: Real estate - - - - n.m. n.m. - - - - - -
The Netherlands 6,914 2,292 2,335 2,287 -2.1% 1.1% 9,389 2,327 7,062 2,266 2,391 2,405
Voice wireline 453 146 152 155 -15.2% -13.1% 702 168 534 168 179 187
Wireless services 1,377 462 464 451 -6.1% -4.1% 1,934 468 1,466 482 501 483
Internet wireline 768 255 256 257 -1.9% -2.7% 1,042 259 783 262 260 261
Mobile Wholesale NL 168 61 56 51 11.3% 19.6% 201 50 151 51 51 49
Other (including intercompany) 183 66 62 55 16.6% 20.0% 215 58 157 55 51 51
Consumer 2,949 990 990 969 -4.6% -2.8% 4,094 1,003 3,091 1,018 1,042 1,031
Voice & Internet wireline 742 233 239 270 -4.3% -7.2% 1,026 251 775 251 259 265
Data network services 309 100 103 106 -6.1% -7.4% 439 110 329 108 112 109
Wireless services 663 209 229 225 2.2% 0.5% 872 223 649 208 217 224
Other (including intercompany) 101 35 33 33 -11.4% 0.0% 154 40 114 35 43 36
Business 1,815 577 604 634 -2.8% -4.2% 2,491 624 1,867 602 631 634
Netherlands 1,101 367 368 366 -9.9% -4.4% 1,654 432 1,222 384 419 419
International 350 119 115 116 4.2% 9.2% 456 120 336 109 115 112
Other 23 7 8 8 -36.1% -22.2% 35 (1) 36 9 5 22
Eliminations (50) (20) (14) (16) 47.1% 33.3% (48) (14) (34) (15) (8) (11)
Getronics 1,424 473 477 474 -8.7% -2.9% 2,097 537 1,560 487 531 542
Other activities 65 16 24 25 -40.9% -52.9% 142 32 110 34 36 40
Intercompany revenues (145) (58) (47) (40) 23.9% 56.8% (157) (40) (117) (37) (42) (38)
Total Revenues 9,954 3,335 3,348 3,271 -1.5% 0.8% 13,451 3,348 10,103 3,307 3,408 3,388
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
of which: External Revenues YTD% Q3%
Germany 2,353 824 780 749 1.0% 3.3% 3,098 768 2,330 798 777 755
Belgium 551 177 185 189 -0.2% -4.8% 744 192 552 186 189 177
Rest of World 183 72 59 52 32.6% 28.6% 195 57 138 56 44 38
Mobile International 3,087 1,073 1,024 990 2.2% 3.2% 4,037 1,017 3,020 1,040 1,010 970
Consumer 2,825 950 947 928 -3.7% -1.8% 3,890 956 2,934 967 990 977
Business 1,651 521 551 579 -0.4% -2.6% 2,219 561 1,658 535 561 562
Wholesale & Operations (national) 478 150 169 159 -2.8% 6.4% 656 164 492 141 177 174
Other (including eliminations) - - - - -100% -100.0% 2 1 1 1 (1) 1
Dutch Telco business 4,954 1,621 1,667 1,666 -2.6% -1.4% 6,767 1,682 5,085 1,644 1,727 1,714
iBasis 540 192 192 156 24.4% 41.2% 558 124 434 136 138 160
Getronics 1,307 433 440 434 -10.2% -4.8% 1,948 493 1,455 455 495 505
Other gains and losses, eliminations - - - - n.m. n.m. (1) (1) - - - -
Of which: Real estate - - - - n.m. n.m. - - - - - -
The Netherlands 6,801 2,246 2,299 2,256 -2.5% 0.5% 9,272 2,298 6,974 2,235 2,360 2,379
Other activities 66 16 25 25 -39.4% -50.0% 142 33 109 32 38 39
Total External Revenues 9,954 3,335 3,348 3,271 -1.5% 0.8% 13,451 3,348 10,103 3,307 3,408 3,388
KPN Investor Relations Revenues Q3 2010
``
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Operating expenses YTD% Q3%
Germany 1,855 638 616 601 -2.3% -0.9% 2,536 637 1,899 644 634 621
Belgium 469 154 151 164 -6.2% -8.9% 678 178 500 169 167 164
Rest of World (including intercompany) 123 48 39 36 21.8% 45.5% 147 46 101 33 35 33
Mobile International 2,447 840 806 801 -2.1% -0.7% 3,361 861 2,500 846 836 818
Consumer 2,297 775 759 763 -9.3% -6.4% 3,353 821 2,532 828 839 865
Business 1,275 411 430 434 -3.9% -4.4% 1,778 451 1,327 430 440 457
Wholesale & Operations (national) 1,464 475 499 490 -3.9% -3.7% 2,029 505 1,524 493 514 517
Other (including eliminations) (1,616) (531) (539) (546) -2.8% -3.8% (2,220) (557) (1,663) (552) (546) (565)
Dutch Telco business 3,420 1,130 1,149 1,141 -8.1% -5.8% 4,940 1,220 3,720 1,199 1,247 1,274
iBasis 673 247 234 192 17.7% 33.5% 734 162 572 185 178 209
Getronics 1,436 478 477 481 -13.0% -2.6% 2,187 536 1,651 491 559 601
Other gains and losses, eliminations (404) (134) (136) (134) -12.2% -11.3% (611) (151) (460) (151) (155) (154)
Of which: Real estate 7 3 2 2 -22.2% 0.0% 12 3 9 3 2 4
The Netherlands 5,125 1,721 1,724 1,680 -6.5% -0.2% 7,250 1,767 5,483 1,724 1,829 1,930
Other activities 103 28 32 43 -29.5% -39.1% 205 59 146 46 46 54
Intercompany expenses (145) (58) (47) (40) 23.9% 56.8% (157) (40) (117) (37) (42) (38)
Total Operating expenses 7,530 2,531 2,515 2,484 -6.0% -1.9% 10,659 2,647 8,012 2,579 2,669 2,764
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Of which: Depreciation1 YTD% Q3%
Germany 273 96 90 87 -11.4% -6.8% 413 105 308 103 103 102
Belgium 57 18 19 20 -27.8% -30.8% 106 27 79 26 24 29
Rest of World (1) (1) (1) 1 n.m. n.m. 1 - 1 1 1 (1)
Mobile International 329 113 108 108 -15.2% -13.1% 520 132 388 130 128 130
Consumer 79 29 26 24 -6.0% 11.5% 113 29 84 26 29 29
Business 22 7 7 8 -15.4% -12.5% 34 8 26 8 9 9
Wholesale & Operations (national) 522 170 176 176 -9.2% -9.1% 760 185 575 187 192 196
Other (including eliminations) 15 6 4 5 15.4% 20.0% 15 2 13 5 5 3
Dutch Telco business 638 212 213 213 -8.6% -6.2% 922 224 698 226 235 237
iBasis 10 4 2 4 0.0% 0.0% 13 3 10 4 3 3
Getronics 71 22 25 24 9.2% 0.0% 87 22 65 22 23 20
Other gains and losses, eliminations 1 1 1 (1) 0.0% -50.0% 2 1 1 2 (1) -
Of which: Real estate - - - - n.m. n.m. - - - - - -
The Netherlands 720 239 241 240 -7.0% -5.9% 1,024 250 774 254 260 260
Other activities 3 1 2 - -40.0% n.m. 6 1 5 - 3 2
Total Depreciation (incl. impairments) 1,052 353 351 348 -9.9% -8.1% 1,550 383 1,167 384 391 392
1
Including impairments, if any
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Of which: Amortization1 YTD% Q3%
Germany 213 78 68 67 4.9% 13.0% 275 72 203 69 67 67
Belgium 33 12 12 9 57.1% 50.0% 29 8 21 8 7 6
Rest of World 6 2 2 2 20.0% 0.0% 12 7 5 2 1 2
Mobile International 252 92 82 78 10.0% 16.5% 316 87 229 79 75 75
Consumer 96 33 32 31 -34.2% -32.7% 175 29 146 49 48 49
Business 47 16 16 15 42.4% 33.3% 47 14 33 12 11 10
Wholesale & Operations (national) 122 42 43 37 29.8% 35.5% 132 38 94 31 32 31
Other (including eliminations) 15 6 5 4 -11.8% 0.0% 26 9 17 6 5 6
Dutch Telco business 280 97 96 87 -3.4% -1.0% 380 90 290 98 96 96
iBasis 10 3 4 3 -52.4% 0.0% 24 3 21 3 4 14
Getronics 40 14 14 12 -21.6% 7.7% 65 14 51 13 14 24
Other gains and losses, eliminations - - - - -100% -100% (1) - (1) (1) (1) 1
Of which: Real estate - - - - n.m. n.m. - - - - - -
The Netherlands 330 114 114 102 -8.6% 0.9% 468 107 361 113 113 135
Other activities 4 2 - 2 100% 100.0% 8 6 2 1 1 -
Total Amortization (incl. impairments) 586 208 196 182 -1.0% 7.8% 792 200 592 193 189 210
1
Including impairments, if any
KPN Investor Relations Expenses Q3 2010
``
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Operating profit YTD% Q3%
Germany 566 212 187 167 15.3% 21.1% 645 154 491 175 163 153
Belgium 126 38 50 38 32.6% 22.6% 124 29 95 31 37 27
Rest of World (15) (3) (5) (7) -59.5% -62.5% (52) (15) (37) (8) (12) (17)
Mobile International 677 247 232 198 23.3% 24.7% 717 168 549 198 188 163
Consumer 653 216 231 206 16.8% 13.7% 742 183 559 190 203 166
Business 540 166 174 200 0.0% -3.5% 713 173 540 172 191 177
Wholesale & Operations (national) 655 236 205 214 2.2% 10.8% 850 209 641 213 210 218
Other (4) (1) - (3) -85.7% -75.0% (31) (3) (28) (4) (13) (11)
Dutch Telco business 1,844 617 610 617 7.7% 8.1% 2,274 562 1,712 571 591 550
iBasis 5 1 3 1 n.m. n.m. (15) 1 (16) (5) (1) (10)
Getronics (8) (2) 1 (7) -91.2% -50.0% (90) 1 (91) (4) (28) (59)
Other gains and losses (2) (4) 1 1 n.m. n.m. 26 18 8 4 2 2
Of which: Real estate (1) (3) 2 - n.m. n.m. 27 19 8 4 1 3
The Netherlands 1,839 612 615 612 14.0% 8.1% 2,195 582 1,613 566 564 483
Other activities (37) (12) (8) (17) 2.8% 0.0% (62) (26) (36) (12) (10) (14)
Total Operating profit 2,479 847 839 793 16.6% 12.6% 2,850 724 2,126 752 742 632
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Operating profit margin
Germany 23.4% 24.9% 23.3% 21.7% 20.3% 19.5% 20.5% 21.4% 20.5% 19.8%
Belgium 21.2% 19.8% 24.9% 18.8% 15.5% 14.0% 16.0% 15.5% 18.1% 14.1%
Rest of World -13.9% -6.7% -14.7% -24.1% -54.7% -48.4% -57.8% -32.0% -52.2% -106.3%
Mobile International 21.7% 22.7% 22.4% 19.8% 17.6% 16.3% 18.0% 19.0% 18.4% 16.6%
Consumer 22.1% 21.8% 23.3% 21.3% 18.1% 18.2% 18.1% 18.7% 19.5% 16.1%
Business 29.8% 28.8% 28.8% 31.5% 28.6% 27.7% 28.9% 28.6% 30.3% 27.9%
Wholesale & Operations (national) 30.9% 33.2% 29.1% 30.4% 29.5% 29.3% 29.6% 30.2% 29.0% 29.7%
Other 0.2% 0.2% 0.0% 0.5% 1.4% 0.5% 1.7% 0.7% 2.3% 1.9%
Dutch Telco business 35.0% 35.3% 34.7% 35.1% 31.5% 31.5% 31.5% 32.3% 32.2% 30.2%
iBasis 0.7% 0.4% 1.3% 0.5% -2.1% 0.6% -2.9% -2.8% -0.6% -5.0%
Getronics -0.6% -0.4% 0.2% -1.5% -4.3% 0.2% -5.8% -0.8% -5.3% -10.9%
Other gains and losses 0.5% 2.9% -0.7% -0.8% -4.4% -13.5% -1.8% -2.7% -1.3% -1.3%
Of which: Real estate -16.7% n.m. 50.0% 0.0% 69.2% 86.4% 47.1% 57.1% 33.3% 42.9%
The Netherlands 26.4% 26.2% 26.3% 26.7% 23.2% 24.8% 22.7% 24.7% 23.6% 20.0%
Other activities -56.1% -75.0% -33.3% -65.4% -43.4% -78.8% -32.7% -35.3% -27.8% -35.0%
Total Operating profit margin 24.8% 25.1% 25.0% 24.2% 21.1% 21.5% 21.0% 22.6% 21.8% 18.6%
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
EBITDA YTD% Q3%
Germany 1,052 386 345 321 5.0% 11.2% 1,333 331 1,002 347 333 322
Belgium 216 68 81 67 10.8% 4.6% 259 64 195 65 68 62
Rest of World (10) (2) (4) (4) -67.7% -60.0% (39) (8) (31) (5) (10) (16)
Mobile International 1,258 452 422 384 7.9% 11.1% 1,553 387 1,166 407 391 368
Consumer 828 278 289 261 4.9% 4.9% 1,030 241 789 265 280 244
Business 609 189 197 223 1.7% -1.6% 794 195 599 192 211 196
Wholesale & Operations (national) 1,299 448 424 427 -0.8% 3.9% 1,742 432 1,310 431 434 445
Other 26 11 9 6 >1,000% 57.1% 10 8 2 7 (3) (2)
Dutch Telco business 2,762 926 919 917 2.3% 3.5% 3,576 876 2,700 895 922 883
iBasis 25 8 9 8 66.7% >200% 22 7 15 2 6 7
Getronics 103 34 40 29 >200% 9.7% 62 37 25 31 9 (15)
Other gains and losses (1) (3) 2 - n.m. n.m. 27 19 8 5 - 3
Of which: Real estate (1) (3) 2 - n.m. n.m. 27 19 8 4 1 3
The Netherlands 2,889 965 970 954 5.1% 3.4% 3,687 939 2,748 933 937 878
Other activities (30) (9) (6) (15) 3.4% -18.2% (48) (19) (29) (11) (6) (12)
Total EBITDA 4,117 1,408 1,386 1,323 6.0% 5.9% 5,192 1,307 3,885 1,329 1,322 1,234
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
EBITDA margin
Germany 43.5% 45.4% 43.0% 41.8% 41.9% 41.8% 41.9% 42.4% 41.8% 41.6%
Belgium 36.3% 35.4% 40.3% 33.2% 32.3% 30.9% 32.8% 32.5% 33.3% 32.5%
Rest of World -9.3% -4.4% -11.8% -13.8% -41.1% -25.8% -48.4% -20.0% -43.5% -100.0%
Mobile International 40.3% 41.6% 40.7% 38.4% 38.1% 37.6% 38.2% 39.0% 38.2% 37.5%
Consumer 28.1% 28.1% 29.2% 26.9% 25.2% 24.0% 25.5% 26.0% 26.9% 23.7%
Business 33.6% 32.8% 32.6% 35.2% 31.9% 31.3% 32.1% 31.9% 33.4% 30.9%
Wholesale & Operations (national) 61.3% 63.0% 60.2% 60.7% 60.5% 60.5% 60.5% 61.0% 59.9% 60.5%
Other -1.6% -2.1% -1.7% -1.1% -0.4% -1.4% -0.1% -1.3% 0.5% 0.3%
Dutch Telco business 52.5% 53.0% 52.2% 52.2% 49.6% 49.2% 49.7% 50.6% 50.2% 48.4%
iBasis 3.7% 3.2% 3.8% 4.1% 3.1% 4.3% 2.7% 1.1% 3.4% 3.5%
Getronics 7.2% 7.1% 8.4% 6.1% 3.0% 6.9% 1.6% 6.4% 1.7% -2.8%
Other gains and losses 0.2% 2.2% -1.5% 0.0% -4.6% -14.3% -1.8% -3.4% 0.0% -2.0%
Of which: Real estate -16.7% n.m. 50.0% 0.0% 69.2% 86.4% 47.1% 57.1% 33.3% 42.9%
The Netherlands 41.5% 41.4% 41.5% 41.6% 39.0% 40.0% 38.7% 40.7% 39.2% 36.4%
Other activities -45.5% -56.3% -25.0% -57.7% -33.6% -57.6% -26.4% -32.4% -16.7% -30.0%
Total EBITDA margin 41.1% 41.7% 41.3% 40.4% 38.4% 38.8% 38.3% 39.9% 38.8% 36.3%
KPN Investor Relations Profit & Margin Q3 2010
``
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
FTE Own Personnel YTD% Q3%
KPN Group 30,654 30,654 31,121 32,203 -11.3% -11.3% 33,148 33,148 34,550 34,550 35,502 35,638
- KPN domestic 11,243 11,243 11,533 11,814 -13.3% -13.3% 12,265 12,265 12,974 12,974 13,223 13,254
- KPN abroad 7,296 7,296 7,367 7,722 -12.2% -12.2% 7,923 7,923 8,314 8,314 8,321 8,231
- Getronics domestic 8,181 8,181 8,231 8,298 -5.9% -5.9% 8,490 8,490 8,692 8,692 9,057 9,181
- Getronics abroad 3,934 3,934 3,990 4,369 -13.9% -13.9% 4,470 4,470 4,570 4,570 4,901 4,972
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
MTA impact: Revenues
Germany (21) - - (21) (62) (21) (41) (21) (20) -
Belgium (11) (11) - - (12) - (12) - (5) (7)
Mobile International (32) (11) - (21) (74) (21) (53) (21) (25) (7)
Consumer (44) (13) (13) (18) (73) (20) (53) (21) (21) (11)
Of which: Mobile Wholesale NL (2) - (1) (1) (12) (3) (9) (3) (4) (2)
Business (26) (7) (8) (11) (36) (11) (25) (11) (9) (5)
Wholesale & Operations 1 (16) (5) (2) (9) (34) (11) (23) (12) (6) (5)
Intercompany 6 2 - 4 19 5 14 6 5 3
Dutch Telco business (80) (23) (23) (34) (124) (37) (87) (38) (31) (18)
KPN Group (112) (34) (23) (55) (198) (58) (140) (59) (56) (25)
1
As of Q2 '10 W&O figures are reported excluding iBasis. The Q1 '10 revenue impact of iBasis is corrected in Q2 '10. YTD figures show the total W&O impact excluding iBasis
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
MTA impact: EBITDA
Germany (10) - (10) (31) (10) (21) (11) (10) -
Belgium (8) (8) - - (9) - (9) - (4) (5)
Mobile International (18) (8) - (10) (40) (10) (30) (11) (14) (5)
Consumer (12) (5) 1 (8) (36) (8) (28) (9) (15) (4)
Of which: Mobile Wholesale NL (1) - - (1) (7) (1) (6) (2) (3) (1)
Business (2) (1) 1 (2) (8) (2) (6) (1) (4) (1)
Wholesale & Operations (1) (1) - (1) (1) - - - -
Intercompany - - - - - - - - -
Dutch Telco business (15) (6) 1 (10) (45) (11) (34) (10) (19) (5)
KPN Group (33) (14) 1 (20) (85) (21) (64) (21) (33) (10)
KPN Investor Relations FTE & MTA impact Q3 2010
``
KPN The Netherlands: Consumer YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Wireline services YTD% Q3%
1
Market penetration
- Broadband 2 84% 84% 83% 83% 83% 83% 82% 82% 81% 81%
- VoIP 2 58% 58% 56% 55% 53% 53% 52% 52% 51% 49%
- Mobile-only 17% 17% 17% 17% 17% 17% 17% 17% 17% 17%
Market share
- Voice - Traditional & VoIP (traffic) 3 ~50% ~50% >50% >50% ~55% ~55% ~55% ~55% ~55% ~55%
4
- Traditional voice (traffic) >80% >80% >80% >80% >80% >80% ~80% ~80% >75% >75%
- VoIP (subscribers) 2 36% 36% 37% 37% 38% 38% 39% 39% 39% 41%
2
- Broadband - KPN ISP Retail (subscribers) 42% 42% 42% 42% 42% 42% 43% 43% 43% 43%
- TV (subscribers) 14% 14% 14% 13% 12% 12% 12% 12% 11% 10%
Access Lines (*1,000) 3,052 3,052 3,102 3,164 -7.3% -7.3% 3,234 3,234 3,293 3,293 3,351 3,413
- Traditional voice 5 1,773 1,773 1,846 1,918 -15.8% -15.8% 2,019 2,019 2,106 2,106 2,189 2,266
- VoIP (package broadband, voice) 2 1,279 1,279 1,256 1,246 7.8% 7.8% 1,215 1,215 1,187 1,187 1,162 1,147
6
Net line loss (*1,000) (115) (35) (45) (35) (150) (30) (120) (45) (50) (25)
2
Number of triple play packages (*1,000) 509 509 452 403 83.1% 83.1% 295 295 278 278 273 247
Traditional voice ARPU € 26 € 26 € 26 € 26 0.0% 4.0% € 26 € 26 € 26 € 25 € 26 € 26
- Access € 17 € 17 € 17 € 17 0.0% 6.3% € 17 € 17 € 17 € 16 € 17 € 17
- Traffic €9 €9 €9 €9 0.0% 0.0% €9 €9 €9 €9 €9 €9
Traditional voice MoU (originating) 180 172 173 194 -1.1% -1.1% 185 194 182 174 178 195
Broadband ISP customers 2 (*1,000) 2,568 2,568 2,568 2,584 -0.4% -0.4% 2,575 2,575 2,578 2,578 2,568 2,565
Broadband ARPU (blended) € 32 € 32 € 32 € 31 3.2% 3.2% € 31 € 31 € 31 € 31 € 30 € 31
TV subscribers 2 (*1,000) 1,144 1,144 1,088 1,033 22.7% 22.7% 984 984 932 932 890 835
TV ARPU (blended) €9 €9 €9 €9 12.5% 12.5% €8 €8 €8 €8 €7 €7
Fiber (*1,000) 54 54 42 31 >200% >200% 16 16 10 10 5 2
- FttC (activated) 22 22 16 10 >500% >500% 5 5 3 3 1 0
- FttH (activated) 32 32 26 21 >200% >200% 11 11 7 7 4 2
1
Based on management estimate
2
Including fiber
3
Market shares defined as share in total consumer voice (including VoIP), based on management estimates
4
Market shares defined as share in traditional consumer voice (excluding VoIP), based on management estimates
5
For Q1; net loss of 101k included 13k migration to Business segment
6
Quarterly delta in PSTN/ISDN access lines + delta Consumer VoIP, ADSL Only and delta Consumer Fiber
KPN The Netherlands: Consumer YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Wireless services YTD% Q3%
Customers (* 1,000) 5,761 5,761 5,992 6,079 -14.5% -14.5% 6,523 6,523 6,739 6,739 6,795 6,821
- Postpaid 3,163 3,163 3,096 3,102 -0.8% -0.8% 3,121 3,121 3,189 3,189 3,214 3,201
- Prepaid 1 2,598 2,598 2,896 2,977 -26.8% -26.8% 3,402 3,402 3,550 3,550 3,581 3,620
Net adds (* 1,000) (762) (231) (87) (444) 275 (216) 491 (56) (26) 573
- Postpaid 42 67 (6) (19) 316 (68) 384 (25) 13 396
- Prepaid 1 (804) (298) (81) (425) (41) (148) 107 (31) (39) 177
Wireless service revenues (in m) € 1,325 € 443 € 448 € 434 -5.5% -3.7% € 1,855 € 453 € 1,402 € 460 € 477 € 465
ARPU € 24 € 25 € 25 € 23 4.3% 8.7% € 23 € 23 € 23 € 23 € 23 € 23
Non-voice as % of ARPU 34% 36% 34% 33% 28% 31% 27% 29% 27% 26%
2
MoU (originating, terminating) 113 113 116 109 5.6% 7.6% 107 109 107 105 110 105
SMS (originating, per subscriber) 53 56 54 49 32.5% 33.3% 42 46 40 42 41 38
SAC/SRC € 167 € 162 € 157 € 183 24.6% 8.0% € 144 € 183 € 134 € 150 € 116 € 139
1
Clean up of 130k subs in Q3 '10 and 280k subs in Q1 '10
2
MoU restated as data customers are now excluded
KPN The Netherlands: Consumer YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Mobile wholesale NL YTD% Q3%
Customers (* 1,000) 2,401 2,401 2,310 2,228 23.5% 23.5% 2,120 2,120 1,944 1,944 1,760 1,637
1
- Postpaid 488 488 430 422 31.2% 31.2% 403 403 372 372 335 313
- Prepaid 1,913 1,913 1,880 1,806 21.7% 21.7% 1,717 1,717 1,572 1,572 1,425 1,324
Wireless service revenues (in m) € 168 € 61 € 56 € 51 11.3% 17.3% € 201 € 50 € 151 € 52 € 51 € 48
1
For Q3; including ~40k migration from Business segment
KPN Investor Relations Consumer KPIs Q3 2010
KPN The Netherlands: Business YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Voice & Internet wireline YTD% Q3%
Market share
Voice1 >45% >45% >45% >45% >45% >45% ~50% ~50% ~50% ~50%
Access Lines (*1,000) 1,391 1,391 1,414 1,446 -7.3% -7.3% 1,469 1,469 1,501 1,501 1,533 1,565
- PSTN2 661 661 671 682 -6.4% -6.4% 691 691 706 706 719 735
- ISDN 703 703 716 735 -8.3% -8.3% 749 749 767 767 786 803
- ZIPB-XL and other 7 7 7 8 -12.5% -12.5% 8 8 8 8 8 8
- VoIP (package broadband, voice) 20 20 20 21 0.0% 0.0% 21 21 20 20 20 19
Business DSL (*1,000) 154 154 150 145 15.2% 15.2% 142 142 134 134 130 127
Traditional voice ARPU € 53 € 51 € 51 € 57 3.9% 4.1% € 51 € 51 € 51 € 49 € 51 € 52
- Access 3 € 29 € 28 € 27 € 32 7.4% 3.7% € 27 € 27 € 27 € 27 € 27 € 27
- Traffic € 24 € 23 € 24 € 25 0.0% 4.5% € 24 € 24 € 24 € 22 € 24 € 25
Traditional voice MoU (originating) 277 259 275 302 -8.9% -8.5% 304 301 304 283 296 319
- National 259 242 257 283 -9.1% -8.7% 285 282 285 265 277 299
- International 18 17 18 19 -5.3% -5.6% 19 19 19 18 19 20
Applications online (*1,000)
- Net accounts 267 267 237 199 >100% >100% 154 154 116 116 109 107
1
Market shares defined as share in traditional voice (including VoIP and internet dial-up), based on management estimates.
2
For Q1; including 13k migration from Consumer segment
3
Increase of ARPU in Q1 due to release of deferred connection fees in Q1 '10
KPN The Netherlands: Business YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Wireless services YTD% Q3%
Customers (* 1,000) 1 1,688 1,688 1,715 1,712 3.2% 3.2% 1,662 1,662 1,636 1,636 1,616 1,592
% data users 52% 52% 50% 47% 48% 48% 46% 46% 44% 42%
Service revenues (in m) € 722 € 228 € 246 € 248 -0.7% -2.6% € 974 € 247 € 727 € 234 € 246 € 247
ARPU € 47 € 46 € 48 € 49 -7.8% -4.2% € 51 € 50 € 51 € 48 € 51 € 53
Non-voice as % of ARPU 30% 32% 29% 29% 11.1% 3.2% 28% 27% 27% 31% 27% 26%
MoU (originating, terminating) 198 183 200 211 -4.8% -4.2% 210 216 208 191 211 226
SAC/SRC € 238 € 242 € 215 € 255 -18.8% -15.7% € 287 € 272 € 293 € 287 € 323 € 289
SMS messages (in m) 395 133 135 127 23.1% 19.8% 443 122 321 111 108 102
1
For Q3; migration of 40k customers to Mobile wholesale NL
KPN The Netherlands: Business YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Data / Network services YTD% Q3%
Traditional Network: leased lines (* 1,000) 19.7 19.7 20.7 21.9 -18.9% -18.9% 23.3 23.3 24.3 24.3 26.1 27.6
- Analogue 14.9 14.9 15.7 16.7 -19.0% -19.0% 17.4 17.4 18.4 18.4 20.0 21.4
- Digital 4.8 4.8 5.0 5.2 -18.6% -18.6% 5.9 5.9 5.9 5.9 6.1 6.2
E-VPN1 (* 1,000)
- Ethernet-VPN (# connections) 9.5 9.5 9.3 9.5 10.5% 10.5% 8.9 8.9 8.6 8.6 8.2 7.9
IP-VPN2 (* 1,000) 60.5 60.5 61.0 59.9 2.4% 2.4% 60.4 60.4 59.1 59.1 53.8 52.8
- Managed VPN (# connections) 27.5 27.5 29.9 30.4 14.6% 14.6% 30.7 30.7 24.0 24.0 18.0 17.5
- Unmanaged VPN (# connections) 33.0 33.0 31.1 29.5 -6.0% -6.0% 29.7 29.7 35.1 35.1 35.8 35.3
1
E-VPN changed into Ethernet-VPN; installed base rationalized, per Q1 '10 representing commercial installed base instead of technical installed base
2
IP-VPN split up into managed and unmanaged; both customer bases representing number of connections
KPN Investor Relations Business KPIs Q3 2010
``
KPN The Netherlands: Wholesale & Operations YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
YTD% Q3%
Access lines
- Retail voice (without ADSL) 3,137 3,137 3,233 3,335 -12.3% -12.3% 3,459 3,459 3,579 3,579 3,694 3,804
Access services : Local Loop (*1,000)
- MDF access lines1 3,678 3,678 3,699 3,725 -1.9% -1.9% 3,743 3,743 3,751 3,751 3,760 3,751
- of which line sharing2 1,187 1,187 1,246 1,304 -17.2% -17.2% 1,374 1,374 1,434 1,434 1,494 1,548
Unbundling (estimates, m) 1.1 1.1 1.1 1.1 0.0% 0.0% 1.1 1.1 1.1 1.1 1.1 1.0
- Shared unbundled lines3 0.2 0.2 0.2 0.2 0.0% 0.0% 0.2 0.2 0.2 0.2 0.2 0.2
- Fully unbundled lines4 0.9 0.9 0.9 0.9 0.0% 0.0% 0.9 0.9 0.9 0.9 0.9 0.8
National traffic (in bn) 11.8 3.7 3.9 4.2 -7.8% -7.5% 17.2 4.4 12.8 4.0 4.2 4.6
- Originating 2.7 0.8 0.9 1.0 -18.2% -20.0% 4.4 1.1 3.3 1.0 1.1 1.2
- Terminating 5.6 1.8 1.8 2.0 -3.4% 0.0% 7.8 2.0 5.8 1.8 1.9 2.1
- Transit 3.5 1.1 1.2 1.2 -5.4% -8.3% 5.0 1.3 3.7 1.2 1.2 1.3
Population coverage
- UMTS / HSDPA 100% 100% 100% 99% 0.8% 0.8% 99% 99% 99% 99% 99% 99%
Population coverage
- FttC - number of homes passed (* 1.000) 464 464 464 464 0.0% 0.0% 464 464 464 464 464 458
- WBA FttC 22 22 16 10 n.a. n.a. n.a. n.a. n.a. n.a. n.a. n.a.
- FttH - number of homes passed 392 392 288 210 >100% >100% 193 193 163 163 119 72
- WBA FttH 33 33 26 22 200% 200% 18 18 11 11 7 4
1
Including Bitstream
2
Includes KPN ADSL connections, line sharing other telcos and KPN Bitstream
3
Line sharing -/- KPN ISP customers + KPN VoIP + KPN ADSL Only
4
MDF access -/- line sharing -/- KPN VoIP -/- KPN ADSL Only
KPN Investor Relations W&O KPIs Q3 2010
``
KPN The Netherlands: Getronics YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
YTD% Q3%
Service Revenues (existing) € 1,253 € 416 € 418 € 419 -8.8% -4.8% € 1,851 € 477 € 1,374 € 437 € 492 € 445
Workspaces (in m)
- Serviced IT workspaces 1.7 1.7 1.7 1.7 0.0% 0.0% 1.8 1.8 1.7 1.7 1.7 1.7
- Serviced voice workspaces 0.5 0.5 0.6 0.6 -16.7% -16.7% 0.6 0.6 0.6 0.6 0.6 0.6
Housing & Hosting (* 1,000)
- Housing services (# m2) 25.0 25.0 25.0 25.0 0.0% 0.0% 25.0 25.0 25.0 25.0 24.9 24.9
- Hosting services (# servers) 14.4 14.4 13.9 13.6 23.1% 23.1% 12.0 12.0 11.7 11.7 9.8 9.8
KPN The Netherlands: iBasis YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
iBasis (international wholesale) YTD% Q3%
- Minutes International (in bn) 17.9 6.1 6.3 5.5 20.9% 22.0% 19.8 5.0 14.8 5.0 4.7 5.1
- Average revenue per minute (€ cents) 3.8 4.1 3.8 3.5 2.7% 17.1% 3.6 3.2 3.7 3.5 3.8 3.8
KPN Investor Relations Getronics & iBasis KPIs Q3 2010
``
Mobile International YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
YTD% Q3%
Wireless service revenues (in m) 2,939 1,025 987 927 4.2% 5.1% 3,776 956 2,820 975 943 902
Germany 2,311 810 772 729 1.8% 4.0% 3,021 751 2,270 779 757 734
Belgium (BASE) 517 170 178 169 5.9% 1.8% 659 171 488 167 167 154
Rest of World (including eliminations) 111 45 37 29 79.0% 55.2% 96 34 62 29 19 14
Customers (* 1,000) 23,566 23,566 23,219 22,856 5.8% 5.8% 22,565 22,565 22,272 22,272 21,722 21,535
- Postpaid 7,618 7,618 7,527 7,466 2.3% 2.3% 7,446 7,446 7,446 7,446 7,397 7,322
- Prepaid 15,948 15,948 15,692 15,390 7.6% 7.6% 15,119 15,119 14,826 14,826 14,325 14,213
Germany YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
YTD% Q3%
Market share1
2
- Service revenue 15.4% 15.7% 15.5% 15.1% 15.5% 15.4% 15.6% 15.7% 15.7% 15.3%
- Base 18.0% 18.0% 17.8% 17.6% 17.3% 17.3% 17.1% 17.1% 16.9% 16.4%
Customers (* 1,000) 19,899 19,899 19,590 19,290 6.3% 6.3% 18,987 18,987 18,712 18,712 18,235 18,038
- Postpaid 6,892 6,892 6,815 6,764 1.4% 1.4% 6,768 6,768 6,800 6,800 6,785 6,739
- Prepaid3 13,007 13,007 12,775 12,526 9.2% 9.2% 12,219 12,219 11,912 11,912 11,450 11,299
% active customers 92% 92% 91% 90% 91% 91% 91% 91% 90% 90%
Net adds (* 1,000) 912 309 300 303 1,210 275 935 477 197 261
- Postpaid 124 77 51 (4) 92 (32) 124 15 46 63
3
- Prepaid 788 232 249 307 1,118 307 811 462 151 198
Wireless service revenues (in m) € 2,311 € 810 € 772 € 729 1.8% 4.0% € 3,021 € 751 € 2,270 € 779 € 757 € 734
ARPU blended € 13 € 14 € 13 € 13 -7.1% 0.0% € 14 € 13 € 14 € 14 € 14 € 14
- ARPU Postpaid € 26 € 26 € 26 € 25 -3.7% -3.7% € 27 € 26 € 27 € 27 € 27 € 27
- ARPU Prepaid €6 €7 €6 €6 0.0% 16.7% €6 €6 €6 €6 €6 €6
Non-voice as % of ARPU 28% 28% 28% 28% 28% 30% 27% 28% 27% 26%
Total traffic (originating, terminating, in m) 25,598 8,615 8,670 8,313 10.9% 9.2% 31,343 8,266 23,077 7,888 7,825 7,364
MoU blended (originating, terminating) 149 148 152 148 3.5% 2.1% 145 149 144 145 147 139
- MoU Postpaid 276 268 279 280 -1.8% -3.6% 282 285 281 278 283 281
- MoU Prepaid 86 89 88 80 26.5% 23.6% 70 77 68 72 70 60
SAC/SRC blended € 44 € 44 € 44 € 44 -12.0% -2.2% € 49 € 46 € 50 € 45 € 53 € 52
- SAC/SRC Postpaid € 115 € 118 € 112 € 115 -10.2% -6.3% € 128 € 127 € 128 € 126 € 129 € 129
- SAC/SRC Prepaid € 15 € 13 € 15 € 16 7.1% 8.3% € 14 € 15 € 14 € 12 € 16 € 13
Gross churn blended 26% 28% 25% 25% 29% 30% 29% 28% 30% 29%
- Gross churn Postpaid 20% 20% 20% 20% 21% 23% 20% 20% 20% 21%
- Gross churn Prepaid 29% 32% 28% 28% 34% 34% 34% 33% 36% 35%
1
Management estimates,
2
Service revenue figures retro-actively changed due to better insights
2
Clean-up of 140k in Q3 '10
Belgium1 YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
YTD% Q3%
Market share2
- Service revenue >18% >18% >18% ~18% >17% ~18% >17% >17% >17% >16%
- Base ~26% ~26% ~26% ~26% >25% >25% >25% >25% >25% >25%
Customers (* 1,000) 3,667 3,667 3,629 3,566 3.0% 3.0% 3,578 3,578 3,560 3,560 3,487 3,497
- Postpaid 726 726 712 702 12.4% 12.4% 678 678 646 646 612 583
- Prepaid 2,941 2,941 2,917 2,864 0.9% 0.9% 2,900 2,900 2,914 2,914 2,875 2,914
% active customers 83% 83% 80% 85% 83% 83% 78% 78% 78% 76%
Net adds (* 1,000) 89 38 63 (12) 133 18 115 73 (10) 52
- Postpaid 48 14 10 24 109 32 77 34 29 14
- Prepaid 41 24 53 (36) 24 (14) 38 39 (39) 38
Wireless service revenues (in m) € 517 € 170 € 178 € 169 5.9% 1.8% € 659 € 171 € 488 € 167 € 167 € 154
ARPU blended € 16 € 15 € 17 € 16 0.0% -6.3% € 16 € 16 € 16 € 16 € 16 € 15
- ARPU Postpaid € 47 € 46 € 48 € 46 -4.1% -8.0% € 49 € 48 € 49 € 50 € 50 € 47
- ARPU Prepaid €8 €8 €9 €8 -11.1% 0.0% €9 €9 €9 €8 €9 €8
Non-voice as % of ARPU 17% 17% 16% 18% 17% 17% 17% 16% 17% 17%
Total traffic (originating, terminating, in m) 4,220 1,342 1,472 1,406 12.3% 12.4% 5,117 1,358 3,759 1,194 1,273 1,292
MoU blended (originating, terminating) 130 120 138 131 8.3% 7.1% 122 126 120 112 124 124
- MoU Postpaid 448 414 470 460 4.7% 2.0% 435 456 428 406 451 428
- MoU Prepaid 53 50 56 52 -3.6% 2.0% 55 52 55 49 55 63
SAC/SRC blended € 16 € 14 € 16 € 18 -27.3% -39.1% € 21 € 21 € 22 € 23 € 21 € 21
- SAC/SRC Postpaid € 54 € 48 € 59 € 55 -8.5% -15.8% € 59 € 58 € 59 € 57 € 54 € 68
- SAC/SRC Prepaid €8 €7 €8 €8 -27.3% -41.7% € 10 €9 € 11 € 12 € 11 €9
Gross churn blended 36% 32% 39% 38% 31% 39% 29% 26% 37% 21%
- Gross churn Postpaid 19% 16% 21% 19% 21% 24% 19% 17% 21% 20%
- Gross churn Prepaid 41% 35% 44% 43% 34% 42% 31% 28% 40% 24%
1
Relating to Mobile business only
2
Management estimates
KPN Investor Relations Mobile Int KPIs Q3 2010
``
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Cash flow YTD% Q3%
Profit before income tax 1,745 520 634 591 12.4% -8.1% 2,036 484 1,552 566 528 458
Finance costs- net 696 310 194 192 22.5% 71.3% 808 240 568 181 212 175
Share of the profit of associated and joint ventures 38 17 11 10 >500% >200% 6 - 6 5 2 (1)
Adjustments for:
Depreciation, Amortization and impairments 1,638 561 547 530 -6.9% -2.8% 2,342 583 1,759 577 580 602
Share-based compensation (12) 6 (24) 6 n.m. -57.1% 33 12 21 14 1 6
Other income (47) (39) (3) (5) 46.9% 56.0% (54) (22) (32) (25) (2) (5)
Change in provisions (excl. deferred taxes) (259) (93) (82) (84) 26.3% -8.8% (290) (85) (205) (102) (61) (42)
Inventories (12) (3) - (9) n.m. -127.3% 42 21 21 11 13 (3)
Trade receivables (44) 27 (39) (32) n.m. -50.9% 259 65 194 55 63 76
Prepayments and accrued income (81) 74 27 (182) -30.8% 34.5% 29 146 (117) 55 40 (212)
Other current assets (16) (4) 9 (21) n.m. n.m. 89 20 69 4 40 25
Trade payables 38 (83) 46 75 n.m. -38.5% (327) (45) (282) (135) 28 (175)
Accruals and deferred income (117) 13 (146) 16 -60.3% 85.7% (209) 86 (295) 7 (237) (65)
Current liabilities (excl. short term financing) (38) (1) 8 (45) n.m. n.m. 127 13 114 146 (22) (10)
Change in working capital (270) 23 (95) (198) -8.8% -83.9% 10 306 (296) 143 (75) (364)
Received dividends from associates and joint ventures 1 - 1 - -50.0% -100% 3 1 2 1 1 -
Taxes received (paid) (564) (6) (4) (554) 0.5% -14.3% (506) 55 (561) (7) 58 (612)
Interest paid (604) (238) (107) (259) 31.0% 33.0% (612) (151) (461) (179) (124) (158)
Net cash flow from operating activities 2,362 1,061 1,072 229 0.4% -9.6% 3,776 1,423 2,353 1,174 1,120 59
Acquisitions of subsidiaries, associates and joint ventures (83) (17) (18) (48) -13.5% n.m. (180) (84) (96) 4 (20) (80)
Disposal of subsidiaries, associates and joint ventures 65 6 (4) 63 97.0% n.m. 28 (5) 33 (6) (3) 42
Investments in intangible assets (excluding software) (323) (34) (245) (44) >1000% >200% (13) - (13) (10) (2) (1)
Disposal of intangibles - - - - -100% -100% 10 - 10 10 - -
Investments in property, plant & equipment and software (1,146) (431) (380) (335) -4.7% 19.7% (1,767) (565) (1,202) (360) (386) (456)
Disposal in property, plant & equipment and software 17 1 1 15 21.4% -80.0% 19 5 14 5 4 5
Disposals of real estate 73 51 15 7 >100% >200% 94 62 32 13 5 14
Other changes and disposals (88) (60) (5) (23) n.m. n.m. (20) (23) 3 3 (3) 3
Net cash flow from investing activities (1,485) (484) (636) (365) 21.8% 41.9% (1,829) (610) (1,219) (341) (405) (473)
Share repurchase (648) (116) (431) (101) -9.0% -42.3% (898) (186) (712) (201) (196) (315)
Share repurchases for option plans - - - - -100.0% -100% (62) - (62) (62) - -
Dividends paid (1,152) (419) (733) - 10.9% 11.7% (1,039) - (1,039) (375) (664) -
Exercised options 13 1 6 6 -27.8% -66.7% 22 4 18 3 9 6
Proceeds from borrowings 991 991 - - -68.8% -40.7% 3,172 - 3,172 1,672 - 1,500
Repayments from borrowings and settlement of derivatives (1,614) (1,488) (25) (101) 30.0% 23.0% (1,249) (7) (1,242) (1,210) (8) (24)
Other changes in interest-bearing current liabilities (2) (2) - - -83.3% -75.0% (13) (1) (12) (8) 1 (5)
Net cash flow used in financing activities (2,412) (1,033) (1,183) (196) n.m. >200% (67) (190) 123 (181) (858) 1,162
Changes in cash and cash equivalents (1,535) (456) (747) (332) n.m. n.m. 1,880 623 1,257 652 (143) 748
Net Cash at beginning of period 2,652 1,579 2,323 2,652 >200% 14.6% 771 2,027 771 1,378 1,520 771
Changes in cash (1,535) (456) (747) (332) n.m. n.m. 1,880 623 1,257 652 (143) 748
Exchange rate difference 2 (4) 3 3 n.m. 33.3% 1 2 (1) (3) 1 1
Net Cash at end of period 1,119 1,119 1,579 2,323 -44.8% -44.8% 2,652 2,652 2,027 2,027 1,378 1,520
Bank overdrafts 216 216 43 42 -72.6% -72.6% 38 38 788 788 541 435
Cash at end of period 1,335 1,335 1,622 2,365 -52.6% -52.6% 2,690 2,690 2,815 2,815 1,919 1,955
Cash flow from operating activities 2,362 1,061 1,072 229 0.4% -9.6% 3,776 1,423 2,353 1,174 1,120 59
Capital expenditures (PP&E and software) (1,146) (431) (380) (335) -4.7% 19.7% (1,767) (565) (1,202) (360) (386) (456)
Proceeds from real estate 73 51 15 7 >100% >200% 94 62 32 13 5 14
Tax recapture E-Plus 327 - - 327 0.0% n.m. 343 16 327 - - 327
Free cash flow² 1,616 681 707 228 7.0% -17.7% 2,446 936 1,510 827 739 (56)
1
Including Property, Plant & Equipment and software
2
Defined as Net cash flow from operating activities plus proceeds from real estate minus Capex, excluding tax recapture at E-Plus
KPN Investor Relations Cash flow, Capex & Debt Q3 2010
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Capex¹ YTD% Q3%
Germany 299 136 89 74 -2.3% 67.9% 450 144 306 81 83 142
Belgium 54 29 12 13 -22.9% -3.3% 101 31 70 30 22 18
Rest of World 5 3 1 1 >100% n.m. 4 2 2 - 1 1
Mobile International 358 168 102 88 -5.3% 51.4% 555 177 378 111 106 161
Consumer 228 68 88 72 50.0% 51.1% 221 69 152 45 54 53
Business 56 22 17 17 -30.9% 10.0% 113 32 81 20 25 36
Wholesale & Operations (national, excluding book gains) 405 139 134 132 -18.3% -9.7% 708 212 496 154 164 178
Other (including intercompany) 21 4 16 1 -19.2% -33.3% 49 23 26 6 13 7
Dutch Telco Business 710 233 255 222 -6.0% 3.6% 1,091 336 755 225 256 274
iBasis 8 3 3 2 >100% n.m. 5 2 3 (2) 3 2
Getronics 64 26 16 22 8.5% 13.0% 107 48 59 23 21 15
Other gains and losses, eliminations 2 (1) 3 - 100% n.m. - (1) 1 2 (1) -
Of which: Real estate 3 - 3 - n.m. n.m. - - - - -
The Netherlands 784 261 277 246 -4.2% 5.2% 1,203 385 818 248 279 291
Other 4 2 1 1 -33.3% 100% 9 3 6 1 1 4
Total Capex 1,146 431 380 335 -4.7% 19.7% 1,767 565 1,202 360 386 456
1
Including Property, Plant & Equipment and software
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Capex¹ / Revenues
Germany 12.4% 16.0% 11.1% 9.6% 14.2% 18.2% 12.8% 9.9% 10.4% 18.3%
Belgium 9.1% 15.2% 6.0% 6.4% 12.6% 15.0% 11.8% 15.0% 10.8% 9.4%
Rest of World 4.6% 6.5% 2.9% 3.4% 4.2% 6.5% 3.1% 0.0% 4.5% 6.3%
Mobile International 11.5% 15.5% 9.8% 8.8% 13.6% 17.2% 12.4% 10.6% 10.4% 16.4%
Consumer 7.7% 6.9% 8.9% 7.4% 5.4% 6.9% 4.9% 4.4% 5.2% 5.1%
Business 3.1% 3.8% 2.8% 2.7% 4.5% 5.1% 4.3% 3.3% 4.0% 5.7%
Wholesale & Operations (national, excluding book gains) 19.5% 20.6% 19.0% 18.8% 24.7% 29.7% 23.1% 22.4% 22.7% 24.2%
Other (including intercompany) -1.3% -0.8% -3.0% -0.2% -2.2% -4.1% -1.5% -1.1% -2.3% -1.2%
Dutch Telco Business 13.6% 13.6% 14.5% 12.6% 15.2% 18.9% 13.9% 12.8% 13.9% 15.0%
iBasis 1.2% 1.2% 1.3% 1.0% 0.7% 1.2% 0.5% -1.1% 1.7% 1.0%
Getronics 4.5% 5.5% 3.4% 4.6% 5.1% 8.9% 3.8% 4.7% 4.0% 2.8%
The Netherlands 11.3% 11.4% 11.9% 10.8% 12.8% 16.5% 11.6% 10.9% 11.7% 12.1%
Total Capex / Revenues 11.5% 12.9% 11.4% 10.2% 13.1% 16.9% 11.9% 10.9% 11.3% 13.5%
1
Including Property, Plant & Equipment and software
1
Debt summary YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
in € bn YTD% Q3%
Bonds 13.14 13.14 13.75 13.30 -0.2% -0.2% 13.16 13.16 13.16 13.16 12.73 12.96
Eurobonds 11.32 11.32 11.75 11.61 -2.1% -2.1% 11.60 11.60 11.56 11.56 10.68 10.62
Global bonds 1.82 1.82 2.00 1.69 13.8% 13.8% 1.56 1.56 1.60 1.60 2.05 2.34
Other debt 0.38 0.38 0.21 0.22 -59.6% -59.6% 0.21 0.21 0.94 0.94 0.69 0.59
Other loans at Royal KPN2 0.16 0.16 0.17 0.16 6.7% 6.7% 0.16 0.16 0.15 0.15 0.14 0.14
Consolidated debt 0.22 0.22 0.04 0.06 -72.2% -72.2% 0.05 0.05 0.79 0.79 0.55 0.45
3
Fair value financial instruments 0.05 0.05 (0.21) 0.25 -88.6% -88.6% 0.45 0.45 0.44 0.44 0.32 0.08
Total debt 13.57 13.57 13.75 13.77 -6.7% -6.7% 13.82 13.82 14.54 14.54 13.74 13.63
2
Of which short-term 2.09 2.09 0.93 0.93 >100% >100% 0.92 0.92 0.82 0.82 1.70 1.17
Cash and cash equivalents 1.34 1.34 1.62 2.37 -52.3% -52.3% 2.69 2.69 2.81 2.81 1.92 1.95
Net debt 12.23 12.23 12.13 11.40 4.3% 4.3% 11.13 11.13 11.73 11.73 11.82 11.68
1
Book value of interest bearing financial liabilities plus the fair value of financial instruments related to these financial liabilities
2
Current liabilities include approximately € 0.2bn of non-netted cash balances per Q3 ’10
3
Excluding option agreements related to Reggefiber € 0.1bn
KPN Investor Relations Cash flow, Capex & Debt Q3 2010
``
Bonds portfolio: Q3 2010
Principal Nominal amount Interest Days
GMTN Currency (mn) outstanding (mn) Coupon Issue date date(s) Redemption ISIN code Comments Lead arrangers Listing Paying Agent convention
Swapped into Fixed Rate of 7.30% (30/360) After
1-Apr exchange offer Issued as USN7637QAB97 (Reg S Morgan Stanley
Global bond 1 no USD 1,162 € 861 8.000% 4-Oct-'00 1-Oct 01-Oct-'10 US780641AB25 Global Note) & US780641AB25 (144A Global Note) UBS Warburg Amsterdam Bankers Trust 30/360
Deutsche Bank
Eurobond yes EUR 1,425 € 986 4.500% 21-Jul-'04 21-Jul 21-Jul-'11 XS0196776214 Banc of America Luxembourg Citibank Actual/ Actual
Citi
Put event applicable in case of Change of Control as ING
Eurobond yes EUR 1,250 € 957 5.000% 13-Nov-'07 13-Nov 13-Nov-'12 XS0330631051 specified in GMTN prospectus 2007 RBS Amsterdam Citibank Actual/ Actual
ABN Amro
Put event applicable in case of Change of Control as JPMorgan
Eurobond yes EUR 850 € 540 4.500% 16-Mar-'06 18-Mar 18-Mar-'13 XS0248012923 specified in supplement to GMTN prospectus 2005 RBS Amsterdam Citibank Actual/ Actual
Barclays Capital
Credit Suise
Put event applicable in case of Change of Control as JP Morgan
Eurobond yes EUR 850 € 545 6.250% 16-Sep-'08 16-Sep 16-Sep-'13 XS0387992661 specified in GMTN prospectus 2008 Rabobank Amsterdam Citibank Actual/ Actual
ABN Amro
Banc of America
Put event applicable in case of Change of Control as JPMorgan
Eurobond yes EUR 650 € 650 4.750% 29-May '07 29 May 29-May '14 XS0303070030 specified in GMTN prospectus 2007 UniCredit Amsterdam Citibank Actual/ Actual
Fortis Bank Nederland
ING
Put event applicable in case of Change of Control as JP Morgan
Eurobond yes EUR 750 € 750 6.250% 4-Feb-'09 04 Feb 04-Feb-'14 XS0411863722 specified in GMTN prospectus 2008 Deutsche Bank Amsterdam Citibank Actual/ Actual
ABN Amro
Citigroup
HVB
Eurobond yes EUR 1,000 € 1,000 4.000% 22-Jun-'05 22-Jun 22-Jun-'15 XS0222766973 ING Amsterdam Citibank Actual/ Actual
Swapped into Fixed Rate of 4.89% (30/360) Put event ABN Amro
applicable in case of Change of Control as specified JPMorgan
Eurobond yes GBP 275 € 328 5.750% 16-Mar-'06 18-Mar 18-Mar-'16 XS0248011446 in supplement to GMTN prospectus 2005 RBS Amsterdam Citibank Actual/ Actual
Put event applicable in case of Change of Control as BNP Paribas
specified in GMTN prospectus 2007 (€ 850 mln) and Rabobank
Eurobond yes EUR 925 € 925 6.500% 2-Apr-'08 15-Jan 15-Jan-'16 XS0355666941 in GMTN prospectus 2008 (tap € 75 mln). RBS Amsterdam Citibank Actual/ Actual
BNP Paribas
Put event applicable in case of Change of Control as Credit Suisse
Eurobond yes EUR 1,000 € 1,000 4.750% 13-Nov '06 17-Jan 17-Jan-'17 XS0275164084 specified in GMTN prospectus 2006 Rabobank Amsterdam Citibank Actual/ Actual
Fortis Bank Nederland
ING
Put event applicable in case of Change of Control as JP Morgan
Eurobond yes EUR 750 € 750 7.500% 4-Feb-'09 04 Feb 04-Feb-'19 XS0411850075 specified in GMTN prospectus 2008 Deutsche Bank Amsterdam Citibank Actual/ Actual
ABN Amro
Swapped into Fixed Rate of 5.12% (30/360) Put event Banc of America
applicable in case of Change of Control as specified JPMorgan
Eurobond yes GBP 250 € 290 6.000% 29-May '07 29 May 29-May '19 XS0303070113 in GMTN prospectus 2007. UniCredit Amsterdam Citibank Actual/ Actual
BNP Paribas
Credit Suisse
Put event applicable in case of Change of Control as Rabobank
Eurobond yes EUR 1,000 € 1,000 3.750% 21-Sep-10 21-Sep 21-Sep-20 XS0543354236 specified in GMTN prospectus 2010 Deutsche Bank Amsterdam Citibank Actual/ Actual
Barclays Bank
Credit Suisse
Put event applicable in case of Change of Control as Rabobank
Eurobond yes EUR 700 € 700 5.625% 30-Sep-09 30 Sep 30-Sep '24 XS0454773713 specified in GMTN prospectus 2009 UniCredit Amsterdam Citibank Actual/ Actual
RBS
Swapped into Fixed Rate of 5.98% (30/360) Put event BNP Paribas
applicable in case of Change of Control as specified Bank of America / Merril
Eurobond yes GBP 850 € 971 5.750% 17-Sep-09 17 Sep 17-Sep-29 XS0451790280 in GMTN prospectus 2009. Lynch Amsterdam Citibank Actual/ Actual
Swapped into 4 Floating Rates of 6 months Euribor +
2.75% (ACT/360) After exchange offer Issued as
1-Apr USN7637QAC70 (Reg S Global Note) & Morgan Stanley
Global bond no USD 1,000 € 891 8.375% 4-Oct-'00 1-Oct 01-Oct-'30 US780641AH94 US780641AC08 (144A Global Note) UBS Warburg Amsterdam Bankers Trust 30/360
Total Bonds Royal KPN NV € 13,144
1
Bond is repaid on 1 October with cash on balance
KPN Investor Relations Bond overview Q3 2010
``
Wireline Tariffs 2005 % 2006 % 2007 % 2008 % 2009 % 2010 %
Excluding VAT (which is 19%) 1 Dec (A) 1 Jul (A) 1 Jan (A) 1 Mar (A) 1 Jan (A) 1 Jan (A)
1 May (B) 1 Jul (B) 1 Feb (B) 1 Apr (B)
1 Jul (C) 1 Oct (C) 1 Mar (C) 1 Jul (C)
2 Aug (D) 1 Sept (D) 1 Oct (D)
15 Aug (E) 1 Oct (E)
Monthly exchange rental (A) (A) (B) + (E) (A) + (C) + (D)
- PSTN line KPN € 15.26 € 15.26 € 15.26 € 15.53 2% € 15.97 3% € 16.13 1%
- ISDN-2 line KPN € 21.96 € 21.96 € 21.96 € 22.36 2% € 22.98 3% € 23.21 1%
- Wholesale line rental PSTN € 12.88 € 13.11 2% € 12.37 -6% € 12.56 2%
- Wholesale line rental ISDN-2 € 18.80 € 19.14 2% € 18.92 -1% € 19.09 1%
Packages: Line rental + flat fee to wireline national (A) (A) (D)
- BelVrij "Weekend" € 15.97 € 15.13 -5% € 14.29 -6% € 14.29
- BelVrij "Evening & Weekend" € 20.17 € 20.17 € 19.33 -4% € 19.33
- BelVrij "Always" € 26.89 € 26.89 € 26.05 -3% € 26.05
Local traffic (B) (A) (B) (A)
Call set-up € 0.0359 € 0.0359 € 0.0363 1% € 0.0369 2% € 0.0379 3% € 0.0544 44%
- Standard € 0.0243 € 0.0243 € 0.0246 1% € 0.0250 2% € 0.0257 3% € 0.0257
- Off-peak € 0.0130 € 0.0130 € 0.0111 -15% € 0.0113 2% € 0.0116 3% € 0.0116
- Night/weekend € 0.0087 € 0.0087 € 0.0111 28% € 0.0113 2% € 0.0116 3% € 0.0116
Long Distance (B) (A) (B) (A)
Call set-up € 0.0435 € 0.0435 € 0.0440 1% € 0.0447 2% € 0.0459 3% € 0.0544 19%
- Standard € 0.0369 € 0.0369 € 0.0373 1% € 0.0379 2% € 0.0389 3% € 0.0389
- Off-peak € 0.0175 € 0.0175 € 0.0177 1% € 0.0180 2% € 0.0185 3% € 0.0185
Fixed-to-KPN Mobile (A) (B) + (E) (A) + (B) (B) (A)
Call set-up € 0.0435 € 0.0435 € 0.0440 1% € 0.0447 2% € 0.0459 3% € 0.0544 19%
- Standard € 0.1394 -13% € 0.1394 € 0.1294 -7% € 0.1177 -9% € 0.1187 1% € 0.1150 -3%
- Off-peak/Night € 0.1341 -13% € 0.1341 € 0.1245 -7% € 0.1177 -5% € 0.1187 1% € 0.1150 -3%
- Weekend € 0.1279 -14% € 0.1279 € 0.1184 -7% € 0.1177 -1% € 0.1187 1% € 0.1150 -3%
International Tariffs (B) (A) (B)
Call set-up € 0.0870 € 0.0870 € 0.0880 1% € 0.0894 2% € 0.0919 3% € 0.0919
- Germany € 0.0626 € 0.0626 € 0.0633 1% € 0.0643 2% € 0.0661 3% € 0.0661
- United Kingdom € 0.0602 € 0.0602 € 0.0609 1% € 0.0619 2% € 0.0636 3% € 0.0636
- France € 0.0695 € 0.0695 € 0.0703 1% € 0.0714 2% € 0.0734 3% € 0.0734
- United States € 0.0626 € 0.0626 € 0.0633 1% € 0.0643 2% € 0.0661 3% € 0.0661
Access to Unbundled Local Loops (monthly charge) (A) (C) (B) (A) (C)
- Line sharing tarriff € 1.91 € 0.74 -61% € 0.37 -50% € 0.19 -49% € 0.10 -47% € 0.10
- MDF access € 9.59 € 8.35 -13% € 8.00 -4% € 7.83 -2% € 6.52 -17% € 6.52
Interconnection (per minute, 3 min peak call incl. set-up charge) (A) (C)
- Local terminating € 0.007 € 0.007 € 0.007 € 0.007 € 0.0050 -29% € 0.0052 4%
- Regional terminating € 0.009 € 0.009 € 0.009 € 0.009 € 0.0069 -23% € 0.0071 3%
- National terminating € 0.0115 € 0.012 € 0.0115 € 0.0115 € 0.0115 € 0.0115
(A) (C)
- Carrier (pre)select local € 0.007 € 0.007 € 0.007 € 0.007 € 0.005 -29% € 0.0052 4%
- Carrier (pre)select regional € 0.011 € 0.011 € 0.011 € 0.011 € 0.007 -34% € 0.0073 3%
- Carrier (pre)select national € 0.015 € 0.015 € 0.015 € 0.015 € 0.015 € 0.015
ADSL retail e.g. with provider "Planet" (incl. KPN ADSL retail charge)
from July 2008 not for sale anymore
- Economy (1.5 Mb/s down - 256 kbit/s up) € 22.65 € 22.65 € 22.65 € 22.65 € 22.65 € 22.65
- Standard (3.0 Mb/s down - 512 kbit/s up) € 29.33 € 29.33 € 29.33 € 29.33 € 29.33 € 29.33
- Comfort (6.0 Mb/s down - 768 kbit/s up) € 46.18 € 46.18 € 46.18 € 46.18 € 46.18 € 46.18
- Advanced (8.0 to 12.0 Mb/s down and 1,024 kbit/s up) € 67.18 € 67.18 € 67.18 € 67.18 € 67.18 € 67.18
Newly sold from July 2008 (B)
- Internet Basis (8 Mb/s down - 1 Mb/s up) € 21.01 € 21.01 € 21.01
- Internet Extra (16 Mb/s down - 2 Mb/s up) € 29.41 € 29.41 € 29.41
- Internet Premium (40 Mb/s down - 3 Mb/s up) € 42.02 € 42.02 € 42.02
ADSL-retail charge (ISP needed)
- Speed: 1.5 to 3.0 Mb/s down - 256 to 512 kbit/s up € 16.76 € 16.76 € 16.76 € 16.76 € 16.76 € 16.76
- Speed: 6.0 Mb/s down - 768 kbit/s up) € 23.49 € 23.49 € 23.49 € 23.49 € 23.49 € 23.49
- Speed: 8.0 to 20.0 Mb/s down - 1.0 Mb/s up € 28.53 € 28.53 € 28.53 € 28.53 € 28.53 € 28.53
VoIP: "InternetPlusBellen" (package VoIP/broadband) , incl. national flat fee weekend
from July 2008 not for sale anymore
- Go (1.5 Mb/s down - 256 kbit/s up) € 29.37 € 29.37 € 29.37 € 29.37 € 29.37 € 29.37
- Lite (3.0 Mb/s down - 512 kbit/s up) € 36.09 € 36.09 € 36.09 € 36.09 € 36.09 € 36.09
- Basic (6.0 Mb/s down - 768 kbit/s up) € 50.38 € 50.38 € 50.38 € 50.38 € 50.38 € 50.38
- Extra (8.0 to 12.0 Mb/s down and 1,024 kbit/s up) € 67.18 € 67.18 € 67.18 € 67.18 € 67.18 € 67.18
Sold from July 2008 not for sale anymore (B)
- Basis (8 Mb/s down - 1 Mb/s up) including national flat fee weekend/evening € 29.41 € 29.41 € 29.41
- Extra (16 Mb/s down - 2 Mb/s up) including national flat fee any time € 42.02 € 42.02 € 42.02
- Premium (40 Mb/s down and 3 Mb/s up) including national flat fee any time € 54.62 € 54.62 € 54.62
Newly sold from July 2010 (C)
- Basis (8 Mb/s down - 1 Mb/s up) no additional voice bundle € 25.21 3%
- Extra (16 Mb/s down - 2 Mb/s up) no additional voice bundle € 33.61 3%
- Premium (40 Mb/s down and 3 Mb/s up) no additional voice bundle € 46.22 3%
TV (monthly charge) (D) (C) (D) (B)
- "Digitenne" (DVB-T) € 11.72 € 11.72 € 5.84 -50% € 6.30 8% € 7.14 13% € 7.14
- "Interactive TV" (IPTV) € 16.76 € 8.36 -50% € 8.36 € 8.36 € 8.40 3%
KPN Investor Relations Tariffs 11:50 AM/7/1/2011
``
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Revenues and Other income YTD% Q3%
Germany 2,421 850 803 768 1.3% 3.8% 3,181 791 2,390 819 797 774
Belgium 595 192 201 202 0.0% -4.0% 802 207 595 200 204 191
Rest of World (including intercompany) 108 45 34 29 68.8% 80.0% 95 31 64 25 23 16
Mobile International 3,124 1,087 1,038 999 2.5% 4.1% 4,078 1,029 3,049 1,044 1,024 981
Consumer 2,950 991 990 969 -4.6% -2.7% 4,095 1,004 3,091 1,018 1,042 1,031
Business 1,815 577 604 634 -2.8% -4.2% 2,491 624 1,867 602 631 634
Getronics 1,428 476 478 474 -8.5% -2.3% 2,097 537 1,560 487 531 542
Wholesale & Operations 2,684 919 903 862 3.2% 8.9% 3,459 857 2,602 844 861 897
Of which: W&O National 2,125 711 708 706 -2.6% -0.4% 2,918 736 2,182 714 726 742
Of which: Real Estate 158 48 55 55 -18.1% -26.2% 272 79 193 65 61 67
Of which: iBasis 678 248 237 193 21.9% 37.8% 719 163 556 180 177 199
Other (including intercompany) (1,913) (630) (636) (647) -5.5% -4.7% (2,697) (673) (2,024) (661) (672) (691)
The Netherlands 6,964 2,333 2,339 2,292 -1.9% 1.9% 9,445 2,349 7,096 2,290 2,393 2,413
Other activities 66 16 24 26 -40.0% -52.9% 143 33 110 34 36 40
Intercompany revenues (145) (58) (47) (40) 23.9% 56.8% (157) (40) (117) (37) (42) (38)
Revenues and Other income 10,009 3,378 3,354 3,277 -1.3% 1.4% 13,509 3,371 10,138 3,331 3,411 3,396
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
of which : Revenues YTD% Q3%
Germany 2,417 848 801 768 1.2% 3.7% 3,180 791 2,389 818 797 774
Belgium 594 191 201 202 -0.2% -4.5% 802 207 595 200 204 191
Rest of World (including intercompany) 109 46 34 29 70.3% 76.9% 95 31 64 26 22 16
Mobile International 3,120 1,085 1,036 999 2.4% 3.9% 4,077 1,029 3,048 1,044 1,023 981
Consumer 2,949 990 990 969 -4.6% -2.8% 4,094 1,003 3,091 1,018 1,042 1,031
Business 1,815 577 604 634 -2.8% -4.2% 2,491 624 1,867 602 631 634
Getronics 1,424 473 477 474 -8.7% -2.9% 2,097 537 1,560 487 531 542
Wholesale & Operations 2,639 882 899 858 2.7% 7.4% 3,404 835 2,569 821 858 890
Of which: W&O National 2,080 674 704 702 -3.2% -2.2% 2,862 714 2,148 689 724 735
Of which: Real Estate 150 48 51 51 -14.8% -17.2% 233 57 176 58 59 59
Of which: iBasis 678 248 237 193 21.9% 37.8% 719 163 556 180 177 199
Other (including intercompany) (1,913) (630) (635) (648) -5.5% -4.8% (2,697) (672) (2,025) (662) (671) (692)
The Netherlands 6,914 2,292 2,335 2,287 -2.1% 1.1% 9,389 2,327 7,062 2,266 2,391 2,405
Voice wireline 453 146 152 155 -15.2% -13.1% 702 168 534 168 179 187
Wireless services 1,377 462 464 451 -6.1% -4.1% 1,934 468 1,466 482 501 483
Internet wireline 768 255 256 257 -1.9% -2.7% 1,042 259 783 262 260 261
Mobile Wholesale NL 168 61 56 51 11.3% 19.6% 201 50 151 51 51 49
Other (including intercompany) 183 66 62 55 16.6% 20.0% 215 58 157 55 51 51
Consumer 2,949 990 990 969 -4.6% -2.8% 4,094 1,003 3,091 1,018 1,042 1,031
Voice & Internet wireline 742 233 239 270 -4.3% -7.2% 1,026 251 775 251 259 265
Data network services 309 100 103 106 -6.1% -7.4% 439 110 329 108 112 109
Wireless services 663 209 229 225 2.2% 0.5% 872 223 649 208 217 224
Other (including intercompany) 101 35 33 33 -11.4% 0.0% 154 40 114 35 43 36
Business 1,815 577 604 634 -2.8% -4.2% 2,491 624 1,867 602 631 634
Netherlands 1,101 367 368 366 -9.9% -4.4% 1,654 432 1,222 384 419 419
International 350 119 115 116 4.2% 9.2% 456 120 336 109 115 112
Other 23 7 8 8 -36.1% -22.2% 35 (1) 36 9 5 22
Eliminations (50) (20) (14) (16) 47.1% 33.3% (48) (14) (34) (15) (8) (11)
Getronics (existing) 1,424 473 477 474 -8.7% -2.9% 2,097 537 1,560 487 531 542
Other activities 65 16 24 25 -40.9% -52.9% 142 32 110 34 36 40
Intercompany revenues (145) (58) (47) (40) 23.9% 56.8% (157) (40) (117) (37) (42) (38)
Total Revenues (reported) 9,954 3,335 3,348 3,271 -1.5% 0.8% 13,451 3,348 10,103 3,307 3,408 3,388
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
of which: External Revenues YTD% Q3%
Germany 2,353 824 780 749 1.0% 3.3% 3,098 768 2,330 798 777 755
Belgium 551 177 185 189 -0.2% -4.8% 744 192 552 186 189 177
Rest of World 183 72 59 52 32.6% 28.6% 195 57 138 56 44 38
Mobile International 3,087 1,073 1,024 990 2.2% 3.2% 4,037 1,017 3,020 1,040 1,010 970
Consumer 2,825 950 947 928 -3.7% -1.8% 3,890 956 2,934 967 990 977
Business 1,651 521 551 579 -0.4% -2.6% 2,219 561 1,658 535 561 562
Getronics 1,307 433 440 434 -10.2% -4.8% 1,948 493 1,455 455 495 505
Wholesale & Operations 1,018 342 362 314 9.9% 23.5% 1,214 288 926 277 315 334
Of which: W&O National 478 150 169 159 -2.8% 6.4% 656 164 492 141 177 174
Of which: Real Estate 2 - 1 1 -71.4% -100.0% 8 1 7 2 3 2
Of which: iBasis 540 192 192 156 24.4% 41.2% 558 124 434 136 138 160
Other - - (1) 1 -100% -100% 1 - 1 1 (1) 1
The Netherlands (reported) 6,801 2,246 2,299 2,256 -2.5% 0.5% 9,272 2,298 6,974 2,235 2,360 2,379
Other activities 66 16 25 25 -39.4% -50.0% 142 33 109 32 38 39
Total External Revenues (reported) 9,954 3,335 3,348 3,271 -1.5% 0.8% 13,451 3,348 10,103 3,307 3,408 3,388
KPN Investor Relations Revenues (Old) Q3 2010
``
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Operating expenses YTD% Q3%
Germany 1,855 638 616 601 -2.3% -0.9% 2,536 637 1,899 644 634 621
Belgium 469 154 151 164 -6.2% -8.9% 678 178 500 169 167 164
Rest of World (including intercompany) 123 48 39 36 21.8% 45.5% 147 46 101 33 35 33
Mobile International 2,447 840 806 801 -2.1% -0.7% 3,361 861 2,500 846 836 818
Consumer 2,297 775 759 763 -9.3% -6.4% 3,353 821 2,532 828 839 865
Business 1,275 411 430 434 -3.9% -4.4% 1,778 451 1,327 430 440 457
Getronics 1,436 478 477 481 -13.0% -2.6% 2,187 536 1,651 491 559 601
Wholesale & Operations 2,026 686 694 646 2.9% 8.9% 2,597 629 1,968 630 652 686
Of which: W&O National 1,472 479 501 492 -4.0% -3.4% 2,041 508 1,533 496 515 522
Of which: Real Estate 113 36 34 43 -13.7% -14.3% 182 51 131 42 46 43
Of which: iBasis 673 247 234 192 17.7% 33.5% 734 162 572 185 178 209
Other (including intercompany) (1,909) (629) (636) (644) -4.3% -4.0% (2,665) (670) (1,995) (655) (661) (679)
The Netherlands 5,125 1,721 1,724 1,680 -6.5% -0.2% 7,250 1,767 5,483 1,724 1,829 1,930
Other activities 103 28 32 43 -29.5% -39.1% 205 59 146 46 46 54
Intercompany expenses (145) (58) (47) (40) 23.9% 56.8% (157) (40) (117) (37) (42) (38)
Total Operating expenses 7,530 2,531 2,515 2,484 -6.0% -1.9% 10,659 2,647 8,012 2,579 2,669 2,764
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Of which: Depreciation1 YTD% Q3%
Germany 273 96 90 87 -11.4% -6.8% 413 105 308 103 103 102
Belgium 57 18 19 20 -27.8% -30.8% 106 27 79 26 24 29
Rest of World (1) (1) (1) 1 n.m. n.m. 1 - 1 1 1 (1)
Mobile International 329 113 108 108 -15.2% -13.1% 520 132 388 130 128 130
Consumer 79 29 26 24 -6.0% 11.5% 113 29 84 26 29 29
Business 22 7 7 8 -15.4% -12.5% 34 8 26 8 9 9
Getronics 71 22 25 24 9.2% 0.0% 87 22 65 22 23 20
Wholesale & Operations 533 175 179 179 -8.9% -7.9% 772 187 585 190 197 198
Of which: W&O National 523 171 175 177 -9.2% -9.0% 759 183 576 188 191 197
Of which: Real Estate 20 7 6 7 -9.1% 0.0% 31 9 22 7 7 8
Of which: iBasis 10 4 2 4 0.0% 0.0% 13 3 10 4 3 3
Other 15 6 4 5 7.1% -25.0% 18 4 14 8 2 4
The Netherlands 720 239 241 240 -7.0% -5.9% 1,024 250 774 254 260 260
Other activities 3 1 2 - -40.0% n.m. 6 1 5 - 3 2
Total Depreciation (incl. impairments) 1,052 353 351 348 -9.9% -8.1% 1,550 383 1,167 384 391 392
1
Including impairments, if any
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Of which: Amortization1 YTD% Q3%
Germany 213 78 68 67 4.9% 13.0% 275 72 203 69 67 67
Belgium 33 12 12 9 57.1% 50.0% 29 8 21 8 7 6
Rest of World 6 2 2 2 20.0% 0.0% 12 7 5 2 1 2
Mobile International 252 92 82 78 10.0% 16.5% 316 87 229 79 75 75
Consumer 96 33 32 31 -34.2% -32.7% 175 29 146 49 48 49
Business 47 16 16 15 42.4% 33.3% 47 14 33 12 11 10
Getronics 40 14 14 12 -21.6% 7.7% 65 14 51 13 14 24
Wholesale & Operations 132 45 47 40 14.8% 28.6% 156 41 115 35 34 46
Of which: W&O National 122 42 43 37 29.8% 35.5% 132 38 94 31 32 31
Of which: Real Estate - - - - n.m. n.m. - - - - - -
Of which: iBasis 10 3 4 3 -52.4% 0.0% 24 3 21 3 4 14
Other 15 6 5 4 -6.3% 50.0% 25 9 16 4 6 6
The Netherlands 330 114 114 102 -8.6% 0.9% 468 107 361 113 113 135
Other activities 4 2 - 2 100% 100% 8 6 2 1 1 -
Total Amortization (incl. impairments) 586 208 196 182 -1.0% 7.8% 792 200 592 193 189 210
1
Including impairments, if any
KPN Investor Relations Expenses (Old) Q3 2010
``
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Operating profit YTD% Q3%
Germany 566 212 187 167 15.3% 21.1% 645 154 491 175 163 153
Belgium 126 38 50 38 32.6% 22.6% 124 29 95 31 37 27
Rest of World (15) (3) (5) (7) -59.5% -62.5% (52) (15) (37) (8) (12) (17)
Mobile International 677 247 232 198 23.3% 24.7% 717 168 549 198 188 163
Consumer 653 216 231 206 16.8% 13.7% 742 183 559 190 203 166
Business 540 166 174 200 0.0% -3.5% 713 173 540 172 191 177
Getronics (8) (2) 1 (7) -91.2% -50.0% (90) 1 (91) (4) (28) (59)
Wholesale & Operations 658 233 209 216 3.8% 8.9% 862 228 634 214 209 211
Of which: W&O National 653 232 207 214 0.6% 6.4% 877 228 649 218 211 220
Of which: Real Estate 45 12 21 12 -27.4% -47.8% 90 28 62 23 15 24
Of which: iBasis 5 1 3 1 n.m. n.m. (15) 1 (16) (5) (1) (10)
Other (4) (1) - (3) -86.2% -83.3% (32) (3) (29) (6) (11) (12)
The Netherlands 1,839 612 615 612 14.0% 8.1% 2,195 582 1,613 566 564 483
Other activities (37) (12) (8) (17) 2.8% 0.0% (62) (26) (36) (12) (10) (14)
Total Operating profit 2,479 847 839 793 16.6% 12.6% 2,850 724 2,126 752 742 632
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
Operating profit margin
Germany 23.4% 24.9% 23.3% 21.7% 20.3% 19.5% 20.5% 21.4% 20.5% 19.8%
Belgium 21.2% 19.8% 24.9% 18.8% 15.5% 14.0% 16.0% 15.5% 18.1% 14.1%
Rest of World -13.9% -6.7% -14.7% -24.1% -54.7% -48.4% -57.8% -32.0% -52.2% -106.3%
Mobile International 21.7% 22.7% 22.4% 19.8% 17.6% 16.3% 18.0% 19.0% 18.4% 16.6%
Consumer 22.1% 21.8% 23.3% 21.3% 18.1% 18.2% 18.1% 18.7% 19.5% 16.1%
Business 29.8% 28.8% 28.8% 31.5% 28.6% 27.7% 28.9% 28.6% 30.3% 27.9%
Getronics -0.6% -0.4% 0.2% -1.5% -4.3% 0.2% -5.8% -0.8% -5.3% -10.9%
Wholesale & Operations 24.5% 25.4% 23.1% 25.1% 24.9% 26.6% 24.4% 25.4% 24.3% 23.5%
The Netherlands 26.4% 26.2% 26.3% 26.7% 23.2% 24.8% 22.7% 24.7% 23.6% 20.0%
Other activities -56.1% -75.0% -33.3% -65.4% -43.4% -78.8% -32.7% -35.3% -27.8% -35.0%
Total Operating profit margin 24.8% 25.1% 25.0% 24.2% 21.1% 21.5% 21.0% 22.6% 21.8% 18.6%
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 y-o-y y-o-y 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
EBITDA YTD% Q3%
Germany 1,052 386 345 321 5.0% 11.2% 1,333 331 1,002 347 333 322
Belgium 216 68 81 67 10.8% 4.6% 259 64 195 65 68 62
Rest of World (10) (2) (4) (4) -67.7% -60.0% (39) (8) (31) (5) (10) (16)
Mobile International 1,258 452 422 384 7.9% 11.1% 1,553 387 1,166 407 391 368
Consumer 828 278 289 261 4.9% 4.9% 1,030 241 789 265 280 244
Business 609 189 197 223 1.7% -1.6% 794 195 599 192 211 196
Getronics 103 34 40 29 >200% 9.7% 62 37 25 31 9 (15)
Wholesale & Operations 1,323 453 435 435 -0.8% 3.2% 1,790 456 1,334 439 440 455
Of which: W&O National 1,298 445 425 428 -1.6% 1.8% 1,768 449 1,319 437 434 448
Of which: Real Estate 65 19 27 19 -22.6% -36.7% 121 37 84 30 22 32
Of which: iBasis 25 8 9 8 66.7% >100% 22 7 15 2 6 7
Other 26 11 9 6 >1,000% 83.3% 11 10 1 6 (3) (2)
The Netherlands 2,889 965 970 954 5.1% 3.4% 3,687 939 2,748 933 937 878
Other activities (30) (9) (6) (15) 3.4% -18.2% (48) (19) (29) (11) (6) (12)
Total EBITDA 4,117 1,408 1,386 1,323 6.0% 5.9% 5,192 1,307 3,885 1,329 1,322 1,234
Consolidated figures YTD '10 Q3 '10 Q2 '10 Q1 '10 2,009 Q4 '09 YTD '09 Q3 '09 Q2 '09 Q1 '09
EBITDA margin
Germany 43.5% 45.4% 43.0% 41.8% 41.9% 41.8% 41.9% 42.4% 41.8% 41.6%
Belgium 36.3% 35.4% 40.3% 33.2% 32.3% 30.9% 32.8% 32.5% 33.3% 32.5%
Rest of World -9.3% -4.4% -11.8% -13.8% -41.1% -25.8% -48.4% -20.0% -43.5% -100.0%
Mobile International 40.3% 41.6% 40.7% 38.4% 38.1% 37.6% 38.2% 39.0% 38.2% 37.5%
Consumer 28.1% 28.1% 29.2% 26.9% 25.2% 24.0% 25.5% 26.0% 26.9% 23.7%
Business 33.6% 32.8% 32.6% 35.2% 31.9% 31.3% 32.1% 31.9% 33.4% 30.9%
Getronics 7.2% 7.1% 8.4% 6.1% 3.0% 6.9% 1.6% 6.4% 1.7% -2.8%
Wholesale & Operations 49.3% 49.3% 48.2% 50.5% 51.7% 53.2% 51.3% 52.0% 51.1% 50.7%
The Netherlands 41.5% 41.4% 41.5% 41.6% 39.0% 40.0% 38.7% 40.7% 39.2% 36.4%
Other activities -45.5% -56.3% -25.0% -57.7% -33.6% -57.6% -26.4% -32.4% -16.7% -30.0%
Total EBITDA margin 41.1% 41.7% 41.3% 40.4% 38.4% 38.8% 38.3% 39.9% 38.8% 36.3%
KPN Investor Relations Profit & Margin (Old) Q3 2010
