A B C D E F G H K RIC Year CompanyCommonName Country GICSSectorName StateorProvinceofHeadquarter StateorProvinceofLegalRegis stryName TotalCurrentAssef TotalCurrentLiabilitiesalAssets/ 1208.HK 2021 MMG Ltd Australia Materials VICTORIA NULL Metals & Mining 2159400000 1628200000 130 1208.HK 2022 MMG Lt Australia Materials CTORIA NULL Metals & Mining 1659900000 1955300000 125 1208.HK 2023 MMG Lid Australia Materials VICTORIA NULL Metals & Mining 1395100000 2201200000 119 14D.AX 2021 1414 Degrees Ltd Australia Industrials SOUTH AUSTRALIA SOUTH AUSTRALIA Electrical Equipment 4784507.644 751778.8991 10' 14D.AX 2022 1414 Degrees Ltd Australia Industrials SOUTH AUSTRALIA SOUTH AUSTRALIA Electrical Equipment 4919748.528 834031.4823 827 14D.AX 2023 1414 Degrees Ltd Australia Industrials SOUTH AUSTRALIA SOUTH AUSTRALIA Electrical Equipment 3070319.635 581095.2238 641 1712.HK 2021 Dragon Mining Ltd Australia Materials WESTERN AUSTRALIA WESTERN AUSTRALIA Metals & Mining 29111883.9 8023028.728 69 1712.HK 2022 Dragon Mining Ltd Australia Materials WESTERN AUSTRALIA WESTERN AUSTRALIA Metals & Mining 28444998.57 9647222.336 714 0 1712.HK 2023 Dragon Mining Ltd Australia Materials WESTERN AUSTRALIA WESTERN AUSTRALIA Metals & Mining 32478225.04 8317727.096 737 11 1752.HK 2021 Top Education Group Ltd Australia Consumer Discretionary NEW SOUTH WALES NEW SOUTH WALES Diversified Consumer Services 24827358.68 5842437.148 54 12 1752.HK 2022 Top Education Group Lid Australia Consumer Discretionary NEW SOUTH WALES NEW SOUTH WALES Diversified Consumer Services 26097428.01 7242576.273 51( 3 1752.HK 2023 Top Education Group Ltd Australia Consumer Discretionary NEW SOUTH WALES NEW SOUTH WALES Diversified Consumer Services 29727693.9 9579042.096 50 14 1AD.AX 1 Adalta Ltd Australia Health Care VICTORIA VICTORIA Biotechnology 6731466.833 1996738.372 67 5 1AD.AX 2022 Adalta Ltd Australia Health Care VICTORIA VICTORIA Biotechnology 7304505.648 2508132.802 73 16 1AD.AX 2023 Adalta Ltd Australia Health Care VICTORIA VICTORIA Biotechnology 5130873.579 3871739.493 51! 17 1AE.AX 2021 Aurora Energy Metals Ltd Australia Materials WESTERN AUSTRALIA WESTERN AUSTRALIA Metals & Mining 94459.73202 12836.56622 944 18 1AE.AX 2022 Aurora Energy Metals Ltd Australia Materials WESTERN AUSTRALIA WESTERN AUSTRALIA Metals & Mining 5095323.207 201536.1577 50s 19 1AE AX 2023 Aurora Energy Metals Ltd Australia Materials WESTERN AUSTRALIA WESTERN AUSTRALIA Metals & Mining 2575909.076 116548.3452 284 20 1ALAX 2021 Algorae Pharmaceuticals Ltd Australia Health Care VICTORIA VICTORIA Biotechnology 1219083.895 198756.8325 12' 21 1ALAX 2022 Algorae Pharmaceuticals Ltd Australia Health Care VICTORIA VICTORIA Biotechnology 2945737.611 165112.7965 294 1ALAX 2023 Algorae Pharmaceuticals Ltd Australia Health Care VICTORIA VICTORIA Biotechnology 2804379.562 299876.679 23 1CG.AX 2021 One Click Group Lid Australia Industrials WESTERN AUSTRALIA WESTERN AUSTRALIA Professional Services 296861.5009 58936.70004 296 24 1CG.AX 2022 One Click Group Ltd Australia Industrials WESTERN AUSTRALIA WESTERN AUSTRALIA Professional Services 2352130.428 523184.6735 284 25 1CG.AX 2023 One Click Group Lid Australia Industrials WESTERN AUSTRALIA WESTERN AUSTRALIA Professional Services 1675524.199 758435.8805 197 6 1MC.AX 2021 Morella Corporation Lid Australia Materials WESTERN AUSTRALIA WESTERN AUSTRALIA Metals & Mining 5345889.974 4874790.993 54: 27 1MC.AX 2022 Morella Corporation Ltd Australia Materials WESTERN AUSTRALIA WESTERN AUSTRALIA Metals & Mining 5469287.198 3316409.835 70' 28 1MC.AX 2023 Morella Corporation Ltd Australia Materials WESTERN AUSTRALIA WESTERN AUSTRALIA Metals & Mining 6973062.694 1272492.751 11; 29 1TT.AX 2021 Thrive Tribe Technologies Ltd Australia Information Technology NEW SOUTH WALES NEW SOUTH WALES Software 2683382.195 264094.3548 29 30 1TT.AX 2022 Thrive Tribe Technologies Ltd Australia Information Technology NEW SOUTH WALES NEW SOUTH WALES Software 890488.3822 229830.1669 117 1TTAX 2023 Thrive Tribe Technologies Lid Australia Information Technology NEW SOUTH WALES NEW SOUTH WALES Software 3914455.221 328080.5253 480 29MAX 2021 29Metals Ltd Australia Materials VICTORIA VICTORIA Metals & Mining 255438104.8 145252321.4 954 2 90 AV anon anMatale I tol Australia Material VICTORIA VISTADIA Motale . Mining 725010079 Sheet1TotalCurrentAsset . TotalCurrentLiabilities TotalAssetsReporte RetainedEarning |EBIT_ Revenue_ TotalLiabilities OperatingIncom * AccountsPay |MarketValueforCompan * 2159400000 1628200000 13024100000 -1306100000 1829700000 4255000000 11093600000 1827400000 249800000 3127909886 1659900000 1955300000 12535500000 -1132700000 754300000 3254200000 10396500000 745300000 272300000 2498123476 1395100000 2201200000 1 1900800000 -1129100000 534300000 4346500000 9777400000 531700000 322500000 2891102564 4784507.644 751778.8991 10360188.65 -15714363.91 -2202078.444 364814.912 1716253.402 -4401270.16 296268.2482 17147776.57 4919748.528 834031.4823 8275452.532 -15307155.62 -2338368.747 391016.307 1046167.542 -753807.6145 245315.9613 11191495.16 3070319.635 581095.2238 6484224.911 -16110435.62 -969729.6937 76918.97477 595400.46 -969729.6937 255027.8306 9244979.806 29111883.9 8023028.728 69187823.52 -57104275.42 2641914.898 36302190.34 25650314.72 2890206.983 35530807.97 28444998.57 9647222.336 71453487.58 -51892654.21 2757906.498 35777841.37 30169371.43 3228685.498 16810607.44 32478225.04 8317727.096 73762453.78 -48335977.88 6365301.717 41197060.81 26938294.64 5125882.746 33406681.28 24827358.68 5842437.148 54448934.91 10953819.85 1738784.875 18628766.8 17968193.51 881764.1281 1628564.359 59617539.19 26097428.01 7242576.273 51055504.56 8909852.526 1768720.628 12902758.32 18559489.88 -552768.3273 1395377.725 23992133.17 29727693.9 9579042.096 50820917.91 9557710.896 1365196.814 17896876.98 18480151.98 1717161.617 1743159.017 13416610.15 6731466.833 1996738.372 6785219.954 -22378273.81 -4060426.336 2989690.258 1996738.372 -4060426.336 161746.7327 18247856.25 7304505.648 2508132.802 7348540.788 -24589826.58 -4138723.457 1901371.224 3636836.04 -4138723.457 383342.4196 8776229.807 5130873.579 3871739.493 5154877.846 -26840722.59 -3205466.12 2354264.574 3881705.163 -3205466.12 747851.8815 8593734.702 94459.73202 12836.56622 94459.73202 -2227339.187 -166462.9712 12836.56622 -166462.9712 1559.582812 5095323.207 201536.1577 5096958.739 -3371044.877 -1321054.193 201536.1577 -1321054.193 136363.3227 12283543.21 2575909.076 116548.3452 2855407.793 -7030650.268 -3774035.93 116548.3452 -3774035.93 56481.01856 12468280.3 1219083.895 198756.8325 1231320.622 -57439045.06 -1507591.719 201081.2108 198756.8325 -1507591.719 32496.30724 4208895.24 2945737.611 165112.7965 2949533.149 -51698461.77 -1637353.613 2353.233453 165112.7965 -1645848.717 10771633.15 2804379.562 299876.679 2807692.564 -50979655.37 -1391507.516 28010.53228 299876.679 -1391507.516 11313036.37 296861.5009 58936.70004 296861.5009 -9765647.12 -348581.7585 9198.423127 58936.70004 -348581.7585 3530128.159 2352130.428 523184.6735 2849650.493 -5939445.966 -2681546.281 1108531.251 682636.3624 -4639823.407 4577123.264 1675524.199 758435.8805 1972637.443 -7632825.535 -1736425.979 2632920.875 876963.8321 -1736425.979 5623792.674 5345889.974 4874790.993 5427633.108 -221147755.5 -5422931.866 100008.2478 5059204.163 -9863933.898 67093931.04 5469287.198 3316409.835 7033462.842 -203760729.3 -3553492.93 544445.748 3514115.95 120774.0137 49859628.42 6973062.694 1272492.751 11217364.93 -199044795.5 -3334433.223 319788.0212 3765590.108 -1612285.438 23142674.04 2683382.195 264094.3548 2916727.275 -15186265.17 -2271854.779 108031.1017 264094.3548 -2271854.779 5549782.185 890488.3822 229830.1669 1171447.894 -15476885.17 -1524722.753 331440.1651 229830.1669 -1498954.502 22600.70252 1096679.319 3914455.221 328080.5253 4808279.172 -15731460.19 -982441.7558 320814.5852 3661080.559 -982441.7558 291384.1949 3635983.562 255438104.8 145252321.4 954820278.6 89264634.35 85172896.96 436153360.3 396136952.7 34876325.86 17728926.03 1126467404 oonnno120 c ananocon oc AndnnEACA 207961 An EE GEOn15907 EA B C D E G H K 1 RIC Year * CompanyCommonName Country |GICSSectorName StateorProvinceofHeadquarter StateorProvinceofLegalRegis GICSIndustryName TotalCurrentAsset |TotalCurrentLiabilities |TotalAssets| 33 29MAX 2022 29Metals Lto Australia Materials VICTORIA VICTORIA Metals & Mining 235018872 152444508 88 34 29MAX 2023 29Metals Ltd Australia Materials VICTORIA VICTORIA Metals & Mining 208835286.7 177407843.8 661 35 3DA.AX 2021 Amaero International Ltd Australia Industrials VICTORIA VICTORIA Machinery 9404756.728 1118475.808 14: 36 3DA.AX 2022 Amaero International Ltd Australia Industrials TORIA VICTORIA Machinery 8777284.741 1351335.684 15( 37 3DA.AX 2023 Amaero International Ltd Australia Industrials VICTORIA VICTORIA Machinery 6754951.172 1492637.403 12. 38 3DP AX 2021 Pointerra Ltd Australia Information Technology WESTERN AUSTRALIA WESTERN AUSTRALIA Software 4681620.167 2368848.833 62 39 3DP AX 2022 Pointerra Ltd Australia Information Technology WESTERN AUSTRALIA WESTERN AUSTRALIA Software 4904097.111 2753434.962 521 40 3DP AX 2023 Pointerra Ltd Australia Information Technology WESTERN AUSTRALIA WESTERN AUSTRALIA Software 2855394.461 4031283.538 31 ' 41 3PL.AX 2021 3P Learning Ltd Australia Consumer Discretionary NEW SOUTH WALES NEW SOUTH WALES Diversified Consumer Services 42 3PL.AX 2022 3P Learning Ltd Australia Consumer Discretionary NEW SOUTH WALES NEW SOUTH WALES Diversified Consumer Services 31456037.32 41073240.08 43 3PLAX 2023 3P Learning Ltd Australia Consumer Discretionary NEW SOUTH WALES NEW SOUTH WALES Diversified Consumer Services 28513148.69 38500816.59 17: 44 4DS.AX 2021 4DS Memory Ltd Australia Information Technology WESTERN AUSTRALIA WESTERN AUSTRALIA Semiconductors & Semiconductor Equipment 3270265.204 655797.0743 37: 45 4DS.AX 2022 4DS Memory Ltd Australia Information Technology WESTERN AUSTRALIA WESTERN AUSTRALIA Semiconductors & Semiconductor Equipment 3650375.758 164270.8772 39. 46 4DS.AX 2023 4DS Memory Ltd Australia Information Technology WESTERN AUSTRALIA WESTERN AUSTRALIA Semiconductors & Semiconductor Equipment 3773669.3 129260.4073 39( 47 4DX.AX 2021 4DMedical Ltd Australia Health Care VICTORIA VICTORIA Health Care Technology 64369531.15 6124429.215 69 48 4DX.AX 2022 4DMedical Ltd Australia Health Care VICTORIA VICTORIA Health Care Technology 40614932.34 6596520.527 512 49 4DX.AX 2023 4DMedical Ltd Australia Health Care VICTORIA VICTORIA Health Care Technology 52354397.89 11379988.67 615 50 5GG.AX 2021 Pentanet Ltd Australia Communication Services WESTERN AUSTRALIA WESTERN AUSTRALIA Diversified Telecommunication Services 25029054.73 2850737.428 391 51 5GG.AX 2022 Pentanet Ltd Australia Communication Services WESTERN AUSTRALIA WESTERN AUSTRALIA Diversified Telecommunication Services 10421166.68 5148819.588 311 52 5GG.AX 2023 Pentanet Ltd Australia Communication Services WESTERN AUSTRALIA ERN AUSTRALIA Diversified Telecommunication Services 8087191.281 5267473.253 32( 53 5GN.AX 2021 5G Networks Ltd Australia Information Technology VICTORIA VICTORIA IT Services 9549445.523 49252075.07 52. 54 5GN.AX 2022 5G Networks Ltd Australia Information Technology VICTORIA VICTORIA IT Services 13166375.68 34857529.31 90- 55 5GN.AX 2023 5G Networks Lid Australia Information Technology VICTORIA VICTORIA IT Services 13966603.34 55438456.15 771 56 88E.AX 2021 88 Energy Ltd Australia Energy WESTERN AUSTRALIA WESTERN AUSTRALIA Oil, Gas & Consumable Fuels 31565605.01 4314343.587 10 57 88E.AX 2022 88 Energy Ltd Australia Energy WESTERN AUSTRALIA WESTERN AUSTRALIA Oil, Gas & Consumable Fuels 10678405.48 919667.7976 906 58 88E.AX 2023 88 Energy Ltd Australia Energy WESTERN AUSTRALIA WESTERN AUSTRALIA Oil, Gas & Consumable Fuels 15088672.94 672066.7652 106 59 8CO.AX 2021 8Common Ltd Australia Information Technology NEW SOUTH WALES NEW SOUTH WALES Software 2602658.789 1310244.51 52: 60 8CO.AX 2022 8Common Ltd Australia Information Technology NEW SOUTH WALES NEW SOUTH WALES Software 2519892.069 1205021.151 60: 61 8CO.AX 2023 8Common Ltd Australia Information Technology NEW SOUTH WALES NEW SOUTH WALES Software 1835383.128 1706576.009 38: 62 A1G.AX 2021 African Gold Ltd Australia Materials N AUSTRALIA WESTERN AUSTRALIA Metals & Mining 2665350.186 584074.4586 63 A1G.AX 2022 African Gold Lid Australia Materials WESTERN AUSTRALIA WESTERN AUSTRALIA Metals & Mining 1036967.393 393580.7819 79 CA LAMP AV on20 African Paled It Australia Materials WESTERN ALICTDALIA WACCTCOM ALICTRALIA Matale . Mining 06701 04074 CEFORG nORG\fYou are junior data analysts at a financial consulting firm based in Australia. Your firm has been engaged by a private equity firm that is keen on investing in Australian companies in light of the current cost of living crisis. The firm is particularly concerned about the financial stability of companies and wants to ensure that their investments are safe and positioned to grow despite the challenging economic environment Your manager has asked you to conduct a preliminary assessment using Altman's Z-Score to evaluate the financial health of companies within a sector of your choice. This analysis is intended to provide initial insights, which will inform the next steps in refining the methodology or considering alternative approaches. Your Task: You've received an email from your manager outlining the specifics of the task. BEA213: Data Analytics for Accounting | Semester 2, 2024 Subject: Preliminary Assessment of Sector Resilience Amid Cost-of-Living Crisis Hello Team, We've been engaged by a private equity firm to perform a preliminary analysis of specific sectors in Australia that are most impacted by the current cost of living crisis. Our objective is to identify potential investment opportunities by assessing the financial stability of companies within these sectors. This assessment will be the first step in refining our overall strategy. Based on your analysis and recommendations, we may decide to refine this method further or potentially remove it altogether in favor of a different approach. Your assignment involves the following tasks: 1. Sector Selection: Identify a relevant sector within the Australian economy that is impacted by the cost of living crisis. You should provide a brief rationale for why you chose this sector. Consider factors such as the sector's importance to the economy, its vulnerability to economic fluctuations, or its role in addressing the cost of living crisis. 2. Work with the Data: You will receive a dataset containing financial information from companies across various sectors for the years 2021, 2022, and 2023. Your analysis should focus solely on data from 2023. The dataset includes two fields: "State or Province of Headquarter" and "State of Province of Legal Regis." You should use the "State or Province of Headquarter" for your analysis. The dataset contains some missing data. For this preliminary assessment, you should utilize the easiest approach to handle the missing data that you can find. Clearly explain your approach in the report, noting that the impact of missing data should not be significant for this preliminary analysis. Additionally, there may be some metrics in the dataset that are not relevant to the calculation of Altman's Z-Score. As you work through the data, identify and filter out these2. Work with the Data: You will receive a dataset containing financial information from companies across various sectors for the years 2021, 2022, and 2023. Your analysis should focus solely on data from 2023. The dataset includes two fields: "State or Province of Headquarter" and "State of Province of Legal Regis." You should use the "State or Province of Headquarter" for your analysis. The dataset contains some missing data. For this preliminary assessment, you should utilize the easiest approach to handle the missing data that you can find. Clearly explain your approach in the report, noting that the impact of missing data should not be significant for this preliminary analysis. Additionally, there may be some metrics in the dataset that are not relevant to the calculation of Altman's Z-Score. As you work through the data, identify and filter out these irrelevant metrics to focus on those that directly contribute to the Z-Score calculation. This will help streamline your analysis and ensure accuracy. 3. Prepare a Visualization: Using Tableau, create a visualization that showcases the financial stability of companies within your chosen sector. Specifically, you will prepare a Choropleth Map of Australia, where each state displays the average Z-Score of companies within it. The color scheme should range from green (low bankruptcy risk) to red (high bankruptcy risk). This visualization will help identify which states house the most financially vulnerable companies. Ensure that your visualization is created using your Tableau account, as this will be checked during the marking process. 4. Prepare an Executive Report: Your report should cover the following sections: Sector Overview: Provide a brief overview of your chosen sector, explaining its relevance to the cost of living crisis and the rationale for your selection. Data Analysis: Discuss your analysis process, including how you handled missing data 2 BEA213: Data Analytics for Accounting | Semester 2, 2024 and filtered the dataset. Present your key findings from the Altman's Z-Score calculations. Tableau Visualization: Include an image of your Tableau map (labeled as Figure 1) and analyze what the visualization reveals about the financial health of companies in different states. Evaluation of Methodology: Critique both Altman's Z-Score as a tool for predicting bankruptcy and the overall methodology of using a bankruptcy indicator based on the average Z-Score for all companies within each state. Discuss the usefulness of this approach for investors seeking investment opportunities. Conclusion and Recommendations: Based on your analysis, provide recommendations on how this preliminary methodology could be refined or if an alternative approach should be considered