CHTR.xlsx

	B	E	F	G	H	I	J	K	L	M
1
2
3										metrics are YTD ; financials are interpolated
4
5		2017	2018	2019	2020	2021	2022	2023	2024	2025

6
7	Footprint		51.2	52.1				55.3	56.8	57.9
8
9	Residential customer relationships					29.9	30	29.9	29.3	28.9
10
11	Monthly rev per residential							119.9	121	122.6
12
13	Resi internet		23.6	24.9	27	28.1	28.4	28.5	28	27.8
14	Growth			6%	8%	4%	1%	0%	-2%	-1%
15
16	Resi video		16.1	15.6	15.6	15.2	14.5	13.5	12.3	12
17	Growth			-3%	0%	-3%	-5%	-7%	-9%	-2%
18
19	resi mobile lines					3.4	5.1	7.5	9.6	11
20	Growth						50%	47%	28%	15%
21
22	resi voice		10.1	9.4	9.2	8.6	7.7	6.7	5.6	5
23
24
25
26
27	Total revenue	41.6	43.6	45.8	48.1	51.7	54	54.6	55.1	55
28
29	Operating costs	26.5	27.9	29.2	29.9	31.5	32.9	33.4	33.2	33
30	D&A	10.6	10.3	9.9	9.7	9.3	8.9	8.7	8.7	8.7
31
32	EBIT	4.5	5.4	6.7	8.5	10.9	12.2	12.5	13.2	13
33
34	Interest expense	3.1	3.5	3.8	3.8	4	4.6	5.2	5.2	5
35
36	Taxes			0.4	0.6	1.1	1.6	1.6	1.6	1.3
37
38	Net income	1.4	1.9	2.5	4.1	5.8	6	5.7	6.4	6.7
39
40	NI to non controlling	0.2	0.3	0.3	0.5	0.7	0.8	0.7	0.8	0.8
41
42	NI to charter shareholders	1.2	1.6	2.2	3.6	5.1	5.2	5	5.6	5.9
43
44	Cap ex	8.7	9.1	7.2	7.4	7.6	9.4	11.1	11.3	11.5
45
46	FCF	3.1	2.8	4.9	5.9	6.8	4.7	2.6	3	3.1
47
48	Shares out	297	236	224	209	193	164	152	145	136
49	avg share price	$341	$313	$393	$556	$682	$464	$382	$326	$200
50	market cap ($B)	101	74	88	116	132	76	58	47	27
51
52	buybacks	12	4	7	11	15	10	3	1	4.4
53
54
55	debt repayment (net) / issuance (-ve)	-9	-3	-7	-4	-9	-7	0	3	-1
56
57	debt		70	76	82	89	96	96	92	95
58
59	EV	101	144	164	198	221	172	154	139	122
60
61	FCF yield on EV	3.1%	1.9%	3.0%	3.0%	3.1%	2.7%	1.7%	2.2%	2.5%
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100