Stock Analysis on Net

Etsy Inc. (NASDAQ:ETSY)

$22.49

This company has been moved to the archive! The financial data has not been updated since November 3, 2022.

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

Microsoft Excel

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

Etsy Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
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 = ×
Dec 31, 2017 = ×
Sep 30, 2017 = ×
Jun 30, 2017 = ×
Mar 31, 2017 = ×

Based on: 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), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


The Return on Assets (ROA) displayed a fluctuating pattern over the observed quarters. Initially, in 2017, the data is mostly missing; however, from the first quarter of 2018, ROA was around 13.51% but showed a generally decreasing trend until reaching a low point of 5.06% in the third quarter of 2020. Thereafter, a notable recovery occurred with ROA peaking at 19.24% in the fourth quarter of 2020. The metric remained relatively strong into 2021, with figures mostly above 10%, before sharply declining to -26.21% in the third quarter of 2022, indicating a significant negative return on the company’s assets by that time.

Financial Leverage exhibited an increasing trend over the time frame. Starting at ratios around 1.8 in early 2017, the ratio gradually increased to a level near 2.3 by 2018 and experienced a sharp rise during 2019, peaking at about 3.85 in the third quarter of 2019. Following a minor reduction in 2020 to near 3.24, leverage substantially escalated again to over 6 in 2021 and maintained high values around 6.1 to 6.56 through mid to late 2022. This reflects a growing use of debt or other liabilities relative to equity, increasing the company’s financial risk profile over the period.

The Return on Equity (ROE) demonstrated strong growth with considerable volatility. ROE began around 20.61% in early 2018 and showed a rising trend through 2019, peaking at 27.19% by the fourth quarter. Despite a dip down to 18.89% in the middle of 2020, the metric surged dramatically in subsequent quarters, reaching an exceptionally high 90.87% in the third quarter of 2021. This extreme increase suggests periods of pronounced profitability relative to shareholder equity, potentially influenced by high financial leverage. However, following this peak, ROE decreased to approximately 64.39% by the third quarter of 2022, still indicating very high returns but also increased variability.

Return on Assets (ROA)
Initial data missing for 2017; from 2018, a decline was observed until late 2020 followed by recovery; sharp negative value in late 2022.
Financial Leverage
Gradual increase from 1.8 in 2017 to above 6.0 by 2021 through 2022; indicates increased use of debt.
Return on Equity (ROE)
Consistent growth with peaks in late 2021 reaching over 90%, followed by a decline but still high in late 2022; correlated with leverage trends.

Overall, the data reveals that the company increased its financial leverage substantially over the period, which coincided with a notable increase in ROE, suggesting the use of debt to amplify equity returns. However, the volatility and eventual sharp decline in ROA and the negative ROA in late 2022 indicate increased financial risk and potential operational challenges during that time. The relationship between high leverage and fluctuating profitability metrics suggests careful attention to risk management may be warranted.


Three-Component Disaggregation of ROE

Etsy Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
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 = × ×
Dec 31, 2017 = × ×
Sep 30, 2017 = × ×
Jun 30, 2017 = × ×
Mar 31, 2017 = × ×

Based on: 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), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


The net profit margin exhibits notable fluctuations over the reported quarters. Beginning from its earliest available data point in March 2018, the margin starts at 18.54%, reaching a low of 8.76% in June 2020, followed by a general upward trend that peaks near 23.46% in June 2021. However, the margin declines subsequently, evident in the negative figure of -25.94% by September 2022, indicating a significant downturn in profitability during that quarter.

Asset turnover ratios suggest moderate variability but generally remain within the range of 0.5 to 1.0 throughout the periods. Initially observing a value around 0.73 in March 2018, the ratio decreases slightly mid-2018, maintains relative stability near 0.6 across 2019 and 2020, then rises to 0.82 by June 2021. Despite some oscillations, the final data point in September 2022 indicates a marked increase to 1.01, suggesting improved efficiency in utilizing assets to generate revenue during that period.

Financial leverage shows a rising trend through the timeline, starting at lower levels around 1.53 in late 2017, increasing steadily to values exceeding 6.0 by mid-2021, peaking at 6.56 in September 2021 before slightly declining but remaining elevated around 6.21 in mid-2022. This indicates a progressively higher reliance on debt or borrowed funds to finance assets, which may impact risk and return dynamics.

Return on equity (ROE) demonstrates significant growth from 2018 onwards. The measure commences in the low twenties percentage range, trending upwards sharply after 2019, reaching extraordinarily high levels such as 47.04% in December 2020, ascending further to 90.87% in September 2021. While there is a gradual decrease following the peak, values remain elevated through mid-2022. The elevated ROE reflects strong profitability relative to shareholder equity, possibly amplified by increased financial leverage observed concurrently.

Summary of Trends
The data indicate initial moderate profitability and asset efficiency followed by periods of increased leverage and exceptional ROE growth. The substantial rise in financial leverage likely contributed to amplified returns on equity but also correlates with greater volatility, as evidenced by the decline in net profit margin to a negative value in the most recent quarter. The improvement in asset turnover towards the later periods suggests enhanced operational efficiency despite the volatility in profitability metrics.

Two-Component Disaggregation of ROA

Etsy Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
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 = ×
Dec 31, 2017 = ×
Sep 30, 2017 = ×
Jun 30, 2017 = ×
Mar 31, 2017 = ×

Based on: 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), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


The analysis of the quarterly financial ratios reveals several noteworthy patterns and fluctuations over the examined periods.

Net Profit Margin (%)
The net profit margin shows an initial increase starting from 18.54% in March 2018, peaking around 20.46% in June 2018. Subsequently, there is a decline toward the end of 2018 and the beginning of 2019, dropping to approximately 11.72% in March 2020. Following this dip, the margin gradually recovers and reaches a notable peak of 23.46% by March 2021. Afterward, a downward trend is observed, with the margin decreasing to 17.01% by September 2022, before a sharp and significant drop to -25.94% is recorded.
Asset Turnover (ratio)
Asset turnover starts at a moderate level of 0.73 in March 2018 but decreases to a low of 0.50 toward the end of 2019. During 2020, the ratio improves steadily, peaking at 0.82 in June 2021. Thereafter, the ratio exhibits fluctuations but trends slightly downward until September 2022, where it increases suddenly to 1.01, representing the highest asset turnover within the period. The increase toward the end suggests improved efficiency in utilizing assets to generate revenue.
Return on Assets (ROA) (%)
The ROA trend generally mirrors the pattern seen in net profit margin. It starts relatively high at 13.51% in March 2018, then declines steadily to around 5.06% by March 2020. Following this low, there is a recovery with ROA peaking at 19.24% in June 2021. After this peak, ROA declines again gradually, reaching 11.39% in September 2022 before experiencing a sharp reversal to -26.21%. This pattern reflects initial profitability challenges, followed by a period of recovery and growth, and a severe downturn in the most recent quarter.

Overall, the data indicates cycles of profitability and efficiency with marked peaks around mid-2021, followed by a pronounced decline in the latest quarter. Both profitability and asset utilization undergo significant fluctuations, impacting returns materially. The sharp negative figures in net profit margin and ROA in the last quarter signal considerable financial distress or exceptional loss events that require further investigation to understand underlying causes.