Calculate ratios for 5 recent years at per the below:

1.Calculate Profitability ratios ( = 4 ratios)

2. Activity Ratios (=9 ratios)

3. Solvency (= 4 ratios)

4. Return on investment Ratio.

5. Liquidity ratio (= 3 ratios)

6. Profitability ratios (= 3 ratios)

7. 5 years Analysis as per the your calculations above

8. Cashflow analysis

Woolwoths

Income Statement Turnover Cost of Sales Gross Profit Expenses EBITDA Depreciation Operating profit (EBIT) Total Interest Paid Interest Received Profit Before Tax Taxation Profit After Interest and Tax Ordinary Dividends Paid Retained Profits 30-Jun-16 30-Jun-17 30-Jun-18 30-Jun-19 30-Jun-20 65,004,000,000 67,411,000,000 68,592,000,000 75,179,000,000 74,058,000,000 38,618,000,000 40,739,000,000 41,700,000,000 45,139,000,000 46,859,000,000 26,386,000,000 26,672,000,000 26,892,000,000 30,040,000,000 27,199,000,000 17,592,000,000 17,097,000,000 19,944,000,000 23,092,000,000 20,251,000,000 8,794,000,000 9,575,000,000 6,948,000,000 6,948,000,000 6,948,000,000 1,514,000,000 1,640,000,000 1,692,000,000 1,692,000,000 1,692,000,000 6,969,000,000 7,626,000,000 (1,668,000,000) 5,121,000,000 4,726,000,000 1,494,000,000 1,494,000,000 1,494,000,000 1,139,000,000 2,688,000,000 48,000,000 96,000,000 71,000,000 71,000,000 71,000,000 6,033,000,000 6,726,000,000 (2,434,000,000) (1,800,000,000 1,402,000,000 1,680,000,000 1,278,000,000 1,115,000,000 (716,000,000) 843,000,000 4,353,000,000 5,448,000,000 (3,549,000,000) (1,084,000,000) 559,000,000 2,176,000,000 3,014,000,000 2,781,000,000 1,400,000,000 2,183,000,000 (6,823,000,000) (2,644,000,000) (4,339,000,000) 30-Jun-16 30-Jun-17 30-Jun-18 19,853,000,000 19,066,000,000 13,126,000,000 11,237,000,000 11,375,000,000 11,399,000,000 30-Jun-19 9,443,000,000 9,696,000,000 30-Jun-20 6,510,000,000 9,685,000,000 Balance sheet Total Equity Ordinary Share Capital Share Premium Non-Distributable Reserves Distributable Reserves Outside Shareholders Interest 1,826,000,000 6,763,000,000 27,000,000 (1,283,000,000) 8,946,000,000 28,000,000 (409,000,000) 2,123,000,000 13,000,000 253,000,000 1,664,000,000 (521,000,000) (4,860,000,000 15,000,000 21,000,000 Deferred Tax Lease Liability Other Non-Current Liabilities Long Term Interest Bearing Total Capital 6,000,000 658,000,000 758,000,000 63,000,000 28,599,000,000 2,850,000,000 2,541,000,000 2,607,000,000 3,666,000,000 1,924,000,000 15,703,000,000 12,137,000,000 11,711,000,000 13,259,000,000 16,023,000,000 38,412,000,000 34,402,000,000 28,202,000,000 26,431,000,000 53,056,000,000 Fixed Assets Intangible Assets Investments & Loans Right Of Use Assets Other Non-Current Assets Net Current Assets Current Assets 15,402,000,000 13,846,000,000 13,959,000,000 14,295,000,000 15,134,000,000 18,965,000,000 19,595,000,000 13,410,000,000 7,283,000,000 8,228,000,000 1,019,000,000 1,057,000,000 1,034,000,000 810,000,000 742,000,000 20,519,000,000 3,664,000,000 208,000,000 247,000,000 1,815,000,000 4,691,000,000 (638,000,000) (304,000,000) (448,000,000) 2,228,000,000 3,742,000,000 10,340,000,000 10,287,000,000 11,497,000,000 11,726,000,000 15,752,000,000 Inventory Trade Receivables Cash & Near Cash Dividends Receivable Tax Receivable 7,117,000,000 1,402,000,000 1,525,000,000 6,990,000,000 1,258,000,000 1,787,000,000 7,542,000,000 1,661,000,000 2,023,000,000 8,325,000,000 1,410,000,000 1,913,000,000 8,054,000,000 2,160,000,000 5,534,000,000 296,000,000 252,000,000 271,000,000 78,000,000 4,000,000 10,978,000,000 10,591,000,000 11,945,000,000 10,370,000,000 9,377,000,000 9,672,000,000 9,498,000,000 12,010,000,000 8,289,000,000 10,762,000,000 Current Liabilities Trade Payables Dividends Payable Tax Payable Short-Term Interest Bearing 393,000,000 215,000,000 26,000,000 1,188,000,000 124,000,000 2,149,000,000 151,000,000 1,134,000,000 151,000,000 1,097,000,000 Net Assets 38,412,000,000 34,402,000,000 28,202,000,000 26,431,000,000 53,056,000,000 Income Statement Turnover Cost of Sales Gross Profit Expenses EBITDA Depreciation Operating profit (EBIT) Total Interest Paid Interest Received Profit Before Tax Taxation Profit After Interest and Tax Ordinary Dividends Paid Retained Profits 30-Jun-16 30-Jun-17 30-Jun-18 30-Jun-19 30-Jun-20 65,004,000,000 67,411,000,000 68,592,000,000 75,179,000,000 74,058,000,000 38,618,000,000 40,739,000,000 41,700,000,000 45,139,000,000 46,859,000,000 26,386,000,000 26,672,000,000 26,892,000,000 30,040,000,000 27,199,000,000 17,592,000,000 17,097,000,000 19,944,000,000 23,092,000,000 20,251,000,000 8,794,000,000 9,575,000,000 6,948,000,000 6,948,000,000 6,948,000,000 1,514,000,000 1,640,000,000 1,692,000,000 1,692,000,000 1,692,000,000 6,969,000,000 7,626,000,000 (1,668,000,000) 5,121,000,000 4,726,000,000 1,494,000,000 1,494,000,000 1,494,000,000 1,139,000,000 2,688,000,000 48,000,000 96,000,000 71,000,000 71,000,000 71,000,000 6,033,000,000 6,726,000,000 (2,434,000,000) (1,800,000,000 1,402,000,000 1,680,000,000 1,278,000,000 1,115,000,000 (716,000,000) 843,000,000 4,353,000,000 5,448,000,000 (3,549,000,000) (1,084,000,000) 559,000,000 2,176,000,000 3,014,000,000 2,781,000,000 1,400,000,000 2,183,000,000 (6,823,000,000) (2,644,000,000) (4,339,000,000) 30-Jun-16 30-Jun-17 30-Jun-18 19,853,000,000 19,066,000,000 13,126,000,000 11,237,000,000 11,375,000,000 11,399,000,000 30-Jun-19 9,443,000,000 9,696,000,000 30-Jun-20 6,510,000,000 9,685,000,000 Balance sheet Total Equity Ordinary Share Capital Share Premium Non-Distributable Reserves Distributable Reserves Outside Shareholders Interest 1,826,000,000 6,763,000,000 27,000,000 (1,283,000,000) 8,946,000,000 28,000,000 (409,000,000) 2,123,000,000 13,000,000 253,000,000 1,664,000,000 (521,000,000) (4,860,000,000 15,000,000 21,000,000 Deferred Tax Lease Liability Other Non-Current Liabilities Long Term Interest Bearing Total Capital 6,000,000 658,000,000 758,000,000 63,000,000 28,599,000,000 2,850,000,000 2,541,000,000 2,607,000,000 3,666,000,000 1,924,000,000 15,703,000,000 12,137,000,000 11,711,000,000 13,259,000,000 16,023,000,000 38,412,000,000 34,402,000,000 28,202,000,000 26,431,000,000 53,056,000,000 Fixed Assets Intangible Assets Investments & Loans Right Of Use Assets Other Non-Current Assets Net Current Assets Current Assets 15,402,000,000 13,846,000,000 13,959,000,000 14,295,000,000 15,134,000,000 18,965,000,000 19,595,000,000 13,410,000,000 7,283,000,000 8,228,000,000 1,019,000,000 1,057,000,000 1,034,000,000 810,000,000 742,000,000 20,519,000,000 3,664,000,000 208,000,000 247,000,000 1,815,000,000 4,691,000,000 (638,000,000) (304,000,000) (448,000,000) 2,228,000,000 3,742,000,000 10,340,000,000 10,287,000,000 11,497,000,000 11,726,000,000 15,752,000,000 Inventory Trade Receivables Cash & Near Cash Dividends Receivable Tax Receivable 7,117,000,000 1,402,000,000 1,525,000,000 6,990,000,000 1,258,000,000 1,787,000,000 7,542,000,000 1,661,000,000 2,023,000,000 8,325,000,000 1,410,000,000 1,913,000,000 8,054,000,000 2,160,000,000 5,534,000,000 296,000,000 252,000,000 271,000,000 78,000,000 4,000,000 10,978,000,000 10,591,000,000 11,945,000,000 10,370,000,000 9,377,000,000 9,672,000,000 9,498,000,000 12,010,000,000 8,289,000,000 10,762,000,000 Current Liabilities Trade Payables Dividends Payable Tax Payable Short-Term Interest Bearing 393,000,000 215,000,000 26,000,000 1,188,000,000 124,000,000 2,149,000,000 151,000,000 1,134,000,000 151,000,000 1,097,000,000 Net Assets 38,412,000,000 34,402,000,000 28,202,000,000 26,431,000,000 53,056,000,000