Select a specific company’s sales/revenue to forecast (sometimes other things can be forecast if you get permission from me). The company must be a publicly held company, been in business for at least...

Select a specific company’s sales/revenue to forecast (sometimes other things can be forecast if you get permission from me). The company must be a publicly held company, been in business for at least 5 years and have at least $100m in sales and not going bankrupt. (Be aware that many companies are owned by someone else so you may have difficulty finding sales data). The company cannot be on the list of unapproved companies. Obtain the sales for the latest 13-16 quarters (should have sales for all of 2018 thru most of 2021). You can get this information from www.sec.gov. Quarterly sales (for quarters 1, 2, 3) are in the 10-Q reports and annual sales are in the 10-K reports which are used then to figure out quarter 4.
Seasonality/Trend. Deseasonalize the sales. Plot the original sales and the deseasonalized sales on one graph. Do the original sales have seasonality? Do the original sales have a trend? Justify your answers. There is no such thing as a seasonality trend.
Preliminary Report . Write up the Cover page and Seasonality/Trend section of the final paper. Turn in your write up and 13-16 quarters of sales data for your company on the excel spreadsheet and the calculated deseasonalized sales and the graph. Have everything clearly labeled. You will turn in the excel spreadsheet and a word document.*** The purpose is to make sure you are started on the project, obtained the sales data and were able to deseasonalize the sales correctly. If these are not done correctly the result of the work is invalid.Cover Page (Make sure you identify the company)
Seasonality/Trend (1/2 page)