Constructing and Analyzing a Dataset on Share-Based Compensation in Excel For this exercise, we create and analyze a dataset in Excel of the changes in the composition of share-based compensation plans (restricted stock unit, performance share, and stock option plans) for Target Corporation over a 10-year period.

Required 1. Create a dataset that will provide information on the composition of Target's share-based compensation plans over a 10-year period from fiscal year 2011 to fiscal year 2020.

a. In your dataset, for each of the share-based awards (restricted stock unit, performance share, and stock options) include the following: number of units granted during the year and the unrecognized compensation expense at year-end. b. Also include in your dataset the total share-based compensation expense included on the income statement for each year and the fair value per unit at grant date of the restricted stock units for each year. c. Hints: i. This information can be found in the note disclosures in the annual 10-K reports. ii. When collecting your data, note that some amounts are in thousands, and some in millions.Do not round numbers; use zeros to fill in placeholders; this means enter $5,200,000 for $5.2 million. iii. Fiscal years end in January or February of the following year; for example, Fiscal Year 2020 ends January 30, 2021.

2.. Prepare a line chart in Excel over the 10-year period showing the trends in units granted of the three different types of share-based awards. Hint: Highlight data, click Insert, Line. Chart should show the earliest year on the left and the latest year on the right. To change the order, right-click inside the horizontal axis. In the Format Axis sidebar, check Categories in reverse order.

Number of Units	FY 2011	FY 2012	FY 2013	FY 2014	FY 2015	FY 2016	FY 2017	FY 2018	FY 2019	FY 2020
Restricted stock units
Performance share units
Stock option units

3. Prepare a line chart in Excel showing the trend of share-based compensation expense over the 10-year period.

	FY 2011	FY 2012	FY 2013	FY 2014	FY 2015	FY 2016	FY 2017	FY 2018	FY 2019	FY 2020
Compensation expense

4. Indicate which year(s) in the data visualization prepared in part 5, showed a highly visible decline in share-based compensation expense. 5. Indicate which year seems to be the start of an increasing trend in the visualization created in part 5.

6. Prepare a line chart in Excel showing the trend of unrecognized share-based compensation expense over the 10-year period for all three share-based plan types.

Unrecognized compensation expense	FY 2011	FY 2012	FY 2013	FY 2014	FY 2015	FY 2016	FY 2017	FY 2018	FY 2019	FY 2020
Restricted stock units
Performance share units
Stock option units

7. Indicate which share-based plan type in the data visualization prepared in part 8 showed the highest value and lowest value in Fiscal Year 2011, 2015, and 2020.

	Highest	Lowest
FY2011
FY2015
FY2020

8. Prepare a schedule for the total fair value of the restricted stock share awards at the date of grant for each of the 10 years. Hint: Multiply the number of restricted stock units by the unit price at the date of grant.

Fair value of restricted stock units	FY 2011	FY 2012	FY 2013	FY 2014	FY 2015	FY 2016	FY 2017	FY 2018	FY 2019	FY 2020
Restricted stock units
Fair value at grant date
Total fair value of restricted stock units