Stock Analysis on Net

CoStar Group Inc. (NASDAQ:CSGP)

$22.49

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.

Paying user area


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

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

Microsoft Excel
ROE = ROA × Financial Leverage
Jun 30, 2023 = ×
Mar 31, 2023 = ×
Dec 31, 2022 = ×
Sep 30, 2022 = ×
Jun 30, 2022 = ×
Mar 31, 2022 = ×
Dec 31, 2021 = ×
Sep 30, 2021 = ×
Jun 30, 2021 = ×
Mar 31, 2021 = ×
Dec 31, 2020 = ×
Sep 30, 2020 = ×
Jun 30, 2020 = ×
Mar 31, 2020 = ×
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×
Dec 31, 2018 = ×
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 analysis of the quarterly financial ratios indicates several notable trends in company performance from early 2018 through mid-2023.

Return on Assets (ROA)
The ROA values start from 7.19% in March 2019, showing an upward trend reaching a peak of 8.36% in December 2019. This peak is followed by a pronounced decline through 2020, reaching a low near 3.24% to 3.3% by mid to late 2021. Beginning in late 2021, the ROA exhibits a modest but consistent recovery, moving up to approximately 4.42% by June 2023. This trajectory indicates reduced asset profitability following 2019 with gradual improvement in recent quarters.
Financial Leverage
The financial leverage ratio remains relatively stable from early 2018 through most of 2019, hovering around 1.10 to 1.13. A noticeable increase occurs in early 2020, peaking at about 1.35 in March 2020, suggesting increased use of debt or liabilities relative to equity. From mid-2020 onward, the leverage ratio gradually decreases and stabilizes near 1.22 by mid-2023. This trend reflects a conservative deleveraging after the spike in early 2020.
Return on Equity (ROE)
The ROE values align closely with the ROA trends but exhibit higher magnitude differences, consistent with the leverage effect. ROE rises to a high of about 9.41% in December 2019, then declines sharply through 2020 and 2021, reaching lows around 4.15% to 4.2%. From late 2021 through mid-2023, there is a gradual increase in ROE, reaching approximately 5.41%. The trajectory suggests that shareholder returns were strongest prior to 2020, were materially impacted thereafter, and have been slowly recovering.

In summary, the company experienced strong asset and equity profitability up until the end of 2019, followed by a significant downturn particularly throughout 2020 and 2021. This period also corresponds with a peak in financial leverage, suggesting increased risk or financing changes during that time. Since late 2021, all key profitability indicators display a steady recovery trend, accompanied by a reduction and stabilization of leverage. These patterns may reflect broader economic conditions impacting the company as well as strategic financial management actions taken in response.


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 = × ×
Mar 31, 2023 = × ×
Dec 31, 2022 = × ×
Sep 30, 2022 = × ×
Jun 30, 2022 = × ×
Mar 31, 2022 = × ×
Dec 31, 2021 = × ×
Sep 30, 2021 = × ×
Jun 30, 2021 = × ×
Mar 31, 2021 = × ×
Dec 31, 2020 = × ×
Sep 30, 2020 = × ×
Jun 30, 2020 = × ×
Mar 31, 2020 = × ×
Dec 31, 2019 = × ×
Sep 30, 2019 = × ×
Jun 30, 2019 = × ×
Mar 31, 2019 = × ×
Dec 31, 2018 = × ×
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).


Net Profit Margin
The net profit margin exhibited a generally declining trend from early 2019 through 2021, starting at 20% and falling to a low point around 12.51% by the end of 2021. Subsequently, it showed a gradual recovery, increasing to approximately 16.56% by mid-2023. This suggests a period of reduced profitability margins followed by a stabilization and modest improvement in profit efficiency relative to revenue.
Asset Turnover
Asset turnover initially remained stable around 0.36 from early 2019 to early 2020, followed by a notable decline reaching 0.23 in late 2020. From 2021 onwards, the ratio slowly increased to around 0.27 in the first half of 2023, indicating a period of decreased efficiency in utilizing assets to generate sales, with gradual recovery beginning after 2020.
Financial Leverage
Financial leverage was relatively stable around 1.10 to 1.13 from early 2018 through 2019, then increased significantly to a peak of 1.35 in early 2020. Afterward, it generally decreased and stabilized around 1.22 from 2022 through mid-2023. This suggests a transient increase in debt or liabilities relative to equity around 2020, followed by deleveraging or stabilization at a moderate leverage level.
Return on Equity (ROE)
Return on equity rose from 7.89% in early 2019 to a peak near 9.41% at the end of 2019, then experienced a marked decline through 2020 and 2021, bottoming around 4.15%. Following this, a moderate recovery is visible, with ROE reaching approximately 5.41% by mid-2023. The pattern reflects decreased profitability and efficiency in generating returns on shareholder equity during 2020 and 2021, with some improvements thereafter but still below previous highs.

Two-Component Disaggregation of ROA

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

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Jun 30, 2023 = ×
Mar 31, 2023 = ×
Dec 31, 2022 = ×
Sep 30, 2022 = ×
Jun 30, 2022 = ×
Mar 31, 2022 = ×
Dec 31, 2021 = ×
Sep 30, 2021 = ×
Jun 30, 2021 = ×
Mar 31, 2021 = ×
Dec 31, 2020 = ×
Sep 30, 2020 = ×
Jun 30, 2020 = ×
Mar 31, 2020 = ×
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×
Dec 31, 2018 = ×
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).


Net Profit Margin
The net profit margin showed a generally declining trend from the peak of 23.17% in December 2018 to a low of 12.51% in December 2021. This represents a significant decrease over three years. However, beginning in 2022, the margin experienced a modest recovery, increasing steadily to reach 16.56% by June 2023. The initial decline may indicate rising costs or decreasing pricing power, while the recent improvement suggests enhanced profitability or better cost management.
Asset Turnover
Asset turnover demonstrated relative stability, fluctuating narrowly around the 0.35-0.36 range until the end of 2019. From 2020 onwards, there was a noticeable drop to approximately 0.23-0.24, which persisted for several quarters. Starting in early 2021, asset turnover gradually improved, reaching around 0.27 by mid-2023. This pattern suggests that the efficiency of asset utilization declined significantly in 2020 but has been on a recovery path since then, though not yet returning to previous peak levels.
Return on Assets (ROA)
Return on assets followed a trend similar to net profit margin, with a peak of 8.36% in December 2018 followed by a pronounced decline to a low near 3.24% by September 2021. Thereafter, ROA showed gradual improvement, reaching 4.42% by June 2023. The initial decrease is consistent with the reduced profitability and asset utilization efficiency observed, while the improvement in recent periods indicates better returns generated from assets, albeit still below earlier peak performance.