Stock Analysis on Net

Reynolds American Inc. (NYSE:RAI)

$22.49

This company has been moved to the archive! The financial data has not been updated since May 3, 2017.

Analysis of Short-term (Operating) Activity Ratios

Microsoft Excel

Paying user area


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Short-term Activity Ratios (Summary)

Reynolds American Inc., short-term (operating) activity ratios

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
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-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

Reynolds American Inc., inventory turnover calculation, comparison to benchmarks

Microsoft Excel
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

Reynolds American Inc., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
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

Reynolds American Inc., payables turnover calculation, comparison to benchmarks

Microsoft Excel
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

Reynolds American Inc., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
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

Reynolds American Inc., average inventory processing period calculation, comparison to benchmarks

Microsoft Excel
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

Reynolds American Inc., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
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

Reynolds American Inc., operating cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
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

Reynolds American Inc., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
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

Reynolds American Inc., cash conversion cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
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.