The task is to produce a1000-word individual report that contains analysis and visualisation of a listed company’s share price and financial position. The analysis and visualisation should be conducted through Excel
Task:
The task is to produce a1000-word individual report that contains analysis and visualisation of a listed company’s share price and financial position. The analysis and visualisation should be conducted through Excel and Tableau, and the report should be composed by Word.
The list of companies is provided in the file “FTSE100_list.xlsx”. The specific company you need to analyse depends on the last two digits of your student number. For example, if your student number is “U22XXX56”, your company is the 56th on the list “PERSIMMON PLC ORD”.
The report should consist of 6parts: Executive summary (not included in word count), Introduction, Descriptive Analytics, Predictive Analytics, Prescriptive Analytics, and Conclusion. You can refer to the word file provided on Brightspace as a template for skeletal structure.
To complete this report,the data you need include the daily prices of your company and related benchmarks from 07/03/2022 to 08/09/2023, the 2022Annual Report, and the 2023 Annual Report of your company. The price data can be downloaded from Yahoo Finance, Google Finance, or other reliable sources.The annual reports can be found on the official website of you company, or from other reliable source (like FAME).
Learning Outcomes
This section is for information only.
The assessment task outlined above has been designed to address specific validated learning outcomes for this module. It is useful to keep in mind that these are the things you need to show in this piece of work.
- On completion of this module, students will need to demonstrate:
- Understand how to interpret data analysis results from analytical software
- Produce reports that clearly present information and data, using a range of interpretation and analytical processes.
- Use analytical techniques and methods to support organisational decision making. Reflect on their role in this process.
- Use evidence-based tools and ethical approaches to undertake responsible problem solving and critical analysis, synthesis and evaluation to support decision making.
