Stock Analysis on Net
Stock Analysis on Net

O’Reilly Automotive Inc. (NASDAQ:ORLY)

この会社は アーカイブに移動しました! 財務データは2022年11月8日以降更新されていません。

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

Microsoft Excel

ROE分解では、純利益を株主資本で割ったものを構成比率の積として表します。

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

O’Reilly Automotive Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2022/09/30 — = 17.67% × —
2022/06/30 — = 17.70% × —
2022/03/31 — = 18.24% × —
2021/12/31 — = 18.47% × —
2021/09/30 — = 17.29% × —
2021/06/30 922.05% = 16.80% × 54.89
2021/03/31 — = 16.48% × —
2020/12/31 1,249.34% = 15.11% × 82.68
2020/09/30 237.48% = 13.47% × 17.63
2020/06/30 262.83% = 13.20% × 19.91
2020/03/31 1,258.98% = 12.34% × 102.06
2019/12/31 350.09% = 12.98% × 26.97
2019/09/30 822.10% = 13.17% × 62.40
2019/06/30 927.10% = 13.15% × 70.51
2019/03/31 360.06% = 13.33% × 27.02
2018/12/31 374.50% = 16.60% × 22.57
2018/09/30 266.15% = 16.80% × 15.84
2018/06/30 323.13% = 16.02% × 20.17
2018/03/31 276.95% = 15.31% × 18.09
2017/12/31 173.62% = 14.97% × 11.59
2017/09/30 — = — × 12.18
2017/06/30 — = — × 8.45
2017/03/31 — = — × 5.06

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

ROEを3つの要素に分解

O’Reilly Automotive Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2022/09/30 — = 15.39% × 1.15 × —
2022/06/30 — = 15.55% × 1.14 × —
2022/03/31 — = 15.85% × 1.15 × —
2021/12/31 — = 16.24% × 1.14 × —
2021/09/30 — = 15.85% × 1.09 × —
2021/06/30 922.05% = 15.94% × 1.05 × 54.89
2021/03/31 — = 15.99% × 1.03 × —
2020/12/31 1,249.34% = 15.10% × 1.00 × 82.68
2020/09/30 237.48% = 14.96% × 0.90 × 17.63
2020/06/30 262.83% = 14.45% × 0.91 × 19.91
2020/03/31 1,258.98% = 13.41% × 0.92 × 102.06
2019/12/31 350.09% = 13.70% × 0.95 × 26.97
2019/09/30 822.10% = 13.69% × 0.96 × 62.40
2019/06/30 927.10% = 13.69% × 0.96 × 70.51
2019/03/31 360.06% = 13.87% × 0.96 × 27.02
2018/12/31 374.50% = 13.89% × 1.19 × 22.57
2018/09/30 266.15% = 14.09% × 1.19 × 15.84
2018/06/30 323.13% = 13.42% × 1.19 × 20.17
2018/03/31 276.95% = 12.89% × 1.19 × 18.09
2017/12/31 173.62% = 12.63% × 1.19 × 11.59
2017/09/30 — = — × — × 12.18
2017/06/30 — = — × — × 8.45
2017/03/31 — = — × — × 5.06

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

ROEを5つの要素に分解

O’Reilly Automotive Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2022/09/30 — = 0.77 × 0.95 × 20.96% × 1.15 × —
2022/06/30 — = 0.78 × 0.95 × 21.09% × 1.14 × —
2022/03/31 — = 0.78 × 0.95 × 21.44% × 1.15 × —
2021/12/31 — = 0.78 × 0.95 × 21.96% × 1.14 × —
2021/09/30 — = 0.77 × 0.95 × 21.66% × 1.09 × —
2021/06/30 922.05% = 0.77 × 0.94 × 21.91% × 1.05 × 54.89
2021/03/31 — = 0.77 × 0.94 × 22.11% × 1.03 × —
2020/12/31 1,249.34% = 0.77 × 0.93 × 20.92% × 1.00 × 82.68
2020/09/30 237.48% = 0.77 × 0.93 × 20.73% × 0.90 × 17.63
2020/06/30 262.83% = 0.78 × 0.93 × 20.00% × 0.91 × 19.91
2020/03/31 1,258.98% = 0.78 × 0.92 × 18.61% × 0.92 × 102.06
2019/12/31 350.09% = 0.78 × 0.93 × 19.02% × 0.95 × 26.97
2019/09/30 822.10% = 0.77 × 0.93 × 19.14% × 0.96 × 62.40
2019/06/30 927.10% = 0.78 × 0.93 × 18.98% × 0.96 × 70.51
2019/03/31 360.06% = 0.78 × 0.93 × 19.05% × 0.96 × 27.02
2018/12/31 374.50% = 0.78 × 0.93 × 19.05% × 1.19 × 22.57
2018/09/30 266.15% = 0.79 × 0.93 × 19.07% × 1.19 × 15.84
2018/06/30 323.13% = 0.75 × 0.94 × 19.11% × 1.19 × 20.17
2018/03/31 276.95% = 0.71 × 0.94 × 19.20% × 1.19 × 18.09
2017/12/31 173.62% = 0.69 × 0.95 × 19.26% × 1.19 × 11.59
2017/09/30 — = — × — × — × — × 12.18
2017/06/30 — = — × — × — × — × 8.45
2017/03/31 — = — × — × — × — × 5.06

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

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

O’Reilly Automotive Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2022/09/30 17.67% = 15.39% × 1.15
2022/06/30 17.70% = 15.55% × 1.14
2022/03/31 18.24% = 15.85% × 1.15
2021/12/31 18.47% = 16.24% × 1.14
2021/09/30 17.29% = 15.85% × 1.09
2021/06/30 16.80% = 15.94% × 1.05
2021/03/31 16.48% = 15.99% × 1.03
2020/12/31 15.11% = 15.10% × 1.00
2020/09/30 13.47% = 14.96% × 0.90
2020/06/30 13.20% = 14.45% × 0.91
2020/03/31 12.34% = 13.41% × 0.92
2019/12/31 12.98% = 13.70% × 0.95
2019/09/30 13.17% = 13.69% × 0.96
2019/06/30 13.15% = 13.69% × 0.96
2019/03/31 13.33% = 13.87% × 0.96
2018/12/31 16.60% = 13.89% × 1.19
2018/09/30 16.80% = 14.09% × 1.19
2018/06/30 16.02% = 13.42% × 1.19
2018/03/31 15.31% = 12.89% × 1.19
2017/12/31 14.97% = 12.63% × 1.19
2017/09/30 — = — × —
2017/06/30 — = — × —
2017/03/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), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31).

2022年第3 四半期の総資産利益率(ROA)の低下の主な理由は、純利益率で測定した収益性の低下です。

ROAを4つの要素に分解

O’Reilly Automotive Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2022/09/30 17.67% = 0.77 × 0.95 × 20.96% × 1.15
2022/06/30 17.70% = 0.78 × 0.95 × 21.09% × 1.14
2022/03/31 18.24% = 0.78 × 0.95 × 21.44% × 1.15
2021/12/31 18.47% = 0.78 × 0.95 × 21.96% × 1.14
2021/09/30 17.29% = 0.77 × 0.95 × 21.66% × 1.09
2021/06/30 16.80% = 0.77 × 0.94 × 21.91% × 1.05
2021/03/31 16.48% = 0.77 × 0.94 × 22.11% × 1.03
2020/12/31 15.11% = 0.77 × 0.93 × 20.92% × 1.00
2020/09/30 13.47% = 0.77 × 0.93 × 20.73% × 0.90
2020/06/30 13.20% = 0.78 × 0.93 × 20.00% × 0.91
2020/03/31 12.34% = 0.78 × 0.92 × 18.61% × 0.92
2019/12/31 12.98% = 0.78 × 0.93 × 19.02% × 0.95
2019/09/30 13.17% = 0.77 × 0.93 × 19.14% × 0.96
2019/06/30 13.15% = 0.78 × 0.93 × 18.98% × 0.96
2019/03/31 13.33% = 0.78 × 0.93 × 19.05% × 0.96
2018/12/31 16.60% = 0.78 × 0.93 × 19.05% × 1.19
2018/09/30 16.80% = 0.79 × 0.93 × 19.07% × 1.19
2018/06/30 16.02% = 0.75 × 0.94 × 19.11% × 1.19
2018/03/31 15.31% = 0.71 × 0.94 × 19.20% × 1.19
2017/12/31 14.97% = 0.69 × 0.95 × 19.26% × 1.19
2017/09/30 — = — × — × — × —
2017/06/30 — = — × — × — × —
2017/03/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), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31).

2022年第3 四半期の総資産利益率(ROA)の低下の主な理由は、EBITマージン率で測定した営業利益率の低下です。

当期純利益率の分解

O’Reilly Automotive Inc.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2022/09/30 15.39% = 0.77 × 0.95 × 20.96%
2022/06/30 15.55% = 0.78 × 0.95 × 21.09%
2022/03/31 15.85% = 0.78 × 0.95 × 21.44%
2021/12/31 16.24% = 0.78 × 0.95 × 21.96%
2021/09/30 15.85% = 0.77 × 0.95 × 21.66%
2021/06/30 15.94% = 0.77 × 0.94 × 21.91%
2021/03/31 15.99% = 0.77 × 0.94 × 22.11%
2020/12/31 15.10% = 0.77 × 0.93 × 20.92%
2020/09/30 14.96% = 0.77 × 0.93 × 20.73%
2020/06/30 14.45% = 0.78 × 0.93 × 20.00%
2020/03/31 13.41% = 0.78 × 0.92 × 18.61%
2019/12/31 13.70% = 0.78 × 0.93 × 19.02%
2019/09/30 13.69% = 0.77 × 0.93 × 19.14%
2019/06/30 13.69% = 0.78 × 0.93 × 18.98%
2019/03/31 13.87% = 0.78 × 0.93 × 19.05%
2018/12/31 13.89% = 0.78 × 0.93 × 19.05%
2018/09/30 14.09% = 0.79 × 0.93 × 19.07%
2018/06/30 13.42% = 0.75 × 0.94 × 19.11%
2018/03/31 12.89% = 0.71 × 0.94 × 19.20%
2017/12/31 12.63% = 0.69 × 0.95 × 19.26%
2017/09/30 — = — × — × —
2017/06/30 — = — × — × —
2017/03/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), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31).

2022年第3 四半期の純利益率の低下の主な理由は、EBITマージン率で測定した営業利益率の低下です。