Stock Analysis on Net

Chipotle Mexican Grill Inc. (NYSE:CMG)

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

Chipotle Mexican Grill Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 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
Turnover Ratios
Inventory turnover 161.15 218.61 197.22 185.34 175.86 191.68 194.58 184.27 191.96 214.37 203.97 177.91 195.78 213.29 211.26 186.94 189.01 191.72 195.93 170.29
Receivables turnover 117.86 109.32 113.59 85.44 134.08 152.24 136.37 80.79 118.06 97.41 87.64 75.77 94.54 90.40 92.26 57.27 83.86 82.63 89.64 69.36
Payables turnover 36.30 38.20 38.02 36.86 34.04 42.59 36.87 35.61 38.60 39.82 36.05 35.79 32.44 38.26 34.83 40.52 30.59 28.88 35.06 38.37
Working capital turnover 17.10 14.35 15.74 16.73 16.40 16.17 24.45 34.00 32.42 37.95 29.78 14.86 10.78 11.18 10.14 10.01 14.20 13.16 13.89 13.77
Average No. Days
Average inventory processing period 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
Add: Average receivable collection period 3 3 3 4 3 2 3 5 3 4 4 5 4 4 4 6 4 4 4 5
Operating cycle 5 5 5 6 5 4 5 7 5 6 6 7 6 6 6 8 6 6 6 7
Less: Average payables payment period 10 10 10 10 11 9 10 10 9 9 10 10 11 10 10 9 12 13 10 10
Cash conversion cycle -5 -5 -5 -4 -6 -5 -5 -3 -4 -3 -4 -3 -5 -4 -4 -1 -6 -7 -4 -3

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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. Chipotle Mexican Grill Inc. inventory turnover ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.
Receivables turnover An activity ratio equal to revenue divided by receivables. Chipotle Mexican Grill Inc. receivables turnover ratio deteriorated from Q1 2024 to Q2 2024 but then improved from Q2 2024 to Q3 2024 exceeding Q1 2024 level.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Chipotle Mexican Grill Inc. payables turnover ratio increased from Q1 2024 to Q2 2024 but then decreased significantly from Q2 2024 to Q3 2024.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Chipotle Mexican Grill Inc. working capital turnover ratio deteriorated from Q1 2024 to Q2 2024 but then improved from Q2 2024 to Q3 2024 exceeding Q1 2024 level.

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.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover.
Operating cycle Equal to average inventory processing period plus average receivables collection period.
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.
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.

Inventory Turnover

Chipotle Mexican Grill Inc., inventory turnover calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 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 thousands)
Restaurant operating costs, exclusive of depreciation and amortization 2,081,395 2,113,717 1,959,998 1,878,016 1,822,105 1,823,946 1,761,490 1,658,057 1,657,629 1,655,254 1,601,593 1,564,615 1,492,962 1,429,656 1,352,819 1,294,483 1,289,189 1,197,976 1,161,905 1,163,779 1,111,809 1,134,569 1,033,722
Inventory 49,848 35,560 37,947 39,309 40,177 36,004 34,599 35,668 33,752 29,456 29,852 32,826 28,450 25,159 24,304 26,445 25,464 24,178 23,335 26,096 23,871 21,144 18,780
Short-term Activity Ratio
Inventory turnover1 161.15 218.61 197.22 185.34 175.86 191.68 194.58 184.27 191.96 214.37 203.97 177.91 195.78 213.29 211.26 186.94 189.01 191.72 195.93 170.29
Benchmarks
Inventory Turnover, Competitors2
McDonald’s Corp. 156.14 180.84 181.22 155.76 168.52 146.30 142.62 141.94 175.32 183.32 165.10 144.74 156.70 159.38 155.54 136.62 158.76 166.87 195.07 154.59
Starbucks Corp. 14.25 15.15 16.09 14.46 12.95 12.54 11.70 10.97 10.97 11.79 13.24 12.89 12.64 12.25 12.45 11.90 11.80 13.06 13.72 12.44 12.24 12.56 13.20

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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 Q3 2024 Calculation
Inventory turnover = (Restaurant operating costs, exclusive of depreciation and amortizationQ3 2024 + Restaurant operating costs, exclusive of depreciation and amortizationQ2 2024 + Restaurant operating costs, exclusive of depreciation and amortizationQ1 2024 + Restaurant operating costs, exclusive of depreciation and amortizationQ4 2023) ÷ Inventory
= (2,081,395 + 2,113,717 + 1,959,998 + 1,878,016) ÷ 49,848 = 161.15

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. Chipotle Mexican Grill Inc. inventory turnover ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.

Receivables Turnover

Chipotle Mexican Grill Inc., receivables turnover calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 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 thousands)
Revenue 2,793,576 2,973,117 2,701,848 2,516,320 2,471,948 2,514,801 2,368,580 2,180,599 2,220,175 2,213,339 2,020,539 1,960,633 1,952,315 1,892,538 1,741,575 1,607,710 1,601,414 1,364,738 1,410,772 1,440,224 1,403,697 1,434,231 1,308,217
Accounts receivable, net 93,202 97,542 89,836 115,535 71,122 60,985 65,869 106,880 71,276 83,636 89,295 99,599 76,099 75,697 68,449 104,500 69,366 68,006 63,461 80,545 49,489 49,362 49,725
Short-term Activity Ratio
Receivables turnover1 117.86 109.32 113.59 85.44 134.08 152.24 136.37 80.79 118.06 97.41 87.64 75.77 94.54 90.40 92.26 57.27 83.86 82.63 89.64 69.36
Benchmarks
Receivables Turnover, Competitors2
Airbnb Inc. 51.62 50.75 48.31 39.83 39.84 34.42 38.36 42.00 45.08 36.09 42.42 42.04
Booking Holdings Inc. 6.32 5.87 6.68 6.57 5.98 6.90 8.87 7.67 7.01 6.51 7.77 8.07 5.93 5.57 9.64 12.85 10.36 19.96 21.76 8.97
McDonald’s Corp. 4.04 4.10 4.41 3.92 4.22 4.12 4.18 4.14 4.80 5.20 5.93 5.23 5.19 5.07 4.77 3.86 3.46 2.94 5.43 4.24
Starbucks Corp. 31.83 32.90 31.49 30.38 30.71 28.67 28.30 27.44 27.91 31.27 29.45 30.92 29.76 27.09 26.09 26.62 27.31 28.33 29.70 30.15 32.97 36.32 35.04

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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 Q3 2024 Calculation
Receivables turnover = (RevenueQ3 2024 + RevenueQ2 2024 + RevenueQ1 2024 + RevenueQ4 2023) ÷ Accounts receivable, net
= (2,793,576 + 2,973,117 + 2,701,848 + 2,516,320) ÷ 93,202 = 117.86

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. Chipotle Mexican Grill Inc. receivables turnover ratio deteriorated from Q1 2024 to Q2 2024 but then improved from Q2 2024 to Q3 2024 exceeding Q1 2024 level.

Payables Turnover

Chipotle Mexican Grill Inc., payables turnover calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 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 thousands)
Restaurant operating costs, exclusive of depreciation and amortization 2,081,395 2,113,717 1,959,998 1,878,016 1,822,105 1,823,946 1,761,490 1,658,057 1,657,629 1,655,254 1,601,593 1,564,615 1,492,962 1,429,656 1,352,819 1,294,483 1,289,189 1,197,976 1,161,905 1,163,779 1,111,809 1,134,569 1,033,722
Accounts payable 221,301 203,480 196,866 197,646 207,541 162,041 182,606 184,566 167,842 158,581 168,905 163,161 171,712 140,251 147,417 121,990 157,324 160,523 130,423 115,816 118,483 99,007 106,214
Short-term Activity Ratio
Payables turnover1 36.30 38.20 38.02 36.86 34.04 42.59 36.87 35.61 38.60 39.82 36.05 35.79 32.44 38.26 34.83 40.52 30.59 28.88 35.06 38.37
Benchmarks
Payables Turnover, Competitors2
Booking Holdings Inc. 5.67 5.70 6.73 6.14 6.83 9.11 8.52 6.82 7.52 6.54 8.32 6.91 6.29 6.98 9.91 9.25 7.99 19.44 15.68 12.16
McDonald’s Corp. 8.93 8.77 8.91 7.46 9.30 9.50 9.05 7.53 9.57 10.74 11.40 7.99 10.16 10.42 10.52 9.42 10.18 13.20 11.35 7.85
Starbucks Corp. 16.66 17.76 18.13 16.92 17.11 17.49 18.12 16.57 15.70 17.03 16.81 17.06 17.36 17.82 17.44 18.50 21.71 19.54 17.80 15.99 16.22 16.53 16.25

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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 Q3 2024 Calculation
Payables turnover = (Restaurant operating costs, exclusive of depreciation and amortizationQ3 2024 + Restaurant operating costs, exclusive of depreciation and amortizationQ2 2024 + Restaurant operating costs, exclusive of depreciation and amortizationQ1 2024 + Restaurant operating costs, exclusive of depreciation and amortizationQ4 2023) ÷ Accounts payable
= (2,081,395 + 2,113,717 + 1,959,998 + 1,878,016) ÷ 221,301 = 36.30

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. Chipotle Mexican Grill Inc. payables turnover ratio increased from Q1 2024 to Q2 2024 but then decreased significantly from Q2 2024 to Q3 2024.

Working Capital Turnover

Chipotle Mexican Grill Inc., working capital turnover calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 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 thousands)
Current assets 1,680,256 1,786,298 1,645,769 1,620,713 1,669,343 1,556,419 1,261,442 1,175,837 1,077,432 1,046,299 1,096,493 1,381,564 1,518,606 1,447,810 1,456,851 1,420,237 1,211,280 1,150,343 1,075,501 1,072,204 954,756 832,402 837,746
Less: Current liabilities 1,037,884 1,043,156 997,353 1,030,625 1,087,707 982,250 894,092 921,880 817,857 831,623 833,738 873,682 850,964 835,486 834,004 822,199 801,717 723,178 665,795 666,593 634,019 548,268 581,667
Working capital 642,372 743,142 648,416 590,088 581,636 574,169 367,350 253,957 259,575 214,676 262,755 507,882 667,642 612,324 622,847 598,038 409,563 427,165 409,706 405,611 320,737 284,134 256,079
 
Revenue 2,793,576 2,973,117 2,701,848 2,516,320 2,471,948 2,514,801 2,368,580 2,180,599 2,220,175 2,213,339 2,020,539 1,960,633 1,952,315 1,892,538 1,741,575 1,607,710 1,601,414 1,364,738 1,410,772 1,440,224 1,403,697 1,434,231 1,308,217
Short-term Activity Ratio
Working capital turnover1 17.10 14.35 15.74 16.73 16.40 16.17 24.45 34.00 32.42 37.95 29.78 14.86 10.78 11.18 10.14 10.01 14.20 13.16 13.89 13.77
Benchmarks
Working Capital Turnover, Competitors2
Airbnb Inc. 1.55 1.64 1.64 1.51 1.25 1.41 1.31 1.22 1.17 1.13 1.10 0.99
Booking Holdings Inc. 5.99 7.26 6.04 5.77 3.65 2.82 2.77 2.33 4.14 3.16 2.32 1.59 1.07 1.02 0.74 0.77 1.03 1.50 2.83 3.37
McDonald’s Corp. 33.38 8.64 3.33 7.11 3.99 5.39 4.03 6.64 23.54 3.13 5.58 5.19 9.32 131.28 18.14 2.58
Starbucks Corp. 18.11 205.59 50.26 48.92 51.17 14.17 11.24

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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 Q3 2024 Calculation
Working capital turnover = (RevenueQ3 2024 + RevenueQ2 2024 + RevenueQ1 2024 + RevenueQ4 2023) ÷ Working capital
= (2,793,576 + 2,973,117 + 2,701,848 + 2,516,320) ÷ 642,372 = 17.10

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. Chipotle Mexican Grill Inc. working capital turnover ratio deteriorated from Q1 2024 to Q2 2024 but then improved from Q2 2024 to Q3 2024 exceeding Q1 2024 level.

Average Inventory Processing Period

Chipotle Mexican Grill Inc., average inventory processing period calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 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 161.15 218.61 197.22 185.34 175.86 191.68 194.58 184.27 191.96 214.37 203.97 177.91 195.78 213.29 211.26 186.94 189.01 191.72 195.93 170.29
Short-term Activity Ratio (no. days)
Average inventory processing period1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
McDonald’s Corp. 2 2 2 2 2 2 3 3 2 2 2 3 2 2 2 3 2 2 2 2
Starbucks Corp. 26 24 23 25 28 29 31 33 33 31 28 28 29 30 29 31 31 28 27 29 30 29 28

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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 Q3 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 161.15 = 2

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.

Average Receivable Collection Period

Chipotle Mexican Grill Inc., average receivable collection period calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 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 117.86 109.32 113.59 85.44 134.08 152.24 136.37 80.79 118.06 97.41 87.64 75.77 94.54 90.40 92.26 57.27 83.86 82.63 89.64 69.36
Short-term Activity Ratio (no. days)
Average receivable collection period1 3 3 3 4 3 2 3 5 3 4 4 5 4 4 4 6 4 4 4 5
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Airbnb Inc. 7 7 8 9 9 11 10 9 8 10 9 9
Booking Holdings Inc. 58 62 55 56 61 53 41 48 52 56 47 45 62 66 38 28 35 18 17 41
McDonald’s Corp. 90 89 83 93 87 89 87 88 76 70 62 70 70 72 76 95 106 124 67 86
Starbucks Corp. 11 11 12 12 12 13 13 13 13 12 12 12 12 13 14 14 13 13 12 12 11 10 10

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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 Q3 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 117.86 = 3

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.

Operating Cycle

Chipotle Mexican Grill Inc., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 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 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
Average receivable collection period 3 3 3 4 3 2 3 5 3 4 4 5 4 4 4 6 4 4 4 5
Short-term Activity Ratio
Operating cycle1 5 5 5 6 5 4 5 7 5 6 6 7 6 6 6 8 6 6 6 7
Benchmarks
Operating Cycle, Competitors2
McDonald’s Corp. 92 91 85 95 89 91 90 91 78 72 64 73 72 74 78 98 108 126 69 88
Starbucks Corp. 37 35 35 37 40 42 44 46 46 43 40 40 41 43 43 45 44 41 39 41 41 39 38

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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 Q3 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 2 + 3 = 5

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.

Average Payables Payment Period

Chipotle Mexican Grill Inc., average payables payment period calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 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 36.30 38.20 38.02 36.86 34.04 42.59 36.87 35.61 38.60 39.82 36.05 35.79 32.44 38.26 34.83 40.52 30.59 28.88 35.06 38.37
Short-term Activity Ratio (no. days)
Average payables payment period1 10 10 10 10 11 9 10 10 9 9 10 10 11 10 10 9 12 13 10 10
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Booking Holdings Inc. 64 64 54 59 53 40 43 54 49 56 44 53 58 52 37 39 46 19 23 30
McDonald’s Corp. 41 42 41 49 39 38 40 48 38 34 32 46 36 35 35 39 36 28 32 46
Starbucks Corp. 22 21 20 22 21 21 20 22 23 21 22 21 21 20 21 20 17 19 21 23 23 22 22

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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 Q3 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 36.30 = 10

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.

Cash Conversion Cycle

Chipotle Mexican Grill Inc., cash conversion cycle calculation (quarterly data)

No. days

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 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 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
Average receivable collection period 3 3 3 4 3 2 3 5 3 4 4 5 4 4 4 6 4 4 4 5
Average payables payment period 10 10 10 10 11 9 10 10 9 9 10 10 11 10 10 9 12 13 10 10
Short-term Activity Ratio
Cash conversion cycle1 -5 -5 -5 -4 -6 -5 -5 -3 -4 -3 -4 -3 -5 -4 -4 -1 -6 -7 -4 -3
Benchmarks
Cash Conversion Cycle, Competitors2
McDonald’s Corp. 51 49 44 46 50 53 50 43 40 38 32 27 36 39 43 59 72 98 37 42
Starbucks Corp. 15 14 15 15 19 21 24 24 23 22 18 19 20 23 22 25 27 22 18 18 18 17 16

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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 Q3 2024 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 2 + 310 = -5

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.