Balance Sheet Cellnex Telecom, S.A.

Equities

CLNX

ES0105066007

Wireless Telecommunications Services

Market Closed - BME Other stock markets 11:35:12 2024-12-02 am EST			After market 03:59:34 pm
33.90 ^EUR	-0.24%		33.96	+0.18%

Nov. 28	IBEX 35 rebounds as it digests the new interest rate and trade war scenario	RE
Nov. 27	IBEX 35 finds no reason to rally as it awaits U.S. prices	RE

aca73026.p3cSao7eKPAeH_hudm2arhWd-jYxQpysTRhTfBIRPtE.ljRfLNHvUsl4LJA4Oz_D33GssFQCEPKaGywbMyFaVICRMEpH35gdtit0lw

Published financial data: CELLNEX TELECOM, S.A.

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: December	2019	2020	2021	2022	2023
Revenues	1B	1.56B	2.44B	3.25B	3.8B
Total Revenues	1B	1.56B	2.44B	3.25B	3.8B
Cost of Goods Sold, Total	169M	211M	297M	359M	408M
Gross Profit	831M	1.35B	2.14B	2.89B	3.4B
Selling General & Admin Expenses, Total	11.1M	11.12M	10.06M	2.02M	3.13M
Depreciation & Amortization - (IS)	501M	974M	1.69B	2.32B	2.55B
Other Operating Expenses	166M	202M	304M	332M	429M
Other Operating Expenses, Total	678M	1.19B	2B	2.66B	2.98B
Operating Income	153M	164M	139M	234M	411M
Interest Expense, Total	-160M	-272M	-461M	-642M	-758M
Interest And Investment Income	606K	1.18M	4.34M	21.64M	67.23M
Net Interest Expenses	-159M	-271M	-456M	-621M	-691M
Income (Loss) On Equity Invest.	82K	52K	-3.22M	-4.24M	-2.64M
Currency Exchange Gains (Loss)	648K	-6.3M	-907K	881K	2.64M
Other Non Operating Income (Expenses)	-38.33M	-80.35M	-131M	-109M	-135M
EBT, Excl. Unusual Items	-43.21M	-194M	-452M	-499M	-414M
Restructuring Charges	-5.55M	-4.91M	-80.87M	-3.37M	-29.94M
Gain (Loss) On Sale Of Investments	-	-	-	-	14.94M
Gain (Loss) On Sale Of Assets	-	-	-	-	-
Asset Writedown	-135K	-205K	317K	-	-
Other Unusual Items	-5.12M	-316K	-1.73M	-418K	-7.33M
EBT, Incl. Unusual Items	-54.01M	-199M	-534M	-503M	-436M
Income Tax Expense	-35.51M	-48.72M	-159M	-190M	-121M
Earnings From Continuing Operations	-18.5M	-151M	-375M	-313M	-316M
Net Income to Company	-18.5M	-151M	-375M	-313M	-316M
Minority Interest	9.26M	17.64M	23.71M	15.88M	18.6M
Net Income - (IS)	-9.24M	-133M	-351M	-297M	-297M
Net Income to Common Incl Extra Items	-9.24M	-133M	-351M	-297M	-297M
Net Income to Common Excl. Extra Items	-9.24M	-133M	-351M	-297M	-297M
Per Share Items
Net EPS - Basic	-0.03	-0.35	-0.58	-0.44	-0.44
Basic EPS - Continuing Operations	-0.03	-0.35	-0.58	-0.44	-0.44
Basic Weighted Average Shares Outstanding	296M	385M	611M	673M	669M
Net EPS - Diluted	-0.03	-0.35	-0.58	-0.44	-0.44
Diluted EPS - Continuing Operations	-0.03	-0.35	-0.58	-0.44	-0.44
Diluted Weighted Average Shares Outstanding	296M	385M	611M	673M	669M
Normalized Basic EPS	-0.06	-0.27	-0.42	-0.44	-0.36
Normalized Diluted EPS	-0.06	-0.27	-0.42	-0.44	-0.36
Dividend Per Share	0.07	0.05	0.05	0.05	0.06
Payout Ratio	-287.94	-22	-	-	-13.56
American Depositary Receipts Ratio (ADR)	0.5	0.5	0.5	0.5	0.5
Supplemental Items
EBITDA	470M	803M	1.31B	2.04B	2.28B
EBITA	257M	502M	838M	1.33B	1.48B
EBIT	153M	164M	139M	234M	411M
EBITDAR	482M	815M	1.32B	2.04B	2.29B
Total Revenues (As Reported)	1.03B	1.6B	2.53B	3.5B	4.05B
Effective Tax Rate - (Ratio)	65.74	24.43	29.78	37.77	27.63
Total Current Taxes	14.56M	31.83M	121M	24.36M	135M
Total Deferred Taxes	-50.88M	-77.46M	-272M	-125M	-244M
Normalized Net Income	-17.75M	-104M	-259M	-296M	-240M
Interest on Long-Term Debt	136M	232M	400M	563M	566M
Non-Cash Pension Expense	857K	1.74M	-2.44M	2.45M	407K
Supplemental Operating Expense Items
Net Rental Expense, Total	11.1M	11.12M	10.06M	2.02M	3.13M
Imputed Operating Lease Interest Expense	2.85M	2.78M	2.5M	526K	893K
Imputed Operating Lease Depreciation	8.26M	8.34M	7.56M	1.5M	2.23M
Maintenance & Repair Expenses, Total	35.6M	50.78M	79.71M	91.97M	111M
Stock-Based Comp., COGS (Total)	-	-	-	-	-
Stock-Based Comp., Other (Total)	5.96M	8.46M	10.72M	16.65M	14.98M
Total Stock-Based Compensation	5.96M	8.46M	10.72M	16.65M	14.98M

Fiscal Period: December	2019	2020	2021	2022	2023
Assets
Cash And Equivalents	2.35B	4.65B	3.93B	1.04B	1.29B
Short Term Investments	-	-	-	-	-
Trading Asset Securities, Total	-	-	77K	-	7.28M
Total Cash And Short Term Investments	2.35B	4.65B	3.93B	1.04B	1.3B
Accounts Receivable, Total	254M	335M	807M	791M	799M
Other Receivables	111M	167M	346M	372M	356M
Notes Receivable	-	-	-	-	-
Total Receivables	365M	503M	1.15B	1.16B	1.16B
Inventory	2.15M	2.16M	2.76M	4.77M	6.26M
Prepaid Expenses	-	-	-	-	-
Other Current Assets, Total	2.02M	2.07M	3.15M	55.09M	1.28B
Total Current Assets	2.72B	5.16B	5.09B	2.26B	3.74B
Gross Property Plant And Equipment	5.16B	7.55B	12.6B	16.54B	17.98B
Accumulated Depreciation	-924M	-1.22B	-1.69B	-2.41B	-3.22B
Net Property Plant And Equipment	4.24B	6.33B	10.91B	14.13B	14.77B
Long-term Investments	2.83M	9.55M	33.38M	288M	237M
Goodwill	1.49B	2.68B	5.98B	6.72B	6.65B
Other Intangibles, Total	4.25B	9.37B	19.03B	20.12B	18.05B
Loans Receivable Long-Term	-	-	-	-	-
Deferred Tax Assets Long-Term	137M	465M	673M	636M	602M
Other Long-Term Assets, Total	165M	63.71M	77.24M	99.58M	316M
Total Assets	13B	24.07B	41.8B	44.26B	44.37B
Liabilities
Accounts Payable, Total	220M	307M	513M	561M	401M
Accrued Expenses, Total	22.98M	26.86M	70.63M	62.85M	90.7M
Current Portion of Long-Term Debt	48.43M	77.11M	720M	143M	906M
Current Portion of Leases	207M	284M	530M	584M	696M
Current Income Taxes Payable	43.74M	101M	277M	215M	138M
Unearned Revenue Current, Total	-	-	-	-	133M
Other Current Liabilities	119M	275M	613M	719M	1.17B
Total Current Liabilities	661M	1.07B	2.72B	2.28B	3.53B
Long-Term Debt	5.1B	9.33B	14.93B	17.77B	17.82B
Long-Term Leases	945M	1.48B	2.31B	2.5B	2.12B
Unearned Revenue Non Current	17.63M	104M	143M	121M	94.29M
Pension & Other Post Retirement Benefits	17.97M	17.19M	70.45M	51.73M	56.3M
Deferred Tax Liability Non Current	828M	1.79B	3.81B	4.44B	3.97B
Other Non Current Liabilities	384M	1.35B	1.98B	1.89B	1.63B
Total Liabilities	7.95B	15.14B	25.96B	29.07B	29.22B
Common Stock, Total	96.33M	122M	170M	177M	177M
Additional Paid In Capital	3.89B	7.77B	14.58B	15.52B	15.48B
Retained Earnings	134M	150M	-284M	-228M	-681M
Treasury Stock	-4.22M	-8.08M	-60.8M	-47.62M	-40.46M
Comprehensive Income and Other	48.57M	-14.84M	-198M	-1.2B	-1B
Total Common Equity	4.16B	8.02B	14.21B	14.22B	13.94B
Minority Interest	890M	915M	1.63B	967M	1.21B
Total Equity	5.05B	8.93B	15.84B	15.19B	15.15B
Total Liabilities And Equity	13B	24.07B	41.8B	44.26B	44.37B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	385M	487M	678M	705M	706M
ECS Total Common Shares Outstanding	385M	487M	678M	705M	706M
Book Value / Share	10.8	16.48	20.95	20.16	19.75
Tangible Book Value	-1.58B	-4.02B	-10.81B	-12.62B	-10.76B
Tangible Book Value Per Share	-4.1	-8.27	-15.93	-17.89	-15.26
Total Debt	6.3B	11.17B	18.48B	21B	21.55B
Net Debt	3.95B	6.51B	14.56B	19.96B	20.25B
Debt Equivalent of Unfunded Proj. Benefit Obligation	3.33M	3.33M	3.33M	895K	895K
Debt Equivalent Oper. Leases	88.82M	88.94M	80.46M	16.18M	25.02M
Minority Interest, Total (Incl. Fin. Div)	890M	915M	1.63B	967M	1.21B
Equity Method Investments, Total	2.83M	3.43M	3.26M	33.23M	42.32M
Account Code - Inventory Valuation	3	3	3	3	3
Land - (BS)	3.06B	4.16B	7.49B	10.36B	12.22B
Machinery, Total	701M	907M	1.11B	1.23B	1.35B
Full Time Employees	1.61K	2.01K	2.88K	2.96K	2.84K
Accumulated Allowance for Doubtful Accounts (Supple)	13.61M	19.42M	20.02M	24M	22.5M
Order Backlog	38.5B	-	-	-	-

Fiscal Period: December	2019	2020	2021	2022	2023
Net Income	-9.24M	-133M	-351M	-297M	-297M
Depreciation & Amortization - CF	391M	608M	958M	1.32B	1.47B
Amortization of Goodwill and Intangible Assets - (CF)	104M	338M	699M	1.1B	1.06B
Depreciation & Amortization, Total	494M	946M	1.66B	2.42B	2.54B
Amortization of Deferred Charges, Total - (CF)	6.37M	28.1M	30.33M	45.21M	100M
(Gain) Loss From Sale Of Asset	-	-	-	-146M	-86.58M
Asset Writedown & Restructuring Costs	135K	205K	-317K	-	-
(Income) Loss On Equity Investments - (CF)	-82K	-52K	3.22M	4.24M	2.64M
Provision and Write-off of Bad Debts	-	-	-	-	-
Other Operating Activities, Total	-71.97M	-39.04M	-198M	-182M	-209M
Change In Accounts Receivable	-61.33M	-63.93M	-253M	34.17M	3.15M
Change In Inventories	1.72M	-9K	-607K	-1.29M	-1.82M
Change in Other Net Operating Assets	59.52M	53.51M	254M	-49.68M	17.03M
Cash from Operations	420M	792M	1.14B	1.83B	2.07B
Capital Expenditure	-894M	-760M	-1.52B	-2.57B	-2.19B
Cash Acquisitions	-3.06B	-5.11B	-12.36B	-3.28B	646M
Investment in Marketable and Equity Securities, Total	-	-	-	-101M	-44.2M
Other Investing Activities, Total	-3.24M	-23.88M	-23.72M	-	-
Cash from Investing	-3.96B	-5.9B	-13.9B	-5.95B	-1.59B
Long-Term Debt Issued, Total	2.68B	5B	6.26B	3.03B	3.91B
Total Debt Issued	2.68B	5B	6.26B	3.03B	3.91B
Long-Term Debt Repaid, Total	-915M	-1.55B	-953M	-1.49B	-3.87B
Total Debt Repaid	-915M	-1.55B	-953M	-1.49B	-3.87B
Issuance of Common Stock	3.68B	4.02B	6.77B	-	-
Repurchase of Common Stock	-	-6.51M	-	-323M	-200M
Common Dividends Paid	-26.62M	-29.28M	-	-	-40.29M
Common & Preferred Stock Dividends Paid	-26.62M	-29.28M	-	-	-40.29M
Special Dividend Paid	-	-	-	-	-
Other Financing Activities, Total	-699K	-	-	-	-1.94M
Cash from Financing	5.42B	7.43B	12.08B	1.22B	-206M
Foreign Exchange Rate Adjustments	10.06M	-28.68M	-39.37M	8.42M	-15.64M
Net Change in Cash	1.9B	2.3B	-725M	-2.89B	254M
Supplemental Items
Cash Interest Paid	148M	260M	442M	626M	752M
Cash Income Tax Paid (Refund)	25.26M	38.58M	166M	95.93M	181M
Levered Free Cash Flow	-434M	323M	82.58M	-302M	-602M
Unlevered Free Cash Flow	-335M	493M	371M	99.59M	-129M
Change In Net Working Capital	42.91M	-168M	-107M	-38.8M	846M
Net Debt Issued / Repaid	1.77B	3.45B	5.31B	1.55B	36.35M

Fiscal Period: December	2019	2020	2021	2022	2023
Profitability
Return on Assets	1.06	0.55	0.26	0.34	0.58
Return on Total Capital	1.23	0.65	0.32	0.41	0.71
Return On Equity %	-0.65	-2.16	-3.03	-2.02	-2.08
Return on Common Equity	-0.4	-2.19	-3.16	-2.09	-2.11
Margin Analysis
Gross Profit Margin %	83.09	86.47	87.8	88.96	89.28
SG&A Margin	1.11	0.71	0.41	0.06	0.08
EBITDA Margin %	47.05	51.43	53.52	62.72	60.07
EBITA Margin %	25.71	32.1	34.39	41.09	38.8
EBIT Margin %	15.33	10.48	5.71	7.21	10.81
Income From Continuing Operations Margin %	-1.85	-9.65	-15.38	-9.64	-8.3
Net Income Margin %	-0.92	-8.52	-14.41	-9.15	-7.81
Net Avail. For Common Margin %	-0.92	-8.52	-14.41	-9.15	-7.81
Normalized Net Income Margin	-1.77	-6.63	-10.61	-9.12	-6.31
Levered Free Cash Flow Margin	-43.42	20.65	3.39	-9.29	-15.83
Unlevered Free Cash Flow Margin	-33.45	31.55	15.2	3.07	-3.38
Asset Turnover
Asset Turnover	0.11	0.08	0.07	0.08	0.09
Fixed Assets Turnover	0.3	0.3	0.28	0.25	0.26
Receivables Turnover (Average Receivables)	5.37	5.3	4.26	4.04	4.75
Inventory Turnover (Average Inventory)	56.24	98.17	120.85	95.17	73.98
Short Term Liquidity
Current Ratio	4.12	4.82	1.87	0.99	1.06
Quick Ratio	4.11	4.81	1.86	0.96	0.7
Operating Cash Flow to Current Liabilities	0.63	0.74	0.42	0.8	0.59
Days Sales Outstanding (Average Receivables)	67.96	69.08	85.69	90.4	76.88
Days Outstanding Inventory (Average Inventory)	6.49	3.73	3.02	3.84	4.93
Average Days Payable Outstanding	405.66	455.6	506.97	539.72	428.25
Cash Conversion Cycle (Average Days)	-331.21	-382.79	-418.26	-445.48	-346.44
Long Term Solvency
Total Debt/Equity	124.69	125	116.67	138.28	142.25
Total Debt / Total Capital	55.49	55.55	53.85	58.03	58.72
LT Debt/Equity	119.62	120.95	108.78	133.49	131.66
Long-Term Debt / Total Capital	53.24	53.76	50.2	56.02	54.35
Total Liabilities / Total Assets	61.15	62.89	62.1	65.68	65.86
EBIT / Interest Expense	0.96	0.6	0.3	0.36	0.54
EBITDA / Interest Expense	4.06	4.07	3.9	4.13	3.89
(EBITDA - Capex) / Interest Expense	-1.55	1.29	0.6	0.14	1
Total Debt / EBITDA	9.72	10.06	10.29	7.91	7.3
Net Debt / EBITDA	6.09	5.87	8.1	7.52	6.86
Total Debt / (EBITDA - Capex)	-25.55	31.9	67.2	242.17	28.49
Net Debt / (EBITDA - Capex)