Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Paying user area
Try for free
General Mills Inc. pages available for free this week:
- Common-Size Balance Sheet: Liabilities and Stockholders’ Equity
- Analysis of Long-term (Investment) Activity Ratios
- Analysis of Reportable Segments
- Common Stock Valuation Ratios
- Enterprise Value (EV)
- Dividend Discount Model (DDM)
- Present Value of Free Cash Flow to Equity (FCFE)
- Return on Assets (ROA) since 2005
- Analysis of Revenues
- Aggregate Accruals
The data is hidden behind: . Unhide it.
Get full access to the entire website from $10.42/mo, or
get 1-month access to General Mills Inc. for $22.49.
This is a one-time payment. There is no automatic renewal.
We accept:
Short-term Activity Ratios (Summary)
Based on: 10-Q (reporting date: 2019-11-24), 10-Q (reporting date: 2019-08-25), 10-K (reporting date: 2019-05-26), 10-Q (reporting date: 2019-02-24), 10-Q (reporting date: 2018-11-25), 10-Q (reporting date: 2018-08-26), 10-K (reporting date: 2018-05-27), 10-Q (reporting date: 2018-02-25), 10-Q (reporting date: 2017-11-26), 10-Q (reporting date: 2017-08-27), 10-K (reporting date: 2017-05-28), 10-Q (reporting date: 2017-02-26), 10-Q (reporting date: 2016-11-27), 10-Q (reporting date: 2016-08-28), 10-K (reporting date: 2016-05-29), 10-Q (reporting date: 2016-02-28), 10-Q (reporting date: 2015-11-29), 10-Q (reporting date: 2015-08-30), 10-K (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-22), 10-Q (reporting date: 2014-11-23), 10-Q (reporting date: 2014-08-24).
The analysis of the quarterly financial ratios and periods reveals several notable patterns and shifts over the given time frame.
- Inventory Turnover
- The inventory turnover ratio fluctuates within a range of approximately 6.12 to 8.12, showing periods of improvement followed by declines. Early periods exhibit higher turnover around 7.5 to 8.1, indicating efficient inventory management. In later periods, the ratio stabilizes closer to 6.3 to 7.1, suggesting a slight reduction in inventory turnover efficiency.
- Receivables Turnover
- This ratio trends downward over time, starting near 12.7 and moving down toward 9.3 to 10.3 in later periods. This decline suggests an increasing length of time taken to collect receivables, potentially implying a loosening of credit policies or delayed payments by customers.
- Payables Turnover
- The payables turnover ratio exhibits a consistent decreasing trend from above 7.3 to approximately 3.5-4.0 in final periods. This indicates the company is taking longer to pay its suppliers, which could be a strategic decision to manage cash flow or a sign of payment processing delays.
- Average Inventory Processing Period
- The average inventory days range mostly between 45 and 60 days, with a slight increase toward the later periods where values cluster closer to 57 days. This aligns with the moderate decrease in inventory turnover, showing inventory held for a longer period before sale.
- Average Receivable Collection Period
- The days to collect receivables generally increase from around 29-33 days early on to about 35-39 days in the later quarters. This confirms the reduction in receivables turnover, reflecting slower cash inflows from customers.
- Operating Cycle
- The operating cycle varies between 75 and 97 days, with an upward trend apparent in later periods. This implies the overall process from inventory acquisition to cash collection is lengthening, potentially exerting pressure on working capital.
- Average Payables Payment Period
- This period shows a clear lengthening trend, rising steadily from about 46-56 days initially to over 90 days in the latest quarters. This increasing duration suggests extended supplier payment terms or delayed payments, possibly to conserve cash.
- Cash Conversion Cycle
- The cash conversion cycle displays a significant improvement, reducing from over 40 days down to zero or negative days toward the end of the period. Negative values in several quarters indicate that the company manages to collect cash from sales before paying its suppliers, which is positive for liquidity management.
In summary, while some efficiency ratios such as inventory turnover have slightly declined, the company has achieved a marked improvement in cash flow management indicated by a shortened and even negative cash conversion cycle. The increasing payable payment period alongside slower receivable collection suggests strategic extension of payment terms to suppliers and some leniency in customer collections. These trends highlight an emphasis on optimizing working capital and cash flow despite extended operating cycles.
Turnover Ratios
Average No. Days
Inventory Turnover
| Nov 24, 2019 | Aug 25, 2019 | May 26, 2019 | Feb 24, 2019 | Nov 25, 2018 | Aug 26, 2018 | May 27, 2018 | Feb 25, 2018 | Nov 26, 2017 | Aug 27, 2017 | May 28, 2017 | Feb 26, 2017 | Nov 27, 2016 | Aug 28, 2016 | May 29, 2016 | Feb 28, 2016 | Nov 29, 2015 | Aug 30, 2015 | May 31, 2015 | Feb 22, 2015 | Nov 23, 2014 | Aug 24, 2014 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Cost of sales | |||||||||||||||||||||||||||||
| Inventories | |||||||||||||||||||||||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Inventory turnover1 | |||||||||||||||||||||||||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Inventory Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Coca-Cola Co. | |||||||||||||||||||||||||||||
| Mondelēz International Inc. | |||||||||||||||||||||||||||||
| PepsiCo Inc. | |||||||||||||||||||||||||||||
| Philip Morris International Inc. | |||||||||||||||||||||||||||||
Based on: 10-Q (reporting date: 2019-11-24), 10-Q (reporting date: 2019-08-25), 10-K (reporting date: 2019-05-26), 10-Q (reporting date: 2019-02-24), 10-Q (reporting date: 2018-11-25), 10-Q (reporting date: 2018-08-26), 10-K (reporting date: 2018-05-27), 10-Q (reporting date: 2018-02-25), 10-Q (reporting date: 2017-11-26), 10-Q (reporting date: 2017-08-27), 10-K (reporting date: 2017-05-28), 10-Q (reporting date: 2017-02-26), 10-Q (reporting date: 2016-11-27), 10-Q (reporting date: 2016-08-28), 10-K (reporting date: 2016-05-29), 10-Q (reporting date: 2016-02-28), 10-Q (reporting date: 2015-11-29), 10-Q (reporting date: 2015-08-30), 10-K (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-22), 10-Q (reporting date: 2014-11-23), 10-Q (reporting date: 2014-08-24).
1 Q2 2020 Calculation
Inventory turnover
= (Cost of salesQ2 2020
+ Cost of salesQ1 2020
+ Cost of salesQ4 2019
+ Cost of salesQ3 2019)
÷ Inventories
= ( + + + )
÷ =
2 Click competitor name to see calculations.
- Cost of Sales
- The cost of sales exhibits a fluctuating trend over the analyzed quarters. It initially increased from approximately 2,829,700 thousand to a peak above 3 million in late 2014 before generally declining through mid-2016. This downward movement was followed by oscillations between approximately 2,450,000 and 2,900,000 thousand in subsequent periods. Notably, cost of sales showed some resurgence towards the end of the timeframe, reaching close to 2,850,000 thousand by late 2019, indicating variability but no consistent growth or decline trend overall.
- Inventories
- Inventories displayed notable variability, beginning near 1,823,300 thousand and initially increasing slightly before a marked reduction around early 2016. After this decline to roughly 1,350,200 thousand, inventories generally trended upward with some fluctuations, peaking around 1,719,500 thousand in the final quarter of 2019. The overall trajectory suggests an increase in inventory levels over the period, albeit with intermittent decreases, potentially reflecting adjustments in stock management or supply chain changes.
- Inventory Turnover Ratio
- The inventory turnover ratio fluctuated between roughly 6.28 and 8.12 times through the quarters. It peaked in early 2016, indicating a faster conversion of inventory into sales during that period. Subsequently, turnover ratios tended to moderate, stabilizing in the 6 to 7 range for the latter part of the analyzed period. This pattern signifies periods of improved inventory efficiency interspersed with phases of slower turnover, possibly influenced by varying sales volumes or inventory policies.
- Summary of Trends and Insights
- The financial data reveals a dynamic operational environment. Cost of sales lacks a definitive directional trend but reflects variability that could be tied to changes in production costs, sales mix, or market conditions. Inventories indicate a general increase, which may suggest buildup for anticipated demand or precautionary stock increases. Meanwhile, inventory turnover ratios imply fluctuating but generally stable inventory management efficiency, with some periods of heightened activity. Taken together, these trends could reflect strategic adjustments in inventory and cost management in response to evolving market demands or internal factors.
Receivables Turnover
| Nov 24, 2019 | Aug 25, 2019 | May 26, 2019 | Feb 24, 2019 | Nov 25, 2018 | Aug 26, 2018 | May 27, 2018 | Feb 25, 2018 | Nov 26, 2017 | Aug 27, 2017 | May 28, 2017 | Feb 26, 2017 | Nov 27, 2016 | Aug 28, 2016 | May 29, 2016 | Feb 28, 2016 | Nov 29, 2015 | Aug 30, 2015 | May 31, 2015 | Feb 22, 2015 | Nov 23, 2014 | Aug 24, 2014 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Net sales | |||||||||||||||||||||||||||||
| Receivables | |||||||||||||||||||||||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Receivables turnover1 | |||||||||||||||||||||||||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Coca-Cola Co. | |||||||||||||||||||||||||||||
| Mondelēz International Inc. | |||||||||||||||||||||||||||||
| PepsiCo Inc. | |||||||||||||||||||||||||||||
| Philip Morris International Inc. | |||||||||||||||||||||||||||||
Based on: 10-Q (reporting date: 2019-11-24), 10-Q (reporting date: 2019-08-25), 10-K (reporting date: 2019-05-26), 10-Q (reporting date: 2019-02-24), 10-Q (reporting date: 2018-11-25), 10-Q (reporting date: 2018-08-26), 10-K (reporting date: 2018-05-27), 10-Q (reporting date: 2018-02-25), 10-Q (reporting date: 2017-11-26), 10-Q (reporting date: 2017-08-27), 10-K (reporting date: 2017-05-28), 10-Q (reporting date: 2017-02-26), 10-Q (reporting date: 2016-11-27), 10-Q (reporting date: 2016-08-28), 10-K (reporting date: 2016-05-29), 10-Q (reporting date: 2016-02-28), 10-Q (reporting date: 2015-11-29), 10-Q (reporting date: 2015-08-30), 10-K (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-22), 10-Q (reporting date: 2014-11-23), 10-Q (reporting date: 2014-08-24).
1 Q2 2020 Calculation
Receivables turnover
= (Net salesQ2 2020
+ Net salesQ1 2020
+ Net salesQ4 2019
+ Net salesQ3 2019)
÷ Receivables
= ( + + + )
÷ =
2 Click competitor name to see calculations.
The quarterly financial data reveals several notable trends in the company's operational performance over the analyzed periods.
- Net Sales
- Net sales exhibit some fluctuations without a consistent upward or downward trajectory across the periods. Initial figures show a rise from approximately 4.27 billion US dollars to around 4.71 billion, followed by general declines and intermittent recoveries. Sales reach lower points near the 3.76 to 3.79 billion range in early 2017, then experience a moderate rebound toward the end of the dataset, peaking again around 4.42 billion US dollars. This pattern suggests variability potentially linked to seasonal factors, market conditions, or operational changes impacting revenue generation.
- Receivables
- Receivables have overall increased throughout the periods, starting from approximately 1.62 billion US dollars and reaching about 1.77 billion by the end. The upward movement is gradual but persistent, indicating either extended credit terms to customers, slower collections, or increased sales on credit. Notably, there are some dips and recoveries that parallel fluctuations in sales, but the general trend remains upward.
- Receivables Turnover Ratio
- The receivables turnover ratio shows a declining trend over the analyzed timeframe. Early periods display higher turnover ratios above 11 times, peaking around 12.7, indicating relatively efficient collection processes. Over time, this ratio decreases to below 10 times in several later periods, reflecting a slower conversion of receivables into cash. This decline may suggest weakening credit management, longer collection periods, or changes in customer payment behavior.
In summary, while net sales show cyclical variations without a distinct long-term growth pattern, receivables steadily increase, and the efficiency in collecting those receivables appears to diminish. These observations imply potential challenges in cash flow management and credit policies that could merit further examination to ensure financial stability and operational effectiveness.
Payables Turnover
| Nov 24, 2019 | Aug 25, 2019 | May 26, 2019 | Feb 24, 2019 | Nov 25, 2018 | Aug 26, 2018 | May 27, 2018 | Feb 25, 2018 | Nov 26, 2017 | Aug 27, 2017 | May 28, 2017 | Feb 26, 2017 | Nov 27, 2016 | Aug 28, 2016 | May 29, 2016 | Feb 28, 2016 | Nov 29, 2015 | Aug 30, 2015 | May 31, 2015 | Feb 22, 2015 | Nov 23, 2014 | Aug 24, 2014 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Cost of sales | |||||||||||||||||||||||||||||
| Accounts payable | |||||||||||||||||||||||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Payables turnover1 | |||||||||||||||||||||||||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Mondelēz International Inc. | |||||||||||||||||||||||||||||
| Philip Morris International Inc. | |||||||||||||||||||||||||||||
Based on: 10-Q (reporting date: 2019-11-24), 10-Q (reporting date: 2019-08-25), 10-K (reporting date: 2019-05-26), 10-Q (reporting date: 2019-02-24), 10-Q (reporting date: 2018-11-25), 10-Q (reporting date: 2018-08-26), 10-K (reporting date: 2018-05-27), 10-Q (reporting date: 2018-02-25), 10-Q (reporting date: 2017-11-26), 10-Q (reporting date: 2017-08-27), 10-K (reporting date: 2017-05-28), 10-Q (reporting date: 2017-02-26), 10-Q (reporting date: 2016-11-27), 10-Q (reporting date: 2016-08-28), 10-K (reporting date: 2016-05-29), 10-Q (reporting date: 2016-02-28), 10-Q (reporting date: 2015-11-29), 10-Q (reporting date: 2015-08-30), 10-K (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-22), 10-Q (reporting date: 2014-11-23), 10-Q (reporting date: 2014-08-24).
1 Q2 2020 Calculation
Payables turnover
= (Cost of salesQ2 2020
+ Cost of salesQ1 2020
+ Cost of salesQ4 2019
+ Cost of salesQ3 2019)
÷ Accounts payable
= ( + + + )
÷ =
2 Click competitor name to see calculations.
The analysis of the presented financial data reveals several notable trends in the company’s cost of sales, accounts payable, and payables turnover ratios over the observed periods.
- Cost of Sales
- The cost of sales displays a fluctuating pattern across the quarters. Initially, it experienced an increase from approximately 2,829,700 thousand USD in August 2014 to a peak of around 3,093,100 thousand USD in November 2014. Subsequently, a general downward trend is observed with occasional rises. Notably, after November 2017, the cost of sales tends to hover between approximately 2,451,100 and 2,901,500 thousand USD, indicating some stabilization albeit at a lower level than the initial peak.
- Accounts Payable
- Accounts payable shows a clear upward trajectory throughout the periods. Starting from about 1,571,300 thousand USD in August 2014, the balances increase steadily to reach above 3,063,000 thousand USD by November 2019. This rising trend indicates an increasing obligation toward suppliers or creditors, possibly reflecting extended payment terms or increased purchasing volume.
- Payables Turnover Ratio
- The payables turnover ratio demonstrates a consistent declining trend over the analyzed quarters. Beginning at a relatively high 7.39 in August 2014, the ratio progressively decreases to 3.57 by November 2019. This decline suggests that the company is taking longer to pay its suppliers or has slower turnover of payables. This tendency is generally aligned with the increasing accounts payable balance but inversely related to the cost of sales movement, which fluctuates without a clear downward or upward pattern.
Overall, the data reflect a scenario where the company is managing higher levels of accounts payable while the payables turnover ratio declines, indicating longer payment periods or extended credit terms from suppliers. Concurrently, the cost of sales experiences variability without a persistent trend, suggesting potential changes in sales volume, cost management, or pricing strategies impacting the cost structure. The liquidity management and supplier negotiations appear to be critical factors influencing the financial position over the periods.
Working Capital Turnover
| Nov 24, 2019 | Aug 25, 2019 | May 26, 2019 | Feb 24, 2019 | Nov 25, 2018 | Aug 26, 2018 | May 27, 2018 | Feb 25, 2018 | Nov 26, 2017 | Aug 27, 2017 | May 28, 2017 | Feb 26, 2017 | Nov 27, 2016 | Aug 28, 2016 | May 29, 2016 | Feb 28, 2016 | Nov 29, 2015 | Aug 30, 2015 | May 31, 2015 | Feb 22, 2015 | Nov 23, 2014 | Aug 24, 2014 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Current assets | |||||||||||||||||||||||||||||
| Less: Current liabilities | |||||||||||||||||||||||||||||
| Working capital | |||||||||||||||||||||||||||||
| Net sales | |||||||||||||||||||||||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Working capital turnover1 | |||||||||||||||||||||||||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Coca-Cola Co. | |||||||||||||||||||||||||||||
| Mondelēz International Inc. | |||||||||||||||||||||||||||||
| PepsiCo Inc. | |||||||||||||||||||||||||||||
| Philip Morris International Inc. | |||||||||||||||||||||||||||||
Based on: 10-Q (reporting date: 2019-11-24), 10-Q (reporting date: 2019-08-25), 10-K (reporting date: 2019-05-26), 10-Q (reporting date: 2019-02-24), 10-Q (reporting date: 2018-11-25), 10-Q (reporting date: 2018-08-26), 10-K (reporting date: 2018-05-27), 10-Q (reporting date: 2018-02-25), 10-Q (reporting date: 2017-11-26), 10-Q (reporting date: 2017-08-27), 10-K (reporting date: 2017-05-28), 10-Q (reporting date: 2017-02-26), 10-Q (reporting date: 2016-11-27), 10-Q (reporting date: 2016-08-28), 10-K (reporting date: 2016-05-29), 10-Q (reporting date: 2016-02-28), 10-Q (reporting date: 2015-11-29), 10-Q (reporting date: 2015-08-30), 10-K (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-22), 10-Q (reporting date: 2014-11-23), 10-Q (reporting date: 2014-08-24).
1 Q2 2020 Calculation
Working capital turnover
= (Net salesQ2 2020
+ Net salesQ1 2020
+ Net salesQ4 2019
+ Net salesQ3 2019)
÷ Working capital
= ( + + + )
÷ =
2 Click competitor name to see calculations.
- Working Capital
- The working capital figures consistently remain negative throughout the reported quarters, indicating that current liabilities exceed current assets. Fluctuations are evident with values oscillating between approximately -0.9 billion and -3.3 billion US dollars. Notably, there is a significant drop in working capital in the May 2018 quarter, reaching around -3.2 billion, followed by sustained negative levels near -3 billion in the subsequent quarters. This trend suggests persistent liquidity constraints and a working capital structure that may warrant management review.
- Net Sales
- Net sales demonstrate variability over the quarters, with values ranging from approximately 3.8 billion to 4.7 billion US dollars. There is an observable cyclical pattern, with sales peaks occurring near the end of calendar years, particularly in November quarters, which may align with seasonal demand trends. Although some quarters show declines, the general sales level remains relatively stable, evidencing resilience with occasional upward adjustments as seen in certain periods like November 2014 and November 2018.
- Working Capital Turnover
- The working capital turnover ratio is not provided, which limits the ability to directly assess how efficiently the company is utilizing its working capital to generate sales. Given the negative working capital position, any turnover calculation would require careful interpretation.
- Overall Observations
- The data reveals a sustained negative working capital scenario alongside relatively stable net sales figures with seasonal fluctuations. The negative working capital could indicate a strategy of leveraging short-term liabilities or potential liquidity pressure. The sales trends' seasonality points to demand patterns influenced by calendar cycles. The absence of working capital turnover ratio data constrains a thorough efficiency analysis.
Average Inventory Processing Period
| Nov 24, 2019 | Aug 25, 2019 | May 26, 2019 | Feb 24, 2019 | Nov 25, 2018 | Aug 26, 2018 | May 27, 2018 | Feb 25, 2018 | Nov 26, 2017 | Aug 27, 2017 | May 28, 2017 | Feb 26, 2017 | Nov 27, 2016 | Aug 28, 2016 | May 29, 2016 | Feb 28, 2016 | Nov 29, 2015 | Aug 30, 2015 | May 31, 2015 | Feb 22, 2015 | Nov 23, 2014 | Aug 24, 2014 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Inventory turnover | |||||||||||||||||||||||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
| Average inventory processing period1 | |||||||||||||||||||||||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||
| Average Inventory Processing Period, Competitors2 | |||||||||||||||||||||||||||||
| Coca-Cola Co. | |||||||||||||||||||||||||||||
| Mondelēz International Inc. | |||||||||||||||||||||||||||||
| PepsiCo Inc. | |||||||||||||||||||||||||||||
| Philip Morris International Inc. | |||||||||||||||||||||||||||||
Based on: 10-Q (reporting date: 2019-11-24), 10-Q (reporting date: 2019-08-25), 10-K (reporting date: 2019-05-26), 10-Q (reporting date: 2019-02-24), 10-Q (reporting date: 2018-11-25), 10-Q (reporting date: 2018-08-26), 10-K (reporting date: 2018-05-27), 10-Q (reporting date: 2018-02-25), 10-Q (reporting date: 2017-11-26), 10-Q (reporting date: 2017-08-27), 10-K (reporting date: 2017-05-28), 10-Q (reporting date: 2017-02-26), 10-Q (reporting date: 2016-11-27), 10-Q (reporting date: 2016-08-28), 10-K (reporting date: 2016-05-29), 10-Q (reporting date: 2016-02-28), 10-Q (reporting date: 2015-11-29), 10-Q (reporting date: 2015-08-30), 10-K (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-22), 10-Q (reporting date: 2014-11-23), 10-Q (reporting date: 2014-08-24).
1 Q2 2020 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ =
2 Click competitor name to see calculations.
The analysis of the inventory turnover ratio and the average inventory processing period over the observed quarters reveals notable fluctuations and periodic patterns. The inventory turnover ratio, which measures how many times inventory is sold and replaced over a period, exhibits variability typically within the range of approximately 6.1 to 8.1.
- Inventory Turnover Ratio Trends
- The inventory turnover ratio begins at 6.37 and experiences a general upward trend early in the timeline, peaking at 8.12 around February 2016. Following this peak, a decline is observable, with values fluctuating between the mid-6s and low 7s. The data suggests an initial improvement in inventory efficiency, followed by stabilization at a moderate turnover level. There is no clear long-term sustained increase or decrease beyond the initial peak period; instead, the ratio oscillates, indicating periodic changes in inventory management or sales patterns.
- Average Inventory Processing Period Trends
- The average inventory processing period, indicating the time inventory remains on hand before sale, inversely correlates with the turnover ratio. It starts at 57 days and decreases to a low of 45 days around February 2016, coinciding with the peak inventory turnover ratio. Post this period, the processing duration lengthens again, fluctuating mainly between approximately 50 and 58 days. This inverse movement corroborates the cyclical nature of inventory handling efficiency over time.
- Relationship and Interpretation
- The inverse relationship between the inventory turnover ratio and the average inventory processing period is consistent with operational principles, where higher turnover is generally associated with shorter inventory durations. The peak turnover and corresponding low processing period around early 2016 may reflect a period of efficient inventory management or increased sales velocity. Subsequent quarters show a reversion to longer processing times and lower turnover, which could indicate either strategic changes in inventory policies, shifts in demand, or external market conditions affecting product movement.
- Overall Insights
- Overall, the data demonstrates a pattern of fluctuating inventory efficiency without a definitive long-term trend upwards or downwards. The periodic nature of these movements suggests that inventory management is responsive to changing conditions, balancing between turnover and holding periods. No extreme outliers or abrupt changes occur outside the typical range, suggesting stable operations with moderate variability in inventory handling.
Average Receivable Collection Period
| Nov 24, 2019 | Aug 25, 2019 | May 26, 2019 | Feb 24, 2019 | Nov 25, 2018 | Aug 26, 2018 | May 27, 2018 | Feb 25, 2018 | Nov 26, 2017 | Aug 27, 2017 | May 28, 2017 | Feb 26, 2017 | Nov 27, 2016 | Aug 28, 2016 | May 29, 2016 | Feb 28, 2016 | Nov 29, 2015 | Aug 30, 2015 | May 31, 2015 | Feb 22, 2015 | Nov 23, 2014 | Aug 24, 2014 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Receivables turnover | |||||||||||||||||||||||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
| Average receivable collection period1 | |||||||||||||||||||||||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||||||||
| Coca-Cola Co. | |||||||||||||||||||||||||||||
| Mondelēz International Inc. | |||||||||||||||||||||||||||||
| PepsiCo Inc. | |||||||||||||||||||||||||||||
| Philip Morris International Inc. | |||||||||||||||||||||||||||||
Based on: 10-Q (reporting date: 2019-11-24), 10-Q (reporting date: 2019-08-25), 10-K (reporting date: 2019-05-26), 10-Q (reporting date: 2019-02-24), 10-Q (reporting date: 2018-11-25), 10-Q (reporting date: 2018-08-26), 10-K (reporting date: 2018-05-27), 10-Q (reporting date: 2018-02-25), 10-Q (reporting date: 2017-11-26), 10-Q (reporting date: 2017-08-27), 10-K (reporting date: 2017-05-28), 10-Q (reporting date: 2017-02-26), 10-Q (reporting date: 2016-11-27), 10-Q (reporting date: 2016-08-28), 10-K (reporting date: 2016-05-29), 10-Q (reporting date: 2016-02-28), 10-Q (reporting date: 2015-11-29), 10-Q (reporting date: 2015-08-30), 10-K (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-22), 10-Q (reporting date: 2014-11-23), 10-Q (reporting date: 2014-08-24).
1 Q2 2020 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ =
2 Click competitor name to see calculations.
- Receivables Turnover
- The receivables turnover ratio shows a fluctuating pattern over the observed periods, with a peak at 12.71 in May 2015 followed by a gradual decline. Initially, there is an upward trend from 10.97 in August 2014 to the peak in May 2015, indicating an improvement in the company's efficiency in collecting receivables. However, post-peak, the ratio trends downward, mostly remaining in the range of 9.35 to 10.31 from August 2017 onward, suggesting a decline in collection efficiency over time.
- Average Receivable Collection Period
- The average receivable collection period inversely mirrors the trend of the receivables turnover ratio. It decreases from 33 days in August 2014 to 29 days in May 2015, signifying faster collection of receivables during that span. Subsequently, the collection period generally increases, reaching as high as 39 days in May 2018 and November 2019. This indicates that it took the company progressively longer to collect receivables in the latter periods, which may raise concerns about cash flow timing and credit management.
- Overall Insight
- The data indicates an initial improvement in receivables management efficiency until mid-2015, followed by a gradual decline in turnover and an increase in the collection period. This change could point to potential challenges in credit policy enforcement or customer payment behavior impacting liquidity. Monitoring these ratios closely is recommended to identify underlying causes and implement corrective measures if necessary.
Operating Cycle
| Nov 24, 2019 | Aug 25, 2019 | May 26, 2019 | Feb 24, 2019 | Nov 25, 2018 | Aug 26, 2018 | May 27, 2018 | Feb 25, 2018 | Nov 26, 2017 | Aug 27, 2017 | May 28, 2017 | Feb 26, 2017 | Nov 27, 2016 | Aug 28, 2016 | May 29, 2016 | Feb 28, 2016 | Nov 29, 2015 | Aug 30, 2015 | May 31, 2015 | Feb 22, 2015 | Nov 23, 2014 | Aug 24, 2014 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Average inventory processing period | |||||||||||||||||||||||||||||
| Average receivable collection period | |||||||||||||||||||||||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Operating cycle1 | |||||||||||||||||||||||||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Operating Cycle, Competitors2 | |||||||||||||||||||||||||||||
| Coca-Cola Co. | |||||||||||||||||||||||||||||
| Mondelēz International Inc. | |||||||||||||||||||||||||||||
| PepsiCo Inc. | |||||||||||||||||||||||||||||
| Philip Morris International Inc. | |||||||||||||||||||||||||||||
Based on: 10-Q (reporting date: 2019-11-24), 10-Q (reporting date: 2019-08-25), 10-K (reporting date: 2019-05-26), 10-Q (reporting date: 2019-02-24), 10-Q (reporting date: 2018-11-25), 10-Q (reporting date: 2018-08-26), 10-K (reporting date: 2018-05-27), 10-Q (reporting date: 2018-02-25), 10-Q (reporting date: 2017-11-26), 10-Q (reporting date: 2017-08-27), 10-K (reporting date: 2017-05-28), 10-Q (reporting date: 2017-02-26), 10-Q (reporting date: 2016-11-27), 10-Q (reporting date: 2016-08-28), 10-K (reporting date: 2016-05-29), 10-Q (reporting date: 2016-02-28), 10-Q (reporting date: 2015-11-29), 10-Q (reporting date: 2015-08-30), 10-K (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-22), 10-Q (reporting date: 2014-11-23), 10-Q (reporting date: 2014-08-24).
1 Q2 2020 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 fluctuations over the observed quarters, ranging between a low of 45 days and a high of 60 days. Initial quarters show variability, with a notable dip around February to May 2016, followed by a gradual increase peaking near 58 days towards the latter part of the timeline. This suggests some inconsistency in inventory turnover efficiency, with periods of both acceleration and slowing down.
- Receivable Collection Period
- The receivable collection period shows a relatively narrower range, primarily fluctuating between 29 and 39 days. Early quarters indicate a slight downward trend, reaching the shortest collection times around May 2015. Subsequently, there is a general upward drift in collection days, particularly from late 2017 onward, indicating a lengthening of the time taken to collect receivables.
- Operating Cycle
- The operating cycle demonstrates a pattern closely tied to the inventory and receivable periods. It ranges from a minimum of 75 days to a maximum approaching 97 days. The cycle shows a decline initially until early 2016, implying improved overall operational efficiency, followed by a period of gradual increase thereafter, reaching its peak in 2018 and 2019. This indicates a lengthening in the total time taken to convert inventory and receivables into cash.
- Overall Observations
- The combined analysis of the three metrics reveals phases of operational efficiency improvements followed by reversals. The initial decline in both inventory processing and operating cycle points to effective working capital management. However, the later increase in both metrics, alongside a rising receivable collection period, suggests a potential slowdown in cash conversion efficiency. These trends may reflect changes in market conditions, inventory management strategies, or credit policies that affected liquidity and operational tempo.
Average Payables Payment Period
| Nov 24, 2019 | Aug 25, 2019 | May 26, 2019 | Feb 24, 2019 | Nov 25, 2018 | Aug 26, 2018 | May 27, 2018 | Feb 25, 2018 | Nov 26, 2017 | Aug 27, 2017 | May 28, 2017 | Feb 26, 2017 | Nov 27, 2016 | Aug 28, 2016 | May 29, 2016 | Feb 28, 2016 | Nov 29, 2015 | Aug 30, 2015 | May 31, 2015 | Feb 22, 2015 | Nov 23, 2014 | Aug 24, 2014 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Payables turnover | |||||||||||||||||||||||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
| Average payables payment period1 | |||||||||||||||||||||||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||||||||
| Mondelēz International Inc. | |||||||||||||||||||||||||||||
| Philip Morris International Inc. | |||||||||||||||||||||||||||||
Based on: 10-Q (reporting date: 2019-11-24), 10-Q (reporting date: 2019-08-25), 10-K (reporting date: 2019-05-26), 10-Q (reporting date: 2019-02-24), 10-Q (reporting date: 2018-11-25), 10-Q (reporting date: 2018-08-26), 10-K (reporting date: 2018-05-27), 10-Q (reporting date: 2018-02-25), 10-Q (reporting date: 2017-11-26), 10-Q (reporting date: 2017-08-27), 10-K (reporting date: 2017-05-28), 10-Q (reporting date: 2017-02-26), 10-Q (reporting date: 2016-11-27), 10-Q (reporting date: 2016-08-28), 10-K (reporting date: 2016-05-29), 10-Q (reporting date: 2016-02-28), 10-Q (reporting date: 2015-11-29), 10-Q (reporting date: 2015-08-30), 10-K (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-22), 10-Q (reporting date: 2014-11-23), 10-Q (reporting date: 2014-08-24).
1 Q2 2020 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ =
2 Click competitor name to see calculations.
The analysis of the payables turnover ratio and average payables payment period over the observed quarters reveals notable trends reflecting changes in payment efficiency and credit management.
- Payables Turnover Ratio
- The payables turnover ratio demonstrates a consistent downward trend from August 2014 through November 2019. Initially, the ratio starts at 7.39 and gradually declines with minor fluctuations, reaching a low of 3.57 by the end of the period. This decreasing ratio suggests that the company is turning over its payables less frequently, implying an extension in the time taken to pay suppliers.
- Average Payables Payment Period
- Correspondingly, the average payables payment period shows an increasing trend, starting at 49 days and peaking at 102 days by November 2019. This increase in the days payable outstanding aligns with the downward movement in the payables turnover ratio, indicating that the company is lengthening the period in which it settles its accounts payable.
- Overall Interpretation
- The inverse relationship between the payables turnover ratio and the average payment period implies that over the analyzed timeframe, the company has progressively delayed payments to its creditors. This could suggest a strategic approach to improving cash flow management by retaining cash for longer periods. However, this shift may affect supplier relationships and credit terms.
Cash Conversion Cycle
| Nov 24, 2019 | Aug 25, 2019 | May 26, 2019 | Feb 24, 2019 | Nov 25, 2018 | Aug 26, 2018 | May 27, 2018 | Feb 25, 2018 | Nov 26, 2017 | Aug 27, 2017 | May 28, 2017 | Feb 26, 2017 | Nov 27, 2016 | Aug 28, 2016 | May 29, 2016 | Feb 28, 2016 | Nov 29, 2015 | Aug 30, 2015 | May 31, 2015 | Feb 22, 2015 | Nov 23, 2014 | Aug 24, 2014 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||||||||||||||||||||||
| Mondelēz International Inc. | |||||||||||||||||||||||||||||
| Philip Morris International Inc. | |||||||||||||||||||||||||||||
Based on: 10-Q (reporting date: 2019-11-24), 10-Q (reporting date: 2019-08-25), 10-K (reporting date: 2019-05-26), 10-Q (reporting date: 2019-02-24), 10-Q (reporting date: 2018-11-25), 10-Q (reporting date: 2018-08-26), 10-K (reporting date: 2018-05-27), 10-Q (reporting date: 2018-02-25), 10-Q (reporting date: 2017-11-26), 10-Q (reporting date: 2017-08-27), 10-K (reporting date: 2017-05-28), 10-Q (reporting date: 2017-02-26), 10-Q (reporting date: 2016-11-27), 10-Q (reporting date: 2016-08-28), 10-K (reporting date: 2016-05-29), 10-Q (reporting date: 2016-02-28), 10-Q (reporting date: 2015-11-29), 10-Q (reporting date: 2015-08-30), 10-K (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-22), 10-Q (reporting date: 2014-11-23), 10-Q (reporting date: 2014-08-24).
1 Q2 2020 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 financial data reveals several notable trends in the company's working capital management over the observed periods.
- Average Inventory Processing Period
- The inventory processing period shows some variability, fluctuating between approximately 45 and 60 days. Initially, the period declines steadily from 57 days to a low of 45 days around early 2016, indicating improved inventory turnover. However, after this point, the period increases again, reaching peaks around 58 days in mid and late 2017 and 2018. The ending periods hover close to 57 days, suggesting a return to initial levels. This pattern may reflect adjustments in inventory management or changing demand conditions.
- Average Receivable Collection Period
- The receivable collection period remains relatively stable, ranging mostly between 29 and 39 days. There is a slight upward trend towards the later periods, moving from low 30s to upper 30s days, which may indicate a gradual lengthening in the time taken to collect receivables. Such an increase, while moderate, could have implications for cash flow if it continues.
- Average Payables Payment Period
- The payables payment period shows a marked upward trend throughout the periods examined. Starting around 49 days, it increases steadily, surpassing 100 days by the final period. This suggests that the company is taking longer to pay its suppliers, which can be indicative of extended credit terms or a deliberate strategy to conserve cash. Such an extension in payables could improve liquidity but may affect relationships with suppliers.
- Cash Conversion Cycle
- The cash conversion cycle generally decreases over time, moving from values above 40 days at the beginning to near zero or even negative values in many of the later periods. This reduction signals significant improvement in working capital efficiency, meaning the company is cycling cash more quickly through its operations. The negative or near-zero values in recent periods suggest that the company may be receiving payments from customers faster than it pays its suppliers, an advantageous position for cash management.
Overall, the data indicates a strategic shift towards improved cash management, with increased payables duration contributing to a reduced cash conversion cycle. While inventory turnover shows some fluctuation, the receivable collection period's slight increase warrants monitoring. The trends reflect an emphasis on optimizing liquidity and operational efficiency over the analyzed intervals.