Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

$19.99

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

Microsoft Excel LibreOffice Calc

Paying users area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

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

Two-Component Disaggregation of ROE

PepsiCo Inc., decomposition of ROE (quarterly data)

Microsoft Excel LibreOffice Calc
ROE = ROA × Financial Leverage
Sep 4, 2021 = ×
Jun 12, 2021 = ×
Mar 20, 2021 = ×
Dec 26, 2020 = ×
Sep 5, 2020 = ×
Jun 13, 2020 = ×
Mar 21, 2020 = ×
Dec 28, 2019 = ×
Sep 7, 2019 = ×
Jun 15, 2019 = ×
Mar 23, 2019 = ×
Dec 29, 2018 = ×
Sep 8, 2018 = ×
Jun 16, 2018 = ×
Mar 24, 2018 = ×
Dec 30, 2017 = ×
Sep 9, 2017 = ×
Jun 17, 2017 = ×
Mar 25, 2017 = ×
Dec 31, 2016 = ×
Sep 3, 2016 = ×
Jun 11, 2016 = ×
Mar 19, 2016 = ×

Based on: 10-Q (reporting date: 2021-09-04), 10-Q (reporting date: 2021-06-12), 10-Q (reporting date: 2021-03-20), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-05), 10-Q (reporting date: 2020-06-13), 10-Q (reporting date: 2020-03-21), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-07), 10-Q (reporting date: 2019-06-15), 10-Q (reporting date: 2019-03-23), 10-K (reporting date: 2018-12-29), 10-Q (reporting date: 2018-09-08), 10-Q (reporting date: 2018-06-16), 10-Q (reporting date: 2018-03-24), 10-K (reporting date: 2017-12-30), 10-Q (reporting date: 2017-09-09), 10-Q (reporting date: 2017-06-17), 10-Q (reporting date: 2017-03-25), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-03), 10-Q (reporting date: 2016-06-11), 10-Q (reporting date: 2016-03-19).

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


Three-Component Disaggregation of ROE

PepsiCo Inc., decomposition of ROE (quarterly data)

Microsoft Excel LibreOffice Calc
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Sep 4, 2021 = × ×
Jun 12, 2021 = × ×
Mar 20, 2021 = × ×
Dec 26, 2020 = × ×
Sep 5, 2020 = × ×
Jun 13, 2020 = × ×
Mar 21, 2020 = × ×
Dec 28, 2019 = × ×
Sep 7, 2019 = × ×
Jun 15, 2019 = × ×
Mar 23, 2019 = × ×
Dec 29, 2018 = × ×
Sep 8, 2018 = × ×
Jun 16, 2018 = × ×
Mar 24, 2018 = × ×
Dec 30, 2017 = × ×
Sep 9, 2017 = × ×
Jun 17, 2017 = × ×
Mar 25, 2017 = × ×
Dec 31, 2016 = × ×
Sep 3, 2016 = × ×
Jun 11, 2016 = × ×
Mar 19, 2016 = × ×

Based on: 10-Q (reporting date: 2021-09-04), 10-Q (reporting date: 2021-06-12), 10-Q (reporting date: 2021-03-20), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-05), 10-Q (reporting date: 2020-06-13), 10-Q (reporting date: 2020-03-21), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-07), 10-Q (reporting date: 2019-06-15), 10-Q (reporting date: 2019-03-23), 10-K (reporting date: 2018-12-29), 10-Q (reporting date: 2018-09-08), 10-Q (reporting date: 2018-06-16), 10-Q (reporting date: 2018-03-24), 10-K (reporting date: 2017-12-30), 10-Q (reporting date: 2017-09-09), 10-Q (reporting date: 2017-06-17), 10-Q (reporting date: 2017-03-25), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-03), 10-Q (reporting date: 2016-06-11), 10-Q (reporting date: 2016-03-19).

The primary reason for the decrease in return on equity ratio (ROE) over Q3 2021 is the decrease in profitability measured by net profit margin ratio.


Two-Component Disaggregation of ROA

PepsiCo Inc., decomposition of ROA (quarterly data)

Microsoft Excel LibreOffice Calc
ROA = Net Profit Margin × Asset Turnover
Sep 4, 2021 = ×
Jun 12, 2021 = ×
Mar 20, 2021 = ×
Dec 26, 2020 = ×
Sep 5, 2020 = ×
Jun 13, 2020 = ×
Mar 21, 2020 = ×
Dec 28, 2019 = ×
Sep 7, 2019 = ×
Jun 15, 2019 = ×
Mar 23, 2019 = ×
Dec 29, 2018 = ×
Sep 8, 2018 = ×
Jun 16, 2018 = ×
Mar 24, 2018 = ×
Dec 30, 2017 = ×
Sep 9, 2017 = ×
Jun 17, 2017 = ×
Mar 25, 2017 = ×
Dec 31, 2016 = ×
Sep 3, 2016 = ×
Jun 11, 2016 = ×
Mar 19, 2016 = ×

Based on: 10-Q (reporting date: 2021-09-04), 10-Q (reporting date: 2021-06-12), 10-Q (reporting date: 2021-03-20), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-05), 10-Q (reporting date: 2020-06-13), 10-Q (reporting date: 2020-03-21), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-07), 10-Q (reporting date: 2019-06-15), 10-Q (reporting date: 2019-03-23), 10-K (reporting date: 2018-12-29), 10-Q (reporting date: 2018-09-08), 10-Q (reporting date: 2018-06-16), 10-Q (reporting date: 2018-03-24), 10-K (reporting date: 2017-12-30), 10-Q (reporting date: 2017-09-09), 10-Q (reporting date: 2017-06-17), 10-Q (reporting date: 2017-03-25), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-03), 10-Q (reporting date: 2016-06-11), 10-Q (reporting date: 2016-03-19).

The primary reason for the decrease in return on assets ratio (ROA) over Q3 2021 is the decrease in profitability measured by net profit margin ratio.