Stock Analysis on Net

3M Co. (NYSE:MMM)

$22.49

This company has been moved to the archive! The financial data has not been updated since October 25, 2022.

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

Microsoft Excel

Short-term Activity Ratios (Summary)

3M Co., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018
Turnover Ratios
Inventory turnover
Receivables turnover
Payables turnover
Working capital turnover
Average No. Days
Average inventory processing period
Add: Average receivable collection period
Operating cycle
Less: Average payables payment period
Cash conversion cycle

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).


The analysis of the quarterly financial data reveals several trends in the company's operational efficiency and cash flow management over the observed periods.

Inventory Turnover
The inventory turnover ratio fluctuated moderately, generally staying within a range of approximately 3.45 to 4.21. Starting from around 3.8 in early 2018, it experienced slight increases and decreases through 2019 and 2020, but a gradual decline is evident towards the latter part of 2022, where it stabilized at around 3.45. This suggests a modest decline in the speed at which inventory is sold and replenished.
Receivables Turnover
Receivables turnover showed a generally positive trend, increasing from roughly 6.1 in early 2018 to about 7.36 by late 2022. This increase indicates improved efficiency in collecting accounts receivable over the period, with the collection period shortening, as also reflected in a decrease in the average receivable collection days.
Payables Turnover
Payables turnover displayed a declining trend, moving from higher values around 8.7-8.9 in early 2018 down to approximately 6.0-6.3 in 2022. Correspondingly, the average payables payment period extended from about 42 days initially to around 58-61 days towards the end. This signifies that the company has been taking longer to pay its suppliers over time.
Working Capital Turnover
The working capital turnover ratio showed variability across periods, with notable dips and spikes. Early 2019 saw a low near 3.13, followed by a substantial peak at 8.57 at the end of that year. Throughout 2020 to 2022, the ratio tended to increase gradually, reaching values above 6.0, suggesting progressively more efficient use of working capital in generating revenue.
Average Inventory Processing Period
Inventory processing days remained relatively stable, typically oscillating between 87 and 106 days. However, a mild trend towards an increased processing period is visible from 2021 into 2022, where days extended from mid-90s to above 100, indicating slightly slower inventory turnover.
Average Receivable Collection Period
The receivable collection period demonstrated a slight contraction over the analyzed timeframe, moving from around 59-61 days down to a consistent range near 50 days. This trend supports the earlier observation of improved receivables turnover efficiency.
Operating Cycle
The operating cycle, combining inventory and receivables periods, showed minor fluctuations but generally ranged between 140 and 157 days. There was some variability but no strong directional trend, indicating relative stability in the company's operating processes.
Average Payables Payment Period
This period expanded steadily over time, extending from low 40s in 2018 to near 60 days by 2022, matching the trend in payables turnover. It points to a deliberate extension in payment terms or slower supplier payments.
Cash Conversion Cycle
The cash conversion cycle demonstrated a gradual decline from around 113 days in 2018 to values close to 90-98 days in later periods. The reduction in this cycle is a positive sign, reflecting improved overall efficiency in cash flow management by shortening the time between outlays and collections.

In summary, the data indicates improving efficiency in managing receivables and working capital, coupled with a slower pace in paying suppliers. Inventory turnover and processing periods have remained relatively stable with slight negative shifts toward the end of the period. The shortening cash conversion cycle reflects a general trend toward more effective cash management practices over time.


Turnover Ratios


Average No. Days


Inventory Turnover

3M Co., inventory turnover calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018
Selected Financial Data (US$ in millions)
Cost of sales
Inventories
Short-term Activity Ratio
Inventory turnover1
Benchmarks
Inventory Turnover, Competitors2
Boeing Co.
Caterpillar Inc.
Eaton Corp. plc
GE Aerospace
Honeywell International Inc.
Lockheed Martin Corp.
RTX Corp.

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

1 Q3 2022 Calculation
Inventory turnover = (Cost of salesQ3 2022 + Cost of salesQ2 2022 + Cost of salesQ1 2022 + Cost of salesQ4 2021) ÷ Inventories
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


The analysis of the quarterly financial data reveals several notable trends in cost of sales, inventories, and inventory turnover over the observed periods.

Cost of Sales
The cost of sales figures demonstrate some fluctuations over the quarters. Initially, the values hover around the low to mid-4000 million US$ range, with slight increases and decreases observed throughout the timeline. There is a noticeable dip in the second and third quarters of 2020, with values dropping to approximately 3805 million and 4303 million respectively, likely reflecting external economic impacts during that period. Post-2020, the cost of sales trends upwards again, reaching peaks above 4800 million US$ towards the end of 2021 and into 2022, before slightly decreasing in the latest quarter reported.
Inventories
Inventories exhibit a generally increasing trend throughout the quarters. Starting from around 4295 million US$ in early 2018, inventories saw some short-term declines but resumed growth particularly beginning in 2021, accelerating through 2022, where inventory levels peak at above 5600 million US$. This rising inventory level may suggest building stock levels or changes in inventory management strategies.
Inventory Turnover
Inventory turnover ratios fluctuate between a low of approximately 3.45 and a high near 4.21 within the given timeframe. Noteworthy is the gradual downward trend in this ratio from 2018 into mid-2022, indicating a slower rate of inventory turnover over time. While the turnover ratio rose to its peak around late 2019, it steadily declines following that period, falling close to the lowest observed levels in the most recent data points. This suggests that inventory is being sold or used at a slower pace over time relative to inventory levels, which aligns with the rising trend in inventories.

In summary, the financial data indicate rising inventory levels accompanied by decreasing inventory turnover rates, alongside fluctuating cost of sales that show a dip during mid-2020 but recover thereafter. These patterns may reflect adjustments in supply chain dynamics, demand variability, or other operational factors impacting inventory management and cost structures over the reported periods.


Receivables Turnover

3M Co., receivables turnover calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018
Selected Financial Data (US$ in millions)
Net sales
Accounts receivable, net of allowances
Short-term Activity Ratio
Receivables turnover1
Benchmarks
Receivables Turnover, Competitors2
Boeing Co.
Caterpillar Inc.
Eaton Corp. plc
GE Aerospace
Honeywell International Inc.
Lockheed Martin Corp.
RTX Corp.

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

1 Q3 2022 Calculation
Receivables turnover = (Net salesQ3 2022 + Net salesQ2 2022 + Net salesQ1 2022 + Net salesQ4 2021) ÷ Accounts receivable, net of allowances
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


The analysis of the quarterly financial data reveals several key trends in net sales, accounts receivable, and receivables turnover over the observed periods.

Net Sales
The net sales figures exhibit some fluctuations throughout the periods without a consistent directional trend. Starting at 8,278 million US dollars in March 2018, net sales showed a mild increase towards mid-2018, peaking near 8,390 million US dollars. However, there was a notable dip towards the end of 2018, reaching approximately 7,945 million US dollars. Early 2020 witnessed a slight decline in sales, which is likely influenced by broader market conditions given the timing. Subsequently, sales recovered steadily during 2020 and early 2021, reaching the highest levels in this dataset at over 8,800 million US dollars. A mild decline is evident again toward the third quarter of 2022, ending just over 8,600 million US dollars.
Accounts Receivable, Net of Allowances
The accounts receivable values generally trend downward from early 2018 through mid-2020, starting at around 5,252 million US dollars and decreasing to a low point near 4,459 million US dollars in June 2020. This reduction may indicate improved collection practices or changes in credit terms. Following this low, accounts receivable show a recovery phase, increasing gradually to reach values slightly above 4,900 million US dollars by late 2021. A modest decline is again apparent nearing the last observed period, finishing near 4,722 million US dollars.
Receivables Turnover Ratio
The receivables turnover ratio generally improves over the period, implying enhanced efficiency in collections. Initially, the ratio hovered around 6.14 but showed some variability in 2018 and 2019. Notably, there is a clear upward trend starting in 2020, with the ratio increasing consistently from about 6.71 to approximately 7.36 by the latest quarter. Higher turnover ratios reflect faster collection of receivables, which complements the noting of decreased accounts receivable during the same periods.

In summary, the financial data portrays a company that faced some fluctuations in net sales and managed to enhance its receivables management significantly over time. The increase in receivables turnover and the controlled levels of accounts receivable suggest improved operational efficiency in credit and collections, which could have positive implications for cash flow and working capital management despite some volatility in sales volumes.


Payables Turnover

3M Co., payables turnover calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018
Selected Financial Data (US$ in millions)
Cost of sales
Accounts payable
Short-term Activity Ratio
Payables turnover1
Benchmarks
Payables Turnover, Competitors2
Boeing Co.
Caterpillar Inc.
Eaton Corp. plc
GE Aerospace
Honeywell International Inc.
Lockheed Martin Corp.
RTX Corp.

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

1 Q3 2022 Calculation
Payables turnover = (Cost of salesQ3 2022 + Cost of salesQ2 2022 + Cost of salesQ1 2022 + Cost of salesQ4 2021) ÷ Accounts payable
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


Cost of Sales
The cost of sales demonstrates a generally fluctuating pattern across the observed periods. Initially, values remain relatively steady around the low 4000 million US dollars mark from early 2018 to early 2019. Subsequently, a notable dip surfaces during the mid-2020 period, reaching a low point of 3805 million US dollars, likely influenced by specific market or operational challenges. Following this decline, the cost of sales progressively increases, peaking near 4853 million US dollars in late 2021 before showing a slight decrease toward the end of the dataset. This overall behavior suggests cyclical variations with episodic downward pressure possibly linked to external disruptions.
Accounts Payable
Accounts payable values reveal an upward trajectory throughout the timeline. Starting at 1874 million US dollars in the first quarter of 2018, the figure rises steadily, with some short-term volatility, to peak at 3273 million US dollars by mid-2022. The steady increase in accounts payable balances may indicate extended supplier credit terms or increased purchasing activity corresponding with operational scaling or inflationary effects.
Payables Turnover Ratio
The payables turnover ratio shows a declining trend over the span reviewed. Beginning at approximately 8.73 in early 2018, the ratio decreases gradually to values near 6.0 by mid-2022, with some minor rebounds. This diminishing ratio aligns with the rising trend in accounts payable and may signal slower payment cycles or lengthening of payment terms, reflecting either strategic working capital management or liquidity considerations.
Summary Insights
The concurrent increase in accounts payable coupled with a decrease in the payables turnover ratio suggests a notable shift in payment practices toward longer credit durations. While the cost of sales fluctuates with episodic dips and recoveries, the financial data collectively may denote responses to changing market conditions and internal financial strategy adaptations. Monitoring these metrics can provide further insight into cash flow dynamics and supplier relationship management.

Working Capital Turnover

3M Co., working capital turnover calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018
Selected Financial Data (US$ in millions)
Current assets
Less: Current liabilities
Working capital
 
Net sales
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
Boeing Co.
Caterpillar Inc.
Eaton Corp. plc
GE Aerospace
Honeywell International Inc.
Lockheed Martin Corp.
RTX Corp.

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

1 Q3 2022 Calculation
Working capital turnover = (Net salesQ3 2022 + Net salesQ2 2022 + Net salesQ1 2022 + Net salesQ4 2021) ÷ Working capital
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


Working Capital
The working capital exhibited notable fluctuations over the analyzed periods. After starting at $5,859 million in March 2018, it declined to $4,988 million by June 2018 before rising sharply to a peak of $10,199 million in September 2019. Subsequently, a marked decrease was observed towards the end of 2019, reaching $3,749 million in December. In 2020 and 2021, working capital generally stabilized within a narrower range between approximately $6,368 million and $7,034 million, but in 2022, it declined once again, ending at $5,352 million in September. This pattern suggests periods of increased investment or asset management adjustments followed by contraction phases.
Net Sales
Net sales displayed relative stability with slight volatility throughout the examined timeframe. The values oscillated within a range of roughly $7,863 million to $8,950 million. There was a small dip in the middle of 2019 and again in mid-2020, coinciding possibly with external market pressures. Noteworthy growth was seen at the start of 2021, peaking at $8,950 million in June 2021. Sales moderately decreased afterward, but generally maintained levels above $8,600 million towards the latter periods. This indicates a resilient revenue stream with manageable fluctuations.
Working Capital Turnover Ratio
The working capital turnover ratio showed significant variability, reflecting changes in operational efficiency and asset utilization. Starting at 5.5 in March 2018, it peaked at 8.57 by December 2019, suggesting a period of highly efficient working capital use. Afterwards, values moderated into a range of around 4.5 to 5.5 through 2020 and into early 2021. From mid-2021, there was a marked upward trend, reaching 7.6 by June 2022 before slightly receding to 6.5 in September 2022. This upward trajectory in recent quarters may indicate improved sales generation relative to working capital levels or enhanced asset management strategies.
Overall Insights
The data reveals a dynamic interplay between working capital and sales performance. Despite some fluctuations in working capital, net sales remained relatively stable, underpinning consistent revenue generation. The working capital turnover ratio's rise during certain periods highlights the company's ability to effectively leverage its current assets to support revenues, particularly in late 2019 and mid-2021 through mid-2022. However, the variability in working capital points to ongoing adjustments in short-term financial position, which may reflect strategic responses to operational demands or market conditions.

Average Inventory Processing Period

3M Co., average inventory processing period calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018
Selected Financial Data
Inventory turnover
Short-term Activity Ratio (no. days)
Average inventory processing period1
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Boeing Co.
Caterpillar Inc.
Eaton Corp. plc
GE Aerospace
Honeywell International Inc.
Lockheed Martin Corp.
RTX Corp.

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

1 Q3 2022 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ =

2 Click competitor name to see calculations.


The analysis of the inventory management metrics over the observed periods reveals notable trends in both inventory turnover and the average inventory processing period.

Inventory Turnover Ratio
The inventory turnover ratio exhibited fluctuations across the quarters. Starting at 3.81 in early 2018, it rose to a peak around the third quarter of 2019 at 4.21, indicating an improvement in inventory efficiency during that period. However, after this peak, the ratio generally declined, with some minor recoveries, descending to 3.45 by the third quarter of 2022. This downward trend suggests a gradual decrease in the frequency of inventory being sold and replaced over time, implying a potential slowdown in inventory movement or changes in sales dynamics.
Average Inventory Processing Period
The average inventory processing period, expressed in days, inversely mirrors the inventory turnover trend. Beginning at 96 days in early 2018, it improved to a low of 87 days around the third quarter of 2019, consistent with the higher turnover during that time. Post-2019, the processing period steadily lengthened, reaching 106 days by the third quarter of 2022. This increase reflects a longer duration for inventory to be processed, which can indicate slower sales or potential inefficiencies in inventory management.

In summary, the data points to a period of enhanced inventory management effectiveness up to late 2019, followed by a consistent trend toward reduced inventory turnover and prolonged processing times. This shift could highlight emerging operational challenges or changes in market conditions affecting inventory flow. Close attention to inventory control measures may be warranted to address the observed decline in turnover and the increase in processing days.


Average Receivable Collection Period

3M Co., average receivable collection period calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018
Selected Financial Data
Receivables turnover
Short-term Activity Ratio (no. days)
Average receivable collection period1
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Boeing Co.
Caterpillar Inc.
Eaton Corp. plc
GE Aerospace
Honeywell International Inc.
Lockheed Martin Corp.
RTX Corp.

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

1 Q3 2022 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ =

2 Click competitor name to see calculations.


The financial data presents an analysis of key receivables management metrics over a period spanning Q1 2018 to Q3 2022. Two primary indicators are examined: receivables turnover ratio and average receivable collection period in days.

Receivables Turnover Ratio
The receivables turnover ratio demonstrates a generally positive upward trend over the reviewed period. Starting at 6.14 in Q1 2018, the ratio remained relatively stable in 2018 with minor fluctuations around 6.1 to 6.53. During 2019, a mild increase was observed, peaking at 6.71 in Q4 2019. The ratio further improved in 2020, reaching 7.03 in Q2 before a slight decline towards the end of the year, stabilizing around 6.84.
In 2021 and into 2022, a stronger growth pattern is evident with the ratio consistently exceeding 6.8 and reaching as high as 7.59 in Q4 2021. Despite some minor decreases in the following quarters, the ratio maintained levels above 7.1, indicating improved efficiency in collecting receivables over time.
Average Receivable Collection Period
This metric inversely reflects the receivables turnover and shows a decreasing trend, which suggests a shortening of the time needed to collect receivables. Beginning at 59 days in Q1 2018, the collection period slightly decreased to 56 days by the end of 2018.
Throughout 2019, the collection period fluctuated around 54 to 61 days, with notable improvement towards the end of the year settling near 54 days. In 2020, the period maintained a lower range near 52-54 days consistently, reflecting better collectability despite the challenging economic environment likely faced during the year.
In 2021, the collection period stabilized further, narrowing between 48 to 53 days, with Q1 2022 reflecting 50 days and minor variances thereafter. The sustained reduction in collection days aligns with the increasing turnover ratio, underscoring enhanced operational effectiveness in accounts receivable management.

Overall, the analysis indicates that the company improved its receivables management over the reviewed timeframe. Increasing turnover ratios coupled with decreasing collection periods suggest more efficient use of working capital, quicker cash inflows from credit sales, and a stronger liquidity position. These trends imply effective credit control policies and possibly tighter credit terms or better customer payment practices.


Operating Cycle

3M Co., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018
Selected Financial Data
Average inventory processing period
Average receivable collection period
Short-term Activity Ratio
Operating cycle1
Benchmarks
Operating Cycle, Competitors2
Boeing Co.
Caterpillar Inc.
Eaton Corp. plc
GE Aerospace
Honeywell International Inc.
Lockheed Martin Corp.
RTX Corp.

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

1 Q3 2022 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= + =

2 Click competitor name to see calculations.


Inventory Processing Period
The average inventory processing period exhibits moderate fluctuations throughout the observed timeframe. Starting at 96 days in March 2018, it sees a slight decline to 87 days by September 2019, indicating improved inventory turnover efficiency. However, from late 2019 onward, this period begins to increase again, reaching 106 days in both June and September 2022, which suggests a slowdown in inventory movement or increased stock levels towards the end of the period.
Receivable Collection Period
The average receivable collection period shows a generally stable trend with minor variations. The values oscillate mostly between 48 and 61 days, starting at 59 days in March 2018 and demonstrating a gradual decline after 2019. The lowest observed value is 48 days in June 2021, reflecting improved collection efficiency. However, from early 2022 onward, the period slightly lengthens again, staying around 50 to 51 days, indicating a modest relaxation in collection speed.
Operating Cycle
The operating cycle, representing the total time from inventory acquisition to cash collection, follows a pattern largely influenced by the two components above. Initially around 155 days in March 2018, it decreases to a low of approximately 142 days by December 2019, indicating enhanced operational efficiency. After this point, the cycle gradually extends, reaching up to 157 days in September 2022. This increase signals a lengthening of the overall cash conversion cycle, likely driven by the rising inventory processing period despite relatively stable receivable collection times.
Overall Insights
The trends suggest that the company experienced improvements in working capital management up until late 2019, particularly in reducing inventory holding periods and shortening the operating cycle. However, from 2020 onwards, there is a reversal in this trend mainly attributed to increased inventory processing times. The receivable collection period remained comparatively stable with minor improvements over time. The lengthening operating cycle in recent years could indicate emerging challenges in inventory management or changes in demand and supply chain conditions.

Average Payables Payment Period

3M Co., average payables payment period calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018
Selected Financial Data
Payables turnover
Short-term Activity Ratio (no. days)
Average payables payment period1
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Boeing Co.
Caterpillar Inc.
Eaton Corp. plc
GE Aerospace
Honeywell International Inc.
Lockheed Martin Corp.
RTX Corp.

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

1 Q3 2022 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ =

2 Click competitor name to see calculations.


Payables Turnover Ratio
The payables turnover ratio demonstrates a decreasing trend over the analyzed period. Initially, the ratio was relatively high, near 8.7 to 8.9 in early 2018, indicating a faster rate of payment to suppliers. Throughout 2018 and 2019, this ratio shows fluctuations but generally declines, dropping to around 7.2 to 7.9. Starting in 2020, the ratio further decreases, reaching lows near 6.3 to 6.5 by the end of 2021 and continuing near similar lower levels into late 2022. This downward trend suggests that the company has been taking longer to pay its suppliers over time, resulting in slower payables turnover.
Average Payables Payment Period
The average payables payment period, expressed in days, exhibits an opposing trend to the payables turnover ratio, increasing gradually throughout the observed quarters. Early in 2018, the payment period was around 41 to 44 days, gradually increasing towards 50 days by late 2018 and early 2019. The period oscillates somewhat but steadily rises from 44 days in mid-2020 up to peaks near 60 days by late 2021 and remains around 58 to 61 days into 2022. This lengthening payment period aligns with the decreasing payables turnover ratio and further indicates that the company has extended the time taken to settle its accounts payable.
Overall Insights
The combined analysis of these two metrics reveals a clear shift in the company's payables management approach over the time frame. The increasing average payment period alongside the decreasing payables turnover ratio suggests that the company has gradually delayed payments to suppliers. This trend could reflect strategic cash flow management, potential supplier negotiations, or operational adjustments. No abrupt changes are noted, rather a steady progression toward longer payment cycles. The implications of such a trend may include improved short-term liquidity but could also affect supplier relationships depending on industry norms and agreements.

Cash Conversion Cycle

3M Co., cash conversion cycle calculation (quarterly data)

No. days

Microsoft Excel
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018
Selected Financial Data
Average inventory processing period
Average receivable collection period
Average payables payment period
Short-term Activity Ratio
Cash conversion cycle1
Benchmarks
Cash Conversion Cycle, Competitors2
Boeing Co.
Caterpillar Inc.
Eaton Corp. plc
GE Aerospace
Honeywell International Inc.
Lockheed Martin Corp.
RTX Corp.

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

1 Q3 2022 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= + =

2 Click competitor name to see calculations.


The analysis of the quarterly financial trends reveals several patterns in the company's working capital management, focusing on inventory, receivables, payables, and the overall cash conversion cycle over the period from the first quarter of 2018 through the third quarter of 2022.

Average Inventory Processing Period
The average inventory processing period shows some fluctuations throughout the observed quarters. Initially, it remained relatively stable around the mid-90s in days during 2018. In 2019 and 2020, slight decreases were observed, reaching a low of 87 days in the third quarter of 2019 and again 88 days in the third quarter of 2020. However, from 2021 onwards, there is an upward trend, increasing steadily to reach 106 days by the third quarter of 2022, representing a lengthening period in inventory turnover.
Average Receivable Collection Period
The average receivable collection period shows a general decreasing tendency over the analyzed period. Starting near 59-60 days in early 2018, it slightly decreased to a range between 50 and 54 days during 2020 and 2021. This downward trend continues into 2022, with values holding close to 50-51 days, indicating an improvement in the efficiency of receivables collection over time.
Average Payables Payment Period
The average payables payment period has increased over the period considered. Beginning around 42 days in the first quarter of 2018, it steadily rose to reach peaks around 60-61 days during mid to late 2022. This suggests the company has extended the time it takes to settle its payables, which could have positive cash flow implications. The increase is particularly notable from 2020 onwards, with a marked rise from approximately 48 days in early 2020 to over 60 days in 2022.
Cash Conversion Cycle
The cash conversion cycle, which represents the net time interval between cash outlays and cash inflows, exhibits a declining trend from 2018 through to 2021. Starting at about 113 days in the first quarter of 2018, it decreases to a low of 87 days by the third quarter of 2021, reflecting improved operational efficiency in cash flow management. However, there is a slight reversal of this trend in 2022, where the cycle lengthens to approximately 96-98 days, partially attributable to the extension of inventory days and an increase in payables payment period as well.

In summary, the data indicate that while receivable collection efficiency has improved, inventory management has seen a deterioration with longer holding periods in recent quarters. Concurrently, the company has extended its payables payment period, potentially to optimize cash holding. As a result, the overall cash conversion cycle improved over the years but has recently shown signs of elongation, possibly due to the increased inventory days. Monitoring these trends could be essential for ongoing liquidity and working capital optimization.