Fluent Essays

Read attachmentsInstruction: Submit an Excel file for grading. A file with tabs for reference to assist you in completeness is attached.  1. (a) For Netflix, compare the companys 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? 2. (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? 3. 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.Tab 1 Netflix Issued Guidance: Microsoft Office User: Instructor: Create a space to insert the pdfs used (you may also include a link to be certain if the embedded pdf fails instructor can access it) and/or include in Excel the specifics (you may want to include in Excel so you can link raw data to your analysis since that isnt possible from the pdfs/links) Analyst Report(s): Microsoft Office User: Instructor: Embedd with pdf. You may also add the hyperlink as additional resource to your source, however the pdf must be included. You can also add key details or metrics extracted from the report for ease of use in the analysis so the pdf does not need opened every time Key points of analyst on forecast and performance: Microsoft Office User: Instructor: Ensure you have a space to include your commentary on the key points of analyst. Tab 2 Microsoft Office User: Instructor: Include the downloaded three years of data for I/S, B/S, SOCF. It is not necessary to include S/SE unless you would like it for balancing the financials. All items forecast are addressed in the other three financials as such the equity statement is not needed. 3 Years Financial Statements Forecast Microsoft Office User: Instructor: Your forecast. If using formulas to build out growth, you can add columns, include and hide columns, or use other tabs to develop your forecast and then paste/link from your anlaysis at other tabs to here. The forecast should have a basis that reconciles with your commentary. (Commentary in column F placeholder is merely a placeholder so you dont forget to add, this is not suggesting a format or dictating space for such comments). The explanation and growth or decline should make sense together and when considering the research. Microsoft Office User: Instructor: As included in the exam instructions, show an industry compare. Select either key metrics/KPIs,or FS line items, or key financial info stats from IBIS. Dont forget to add comments as per (c) in the exam instructions. To repeat these are placeholders merely to provide a visual supporting the instructions in the e-learning exam. The exam project is graded on 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.  Commentary on why this is your forecast Industry comparison Comments on industry compare Tab 3 Microsoft Office User: Instructor: Include your graph through Q3 22. Dont forget to highlight what happened to the daily stock price after release (use tools of your choice such as circles, arrows, colors, etc that works with your visual). Prices can do three things - go down, go up, or stay about the same depending on the market reaction Optional commentary permitted under the graphNotes Notes Tab for Final Exam Question # Validation Validation Check Figures Question # 2015 data Type TransactionNumber AppliedToTransactionNumber CustNum CustName TransactionDate Amount Sales 1001 1836 Runners Market 5-Mar-15 $ 16,157.44 Sales 1002 1168 Bigmart 5-Mar-15 $ 9,144.00 Sales 1003 1167 Goodway 5-Mar-15 $ 15,737.60 Sales 1004 1841 Neighborhood Athletic Supply 8-Mar-15 $ 6,008.00 Sales 1005 1842 Northern Lites 8-Mar-15 $ 7,241.60 Sales 1006 1168 Bigmart 13-Mar-15 $ 8,476.00 Sales 1007 1167 Goodway 13-Mar-15 $ 15,737.60 Sales 1008 1814 ValueChoice 13-Mar-15 $ 9,084.40 Sales 1009 1841 Neighborhood Athletic Supply 16-Mar-15 $ 4,240.00 Sales 1010 1842 Northern Lites 16-Mar-15 $ 5,993.60 Sales 1011 1843 Southeast Regional 16-Mar-15 $ 9,019.12 Sales 1012 1861 Family Fit 23-Mar-15 $ 6,552.40 Sales 1013 1863 Fit N Fun 23-Mar-15 $ 5,008.64 Sales 1014 1864 Cross Country Mart 23-Mar-15 $ 11,113.60 Sales 1015 1840 Super Runners Mark 27-Mar-15 $ 17,677.04 Sales 1016 1841 Neighborhood Athletic Supply 27-Mar-15 $ 4,240.00 Sales 1017 1842 Northern Lites 30-Mar-15 $ 7,241.60 Sales 1018 1167 Goodway 2-Apr-15 $ 19,672.00 Sales 1019 1814 ValueChoice 3-Apr-15 $ 6,975.00 Sales 1020 1838 Urban Runner 3-Apr-15 $ 16,230.00 Sales 1021 1863 Fit N Fun 6-Apr-15 $ 7,330.80 Sales 1022 1864 Cross Country Mart 6-Apr-15 $ 13,892.00 Sales 1023 1861 Family Fit 6-Apr-15 $ 8,074.40 Sales 1024 1862 Corner Runner 6-Apr-15 $ 9,642.00 Sales 1025 1840 Super Runners Mark 10-Apr-15 $ 22,096.30 Sales 1026 1841 Neighborhood Athletic Supply 10-Apr-15 $ 7,510.00 Sales 1027 1842 Northern Lites 12-Apr-15 $ 9,052.00 Sales 1028 1861 Family Fit 17-Apr-15 $ 8,190.50 Sales 1029 1842 Northern Lites 17-Apr-15 $ 9,052.00 Sales 1030 1843 Southeast Regional 17-Apr-15 $ 11,273.90 Sales 1031 1836 Runners Market 23-Apr-15 $ 19,571.80 Sales 1032 1841 Neighborhood Athletic Supply 23-Apr-15 $ 1,300.00 Sales 1033 1168 Bigmart 23-Apr-15 $ 835.00 Sales 1034 1837 Cool Threads 23-Apr-15 $ 7,600.00 Sales 1035 1841 Neighborhood Athletic Supply 23-Apr-15 $ 702.00 Sales 1036 1814 ValueChoice 23-Apr-15 $ 4,380.50 Sales 1037 1167 Goodway 23-Apr-15 $ 19,312.00 Sales 1038 1861 Family Fit 24-Apr-15 $ 8,074.40 Sales 1039 1837 Cool Threads 24-Apr-15 $ 14,092.60 Sales 1040 1842 Northern Lites 27-Apr-15 $ 9,052.00 Sales 1041 1843 Southeast Regional 27-Apr-15 $ 11,119.10 Sales 1042 1168 Bigmart 1-May-15 $ 663.60 Sales 1043 1814 ValueChoice 1-May-15 $ 8,641.08 Sales 1044 1837 Cool Threads 1-May-15 $ 11,424.67 Sales 1045 1168 Bigmart 4-May-15 $ 520.80 Sales 1046 1862 Corner Runner 4-May-15 $ 7,851.48 Sales 1047 1863 Fit N Fun 4-May-15 $ 6,159.72 Sales 1048 1842 Northern Lites 11-May-15 $ 7,603.68 Sales 1049 1843 Southeast Regional 11-May-15 $ 9,340.YogaCo –original by EY Foundation Edited at GGU Background: Final Exam Instructions YogaCo is a privately owned business that began operations in March 2015. Its sole business is the manufacture and sale of upper-end, high-quality yoga gear. It only sells to large distribution outlets. Its primary product is a line of lightweight exercise clothes that contain a new, long-range RFID chip that captures the following information about the user based on personal data (age, weight, etc.) entered by the user: ► Heart rate ► Perspiration rate ► Calories burned ► Exercise efficiency (percent of capacity) The chip is able to continuously send this information to a host device as far away as 15 miles. The clothes are also GPS enabled and able to track routes, distances, and elevations. Management prides itself on being on the cutting edge. The company expects to conduct an IPO within a year or two. YogaCo recently retained your firm as its consultant, largely because of your commitment to highly efficient and technology-enabled analysis. Data You have been hired by YogaCo to help analyze their cash receipts to be able to complete a Cash Flow analysis later. You are first responsible for performing an assessment of YogaCo related to its order-to- cash function as it is a key piece in their Cash Flow model. Your first task is to acquire the data for these transactions. You work with YogaCo’s IT group to gain access to its sales and cash receipts data for its start-up period of operations, March through December 2015. You have been provided with an Excel file with this data (2015 Data Tab) so you can begin your analysis. The data file includes the following fields: ► Type: this is the type of transaction, which is either a sale (Sales) or a cash receipt (CashReceipt). ► TransactionNumber: this is the transaction number (beginning with 1001 and will not exceed 9999) automatic invoices are sent on this day to customers. ► AppliedToTransaction Number: this is the sales transaction number to which a cash receipt is applied. ► CustNum: this is a unique customer number used to identify each customer. ► CustName: this is the customer’s name. ► TransactionDate: this is the date of the sale or cash receipt. ► Amount: this is the amount of the sale or cash receipt. Cash receipts will show a negative amount. Part I: Become familiar with your data file. Make certain that your data is complete and accurate before performing any analysis. Complete the following in the Final Exam – Data spreadsheet: YogaCo –original by EY Foundation Edited at GGU 1. You’ve been told that the accounts receivable balance on the general ledger on December 31, 2015, is $684,491.19. They can always get this number from accounting to act as check figure. You also know that as a start-up company, the beginning accounts receivable balance is zero. You are also told that there are no returns or w