Stock Analysis on Net
Stock Analysis on Net

Autodesk Inc. (NASDAQ:ADSK)

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

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

Autodesk Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Oct 31, 2021 103.07% = 15.46% × 6.67
Jul 31, 2021 99.01% = 17.72% × 5.59
Apr 30, 2021 114.97% = 17.78% × 6.47
Jan 31, 2021 125.14% = 16.60% × 7.54
Oct 31, 2020 618.61% = 7.21% × 85.78
Jul 31, 2020 539.67% = 6.32% × 85.40
Apr 30, 2020 — = 5.51% × —
Jan 31, 2020 — = 3.47% × —
Oct 31, 2019 — = 2.93% × —
Jul 31, 2019 — = 1.17% × —
Apr 30, 2019 — = -0.47% × —
Jan 31, 2019 — = -1.71% × —
Oct 31, 2018 — = -8.45% × —
Jul 31, 2018 — = -10.83% × —
Apr 30, 2018 — = -13.29% × —
Jan 31, 2018 — = -13.78% × —
Oct 31, 2017 -528.24% = -13.65% × 38.70
Jul 31, 2017 -186.94% = -13.55% × 13.80
Apr 30, 2017 -107.07% = -12.28% × 8.72
Jan 31, 2017 -79.35% = -12.13% × 6.54
Oct 31, 2016 -42.04% = -9.23% × 4.55
Jul 31, 2016 -26.05% = -6.87% × 3.79
Apr 30, 2016 -36.03% = -9.94% × 3.63
Jan 31, 2016 -20.41% = -5.99% × 3.41
Oct 31, 2015 — = — × 3.01
Jul 31, 2015 — = — × 2.81
Apr 30, 2015 — = — × 2.15

Based on: 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-K (reporting date: 2019-01-31), 10-Q (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30), 10-K (reporting date: 2018-01-31), 10-Q (reporting date: 2017-10-31), 10-Q (reporting date: 2017-07-31), 10-Q (reporting date: 2017-04-30), 10-K (reporting date: 2017-01-31), 10-Q (reporting date: 2016-10-31), 10-Q (reporting date: 2016-07-31), 10-Q (reporting date: 2016-04-30), 10-K (reporting date: 2016-01-31), 10-Q (reporting date: 2015-10-31), 10-Q (reporting date: 2015-07-31), 10-Q (reporting date: 2015-04-30).

The primary reason for the increase in return on equity ratio (ROE) over Q3 2022 is the increase in financial leverage ratio.

Three-Component Disaggregation of ROE

Autodesk Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Oct 31, 2021 103.07% = 31.31% × 0.49 × 6.67
Jul 31, 2021 99.01% = 32.54% × 0.54 × 5.59
Apr 30, 2021 114.97% = 33.32% × 0.53 × 6.47
Jan 31, 2021 125.14% = 31.88% × 0.52 × 7.54
Oct 31, 2020 618.61% = 11.74% × 0.61 × 85.78
Jul 31, 2020 539.67% = 10.26% × 0.62 × 85.40
Apr 30, 2020 — = 8.91% × 0.62 × —
Jan 31, 2020 — = 6.55% × 0.53 × —
Oct 31, 2019 — = 4.74% × 0.62 × —
Jul 31, 2019 — = 1.95% × 0.60 × —
Apr 30, 2019 — = -0.82% × 0.57 × —
Jan 31, 2019 — = -3.14% × 0.54 × —
Oct 31, 2018 — = -13.37% × 0.63 × —
Jul 31, 2018 — = -18.53% × 0.58 × —
Apr 30, 2018 — = -24.39% × 0.54 × —
Jan 31, 2018 — = -27.56% × 0.50 × —
Oct 31, 2017 -528.24% = -28.60% × 0.48 × 38.70
Jul 31, 2017 -186.94% = -30.15% × 0.45 × 13.80
Apr 30, 2017 -107.07% = -27.13% × 0.45 × 8.72
Jan 31, 2017 -79.35% = -28.66% × 0.42 × 6.54
Oct 31, 2016 -42.04% = -20.26% × 0.46 × 4.55
Jul 31, 2016 -26.05% = -15.01% × 0.46 × 3.79
Apr 30, 2016 -36.03% = -21.83% × 0.46 × 3.63
Jan 31, 2016 -20.41% = -13.20% × 0.45 × 3.41
Oct 31, 2015 — = — × — × 3.01
Jul 31, 2015 — = — × — × 2.81
Apr 30, 2015 — = — × — × 2.15

Based on: 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-K (reporting date: 2019-01-31), 10-Q (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30), 10-K (reporting date: 2018-01-31), 10-Q (reporting date: 2017-10-31), 10-Q (reporting date: 2017-07-31), 10-Q (reporting date: 2017-04-30), 10-K (reporting date: 2017-01-31), 10-Q (reporting date: 2016-10-31), 10-Q (reporting date: 2016-07-31), 10-Q (reporting date: 2016-04-30), 10-K (reporting date: 2016-01-31), 10-Q (reporting date: 2015-10-31), 10-Q (reporting date: 2015-07-31), 10-Q (reporting date: 2015-04-30).

The primary reason for the increase in return on equity ratio (ROE) over Q3 2022 is the increase in financial leverage ratio.

Two-Component Disaggregation of ROA

Autodesk Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Oct 31, 2021 15.46% = 31.31% × 0.49
Jul 31, 2021 17.72% = 32.54% × 0.54
Apr 30, 2021 17.78% = 33.32% × 0.53
Jan 31, 2021 16.60% = 31.88% × 0.52
Oct 31, 2020 7.21% = 11.74% × 0.61
Jul 31, 2020 6.32% = 10.26% × 0.62
Apr 30, 2020 5.51% = 8.91% × 0.62
Jan 31, 2020 3.47% = 6.55% × 0.53
Oct 31, 2019 2.93% = 4.74% × 0.62
Jul 31, 2019 1.17% = 1.95% × 0.60
Apr 30, 2019 -0.47% = -0.82% × 0.57
Jan 31, 2019 -1.71% = -3.14% × 0.54
Oct 31, 2018 -8.45% = -13.37% × 0.63
Jul 31, 2018 -10.83% = -18.53% × 0.58
Apr 30, 2018 -13.29% = -24.39% × 0.54
Jan 31, 2018 -13.78% = -27.56% × 0.50
Oct 31, 2017 -13.65% = -28.60% × 0.48
Jul 31, 2017 -13.55% = -30.15% × 0.45
Apr 30, 2017 -12.28% = -27.13% × 0.45
Jan 31, 2017 -12.13% = -28.66% × 0.42
Oct 31, 2016 -9.23% = -20.26% × 0.46
Jul 31, 2016 -6.87% = -15.01% × 0.46
Apr 30, 2016 -9.94% = -21.83% × 0.46
Jan 31, 2016 -5.99% = -13.20% × 0.45
Oct 31, 2015 — = — × —
Jul 31, 2015 — = — × —
Apr 30, 2015 — = — × —

Based on: 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-K (reporting date: 2019-01-31), 10-Q (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30), 10-K (reporting date: 2018-01-31), 10-Q (reporting date: 2017-10-31), 10-Q (reporting date: 2017-07-31), 10-Q (reporting date: 2017-04-30), 10-K (reporting date: 2017-01-31), 10-Q (reporting date: 2016-10-31), 10-Q (reporting date: 2016-07-31), 10-Q (reporting date: 2016-04-30), 10-K (reporting date: 2016-01-31), 10-Q (reporting date: 2015-10-31), 10-Q (reporting date: 2015-07-31), 10-Q (reporting date: 2015-04-30).

The primary reason for the decrease in return on assets ratio (ROA) over Q3 2022 is the decrease in asset turnover ratio.