Data Analytics - Pepsi Changed - Ticker - CUSIP Assignment Help

Internal Code : AA_AH_CIDB_FF

Data Analytics Assignment Help

TASK 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. 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

• Global Company Key which is an identifying code that the data source uses
• Ticker
• CUSIP is an acronym for Committee on Uniform Securities Information Procedures and is used when securities are traded in the US and Canada.
• Company name
• Fiscal Year-end Month
• 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

• Data date
• Data Year – fiscal
• Fiscal Year-end Month

Parameter Estimates

• Dividend rate
• Life of Options
• Risk Free Rate
• Volatility

Indicate: How many unique companies are included in the files for each year? Describe the process you used to determine that. 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 files provided. You can think about this from the perspective of management planning the changes or as the auditors evaluating the changes. Your analysis should include:

1. A table summarizing relevant information from the file. Summarize what the information in your table indicates.
2. At least one graph with information from the file. Summarize what the information in your chart indicates.
3. 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.Is there other data that would have been useful in your analysis?

The above question has been solved by our Data Analytics experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.