Using the Data below figure out the following for the past 5 years.Focus on CAGR (Compound annual growth rate) of Key Income Statement Components.
a) Total Revenue Growth.
b) Revenue Growth by Segment (if applicable).
c) Cost of goods sold, SG&A, Total Operating Expenses.
?
Microsoft Corporation (NMS: MSFT) Exchange rate used is that of the Year End reported date 10 As Reported Annual Income Statement 11 Report Date 06/30/2016 06/30/2017 06/30/2018 06/30/2019 06/30/2020 USD USD USD USD USD 12 Audit Status No Not Not Not Not Qualified Qualified Qualified Qualified Available Consolidated Yes Yes Yes Yes Yes Scale Thousand Thousands Thousands Thousands Thousands Product revenue 57 190000 64497000 68089000 68041000 Service & other revenue 23818000 82760000 45863000 69774000 74974000 Revenue 25320000 80950000 110360000 125843000 143015000 19 Cost of revenue - product 17880000 15175000 15420000 16273000 16017000 20 Cost of revenue - service & other revenue 14900000 19086000 22933000 26637000 30061000 21 Cost of revenue 32780000 34261000 38353000 42910000 46078000 22 Gross margin 52540000 55689000 72007000 82933000 95937000 23 Research & development 11988000 13037000 14726000 16876000 19289000 24 Sales & marketing 14697000 15539000 7469000 8213000 19598000 25 General & administrative 4563000 4481000 4754000 4885000 5111000 26 Impairment, integration, & restructuring 1110000 306000 27 Operating income (loss 20182000 22326000 35058000 42959000 52959000 29 Interest & dividends income 903000 1387000 2214000 2762000 2680000 29 Interest expense 1243000 2222000 2733000 2686000 2581000 20 Net recognized gains on investments 368000 2583000 2399000 648000 Net gains (losses) on derivatives 443000 510000 -187000 144000 187000 32 Net gains (losses) on foreign currency remeasurements 121000 164000 218000 -82000 -191000 Other income (expense). net -195000 -251000 -59000 -40000 24 Other income, net -431000 1416000 729000 25 Income (loss) before income taxes - United States 325000 453000 11527000 15799000 24116000 26 Income (loss) before income taxes - foreign 20076000 22696000 24947000 27889000 28920000 Income (loss) before income taxes 19751000 23149000 26474000 43688000 Current taxes provision (benefit) - United States federal 545000 2739000 9764000 4718000 8537000 Current taxes provision (benefit) - United States state & loc 136000 30000 934000 682000 763000 40 Current taxes provision (benefit) - foreign 1940000 2472000 4348000 5531000 4444000 Current taxes provision (benefit) 2621000 25046000 8744000 Deferred taxes provision (benefit) - United States federal 4292000 5647000 43 Deferred taxes provision (benefit) - United States state & lo 458000 1010000 -6000 44 Deferred taxes provision (benefit) - foreign -393000 194000 -41000 45 Deferred taxes provision (benefit) 332000 -3286000 -5143000 -6483000 11000 Provision for income taxes 2953000 1945000 18903000 4448000 8755000 47 Net income (loss) 16798000 21204000 16571000 30240000 44281000 49 Weighted average shares outstanding - basic 7925000 7746000 7700000 7673000 7610000 49 Weighted average shares outstanding - diluted 8013000 7832000 7753000 7683000 50 Year end shares outstanding 7808000 7708000 7677000 7643000 7571000 51 Net earnings (loss) per share - basic 2. 12 2.74 2.15 5.11 5.82 52 Net earnings (loss) per share - diluted 2.1 2.71 2.13 5.06 5.76 53 Cash dividends declared per common share 1.44 1.56 1.68 1.84 2.04 54 Number of full time employees 114000 124000 97535 144000 163000 55 Number of common stockholders 106534 101825 131000 94069 91674 56 Foreign currency translation adjustments -519000 228000 318000
