Go to the SEC website and download the FY18 10-k Excel files for Pfizer (PFE), Merck (MRK) and Johnson & Johnson (JNJ). In order to download the files you will need to search for each company and find the 10k filing for the year 2018. You can limit the file types you see by typing 10-k into filing type within the filter results option. Click on the interactive data option next to the 10-k filing information. Directly below the company name you will see an option to “View Excel Document” – click here and download the 10-k. Save each of the three files to the same folder. Name the files based on company name, file type and year (e.g. MRK_10K_FY18). In order to combine data, we will use an Excel function called VLOOKUP (Microsoft Excel VLOOKUP).

Steps:

1. Read through how the VLOOKUP function works (Microsoft Excel VLOOKUP).

2. Create a new Excel file

3. Make the following columns

1. Company Name

2. Year

3. Sales

4. Cost of Goods Sold

5. Gross Profit

6. Net Income

4. Use VLOOKUP to populate the Company Name from your files.

Answer rating: 100% (QA)

VLOOKUP stands for Vertical Lookup It is a function that makes Excel search for a certain value in a ... View the full answer