BEA TASK 3 PART B (TIME SERIES ANALYSIS)
PART B (25 marks) – Group work
You are required to choose three companies from the list of companies provided below. These are companies that are listed either on the New York Stock Exchange or the NASDAQ – two of America’s top bourses. Ensure that you do not choose companies in the same industry or sector as marks will be lost. You must extract quarterly data on Turnover (Revenue or Sales), Operating Profit (Profit before interest and tax) and Net Profit after Tax from the second quarter of 2009 to the second quarter of 2014. This should give you 21 data points.
Required:
- Perform a time series analysis to identify its components which are the Random, Cyclical, Seasonal and Trend (12 marks)
- Provide comments on the components of the time series and discuss the extent to which the results of the time series help to understand what significantly affect the sales, operating profit and net profit figures. You must relate to the company’s business operations (2.5 marks)
- Perform regression analysis and use it for forecast the Revenue, operating profit and net profit figures for the third quarter of 2014. (6 marks)
- Compare forecasted figures with the actual outturn for the third quarter of 2014. Provide an explanation to the size of the difference between the forecast and the actual figure. (2.5 marks)
- Referencing will be awarded 2 marks
The above should be done in report which should be in MS Word format (Times New Roman font size 12, single-spaced). All figures and tables should be clearly labelled and embedded within the body of the report as MS Excel objects. DO NOT SUBMIT SEPARATE EXCEL FILES.
You must include a comprehensive list of references for both your data sources as well as citations. You are highly recommended to use the Harvard academic referencing style.
LIST OF COMPANIES TO CHOOSE FROM
| Listed on NYSE | Listed on NASDAQ |
| ExxonMobil | Magsilver corporation |
| Acer group | Majesco Entertainment |
| Goodrich Petroleum | Family Dollar Stores |
| ABM Industries | |
| Air Products and Chemicals | |
| Plum Creek Timber Co Inc. | |
| Royal Bank of Canada | |
| TRW Automotive holdings | |
| Tupperware Brands | |
| Extra Storage Space Inc | |
| Hewlett Packard | |
| Kellogs | |
| Kemper Corporation | |
| Oshkosh Corporation |
For a custom-written paper on the above topic, place your order now!
What We Offer:
• On-time delivery guarantee
• PhD-level writers
• Automatic plagiarism check
• 100% money-back guarantee
• 100% Privacy and Confidentiality
• High Quality custom-written papers
