Stock Analysis on Net

HP Inc. (NYSE:HPQ)

$22.49

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

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

Microsoft Excel

Paying user 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 Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

HP Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Jul 31, 2019 = ×
Apr 30, 2019 = ×
Jan 31, 2019 = ×
Oct 31, 2018 = ×
Jul 31, 2018 = ×
Apr 30, 2018 = ×
Jan 31, 2018 = ×
Oct 31, 2017 = ×
Jul 31, 2017 = ×
Apr 30, 2017 = ×
Jan 31, 2017 = ×
Oct 31, 2016 = ×
Jul 31, 2016 = ×
Apr 30, 2016 = ×
Jan 31, 2016 = ×
Oct 31, 2015 = ×
Jul 31, 2015 = ×
Apr 30, 2015 = ×
Jan 31, 2015 = ×
Oct 31, 2014 = ×
Jul 31, 2014 = ×
Apr 30, 2014 = ×
Jan 31, 2014 = ×
Oct 31, 2013 = ×
Jul 31, 2013 = ×
Apr 30, 2013 = ×
Jan 31, 2013 = ×

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


The analysis of the quarterly financial data reveals distinct trends in the key financial ratios over the periods presented.

Return on Assets (ROA)
The ROA shows a generally positive trajectory starting from a value of 4.84% in January 2014, peaking notably at 14.81% in April 2016. Following this peak, there is a decline to 8.6% by October 2016, after which the ROA stabilizes and fluctuates around 7% to 13%, with a secondary peak reaching 15.39% in January 2019. This pattern indicates periods of enhanced asset efficiency interspersed with corrections or reduced efficiency in generating earnings from assets over time.
Financial Leverage
The financial leverage ratio exhibits a decreasing trend from 4.66 in January 2013 to 3.62 in July 2014, implying a gradual reduction in the company's use of debt relative to equity during this period. There is a slight increase observed in October 2014, reaching 3.86, and remaining relatively steady around the high 3.7 to low 4.0 range through April 2015. Data beyond this point is not available to assess further trends.
Return on Equity (ROE)
The ROE, which starts at 18.75% in January 2014, shows gradual improvement peaking at 19.52% by July 2014. From there, a downward trend follows through April 2015, ending at 16.4%. This indicates that the company's profitability relative to shareholder equity increased initially but subsequently experienced a decline, potentially reflecting changing operational efficiencies or capital structure adjustments within the company.

Overall, the financial data indicate periods of strong profitability and efficient asset use, particularly highlighted by the peaks in ROA and ROE. The downward adjustments in financial leverage suggest a cautious approach to debt management in the earlier part of the period analyzed. However, missing data for some ratios in later periods limits a complete longitudinal assessment.


Three-Component Disaggregation of ROE

HP Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Jul 31, 2019 = × ×
Apr 30, 2019 = × ×
Jan 31, 2019 = × ×
Oct 31, 2018 = × ×
Jul 31, 2018 = × ×
Apr 30, 2018 = × ×
Jan 31, 2018 = × ×
Oct 31, 2017 = × ×
Jul 31, 2017 = × ×
Apr 30, 2017 = × ×
Jan 31, 2017 = × ×
Oct 31, 2016 = × ×
Jul 31, 2016 = × ×
Apr 30, 2016 = × ×
Jan 31, 2016 = × ×
Oct 31, 2015 = × ×
Jul 31, 2015 = × ×
Apr 30, 2015 = × ×
Jan 31, 2015 = × ×
Oct 31, 2014 = × ×
Jul 31, 2014 = × ×
Apr 30, 2014 = × ×
Jan 31, 2014 = × ×
Oct 31, 2013 = × ×
Jul 31, 2013 = × ×
Apr 30, 2013 = × ×
Jan 31, 2013 = × ×

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


The analysis of the quarterly financial ratios reveals several noteworthy trends over the observed periods.

Net Profit Margin
The net profit margin displays a generally positive trend from early 2014 through mid-2019. Starting around 4.5%, it maintains a relatively stable range between 4.3% and 5.4% for several quarters. Beginning in early 2018, there is a marked increase, reaching a peak above 9% by October 2018. This surge suggests improved profitability in recent periods. However, subsequent quarters show a slight decline, stabilizing near 7% to 7.2% by mid-2019.
Asset Turnover
Asset turnover exhibits more volatility compared to net profit margin. Initial values around 1.06 to 1.09 during 2013 and 2014 indicate steady efficiency in using assets to generate revenue. There is an unusual spike in early 2016, with values reaching as high as 3.48, before gradually declining to approximately 1.6 to 1.8 from 2017 onward. This pattern suggests some exceptional events or accounting adjustments in 2016 that temporarily inflated asset turnover, followed by normalization to a moderate efficiency level.
Financial Leverage
Financial leverage data is available only up to late 2014. Over this period, leverage ratios decrease gradually from 4.66 to a low of 3.62, then slightly increase back to around 3.85 by the end of the timeline. This indicates a reduction in the use of debt relative to equity initially, followed by a stabilization or mild increase, reflecting cautious management of capital structure.
Return on Equity (ROE)
ROE data is also limited to the early part of the timeline, primarily from 2014 to 2015. Throughout these periods, ROE remains in the range of approximately 16.4% to 19.5%, showing strong and consistent profitability related to shareholders’ equity. The highest values occur around mid-2014, suggesting effective use of equity to generate returns during that time frame.

Overall, the company's profitability demonstrated by net profit margin and ROE is solid with signs of improvement in recent years. The asset turnover shows potential volatility and unusual spikes that may warrant further investigation. Financial leverage decreased over time, indicating a possibly more conservative financing approach. These dynamics collectively describe a business improving profitability while managing asset efficiency and financial risk cautiously.


Two-Component Disaggregation of ROA

HP Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Jul 31, 2019 = ×
Apr 30, 2019 = ×
Jan 31, 2019 = ×
Oct 31, 2018 = ×
Jul 31, 2018 = ×
Apr 30, 2018 = ×
Jan 31, 2018 = ×
Oct 31, 2017 = ×
Jul 31, 2017 = ×
Apr 30, 2017 = ×
Jan 31, 2017 = ×
Oct 31, 2016 = ×
Jul 31, 2016 = ×
Apr 30, 2016 = ×
Jan 31, 2016 = ×
Oct 31, 2015 = ×
Jul 31, 2015 = ×
Apr 30, 2015 = ×
Jan 31, 2015 = ×
Oct 31, 2014 = ×
Jul 31, 2014 = ×
Apr 30, 2014 = ×
Jan 31, 2014 = ×
Oct 31, 2013 = ×
Jul 31, 2013 = ×
Apr 30, 2013 = ×
Jan 31, 2013 = ×

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


The analysis of the quarterly financial data reveals several notable trends across the three key performance indicators over the examined periods.

Net Profit Margin
This metric shows a generally stable pattern in the early periods, maintaining levels slightly above 4.5%. Starting around early 2016, there is a steady upward shift, with margins improving gradually to reach a peak of over 9% by early 2019. This suggests an improvement in profitability, with the company enhancing its efficiency in generating profits from sales over time.
Asset Turnover
The asset turnover ratio demonstrates minor fluctuations in the earlier periods, mostly hovering just above 1.0, indicating consistent use of assets to generate revenue. A notable yet brief surge occurs around early 2016, where the ratio jumps significantly before gradually declining back toward figures closer to 1.6–1.8 in later quarters. This pattern may reflect periods of increased asset utilization efficiency followed by normalization.
Return on Assets (ROA)
Return on assets follows a similarly variable trajectory, initially moderate around 4.8% to 5.3%. Subsequently, a sharp rise is observed beginning in early 2016, peaking above 15% before stabilizing around 12-13% in later periods. The pronounced increase aligns with improved profitability and asset utilization, signaling enhanced overall effectiveness in leveraging assets to generate returns.

In summary, the company experienced a phase of advancing profitability and asset efficiency beginning around early 2016, as evidenced by rising net profit margins, fluctuating but generally improving asset turnover, and significantly higher returns on assets. These indicators collectively point to improved operational performance and financial health over the examined timeframe.