Instruction:
Submit an Excel file for grading. A file with tabs for reference to assist you in completeness is attached.
- (a) For Netflix, compare the company’s Q322 issued guidance (forecast) to an analyst report and include in the file. HINTS: Q3 guidance is found in the Q2 releases. A number of analyst reports are available surrounding the week of 7/19/22, for example Deutshe Bank in which you can find “Outlook” and “Opinions.” (b) What are the analysts key points as to the forecast?
- (a) Aggregate 3 most recent years of financial statement data. Create a 4th column using the forecast and research data to develop what you think the next year will be (forecast year 4!). Include comments as to why this is your estimate. (b) Compare this to IBIS world industry/sector data and show your comparison. (Some analyst reports such as DB also include industry data). (c) Is the Company better or worse than the industry? Why?
- Create a 2-3 year visual graph of the company stock price that ends in most recent period (Q3 22 to date should be included and the 2-3 years should calculate back from there). Highlight within your visual the date points at which the company issued (a) earnings and (b) guidance to show what happened to the stock price when released (select immediate days only, not lengthy time periods). Additional commentary permitted below the visual if necessary.
Points are allocated for accuracy, completeness, application of executive/business communication, creativity/ visual appeal in line with the guidance of the Storytelling textbook and communication of data covered in the course.
