Stock Analysis on Net

Twitter Inc. (NYSE:TWTR)

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

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

Microsoft Excel

Two-Component Disaggregation of ROE

Twitter Inc., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2021 -3.03% = -1.57% × 1.92
Dec 31, 2020 -14.25% = -8.49% × 1.68
Dec 31, 2019 16.84% = 11.54% × 1.46
Dec 31, 2018 17.71% = 11.86% × 1.49
Dec 31, 2017 -2.14% = -1.46% × 1.47

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Three-Component Disaggregation of ROE

Twitter Inc., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2021 -3.03% = -4.36% × 0.36 × 1.92
Dec 31, 2020 -14.25% = -30.56% × 0.28 × 1.68
Dec 31, 2019 16.84% = 42.37% × 0.27 × 1.46
Dec 31, 2018 17.71% = 39.63% × 0.30 × 1.49
Dec 31, 2017 -2.14% = -4.42% × 0.33 × 1.47

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Five-Component Disaggregation of ROE

Twitter Inc., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2021 -3.03% = × × -7.09% × 0.36 × 1.92
Dec 31, 2020 -14.25% = × -0.50 × 2.74% × 0.28 × 1.68
Dec 31, 2019 16.84% = 3.76 × 0.74 × 15.27% × 0.27 × 1.46
Dec 31, 2018 17.71% = 2.85 × 0.76 × 18.28% × 0.30 × 1.49
Dec 31, 2017 -2.14% = × -9.72 × 0.40% × 0.33 × 1.47

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Two-Component Disaggregation of ROA

Twitter Inc., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2021 -1.57% = -4.36% × 0.36
Dec 31, 2020 -8.49% = -30.56% × 0.28
Dec 31, 2019 11.54% = 42.37% × 0.27
Dec 31, 2018 11.86% = 39.63% × 0.30
Dec 31, 2017 -1.46% = -4.42% × 0.33

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Four-Component Disaggregation of ROA

Twitter Inc., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2021 -1.57% = × × -7.09% × 0.36
Dec 31, 2020 -8.49% = × -0.50 × 2.74% × 0.28
Dec 31, 2019 11.54% = 3.76 × 0.74 × 15.27% × 0.27
Dec 31, 2018 11.86% = 2.85 × 0.76 × 18.28% × 0.30
Dec 31, 2017 -1.46% = × -9.72 × 0.40% × 0.33

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Disaggregation of Net Profit Margin

Twitter Inc., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2021 -4.36% = × × -7.09%
Dec 31, 2020 -30.56% = × -0.50 × 2.74%
Dec 31, 2019 42.37% = 3.76 × 0.74 × 15.27%
Dec 31, 2018 39.63% = 2.85 × 0.76 × 18.28%
Dec 31, 2017 -4.42% = × -9.72 × 0.40%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).