Stock Analysis on Net

Diageo PLC (NYSE:DEO)

This company has been moved to the archive! The financial data has not been updated since August 12, 2014.

Analysis of Long-term (Investment) Activity Ratios

Microsoft Excel

Long-term Activity Ratios (Summary)

Diageo PLC, long-term (investment) activity ratios

Microsoft Excel
Jun 30, 2014 Jun 30, 2013 Jun 30, 2012 Jun 30, 2011 Jun 30, 2010 Jun 30, 2009
Net fixed asset turnover 4.07 4.47 4.91 5.18 5.39 5.42
Total asset turnover 0.61 0.62 0.65 0.67 0.67 0.68
Equity turnover 2.05 2.20 2.61 2.52 3.23 3.81

Based on: 20-F (reporting date: 2014-06-30), 20-F (reporting date: 2013-06-30), 20-F (reporting date: 2012-06-30), 20-F (reporting date: 2011-06-30), 20-F (reporting date: 2010-06-30), 20-F (reporting date: 2009-06-30).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Diageo PLC net fixed asset turnover ratio deteriorated from 2012 to 2013 and from 2013 to 2014.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Diageo PLC total asset turnover ratio deteriorated from 2012 to 2013 and from 2013 to 2014.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Diageo PLC equity turnover ratio deteriorated from 2012 to 2013 and from 2013 to 2014.

Net Fixed Asset Turnover

Diageo PLC, net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2014 Jun 30, 2013 Jun 30, 2012 Jun 30, 2011 Jun 30, 2010 Jun 30, 2009
Selected Financial Data (US$ in millions, translated from GBP £)
Sales 23,611 25,666 23,734 20,559 19,945 19,859
Property, plant and equipment 5,798 5,747 4,833 3,965 3,700 3,667
Long-term Activity Ratio
Net fixed asset turnover1 4.07 4.47 4.91 5.18 5.39 5.42
Benchmarks
Net Fixed Asset Turnover, Competitors2
Altria Group Inc.
Coca-Cola Co.
Mondelēz International Inc.
PepsiCo Inc.

Based on: 20-F (reporting date: 2014-06-30), 20-F (reporting date: 2013-06-30), 20-F (reporting date: 2012-06-30), 20-F (reporting date: 2011-06-30), 20-F (reporting date: 2010-06-30), 20-F (reporting date: 2009-06-30).

1 2014 Calculation
Net fixed asset turnover = Sales ÷ Property, plant and equipment
= 23,611 ÷ 5,798 = 4.07

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Diageo PLC net fixed asset turnover ratio deteriorated from 2012 to 2013 and from 2013 to 2014.

Total Asset Turnover

Diageo PLC, total asset turnover calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2014 Jun 30, 2013 Jun 30, 2012 Jun 30, 2011 Jun 30, 2010 Jun 30, 2009
Selected Financial Data (US$ in millions, translated from GBP £)
Sales 23,611 25,666 23,734 20,559 19,945 19,859
Total assets 38,784 41,559 36,347 30,729 29,943 29,258
Long-term Activity Ratio
Total asset turnover1 0.61 0.62 0.65 0.67 0.67 0.68
Benchmarks
Total Asset Turnover, Competitors2
Altria Group Inc.
Coca-Cola Co.
Mondelēz International Inc.
PepsiCo Inc.

Based on: 20-F (reporting date: 2014-06-30), 20-F (reporting date: 2013-06-30), 20-F (reporting date: 2012-06-30), 20-F (reporting date: 2011-06-30), 20-F (reporting date: 2010-06-30), 20-F (reporting date: 2009-06-30).

1 2014 Calculation
Total asset turnover = Sales ÷ Total assets
= 23,611 ÷ 38,784 = 0.61

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Diageo PLC total asset turnover ratio deteriorated from 2012 to 2013 and from 2013 to 2014.

Equity Turnover

Diageo PLC, equity turnover calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2014 Jun 30, 2013 Jun 30, 2012 Jun 30, 2011 Jun 30, 2010 Jun 30, 2009
Selected Financial Data (US$ in millions, translated from GBP £)
Sales 23,611 25,666 23,734 20,559 19,945 19,859
Equity attributable to equity shareholders of the parent company 11,523 11,661 9,088 8,149 6,167 5,208
Long-term Activity Ratio
Equity turnover1 2.05 2.20 2.61 2.52 3.23 3.81
Benchmarks
Equity Turnover, Competitors2
Altria Group Inc.
Coca-Cola Co.
Mondelēz International Inc.
PepsiCo Inc.

Based on: 20-F (reporting date: 2014-06-30), 20-F (reporting date: 2013-06-30), 20-F (reporting date: 2012-06-30), 20-F (reporting date: 2011-06-30), 20-F (reporting date: 2010-06-30), 20-F (reporting date: 2009-06-30).

1 2014 Calculation
Equity turnover = Sales ÷ Equity attributable to equity shareholders of the parent company
= 23,611 ÷ 11,523 = 2.05

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Diageo PLC equity turnover ratio deteriorated from 2012 to 2013 and from 2013 to 2014.