Question: Using the TGT Quarterly Sales (Target Corp.) data: a. Create a line chart of sales. Do you see a trend? Do you see any seasonality?

Using the TGT Quarterly Sales (Target Corp.) data:

a. Create a line chart of sales. Do you see a trend? Do you see any seasonality? If so, what is the frequency?

b. Using the procedures detailed in the chapter, decompose the time series into the trend, seasonality, and irregular components.

c. Which of the time series methodologies discussed in the chapter would likely be the most appropriate for forecasting Target’s sales?


Data from Target Corp.

Target Corporation Quarterly Revenue and Net Income





Report DateFiscal YearFiscal QuarterRevenueNet Income
4/30/20062006112,863554
7/31/20062006213,347609
10/31/20062006313,570506
1/31/20072006419,7101,119
4/30/20072007114,041651
7/31/20072007214,620686
10/31/20072007314,835483
1/31/20082007419,8711,028
4/30/20082008114,802602
7/31/20082008215,472634
10/31/20082008315,114369
1/31/20092008419,560609
4/30/20092009114,833522
7/31/20092009215,067594
10/31/20092009315,276436
1/31/20102009420,181936
4/30/20102010115,593671
7/31/20102010215,532679
10/31/20102010315,605535
1/31/20112010420,6611,035
4/30/20112011115,935689
7/31/20112011216,240704
10/31/20112011316,402555
1/31/20122011421,288981
4/30/20122012116,867697
7/31/20122012216,779704
10/31/20122012316,929637
1/31/20132012422,726961
4/30/20132013116,706498
7/31/20132013217,117611
10/31/20132013317,258341
1/31/20142013421,515520
4/30/20142014117,050418
7/31/20142014217,406234
10/31/20142014317,732352
1/31/20152014421,751960
4/30/20152015117,119651
7/31/20152015217,427773
10/31/20152015317,613476
1/31/20162015421,6261,421
4/30/20162016116,196614
7/31/20162016216,169625
10/31/20162016316,441608
1/31/20172016420,690821
4/30/20172017116,017677
7/31/20172017216,429671
10/31/20172017316,667478
1/31/20182017422,7661102
4/30/20182018116,781717
7/31/20182018217,776799
10/31/20182018317,821616
1/31/20192018422,977798













Step by Step Solution

3.49 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a The line chart of Target Corporations quarterly revenue shows a clear upward trend over time indic... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Financial Analysis Questions!