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
Reynolds American Inc. pages available for free this week:
- Cash Flow Statement
- Common-Size Balance Sheet: Liabilities and Stockholders’ Equity
- Analysis of Long-term (Investment) Activity Ratios
- Common Stock Valuation Ratios
- Enterprise Value to EBITDA (EV/EBITDA)
- Capital Asset Pricing Model (CAPM)
- Operating Profit Margin since 2005
- Debt to Equity since 2005
- Total Asset Turnover since 2005
- Price to Sales (P/S) since 2005
The data is hidden behind: . Unhide it.
Get full access to the entire website from $10.42/mo, or
get 1-month access to Reynolds American 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-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).
The analysis of the financial ratios over the five-year period reveals several notable trends relating to inventory, receivables, payables, and overall working capital management.
- Inventory Turnover and Inventory Processing Period
- The inventory turnover ratio shows a declining trend from 4.39 in 2012 to 2.7 in 2015, with a slight recovery to 2.94 in 2016. Correspondingly, the average inventory processing period increases from 83 days in 2012 to a peak of 135 days in 2015 before decreasing to 124 days in 2016. This indicates a lengthening of inventory holding time through 2015, which could suggests slower inventory movement, before some improvement in 2016.
- Receivables Turnover and Collection Period
- The receivables turnover ratio declines from 140.54 in 2012 to 104.28 in 2014, then rises sharply to 255.24 in 2016. This change is mirrored inversely by the average receivable collection period, which remains relatively stable around 3–4 days until 2014, then drops significantly to just 1 day in 2016. These figures suggest a considerable improvement in the efficiency of receivables collection in the last two years, leading to faster conversion of receivables into cash.
- Payables Turnover and Payment Period
- The payables turnover ratio fluctuates, starting at 23.11 in 2012, dropping to 19.88 in 2013, rising to 28.58 in 2014, and then declining again to 21.9 in 2016. The average payables payment period shows an inverse pattern, increasing from 16 days in 2012 to 18 days in 2013, then decreasing to 13 days in 2014, before increasing again to 17 days in 2016. These dynamics imply variability in the payment terms and timing to suppliers, without a clear long-term trend in payables management.
- Working Capital Turnover
- The working capital turnover ratio shows considerable variability, with values of 11.72 in 2012, rising sharply to 20.67 in 2013, missing data for 2014, then recorded as 16.61 in 2015 and missing again in 2016. Despite gaps, the available data suggest fluctuations in the efficiency of using working capital to generate sales over the period.
- Operating Cycle and Cash Conversion Cycle
- The operating cycle lengthens steadily from 86 days in 2012 to a peak of 137 days in 2015 before contracting slightly to 125 days in 2016. Similarly, the cash conversion cycle increases from 70 days in 2012 to 123 days in 2015 and decreases to 108 days in 2016. These trends indicate a tendency towards longer periods to convert raw materials and receivables into cash, especially during 2014–2015, with some improvement noted in 2016.
Overall, the data suggest that the company experienced a slowing in inventory turnover and extended cash conversion cycles up to 2015, impacting operational efficiency. However, improvements in receivables collection and some reduction in inventory days in 2016 indicate a partial recovery in working capital management. Payables payment patterns remained variable without a consistent trend. The mixed results highlight areas for potential focus on optimizing inventory levels and payables terms to further improve cash flow performance.
Turnover Ratios
Average No. Days
Inventory Turnover
Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | ||
---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | ||||||
Cost of products sold, excludes excise taxes | ||||||
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-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).
1 2016 Calculation
Inventory turnover = Cost of products sold, excludes excise taxes ÷ Inventories
= ÷ =
2 Click competitor name to see calculations.
- Cost of Products Sold
- The cost of products sold showed a fluctuating but overall upward trend over the five-year period. It decreased from 4321 million USD in 2012 to 3678 million USD in 2013, indicating a reduction in costs during that year. However, from 2013 onwards, there was a steady increase: 4058 million USD in 2014, 4688 million USD in 2015, and 4841 million USD in 2016, reaching the highest value within the period analyzed.
- Inventories
- The inventory levels experienced consistent growth from 984 million USD in 2012 to 1734 million USD in 2015, reflecting an accumulation of stock or increased production capacity. In 2016, there was a slight decline to 1645 million USD, which might indicate improved inventory management or changes in demand.
- Inventory Turnover Ratio
- The inventory turnover ratio steadily declined from 4.39 in 2012 to 2.7 in 2015, suggesting that the company was selling and replenishing inventory less frequently year-over-year. This decline corresponds with the rise in inventory values, implying slower inventory movement. In 2016, there was a slight recovery to 2.94, which may point to enhanced efficiency in inventory management compared to the previous year, but it remained significantly lower than the ratio observed in 2012.
- Overall Observations
- The data indicates rising costs of products sold alongside increasing inventory levels, with inventory turnover declining, which could imply slower sales or potential overstocks during the period from 2012 to 2015. The slight improvement in inventory turnover in 2016, coupled with a minor decrease in inventories, may suggest attempts to address these inefficiencies. The relationship between these variables highlights the importance of monitoring inventory management and cost control to maintain operational effectiveness.
Receivables Turnover
Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | ||
---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | ||||||
Net sales, includes excise taxes | ||||||
Accounts receivable | ||||||
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-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).
1 2016 Calculation
Receivables turnover = Net sales, includes excise taxes ÷ Accounts receivable
= ÷ =
2 Click competitor name to see calculations.
- Net Sales
- The net sales, including excise taxes, showed a fluctuating but ultimately upward trend over the five-year period. Beginning at $12,227 million in 2012, sales slightly decreased to $11,966 million in 2013 but recovered in 2014 to $12,096 million. A significant increase is observed in 2015 with $14,884 million, followed by a further rise to $16,846 million in 2016. This indicates strong growth in sales especially in the last two years.
- Accounts Receivable
- Accounts receivable demonstrated variability with no clear upward or downward pattern. Starting at $87 million in 2012, it increased to $106 million in 2013, and then to $116 million in 2014. However, a marked decline occurred in 2015, falling to $68 million and slightly decreasing further to $66 million in 2016. This decline suggests improved collection efficiency or changes in credit policy in the later years.
- Receivables Turnover
- The receivables turnover ratio exhibited a decreasing trend from 2012 through 2014, moving from 140.54 to 104.28, indicating slower collections relative to receivables during this period. A notable reversal is evident in 2015 and 2016, where this ratio sharply increased to 218.88 and then 255.24, respectively. This substantial improvement aligns with the reduction in accounts receivable and suggests enhanced effectiveness in receivables management in the last two years.
Payables Turnover
Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | ||
---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | ||||||
Cost of products sold, excludes excise taxes | ||||||
Accounts payable | ||||||
Short-term Activity Ratio | ||||||
Payables turnover1 | ||||||
Benchmarks | ||||||
Payables Turnover, Competitors2 | ||||||
Coca-Cola Co. | ||||||
Mondelēz International Inc. | ||||||
PepsiCo Inc. | ||||||
Philip Morris International Inc. |
Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).
1 2016 Calculation
Payables turnover = Cost of products sold, excludes excise taxes ÷ Accounts payable
= ÷ =
2 Click competitor name to see calculations.
- Cost of Products Sold (Excluding Excise Taxes)
- The cost of products sold exhibits some fluctuation over the five-year period. It decreased from 4321 million USD in 2012 to 3678 million USD in 2013, suggesting an improvement in managing production or procurement costs during that year. However, this was followed by a steady increase from 2013 onward, reaching 4841 million USD by 2016. This upward trend from 2013 to 2016 indicates rising expenses related to product costs, potentially linked to increased sales volume, higher input prices, or changes in product mix.
- Accounts Payable
- Accounts payable remained relatively stable from 2012 to 2013, decreasing slightly from 187 million USD to 185 million USD. A noticeable decline to 142 million USD occurred in 2014, presenting a reduction in outstanding obligations to suppliers or shorter payment terms. Subsequently, there was an increase in accounts payable over the next two years, rising to 179 million USD in 2015 and further to 221 million USD in 2016. This may reflect changes in supplier credit terms, increased purchasing activity, or adjustments in working capital management.
- Payables Turnover Ratio
- The payables turnover ratio shows varying performance across the reported years. It decreased from 23.11 in 2012 to 19.88 in 2013, suggesting that the company took longer to pay its suppliers during 2013 compared to 2012. Subsequently, there was a significant increase to 28.58 in 2014, indicating a faster payment cycle. The ratio then declined to 26.19 in 2015 and further to 21.9 in 2016, showing a slowdown in the payment process after 2014. The fluctuations in this ratio imply changing payment practices or negotiation of supplier credit terms during this period.
Working Capital Turnover
Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | ||
---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | ||||||
Current assets | ||||||
Less: Current liabilities | ||||||
Working capital | ||||||
Net sales, includes excise taxes | ||||||
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-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).
1 2016 Calculation
Working capital turnover = Net sales, includes excise taxes ÷ Working capital
= ÷ =
2 Click competitor name to see calculations.
The financial data reveals several notable trends in the analyzed periods.
- Working Capital
- Working capital exhibited significant volatility throughout the five-year span. It started at a positive value of 1,043 million US dollars in 2012, then fell sharply to 579 million in 2013. This downward trajectory continued, resulting in a negative position of -221 million in 2014. The company's working capital recovered somewhat in 2015, reaching 896 million, but again deteriorated sharply to -747 million in 2016. These fluctuations indicate challenges in maintaining consistent liquidity and operational efficiency.
- Net Sales (includes excise taxes)
- Net sales demonstrated a generally positive and upward trend across the period. Sales were 12,227 million US dollars in 2012 and experienced a slight decline in 2013 to 11,966 million, followed by a modest increase in 2014 to 12,096 million. From 2014 onward, net sales increased more robustly, reaching 14,884 million in 2015 and further growing to 16,846 million in 2016. This upward trajectory suggests growth in revenue generation capacity despite fluctuations in working capital.
- Working Capital Turnover Ratio
- The working capital turnover ratio, which indicates how efficiently the company uses its working capital to generate sales, showed some irregularities. It started at 11.72 in 2012, rose markedly to 20.67 in 2013, then the data is missing for 2014. In 2015, the ratio declined to 16.61. No value is provided for 2016. The initial increase suggests improved efficiency in 2013, but the subsequent decline in 2015 points to potential operational inefficiencies. Missing data limits full trend analysis over the entire period.
In summary, while net sales consistently trended upward, indicative of revenue growth, working capital experienced notable fluctuations including negative values in certain years, potentially signaling liquidity or operational management issues. The working capital turnover ratio data, although incomplete, hints at variable efficiency in utilizing working capital to support sales. Together, these patterns suggest revenue growth was not consistently matched by effective management of short-term assets and liabilities.
Average Inventory Processing Period
Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | ||
---|---|---|---|---|---|---|
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-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).
1 2016 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ =
2 Click competitor name to see calculations.
The analysis of the financial data reveals notable trends in inventory management over the five-year period from 2012 to 2016.
- Inventory Turnover
- The inventory turnover ratio shows a declining trend from 4.39 in 2012 to 2.7 in 2015, indicating a decrease in the frequency of inventory being sold and replenished during the year. In 2016, there is a slight recovery to 2.94, although it remains significantly lower than the 2012 level. This downward trend suggests potential challenges in inventory management or a shift in sales velocity, possibly implying slower movement of goods or increased inventory levels.
- Average Inventory Processing Period
- Corresponding to the decrease in inventory turnover, the average inventory processing period, expressed in number of days, has increased markedly from 83 days in 2012 to a peak of 135 days in 2015. This indicates that, on average, inventory remained in stock for a longer period before being sold. In 2016, the average period slightly decreased to 124 days but still remains substantially higher than in 2012, demonstrating a sustained elongation in inventory holding.
Overall, the data reflects a pattern of inventory moving less efficiently through the company's operations over the period analyzed, with a peak inefficiency in 2015 followed by a moderate improvement in 2016. The extended inventory processing times and reduced turnover may have implications for working capital management and operational efficiency.
Average Receivable Collection Period
Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | ||
---|---|---|---|---|---|---|
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-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).
1 2016 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ =
2 Click competitor name to see calculations.
- Receivables Turnover
- The receivables turnover ratio exhibited notable fluctuations over the five-year period. Starting at 140.54 in 2012, it declined progressively to 112.89 in 2013 and further to 104.28 in 2014, indicating a slower collection of receivables during these years. However, a significant improvement occurred in 2015 and 2016, with the ratio sharply increasing to 218.88 and then to 255.24, respectively. This upward trend suggests a substantial enhancement in the efficiency of collecting receivables in the latter years.
- Average Receivable Collection Period
- The average receivable collection period remained relatively low throughout the period and displayed a consistent decreasing trend after 2014. It was steady at 3 days in 2012 and 2013, slightly increased to 4 days in 2014, then improved significantly to 2 days in 2015 and 1 day in 2016. This pattern corresponds with the increase in receivables turnover, confirming faster collection of receivables and improved cash flow management in the last two years.
- Overall Analysis
- The data indicates an initial weakening in receivables management between 2012 and 2014, followed by marked optimization in 2015 and 2016. The sharp rise in receivables turnover coupled with the reduction in average collection period points to more effective credit and collection policies or improved customer payment behavior. This trend likely contributed positively to liquidity and operational efficiency in the final years examined.
Operating Cycle
Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | ||
---|---|---|---|---|---|---|
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-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).
1 2016 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= + =
2 Click competitor name to see calculations.
- Inventory Management
- The average inventory processing period showed an increasing trend from 83 days in 2012 to a peak of 135 days in 2015, followed by a slight decline to 124 days in 2016. This indicates that the company generally took longer to process its inventory over the analyzed period, with a minor improvement in the final year.
- Receivables Collection
- The average receivable collection period remained consistently low throughout the period, starting at 3 days in 2012 and 2013, slightly increasing to 4 days in 2014, then improving significantly to 2 days in 2015 and further to 1 day in 2016. This pattern suggests enhanced efficiency in collecting receivables over the years.
- Operating Cycle
- The operating cycle duration mirrored the inventory processing trend, increasing from 86 days in 2012 to 137 days in 2015 and then decreasing to 125 days in 2016. The operating cycle's movement indicates a lengthening in the total time span for converting inventory and receivables into cash, with improvement noted in the last year.
Average Payables Payment Period
Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | ||
---|---|---|---|---|---|---|
Selected Financial Data | ||||||
Payables turnover | ||||||
Short-term Activity Ratio (no. days) | ||||||
Average payables payment period1 | ||||||
Benchmarks (no. days) | ||||||
Average Payables Payment Period, Competitors2 | ||||||
Coca-Cola Co. | ||||||
Mondelēz International Inc. | ||||||
PepsiCo Inc. | ||||||
Philip Morris International Inc. |
Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).
1 2016 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ =
2 Click competitor name to see calculations.
- Payables Turnover Ratio
- The payables turnover ratio exhibited noticeable fluctuations over the five-year period. It started at 23.11 in 2012, decreased to 19.88 in 2013, indicating a slower rate of payment to suppliers. Subsequently, it rose sharply to 28.58 in 2014, suggesting a faster payment cycle. This elevated level slightly decreased to 26.19 in 2015 and further declined to 21.9 by the end of 2016. Overall, the ratio shows variability but with a general trend of acceleration in payments around 2014 followed by a moderation.
- Average Payables Payment Period (Days)
- The average payables payment period reflects the inverse behavior of the turnover ratio. It began at 16 days in 2012 and increased to 18 days in 2013, indicating that payments were taking longer to settle. The period then shortened significantly to 13 days in 2014, aligning with the peak in turnover ratio, meaning payments were made more promptly. It increased modestly to 14 days in 2015 and rose again to 17 days in 2016. This pattern confirms a period of quicker payments around 2014, followed by a gradual extension of the payment period in the subsequent years.
- Overall Interpretation
- The data illustrate a dynamic approach to payables management over the assessed period. The company appears to have accelerated payments in 2014, possibly to leverage supplier relationships or capture early payment benefits, reflected in the elevated turnover ratio and shortened payment period. However, from 2015 onward, there is a tendency to slow down payments slightly, which may signal strategic cash flow management or changes in credit terms with suppliers. Despite this, payables turnover and payment periods remain within a range that suggests reasonably consistent payment practices without extreme delays.
Cash Conversion Cycle
Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | ||
---|---|---|---|---|---|---|
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 | ||||||
Coca-Cola Co. | ||||||
Mondelēz International Inc. | ||||||
PepsiCo Inc. | ||||||
Philip Morris International Inc. |
Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).
1 2016 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= + – =
2 Click competitor name to see calculations.
- Inventory Management
- The average inventory processing period showed a significant upward trend from 83 days in 2012 to a peak of 135 days in 2015, followed by a slight improvement to 124 days in 2016. This indicates a lengthening time for inventory turnover over the analyzed period, potentially reflecting slower inventory movement or changes in stock management.
- Receivables Collection
- The average receivable collection period remained relatively low and stable, fluctuating minimally between 3 days in 2012 and 1 day in 2016, with a slight increase to 4 days in 2014. The overall trend suggests efficient management of receivables, enabling rapid cash inflows from customers.
- Payables Payment
- The average payables payment period experienced moderate fluctuations, starting at 16 days in 2012, rising to 18 days in 2013, then declining to 13 days in 2014, before increasing again to 17 days in 2016. These variations indicate some changes in the company's payment practices to suppliers, which could affect cash outflows timing.
- Cash Conversion Cycle
- The cash conversion cycle followed an increasing trajectory from 70 days in 2012 to a peak of 123 days in 2015, then improved slightly to 108 days in 2016. This pattern largely mirrors the trend in inventory processing periods, suggesting that longer inventory holding periods were key drivers of the extended cash conversion cycle, potentially impacting overall liquidity.