Using the Data below figure out the following for the past 5 years.
a) The compound annual growth rate for sales.
b) Average annual percentage change in sales.
c) Revenue Growth.
d) Revenue Growth by Segment (if applicable).
5 Microsoft Corporation (NMS: MSFT) 6 7 Exchange rate used is that of the Year End reported date 9 10 11 As Reported Annual Income Statement Report Date Currency Audit Status 12 1a 14 15 16 17 19 19 20 21 06/30/2018 USD Not Qualified Yes Thousands 64497000 45863000 110380000 15420000 22933000 38353000 72007000 14726000 17489000 4754000 06/30/2019 USD Not Qualified Yes Thousands 68069000 59774000 125843000 16273000 28637000 42910000 82933000 16876000 18213000 4885000 06/30/2020 USD Not Available Yes Thousands 88041000 74974000 143015000 16017000 30061000 48078000 98937000 19269000 19598000 5111000 22 24 25 26 27 29 06/30/2016 USD Not Qualified Yes Thousands 61502000 23818000 85320000 17880000 14900000 32780000 52540000 11988000 14697000 4583000 1110000 20182000 903000 1243000 688000 -443000 - 121000 -195000 -431000 -325000 20076000 19751000 545000 136000 1940000 2621000 Consolidated Scale Product revenue Service & other revenue Revenue Cost of revenue - product Cost of revenue - service & other revenue Cost of revenue Gross margin Research & development Sales & marketing General & administrative Impairment, integration. & restructuring Operating income (loss) Interest & dividends income Interest expense Net recognized gains on investments Net gains (losses) on derivatives Net gains (losses) on foreign currency remeasurements Other income (expense). net Other income, net Income (loss) before income taxes - United States Income (loss) before income taxes - foreign Income (loss) before income taxes Current taxes provision (benefit) - United States federal Current taxes provision (benefit) - United States state & loc Current taxes provision (benefit) - foreign Current taxes provision (benefit) Deferred taxes provision (benefit) - United States federal Deferred taxes provision (benefit) - United States state & lo Deferred taxes provision (benefit) - foreign Deferred taxes provision (benefit) Provision for income taxes Net income (loss) Weighted average shares outstanding - basic Weighted average shares outstanding - diluted Year end shares outstanding Net earnings (loss) per share - basic Net earnings (loss) per share - diluted Cash dividends declared per common share Number of full time employees Number of common stockholders Foreign currency translation adjustments 06/30/2017 USD Not Qualified Yes Thousands 57190000 32760000 89950000 15175000 19086000 34201000 55689000 13037000 15539000 4481000 306000 22326000 1387000 2222000 2583000 -510000 -164000 -251000 823000 453000 22696000 23 149000 2739000 30000 2472000 5241000 85 36 37 29 29 35058000 2214000 2733000 2399000 -187000 -218000 -59000 1416000 11527000 24947000 38474000 19784000 934000 4348000 25046000 -4292000 -458000 -393000 -5143000 19903000 16571000 7700000 7794000 7677000 2.15 2.13 1.68 97535 131000 42959000 2762000 2686000 648000 144000 -82000 -57000 729000 15799000 27889000 43688000 4718000 682000 553 1000 10911000 -5647000 -1010000 194000 -8463000 4448000 39240000 7673000 7753000 7643000 5.11 5.00 1.84 144000 94069 -318000 52959000 2680000 2591000 32000 187000 - 191000 -40000 77000 24116000 28920000 53038000 3537000 783000 4444000 8744000 58000 -6000 -41000 11000 8755000 4428 1000 7610000 7683000 7571000 5.82 5.76 2.04 163000 91674 -426000 46 47 49 50 51 52 52 332000 2953000 16798000 7925000 8013000 7808000 2.12 2.1 1.44 114000 106534 -519000 -3296000 1945000 21204000 7746000 7832000 7708000 2.74 2.71 1.56 124000 101825 228000 54 55 5 Microsoft Corporation (NMS: MSFT) 6 7 Exchange rate used is that of the Year End reported date 9 10 11 As Reported Annual Income Statement Report Date Currency Audit Status 12 1a 14 15 16 17 19 19 20 21 06/30/2018 USD Not Qualified Yes Thousands 64497000 45863000 110380000 15420000 22933000 38353000 72007000 14726000 17489000 4754000 06/30/2019 USD Not Qualified Yes Thousands 68069000 59774000 125843000 16273000 28637000 42910000 82933000 16876000 18213000 4885000 06/30/2020 USD Not Available Yes Thousands 88041000 74974000 143015000 16017000 30061000 48078000 98937000 19269000 19598000 5111000 22 24 25 26 27 29 06/30/2016 USD Not Qualified Yes Thousands 61502000 23818000 85320000 17880000 14900000 32780000 52540000 11988000 14697000 4583000 1110000 20182000 903000 1243000 688000 -443000 - 121000 -195000 -431000 -325000 20076000 19751000 545000 136000 1940000 2621000 Consolidated Scale Product revenue Service & other revenue Revenue Cost of revenue - product Cost of revenue - service & other revenue Cost of revenue Gross margin Research & development Sales & marketing General & administrative Impairment, integration. & restructuring Operating income (loss) Interest & dividends income Interest expense Net recognized gains on investments Net gains (losses) on derivatives Net gains (losses) on foreign currency remeasurements Other income (expense). net Other income, net Income (loss) before income taxes - United States Income (loss) before income taxes - foreign Income (loss) before income taxes Current taxes provision (benefit) - United States federal Current taxes provision (benefit) - United States state & loc Current taxes provision (benefit) - foreign Current taxes provision (benefit) Deferred taxes provision (benefit) - United States federal Deferred taxes provision (benefit) - United States state & lo Deferred taxes provision (benefit) - foreign Deferred taxes provision (benefit) Provision for income taxes Net income (loss) Weighted average shares outstanding - basic Weighted average shares outstanding - diluted Year end shares outstanding Net earnings (loss) per share - basic Net earnings (loss) per share - diluted Cash dividends declared per common share Number of full time employees Number of common stockholders Foreign currency translation adjustments 06/30/2017 USD Not Qualified Yes Thousands 57190000 32760000 89950000 15175000 19086000 34201000 55689000 13037000 15539000 4481000 306000 22326000 1387000 2222000 2583000 -510000 -164000 -251000 823000 453000 22696000 23 149000 2739000 30000 2472000 5241000 85 36 37 29 29 35058000 2214000 2733000 2399000 -187000 -218000 -59000 1416000 11527000 24947000 38474000 19784000 934000 4348000 25046000 -4292000 -458000 -393000 -5143000 19903000 16571000 7700000 7794000 7677000 2.15 2.13 1.68 97535 131000 42959000 2762000 2686000 648000 144000 -82000 -57000 729000 15799000 27889000 43688000 4718000 682000 553 1000 10911000 -5647000 -1010000 194000 -8463000 4448000 39240000 7673000 7753000 7643000 5.11 5.00 1.84 144000 94069 -318000 52959000 2680000 2591000 32000 187000 - 191000 -40000 77000 24116000 28920000 53038000 3537000 783000 4444000 8744000 58000 -6000 -41000 11000 8755000 4428 1000 7610000 7683000 7571000 5.82 5.76 2.04 163000 91674 -426000 46 47 49 50 51 52 52 332000 2953000 16798000 7925000 8013000 7808000 2.12 2.1 1.44 114000 106534 -519000 -3296000 1945000 21204000 7746000 7832000 7708000 2.74 2.71 1.56 124000 101825 228000 54 55
