FINANCIAL AND OPERATIONAL HIGHLIGHTS
SARANA MENARA NUSANTARA

 

Executive Summary

Amount in IDR Billion, unless otherwise stated


FINANCIAL DATA

 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 
 
Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2TOTAL
 
Revenue17.134.758.6104.7104.7 63.9167.8325.6520.6520.6 239.2504.2783.01,082.51,082.5 326.4664.61,008.11,355.81,355.8 369.0772.31,199.21,650.91,650.9 481.51,023.51,619.12,265.32,265.3 720.21,481.72,295.33,197.13,197.1 913.21,909.93,074.94,106.24,106.2 1,068.62,141.13,273.84,469.84,469.8 1,170.32,423.13,731.85,053.15,053.1 1,313.32,643.22,643.2Revenue
EBITDA12.323.033.966.366.3 41.4115.1230.9426.8426.8 206.1429.6666.7932.9932.9 268.3549.4836.61,127.51,127.5 308.0644.71,003.71,386.01,386.0 404.0853.61,349.41,888.71,888.7 600.71,235.71,908.72,651.42,651.4 754.31,568.32,540.13,418.43,418.4 889.71,792.72,744.63,775.73,775.7 1,000.52,108.83,254.44,408.04,408.0 1,133.62,269.52,269.5EBITDA
Net Profit / Loss12.822.742.35.95.9 13.338.02.7(431.6)(431.6) 14.7354.9504.6589.5589.5 76.6(38.7)70.8100.0100.0 151.3257.1268.6283.9283.9 75.2128.8250.4346.3346.3 171.9338.1106.3164.7164.7 449.0581.7889.7839.4839.4 170.3474.8487.72,964.72,964.7 519.51,328.02,311.63,043.03,043.0 649.41,276.01,276.0Net Profit / Loss
Earnings per share
(Full Amount)
9.015.228.34.04.0 4.613.00.9(148.0)(148.0) 15.0362.0515.0601.0601.0 78.0(38.0)70.099.099.0 148.0252.0263.0278.0278.0 74.0126.0245.0340.0340.0 170.033.411.016.516.5 44.157.187.482.482.4 16.546.447.5290.0290.0 50.8129.8226.2297.9297.9 63.6125.1125.1Earnings per share
(Full Amount)
Cash Position6.1214.0216.381.181.1 65.545.692.2925.7925.7 935.5821.4684.7473.8473.8 601.0476.0427.5354.6354.6 702.1800.7591.7649.5649.5 498.51,621.61,253.11,129.61,129.6 947.61,428.81,610.01,505.71,505.7 1,373.52,283.32,412.32,009.62,009.6 2,074.23,205.02,588.02,986.82,986.8 2,956.33,601.31,550.92,905.32,905.3 2,421.94,743.34,743.3Cash Position
Bank Debt102.687.0272.5328.7328.7 381.2411.21,738.42,617.82,617.8 2,804.82,745.12,644.03,277.63,277.6 3,537.14,333.04,274.04,276.84,276.8 4,394.25,241.05,623.26,152.66,152.6 6,097.26,917.56,839.48,069.48,069.4 8,051.28,264.49,146.59,435.19,435.1 7,993.68,253.38,300.26,679.66,679.6 6,808.36,871.47,487.97,112.87,112.8 6,867.69,768.56,592.06,622.56,622.5 6,602.57,616.77,616.7Bank Debt
Bonds Payable----- ----- ----- ----- ----- ----- ----- 1,000.01,000.01,000.02,696.32,696.3 2,725.82,782.32,864.62,759.52,759.5 2,769.42,758.72,713.93,473.83,473.8 2,515.82,526.32,526.3Bonds Payable
Subdebt---68.668.6 67.01,326.41,350.81,604.11,604.1 1,732.31,497.91,520.71,476.61,476.6 1,540.4781.1840.0846.3846.3 819.8---- ----- ----- ----- ----- ----- ---Subdebt
Mezzanine----- ---462.7462.7 527.8500.1486.5601.4601.4 657.7---- ----- ----- ----- ----- ----- ----- ---Mezzanine
Management Tower Europe S.a.r.l----- ----- ----- ----- ----- ---220.7220.7 214.0223.6270.0289.8289.8 270.0281.4266.9222.0222.0 207.8218.9241.9221.1221.1 220.5214.9--- ---Management Tower Europe S.a.r.l
Trailing EBITDA - 12 months49.346.145.266.366.3 95.4158.4263.3426.8426.8 591.5741.3862.6932.9932.9 995.11,052.71,102.91,127.51,127.5 1,167.31,222.81,294.61,386.01,386.0 1,482.01,594.91,731.71,888.71,888.7 2,085.32,270.82,447.92,651.42,651.4 2,805.12,984.03,282.83,418.43,418.4 3,553.83,642.83,622.93,775.73,775.7 3,886.54,091.84,285.64,408.04,408.0 4,541.24,568.74,568.7Trailing EBITDA - 12 months
                                                                 
CAPEX-112.8112.9189.5415.2 104.61,417.91,419.1104.83,046.4 158.2279.847.4907.11,392.5 462.517.231.656.0567.3 272.0357.7603.3303.11,536.2 407.1318.6327.61,442.82,496.1 779.0228.1228.4295.21,530.6 566.5384.2407.9342.91,701.6 244.8717.6819.6255.41,639.4 96.83,799.2172.3270.24,338.5 215.3253.1468.5CAPEX
Tax paid
(art. 22+23+25+29)
0.20.20.20.20.8 0.20.50.20.21.1 1.31.23.33.19.0 8.324.09.39.150.7 14.421.58.39.653.8 15.735.714.716.082.1 25.655.522.831.8135.8 26.236.620.017.3100.1 15.1459.995.3106.4676.6 98.1176.989.7106.4471.6 99.9495.3595.2Tax paid
(art. 22+23+25+29)



RATIOS

 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 
 
Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2TOTAL
 
Net Debt97(127)56316316 3831,6922,9973,7593,759 4,1293,9223,9664,8824,882 5,1344,6384,6864,7694,769 4,5124,4405,0315,5035,503 5,5995,2965,5867,1617,161 7,3187,0597,8078,2198,219 7,8907,2517,1557,5887,588 7,6686,6688,0067,1067,106 6,9019,1417,7557,1917,191 6,6965,4005,400Net Debt
Net Debt to EBITDA - LQA1.96-1.302.442.44 2.315.746.474.804.80 5.014.394.184.584.58 4.784.124.084.104.10 3.663.303.503.603.60 3.462.952.823.323.32 3.052.782.902.772.77 2.612.231.842.162.16 2.151.852.101.721.72 1.722.061.691.561.56 1.481.191.19Net Debt to EBITDA - LQA
Net Debt to EBITDA - Trailing (12 mo)1.96-1.244.774.77 4.0110.6811.388.818.81 6.985.294.605.235.23 5.164.414.254.234.23 3.873.633.893.973.97 3.783.323.233.793.79 3.513.113.193.103.10 2.812.432.182.222.22 2.161.832.211.881.88 1.782.231.811.631.63 1.471.181.18Net Debt to EBITDA - Trailing (12 mo)
DSCR----- ----- ----- 2.273.673.463.443.44 4.534.013.462.562.56 2.172.052.022.212.21 2.773.274.074.254.25 4.014.905.214.804.80 4.034.383.634.224.22 4.143.532.70-- 3.934.044.04DSCR
FX end of Quarter (USD/IDR)9,1189,0549,1379,4199,419 9,2179,2259,37810,95010,950 11,57510,2259,6819,4009,400 9,1159,0838,9248,9918,991 8,7098,5978,8239,0689,068 9,1809,4809,5889,6709,670 9,7199,92911,61312,18912,189 11,40411,96912,21212,44012,440 13,08413,33214,65713,79513,795 13,27613,18012,99813,43613,436 13,32113,31913,319FX end of Quarter (USD/IDR)
FX end of Quarter (EURO/IDR)12,15412,16412,93813,76013,760 14,55914,56313,75115,43215,432 15,32714,43214,15813,51013,510 12,21611,08712,13911,95611,956 12,31712,46211,95611,73911,739 12,25911,80112,40712,81012,810 12,42312,97715,67116,82116,821 15,67416,33315,49515,13315,133 14,16514,92016,49215,07015,070 15,03014,65114,57914,16214,162 14,22814,87514,875FX end of Quarter (EURO/IDR)
FX end of Quarter (SGD/IDR)6,0125,9086,1326,5026,502 6,6836,7796,5947,6077,607 7,6177,0556,8416,6996,699 6,5056,4816,7746,9816,981 6,9066,9856,7966,9746,974 7,3097,4157,8267,9077,907 7,8167,8419,2349,6289,628 9,0509,5839,5859,4229,422 9,5089,89510,2749,7519,751 9,8309,7719,5229,2999,299 9,5329,5919,591FX end of Quarter (SGD/IDR)



OPERATIONAL DATA

 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 
 
Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTALCUMULATIVE Q1Q2Q3Q4TOTALCUMULATIVE Q1Q2Q3Q4TOTALCUMULATIVE Q1Q2Q3Q4TOTALCUMULATIVE Q1Q2Q3Q4TOTALCUMULATIVE Q1Q2Q3Q4TOTALCUMULATIVE Q1Q2Q3Q4TOTALCUMULATIVE Q1Q2Q3Q4TOTALCUMULATIVE Q1Q2Q3Q4TOTALCUMULATIVE Q1Q2TOTALCUMULATIVE
 
Total Physical Sites---781781 751,1651,201902,5313,312 147202177371,1034,415 3948122436575,072 1233735063531,3556,427 3823344588812,0558,482 5122041983701,2849,766 5596143892671,82911,595 80604762664212,237 182,520(246)332,32514,562 25275214,614Total Physical Sites
Total Sites27029208251758 901,1721,200922,5543,312 145200177361,0984,410 3998112446625,072 1003754353811,2916,363 4043554638752,0978,460 5321881993671,2869,746 2328214171161,58611,332 1411594343977312,105 112,517(258)72,27714,382 41246514,447Total Sites
Total Colos102485107226 1962155326561,5991,825 3633371901571,0472,872 66891411254213,293 1905182691651,1424,435 3085154666651,9546,389 8145185053502,1878,576 315301315(701)2308,806 46296173465619,367 (97)1,327(261)(70)89910,266 (116)30218610,452Total Colos



SITES PER ISLANDS

 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 
 
Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2TOTAL
 
Java189216246361361 3981,3072,2062,2052,205 2,2402,3492,3532,6842,684 2,8072,8082,7962,8462,846 2,8542,9203,0753,1973,197 3,3613,5123,9004,1834,183 4,4904,6134,7565,0575,057 5,1975,6365,6975,8375,837 5,7395,8446,2666,2956,295 6,3027,7317,7297,7267,726 7,7597,7807,780Java
Sumatra2838101168168 212327554557557 5916456451,0061,006 1,0831,0831,0881,1801,180 1,2411,3471,4281,5091,509 1,6011,6621,6691,8991,899 2,0272,0502,0752,1062,106 2,1332,1942,3052,2692,269 2,3652,3762,3822,3852,385 2,3872,9942,9952,9982,998 3,0002,9992,999Sumatra
Kalimantan1316466363 8387106158158 212226236243243 338343346386386 399476596685685 724754789817817 843850859869869 9051,0451,1571,1651,165 1,2591,2711,2751,2781,278 1,2791,4011,4001,4001,400 1,4021,4031,403Kalimantan
Others4029114166166 155299354392392 414437440477477 581583598660660 678804883972972 1,0811,1941,2271,5611,561 1,6321,6671,6891,7141,714 1,7431,9242,0572,0612,061 2,1102,1412,1432,1472,147 2,1482,5072,2512,2582,258 2,2622,2652,265Others



TOTAL EMPLOYEE

 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 
 
Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2Q3Q4TOTAL Q1Q2TOTAL
 
Permanent2275101114114 123168197229229 235237244249249 251243251254254 253269276321321 350397438478478 479509526541541 558582586600600 587576748749749 750760767774774 785796796Permanent
Definite----- 611283838 35-323737 3326196363 78121135102102 9789111124124 141144143158158 173175164141141 141134226199199 167150132154154 156164164Definite


Notes :

  • In IDR billion unless Operational data, Sites per island and Total Employee
  • From 2007-2008 using Protelindo figures
  • 2009 onwards using SMN figures