Data Analytics Assignment
Accounting for stock options requires that employee stock options be valued with a model that includes six parameters. The company used in chapter 19 to illustrate options was Pepsi. From chapter 19, here is the relevant information that Pepsi disclosed:
Required:
1. In 2016, Pepsi changed three of the parameters used to estimate the option values. Evaluating each of these changes independently, indicate the effect of Pepsi's change in 2016 on the estimated value of the option.
|
Parameter
|
Effect of change on estimated option value
|
|
Expected Life
|
|
|
Risk-free interest rate
|
|
|
Expected volatility
|
|
2. There are two files available for this assignment. Each file is set up similarly. The two files have information for the years 2015 and 2016. Each file contains the following information:
• Identifying company information
o Global Company Key which is an identifying code that the data source uses
o Ticker
o CUSIP is an acronym for Committee on Uniform Securities Information Procedures and is used when securities are traded in the US and Canada.
o Company name
o Fiscal Year-end Month
o SIC code is the Standard Industrial Classification code and indicates the firm's primary line of business.
• Date of fiscal year end that parameter estimates were reported
o Data date
o Data Year - fiscal
o Fiscal Year-end Month
• Parameter Estimates
o Dividend rate
o Life of Options
o Risk Free Rate
o Volatility
Indicate:
a. How many unique companies are included in the files for each year? Describe the process you used to determine that.
b. How many estimates are there for each of the parameters? Again, describe the process you used to determine that.
3. Now analyze whether the parameter changes were justified using the data provided in the data filesprovided. You can think about this from the perspective of management planning the changes or as the auditors evaluating the changes.
Your analysis should include:
a. A table summarizing relevant information from the file. Summarize what the information in your table indicates.
b. At least one graph with information from the file. Summarize what the information in your chart indicates.
c. For each of the three parameters that changed, indicate whether or not your analysis supports the change and how your analysis led to that conclusion.
d. Is there other data that would have been useful in your analysis?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Data-Analytics-Assignment.rar