Stock Analysis on Net

Amazon.com Inc. (NASDAQ:AMZN)

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

Microsoft Excel

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

Amazon.com Inc.、 ROE 分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2023/06/30 7.75% = 2.74% × 2.83
2023/03/31 2.78% = 0.92% × 3.01
2022/12/31 -1.86% = -0.59% × 3.17
2022/09/30 8.24% = 2.64% × 3.12
2022/06/30 8.83% = 2.77% × 3.19
2022/03/31 15.98% = 5.21% × 3.07
2021/12/31 24.13% = 7.93% × 3.04
2021/09/30 21.78% = 6.87% × 3.17
2021/06/30 25.64% = 8.17% × 3.14
2021/03/31 26.04% = 8.33% × 3.13
2020/12/31 22.84% = 6.64% × 3.44
2020/09/30 20.99% = 6.16% × 3.41
2020/06/30 17.88% = 5.10% × 3.50
2020/03/31 16.18% = 4.77% × 3.39
2019/12/31 18.67% = 5.14% × 3.63
2019/09/30 20.08% = 5.70% × 3.52
2019/06/30 22.80% = 6.32% × 3.61
2019/03/31 24.80% = 6.74% × 3.68
2018/12/31 23.13% = 6.19% × 3.73
2018/09/30 = × 3.67
2018/06/30 = × 3.83
2018/03/31 = × 4.02

レポートに基づく: 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), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31).

2023年第2 四半期に株主資本利益率(ROE)が増加した主な理由は、総資産利益率(ROA)で測定した収益性の向上です。


ROEを3つの要素に分解

Amazon.com Inc.、 ROE 分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2023/06/30 7.75% = 2.43% × 1.13 × 2.83
2023/03/31 2.78% = 0.82% × 1.13 × 3.01
2022/12/31 -1.86% = -0.53% × 1.11 × 3.17
2022/09/30 8.24% = 2.25% × 1.17 × 3.12
2022/06/30 8.83% = 2.39% × 1.16 × 3.19
2022/03/31 15.98% = 4.48% × 1.16 × 3.07
2021/12/31 24.13% = 7.10% × 1.12 × 3.04
2021/09/30 21.78% = 5.73% × 1.20 × 3.17
2021/06/30 25.64% = 6.64% × 1.23 × 3.14
2021/03/31 26.04% = 6.42% × 1.30 × 3.13
2020/12/31 22.84% = 5.53% × 1.20 × 3.44
2020/09/30 20.99% = 4.99% × 1.23 × 3.41
2020/06/30 17.88% = 4.10% × 1.25 × 3.50
2020/03/31 16.18% = 3.56% × 1.34 × 3.39
2019/12/31 18.67% = 4.13% × 1.25 × 3.63
2019/09/30 20.08% = 4.27% × 1.33 × 3.52
2019/06/30 22.80% = 4.80% × 1.32 × 3.61
2019/03/31 24.80% = 4.97% × 1.36 × 3.68
2018/12/31 23.13% = 4.33% × 1.43 × 3.73
2018/09/30 = × × 3.67
2018/06/30 = × × 3.83
2018/03/31 = × × 4.02

レポートに基づく: 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), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31).

2023年第2 四半期に株主資本利益率(ROE)が増加した主な理由は、純利益率で測定した収益性の向上です。


ROEを5つの要素に分解

Amazon.com Inc.、 ROE 分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2023/06/30 7.75% = 0.96 × 0.82 × 3.09% × 1.13 × 2.83
2023/03/31 2.78% = 1.25 × 0.56 × 1.17% × 1.13 × 3.01
2022/12/31 -1.86% = × × -0.69% × 1.11 × 3.17
2022/09/30 8.24% = 1.14 × 0.82 × 2.41% × 1.17 × 3.12
2022/06/30 8.83% = 1.03 × 0.85 × 2.75% × 1.16 × 3.19
2022/03/31 15.98% = 0.95 × 0.92 × 5.13% × 1.16 × 3.07
2021/12/31 24.13% = 0.87 × 0.95 × 8.51% × 1.12 × 3.04
2021/09/30 21.78% = 0.85 × 0.95 × 7.15% × 1.20 × 3.17
2021/06/30 25.64% = 0.88 × 0.95 × 7.96% × 1.23 × 3.14
2021/03/31 26.04% = 0.86 × 0.95 × 7.83% × 1.30 × 3.13
2020/12/31 22.84% = 0.88 × 0.94 × 6.69% × 1.20 × 3.44
2020/09/30 20.99% = 0.85 × 0.92 × 6.37% × 1.23 × 3.41
2020/06/30 17.88% = 0.81 × 0.91 × 5.55% × 1.25 × 3.50
2020/03/31 16.18% = 0.82 × 0.89 × 4.89% × 1.34 × 3.39
2019/12/31 18.67% = 0.83 × 0.90 × 5.55% × 1.25 × 3.63
2019/09/30 20.08% = 0.86 × 0.90 × 5.57% × 1.33 × 3.52
2019/06/30 22.80% = 0.86 × 0.90 × 6.16% × 1.32 × 3.61
2019/03/31 24.80% = 0.87 × 0.90 × 6.29% × 1.36 × 3.68
2018/12/31 23.13% = 0.89 × 0.89 × 5.45% × 1.43 × 3.73
2018/09/30 = × × × × 3.67
2018/06/30 = × × × × 3.83
2018/03/31 = × × × × 4.02

レポートに基づく: 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), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31).

2023年第2 四半期に株主資本利益率(ROE)が増加した主な理由は、EBITマージン比率で測定した営業収益性の向上です。


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

Amazon.com Inc.、 ROA 分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2023/06/30 2.74% = 2.43% × 1.13
2023/03/31 0.92% = 0.82% × 1.13
2022/12/31 -0.59% = -0.53% × 1.11
2022/09/30 2.64% = 2.25% × 1.17
2022/06/30 2.77% = 2.39% × 1.16
2022/03/31 5.21% = 4.48% × 1.16
2021/12/31 7.93% = 7.10% × 1.12
2021/09/30 6.87% = 5.73% × 1.20
2021/06/30 8.17% = 6.64% × 1.23
2021/03/31 8.33% = 6.42% × 1.30
2020/12/31 6.64% = 5.53% × 1.20
2020/09/30 6.16% = 4.99% × 1.23
2020/06/30 5.10% = 4.10% × 1.25
2020/03/31 4.77% = 3.56% × 1.34
2019/12/31 5.14% = 4.13% × 1.25
2019/09/30 5.70% = 4.27% × 1.33
2019/06/30 6.32% = 4.80% × 1.32
2019/03/31 6.74% = 4.97% × 1.36
2018/12/31 6.19% = 4.33% × 1.43
2018/09/30 = ×
2018/06/30 = ×
2018/03/31 = ×

レポートに基づく: 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), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31).

2023年第2 四半期に総資産利益率(ROA)が上昇した主な理由は、純利益率で測定した収益性の向上です。


ROAを4つの成分に分解

Amazon.com Inc.、 ROA 分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2023/06/30 2.74% = 0.96 × 0.82 × 3.09% × 1.13
2023/03/31 0.92% = 1.25 × 0.56 × 1.17% × 1.13
2022/12/31 -0.59% = × × -0.69% × 1.11
2022/09/30 2.64% = 1.14 × 0.82 × 2.41% × 1.17
2022/06/30 2.77% = 1.03 × 0.85 × 2.75% × 1.16
2022/03/31 5.21% = 0.95 × 0.92 × 5.13% × 1.16
2021/12/31 7.93% = 0.87 × 0.95 × 8.51% × 1.12
2021/09/30 6.87% = 0.85 × 0.95 × 7.15% × 1.20
2021/06/30 8.17% = 0.88 × 0.95 × 7.96% × 1.23
2021/03/31 8.33% = 0.86 × 0.95 × 7.83% × 1.30
2020/12/31 6.64% = 0.88 × 0.94 × 6.69% × 1.20
2020/09/30 6.16% = 0.85 × 0.92 × 6.37% × 1.23
2020/06/30 5.10% = 0.81 × 0.91 × 5.55% × 1.25
2020/03/31 4.77% = 0.82 × 0.89 × 4.89% × 1.34
2019/12/31 5.14% = 0.83 × 0.90 × 5.55% × 1.25
2019/09/30 5.70% = 0.86 × 0.90 × 5.57% × 1.33
2019/06/30 6.32% = 0.86 × 0.90 × 6.16% × 1.32
2019/03/31 6.74% = 0.87 × 0.90 × 6.29% × 1.36
2018/12/31 6.19% = 0.89 × 0.89 × 5.45% × 1.43
2018/09/30 = × × ×
2018/06/30 = × × ×
2018/03/31 = × × ×

レポートに基づく: 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), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31).

2023年第2 四半期に比べて総資産利益率(ROA)が上昇した主な理由は、EBITマージン比率で測定した営業利益率の向上です。


純利益率の分解

Amazon.com Inc.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2023/06/30 2.43% = 0.96 × 0.82 × 3.09%
2023/03/31 0.82% = 1.25 × 0.56 × 1.17%
2022/12/31 -0.53% = × × -0.69%
2022/09/30 2.25% = 1.14 × 0.82 × 2.41%
2022/06/30 2.39% = 1.03 × 0.85 × 2.75%
2022/03/31 4.48% = 0.95 × 0.92 × 5.13%
2021/12/31 7.10% = 0.87 × 0.95 × 8.51%
2021/09/30 5.73% = 0.85 × 0.95 × 7.15%
2021/06/30 6.64% = 0.88 × 0.95 × 7.96%
2021/03/31 6.42% = 0.86 × 0.95 × 7.83%
2020/12/31 5.53% = 0.88 × 0.94 × 6.69%
2020/09/30 4.99% = 0.85 × 0.92 × 6.37%
2020/06/30 4.10% = 0.81 × 0.91 × 5.55%
2020/03/31 3.56% = 0.82 × 0.89 × 4.89%
2019/12/31 4.13% = 0.83 × 0.90 × 5.55%
2019/09/30 4.27% = 0.86 × 0.90 × 5.57%
2019/06/30 4.80% = 0.86 × 0.90 × 6.16%
2019/03/31 4.97% = 0.87 × 0.90 × 6.29%
2018/12/31 4.33% = 0.89 × 0.89 × 5.45%
2018/09/30 = × ×
2018/06/30 = × ×
2018/03/31 = × ×

レポートに基づく: 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), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31).

2023年第2 四半期に比べて純利益率が上昇した主な理由は、EBITマージン比率で測定した営業利益率の向上です。