General formatting requirements: Please construct visually attractive and easily readable worksheets. Round your calculated percentages to the nearest one tenth of one percent (e.g., 100.0%; 65.2%; 4.3%, etc). 1. Use Excel to prepare a horizontal and a vertical analysis of the following selected income statement components: Net revenues, gross profit, SG&A expenses, and Net Income. The specific terminology and classifications will vary somewhat across companies. Use the three most recent years income statement data to construct two horizontal income statement analyses and three vertical analyses. 2. From your company's 10-K, locate management's discussion and analysis of year-to-year financial and operating results to identify the main reasons for the changes, trends, and relationships in your horizontal and vertical spreadsheets. Organize your analysis under four headings: Net revenues; inventory and cost of sales; SG&A expenses;, and Net Income. Your