Stock Analysis on Net

AT&T Inc. (NYSE:T)

Analysis of Goodwill and Intangible Assets

Microsoft Excel

Goodwill and Intangible Asset Disclosure

AT&T Inc., balance sheet: goodwill and intangible assets

US$ in millions

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Goodwill 63,432 67,854 67,895 133,223 135,259
Wireless licenses 2,656 3,057 2,748 2,643 2,558
Orbital slots 5,825
Distribution network 18,399 18,414
Released television and film content 10,939 10,940
Customer lists and relationships 275 305 338 539 3,640
Trademarks, trade names and other 37 284 324 29,761 30,880
Amortized intangible assets, gross carrying amount 2,968 3,646 3,410 62,281 72,257
Accumulated amortization (994) (1,119) (974) (19,523) (16,910)
Amortized intangible assets, net 1,974 2,527 2,436 42,758 55,347
Wireless licenses 125,075 124,734 121,769 111,494 85,728
Trade names 5,241 5,241 5,241 5,241 5,241
Indefinite-lived intangible assets not subject to amortization 130,316 129,975 127,010 116,735 90,969
Other intangible assets 132,290 132,502 129,446 159,493 146,316
Goodwill and other intangible assets 195,722 200,356 197,341 292,716 281,575

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

Item Description The company
Goodwill Amount after accumulated impairment loss of an asset representing future economic benefits arising from other assets acquired in a business combination that are not individually identified and separately recognized. AT&T Inc. goodwill decreased from 2022 to 2023 and from 2023 to 2024.
Other intangible assets Sum of the carrying amounts of all intangible assets, excluding goodwill, as of the balance sheet date, net of accumulated amortization and impairment charges. AT&T Inc. other intangible assets increased from 2022 to 2023 but then slightly decreased from 2023 to 2024.
Goodwill and other intangible assets Sum of the carrying amounts of all intangible assets, including goodwill, as of the balance sheet date, net of accumulated amortization and impairment charges. AT&T Inc. goodwill and other intangible assets increased from 2022 to 2023 but then decreased significantly from 2023 to 2024.

Adjustments to Financial Statements: Removal of Goodwill

AT&T Inc., adjustments to financial statements

US$ in millions

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Adjustment to Total Assets
Total assets (as reported) 394,795 407,060 402,853 551,622 525,761
Less: Goodwill 63,432 67,854 67,895 133,223 135,259
Total assets (adjusted) 331,363 339,206 334,958 418,399 390,502
Adjustment to Stockholders’ Equity Attributable To AT&T
Stockholders’ equity attributable to AT&T (as reported) 104,372 103,297 97,500 166,332 161,673
Less: Goodwill 63,432 67,854 67,895 133,223 135,259
Stockholders’ equity attributable to AT&T (adjusted) 40,940 35,443 29,605 33,109 26,414

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


AT&T Inc., Financial Data: Reported vs. Adjusted


Adjusted Financial Ratios: Removal of Goodwill (Summary)

AT&T Inc., adjusted financial ratios

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Total Asset Turnover
Reported total asset turnover 0.31 0.30 0.30 0.31 0.33
Adjusted total asset turnover 0.37 0.36 0.36 0.40 0.44
Financial Leverage
Reported financial leverage 3.78 3.94 4.13 3.32 3.25
Adjusted financial leverage 8.09 9.57 11.31 12.64 14.78
Return on Equity (ROE)
Reported ROE 10.49% 13.94% -8.74% 12.07% -3.20%
Adjusted ROE 26.74% 40.63% -28.79% 60.65% -19.60%
Return on Assets (ROA)
Reported ROA 2.77% 3.54% -2.12% 3.64% -0.98%
Adjusted ROA 3.30% 4.25% -2.54% 4.80% -1.33%

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

Financial ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. AT&T Inc. adjusted total asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
AT&T Inc. adjusted financial leverage ratio decreased from 2022 to 2023 and from 2023 to 2024.
Adjusted ROE A profitability ratio calculated as net income divided by adjusted shareholders’ equity. AT&T Inc. adjusted ROE improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. AT&T Inc. adjusted ROA improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.

AT&T Inc., Financial Ratios: Reported vs. Adjusted


Adjusted Total Asset Turnover

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
As Reported
Selected Financial Data (US$ in millions)
Operating revenues 122,336 122,428 120,741 168,864 171,760
Total assets 394,795 407,060 402,853 551,622 525,761
Activity Ratio
Total asset turnover1 0.31 0.30 0.30 0.31 0.33
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Operating revenues 122,336 122,428 120,741 168,864 171,760
Adjusted total assets 331,363 339,206 334,958 418,399 390,502
Activity Ratio
Adjusted total asset turnover2 0.37 0.36 0.36 0.40 0.44

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

2024 Calculations

1 Total asset turnover = Operating revenues ÷ Total assets
= 122,336 ÷ 394,795 = 0.31

2 Adjusted total asset turnover = Operating revenues ÷ Adjusted total assets
= 122,336 ÷ 331,363 = 0.37

Activity ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. AT&T Inc. adjusted total asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Adjusted Financial Leverage

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
As Reported
Selected Financial Data (US$ in millions)
Total assets 394,795 407,060 402,853 551,622 525,761
Stockholders’ equity attributable to AT&T 104,372 103,297 97,500 166,332 161,673
Solvency Ratio
Financial leverage1 3.78 3.94 4.13 3.32 3.25
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Adjusted total assets 331,363 339,206 334,958 418,399 390,502
Adjusted stockholders’ equity attributable to AT&T 40,940 35,443 29,605 33,109 26,414
Solvency Ratio
Adjusted financial leverage2 8.09 9.57 11.31 12.64 14.78

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

2024 Calculations

1 Financial leverage = Total assets ÷ Stockholders’ equity attributable to AT&T
= 394,795 ÷ 104,372 = 3.78

2 Adjusted financial leverage = Adjusted total assets ÷ Adjusted stockholders’ equity attributable to AT&T
= 331,363 ÷ 40,940 = 8.09

Solvency ratio Description The company
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
AT&T Inc. adjusted financial leverage ratio decreased from 2022 to 2023 and from 2023 to 2024.

Adjusted Return on Equity (ROE)

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
As Reported
Selected Financial Data (US$ in millions)
Net income (loss) attributable to AT&T 10,948 14,400 (8,524) 20,081 (5,176)
Stockholders’ equity attributable to AT&T 104,372 103,297 97,500 166,332 161,673
Profitability Ratio
ROE1 10.49% 13.94% -8.74% 12.07% -3.20%
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Net income (loss) attributable to AT&T 10,948 14,400 (8,524) 20,081 (5,176)
Adjusted stockholders’ equity attributable to AT&T 40,940 35,443 29,605 33,109 26,414
Profitability Ratio
Adjusted ROE2 26.74% 40.63% -28.79% 60.65% -19.60%

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

2024 Calculations

1 ROE = 100 × Net income (loss) attributable to AT&T ÷ Stockholders’ equity attributable to AT&T
= 100 × 10,948 ÷ 104,372 = 10.49%

2 Adjusted ROE = 100 × Net income (loss) attributable to AT&T ÷ Adjusted stockholders’ equity attributable to AT&T
= 100 × 10,948 ÷ 40,940 = 26.74%

Profitability ratio Description The company
Adjusted ROE A profitability ratio calculated as net income divided by adjusted shareholders’ equity. AT&T Inc. adjusted ROE improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.

Adjusted Return on Assets (ROA)

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
As Reported
Selected Financial Data (US$ in millions)
Net income (loss) attributable to AT&T 10,948 14,400 (8,524) 20,081 (5,176)
Total assets 394,795 407,060 402,853 551,622 525,761
Profitability Ratio
ROA1 2.77% 3.54% -2.12% 3.64% -0.98%
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Net income (loss) attributable to AT&T 10,948 14,400 (8,524) 20,081 (5,176)
Adjusted total assets 331,363 339,206 334,958 418,399 390,502
Profitability Ratio
Adjusted ROA2 3.30% 4.25% -2.54% 4.80% -1.33%

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

2024 Calculations

1 ROA = 100 × Net income (loss) attributable to AT&T ÷ Total assets
= 100 × 10,948 ÷ 394,795 = 2.77%

2 Adjusted ROA = 100 × Net income (loss) attributable to AT&T ÷ Adjusted total assets
= 100 × 10,948 ÷ 331,363 = 3.30%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. AT&T Inc. adjusted ROA improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.