Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).
Short-term activity ratio | Description | The company |
---|---|---|
Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Twenty-First Century Fox Inc. inventory turnover ratio improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level. |
Receivables turnover | An activity ratio equal to revenue divided by receivables. | Twenty-First Century Fox Inc. receivables turnover ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018. |
Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Twenty-First Century Fox Inc. payables turnover ratio decreased from 2016 to 2017 but then slightly increased from 2017 to 2018. |
Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Twenty-First Century Fox Inc. working capital turnover ratio deteriorated from 2016 to 2017 and from 2017 to 2018. |
Short-term activity ratio | Description | The company |
---|---|---|
Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Twenty-First Century Fox Inc. number of days of inventory outstanding improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level. |
Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Twenty-First Century Fox Inc. number of days of receivables outstanding improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018. |
Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Twenty-First Century Fox Inc. operating cycle improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level. |
Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | |
Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Twenty-First Century Fox Inc. cash conversion cycle improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level. |
Inventory Turnover
Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | Jun 30, 2015 | Jun 30, 2014 | Jun 30, 2013 | ||
---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | |||||||
Operating expenses | 19,769) | 17,775) | 17,129) | 18,561) | 21,108) | 17,496) | |
Inventories, net | 3,669) | 3,101) | 3,291) | 2,749) | 3,092) | 2,784) | |
Short-term Activity Ratio | |||||||
Inventory turnover1 | 5.39 | 5.73 | 5.20 | 6.75 | 6.83 | 6.28 | |
Benchmarks | |||||||
Inventory Turnover, Competitors2 | |||||||
Walt Disney Co. | 23.51 | — | — | — | — | — |
Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).
1 2018 Calculation
Inventory turnover = Operating expenses ÷ Inventories, net
= 19,769 ÷ 3,669 = 5.39
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Twenty-First Century Fox Inc. inventory turnover ratio improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level. |
Receivables Turnover
Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | Jun 30, 2015 | Jun 30, 2014 | Jun 30, 2013 | ||
---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | |||||||
Revenues | 30,400) | 28,500) | 27,326) | 28,987) | 31,867) | 27,675) | |
Receivables, net | 7,120) | 6,477) | 6,258) | 5,912) | 6,468) | 5,459) | |
Short-term Activity Ratio | |||||||
Receivables turnover1 | 4.27 | 4.40 | 4.37 | 4.90 | 4.93 | 5.07 | |
Benchmarks | |||||||
Receivables Turnover, Competitors2 | |||||||
Alphabet Inc. | — | — | — | — | — | — | |
Comcast Corp. | — | — | — | — | — | — | |
Meta Platforms Inc. | — | — | — | — | — | — | |
Netflix Inc. | — | — | — | — | — | — | |
Walt Disney Co. | 6.37 | — | — | — | — | — |
Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).
1 2018 Calculation
Receivables turnover = Revenues ÷ Receivables, net
= 30,400 ÷ 7,120 = 4.27
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Receivables turnover | An activity ratio equal to revenue divided by receivables. | Twenty-First Century Fox Inc. receivables turnover ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018. |
Payables Turnover
Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | Jun 30, 2015 | Jun 30, 2014 | Jun 30, 2013 | ||
---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | |||||||
Operating expenses | 19,769) | 17,775) | 17,129) | 18,561) | 21,108) | 17,496) | |
Accounts payable | 443) | 406) | 270) | —) | —) | —) | |
Short-term Activity Ratio | |||||||
Payables turnover1 | 44.63 | 43.78 | 63.44 | — | — | — | |
Benchmarks | |||||||
Payables Turnover, Competitors2 | |||||||
Alphabet Inc. | — | — | — | — | — | — | |
Comcast Corp. | — | — | — | — | — | — | |
Meta Platforms Inc. | — | — | — | — | — | — | |
Netflix Inc. | — | — | — | — | — | — | |
Walt Disney Co. | 5.03 | — | — | — | — | — |
Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).
1 2018 Calculation
Payables turnover = Operating expenses ÷ Accounts payable
= 19,769 ÷ 443 = 44.63
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Twenty-First Century Fox Inc. payables turnover ratio decreased from 2016 to 2017 but then slightly increased from 2017 to 2018. |
Working Capital Turnover
Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | Jun 30, 2015 | Jun 30, 2014 | Jun 30, 2013 | ||
---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | |||||||
Current assets | 19,333) | 16,286) | 14,949) | 17,376) | 15,376) | 15,567) | |
Less: Current liabilities | 8,244) | 7,238) | 7,068) | 7,262) | 8,856) | 8,435) | |
Working capital | 11,089) | 9,048) | 7,881) | 10,114) | 6,520) | 7,132) | |
Revenues | 30,400) | 28,500) | 27,326) | 28,987) | 31,867) | 27,675) | |
Short-term Activity Ratio | |||||||
Working capital turnover1 | 2.74 | 3.15 | 3.47 | 2.87 | 4.89 | 3.88 | |
Benchmarks | |||||||
Working Capital Turnover, Competitors2 | |||||||
Alphabet Inc. | — | — | — | — | — | — | |
Comcast Corp. | — | — | — | — | — | — | |
Meta Platforms Inc. | — | — | — | — | — | — | |
Netflix Inc. | — | — | — | — | — | — | |
Walt Disney Co. | — | — | — | — | — | — |
Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).
1 2018 Calculation
Working capital turnover = Revenues ÷ Working capital
= 30,400 ÷ 11,089 = 2.74
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Twenty-First Century Fox Inc. working capital turnover ratio deteriorated from 2016 to 2017 and from 2017 to 2018. |
Average Inventory Processing Period
Twenty-First Century Fox Inc., average inventory processing period calculation, comparison to benchmarks
Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | Jun 30, 2015 | Jun 30, 2014 | Jun 30, 2013 | ||
---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||
Inventory turnover | 5.39 | 5.73 | 5.20 | 6.75 | 6.83 | 6.28 | |
Short-term Activity Ratio (no. days) | |||||||
Average inventory processing period1 | 68 | 64 | 70 | 54 | 53 | 58 | |
Benchmarks (no. days) | |||||||
Average Inventory Processing Period, Competitors2 | |||||||
Walt Disney Co. | 16 | — | — | — | — | — |
Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).
1 2018 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 5.39 = 68
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Twenty-First Century Fox Inc. number of days of inventory outstanding improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level. |
Average Receivable Collection Period
Twenty-First Century Fox Inc., average receivable collection period calculation, comparison to benchmarks
Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | Jun 30, 2015 | Jun 30, 2014 | Jun 30, 2013 | ||
---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||
Receivables turnover | 4.27 | 4.40 | 4.37 | 4.90 | 4.93 | 5.07 | |
Short-term Activity Ratio (no. days) | |||||||
Average receivable collection period1 | 85 | 83 | 84 | 74 | 74 | 72 | |
Benchmarks (no. days) | |||||||
Average Receivable Collection Period, Competitors2 | |||||||
Alphabet Inc. | — | — | — | — | — | — | |
Comcast Corp. | — | — | — | — | — | — | |
Meta Platforms Inc. | — | — | — | — | — | — | |
Netflix Inc. | — | — | — | — | — | — | |
Walt Disney Co. | 57 | — | — | — | — | — |
Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).
1 2018 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 4.27 = 85
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Twenty-First Century Fox Inc. number of days of receivables outstanding improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018. |
Operating Cycle
Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | Jun 30, 2015 | Jun 30, 2014 | Jun 30, 2013 | ||
---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||
Average inventory processing period | 68 | 64 | 70 | 54 | 53 | 58 | |
Average receivable collection period | 85 | 83 | 84 | 74 | 74 | 72 | |
Short-term Activity Ratio | |||||||
Operating cycle1 | 153 | 147 | 154 | 128 | 127 | 130 | |
Benchmarks | |||||||
Operating Cycle, Competitors2 | |||||||
Walt Disney Co. | 73 | — | — | — | — | — |
Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).
1 2018 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 68 + 85 = 153
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Twenty-First Century Fox Inc. operating cycle improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level. |
Average Payables Payment Period
Twenty-First Century Fox Inc., average payables payment period calculation, comparison to benchmarks
Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | Jun 30, 2015 | Jun 30, 2014 | Jun 30, 2013 | ||
---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||
Payables turnover | 44.63 | 43.78 | 63.44 | — | — | — | |
Short-term Activity Ratio (no. days) | |||||||
Average payables payment period1 | 8 | 8 | 6 | — | — | — | |
Benchmarks (no. days) | |||||||
Average Payables Payment Period, Competitors2 | |||||||
Alphabet Inc. | — | — | — | — | — | — | |
Comcast Corp. | — | — | — | — | — | — | |
Meta Platforms Inc. | — | — | — | — | — | — | |
Netflix Inc. | — | — | — | — | — | — | |
Walt Disney Co. | 73 | — | — | — | — | — |
Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).
1 2018 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 44.63 = 8
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. |
Cash Conversion Cycle
Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | Jun 30, 2015 | Jun 30, 2014 | Jun 30, 2013 | ||
---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||
Average inventory processing period | 68 | 64 | 70 | 54 | 53 | 58 | |
Average receivable collection period | 85 | 83 | 84 | 74 | 74 | 72 | |
Average payables payment period | 8 | 8 | 6 | — | — | — | |
Short-term Activity Ratio | |||||||
Cash conversion cycle1 | 145 | 139 | 148 | — | — | — | |
Benchmarks | |||||||
Cash Conversion Cycle, Competitors2 | |||||||
Walt Disney Co. | 0 | — | — | — | — | — |
Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).
1 2018 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 68 + 85 – 8 = 145
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Twenty-First Century Fox Inc. cash conversion cycle improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level. |