Analysis of Short-term (Operating) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
Keurig Dr Pepper Inc., short-term (operating) activity ratios (quarterly data)
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Keurig Dr Pepper Inc. inventory turnover ratio deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Keurig Dr Pepper Inc. receivables turnover ratio deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Keurig Dr Pepper Inc. payables turnover ratio decreased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Keurig Dr Pepper Inc. number of days of inventory outstanding deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Keurig Dr Pepper Inc. number of days of receivables outstanding deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Keurig Dr Pepper Inc. operating cycle deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Keurig Dr Pepper Inc. number of days of payables outstanding increased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Keurig Dr Pepper Inc. cash conversion cycle deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Inventory Turnover
Keurig Dr Pepper Inc., inventory turnover calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||
| Cost of sales | 1,778) | 1,428) | 1,619) | 1,415) | 1,370) | 1,302) | 1,353) | 1,316) | 1,302) | 1,161) | 1,241) | 1,245) | 1,186) | 1,106) | |||||
| Inventories | 1,239) | 1,045) | 894) | 972) | 897) | 841) | 762) | 824) | 747) | 682) | 654) | 751) | 686) | 663) | |||||
| Short-term Activity Ratio | |||||||||||||||||||
| Inventory turnover1 | 5.04 | 5.58 | 6.38 | 5.60 | 5.95 | 6.27 | 6.73 | 6.09 | 6.63 | 7.09 | 7.31 | — | — | — | |||||
| Benchmarks | |||||||||||||||||||
| Inventory Turnover, Competitors2 | |||||||||||||||||||
| Altria Group Inc. | 5.93 | 5.73 | 5.96 | 6.41 | 4.10 | 3.72 | 3.98 | 4.10 | 3.96 | 3.83 | 3.09 | — | — | — | |||||
| Coca-Cola Co. | 4.69 | 4.26 | 4.50 | 4.67 | 4.37 | 4.04 | 4.11 | 4.11 | 3.92 | 4.11 | 4.33 | — | — | — | |||||
| Mondelēz International Inc. | 6.12 | 6.33 | 6.45 | 5.84 | 5.67 | 6.13 | 6.10 | 5.59 | 5.84 | 6.49 | 6.10 | — | — | — | |||||
| PepsiCo Inc. | 7.26 | 7.95 | 8.53 | 8.11 | 6.82 | 7.10 | 7.62 | 7.43 | 7.01 | 8.49 | 9.03 | — | — | — | |||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2022 Calculation
Inventory turnover
= (Cost of salesQ2 2022
+ Cost of salesQ1 2022
+ Cost of salesQ4 2021
+ Cost of salesQ3 2021)
÷ Inventories
= (1,778 + 1,428 + 1,619 + 1,415)
÷ 1,239 = 5.04
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Keurig Dr Pepper Inc. inventory turnover ratio deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Receivables Turnover
Keurig Dr Pepper Inc., receivables turnover calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||
| Net sales | 3,554) | 3,078) | 3,391) | 3,250) | 3,140) | 2,902) | 3,121) | 3,020) | 2,864) | 2,613) | 2,934) | 2,870) | 2,812) | 2,504) | |||||
| Trade accounts receivable, net | 1,326) | 1,214) | 1,148) | 1,138) | 1,075) | 1,065) | 1,048) | 1,051) | 1,010) | 1,037) | 1,115) | 1,090) | 1,068) | 1,016) | |||||
| Short-term Activity Ratio | |||||||||||||||||||
| Receivables turnover1 | 10.01 | 10.59 | 11.05 | 10.91 | 11.33 | 11.18 | 11.09 | 10.88 | 11.17 | 10.83 | 9.97 | — | — | — | |||||
| Benchmarks | |||||||||||||||||||
| Receivables Turnover, Competitors2 | |||||||||||||||||||
| Altria Group Inc. | 592.47 | 562.37 | 553.47 | 723.94 | 199.99 | 181.90 | 190.90 | 171.23 | 182.78 | 175.79 | 165.20 | — | — | — | |||||
| Coca-Cola Co. | 9.19 | 8.65 | 11.01 | 9.72 | 9.02 | 8.89 | 10.50 | 8.75 | 8.92 | 8.39 | 9.38 | — | — | — | |||||
| Mondelēz International Inc. | 12.11 | 9.94 | 12.29 | 10.61 | 12.51 | 10.21 | 11.57 | 10.52 | 13.08 | 9.91 | 11.69 | — | — | — | |||||
| PepsiCo Inc. | 7.80 | 8.58 | 9.16 | 8.03 | 7.67 | 8.03 | 8.37 | 7.38 | 7.71 | 8.04 | 8.59 | — | — | — | |||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2022 Calculation
Receivables turnover
= (Net salesQ2 2022
+ Net salesQ1 2022
+ Net salesQ4 2021
+ Net salesQ3 2021)
÷ Trade accounts receivable, net
= (3,554 + 3,078 + 3,391 + 3,250)
÷ 1,326 = 10.01
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Keurig Dr Pepper Inc. receivables turnover ratio deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Payables Turnover
Keurig Dr Pepper Inc., payables turnover calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||
| Cost of sales | 1,778) | 1,428) | 1,619) | 1,415) | 1,370) | 1,302) | 1,353) | 1,316) | 1,302) | 1,161) | 1,241) | 1,245) | 1,186) | 1,106) | |||||
| Accounts payable | 4,950) | 4,510) | 4,316) | 4,072) | 3,976) | 3,871) | 3,740) | 3,517) | 3,377) | 3,238) | 3,176) | 2,976) | 2,909) | 2,558) | |||||
| Short-term Activity Ratio | |||||||||||||||||||
| Payables turnover1 | 1.26 | 1.29 | 1.32 | 1.34 | 1.34 | 1.36 | 1.37 | 1.43 | 1.47 | 1.49 | 1.50 | — | — | — | |||||
| Benchmarks | |||||||||||||||||||
| Payables Turnover, Competitors2 | |||||||||||||||||||
| Altria Group Inc. | 17.13 | 18.36 | 15.86 | 27.28 | 28.31 | 26.76 | 20.57 | 21.92 | 27.77 | 27.63 | 21.80 | — | — | — | |||||
| Mondelēz International Inc. | 2.74 | 2.48 | 2.60 | 2.63 | 2.60 | 2.53 | 2.60 | 2.83 | 2.90 | 2.85 | 2.65 | — | — | — | |||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2022 Calculation
Payables turnover
= (Cost of salesQ2 2022
+ Cost of salesQ1 2022
+ Cost of salesQ4 2021
+ Cost of salesQ3 2021)
÷ Accounts payable
= (1,778 + 1,428 + 1,619 + 1,415)
÷ 4,950 = 1.26
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Keurig Dr Pepper Inc. payables turnover ratio decreased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Working Capital Turnover
Keurig Dr Pepper Inc., working capital turnover calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||
| Current assets | 3,771) | 3,490) | 3,057) | 2,803) | 2,616) | 2,665) | 2,388) | 2,416) | 2,240) | 2,277) | 2,273) | 2,269) | 2,221) | 2,162) | |||||
| Less: Current liabilities | 6,761) | 6,448) | 6,485) | 6,795) | 6,917) | 7,225) | 7,694) | 7,329) | 7,298) | 6,858) | 6,474) | 6,550) | 6,695) | 6,656) | |||||
| Working capital | (2,990) | (2,958) | (3,428) | (3,992) | (4,301) | (4,560) | (5,306) | (4,913) | (5,058) | (4,581) | (4,201) | (4,281) | (4,474) | (4,494) | |||||
| Net sales | 3,554) | 3,078) | 3,391) | 3,250) | 3,140) | 2,902) | 3,121) | 3,020) | 2,864) | 2,613) | 2,934) | 2,870) | 2,812) | 2,504) | |||||
| Short-term Activity Ratio | |||||||||||||||||||
| Working capital turnover1 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||
| Benchmarks | |||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||
| Altria Group Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||
| Coca-Cola Co. | 15.83 | 11.91 | 14.90 | 4.58 | 5.07 | 6.14 | 7.12 | 9.51 | 13.61 | — | — | — | — | — | |||||
| Mondelēz International Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||
| PepsiCo Inc. | — | — | — | — | — | — | — | — | — | 31.12 | — | — | — | — | |||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2022 Calculation
Working capital turnover
= (Net salesQ2 2022
+ Net salesQ1 2022
+ Net salesQ4 2021
+ Net salesQ3 2021)
÷ Working capital
= (3,554 + 3,078 + 3,391 + 3,250)
÷ -2,990 = —
2 Click competitor name to see calculations.
Average Inventory Processing Period
Keurig Dr Pepper Inc., average inventory processing period calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||
| Inventory turnover | 5.04 | 5.58 | 6.38 | 5.60 | 5.95 | 6.27 | 6.73 | 6.09 | 6.63 | 7.09 | 7.31 | — | — | — | |||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||
| Average inventory processing period1 | 72 | 65 | 57 | 65 | 61 | 58 | 54 | 60 | 55 | 52 | 50 | — | — | — | |||||
| Benchmarks (no. days) | |||||||||||||||||||
| Average Inventory Processing Period, Competitors2 | |||||||||||||||||||
| Altria Group Inc. | 62 | 64 | 61 | 57 | 89 | 98 | 92 | 89 | 92 | 95 | 118 | — | — | — | |||||
| Coca-Cola Co. | 78 | 86 | 81 | 78 | 84 | 90 | 89 | 89 | 93 | 89 | 84 | — | — | — | |||||
| Mondelēz International Inc. | 60 | 58 | 57 | 62 | 64 | 60 | 60 | 65 | 62 | 56 | 60 | — | — | — | |||||
| PepsiCo Inc. | 50 | 46 | 43 | 45 | 54 | 51 | 48 | 49 | 52 | 43 | 40 | — | — | — | |||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2022 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 5.04 = 72
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Keurig Dr Pepper Inc. number of days of inventory outstanding deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Average Receivable Collection Period
Keurig Dr Pepper Inc., average receivable collection period calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||
| Receivables turnover | 10.01 | 10.59 | 11.05 | 10.91 | 11.33 | 11.18 | 11.09 | 10.88 | 11.17 | 10.83 | 9.97 | — | — | — | |||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||
| Average receivable collection period1 | 36 | 34 | 33 | 33 | 32 | 33 | 33 | 34 | 33 | 34 | 37 | — | — | — | |||||
| Benchmarks (no. days) | |||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | |||||||||||||||||||
| Altria Group Inc. | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | — | — | — | |||||
| Coca-Cola Co. | 40 | 42 | 33 | 38 | 40 | 41 | 35 | 42 | 41 | 43 | 39 | — | — | — | |||||
| Mondelēz International Inc. | 30 | 37 | 30 | 34 | 29 | 36 | 32 | 35 | 28 | 37 | 31 | — | — | — | |||||
| PepsiCo Inc. | 47 | 43 | 40 | 45 | 48 | 45 | 44 | 49 | 47 | 45 | 43 | — | — | — | |||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2022 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 10.01 = 36
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Keurig Dr Pepper Inc. number of days of receivables outstanding deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Operating Cycle
Keurig Dr Pepper Inc., operating cycle calculation (quarterly data)
No. days
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||
| Average inventory processing period | 72 | 65 | 57 | 65 | 61 | 58 | 54 | 60 | 55 | 52 | 50 | — | — | — | |||||
| Average receivable collection period | 36 | 34 | 33 | 33 | 32 | 33 | 33 | 34 | 33 | 34 | 37 | — | — | — | |||||
| Short-term Activity Ratio | |||||||||||||||||||
| Operating cycle1 | 108 | 99 | 90 | 98 | 93 | 91 | 87 | 94 | 88 | 86 | 87 | — | — | — | |||||
| Benchmarks | |||||||||||||||||||
| Operating Cycle, Competitors2 | |||||||||||||||||||
| Altria Group Inc. | 63 | 65 | 62 | 58 | 91 | 100 | 94 | 91 | 94 | 97 | 120 | — | — | — | |||||
| Coca-Cola Co. | 118 | 128 | 114 | 116 | 124 | 131 | 124 | 131 | 134 | 132 | 123 | — | — | — | |||||
| Mondelēz International Inc. | 90 | 95 | 87 | 96 | 93 | 96 | 92 | 100 | 90 | 93 | 91 | — | — | — | |||||
| PepsiCo Inc. | 97 | 89 | 83 | 90 | 102 | 96 | 92 | 98 | 99 | 88 | 83 | — | — | — | |||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2022 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 72 + 36 = 108
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Keurig Dr Pepper Inc. operating cycle deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Average Payables Payment Period
Keurig Dr Pepper Inc., average payables payment period calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||
| Payables turnover | 1.26 | 1.29 | 1.32 | 1.34 | 1.34 | 1.36 | 1.37 | 1.43 | 1.47 | 1.49 | 1.50 | — | — | — | |||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||
| Average payables payment period1 | 290 | 282 | 276 | 273 | 272 | 268 | 266 | 256 | 249 | 245 | 243 | — | — | — | |||||
| Benchmarks (no. days) | |||||||||||||||||||
| Average Payables Payment Period, Competitors2 | |||||||||||||||||||
| Altria Group Inc. | 21 | 20 | 23 | 13 | 13 | 14 | 18 | 17 | 13 | 13 | 17 | — | — | — | |||||
| Mondelēz International Inc. | 133 | 147 | 141 | 139 | 140 | 144 | 140 | 129 | 126 | 128 | 138 | — | — | — | |||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2022 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 1.26 = 290
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Keurig Dr Pepper Inc. number of days of payables outstanding increased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Cash Conversion Cycle
Keurig Dr Pepper Inc., cash conversion cycle calculation (quarterly data)
No. days
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||
| Average inventory processing period | 72 | 65 | 57 | 65 | 61 | 58 | 54 | 60 | 55 | 52 | 50 | — | — | — | |||||
| Average receivable collection period | 36 | 34 | 33 | 33 | 32 | 33 | 33 | 34 | 33 | 34 | 37 | — | — | — | |||||
| Average payables payment period | 290 | 282 | 276 | 273 | 272 | 268 | 266 | 256 | 249 | 245 | 243 | — | — | — | |||||
| Short-term Activity Ratio | |||||||||||||||||||
| Cash conversion cycle1 | -182 | -183 | -186 | -175 | -179 | -177 | -179 | -162 | -161 | -159 | -156 | — | — | — | |||||
| Benchmarks | |||||||||||||||||||
| Cash Conversion Cycle, Competitors2 | |||||||||||||||||||
| Altria Group Inc. | 42 | 45 | 39 | 45 | 78 | 86 | 76 | 74 | 81 | 84 | 103 | — | — | — | |||||
| Mondelēz International Inc. | -43 | -52 | -54 | -43 | -47 | -48 | -48 | -29 | -36 | -35 | -47 | — | — | — | |||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2022 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 72 + 36 – 290 = -182
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Keurig Dr Pepper Inc. cash conversion cycle deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |