Stock Analysis on Net

AT&T Inc. (NYSE:T)

デュポンの分析: ROE、ROA、純利益率の内訳 
四半期データ

Microsoft Excel

ROEを2つのコンポーネントに分解

AT&T Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2026/03/31 19.54% = 5.09% × 3.84
2025/12/31 19.86% = 5.22% × 3.80
2025/09/30 20.09% = 5.26% × 3.82
2025/06/30 12.12% = 3.15% × 3.85
2025/03/31 11.43% = 2.98% × 3.83
2024/12/31 10.49% = 2.77% × 3.78
2024/09/30 8.85% = 2.30% × 3.85
2024/06/30 12.08% = 3.20% × 3.78
2024/03/31 13.03% = 3.41% × 3.82
2023/12/31 13.94% = 3.54% × 3.94
2023/09/30 -10.90% = -2.78% × 3.92
2023/06/30 -8.61% = -2.15% × 4.01
2023/03/31 -9.16% = -2.27% × 4.03
2022/12/31 -8.74% = -2.12% × 4.13
2022/09/30 16.37% = 4.70% × 3.48
2022/06/30 16.92% = 4.67% × 3.62
2022/03/31 10.26% = 3.00% × 3.41

レポートに基づく: 10-Q (報告日: 2026-03-31), 10-K (報告日: 2025-12-31), 10-Q (報告日: 2025-09-30), 10-Q (報告日: 2025-06-30), 10-Q (報告日: 2025-03-31), 10-K (報告日: 2024-12-31), 10-Q (報告日: 2024-09-30), 10-Q (報告日: 2024-06-30), 10-Q (報告日: 2024-03-31), 10-K (報告日: 2023-12-31), 10-Q (報告日: 2023-09-30), 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-31), 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31).


ROEを3つの要素に分解

AT&T Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2026/03/31 19.54% = 16.94% × 0.30 × 3.84
2025/12/31 19.86% = 17.47% × 0.30 × 3.80
2025/09/30 20.09% = 17.87% × 0.29 × 3.82
2025/06/30 12.12% = 10.29% × 0.31 × 3.85
2025/03/31 11.43% = 9.64% × 0.31 × 3.83
2024/12/31 10.49% = 8.95% × 0.31 × 3.78
2024/09/30 8.85% = 7.42% × 0.31 × 3.85
2024/06/30 12.08% = 10.41% × 0.31 × 3.78
2024/03/31 13.03% = 11.13% × 0.31 × 3.82
2023/12/31 13.94% = 11.76% × 0.30 × 3.94
2023/09/30 -10.90% = -9.29% × 0.30 × 3.92
2023/06/30 -8.61% = -7.22% × 0.30 × 4.01
2023/03/31 -9.16% = -7.52% × 0.30 × 4.03
2022/12/31 -8.74% = -7.06% × 0.30 × 4.13
2022/09/30 16.37% = 15.37% × 0.31 × 3.48
2022/06/30 16.92% = 14.21% × 0.33 × 3.62
2022/03/31 10.26% = 11.21% × 0.27 × 3.41

レポートに基づく: 10-Q (報告日: 2026-03-31), 10-K (報告日: 2025-12-31), 10-Q (報告日: 2025-09-30), 10-Q (報告日: 2025-06-30), 10-Q (報告日: 2025-03-31), 10-K (報告日: 2024-12-31), 10-Q (報告日: 2024-09-30), 10-Q (報告日: 2024-06-30), 10-Q (報告日: 2024-03-31), 10-K (報告日: 2023-12-31), 10-Q (報告日: 2023-09-30), 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-31), 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31).


ROEを5つの要素に分解

AT&T Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担率 × 利息負担率 × EBITマージン率 × 資産回転率 × 財務レバレッジ比率
2026/03/31 19.54% = 0.86 × 0.78 × 25.20% × 0.30 × 3.84
2025/12/31 19.86% = 0.86 × 0.79 × 25.77% × 0.30 × 3.80
2025/09/30 20.09% = 0.83 × 0.80 × 26.78% × 0.29 × 3.82
2025/06/30 12.12% = 0.73 × 0.72 × 19.46% × 0.31 × 3.85
2025/03/31 11.43% = 0.72 × 0.71 × 18.85% × 0.31 × 3.83
2024/12/31 10.49% = 0.71 × 0.69 × 18.11% × 0.31 × 3.78
2024/09/30 8.85% = 0.70 × 0.65 × 16.20% × 0.31 × 3.85
2024/06/30 12.08% = 0.77 × 0.71 × 19.07% × 0.31 × 3.78
2024/03/31 13.03% = 0.77 × 0.72 × 19.92% × 0.31 × 3.82
2023/12/31 13.94% = 0.77 × 0.74 × 20.69% × 0.30 × 3.94
2023/09/30 -10.90% = × × -0.80% × 0.30 × 3.92
2023/06/30 -8.61% = × -4.88 × 0.88% × 0.30 × 4.01
2023/03/31 -9.16% = × -7.39 × 0.61% × 0.30 × 4.03
2022/12/31 -8.74% = × -3.48 × 1.13% × 0.30 × 4.13
2022/09/30 16.37% = 0.80 × 0.80 × 23.90% × 0.31 × 3.48
2022/06/30 16.92% = 0.78 × 0.80 × 22.77% × 0.33 × 3.62
2022/03/31 10.26% = 0.78 × 0.77 × 18.60% × 0.27 × 3.41

レポートに基づく: 10-Q (報告日: 2026-03-31), 10-K (報告日: 2025-12-31), 10-Q (報告日: 2025-09-30), 10-Q (報告日: 2025-06-30), 10-Q (報告日: 2025-03-31), 10-K (報告日: 2024-12-31), 10-Q (報告日: 2024-09-30), 10-Q (報告日: 2024-06-30), 10-Q (報告日: 2024-03-31), 10-K (報告日: 2023-12-31), 10-Q (報告日: 2023-09-30), 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-31), 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31).


ROAを2つのコンポーネントに分解

AT&T Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2026/03/31 5.09% = 16.94% × 0.30
2025/12/31 5.22% = 17.47% × 0.30
2025/09/30 5.26% = 17.87% × 0.29
2025/06/30 3.15% = 10.29% × 0.31
2025/03/31 2.98% = 9.64% × 0.31
2024/12/31 2.77% = 8.95% × 0.31
2024/09/30 2.30% = 7.42% × 0.31
2024/06/30 3.20% = 10.41% × 0.31
2024/03/31 3.41% = 11.13% × 0.31
2023/12/31 3.54% = 11.76% × 0.30
2023/09/30 -2.78% = -9.29% × 0.30
2023/06/30 -2.15% = -7.22% × 0.30
2023/03/31 -2.27% = -7.52% × 0.30
2022/12/31 -2.12% = -7.06% × 0.30
2022/09/30 4.70% = 15.37% × 0.31
2022/06/30 4.67% = 14.21% × 0.33
2022/03/31 3.00% = 11.21% × 0.27

レポートに基づく: 10-Q (報告日: 2026-03-31), 10-K (報告日: 2025-12-31), 10-Q (報告日: 2025-09-30), 10-Q (報告日: 2025-06-30), 10-Q (報告日: 2025-03-31), 10-K (報告日: 2024-12-31), 10-Q (報告日: 2024-09-30), 10-Q (報告日: 2024-06-30), 10-Q (報告日: 2024-03-31), 10-K (報告日: 2023-12-31), 10-Q (報告日: 2023-09-30), 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-31), 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31).


ROAを4つの要素に分解

AT&T Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担率 × 利息負担率 × EBITマージン率 × 資産回転率
2026/03/31 5.09% = 0.86 × 0.78 × 25.20% × 0.30
2025/12/31 5.22% = 0.86 × 0.79 × 25.77% × 0.30
2025/09/30 5.26% = 0.83 × 0.80 × 26.78% × 0.29
2025/06/30 3.15% = 0.73 × 0.72 × 19.46% × 0.31
2025/03/31 2.98% = 0.72 × 0.71 × 18.85% × 0.31
2024/12/31 2.77% = 0.71 × 0.69 × 18.11% × 0.31
2024/09/30 2.30% = 0.70 × 0.65 × 16.20% × 0.31
2024/06/30 3.20% = 0.77 × 0.71 × 19.07% × 0.31
2024/03/31 3.41% = 0.77 × 0.72 × 19.92% × 0.31
2023/12/31 3.54% = 0.77 × 0.74 × 20.69% × 0.30
2023/09/30 -2.78% = × × -0.80% × 0.30
2023/06/30 -2.15% = × -4.88 × 0.88% × 0.30
2023/03/31 -2.27% = × -7.39 × 0.61% × 0.30
2022/12/31 -2.12% = × -3.48 × 1.13% × 0.30
2022/09/30 4.70% = 0.80 × 0.80 × 23.90% × 0.31
2022/06/30 4.67% = 0.78 × 0.80 × 22.77% × 0.33
2022/03/31 3.00% = 0.78 × 0.77 × 18.60% × 0.27

レポートに基づく: 10-Q (報告日: 2026-03-31), 10-K (報告日: 2025-12-31), 10-Q (報告日: 2025-09-30), 10-Q (報告日: 2025-06-30), 10-Q (報告日: 2025-03-31), 10-K (報告日: 2024-12-31), 10-Q (報告日: 2024-09-30), 10-Q (報告日: 2024-06-30), 10-Q (報告日: 2024-03-31), 10-K (報告日: 2023-12-31), 10-Q (報告日: 2023-09-30), 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-31), 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31).


当期純利益率の分解

AT&T Inc.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担率 × 利息負担率 × EBITマージン率
2026/03/31 16.94% = 0.86 × 0.78 × 25.20%
2025/12/31 17.47% = 0.86 × 0.79 × 25.77%
2025/09/30 17.87% = 0.83 × 0.80 × 26.78%
2025/06/30 10.29% = 0.73 × 0.72 × 19.46%
2025/03/31 9.64% = 0.72 × 0.71 × 18.85%
2024/12/31 8.95% = 0.71 × 0.69 × 18.11%
2024/09/30 7.42% = 0.70 × 0.65 × 16.20%
2024/06/30 10.41% = 0.77 × 0.71 × 19.07%
2024/03/31 11.13% = 0.77 × 0.72 × 19.92%
2023/12/31 11.76% = 0.77 × 0.74 × 20.69%
2023/09/30 -9.29% = × × -0.80%
2023/06/30 -7.22% = × -4.88 × 0.88%
2023/03/31 -7.52% = × -7.39 × 0.61%
2022/12/31 -7.06% = × -3.48 × 1.13%
2022/09/30 15.37% = 0.80 × 0.80 × 23.90%
2022/06/30 14.21% = 0.78 × 0.80 × 22.77%
2022/03/31 11.21% = 0.78 × 0.77 × 18.60%

レポートに基づく: 10-Q (報告日: 2026-03-31), 10-K (報告日: 2025-12-31), 10-Q (報告日: 2025-09-30), 10-Q (報告日: 2025-06-30), 10-Q (報告日: 2025-03-31), 10-K (報告日: 2024-12-31), 10-Q (報告日: 2024-09-30), 10-Q (報告日: 2024-06-30), 10-Q (報告日: 2024-03-31), 10-K (報告日: 2023-12-31), 10-Q (報告日: 2023-09-30), 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-31), 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31).