NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to the step in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: 1. Identify questions related to the income statement. 2. Analyze a list of calculated financial ratios for a selection of companies. 3. Create a dynamic spreadsheet that pulls in XBRL data. 4. Create formulas to identify the companies based on the ratios. Refer to Chapter 8 pages 314 through 317 for instructions and steps for each of the lab parts. After completing Lab parts 1 through 4, complete the following requirements. Software needed Google Sheets (sheets.) iXBRLAnalyst script (https://findynamics/gsheets/ixbrla nalyst. gs) Data The data used in this analysis are XBRL-tagged data from Fortune 100 companies. The data are pulled from FinDynamics, which in turn pulls the data from the SEC.