Logged out
Access All our Essays in an Instant
Swap your work for FREE access, or pay £4.99 for instant access
Financial Statement Analysis
Member rating: No Rating | Words: | Submitted: Mon Sep 27 2004
Page Preview
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
GSN 404: Financial Statement Analysis Assignment No 1 Student : Aloke Shirolkar (n4848853) Word Count : 995 Table of Contents Introduction 3 Data 3 Calculations 4 Discussion 8 Liquidity 8 Management Efficiency 9 Conclusion 10 Bibliography 10 Introduction Scope of the Assignment 1. To calculate the net working capital for each of the three years 2000, 2001, 2002 for Woolworths and Coles 2. Commenting on the strength and Weakness that are revealed by the figures. 3. Comparing and contrasting the two companies, as well as commenting on any trends observed over the three year period Data The following data has been obtained from annual reports of Woolworth and Coles. Woolworth - (Table1) Current Assets 2000 $m 2001 $m 2002 $m Cash 350 256 295 Receivables 164 194.9 258.6 Inventories 1648.3 1731.8 1838.4 Property, plant and equipment 98 126.8 98.3 Other 84.8 79 97.7 Total 2345.1 2388.5 2588.0 Woolworth (Table 2) Current Liabilities 2000 $m 2001 $m 2002 $m Accounts Payable 1571.8 1666.4 2000.6 Accruals 334.3 399 440.1 Interest bearing Liabilities 341.7 34.1 Current tax Liabilities 125 113.4 Borrowings 129.9 Provisions 558.9 427.3 509.6 Total 2594.9 2959.4 3097.8 Coles Myer Ltd (Table 3) Current Assets 2000 $m 2001 $m 2002 $m Cash 263.2 578.1 866 Receivables 487.5 397.5 295.7 Inventories 2917.7 2904.2 2808.9 Property, plant and equipment Other 41.4 66.3 53.2 Total 3709.8 3946.1 4023.8 Coles Myer Ltd (Table 4) Current Liabilities 2000 $m 2001 $m 2002 $m Accounts Payable 2245.0 2164 2270.7 Accruals Interest bearing Liabilities 127.8 15.3 Loans Current tax Liabilities Borrowings 44.1 Provisions 716.5 626.7 640.6 Total 3005.6 2918.5 2926.6 Calculations Working Capital = Current Assets - Current Liabilities Woolworth (Table 4 ) - Working Capital Woolworth's 2000 m$ 2001 m$ 2002 m$ Working Capital - 249.8 - 570.9 -509.8 Coles Myer Ltd (Table 5) - Working Capital Coles Myer 2000 m$ 2001 m$ 2002 m$ Working Capital 704.2 1027.6 1097.2 The following calculations have been made for...
Get instant access
- Instant, unlimited access to our documents in full
- Swap your work for free access, or pay £4.99
- To see the full version of this document and 146,871 others
Receive email updates for this category
- Simply tell us your email address and receive a weekly Study Help Email for FREE
- Receive 3 FREE essay views with each email
- Get all the latest essays from Coursework.Info & discussion from TheStudentRoom.co.uk
