Question
Task Description You are working as a consultant for an investment advisory firm, 'Let's Invest in Australia', based in Launceston. Your CEO knows that you
Task Description You are working as a consultant for an investment advisory firm, 'Let's Invest in Australia', based in Launceston. Your CEO knows that you are using Excel for calculations and Tableau for data visualization. Therefore, your firm has given you the important task of providing investment advice to a potential international client. Required You are provided with a dataset of accounting data for publicly listed companies in Australia. You are required to calculate the risk of bankruptcy for companies included in the materials using Altman's Z-Score. Based on these scores, you are required to create a data visualisation using Tableau based on the map of Australia showing the states/territories with the companies that have the lowest and highest risks of bankruptcy. Finally, you are required to write a report (1500 words maximum) to provide investment and risk-related advice to investors willing to invest in the Australian materials sector. More details are available below. Data you are going to use for this assessment- 1- Your potential client is willing to invest in the Australian materials sector. The given data includes 2023 data of companies listed on the Australian Stock Exchange, so you need to use data related to the materials sector. 2- Select a company from the list of companies in the materials sector included in the given dataset. Note that no two students are allowed to choose the same company. So, to avoid any confusion later, you are advised to announce your company selection using the discussion forum 'Announce your company selection'. Also, read previous announcements to ensure that the company you have decided to select has not been selected by someone else. 3- Download the selected company's 2023 annual report and analyse the risk-related information published in it. Based on the information included in the selected company's annual report, you need to inform the potential investor about some of the risks associated with investments in the Australian materials sector, including environmental risks such as climate change. 4- Read the context and other information below to know more about the task.3 Context Below is the email you have received from your manager- Hello [Your Names], We have a new American client in the Materials industry looking to invest in Australia. The client requires us to conduct several analyses that will be helpful for them in deciding about investment in the Australian materials sector. Specifically, the client requires us to calculate Altman's Z-Score for materials sector companies listed on the ASX. The dataset containing data from the Australian companies listed on the ASX is attached. The client has asked us to use Tableau to create a Choropleth Map of Australia to display the average Z-scores of materials sector companies from each Australian state, using a green-to-red colour scheme, with green indicating low bankruptcy risk and red indicating high risk. The map will help identify states with the highest bankruptcy risk, which may be more cost-effective for the client's investments. The client requires us to write a report containing the following information- i.) An overview of the Australian materials sector and industries included in the Australian materials sector ii.) Inform the potential investor company how climate change and global warming may impact the Australian materials sector and how Australia's 'net zero emissions' by 2050 plan will impact the sector. iii.) Calculation of company-wise and state-wise Altman's Z score iv.) An analysis of the Tableau visualization using a Chloropleth map v.) Any disadvantages of using a Chloropleth map and how these disadvantages can be controlled4 iv.) A discussion on the critical analysis of Altman's Z score as a bankruptcy predictor. Your report should also include information about other bankruptcy predictors commonly used. The report should also include your recommendations about the bankruptcy predictors that can be used for the given data. vi.) Investment recommendations based on the insights you have witnessed while analysing the data vii.) Risk associated with investment in the Australian material sector including environmental risks. The client has asked me to present the key recommendations and submit the report by Friday 11 May. If you have any questions or require further information, don't hesitate to contact me.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started