Export to Excel Export to OpenOffice.org Print version

Diageo PLC (DEO) | Analysis of Equity Method Investment

Selected Financial Data

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Diageo PLC's selected financial data

USD $ in millions, translated from GBP £

Export to Excel Export to OpenOffice.org
    Jun 30, 2011 Jun 30, 2010 Jun 30, 2009 Jun 30, 2008 Jun 30, 2007 Jun 30, 2006
chart Share of associates' profits after tax
chart Investments in associates
   
chart ROA (equity method investments only)1 % % % % % %

Source: Based on data from Diageo PLC Annual Reports

2011 Calculations

1 ROA (equity method investments only) = 100 × Share of associates' profits after tax ÷ Investments in associates
= 100 × ÷ = %

Item Description The company
Share of associates' profits after tax This item represents the entity's proportionate share for the period of the net income (loss) of its investee (such as unconsolidated subsidiaries and joint ventures) to which the equity method of accounting is applied. Such amount typically reflects adjustments similar to those made in preparing consolidated statements, including adjustments to eliminate intercompany gains and losses, and to amortize, if appropriate, any difference between cost and underlying equity in net assets of the investee at the date of investment. Diageo PLC's share of associates' profits after tax declined from 2009 to 2010 but then increased from 2010 to 2011 exceeding 2009 level.
Investments in associates This item represents the carrying amount on the entity's balance sheet of its investment in common stock of an equity method investee. This is not an indicator of the fair value of the investment, rather it is the initial cost adjusted for the entity's share of earnings and losses of the investee, adjusted for any distributions (dividends) and other than temporary impairment losses recognized. Diageo PLC's investments in associates declined from 2009 to 2010 but then increased from 2010 to 2011 exceeding 2009 level.
ROA (equity method investments only) A profitability ratio calculated as share of associates' profits after tax divided by investments in associates. Diageo PLC's ROA of equity method investments deteriorated from 2009 to 2010 but then slightly improved from 2010 to 2011.

Summarized Financial Information

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Summarized financial information for Diageo PLC's affiliates, subsidiaries, associates, and joint ventures

USD $ in millions, translated from GBP £

Export to Excel Export to OpenOffice.org
    Jun 30, 2011 Jun 30, 2010 Jun 30, 2009 Jun 30, 2008 Jun 30, 2007 Jun 30, 2006
chart Non-current assets
chart Current assets
chart Total assets
chart Current liabilities
chart Non-current liabilities
chart Total liabilities
chart Net assets
chart Total liabilities and equity
chart Sales
chart Profit for the year

Source: Based on data from Diageo PLC Annual Reports

Item Description The company
Net assets This item represents the disclosure of summarized financial information for unconsolidated subsidiaries and 50 percent-or-less owned entities accounted for using the equity method of accounting. If investments in common stock of corporate joint ventures or other investments accounted for under the equity method are, in the aggregate, material in relation to the financial position or results of operations of an investor, it may be necessary to present summarized information as to assets, liabilities, and results of operations of the investee, or group of investments for which combined disclosure is appropriate, either by individual financial statement caption or in groups, as appropriate. Such summarized financial information may include total equity or capital (as applicable). Net assets of Diageo PLC's affiliates, subsidiaries, associates, and joint ventures declined from 2009 to 2010 but then increased from 2010 to 2011 exceeding 2009 level.
Profit for the year This item represents the disclosure of summarized financial information for unconsolidated subsidiaries and 50 percent-or-less owned entities accounted for using the equity method of accounting. If investments in common stock of corporate joint ventures or other investments accounted for under the equity method are, in the aggregate, material in relation to the financial position or results of operations of an investor, it may be necessary to present summarized information as to assets of the investee, or group of investments for which combined disclosure is appropriate, either by individual financial statement caption or in groups, as appropriate. Such summarized financial information may, at a minimum, include net income or loss. Profit for the year of Diageo PLC's affiliates, subsidiaries, associates, and joint ventures declined from 2009 to 2010 but then increased from 2010 to 2011 exceeding 2009 level.

Adjustments to Financial Data: Proportionate Consolidation

Recognition of Diageo PLC's proportionate share of affiliates, subsidiaries, associates, and joint ventures assets and liabilities instead of net equity.

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Diageo PLC, adjustments to financial data

USD $ in millions, translated from GBP £

Export to Excel Export to OpenOffice.org
    Jun 30, 2011 Jun 30, 2010 Jun 30, 2009 Jun 30, 2008 Jun 30, 2007 Jun 30, 2006
chart Weighted average percentage interest in affiliates % % % % % %
  Adjustment to Current Assets
chart Current assets (as reported)
chart Add: Current assets of affiliates (adjustment)
chart Current assets (adjusted)
  Adjustment to Total Assets
chart Total assets (as reported)
chart Less: Investments in associates (adjustment)
chart Add: Total assets of affiliates (adjustment)
chart Total assets (adjusted)
  Adjustment to Current Liabilities
chart Current liabilities (as reported)
chart Add: Current liabilities of affiliates (adjustment)
chart Current liabilities (adjusted)
  Adjustment to Total Liabilities
chart Total liabilities (as reported)
chart Add: Total liabilities of affiliates (adjustment)
chart Total liabilities (adjusted)
  Adjustment to Sales
chart Sales (as reported)
chart Add: Sales of affiliates (adjustment)
chart Sales (adjusted)

Adjusted Ratios: Proportionate Consolidation (Summary)

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Diageo PLC, adjusted ratios

Export to Excel Export to OpenOffice.org
    Jun 30, 2011 Jun 30, 2010 Jun 30, 2009 Jun 30, 2008 Jun 30, 2007 Jun 30, 2006
  Current Ratio
chart Reported current ratio
chart Adjusted current ratio
  Net Profit Margin
chart Reported net profit margin % % % % % %
chart Adjusted net profit margin % % % % % %
  Total Asset Turnover
chart Reported total asset turnover
chart Adjusted total asset turnover
  Financial Leverage
chart Reported financial leverage
chart Adjusted financial leverage
  Return on Assets (ROA)
chart Reported ROA % % % % % %
chart Adjusted ROA % % % % % %
Ratio Description The company
Adjusted current ratio A liquidity ratio calculated as adjusted current assets divided by adjusted current liabilities. Diageo PLC's adjusted current ratio improved from 2009 to 2010 but then deteriorated significantly from 2010 to 2011.
Adjusted net profit margin An indicator of profitability, calculated as net income divided by adjusted revenue. Diageo PLC's adjusted net profit margin deteriorated from 2009 to 2010 but then improved from 2010 to 2011 exceeding 2009 level.
Adjusted total asset turnover An activity ratio calculated as adjusted total revenue divided by adjusted total assets. Diageo PLC's adjusted total asset turnover deteriorated from 2009 to 2010 but then improved from 2010 to 2011 exceeding 2009 level.
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
Diageo PLC's adjusted financial leverage declined from 2009 to 2010 and from 2010 to 2011.
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Diageo PLC's adjusted ROA deteriorated from 2009 to 2010 but then improved from 2010 to 2011 exceeding 2009 level.

Adjusted Current Ratio

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel Export to OpenOffice.org
    Jun 30, 2011 Jun 30, 2010 Jun 30, 2009 Jun 30, 2008 Jun 30, 2007 Jun 30, 2006
  As Reported
chart Current assets (USD $ in millions, translated from GBP £)
chart Current liabilities (USD $ in millions, translated from GBP £)
   
chart Current ratio1
  Adjusted: from Equity Method to Proportionate Consolidation
chart Adjusted current assets (USD $ in millions, translated from GBP £)
chart Adjusted current liabilities (USD $ in millions, translated from GBP £)
   
chart Adjusted current ratio2

2011 Calculations

1 Current ratio = Current assets ÷ Current liabilities
= ÷ =

2 Adjusted current ratio = Adjusted current assets ÷ Adjusted current liabilities
= ÷ =

Ratio Description The company
Adjusted current ratio A liquidity ratio calculated as adjusted current assets divided by adjusted current liabilities. Diageo PLC's adjusted current ratio improved from 2009 to 2010 but then deteriorated significantly from 2010 to 2011.

Adjusted Net Profit Margin

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel Export to OpenOffice.org
    Jun 30, 2011 Jun 30, 2010 Jun 30, 2009 Jun 30, 2008 Jun 30, 2007 Jun 30, 2006
  As Reported
chart Profit for the year attributable to equity shareholders of the parent company (USD $ in millions, translated from GBP £)
chart Sales (USD $ in millions, translated from GBP £)
   
chart Net profit margin1 % % % % % %
  Adjusted: from Equity Method to Proportionate Consolidation
chart Profit for the year attributable to equity shareholders of the parent company (USD $ in millions, translated from GBP £)
chart Adjusted sales (USD $ in millions, translated from GBP £)
   
chart Adjusted net profit margin2 % % % % % %

2011 Calculations

1 Net profit margin = 100 × Profit for the year attributable to equity shareholders of the parent company ÷ Sales
= 100 × ÷ = %

2 Adjusted net profit margin = 100 × Profit for the year attributable to equity shareholders of the parent company ÷ Adjusted sales
= 100 × ÷ = %

Ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as net income divided by adjusted revenue. Diageo PLC's adjusted net profit margin deteriorated from 2009 to 2010 but then improved from 2010 to 2011 exceeding 2009 level.

Adjusted Total Asset Turnover

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel Export to OpenOffice.org
    Jun 30, 2011 Jun 30, 2010 Jun 30, 2009 Jun 30, 2008 Jun 30, 2007 Jun 30, 2006
  As Reported
chart Sales (USD $ in millions, translated from GBP £)
chart Total assets (USD $ in millions, translated from GBP £)
   
chart Total asset turnover1
  Adjusted: from Equity Method to Proportionate Consolidation
chart Adjusted sales (USD $ in millions, translated from GBP £)
chart Adjusted total assets (USD $ in millions, translated from GBP £)
   
chart Adjusted total asset turnover2

2011 Calculations

1 Total asset turnover = Sales ÷ Total assets
= ÷ =

2 Adjusted total asset turnover = Adjusted sales ÷ Adjusted total assets
= ÷ =

Ratio Description The company
Adjusted total asset turnover An activity ratio calculated as adjusted total revenue divided by adjusted total assets. Diageo PLC's adjusted total asset turnover deteriorated from 2009 to 2010 but then improved from 2010 to 2011 exceeding 2009 level.

Adjusted Financial Leverage

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel Export to OpenOffice.org
    Jun 30, 2011 Jun 30, 2010 Jun 30, 2009 Jun 30, 2008 Jun 30, 2007 Jun 30, 2006
  As Reported
chart Total assets (USD $ in millions, translated from GBP £)
chart Equity attributable to equity shareholders of the parent company (USD $ in millions, translated from GBP £)
   
chart Financial leverage1
  Adjusted: from Equity Method to Proportionate Consolidation
chart Adjusted total assets (USD $ in millions, translated from GBP £)
chart Equity attributable to equity shareholders of the parent company (USD $ in millions, translated from GBP £)
   
chart Adjusted financial leverage2

2011 Calculations

1 Financial leverage = Total assets ÷ Equity attributable to equity shareholders of the parent company
= ÷ =

2 Adjusted financial leverage = Adjusted total assets ÷ Equity attributable to equity shareholders of the parent company
= ÷ =

Ratio Description The company
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
Diageo PLC's adjusted financial leverage declined from 2009 to 2010 and from 2010 to 2011.

Adjusted Return On Assets (ROA)

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel Export to OpenOffice.org
    Jun 30, 2011 Jun 30, 2010 Jun 30, 2009 Jun 30, 2008 Jun 30, 2007 Jun 30, 2006
  As Reported
chart Profit for the year attributable to equity shareholders of the parent company (USD $ in millions, translated from GBP £)
chart Total assets (USD $ in millions, translated from GBP £)
   
chart ROA1 % % % % % %
  Adjusted: from Equity Method to Proportionate Consolidation
chart Profit for the year attributable to equity shareholders of the parent company (USD $ in millions, translated from GBP £)
chart Adjusted total assets (USD $ in millions, translated from GBP £)
   
chart Adjusted ROA2 % % % % % %

1 ROA = 100 × Profit for the year attributable to equity shareholders of the parent company ÷ Total assets
= 100 × ÷ = %

2 Adjusted ROA = 100 × Profit for the year attributable to equity shareholders of the parent company ÷ Adjusted total assets
= 100 × ÷ = %

Ratio Description The company
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Diageo PLC's adjusted ROA deteriorated from 2009 to 2010 but then improved from 2010 to 2011 exceeding 2009 level.

May 23, 2012

Existing users sign in

Forgot your password?