Stock Analysis on Net
Stock Analysis on Net

Mosaic Co. (NYSE:MOS)

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

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

Mosaic Co., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Jun 30, 2022 27.70% = 13.57% × 2.04
Mar 31, 2022 22.82% = 11.34% × 2.01
Dec 31, 2021 15.38% = 7.40% × 2.08
Sep 30, 2021 17.21% = 8.51% × 2.02
Jun 30, 2021 13.69% = 6.59% × 2.08
Mar 31, 2021 10.66% = 5.15% × 2.07
Dec 31, 2020 6.95% = 3.37% × 2.07
Sep 30, 2020 -12.69% = -5.74% × 2.21
Jun 30, 2020 -13.20% = -5.89% × 2.24
Mar 31, 2020 -16.71% = -7.38% × 2.26
Dec 31, 2019 -11.62% = -5.53% × 2.10
Sep 30, 2019 -0.34% = -0.17% × 2.02
Jun 30, 2019 2.46% = 1.25% × 1.97
Mar 31, 2019 5.27% = 2.73% × 1.93
Dec 31, 2018 4.52% = 2.34% × 1.94
Sep 30, 2018 -0.70% = -0.36% × 1.96
Jun 30, 2018 -0.92% = -0.46% × 2.00
Mar 31, 2018 -0.61% = -0.31% × 1.96
Dec 31, 2017 -1.11% = -0.58% × 1.94
Sep 30, 2017 — = — × 1.76
Jun 30, 2017 — = — × 1.79
Mar 31, 2017 — = — × 1.78

Based on: 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 primary reason for the increase in return on equity ratio (ROE) over Q2 2022 is the increase in profitability measured by return on assets ratio (ROA).

Three-Component Disaggregation of ROE

Mosaic Co., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Jun 30, 2022 27.70% = 19.66% × 0.69 × 2.04
Mar 31, 2022 22.82% = 18.99% × 0.60 × 2.01
Dec 31, 2021 15.38% = 13.20% × 0.56 × 2.08
Sep 30, 2021 17.21% = 16.35% × 0.52 × 2.02
Jun 30, 2021 13.69% = 14.25% × 0.46 × 2.08
Mar 31, 2021 10.66% = 11.17% × 0.46 × 2.07
Dec 31, 2020 6.95% = 7.67% × 0.44 × 2.07
Sep 30, 2020 -12.69% = -13.04% × 0.44 × 2.21
Jun 30, 2020 -13.20% = -12.92% × 0.46 × 2.24
Mar 31, 2020 -16.71% = -15.91% × 0.46 × 2.26
Dec 31, 2019 -11.62% = -11.98% × 0.46 × 2.10
Sep 30, 2019 -0.34% = -0.36% × 0.46 × 2.02
Jun 30, 2019 2.46% = 2.70% × 0.46 × 1.97
Mar 31, 2019 5.27% = 5.85% × 0.47 × 1.93
Dec 31, 2018 4.52% = 4.90% × 0.48 × 1.94
Sep 30, 2018 -0.70% = -0.80% × 0.45 × 1.96
Jun 30, 2018 -0.92% = -1.14% × 0.40 × 2.00
Mar 31, 2018 -0.61% = -0.82% × 0.38 × 1.96
Dec 31, 2017 -1.11% = -1.45% × 0.40 × 1.94
Sep 30, 2017 — = — × — × 1.76
Jun 30, 2017 — = — × — × 1.79
Mar 31, 2017 — = — × — × 1.78

Based on: 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 primary reason for the increase in return on equity ratio (ROE) over Q2 2022 is the increase in efficiency measured by asset turnover ratio.

Two-Component Disaggregation of ROA

Mosaic Co., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Jun 30, 2022 13.57% = 19.66% × 0.69
Mar 31, 2022 11.34% = 18.99% × 0.60
Dec 31, 2021 7.40% = 13.20% × 0.56
Sep 30, 2021 8.51% = 16.35% × 0.52
Jun 30, 2021 6.59% = 14.25% × 0.46
Mar 31, 2021 5.15% = 11.17% × 0.46
Dec 31, 2020 3.37% = 7.67% × 0.44
Sep 30, 2020 -5.74% = -13.04% × 0.44
Jun 30, 2020 -5.89% = -12.92% × 0.46
Mar 31, 2020 -7.38% = -15.91% × 0.46
Dec 31, 2019 -5.53% = -11.98% × 0.46
Sep 30, 2019 -0.17% = -0.36% × 0.46
Jun 30, 2019 1.25% = 2.70% × 0.46
Mar 31, 2019 2.73% = 5.85% × 0.47
Dec 31, 2018 2.34% = 4.90% × 0.48
Sep 30, 2018 -0.36% = -0.80% × 0.45
Jun 30, 2018 -0.46% = -1.14% × 0.40
Mar 31, 2018 -0.31% = -0.82% × 0.38
Dec 31, 2017 -0.58% = -1.45% × 0.40
Sep 30, 2017 — = — × —
Jun 30, 2017 — = — × —
Mar 31, 2017 — = — × —

Based on: 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 primary reason for the increase in return on assets ratio (ROA) over Q2 2022 is the increase in asset turnover ratio.