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 year 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).
3.  

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