PDBA Online MFA Syndicate Assignment. Financial Analysis of a Listed Company. February 2023 The purpose of this assignment is to analyse the performance of a JSE listed company. The historical financial data will be provided to you. You can choose a company from the list below. Clicks (CLS) Woolworths (WHL) Pick n Pay (PIK) Shoprite (SHP) Truworths (TRU) Mr Price (MRP) Part 1 Ratio Calculations 30/100 Calculate the following category of ratios: 1. Profitability a. Gp% b. OP% c. PAT% 2. Activity a. WCTO b. FATO c. NATO d. Debtor Days e. Creditor days f. Stock days 3. Liquidity g. Current test h. Interest cover 4. Leverage i. D/E j. D/TC k. Leverage 5. RONA = Po x A 6. ROE = Pa x A x L Part 2 Performance Analysis Write up 70/100 Produce a graphical story line with the appropriate commentary that describes the performance of the business over the last 10 years. A Note on the mark allocation for this section: 40 of the 70 marks for Part 2 are allocated to your graphical and written story using the ratios from categories 1,2,3 &4. 30 of the 70 marks for Part 2 are allocated to your graphical and written story using the ratios from categories 5 & 6. In this section it is important to show how the performance ratios are connect to the ratios in categories 1,2,3 &4. A Note on the overall submission: Your submission should consist of 1 PDF document with everything that you need to tell the story of your chosen business. The quality of your graphs is important. Graphs should be constructed so that they are clear and well labelled. The reader should not have to ask any questions about what is going on in the graph. Be careful not to clutter your graphs with too much data. The quality of your writing is important. You should be clear, concise, and specific. WHL WOOLWORTHS HOLDINGS LTD NameOfRow Income Statement 30-Jun-12 30-Jun-13 30-Jun-14 30-Jun-15 30-Jun-16 30-Jun-17 30-Jun-18 30-Jun-19 30-Jun-20 30-Jun-21 30-Jun-22 31-Jan-01 TheDate 02020060 Turnover 28,604,000,000 35,227,000,000 39,707,000,000 56,506,000,000 65,004,000,000 67,411,000,000 68,592,000,000 75,179,000,000 74,058,000,000 80,942,000,000 82,255,000,000 Sales T/O GROWTH 12.7% 42.3% 14.7% 4.0% 1.8% 9.6% -1.8% 9.6% 1.6% 01020053 Cost of Sales 18,419,000,000 21,674,000,000 24,209,000,000 33,356,000,000 38,618,000,000 40,739,000,000 41,700,000,000 45,139,000,000 46,859,000,000 49,816,000,000 50,831,000,000 CostOfSales 02020094 Gross Profit 10,185,000,000 13,553,000,000 15,498,000,000 23,150,000,000 26,386,000,000 26,672,000,000 26,892,000,000 30,040,000,000 27,199,000,000 31,126,000,000 31,424,000,000 GP% 35.6% 38.5% 39.0% 41.0% 40.6% 39.6% 39.2% 40.0% 36.7% 38.5% 38.2% Expenses 6,893,000,000 9,329,000,000 10,683,000,000 15,873,000,000 17,592,000,000 17,097,000,000 19,944,000,000 23,227,000,000 20,781,000,000 22,004,000,000 22,983,000,000 Expenses 02020088 Depreciation 463,000,000 534,000,000 640,000,000 1,245,000,000 1,514,000,000 1,640,000,000 1,692,000,000 1,675,000,000 1,762,000,000 1,671,000,000 1,530,000,000 Depreciation 02020098 Operating profit (EBIT) 2,687,000,000 3,469,000,000 3,943,000,000 5,587,000,000 6,969,000,000 7,626,000,000 (1,668,000,000) 5,121,000,000 4,726,000,000 7,451,000,000 6,911,000,000 OPeratingProfit OP% 9.4% 9.8% 9.9% 9.9% 10.7% 11.3% -2.4% 6.8% 6.4% 9.2% 8.4% 01020074 Total Interest Paid 38,000,000 68,000,000 136,000,000 1,494,000,000 1,494,000,000 1,494,000,000 1,494,000,000 1,139,000,000 2,688,000,000 2,502,000,000 1,953,000,000 InteerestAndFinanceCharges 02020064 Interest Received 82,000,000 57,000,000 112,000,000 116,000,000 48,000,000 96,000,000 71,000,000 76,000,000 62,000,000 83,000,000 67,000,000 Interest Received 02020099 Profit Before Tax 2,870,000,000 3,647,000,000 4,104,000,000 4,432,000,000 6,033,000,000 6,726,000,000 (2,434,000,000) (1,800,000,000) 1,402,000,000 5,150,000,000 5,190,000,000 ProfitBeforeTax 02020067 Taxation 811,000,000 1,009,000,000 1,114,000,000 1,312,000,000 1,680,000,000 1,278,000,000 1,115,000,000 (716,000,000) 843,000,000 987,000,000 1,473,000,000 Taxation 02020100 Profit After Interest and Tax 2,059,000,000 2,638,000,000 2,990,000,000 3,120,000,000 4,353,000,000 5,448,000,000 (3,549,000,000) (1,084,000,000) 559,000,000 4,163,000,000 3,717,000,000 ProfitAfterTax PAT% 7.2% 7.5% 7.5% 5.5% 6.7% 8.1% -5.2% -1.4% 0.8% 5.1% 4.5% 01090358 Ordinary Dividends Paid 1,261,000,000 1,640,000,000 1,999,000,000 2,146,000,000 2,176,000,000 3,014,000,000 2,781,000,000 - - - 1,417,000,000 OrdinaryDividend 01020082 Retained Profits 798,000,000 998,000,000 991,000,000 974,000,000 2,177,000,000 2,434,000,000 (6,823,000,000) (2,644,000,000) (4,339,000,000) 3,778,000,000 2,878,000,000 RetainedProfits Balance sheet 30-Jun-12 30-Jun-13 30-Jun-14 30-Jun-15 30-Jun-16 30-Jun-17 30-Jun-18 30-Jun-19 30-Jun-20 30-Jun-21 30-Jun-22 31-Jan-01 Total Equity 4,572,000,000 5,904,000,000 6,952,000,000 14,297,000,000 19,853,000,000 19,066,000,000 13,126,000,000 9,443,000,000 6,510,000,000 9,328,000,000 11,800,000,000 TotalEquity 02010002 Ordinary Share Capital 1,000,000 1,000,000 678,000,000 10,802,000,000 11,237,000,000 11,375,000,000 11,399,000,000 9,696,000,000 9,685,000,000 9,750,000,000 9,171,000,000 OrdinaryShareCapital 02010003 Share Premium 94,000,000 431,000,000 - - - - - - - - - SharePremium 02010004 Non-Distributable Reserves (993,000,000) (928,000,000) (741,000,000) (1,914,000,000) 1,826,000,000 (1,283,000,000) (409,000,000) 253,000,000 1,664,000,000 637,000,000 808,000,000 NonDistributableReserve 02010005 Distributable Reserves 5,363,000,000 6,115,000,000 6,692,000,000 5,363,000,000 6,763,000,000 8,946,000,000 2,123,000,000 (521,000,000) (4,860,000,000) (1,082,000,000) 1,796,000,000 CumRetainedProfits 02010012 Outside Shareholders Interest 107,000,000 285,000,000 323,000,000 46,000,000 27,000,000 28,000,000 13,000,000 15,000,000 21,000,000 23,000,000 25,000,000 OutsideShareholdersInterest 02010008 Preference Shares - - - - - - - - - - - PreferanceShares 02010014 Deferred Tax 360,000,000 360,000,000 332,000,000 516,000,000 6,000,000 658,000,000 758,000,000 63,000,000 - - 3,000,000 DefferedTax SY0001 Lease Liability - - - 28,599,000,000 27,194,000,000 26,784,000,000 02010015 Other Non-Current Liabilities 792,000,000 843,000,000 963,000,000 2,634,000,000 2,850,000,000 2,541,000,000 2,607,000,000 3,666,000,000 1,924,000,000 2,411,000,000 2,157,000,000 OtherNonCurrentLiabilities 02010020 Long Term Interest Bearing 25,000,000 705,000,000 623,000,000 14,922,000,000 15,703,000,000 12,137,000,000 11,711,000,000 13,259,000,000 16,023,000,000 5,963,000,000 4,813,000,000 LongTermInterestLoan Total Capital 5,749,000,000 7,812,000,000 8,870,000,000 32,369,000,000 38,412,000,000 34,402,000,000 28,202,000,000 26,431,000,000 53,056,000,000 44,896,000,000 45,557,000,000 TotalCapital 02010023 Fixed Assets 2,331,000,000 2,726,000,000 3,519,000,000 14,508,000,000 15,402,000,000 13,846,000,000 13,959,000,000 14,295,000,000 15,134,000,000 9,315,000,000 9,190,000,000 TotalFixedAssets 02010025 Intangible Assets 1,219,000,000 2,440,000,000 2,946,000,000 15,700,000,000 18,965,000,000 19,595,000,000 13,410,000,000 7,283,000,000 8,228,000,000 7,135,000,000 7,451,000,000 IntangibleAssets 02010031 Investments & Loans 756,000,000 856,000,000 907,000,000 949,000,000 1,019,000,000 1,057,000,000 1,034,000,000 810,000,000 742,000,000 1,006,000,000 1,093,000,000 InvestmentsandLoans SY0002 Right Of Use Assets - - - 20,519,000,000 19,116,000,000 18,891,000,000 02010030 Other Non-Current Assets 705,000,000 819,000,000 820,000,000 2,047,000,000 3,664,000,000 208,000,000 247,000,000 1,815,000,000 4,691,000,000 3,566,000,000 3,642,000,000 OtherNonCurrentAssets Net Current Assets 738,000,000 971,000,000 678,000,000 (835,000,000) (638,000,000) (304,000,000) (448,000,000) 2,228,000,000 3,742,000,000 4,758,000,000 5,290,000,000 NetCurrentAssets 02010034 Current Assets 5,034,000,000 5,347,000,000 14,077,000,000 8,251,000,000 10,340,000,000 10,287,000,000 11,497,000,000 11,726,000,000 15,752,000,000 15,450,000,000 15,812,000,000 CurrentAssets 02010035 Inventory 2,216,000,000 2,901,000,000 3,436,000,000 5,881,000,000 7,117,000,000 6,990,000,000 7,542,000,000 8,325,000,000 8,054,000,000 8,501,000,000 8,709,000,000 Inventory 02010036 Trade Receivables 672,000,000 879,000,000 1,090,000,000 1,270,000,000 1,402,000,000 1,258,000,000 1,661,000,000 1,410,000,000 2,160,000,000 1,277,000,000 1,703,000,000 TradeReceivables 02010037 Cash & Near Cash 2,145,000,000 1,562,000,000 9,542,000,000 891,000,000 1,525,000,000 1,787,000,000 2,023,000,000 1,913,000,000 5,534,000,000 5,624,000,000 5,374,000,000 CashAndNearCash 02010038 Dividends Receivable - - - - - - - - - - - DividendsReceivable 02010039 Tax Receivable 1,000,000 5,000,000 9,000,000 209,000,000 296,000,000 252,000,000 271,000,000 78,000,000 4,000,000 48,000,000 26,000,000 TaxReceivable 02010041 Current Liabilities 4,296,000,000 4,376,000,000 13,399,000,000 9,086,000,000 10,978,000,000 10,591,000,000 11,945,000,000 9,498,000,000 12,010,000,000 10,692,000,000 10,522,000,000 CurrentLiabilities 02010042 Trade Payables 3,402,000,000 4,142,000,000 5,171,000,000 8,631,000,000 10,370,000,000 9,377,000,000 9,672,000,000 8,289,000,000 10,762,000,000 9,625,000,000 10,211,000,000 TradePayables 02010043 Dividends Payable - - - - - - - - - - - DividendsPayable 02010044 Tax Payable 368,000,000 107,000,000 189,000,000 259,000,000 393,000,000 26,000,000 124,000,000 151,000,000 75,000,000 390,000,000 28,000,000 TaxPayable 02010045 Short-Term Interest Bearing 526,000,000 127,000,000 8,039,000,000 196,000,000 215,000,000 1,188,000,000 2,149,000,000 1,134,000,000 1,097,000,000 1,097,000,000 1,097,000,000 ShortTermInterestBearing Net Assets 5,749,000,000 7,812,000,000 8,870,000,000 32,369,000,000 38,412,000,000 34,402,000,000 28,202,000,000 26,431,000,000 53,056,000,000 44,896,000,000 45,557,000,000 NetAssets