Company of choice: NIKE- Q4 of 2022 reports
Instructions:
research sources, such as Yahoo! Finance and MSN Money, for the financial highlights and trading information on your selected company. Using these sites, you will compute the ratios for the most recent year-end of your chosen company. You will also need to collect the quarterly data for the four quarters of your chosen company (with the last quarter being of the same ending date as your year-end). An Excel template is provided for you to compute these ratios. You will research various internet sources for the financial highlights and trading information on your selected company. At the same time, you should research the data for industry averages. It is highly likely all the important ratios for the industry will be unavailable except at a prohibitive cost. I highly suggest you supplement these ratios with those of the closest competitor. Therefore, a good practice is to research two companies in part 1, your competitor and a competitor. Therefore, when you are searching for data, you can do so for both companies at the same time.
Using these sites, you will compute the ratios for the four most recent quarters of your chosen company. Please make sure the data for the industry and the competitor aligns with the quarterly data you get for your chosen company, especially with regards to the dates. When accumulating the data, consider the Q4 and the end of year fully audited data as the same date. QI, 2, and 3 are the quarters immediately before Q4. This may mean that you may have to ignore recent quarterly data. An Excel template will be provided for you to compute these ratios.
Part Two A: Numerical Analysis Computations
In this second phase of the research project, you will provide the following information necessary to begin your research. Use the Excel spreadsheet posted in the Research Project content page to input quarterly financial data for your chosen company. Quarter 4 should correspond to the most recent year-end data for the company as is produced in the company’s IOK report. Using the Excel template, compute the ratios for the four most recent quarters of your chosen company. Sources of free data include Yahoo Finance and MSN Money. Research at least three Web sites to obtain the most accurate and reliable information. By using at least three sources, you will be able to select the financial information from two of the sources with the most closely corresponding information.