SUPPLEMENT

Q4 2021 — Supplemental Quarterly Pro Forma Financial Information (ex. U.S. Video and Vrio)

Q4 2021PDF · 6 pages71 KB
Quarterly Pro Forma Financial Information
Supplemental Unaudited Quarterly Pro Forma Financial Information1
Dollars in millions
Unaudited
Operating Revenues 3/31/20 6/30/20 9/30/20 12/31/20 2020 3/31/21 6/30/21 9/30/21 12/31/21 2021
Reported AT&T Operating Revenues $ 42,779 $ 40,950 $ 42,340 $ 45,691 $ 171,760 $ 43,939 $44,045 $ 39,922 $ 40,958 $ 168,864
Less: Video (A1) (7,407) (7,021) (7,014) (7,168) (28,610) (6,725) (6,639) (2,149) — (15,513)
Add: WarnerMedia sales to Video (A2) 755 666 551 487 2,459 524 508 167 — 1,199
Add: WarnerMedia sales of DIRECTV advertising inventory (A3) 413 294 408 603 1,718 388 410 111 — 909
Add: Other eliminations 64 55 65 84 268 61 58 17 — 136
Less: Vrio (A4) (887) (752) (753) (762) (3,154) (743) (749) (756) (359) (2,607)
Add: WarnerMedia sales to Vrio (A5) 41 39 53 60 193 64 65 63 30 222
Pro Forma Operating Revenues $ 35,758 $ 34,231 $ 35,650 $ 38,995 $ 144,634 $ 37,508 $ 37,698 $ 37,375 $ 40,629 $ 153,210
Reported Revenue Growth Rate Y/Y 2.7 % 7.6 % -5.7 % -10.4 % -1.7 %
Pro Forma Revenue Growth Rate Y/Y 4.9 % 10.1 % 4.8 % 4.2 % 5.9 %

-- 1 of 6 --

Operations and Support Expenses 3/31/20 6/30/20 9/30/20 12/31/20 2020 3/31/21 6/30/21 9/30/21 12/31/21 2021
Reported AT&T Operations and Support Expenses $ 28,071 $ 30,133 $ 29,178 $ 49,457 $ 136,839 $ 30,469 $ 35,015 $ 27,194 $ 29,977 $ 122,655
Adjustments (B1) 476 (3,295) (151) (16,655) (19,625) (94) (4,555) (291) (320) (5,260)
Adjusted Operations and Support Expenses 28,547 26,838 29,027 32,802 117,214 30,375 30,460 26,903 29,657 117,395
Less: Video (A1) (6,020) (5,809) (5,887) (6,458) (24,174) (5,660) (5,275) (1,731) — (12,666)
Add: WarnerMedia sales to Video (A2) 755 666 551 487 2,459 524 508 167 — 1,199
Add: WarnerMedia sales of DIRECTV advertising inventory (A3) 39 38 38 38 153 39 38 12 — 89
Add: WarnerMedia/DIRECTV 70% revenue share (A3) 289 206 286 422 1,203 271 287 78 — 636
Add: Other eliminations 64 55 65 84 268 61 58 17 — 136
Less: Vrio (A4) (783) (661) (675) (681) (2,800) (661) (660) (660) (321) (2,302)
Add: WarnerMedia sales to Vrio (A5) 41 39 53 60 193 64 65 63 30 222
Pro Forma Adjusted Operations and Support Expenses $ 22,932 $ 21,372 $ 23,458 $ 26,754 $ 94,516 $ 25,013 $ 25,481 $ 24,849 $ 29,366 $ 104,709
Reported Operations and Support Expense Growth Rate Y/Y 8.5% 16.2 % -6.8 % -39.4 % -10.4 %
Adjusted Operations and Support Expense Growth Rate Y/Y 6.4 % 13.5% -7.3 % -9.6 % 0.2 %
Pro Forma Adjusted Operations and Support Expense Growth Rate Y/Y 9.1 % 19.2 % 5.9 % 9.8 % 10.8 %

-- 2 of 6 --

Depreciation and Amortization Expense 3/31/20 6/30/20 9/30/20 12/31/20 2020 3/31/21 6/30/21 9/30/21 12/31/21 2021
Reported AT&T Depreciation and Amortization Expense $ 7,222 $ 7,285 $ 7,030 $ 6,979 $ 28,516 $ 5,809 $ 5,761 $ 5,619 $ 5,673 $ 22,862
Adjustments (B1) (2,056) (2,145) (1,921) (1,904) (8,026) (1,131) (1,069) (1,012) (1,021) (4,233)
Adjusted Depreciation and Amortization Expense 5,166 5,140 5,109 5,075 20,490 4,678 4,692 4,607 4,652 18,629
Less: Video Depreciation (A1) (591) (593) (557) (521) (2,262) (164) (148) (44) — (356)
Less: Vrio Depreciation (A4) (147) (127) (126) (120) (520) (117) (114) — — (231)
Add: Other consolidation — 1 — 1 2 — — — — —
Pro Forma Adjusted Depreciation and Amortization Expense $ 4,428 $ 4,421 $ 4,426 $ 4,435 $ 17,710 $ 4,397 $ 4,430 $ 4,563 $ 4,652 $ 18,042
Reported Depreciation and Amortization Expense Growth Rate Y/Y -19.6 % -20.9 % -20.1 % -18.7 % -19.8 %
Adjusted Depreciation and Amortization Expense Growth Rate Y/Y -9.4 % -8.7 % -9.8 % -8.3 % -9.1 %
Pro Forma Adjusted Depreciation and Amortization Expense Growth Rate Y/Y -0.7 % 0.2 % 3.1 % 4.9 % 1.9 %

-- 3 of 6 --

Operating Income 3/31/20 6/30/20 9/30/20 12/31/20 2020 3/31/21 6/30/21 9/30/21 12/31/21 2021
Reported AT&T Operating Income (Loss) $ 7,486 $ 3,532 $ 6,132 $ (10,745) $ 6,405 $ 7,661 $ 3,269 $ 7,109 $ 5,308 $ 23,347
Adjustments (B1) 1,580 5,440 2,072 18,559 27,651 1,225 5,624 1,303 1,341 9,493
Adjusted Operating Income 9,066 8,972 8,204 7,814 34,056 8,886 8,893 8,412 6,649 32,840
Less: Video (A1) (796) (619) (570) (189) (2,174) (901) (1,216) (374) — (2,491)
Add: WarnerMedia sales to Video (A2) — — — — — — — — — —
Add: WarnerMedia sales of DIRECTV advertising inventory (A3) 374 255 370 564 1,563 349 372 99 — 820
Add: WarnerMedia/DIRECTV 70% revenue share (A3) (289) (206) (286) (422) (1,203) (271) (287) (78) — (636)
Add: Other eliminations — — — — — — — — — —
Less: Vrio (A4) 43 36 48 39 166 35 25 (96) (38) (74)
Add: WarnerMedia sales to Vrio (A5) — — — — — — — — — —
Pro Forma Adjusted Operating Income $ 8,398 $ 8,438 $ 7,766 $ 7,806 $ 32,408 $ 8,098 $ 7,787 $ 7,963 $ 6,611 $ 30,459
Reported Operating Income Growth Rate Y/Y 2.3 % -7.4 % 15.9 % 149.4 % 264.5%
Adjusted Operating Income Growth Rate Y/Y -2.0 % -0.9 % 2.5% -14.9 % -3.6 %
Pro Forma Adjusted Operating Income Growth Rate Y/Y -3.6 % -7.7 % 2.5% -15.3 % -6.0 %
Reported Operating Income Margin 17.5% 8.6 % 14.5% -23.5% 3.7 % 17.4 % 7.4 % 17.8 % 13.0 % 13.8 %
Adjusted Operating Income Margin 21.2 % 21.9 % 19.4 % 17.1 % 19.8 % 20.2 % 20.2 % 21.1 % 16.2 % 19.4 %
Pro Forma Adjusted Operating Income Margin 23.5% 24.7 % 21.8 % 20.0 % 22.4 % 21.6 % 20.7 % 21.3 % 16.3 % 19.9 %

-- 4 of 6 --

EBITDA 3/31/20 6/30/20 9/30/20 12/31/20 2020 3/31/21 6/30/21 9/30/21 12/31/21 2021
Reported AT&T Net Income (Loss) $ 4,963 $ 1,563 $ 3,168 $ (13,515) $ (3,821) $ 7,942 $ 1,874 $ 6,273 $ 5,390 $ 21,479
Additions:
Income Tax Expense (Benefit) 1,302 935 766 (2,038) 965 2,122 751 1,539 1,056 5,468
Interest Expense 2,018 2,041 1,972 1,894 7,925 1,870 1,684 1,667 1,663 6,884
Equity in Net Income (Loss) of Affiliates 6 10 (5) (106) (95) (52) (41) (91) (447) (631)
Other (Income) Expense - net (803) (1,017) 231 3,020 1,431 (4,221) (999) (2,279) (2,354) (9,853)
Depreciation and amortization 7,222 7,285 7,030 6,979 28,516 5,809 5,761 5,619 5,673 22,862
EBITDA 14,708 10,817 13,162 (3,766) 34,921 13,470 9,030 12,728 10,981 46,209
Adjustments (B1) (476) 3,295 151 16,655 19,625 94 4,555 291 320 5,260
Adjusted EBITDA 14,232 14,112 13,313 12,889 54,546 13,564 13,585 13,019 11,301 51,469
Less: Video (A1) (1,387) (1,212) (1,127) (710) (4,436) (1,065) (1,364) (418) — (2,847)
Add: WarnerMedia sales to Video (A2) — — — — — — — — — —
Add: WarnerMedia sales of DIRECTV advertising inventory (A3) 374 256 370 565 1,565 349 372 99 — 820
Add: WarnerMedia/DIRECTV 70% revenue share (A3) (289) (206) (286) (422) (1,203) (271) (287) (78) — (636)
Add: Other eliminations — — — — — — — — — —
Less: Vrio (A4) (104) (91) (78) (81) (354) (82) (89) (96) (38) (305)
Add: WarnerMedia sales to Vrio (A5) — — — — — — — — — —
Pro Forma Adjusted EBITDA $ 12,826 $ 12,859 $ 12,192 $ 12,241 $ 50,118 $ 12,495 $ 12,217 $ 12,526 $ 11,263 $ 48,501
Adjusted EBITDA Growth Rate Y/Y -4.7 % -3.7 % -2.2 % -12.3 % -5.6 %
Pro Forma Adjusted EBITDA Growth Rate Y/Y -2.6 % -5.0 % 2.7 % -8.0 % -3.2 %
Adjusted EBITDA Margin 33.3 % 34.5% 31.4 % 28.2 % 31.8 % 30.9 % 30.8 % 32.6 % 27.6 % 30.5%
Pro Forma Adjusted EBITDA Margin 35.9 % 37.6 % 34.2 % 31.4 % 34.7 % 33.3 % 32.4 % 33.5% 27.7 % 31.7 %
1 After the transaction, AT&T expects to retain incurred operations and support costs in the range of ~$500M per quarter and depreciation costs for network
infrastructure that provides both U-verse video and broadband services of ~$150M per quarter, of which approximately 50% will be received from DIRECTV
through transition service agreements and commercial arrangements. These pro formas do not include the impacts of accounting for the NFL SUNDAY
TICKET, per the Contribution Agreement.

-- 5 of 6 --

NOTES
(A) Notes to Pro Forma Adjustments
(A1) Video business results as reported in AT&T's consolidated financial results; quarters ended 2021 exclude retained depreciation on assets supporting U-verse
products
(A2) Intercompany transactions between WarnerMedia and Video that are external following the close of the transaction
(A3) DIRECTV's advertising inventory sold by WarnerMedia (Xandr business) pursuant to commercial agreement, with WarnerMedia recording all the advertising
revenues and an expense for DIRECTV's 70% revenue share
(A4) Vrio business results as reported in AT&T's consolidated financial results
(A5) Intercompany transactions between WarnerMedia and Vrio that are external following the close of the transaction
(B1) Non-GAAP Adjustments2: 3/31/20 6/30/20 9/30/20 12/31/20 2020 3/31/21 6/30/21 9/30/21 12/31/21 2021
Merger Costs $ 182 $ 211 $ 38 $ 37 $ 468 $ 37 $ — $ 130 $ 132 $ 299
Employee separation costs and benefit-related (gain) loss 119 765 40 253 1,177 57 — — — 57
Impairments 123 2,319 73 16,365 18,880 — 4,555 161 188 4,904
Gain (loss) on spectrum transaction (900) — — — (900) — — — — —
Adjustments to Operations and Support Expenses/ EBITDA (476) 3,295 151 16,655 19,625 94 4,555 291 320 5,260
Amortization of intangibles 2,056 2,145 1,921 1,890 8,012 1,131 1,069 1,012 1,021 4,233
Impairments — — — 14 14 — — — — —
Adjustments to Operating Income $ 1,580 $ 5,440 $ 2,072 $ 18,559 $ 27,651 $ 1,225 $ 5,624 $ 1,303 $ 1,341 $ 9,493
2 As reported in AT&T's Forms 8-K filed April 22, 2020, July 23, 2020, October 22, 2020, January 27, 2021, April 22, 2021, July 22, 2021, October 21, 2021 and January 26, 2022.

-- 6 of 6 --