Stock Analysis on Net
Stock Analysis on Net

CoStar Group Inc. (NASDAQ:CSGP)

This company has been moved to the archive! The financial data has not been updated since July 26, 2023.

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data

Microsoft Excel

Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.

Two-Component Disaggregation of ROE

CoStar Group Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Jun 30, 2023 5.41% = 4.42% × 1.22
Mar 31, 2023 5.27% = 4.31% × 1.22
Dec 31, 2022 5.38% = 4.40% × 1.22
Sep 30, 2022 5.04% = 4.12% × 1.22
Jun 30, 2022 5.61% = 4.45% × 1.26
Mar 31, 2022 5.31% = 4.18% × 1.27
Dec 31, 2021 5.12% = 4.03% × 1.27
Sep 30, 2021 4.20% = 3.30% × 1.27
Jun 30, 2021 4.15% = 3.24% × 1.28
Mar 31, 2021 4.20% = 3.29% × 1.27
Dec 31, 2020 4.23% = 3.28% × 1.29
Sep 30, 2020 5.25% = 4.11% × 1.28
Jun 30, 2020 5.74% = 4.63% × 1.24
Mar 31, 2020 8.74% = 6.46% × 1.35
Dec 31, 2019 9.25% = 8.17% × 1.13
Sep 30, 2019 9.41% = 8.36% × 1.13
Jun 30, 2019 9.07% = 8.03% × 1.13
Mar 31, 2019 8.67% = 7.65% × 1.13
Dec 31, 2018 7.89% = 7.19% × 1.10
Sep 30, 2018 — = — × 1.10
Jun 30, 2018 — = — × 1.10
Mar 31, 2018 — = — × 1.11

Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

The primary reason for the increase in return on equity ratio (ROE) over Q2 2023 is the increase in profitability measured by return on assets ratio (ROA).

Three-Component Disaggregation of ROE

CoStar Group Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Jun 30, 2023 5.41% = 16.56% × 0.27 × 1.22
Mar 31, 2023 5.27% = 16.32% × 0.26 × 1.22
Dec 31, 2022 5.38% = 16.93% × 0.26 × 1.22
Sep 30, 2022 5.04% = 15.97% × 0.26 × 1.22
Jun 30, 2022 5.61% = 16.03% × 0.28 × 1.26
Mar 31, 2022 5.31% = 15.37% × 0.27 × 1.27
Dec 31, 2021 5.12% = 15.05% × 0.27 × 1.27
Sep 30, 2021 4.20% = 12.51% × 0.26 × 1.27
Jun 30, 2021 4.15% = 12.68% × 0.26 × 1.28
Mar 31, 2021 4.20% = 13.25% × 0.25 × 1.27
Dec 31, 2020 4.23% = 13.69% × 0.24 × 1.29
Sep 30, 2020 5.25% = 17.57% × 0.23 × 1.28
Jun 30, 2020 5.74% = 19.76% × 0.23 × 1.24
Mar 31, 2020 8.74% = 20.68% × 0.31 × 1.35
Dec 31, 2019 9.25% = 22.50% × 0.36 × 1.13
Sep 30, 2019 9.41% = 23.17% × 0.36 × 1.13
Jun 30, 2019 9.07% = 22.48% × 0.36 × 1.13
Mar 31, 2019 8.67% = 21.76% × 0.35 × 1.13
Dec 31, 2018 7.89% = 20.00% × 0.36 × 1.10
Sep 30, 2018 — = — × — × 1.10
Jun 30, 2018 — = — × — × 1.10
Mar 31, 2018 — = — × — × 1.11

Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

The primary reason for the increase in return on equity ratio (ROE) over Q2 2023 is the increase in profitability measured by net profit margin ratio.

Two-Component Disaggregation of ROA

CoStar Group Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Jun 30, 2023 4.42% = 16.56% × 0.27
Mar 31, 2023 4.31% = 16.32% × 0.26
Dec 31, 2022 4.40% = 16.93% × 0.26
Sep 30, 2022 4.12% = 15.97% × 0.26
Jun 30, 2022 4.45% = 16.03% × 0.28
Mar 31, 2022 4.18% = 15.37% × 0.27
Dec 31, 2021 4.03% = 15.05% × 0.27
Sep 30, 2021 3.30% = 12.51% × 0.26
Jun 30, 2021 3.24% = 12.68% × 0.26
Mar 31, 2021 3.29% = 13.25% × 0.25
Dec 31, 2020 3.28% = 13.69% × 0.24
Sep 30, 2020 4.11% = 17.57% × 0.23
Jun 30, 2020 4.63% = 19.76% × 0.23
Mar 31, 2020 6.46% = 20.68% × 0.31
Dec 31, 2019 8.17% = 22.50% × 0.36
Sep 30, 2019 8.36% = 23.17% × 0.36
Jun 30, 2019 8.03% = 22.48% × 0.36
Mar 31, 2019 7.65% = 21.76% × 0.35
Dec 31, 2018 7.19% = 20.00% × 0.36
Sep 30, 2018 — = — × —
Jun 30, 2018 — = — × —
Mar 31, 2018 — = — × —

Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

The primary reason for the increase in return on assets ratio (ROA) over Q2 2023 is the increase in profitability measured by net profit margin ratio.