Please read the “0-My Requirement” document carefully. Brief: You need give me t

Please read the “0-My Requirement” document carefully.
Brief:
You need give me two document:
1.a 4200-word report
2.an excel. All the data analysis and processing processes are in excel.
Detail:
1.Have selected a company and four significant information events as following:
Chosen Company: NEXT Plc
Official website: https://www.nextplc.co.uk/
Stock Exchange Listing: London Stock Exchange
Period over which continuous daily price data available: 2020-2023
Natures & Dates of Four Information Events for Chosen Company:
a) 09/11/2022：Announced acquisition of Made.com Design Ltd
b) 01/12/2022: Announced acquisition of Joules
c) 08/02/2023: New executive director appointment
d) 28/03/2023: Announced acquisition of CK Acquisitions Ltd
This Four Events detail has attached in “2-Four Events Detail” file
2. Performing appropriate analysis of the impact of multiple information events on the stock returns of a public company.(Detail in Assessment instruction document)
a control is needed to model daily returns conditionally expected from
contemporaneous non-firm-specific information. The market model should be used as
the control.
Suitable tests for coefficient stability, and for the validity of the Ordinary Least
Squares assumptions, should be conducted, and appropriate modifications made to the
estimated model as necessary. The final estimated model can then be used to calculate
prediction errors (abnormal returns) in the event windows.
3.Writing up a report
Length: 4200 words (Include footnotes and the bibliography)
Reference: APA 7th
Use “Event study” and ‘Hypothesis testing’ methods to analysis if the Four Information Events have significant impact on Next PLC’s stock price fluctuations?
The two methods detail are attached in “3-Analusis method” file.
The stock price from 2020-2023 is attached in “4-Data for NEXT stock” file
The annual reports for NEXT PLC from 2020-2024 is attached in “5-Annual report” file
There is a sample report attached in “6-Sample report” file.
Some useful reference are attached in “7-Useful reference” file.
4.Others
1. I want to set the event window of each event to 7 days, that is, three days before the event starts and three days after the event ends, making a total of 7 days.
2. Estimation period is set at 8 months before the first event and 3 months after the last event.
3. FTSE ALL SHARE as market index
4. Suppose the test degree of freedom is n-2.
5. Use this formula when calculating abnormal return.
6.If you draw a table, make it like the one on the right