90.2K

Verified Solution

Link Copied!

Select a specific companys sales/revenue to forecast (other things can be forecast if you see me and get permission. 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 2020 and some of 2021). You can get this information from www.sec.gov. Quarterly sales are in the 10-Q reports and annual sales are in the 10-K reports

Avg MA2 2018 01 MA4 1 22,791,000 Index Index Deseasonal 1.01 22479051.07 Q2 2 21,735,000 0.95 22860198.56 23626750 Q3 3 22,135,000 24135250 0.92 0.96 23004885.69 24643750 Q4 4 27,846,000 25284125 1.10 1.07 26091962.97 25924500 2019 Q1 5 26,859,000 26511000 1.01 1.01 26491370.84 27097500 Q2 6 26,858,000 27166500 0.99 0.95 28248410.99 27235500 Q3 7 26,827,000 27204250 0.99 0.96 27881277.09 27173000 04 8 28,398,000 26780125 1.06 1.07 26609192.14 26387250 2020 01 9 26,609,000 26225375 1.01 1.01 26244792.68 26063500 02 10 23,715,000 25977250 0.91 0.95 24942701.12 25891000 Q3 11 25,532,000 25965500 0.98 0.96 26535384.75 26040000 Q4 12 27,708,000 26643875 1.04 1.07 25962655.67 27247750 2021 01 13 27,205,000 1.01 26832635.01 Q2 14 28,546,000 0.95 30023797.01 Q3 15 Q4 16 Seasonalized Forecasts. Seasonalize each of the five forecasts (starting in period 5). Include a table in your report (not just excel) showing all five forecasts for only the four periods into the future. Avg MA2 2018 01 MA4 1 22,791,000 Index Index Deseasonal 1.01 22479051.07 Q2 2 21,735,000 0.95 22860198.56 23626750 Q3 3 22,135,000 24135250 0.92 0.96 23004885.69 24643750 Q4 4 27,846,000 25284125 1.10 1.07 26091962.97 25924500 2019 Q1 5 26,859,000 26511000 1.01 1.01 26491370.84 27097500 Q2 6 26,858,000 27166500 0.99 0.95 28248410.99 27235500 Q3 7 26,827,000 27204250 0.99 0.96 27881277.09 27173000 04 8 28,398,000 26780125 1.06 1.07 26609192.14 26387250 2020 01 9 26,609,000 26225375 1.01 1.01 26244792.68 26063500 02 10 23,715,000 25977250 0.91 0.95 24942701.12 25891000 Q3 11 25,532,000 25965500 0.98 0.96 26535384.75 26040000 Q4 12 27,708,000 26643875 1.04 1.07 25962655.67 27247750 2021 01 13 27,205,000 1.01 26832635.01 Q2 14 28,546,000 0.95 30023797.01 Q3 15 Q4 16 Seasonalized Forecasts. Seasonalize each of the five forecasts (starting in period 5). Include a table in your report (not just excel) showing all five forecasts for only the four periods into the future

Answer & Explanation Solved by verified expert

See Answer