{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":123,"n_cols":10,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
[null,1,2014,2015,2016,2017,2018,2019,2020]
["Gross profit",null,"66,45B‬","‪104,76B‬","‪119,92B‬","‪131,77B‬","‪167,05B‬","‪127,08B‬","‪126,26B"]
["Total revenue",null,"307,04B‬","‪357,93B‬","‪377,18B‬","‪440,16B‬","‪516,03B‬","‪489,55B‬","‪462,71B"]
["Cost of goods",null,"‪−240,59B‬","‪−253,17B‬","‪−257,26B‬","‪−308,39B‬","‪−348,98B‬","‪−362,47B‬","‪−336,45B‬"]
["Operating expenses (excl. COGS)",null,"‪−34,52B‬","‪−40,03B‬","‪−42,61B‬","‪−45,73B‬","‪−52,14B‬","‪−48,27B‬","‪−48,69B‬"]
["Operating income",null,"‪31,93B‬","‪64,73B‬","‪77,31B‬","‪86,04B‬","‪114,90B‬","‪78,81B‬","‪77,56B‬"]
["Non-operating income, total",null,"‪−34,06B‬","‪−27,28B‬","‪12,53B‬","‪874,95","‪−3,39B‬","‪−7,96B‬","‪−20,40B"]
["Pretax income",null,"‪−2,12B‬","‪37,45B‬","‪89,84B‬","‪86,91B‬","‪111,51B‬","‪70,85B‬","‪57,16B‬"]
["Taxes",null,386.12,"‪−11,77B‬","‪−15,48B‬","‪−17,85B‬","‪−28,77B‬","‪−15,46B‬","‪−13,46B"]
["Non-controlling/minority interest",null,"‪38,61","‪−61,30","‪0,00‬","‪−291,65","‪−125,65","‪−388,23","‪−72,35"]
["Net income",null,"−1,66B‬","‪25,75B‬","‪74,43B‬","‪69,06B‬","‪82,61B‬","‪55,00B‬","‪43,63B‬"]
["Dilution adjustment",null,"‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬"]
["Preferred dividends",null,"‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬"]
["Basic EPS",null,"−0,15‬","‪2,33‬","‪6,63‬","‪6,18‬","‪7,39‬","‪4,92‬","‪3,90"]
["Diluted EPS",null,"−0,15‬","‪2,33‬","‪6,63‬","‪6,18‬","‪7,39‬","‪4,92‬","‪3,90"]
["Average basic shares outstanding",null,"11,15B‬","‪11,16B‬","‪11,17B‬","‪11,17B‬","‪11,17B‬","‪11,17B‬","‪11,17B"]
["Diluted shares outstanding",null,"11,15B‬","‪11,16B‬","‪11,17B‬","‪11,17B‬","‪11,17B‬","‪11,17B‬","‪11,17B"]
["EBITDA",null,"‪60,74B‬","‪101,14B‬","‪109,74B‬","‪117,48B‬","‪150,46B‬","‪116,02B‬","‪107,81B"]
["EBIT",null,"‪31,93B‬","‪64,73B‬","‪77,31B‬","‪86,04B‬","‪114,90B‬","‪78,81B‬","‪77,56B‬"]
["Total operating expenses",null,"‪275,11B‬","‪293,20B‬","‪299,87B‬","‪354,12B‬","‪401,12B‬","‪410,74B‬","‪385,14B‬"]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
["Total assets",null,"‪474,84B‬","‪453,77B‬","‪400,32B‬","‪462,41B‬","‪502,88B‬","‪519,31B‬","‪558,58B"]
["Total current assets",null,"‪135,60B‬","‪150,74B‬","‪124,47B‬","‪167,94B‬","‪190,08B‬","‪185,77B‬","‪210,87B"]
["Cash and short term investments",null,"‪33,42B‬","‪53,17B‬","‪19,29B‬","‪32,47B‬","‪51,75B‬","‪69,13B‬","‪78,77B‬"]
["Total receivables, net",null,"‪39,60B‬","‪31,84B‬","‪37,05B‬","‪49,74B‬","‪50,50B‬","‪37,27B‬","‪43,57B"]
["Total inventory",null,"‪60,42B‬","‪64,05B‬","‪65,13B‬","‪81,81B‬","‪84,43B‬","‪75,53B‬","‪83,43B"]
["Prepaid expenses",null,"‪2,16B‬","‪1,68B‬","‪2,99B‬","‪3,91B‬","‪3,40B‬","‪3,54B‬","‪2,00B"]
["Other current assets, total",null,"‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","—","‪310,56","‪3,11B"]
["Total non-current assets",null,"339,24B‬","‪303,02B‬","‪275,86B‬","‪294,48B‬","‪312,80B‬","‪333,54B‬","‪347,71B"]
["Long term investments",null,"‪21,18B‬","‪15,78B‬","‪549,39","‪287,86","‪208,12","‪248,44","‪221,89"]
["Net property/plant/equipment",null,"‪304,32B‬","‪274,90B‬","‪265,24B‬","‪280,60B‬","‪304,41B‬","‪322,17B‬","‪336,46B‬"]
["Gross property/plant/equipment",null,"‪588,66B‬","‪580,70B‬","‪591,57B‬","‪612,10B‬","‪672,71B‬","‪701,42B‬","‪743,79B"]
["Accumulated depreciation, total",null,"‪−284,34B‬","‪−305,80B‬","‪−326,34B‬","‪−331,50B‬","‪−368,30B‬","‪−379,25B‬","‪−407,32B‬"]
["Deferred tax assets",null,"‪12,06B‬","‪8,84B‬","‪8,06B‬","‪11,57B‬","‪6,52B‬","‪8,20B‬","‪8,06B‬"]
["Net intangible assets",null,"‪1,44B‬","‪1,31B‬","‪1,34B‬","‪1,55B‬","‪1,66B‬","‪2,92B‬","‪2,96B‬"]
["Goodwill, net",null,"‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","—","‪0,00‬"]
["Other intangibles, net",null,"‪1,44B‬","‪1,31B‬","‪1,34B‬","‪1,55B‬","‪1,66B‬","—","‪2,96B‬"]
["Other long term assets, total",null,"‪240,00","‪2,19B‬","‪671,48","‪460,57","‪0,00‬","‪0,00‬","‪0,00"]
["Total liabilities",null,"‪238,32B‬","‪211,29B‬","‪112,75B‬","‪145,94B‬","‪155,39B‬","‪176,52B‬","‪218,27B‬"]
["Total current liabilities",null,"‪96,48B‬","‪103,78B‬","‪65,13B‬","‪91,08B‬","‪97,26B‬","‪97,20B‬","‪134,99B‬"]
["Short term debt",null,"‪51,78B‬","‪65,22B‬","‪19,60B‬","‪17,79B‬","‪19,35B‬","‪20,75B‬","‪30,62B‬"]
["Accounts payable",null,"23,22B‬","‪24,76B‬","‪25,39B‬","‪38,52B‬","‪38,36B‬","‪33,48B‬","‪45,86B‬"]
["Income tax payable",null,"‪4,50B‬","‪2,56B‬","‪1,40B‬","‪1,15B‬","‪1,18B‬","‪372,67","‪1,33B‬"]
["Dividends payable",null,"‪120,00","‪73,03","‪61,04","‪12,55B‬","‪19,29B‬","‪19,07B‬","‪27,37B‬"]
["Accrued payroll",null,"3,66B‬","‪3,58B‬","‪3,66B‬","‪3,80B‬","‪3,95B‬","‪3,91B‬","‪4,22B‬"]
["Deferred income, current",null,"—","—","‪9,40B‬","‪10,48B‬","‪8,05B‬","‪11,74B‬","‪17,97B‬"]
["Other current liabilities",null,"‪13,20B‬","‪7,60B‬","‪5,62B‬","‪6,79B‬","‪7,08B‬","‪7,89B‬","‪7,62B"]
["Total non-current liabilities",null,"‪141,84B‬","‪107,51B‬","‪47,61B‬","‪54,87B‬","‪58,13B‬","‪79,32B‬","‪83,28B‬"]
["Long term debt",null,"103,32B‬","‪69,68B‬","‪10,93B‬","‪13,53B‬","‪17,83B‬","‪33,29B‬","‪41,12B‬"]
["Provision for risks & charge",null,"‪5,88B‬","‪10,15B‬","‪10,44B‬","‪11,28B‬","‪10,20B‬","‪15,47B‬","‪10,58B‬"]
["Deferred tax liabilities",null,"‪32,64B‬","‪27,68B‬","‪26,25B‬","‪30,22B‬","‪29,48B‬","‪30,25B‬","‪31,43B‬"]
["Deferred income, non-current",null,"—","—","—","—","—","—","—"]
["Other non-current liabilities, total",null,"‪0,00‬","‪0,00‬","‪−0,00‬","‪−172,71","‪624,35","‪310,56","‪147,93"]
["Total equity",null,"‪236,52B‬","‪242,48B‬","‪287,58B‬","‪316,47B‬","‪347,49B‬","‪342,79B‬","‪340,31B‬"]
["Common equity, total",null,"‪234,60B‬","‪241,53B‬","‪286,48B‬","‪315,09B‬","‪346,03B‬","‪341,43B‬","‪338,90B‬"]
["Retained earnings",null,"‪447,48B‬","‪567,63B‬","‪531,26B‬","‪533,05B‬","‪670,28B‬","‪596,27B‬","‪704,29B"]
["Paid in capital",null,"82,08B‬","‪98,89B‬","‪82,71B‬","‪78,01B‬","‪94,00B‬","‪84,16B‬","‪100,22B‬"]
["Common stock par/Carrying value",null,"‪23,16B‬","‪28,19B‬","‪23,56B‬","‪22,22B‬","‪26,78B‬","‪23,97B‬","‪28,55B"]
["Additional paid-in capital/Capital surplus",null,"‪59,70B‬","‪70,77B‬","‪59,15B‬","‪55,79B‬","‪67,22B‬","‪60,19B‬","‪71,67B"]
["Treasury stock - common",null,"‪−780,00","‪−73,03","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00"]
["Other common equity",null,"−294,96B‬","‪−424,99B‬","‪−327,50B‬","‪−295,97B‬","‪−418,25B‬","‪−339,00B‬","‪−465,61B‬"]
["Preferred stock, carrying value",null,"‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬"]
["Minority interest",null,"‪1,92B‬","‪949,46","‪1,10B‬","‪1,38B‬","‪1,46B‬","‪1,37B‬","‪1,41B"]
["Total liabilities & shareholders' equities",null,"‪474,84B‬","‪453,77B‬","‪400,32B‬","‪462,41B‬","‪502,88B‬","‪519,31B‬","‪558,58B‬"]
["Total debt",null,"‪155,10B‬","‪134,90B‬","‪30,52B‬","‪31,32B‬","‪37,18B‬","‪54,04B‬","‪71,75B‬"]
["Book value per share",null,"‪21,05‬","‪21,62‬","‪25,64‬","‪28,20‬","‪30,97‬","‪30,55‬","‪30,33"]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
["Cash from operating activities",null,"‪50,04B‬","‪85,70B‬","‪81,00B‬","‪79,80B‬","‪119,61B‬","‪112,52B‬","‪90,37B‬"]
["Funds from operations",null,"‪51,89B‬","‪84,53B‬","‪84,82B‬","‪96,94B‬","‪123,51B‬","‪93,95B‬","‪92,83B‬"]
["Net income (cash flow)",null,"‪−1,70B‬","‪25,81B‬","‪74,43B‬","‪69,35B‬","‪82,74B‬","‪55,39B‬","‪43,56B‬"]
["Depreciation & amortization (cash flow)",null,"‪28,80B‬","‪32,80B‬","‪32,43B‬","‪31,73B‬","‪35,56B‬","‪37,21B‬","‪30,24B‬"]
["Deferred taxes (cash flow)",null,"—","—","‪−1,27B‬","‪1,22B‬","‪4,27B‬","‪−1,04B‬","‪1,37B‬"]
["Non-cash items",null,"‪24,79B‬","‪25,93B‬","‪−20,77B‬","‪−5,37B‬","‪942,34","‪2,39B‬","‪17,65B‬"]
["Changes in working capital",null,"‪−1,85B‬","‪1,16B‬","‪−3,82B‬","‪−17,15B‬","‪−3,90B‬","‪18,57B‬","‪−2,46B‬"]
["Change in accounts receivable",null,"‪−7,84B‬","‪3,68B‬","‪−7,97B‬","‪−12,48B‬","‪942,34","‪11,19B‬","‪−8,25B‬"]
["Change in taxes payable",null,"—","—","—","—","—","—","—"]
["Change in accounts payabl",null,"‪7,37B‬","‪2,08B‬","‪6,30B‬","‪11,02B‬","‪−6,60B‬","‪−841,16","‪9,55B"]
["Change in accrued expenses",null,"—","—","—","—","—","—","—"]
["Change in inventories",null,"‪−1,39B‬","‪−4,60B‬","‪−2,14B‬","‪−15,69B‬","‪1,76B‬","‪8,22B‬","‪−3,76B‬"]
["Change in other assets/liabilities",null,"—","—","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬"]
["Cash from investing activities",null,"‪−25,91B‬","‪−28,26B‬","‪16,48B‬","‪−35,52B‬","‪−54,53B‬","‪−55,39B‬","‪−64,47B‬"]
["Purchase/sale of business, net",null,"‪695,01","‪1,16B‬","‪267,98","‪1,11B‬","‪62,82","‪−64,70","‪217,06"]
["Purchase/sale of investments, net",null,"‪−8,57B‬","‪−7,85B‬","‪47,97B‬","‪2,68B‬","‪62,82","‪129,41","‪−14,47B‬"]
["Sale/maturity of investments",null,"‪0,00‬","‪0,00‬","‪91,92B‬","‪9,45B‬","‪439,76","‪323,52","‪30,61B‬"]
["Purchase of investments",null,"‪−8,57B‬","‪−7,85B‬","‪−43,95B‬","‪−6,77B‬","‪−376,94","‪−194,11","‪−45,08B‬"]
["Capital expenditures",null,"−19,54B‬","‪−21,58B‬","‪−31,76B‬","‪−39,31B‬","‪−54,66B‬","‪−55,45B‬","‪−50,21B‬"]
["Other investing cash flow items, total",null,"‪1,51B‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00"]
["Cash from financing activities",null,"‪−10,00B‬","‪−42,48B‬","‪−105,52B‬","‪−28,00B‬","‪−52,02B‬","‪−36,75B‬","‪−40,37B‬"]
["Issuance/retirement of stock, net",null,"‪−308,89","‪245,20","‪67,00","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00"]
["Issuance/retirement of debt, net",null,"‪−5,17B‬","‪−36,41B‬","‪−93,53B‬","‪−3,91B‬","‪314,11","‪22,13B‬","‪4,99B"]
["Total cash dividends paid",null,"−4,52B‬","‪−6,31B‬","‪−12,06B‬","‪−24,09B‬","‪−52,33B‬","‪−58,69B‬","‪−45,08B‬"]
["Other financing cash flow items, total",null,"‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬","‪0,00‬"]
["Free cash flow",null,"‪64,36B‬","‪49,98B‬","‪41,06B‬","‪65,59B‬","‪58,62B‬","‪40,95B‬","83,91B"]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
["Valuation ratios",null,0,0,0,0,0,0,0,"Current"]
["Price to earnings ratio",null,"—","‪8,10‬","‪5,02‬","‪6,77‬","‪5,82‬","‪8,52‬","‪14,30‬","‪5.45‬"]
["Price to sales ratio",null,"‪0,39‬","‪0,59‬","‪0,99‬","‪1,06‬","‪0,93‬","‪0,96‬","‪1,35‬","‪1.18‬"]
["Price to cash flow ratio",null,"‪2,41‬","‪2,46‬","‪4,59‬","‪5,86‬","‪4,02‬","‪4,17‬","‪6,90‬","‪5.30‬"]
["Price to book ratio",null,"‪0,51‬","‪0,87‬","‪1,30‬","‪1,48‬","‪1,39‬","‪1,37‬","‪1,84‬","‪1.85‬"]
["Enterprise value",null,"‪244,30B‬","‪293,36B‬","‪384,03B‬","‪467,99B‬","‪467,83B‬","‪455,04B‬","‪618,07B‬","‪783.70B‬"]
["Enterprise value to EBITDA ratio",null,"‪4,02‬","‪2,90‬","‪3,50‬","‪3,98‬","‪3,11‬","‪3,92‬","‪5,73‬","‪3.57‬"]
[null,null,0,0,0,0,0,0,0]
["Profitability ratios",null,0,0,0,0,0,0,0]
["Return on assets %",null,"‪−0,38‬","‪5,55‬","‪17,43‬","‪16,01‬","‪17,12‬","‪10,76‬","‪8,10‬","‪25.25‬"]
["Return on equity %",null,"‪−0,72‬","‪10,81‬","‪28,19‬","‪22,96‬","‪24,99‬","‪16,00‬","‪12,83‬","‪37.30"]
["Return on invested capital %",null,"‪−0,52‬","‪7,93‬","‪24,46‬","‪22,06‬","‪23,86‬","‪14,89‬","‪11,56‬","‪33.78‬"]
["Gross margin %",null,"‪21,64‬","‪29,27‬","‪31,79‬","‪29,94‬","‪32,37‬","‪25,96‬","‪27,29‬","‪45.75‬"]
["Operating margin %",null,"‪10,40‬","‪18,09‬","‪20,50‬","‪19,55‬","‪22,27‬","‪16,10‬","‪16,76‬","‪39.66‬"]
["EBITDA margin %",null,"‪19,78‬","‪28,26‬","‪29,09‬","‪26,69‬","‪29,16‬","‪23,70‬","‪23,30‬","‪43.41‬"]
[null,null,0,0,0,0,0,0,0]
["Liquidity ratios",null,0,0,0,0,0,0,0]
["Quick ratio",null,"‪0,78‬","‪0,84‬","‪0,91‬","‪0,95‬","‪1,09‬","‪1,13‬","‪0,94‬","‪1.28"]
["Current ratio",null,"‪1,41‬","‪1,45‬","‪1,91‬","‪1,84‬","‪1,95‬","‪1,91‬","‪1,56‬","‪2.12‬"]
["Inventory turnover",null,"‪4,41‬","‪4,07‬","‪3,98‬","‪4,20‬","‪4,20‬","‪4,53‬","‪4,23‬","‪4.63‬"]
["Asset turnover",null,"‪0,70‬","‪0,77‬","‪0,88‬","‪1,02‬","‪1,07‬","‪0,96‬","‪0,86‬","‪1.16‬"]
[null,null,0,0,0,0,0,0,0]
["Solvency ratios",null,0,0,0,0,0,0,0]
["Debt to assets ratio",null,"‪0,33‬","‪0,30‬","‪0,08‬","‪0,07‬","‪0,07‬","‪0,10‬","‪0,13‬","‪0.12‬"]
["Debt to equity ratio",null,"‪0,66‬","‪0,56‬","‪0,11‬","‪0,10‬","‪0,11‬","‪0,16‬","‪0,21‬","‪0.17‬"]
["Long term debt to total assets ratio",null,"‪0,22‬","‪0,15‬","‪0,03‬","‪0,03‬","‪0,04‬","‪0,06‬","‪0,07‬","‪0.06‬"]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}