Great Deal! Get Instant $25 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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...

1 answer below »
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 XXXXXXXXXXYou 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)
Answered 6 days AfterMar 11, 2022

Solution

Rochak answered on Mar 11 2022
79 Votes
Sheet1
    Company    T-Mobile
    (in million U.S. Dollars)
    Year    Quarter    Sales     Deseasonalized...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here