Common-Size Balance Sheet: Assets
Quarterly Data
Procter & Gamble Co., common-size consolidated balance sheet: assets (quarterly data)
Based on: 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), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30).
- Cash and Cash Equivalents
- The percentage of cash and cash equivalents relative to total assets fluctuated notably, rising sharply from 2.15% in September 2018 to a peak of approximately 13.41% in June 2020. Following this peak, the ratio declined gradually, stabilizing around 6% to 9% in the subsequent periods up to March 2025. This suggests periods of increased liquidity, possibly in response to external factors, followed by a return to more typical levels.
- Available-for-Sale Investment Securities
- This asset category was only reported through the first half of 2019, showing a decreasing trend from 7.35% to 5.25% of total assets before data became unavailable. The diminishing proportion before the absence of data may indicate a reduction or disposal of these securities.
- Accounts Receivable
- Accounts receivable as a percentage of total assets remained relatively stable, generally oscillating between 4% and 5%, with only moderate variation. The data shows slight increases in several quarters, particularly toward the end of the observed period, reaching slightly above 5% by March 2025. This stability suggests consistent revenue collection patterns over time.
- Materials and Supplies
- The proportion of materials and supplies demonstrated a gradual upward trend, moving from 1.21% in September 2018 to peaks around 1.9% in late 2022 before a moderate reduction to about 1.57% by March 2025. This incremental increase implies a steady accumulation or higher valuation of raw materials on hand over time.
- Work in Process
- The percentage of work in process showed a steady, albeit modest, rise from 0.51% in September 2018 to approximately 0.78% by March 2025. This incremental increase reflects a gradual build-up of production at intermediate stages.
- Finished Goods
- Finished goods as a share of total assets generally increased over the sample period, from 2.66% in September 2018 to levels peaking near 3.83% in late 2022, followed by minor fluctuations settling around 3.6% in early 2025. This trend points to a larger inventory of completed products relative to total assets.
- Inventories (Aggregate)
- Total inventories showed a clear increasing trend, moving from 4.38% of total assets in September 2018 to over 6% by late 2022 and maintaining that elevated level through early 2025. This growth in inventories is consistent with the rises seen in its constituent parts (materials, work in process, and finished goods), indicating an overall expansion in stock holdings.
- Prepaid Expenses and Other Current Assets
- This category exhibited variability without a clear directional trend. Starting near 1.58% in late 2018, values fluctuated between roughly 1.3% and 2.0% throughout the years, with intermittent spikes and declines. This volatility may suggest the impact of periodic payments or adjustments in short-term assets other than inventories.
- Current Assets (Aggregate)
- Current assets as a proportion of total assets showed fluctuations, with percentages moving in a range from about 16.9% to 23.2%. Notably, there was an abrupt increase at the end of 2019 and mid-2020 periods, coinciding with elevated cash and cash equivalent ratios, before returning to more moderate levels around 19-21% in subsequent years. This pattern indicates variable liquidity and near-term asset management.
- Property, Plant and Equipment, Net
- Property, plant, and equipment represented a stable portion of total assets, generally ranging from 16.8% to 18.5%, with minor fluctuations. The secure and steady representation suggests consistent investment and maintenance in tangible fixed assets.
- Goodwill
- The percentage of goodwill declined from about 38.2% in September 2018 to approximately 32.9% by March 2025. Although this reduction was gradual, it reflects a slow decrease in this intangible asset component, possibly due to amortization, impairments, or revaluations post-acquisitions.
- Trademarks and Other Intangible Assets, Net
- This component displayed a moderate downward trend, decreasing from around 20.2% in 2018 to approximately 17.7% by early 2025. The steady reduction suggests gradual amortization or reclassification of intangible assets over the period.
- Other Noncurrent Assets
- Other noncurrent assets increased moderately from 4.53% in late 2018 to nearly 11% by the end of 2024 and early 2025. This continuous growth indicates the accumulation or revaluation of other long-term asset types, potentially including investments or deferred assets.
- Noncurrent Assets (Aggregate)
- Noncurrent assets consistently comprised the majority of total assets, broadly maintaining levels around 80%. While there was some variation (with a dip to around 77% during mid-2020), the overall stability indicates a strong emphasis on long-term asset holdings.
- Total Assets
- The analyses are based on the division of total assets, which remained constant at 100% as expected, facilitating the relative proportion assessments of each component over time.