In footnote 2 some claims were made about the average level of fourth quarter sales for Target

Question:

In footnote 2 some claims were made about the average level of fourth quarter sales for Target Corp. Using the Target Quarterly Sales.xlsx workbook from the official Web site (www.cengage.com/finance/mayes/analysis/9e) verify those claims.

a. Create a line chart of Target’s quarterly revenue and net income, with net income on a secondary y-axis. Does there appear to be any seasonality in its revenue? Net income?

b. Create a pivot table that has Fiscal Year and Fiscal Quarter in the Rows field, and Revenue in the Values field. Be sure to show subtotals for each year at the bottom of each group.

c. Add Revenue to the Values field a second time. Use Show Values As % of Parent Total to show quarterly sales as a percentage of full year sales. What is the average for the fourth quarter? First quarter?

d. Add Revenue to the Values field a third time. Use Show Values As % Difference From to show the year-over-year percentage change in quarterly sales.

e. Repeat parts b and c, but this time using Net Income.


Target Quarterly Sales.xlsx workbook. 

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













Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: