Stock Analysis on Net

Procter & Gamble Co. (NYSE:PG)

Financial Reporting Quality: Aggregate Accruals

Microsoft Excel

Earnings can be decomposed into cash and accrual components. The accrual component (aggregate accruals) has been found to have less persistence than the cash component, and therefore (1) earnings with higher accrual component are less persistent than earnings with smaller accrual component, all else equal; and (2) the cash component of earnings should receive a higher weighting evaluating company performance.


Balance-Sheet-Based Accruals Ratio

Procter & Gamble Co., balance sheet computation of aggregate accruals

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Operating Assets
Total assets 120,829 117,208 119,307 120,700 115,095 118,310
Less: Cash and cash equivalents 8,246 7,214 10,288 16,181 4,239 2,569
Less: Available-for-sale investment securities 6,048 9,281
Operating assets 112,583 109,994 109,019 104,519 104,808 106,460
Operating Liabilities
Total liabilities 73,764 70,354 72,653 73,822 67,516 65,427
Less: Debt due within one year 10,229 8,645 8,889 11,183 9,697 10,423
Less: Long-term debt, excluding due within one year 24,378 22,848 23,099 23,537 20,395 20,863
Operating liabilities 39,157 38,861 40,665 39,102 37,424 34,141
 
Net operating assets1 73,426 71,133 68,354 65,417 67,384 72,319
Balance-sheet-based aggregate accruals2 2,293 2,779 2,937 (1,967) (4,935)
Financial Ratio
Balance-sheet-based accruals ratio3 3.17% 3.98% 4.39% -2.96% -7.06%
Benchmarks
Balance-Sheet-Based Accruals Ratio, Industry
Consumer Staples 2.32% 2.21% -1.91% -0.77% 200.00%

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

1 2023 Calculation
Net operating assets = Operating assets – Operating liabilities
= 112,58339,157 = 73,426

2 2023 Calculation
Balance-sheet-based aggregate accruals = Net operating assets2023 – Net operating assets2022
= 73,42671,133 = 2,293

3 2023 Calculation
Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × 2,293 ÷ [(73,426 + 71,133) ÷ 2] = 3.17%

Financial ratio Description The company
Balance-sheet-based accruals ratio Ratio is found by dividing balance-sheet-based aggregate accruals by average net operating assets. Using the balance-sheet-based accruals ratio, Procter & Gamble Co. improved earnings quality from 2022 to 2023.

Cash-Flow-Statement-Based Accruals Ratio

Procter & Gamble Co., cash flow statement computation of aggregate accruals

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Net earnings attributable to Procter & Gamble (P&G) 14,653 14,742 14,306 13,027 3,897 9,750
Less: Operating activities 16,848 16,723 18,371 17,403 15,242 14,867
Less: Investing activities (3,500) (4,424) (2,834) 3,045 (3,490) (3,511)
Cash-flow-statement-based aggregate accruals 1,305 2,443 (1,231) (7,421) (7,855) (1,606)
Financial Ratio
Cash-flow-statement-based accruals ratio1 1.81% 3.50% -1.84% -11.18% -11.25%
Benchmarks
Cash-Flow-Statement-Based Accruals Ratio, Industry
Consumer Staples 1.85% 0.51% -6.44% -1.92% -1.83%

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

1 2023 Calculation
Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × 1,305 ÷ [(73,426 + 71,133) ÷ 2] = 1.81%

Financial ratio Description The company
Cash-flow-statement-based accruals ratio Ratio is found by dividing cash-flow-statement-based aggregate accruals by average net operating assets. Using the cash-flow-statement-based accruals ratio, Procter & Gamble Co. improved earnings quality from 2022 to 2023.