|T.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAP
1Main
2Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q42219971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022
3WarnerMedia41843020585352593044235632
4LatAm728382695716696357165354
5Corporate1932213122071264
6Video321242861015513
7Eliminations-5253-5180-3629
8Service2624724731109969109965114730
9Equipment50795312
10Revenue313263004343126462414953151374459084282140498407334376463055118322123443122513124280126723127434128752132447146801163786160546170756181193171760168864
11CoE540154400.027100423177665908
12Other COGS80326761
13Total COGS134331220100000000000000
14Gross Profit1789317842
15SG&A70947202
16Operating Income107991064000000000000000
17Other Income781242
18Pretax Income108771188200000000000000
19Taxes4471277
20Net Income104301060500000000000000
21EPS1.38955502264854781.3868183601412318
22Shares7506764761705958592459385950582153855221564661896183680673487183
23
24Revenue y/y-0.040956394049671220.072230209154570350.071148980342120580.037209020613353294-0.10639623155681865-0.06724318201620627-0.054249083393661970.0058027556916391280.074411410895342870.44079608810894810.8764887796368250.043280201484085845-0.007533841530098950.0144229591961668730.019657225619568620.00561066262635834260.0103426087229467890.028698583322977590.10837542564195490.11570084672447734-0.019781910541804560.06359548042305630.06112230316943479-0.05206051006385459-0.01686073591057291
25
26Cash6387
27AR11384
28Inventories3935
29Prepaids14553
30Gross PP&E327903
31Depreciation-200858
32Net PP&E127045
33Goodwill98087
34Licenses123856
35Leases21782
36Other19434
37Assets426463
38
39Debt133751
40AP36642
41Billings3705
42Dividends2013
43DT56055
44Pension6152
45Leases18741
46ONCL29426
47Liabilities139978
48L+SE426463
49
50Model NI10605
51Reported NI16246
52D&A13426
53Bad Debts1323
54DT2947
55Investments412
56Pension-2529
57Actuarial pension-3838
58Impairments745
59WC-3268
60CFFO25464
61
62CapEx-15397
63Acquisitions-9959
64Dispositions49
65DirectTV2205
66Other91
67CFFI-23011
68
69Borrowings-37825
70Vendor Financing-4237
71Buybacks-847
72Dividends-7845
73Other-3649
74CFFF-54403
75
76CIC-51950