Each student should work independently. The entire assignment mus 1. Vertical Analysis of Income Statement - 2.5 points - Use a separate sheet of paper. Use the income statement provided for Intel. Required: (a) Preferably using a Microsoft Excel file, perform a vertical analysis for the 2021 income statement through Net Income. (b) Then, make one observation about the data based on your analysis. Note: Do not do anything with the data below "Net Income." Do not perform a vertical analysis for years prior to 2021. 2. Partial Horizontal Analysis of the Balance Sheet - 2.5 points - Use a separate sheet of paper. Use the balance sheet. Required: Preferably using a Microsoft Excel file, perform a horizontal analysis using 2020 as the base year through total assets only, then STOP. (Do not do a horizontal analysis on the entire balance sheet.) 3. Ratio Analysis - 2.5 points, half point each. Compute each on your own. Do not use published ratios. Required: On a separate sheet, compute the following ratios for the most current year. Show your work. a. 2021 Quick Ratio* b. 2021 Inventory Turnover c. 2021 Net Margin d. 2021 Asset Turnover e. 2021 Book Value per Share** follow the concept rather than a rigid formula for considering what is a quick asset. ** For purposes of this assignment, assume that 4,070 million shares of common stock are outstanding. 4. Understanding of Ratio Analysis - 2.5 points, half point each Required: Indicate which ratio would typically be indicative of a better company position and respond why this is true. a. A current ratio of 0.8 or 1.5 b. An inventory turnover ratio of 7 or 17 c. A return on investment (return on assets) of 8.2 percent or 9.9 percent d. A return on equity of 7 percent or 10 percent e. Average days to sell inventory of 15 days or 35 days