Altice USA, Inc. Financial Ratios — ATUS Stock

Profitability (USD)

	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y
As of date	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024

Return on Common Equity (%)	- -	- -	3.4	42.35	- -	- -	- -	- -	- -
Return on Assets (%)	- -	4.19	0.06	0.41	1.29	2.97	0.58	0.16	-0.32
Return on Capital (%)	- -	- -	- -	5.34	5.71	7.53	2.83	4.4	- -
Return on Invested Capital (%)	- -	- -	- -	5.31	6.37	7.62	3.17	4.99	- -
Gross Margin (%)	68.24	67.38	66.83	66.19	66.24	66.48	66.77	67.2	67.65
EBITDA Margin (%)	39.94	42.16	42.89	42.62	43.35	42.9	38.42	38.55	37.37
Operating Margin (%)	11.69	10.67	17.99	19.43	22.3	25.19	20.03	20.75	19.03
Incremental Operating Margin (%)	- -	8.82	280.18	90.53	231.4	170.96	137.4	3.95	75.32
Pretax Margin (%)	-18.13	-14.69	-0.19	1.92	5.89	12.94	5.36	1.28	-0.92
Profit Margin (%)	-13.83	16.04	0.2	1.42	4.41	9.81	2.02	0.58	-1.15
Net Income to Common Margin (%)	-13.83	16.04	0.2	1.42	4.41	9.81	2.02	0.58	-1.15
Effective Tax Rate (%)	- -	- -	- -	25.22	23.96	22.59	57.25	33.34	- -
Dvd Payout Ratio (%)	-43.99	61.44	6,709.62	- -	- -	- -	- -	- -	- -
Sustainable Growth Rate (%)	- -	- -	-224.91	42.35	- -	- -	- -	- -	- -

Credit (USD)

MCP API Chat

	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y
As of date	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024

Total Debt	24,030	21,941	22,813	24,689	26,980	26,784	26,848	25,340	25,313
ST Debt	1,602	593	159	171	1,246	917	2,075	359	185
LT Debt	22,428	21,348	22,654	24,519	25,734	25,867	24,773	24,980	25,127
Total Debt/EBITDA	10	5.59	5.56	5.94	6.29	6.19	7.24	7.12	7.56
Net Debt/EBITDA	9.78	5.5	5.48	5.7	6.13	6.04	7.02	6.89	7.37
Total Debt/EBIT	34.17	22.09	13.26	13.02	12.23	10.54	13.89	13.22	14.86
Net Debt/EBIT	33.44	21.73	13.07	12.49	11.91	10.28	13.47	12.81	14.47
EBITDA to Interest Expense	1.65	2.45	2.64	2.71	3.17	3.42	2.78	2.17	1.9
EBITDA-CapEx/Interest Expense	1.65	2.45	2.64	2.7	3.17	3.42	2.78	2.17	1.9
EBIT to Interest Expense	0.48	0.62	1.11	1.23	1.63	2.01	1.45	1.17	0.97
Interest Expense	1,457	1,603	1,556	1,537	1,353	1,267	1,332	1,639	1,763
Common Equity/Total Assets	-2.68	2.44	0.77	1.16	-2.94	-2.54	-1.93	-1.87	-2.21
Long-Term Debt/Equity (%)	1,104.92	387.81	615.56	1,075.73	- -	- -	- -	- -	- -
Long-Term Debt/Capital (%)	97.28	93.67	98.15	97.7	99.22	99.92	94.66	101.01	102.04
Long-Term Debt/Total Assets (%)	61.49	61.32	67.39	71.89	77.1	77.88	73.59	78.25	79.26
Total Debt/Equity (%)	1,183.84	398.59	619.87	1,083.22	-2,242.45	-3,075.43	-5,327.91	-5,833	-5,540.9
Total Debt/Capital (%)	104.23	96.27	98.84	98.38	104.02	103.46	102.59	102.46	102.79
Total Debt/Total Assets (%)	65.88	63.03	67.87	72.39	80.83	80.64	79.75	79.38	79.85
Net Debt to Equity	1,158.47	392.2	611.06	1,039.65	-2,184.64	-3,000.6	-5,167.1	-5,649.98	-5,397.08
Net Debt/Capital (%)	104.2	96.12	98.71	97.14	102.44	101.71	100.67	100.47	101.18
EBITDA	2,404	3,924	4,103	4,160	4,290	4,329	3,707	3,561	3,346
EBITDA-CapEx	2,403	3,922	4,103	4,156	4,290	4,329	3,707	3,561	3,346
Operating Income (Loss)	703	993	1,721	1,897	2,206	2,542	1,933	1,917	1,704

Liquidity (USD)

MCP API Chat

	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y
As of date	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024

Cash Ratio	0.33	0.13	0.15	0.35	0.09	0.07	0.08	0.13	0.11
Current Ratio	0.46	0.36	0.45	0.7	0.32	0.29	0.64	0.36	0.32
Quick Ratio	0.43	0.29	0.38	0.59	0.23	0.22	0.17	0.29	0.26
CFO/Avg Current Liab	- -	0.65	1.1	1.28	1.17	0.98	0.7	0.58	0.69
Common Equity/Total Assets	-2.68	2.44	0.77	1.16	-2.94	-2.54	-1.93	-1.87	-2.21
Long-Term Debt/Equity (%)	1,104.92	387.81	615.56	1,075.73	- -	- -	- -	- -	- -
Long-Term Debt/Capital (%)	97.28	93.67	98.15	97.7	99.22	99.92	94.66	101.01	102.04
Long-Term Debt/Total Assets (%)	61.49	61.32	67.39	71.89	77.1	77.88	73.59	78.25	79.26
Total Debt/Equity (%)	1,183.84	398.59	619.87	1,083.22	-2,242.45	-3,075.43	-5,327.91	-5,833	-5,540.9
Total Debt/Capital (%)	104.23	96.27	98.84	98.38	104.02	103.46	102.59	102.46	102.79
Total Debt/Total Assets (%)	65.88	63.03	67.87	72.39	80.83	80.64	79.75	79.38	79.85
CFO/Total Liabilities	3.44	6.89	8.38	8.02	8.62	8.37	6.93	5.64	4.92
CFO/CapEx	11,174.1	1,182.34	4,295.06	627.41	- -	- -	- -	- -	- -
Altman's Z-Score	0.5	1.63	1.94	2.02	1.8	1.69	1.3	1.4	1.26

Working Capital (USD)

MCP API Chat

	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y
As of date	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024

Accounts Receivable Turnover	- -	25.84	23.36	21.56	22	23.76	24.96	25.53	25.96
Days Sales Outstanding	- -	14.13	15.63	16.93	16.59	15.36	14.62	14.3	14.06
Inventory Turnover	- -	- -	- -	- -	- -	- -	- -	- -	- -
Days Inventory Outstanding	- -	- -	- -	- -	- -	- -	- -	- -	- -
Accounts Payable Turnover	- -	4.05	3.84	3.98	4.19	3.72	2.87	2.82	3.04
Accounts Payable Turnover Days	- -	90.23	95.05	91.63	87.15	98.13	127.35	129.55	120.24
Cash Conversion Cycle	- -	-76.1	-79.42	-74.7	-70.56	-82.77	-112.72	-115.25	-106.18
Inventory to Cash Days	- -	14.13	15.63	16.93	16.59	15.36	14.62	14.3	14.06
Inventories	- -	- -	- -	- -	- -	- -	- -	- -	- -
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

MCP API Chat

	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y
As of date	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024

Market Capitalization	- -	13,281	12,061	18,055	22,005	7,415	2,085	1,478	1,108
- Cash & Cash Equivalents	487	330	299	702	278	196	305	302	257
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	2	9	9	-62	-51	-29	-12	12
+ Total Debt	24,030	21,941	22,813	24,689	26,980	26,784	26,848	25,340	25,313
Enterprise Value	22,802	34,894	34,584	42,052	48,644	33,953	28,599	26,503	26,177
Total Capital	23,054	22,791	23,081	25,096	25,937	25,889	26,170	24,731	24,626
Total Debt/Capital (%)	104.23	96.27	98.84	98.38	104.02	103.46	102.59	102.46	102.79
Total Debt / EV	1.05	0.63	0.66	0.59	0.55	0.79	0.94	0.96	0.97
EV/Sales	3.79	3.75	3.62	4.31	4.92	3.36	2.96	2.87	2.92
EV/EBITDA	9.49	8.89	8.43	10.11	11.34	7.84	7.72	7.44	7.82
EV/EBIT	32.43	35.13	20.1	22.17	22.05	13.36	14.8	13.83	15.36
EV/Cash Flow to Firm	9.94	131.16	47.13	11.36	12.13	8.85	9.74	9.08	8.03
EV/Free Cash Flow to Firm	9.94	130.33	47.09	11.34	12.13	8.85	9.74	9.08	8.03
Diluted Market Cap	- -	13,281	12,061	18,114	22,104	7,480	2,085	1,479	1,108
Diluted Enterprise Value	23,544	34,894	34,584	42,111	48,744	34,017	28,599	26,504	26,177
EV per Share	30.94	50.13	47.37	63.68	83.72	74.08	63.1	58.28	56.92
TTM Sales	6,017	9,307	9,567	9,761	9,895	10,091	9,648	9,237	8,954
TTM EBITDA	2,404	3,924	4,103	4,160	4,290	4,329	3,707	3,561	3,346
TTM Operating Income	703	993	1,721	1,897	2,206	2,542	1,933	1,917	1,704
TTM Cash Flow to Firm	2,294	266	734	3,703	4,009	3,835	2,936	2,919	3,258
TTM Free Cash Flow to Firm	2,294	268	734	3,707	4,009	3,835	2,936	2,919	3,258

Multiples (USD)

MCP API Chat

	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y
As of date	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024

Price/Free Cash Flow	- -	6.57	4.81	7.08	7.42	2.62	0.88	0.81	0.7
EV/EBIT	32.43	35.13	20.1	22.17	22.05	13.36	14.8	13.83	15.36
Enterprise Value	22,802	34,894	34,584	42,052	48,644	33,953	28,599	26,503	26,177
Low Price	- -	17.8	14.5	16.21	15.96	14.33	3.68	1.75	1.52
EV/Sales	3.79	3.75	3.62	4.31	4.92	3.36	2.96	2.87	2.92
EV/EBITDA	9.49	8.89	8.43	10.11	11.34	7.84	7.72	7.44	7.82
Price/Earnings	- -	8.89	640.42	129.95	50.45	7.49	10.72	27.78	- -
Price/Earnings Average	- -	11.18	685.39	117.71	35.96	13.37	22.28	27.62	-10.23
Price/Earnings High	- -	16.45	974.98	151.06	51.02	17.67	40.13	47.61	-14.7
Price/Earnings Low	- -	8.3	561.92	77.05	21.25	6.63	8.57	14.96	-6.79
Price/Book Value	- -	15.66	46.58	45.46	-22.44	-8.78	-3.21	-2.48	-1.58
Price/Book Value Average	- -	19.68	49.85	41.17	-15.99	-15.68	-6.67	-2.46	-1.51
Price/Book Value High	- -	28.97	70.92	52.84	-22.69	-20.73	-12.02	-4.25	-2.16
Price/Book Value Low	- -	14.61	40.87	26.95	-9.45	-7.78	-2.57	-1.33	-1
Price/Tangible Book Value	- -	-0.64	-0.56	-0.81	-0.87	-0.3	-0.09	-0.06	-0.05
Price/Tangible Book Value Average	- -	-0.81	-0.6	-0.73	-0.62	-0.54	-0.18	-0.06	-0.05
Price/Tangible Book Value High	- -	-1.19	-0.85	-0.94	-0.88	-0.71	-0.33	-0.11	-0.07
Price/Tangible Book Value Low	- -	-0.6	-0.49	-0.48	-0.37	-0.27	-0.07	-0.03	-0.03
Price/Sales	- -	1.43	1.26	1.85	2.22	0.73	0.22	0.16	0.12
Price/Sales Average	- -	1.79	1.35	1.68	1.59	1.31	0.45	0.16	0.12
Price/Sales High	- -	2.64	1.92	2.15	2.25	1.73	0.81	0.27	0.17
Price/Sales Low	- -	1.33	1.11	1.1	0.94	0.65	0.17	0.09	0.08
Price/Cash Flow	- -	6.58	4.81	7.07	7.38	2.6	0.88	0.81	0.7
Price/Cash Flow Average	- -	8.27	5.15	6.4	5.26	4.64	1.83	0.8	0.67
Price/Cash Flow High	- -	12.17	7.32	8.22	7.47	6.13	3.3	1.39	0.96
Price/Cash Flow Low	- -	6.14	4.22	4.19	3.11	2.3	0.7	0.44	0.44
Price/Free Cash Flow Average	- -	8.26	5.14	6.41	5.29	4.68	1.83	0.81	0.67
Price/Free Cash Flow High	- -	12.16	7.32	8.23	7.5	6.19	3.3	1.39	0.96
Price/Free Cash Flow Low	- -	6.13	4.22	4.2	3.12	2.32	0.7	0.44	0.44
EV/Sales Average	3.91	4.12	3.7	4.13	4.28	3.94	3.2	2.87	2.92
EV/Sales High	3.91	4.96	4.27	4.61	4.94	4.36	3.56	2.98	2.97
EV/Sales Low	3.91	3.65	3.46	3.56	3.63	3.28	2.92	2.8	2.88
EV/EBITDA Average	9.8	9.76	8.63	9.7	9.87	9.19	8.32	7.44	7.81
EV/EBITDA High	9.8	11.77	9.96	10.81	11.4	10.17	9.26	7.74	7.94
EV/EBITDA Low	9.8	8.67	8.07	8.34	8.37	7.65	7.6	7.25	7.7
EV/EBIT Average	33.48	38.56	20.59	21.27	19.18	15.65	15.96	13.82	15.33
EV/EBIT High	33.48	46.48	23.76	23.72	22.16	17.33	17.76	14.38	15.6
EV/EBIT Low	33.48	34.23	19.24	18.29	16.28	13.02	14.58	13.47	15.12
Last Price	- -	19.08	16.52	27.34	37.87	16.18	4.6	3.25	2.41
High Price	- -	35.29	25.15	31.78	38.3	38.19	17.23	5.57	3.29
Enterprise Value Average	23,544	38,305	35,431	40,351	42,326	39,775	30,848	26,495	26,121
Enterprise Value High	23,544	46,177	40,885	44,984	48,894	44,040	34,321	27,558	26,582
Enterprise Value Low	23,544	34,003	33,106	34,702	35,910	33,105	28,182	25,821	25,768

Shares Outstanding	737	737	709	633	476	455	456	456	463
Diluted Weighted Avg Shares	737	696	730	663	584	462	453	455	460
Basic Weighted Avg Shares	737	696	730	660	581	458	453	455	460
Revenue per Share	8.16	13.37	13.1	14.78	17.03	22.02	21.29	20.31	19.47
EBITDA per Share	3.26	5.64	5.62	6.3	7.38	9.45	8.18	7.83	7.28
Operating Income per Share	0.95	1.43	2.36	2.87	3.8	5.55	4.26	4.22	3.7
Basic EPS, GAAP	-1.13	2.15	0.03	0.21	0.75	2.16	0.43	0.12	-0.22
Basic EPS from Cont Ops	-1.13	2.15	0.03	0.21	0.76	2.21	0.49	0.17	-0.17
Diluted EPS, GAAP	-1.13	2.15	0.03	0.21	0.75	2.14	0.43	0.12	-0.22
Diluted EPS from Cont Ops	-1.13	2.15	0.03	0.21	0.76	2.19	0.49	0.17	-0.17
Dividend per Share	0.5	1.32	2.05	- -	- -	- -	- -	- -	- -
Cash Flow per Share	1.61	2.9	3.44	3.87	5.13	6.23	5.22	4.02	3.44
Free Cash Flow per Basic Share	1.61	2.9	3.43	3.86	5.13	6.23	5.22	4.02	3.44
Cash & Equivalents per Share	1.67	0.47	0.41	1.06	0.48	0.43	0.67	0.66	0.56
Book Value per Share	-1.32	1.22	0.35	0.6	-1.69	-1.84	-1.43	-1.31	-1.52
Tangible Book Value per Share	-34.37	-29.6	-29.51	-33.87	-43.39	-53.45	-52.05	-50.48	-49.29

Altice USA, Inc.

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)