Part B Ind Assignment.xlsx - ACCT5001 Individual Assignment Part B Ratios NB Do not change the format of this worksheet Woolworths Limited Use 2012

Part B Ind Assignment.xlsx - ACCT5001 Individual Assignment...

This preview shows page 1 - 2 out of 3 pages.

ACCT5001 Individual Assignment - Part B: Ratios NB: Do not change the format of this worksheet Use 2012 annual reports Woolworths Limited Metcash Limited 2012 2011 2012 2011 AUD$'m AUD$m % % AUD$m AUD$m % % Sales Revenue (sale of goods only) 55,129.8 52,609.1 4.8% 100.0% 12,255.1 12,364.0 -0.9% 100.0% Cost of sales -40,792.4 -39,050.0 4.5% 74.0% -11,086.1 -11,186.9 -0.9% 90.5% Gross profit from continuing operations 14,337.4 13,559.1 5.7% 26.0% 1,169.0 1,177.1 -0.7% 9.5% All other rev/income (incl financial income & share of associate profit/(l 397.0 400.5 -0.9% 0.7% 111.7 96.2 16.1% 0.9% Operating Expenses (excl. financing/interest costs) -11,347.7 -10,666.7 6.4% 20.6% -826.3 -831.7 -0.6% 6.7% Significant items 0.0 0.0 N/A 0.0% -176.7 -6.9 2460.9% 1.4% Earnings from continuing operations before interest and tax (EBIT) 3,386.7 3,292.9 2.8% 6.1% 277.7 434.7 -36.1% 2.3% financing cost/expense -318.3 -300.1 6.1% 0.6% -80.3 -77.5 3.6% 0.7% Net Profit from continuing operations before income tax 3,068.4 2,992.8 2.5% 5.6% 197.4 357.2 -44.7% 1.6% Income tax expense -885.0 -869.2 1.8% 1.6% -71.8 -106.1 -32.3% 0.6% Profit/Loss from continuing operations after tax 2,183.4 2,123.6 2.8% 4.0% 125.6 251.1 -50.0% 1.0% Net profit/(loss) from discontinued operations -366.3 16.7 -2293.4% -0.7% -27.2 0.0 N/A -0.2% Profit for the period 1,817.1 2,140.3 -15.1% 3.3% 98.4 251.1 -60.8% 0.8% Statement of Financial Position Assets Cash and cash equivalents 833.4 1,519.6 -45.2% 3.9% 51.5 152.9 -66.3% 1.3% Trade receivables (excl. Impairment allowance, other & prepayments)
Image of page 1
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture