Analytical steps.Select a specific company’s sales/revenue to forecast (sometimes other things can be forecast ifyou get permission from me). The company must be a publicly held company, been in...

Analytical steps.Select a specific company’s sales/revenue to forecast (sometimes other things can be forecast ifyou get permission from me). The company must be a publicly held company, been in businessfor at least 5 years and have at least $100m in sales and not going bankrupt. (Be aware thatmany companies are owned by someone else so you may have difficulty finding sales data). Thecompany cannot be on the list of unapproved companies. Obtain the sales for the latest 13-16quarters (should have sales for all of 2018 thru most of 2021). You can get this information fromwww.sec.gov. Quarterly sales (for quarters 1, 2, 3) are in the 10-Q reports and annual sales are inthe 10-K reports which are used then to figure out quarter 4.Sections in your paper (and the approximate length in the word document) and pointvalue (the point value includes the corresponding excel calculations). In each sectionyou will be discussing your analysis and the results (not detailed math calculations).Assume that you are writing to this to your boss (or even higher in the organization) andyou are explaining what you did and the results. You will submit the word document andthe excel spreadsheet.Word Document(1 point) Cover Page (Make sure you identify the company)(3 points) Current Status (1 1/2 pages)(7 points) Seasonality/Trend (1/2 page)(25 points) Deseasonalized Forecasts (1 1/2 pages)(4 points) Seasonalized Forecasts (1/2 page)(3 points) Recommended Forecast (1/2 page)Appendix(1 point) Works cited(1 point) Income statement example (1 page)(from SEC documents)Excel Spreadsheet.This will contain all your calculations and be easy to follow. Follow a similarformat to the class handout for chapter 3. Your spreadsheet will not be exactly the samesince you have more data, will need to calculate an average index and will be doingexponential smoothing twice.If your write up is not well organized and I have to look for information, you will lose points.Chose the parameters for your forecasts from the following table using the first four letters ofyour last name (if the last name is less than 4 letters then use you first name for the remainingletters). Include your choices on your spreadsheet so that I can easily verify what you used.a-i j-q r-zMov. Ave -1st letter 3 periods 4 periods 3 periodsWt. Mov. Ave. - 2nd letter wts. 5,3,1 wts. 7,4,2,1 wts. 3,2,1Exp. Smoothing - 3rd letter  = .7 and .2  = .6 and .3  = .5 and .2Trend Adj. -4th letter  = .6  = .2  = .5  = .25  = .4  = .3