Common-Size Income Statement
Quarterly Data
Based on: 10-Q (reporting date: 2025-12-31), 10-Q (reporting date: 2025-09-30), 10-K (reporting date: 2025-06-30), 10-Q (reporting date: 2025-03-31), 10-Q (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-K (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30).
The common-size income statement reveals several noteworthy trends in the company’s financial performance over the analyzed period. Net sales are consistently represented as 100% by definition, allowing for a clear view of how other income statement items fluctuate as a percentage of revenue. Cost of products sold generally remained between 46% and 56% of net sales, exhibiting some volatility, particularly a peak in the period ending March 31, 2022. Gross profit as a percentage of net sales mirrored this trend, fluctuating between approximately 44% and 53%. Operating income demonstrated a similar pattern, ranging from roughly 15% to 28% of net sales, with a noticeable dip in the periods ending June 30, 2020, and June 30, 2021.
- Gross Profit Margin
- Gross profit margin experienced a decline from approximately 51% in the earlier periods (September 2019 - December 2019) to a low of around 44% in June 2022. It then showed some recovery, reaching approximately 51% by September 2023, before decreasing again to around 49% by June 2025. This suggests potential pressures on input costs or pricing strategies during certain periods.
- Operating Expense Management
- Selling, general, and administrative expenses consistently represented a significant portion of net sales, generally between 23% and 30%. A decrease in this percentage was observed from 2019-2021, followed by an increase in 2022-2023, and a subsequent decrease again in 2024-2025. This indicates fluctuations in the company’s operational spending relative to its revenue.
- Profitability
- Net earnings attributable to P&G as a percentage of net sales followed a similar trajectory to operating income, ranging from approximately 14% to 22%. A significant dip occurred in the period ending June 30, 2020, and again in June 2021, followed by a recovery and then a decline in 2022. The most recent periods (2024-2025) show a return to levels closer to those observed in 2021, but with some volatility. The impact of the indefinite-lived intangible asset impairment charge in December 2023 significantly reduced net earnings for that period.
- Interest and Other Income
- Interest expense remained relatively stable as a percentage of net sales, generally between 0.5% and 1.2%. Interest income showed an increasing trend over the period, rising from approximately 0.2% to 0.6% of net sales. Other non-operating income (expense), net, exhibited considerable fluctuation, ranging from negative to positive values, with a notable negative impact in December 2020 and a positive impact in March 2025. These fluctuations suggest the impact of various non-core business activities on the company’s overall profitability.
- Tax Rate
- The effective tax rate, as indicated by income taxes as a percentage of net sales, fluctuated between approximately 3% and 5.5%. The higher rates observed in September 2022 and March 2025 may be attributable to changes in tax laws or the geographic distribution of earnings.
Overall, the company’s profitability appears sensitive to changes in cost of products sold, operating expenses, and non-operating items. While revenue remained constant in percentage terms, the fluctuations in these other areas significantly impacted net earnings. The recent periods (2024-2025) suggest a potential stabilization of profitability, but continued monitoring of cost management and non-operating income is warranted.