1. Prepare common size financial statements analysis (horizontal and vertical analysis) for the Company as we demonstrated in class using excel. (Ie You can download the comparative income statements to excel from the company website and compare the income statement items as a percentage of net sales for each year and the change in the items year over yearas a $ amount and a percentage as we demonstrated in class).

2. What is the percentage change in net sales for each year? Describe any trends that you believe to be developing. (Please include account descriptions and amounts in a table presentation).

PART II Item 8 ITEM 8. FINANCIAL STATEMENTS AND SUPPLEMENTARY DATA INCOME STATEMENTS (In millions, except per share amounts) Year Ended June 30, 2020 2019 2018 Revenue: Product Service and other $ 68,041 $ 66,069 $ 64,497 74,974 59,774 45,863 Total revenue 143,015 125,843 110,360 Cost of revenue: Product Service and other 16,017 30,061 16,273 26,637 15,420 22,933 Total cost of revenue 46,078 42,910 38,353 Gross margin Research and development Sales and marketing General and administrative 96,937 19,269 19,598 5,111 82,933 16,876 18,213 4,885 72,007 14,726 17,469 4,754 Operating income Other income, net 52,959 77 42,959 729 35,058 1,416 Income before income taxes Provision for income taxes 53,036 8,755 43,688 4,448 36,474 19,903 Net income $ 44,281 $ 39,240 $ 16,571 Earnings per share: Basic Diluted $ $ 5.82 $ 5.76 $ 5.11 $ 5.06 $ 2.15 2.13 Weighted average shares outstanding: Basic Diluted 7,610 7,683 7,673 7,753 7,700 7,794 Refer to accompanying notes