AI Tokens
Stock Analysis on Net

Time Warner Inc. (NYSE:TWX)

This company has been moved to the archive! The financial data has not been updated since April 26, 2018.

Analysis of Short-term (Operating) Activity Ratios

Microsoft Excel

Short-term Activity Ratios (Summary)

Turnover Ratios

Average No. Days

Time Warner Inc., short-term (operating) activity ratios

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Turnover Ratios
Inventory turnover 7.35 7.94 9.22 9.34 8.00
Receivables turnover 3.33 3.37 3.79 3.54 3.79
Payables turnover 22.71 31.07 24.74 27.66 23.42
Working capital turnover 27.38 7.75 6.23 6.88 6.68
Average No. Days
Average inventory processing period 50 46 40 39 46
Add: Average receivable collection period 110 108 96 103 96
Operating cycle 160 154 136 142 142
Less: Average payables payment period 16 12 15 13 16
Cash conversion cycle 144 142 121 129 126

Based on: 10-K (reporting date: 2017-12-31), 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).


An analysis of the short-term activity ratios from 2013 to 2017 reveals a general trend of declining operational efficiency in asset management, countered by a significant shift in working capital utilization in the final year of the period.

Inventory and Receivables Management
A downward trend in asset turnover is observed. Inventory turnover peaked in 2014 at 9.34 before declining to 7.35 by 2017, which corresponds with the average inventory processing period increasing from 39 to 50 days. Similarly, receivables turnover decreased from 3.79 in 2013 to 3.33 in 2017. This decline is reflected in the average receivable collection period, which extended from 96 days to 110 days, indicating a slowing rate of cash recovery from customers.
Payables and Liability Turnover
Payables turnover exhibited significant volatility, reaching a peak of 31.07 in 2016 before dropping to 22.71 in 2017. Despite these fluctuations, the average payables payment period remained consistently short, ranging between 12 and 16 days. This suggests a disciplined or constrained approach to supplier payments, maintaining a rapid payment cycle regardless of the fluctuations in turnover ratios.
Operating and Cash Conversion Cycles
The operating cycle shows a general expansion, rising from 136 days in 2015 to 160 days by 2017. Because the payables payment period remained relatively stable and short, the cash conversion cycle followed a similar upward trajectory, increasing from 121 days in 2015 to 144 days in 2017. This indicates that more capital is being tied up in operations for longer durations.
Working Capital Efficiency
Working capital turnover remained relatively stable between 6.23 and 7.75 from 2013 through 2016. However, a substantial increase is observed in 2017, where the ratio climbed to 27.38. This sharp spike suggests a significant reduction in net working capital relative to revenue or a dramatic increase in the efficiency of utilizing short-term assets and liabilities to generate sales.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Inventory Turnover

Time Warner Inc., inventory turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Costs of revenues 17,647 16,376 16,154 15,875 16,230
Inventories 2,401 2,062 1,753 1,700 2,028
Short-term Activity Ratio
Inventory turnover1 7.35 7.94 9.22 9.34 8.00
Benchmarks
Inventory Turnover, Competitors2
Walt Disney Co. — — — — —

Based on: 10-K (reporting date: 2017-12-31), 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).

1 2017 Calculation
Inventory turnover = Costs of revenues ÷ Inventories
= 17,647 ÷ 2,401 = 7.35

2 Click competitor name to see calculations.


The analysis of operating activity ratios from 2013 to 2017 reveals a period of initial efficiency gain followed by a gradual decline in inventory turnover. While costs of revenues remained relatively stable for the first four years before rising in 2017, the volume of inventories held increased significantly in the latter half of the period, negatively impacting the turnover rate.

Cost of Revenues Trends
Costs of revenues exhibited minor fluctuations between 2013 and 2016, ranging from US$ 15,875 million to US$ 16,376 million. A more pronounced increase occurred in 2017, reaching US$ 17,647 million, which represents a notable upward shift in the cost of generating revenue toward the end of the period.
Inventory Level Fluctuations
Inventories decreased from US$ 2,028 million in 2013 to a low of US$ 1,700 million in 2014. Subsequently, a consistent upward trend is observed, with inventory levels climbing annually to reach US$ 2,401 million by December 31, 2017. This growth indicates a substantial increase in the capital tied up in unsold inventory.
Inventory Turnover Performance
The inventory turnover ratio peaked in 2014 at 9.34, reflecting the most efficient movement of inventory relative to the cost of revenues during the analyzed timeframe. However, the ratio entered a steady decline thereafter, falling to 9.22 in 2015, 7.94 in 2016, and ending at 7.35 in 2017. This downward trajectory suggests that inventory is being liquidated more slowly, potentially indicating an accumulation of excess stock or a decrease in operational efficiency.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Receivables Turnover

Time Warner Inc., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Revenues 31,271 29,318 28,118 27,359 29,795
Receivables, less allowances 9,401 8,699 7,411 7,720 7,868
Short-term Activity Ratio
Receivables turnover1 3.33 3.37 3.79 3.54 3.79
Benchmarks
Receivables Turnover, Competitors2
Alphabet Inc. — — — — —
Comcast Corp. — — — — —
Meta Platforms Inc. — — — — —
Netflix Inc. — — — — —
Walt Disney Co. — — — — —

Based on: 10-K (reporting date: 2017-12-31), 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).

1 2017 Calculation
Receivables turnover = Revenues ÷ Receivables, less allowances
= 31,271 ÷ 9,401 = 3.33

2 Click competitor name to see calculations.


The financial performance between 2013 and 2017 is characterized by a recovery in revenue growth coupled with a simultaneous increase in outstanding receivables, leading to a general decline in the efficiency of credit collections.

Revenue Trends
Annual revenues experienced a decline in 2014, dropping to 27,359 million US dollars from 29,795 million US dollars in 2013. Following this dip, a consistent growth pattern emerged, with revenues increasing every year to reach a period peak of 31,271 million US dollars by December 31, 2017.
Receivables Trajectory
Net receivables showed a slight downward trend in the first three years, reaching a minimum of 7,411 million US dollars in 2015. However, a significant reversal occurred in 2016 and 2017, with receivables increasing to 8,699 million and 9,401 million US dollars, respectively. The growth in receivables in the final two years significantly outpaced the growth in revenues.
Receivables Turnover Analysis
The receivables turnover ratio reflects a deterioration in operational efficiency over the analyzed period. While the ratio remained stable at 3.79 in 2013 and 2015, it declined to 3.37 in 2016 and further to 3.33 in 2017. This downward trend indicates that the company is taking longer to collect payments from its customers, resulting in a slower conversion of receivables into cash.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Payables Turnover

Time Warner Inc., payables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Costs of revenues 17,647 16,376 16,154 15,875 16,230
Accounts payable 777 527 653 574 693
Short-term Activity Ratio
Payables turnover1 22.71 31.07 24.74 27.66 23.42
Benchmarks
Payables Turnover, Competitors2
Alphabet Inc. — — — — —
Comcast Corp. — — — — —
Meta Platforms Inc. — — — — —
Netflix Inc. — — — — —
Walt Disney Co. — — — — —

Based on: 10-K (reporting date: 2017-12-31), 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).

1 2017 Calculation
Payables turnover = Costs of revenues ÷ Accounts payable
= 17,647 ÷ 777 = 22.71

2 Click competitor name to see calculations.


The analysis of short-term operating activity reveals significant volatility in the payables turnover ratio between 2013 and 2017, indicating fluctuations in the efficiency and timing of supplier payments.

Costs of Revenues and Accounts Payable Trends
Costs of revenues remained relatively stable from 2013 through 2016, ranging between 15,875 and 16,376 million US dollars, before increasing to 17,647 million US dollars in 2017. During the same period, accounts payable exhibited inconsistent movement, reaching a five-year low of 527 million US dollars in 2016 and a five-year peak of 777 million US dollars in 2017.
Payables Turnover Ratio Fluctuations
The payables turnover ratio experienced non-linear movement over the period. Starting at 23.42 in 2013, the ratio increased to 27.66 in 2014, dipped slightly to 24.74 in 2015, and reached its maximum value of 31.07 in 2016. This peak indicates the fastest rate of supplier payment within the analyzed timeframe.
Analysis of the 2017 Downturn
A sharp reversal occurred in 2017, with the payables turnover ratio falling to its lowest point of 22.71. This decline is directly correlated with the simultaneous increase in accounts payable to 777 million US dollars. The reduction in the turnover ratio suggests a strategic shift toward extending payment terms or a significant increase in the volume of short-term obligations relative to the costs of revenues.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Working Capital Turnover

Time Warner Inc., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Current assets 15,219 13,485 12,513 13,180 12,844
Less: Current liabilities 14,077 9,703 8,002 9,204 8,383
Working capital 1,142 3,782 4,511 3,976 4,461
 
Revenues 31,271 29,318 28,118 27,359 29,795
Short-term Activity Ratio
Working capital turnover1 27.38 7.75 6.23 6.88 6.68
Benchmarks
Working Capital Turnover, Competitors2
Alphabet Inc. — — — — —
Comcast Corp. — — — — —
Meta Platforms Inc. — — — — —
Netflix Inc. — — — — —
Walt Disney Co. — — — — —

Based on: 10-K (reporting date: 2017-12-31), 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).

1 2017 Calculation
Working capital turnover = Revenues ÷ Working capital
= 31,271 ÷ 1,142 = 27.38

2 Click competitor name to see calculations.


An analysis of the operating activity ratios between 2013 and 2017 reveals a significant shift in the efficiency and management of working capital relative to revenue generation. While revenues remained relatively stable with a positive trajectory in later years, a substantial contraction in working capital led to a dramatic increase in the turnover ratio by the end of the period.

Working Capital Trends
Working capital exhibited volatility between 2013 and 2016, fluctuating between 3,782 million and 4,511 million US dollars. However, a sharp decline occurred in 2017, where working capital dropped to 1,142 million US dollars, representing a reduction of approximately 70% compared to the previous year.
Revenue Performance
Revenues demonstrated a recovery and growth pattern after a dip in 2014. From a low of 27,359 million US dollars in 2014, revenues grew steadily each year, reaching a peak of 31,271 million US dollars in 2017. This indicates a consistent ability to generate top-line growth despite the reductions in short-term capital.
Working Capital Turnover Analysis
The working capital turnover ratio remained stable from 2013 to 2016, ranging from 6.23 to 7.75, suggesting a consistent operational relationship between current assets/liabilities and sales. In 2017, the ratio spiked to 27.38. This exponential increase was driven by the simultaneous rise in revenues and the drastic decrease in working capital. Such a high turnover ratio indicates an aggressive lean in working capital management, which may either reflect extreme operational efficiency or a potential reduction in the liquidity cushion available to support short-term obligations.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Average Inventory Processing Period

Time Warner Inc., average inventory processing period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data
Inventory turnover 7.35 7.94 9.22 9.34 8.00
Short-term Activity Ratio (no. days)
Average inventory processing period1 50 46 40 39 46
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Walt Disney Co. — — — — —

Based on: 10-K (reporting date: 2017-12-31), 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).

1 2017 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 7.35 = 50

2 Click competitor name to see calculations.


The analysis of operating activity ratios from 2013 to 2017 reveals a cyclical trend in inventory management efficiency. An initial phase of improved asset utilization was followed by a gradual decline in the speed of inventory turnover and a corresponding increase in the processing period.

Inventory Turnover
The inventory turnover ratio exhibited an upward trend in the early part of the period, rising from 8.00 in 2013 to a peak of 9.34 in 2014. Following a slight moderation to 9.22 in 2015, a consistent downward trend is observed, with the ratio falling to 7.94 in 2016 and reaching its lowest point of 7.35 in 2017. This decline suggests a reduction in the frequency of inventory replacement toward the end of the analyzed timeframe.
Average Inventory Processing Period
The average inventory processing period reflects a mirrored pattern to the turnover ratio. The period decreased from 46 days in 2013 to its most efficient level of 39 days in 2014, remaining stable at 40 days in 2015. A subsequent increase is noted, returning to 46 days in 2016 and expanding to 50 days by December 31, 2017. This indicates that inventory remained in the processing cycle longer over the final two years of the period compared to the peak efficiency seen in 2014.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Average Receivable Collection Period

Time Warner Inc., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data
Receivables turnover 3.33 3.37 3.79 3.54 3.79
Short-term Activity Ratio (no. days)
Average receivable collection period1 110 108 96 103 96
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Alphabet Inc. — — — — —
Comcast Corp. — — — — —
Meta Platforms Inc. — — — — —
Netflix Inc. — — — — —
Walt Disney Co. — — — — —

Based on: 10-K (reporting date: 2017-12-31), 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).

1 2017 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 3.33 = 110

2 Click competitor name to see calculations.


An analysis of short-term operating activity indicates a general decline in the efficiency of accounts receivable management from 2013 through 2017. While a temporary recovery in collection efficiency occurred in 2015, the subsequent two years demonstrate a consistent weakening in the speed at which credit sales are converted into cash.

Receivables Turnover
The turnover ratio exhibited volatility in the initial period, decreasing from 3.79 in 2013 to 3.54 in 2014, before returning to 3.79 in 2015. Following this peak, a sustained downward trajectory was observed, with the ratio falling to 3.37 in 2016 and further to 3.33 by the end of 2017. This overall reduction indicates a decrease in the frequency with which the company collects its average receivables balance during the year.
Average Receivable Collection Period
The collection period mirrors the turnover trend, showing a general increase in the time required to collect outstanding payments. After fluctuating between 96 and 103 days from 2013 to 2015, the period lengthened significantly to 108 days in 2016 and reached a peak of 110 days in 2017. This represents an extension of the credit-to-cash cycle by 14 days over the five-year window, signaling a slowing of cash inflows from customers.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Operating Cycle

Time Warner Inc., operating cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data
Average inventory processing period 50 46 40 39 46
Average receivable collection period 110 108 96 103 96
Short-term Activity Ratio
Operating cycle1 160 154 136 142 142
Benchmarks
Operating Cycle, Competitors2
Walt Disney Co. — — — — —

Based on: 10-K (reporting date: 2017-12-31), 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).

1 2017 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 50 + 110 = 160

2 Click competitor name to see calculations.


The operating cycle exhibits a general upward trend over the five-year period from 2013 to 2017, indicating a lengthening of the time required to convert current assets into cash. While the cycle remained relatively stable between 2013 and 2015, a significant extension occurred in 2016 and 2017, concluding at 160 days.

Average Inventory Processing Period
The inventory processing period showed initial improvement, decreasing from 46 days in 2013 to 39 days in 2014. However, this efficiency was not sustained, as the period progressively climbed to 40 days in 2015, 46 days in 2016, and reached a peak of 50 days by 2017. This represents a deterioration in inventory turnover efficiency in the latter half of the analyzed period.
Average Receivable Collection Period
The collection period constitutes the most substantial portion of the total operating cycle. After fluctuating between 96 and 103 days from 2013 to 2015, the collection period increased notably to 108 days in 2016 and 110 days in 2017. The steady increase in the time required to collect receivables suggests a decline in credit collection efficiency or a shift in customer payment terms.
Operating Cycle Integration
The combined effect of slower inventory turnover and delayed receivable collections resulted in an expanded operating cycle. The cycle reached its lowest point in 2015 at 136 days before increasing sharply to 154 days in 2016 and 160 days in 2017. This overall expansion of 18 days from 2013 to 2017 reflects a decrease in short-term operational liquidity and working capital efficiency.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Average Payables Payment Period

Time Warner Inc., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data
Payables turnover 22.71 31.07 24.74 27.66 23.42
Short-term Activity Ratio (no. days)
Average payables payment period1 16 12 15 13 16
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Alphabet Inc. — — — — —
Comcast Corp. — — — — —
Meta Platforms Inc. — — — — —
Netflix Inc. — — — — —
Walt Disney Co. — — — — —

Based on: 10-K (reporting date: 2017-12-31), 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).

1 2017 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 22.71 = 16

2 Click competitor name to see calculations.


The analysis of short-term operating activity indicates a fluctuating yet generally rapid cycle of accounts payable settlement between 2013 and 2017.

Payables Turnover
The turnover ratio exhibited volatility over the five-year period, starting at 23.42 in 2013 and reaching a peak of 31.07 in 2016. This peak represents the highest efficiency in clearing obligations during the observed timeframe. However, a significant contraction occurred in 2017, where the ratio declined to 22.71, marking the lowest turnover rate of the period.
Average Payables Payment Period
The payment period moved in inverse correlation with the turnover ratio, oscillating within a narrow range of 12 to 16 days. A downward trend in the time taken to settle obligations was observed from 2013 to 2016, reaching a minimum of 12 days. This trend reversed in 2017, as the period lengthened back to 16 days.

The consistently short duration of the payment period suggests a policy of rapid debt settlement. The alignment of the highest turnover ratio and the shortest payment period in 2016 indicates a peak in operational liquidity regarding supplier obligations, while the return to a 16-day period in 2017 suggests a shift back to the baseline activity levels observed at the start of the analysis period.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Cash Conversion Cycle

Time Warner Inc., cash conversion cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data
Average inventory processing period 50 46 40 39 46
Average receivable collection period 110 108 96 103 96
Average payables payment period 16 12 15 13 16
Short-term Activity Ratio
Cash conversion cycle1 144 142 121 129 126
Benchmarks
Cash Conversion Cycle, Competitors2
Walt Disney Co. — — — — —

Based on: 10-K (reporting date: 2017-12-31), 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).

1 2017 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 50 + 110 – 16 = 144

2 Click competitor name to see calculations.


The cash conversion cycle for Time Warner Inc. exhibits a general upward trend from 2013 to 2017, indicating a decline in the efficiency of working capital management. The cycle expanded from 126 days in 2013 to 144 days by the end of 2017, with the most significant increase occurring between 2015 and 2016.

Average Inventory Processing Period
Inventory turnover times showed moderate volatility, dipping to 39 days in 2014 before steadily increasing to 50 days by 2017. This gradual increase suggests a slowing rate of inventory movement during the latter half of the analyzed period.
Average Receivable Collection Period
The collection period serves as the primary driver of the cash conversion cycle. A general increase is observed, rising from 96 days in 2013 to 110 days in 2017. The widening gap in collection times indicates a slower conversion of credit sales into cash.
Average Payables Payment Period
The payment period remained consistently low throughout the five-year period, fluctuating within a narrow range of 12 to 16 days. This reflects a corporate practice of rapid settlement of obligations to suppliers, which provides minimal relief to the overall cash conversion cycle.

The deterioration of the cash conversion cycle is primarily attributable to the simultaneous increase in the time required to collect receivables and process inventory. Because the payables payment period remained short and stable, the company was unable to offset the lengthening of the operating cycle through extended supplier credit. Consequently, the expansion of the cycle to 144 days by 2017 suggests a greater requirement for working capital to sustain operational activities.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?