Using the following Income Statment and Balance Sheet for Microsoft Corp analyze the following points for the past 5 years. Point out the different variables for different years as well.
Ex) EPS for 2016 was..., EPS for 2017 was..., EPS 2018 was... etc.)
1. EPS Analysis
2. DPS Analysis
3. Retained Earnings per share analysis.
4. Can you get the Dividend yield for this company using the following charts? If yes, what is it?
Microsoft Corporation (NMS: MSFT) Exchange rate used is that of the Year End reported date As Reported Annual Income Statement Report Date Currency Audit Status 06/30/2020 USD Not Available Yes Thousands 68041000 74974000 143015000 16017000 30061000 46078000 96937000 19269000 19598000 5111000 06/30/2019 USD Not Qualified Yes Thousands 66069000 59774000 125843000 16273000 26637000 42910000 82933000 16876000 18213000 4885000 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 & local Current taxes provision (benefit) - foreign Current taxes provision (benefit) Deferred taxes provision (benefit) - United States federal Deferred taxes provision (benefit) - United States state & loce 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 34261000 55689000 13037000 15539000 4481000 306000 22326000 1387000 2222000 2583000 -510000 -164000 -251000 823000 453000 22696000 23149000 2739000 30000 2472000 5241000 06/30/2018 USD Not Qualified Yes Thousands 64497000 45863000 110360000 15420000 22933000 38353000 72007000 14726000 17469000 4754000 0 35058000 2214000 2733000 2399000 -187000 -218000 -59000 1416000 11527000 24947000 36474000 19764000 934000 4348000 25046000 -4292000 -458000 -393000 -5143000 19903000 16571000 7700000 7794000 7677000 2.15 2.13 1.68 97535 131000 06/30/2016 USD Not Qualified Yes Thousands 61502000 23818000 85320000 17880000 14900000 32780000 52540000 11988000 14697000 4563000 1110000 20182000 903000 1243000 668000 -443000 -121000 -195000 -431000 -325000 20076000 19751000 545000 136000 1940000 2621000 52959000 2680000 2591000 32000 187000 -191000 -40000 77000 24116000 28920000 53036000 3537000 763000 4444000 8744000 58000 -6000 -41000 11000 8755000 44281000 7610000 7683000 7571000 5.82 5.76 2.04 163000 91674 -426000 42959000 2762000 2686000 648000 144000 -82000 -57000 729000 15799000 27889000 43688000 4718000 662000 5531000 10911000 -5647000 -1010000 194000 -6463000 4448000 39240000 7673000 7753000 7643000 5.11 5.06 1.84 144000 94069 -318000 -3296000 1945000 21204000 7746000 7832000 7708000 2.74 2.71 1.56 124000 101825 228000 332000 2953000 16798000 7925000 8013000 7808000 2.12 2.1 1.44 114000 106534 -519000 As Reported Annual Balance Sheet Report Date 06/30/2020 06/30/2019 06/30/2018 06/30/2017 06/30/2016 Currency Audit Status USD Not Available USD Not Qualified USD Not Qualified USD Not Qualified USD Not Qualified Consolidated Scale Yes Thousands Yes Thousands Yes Thousands Yes Thousands Yes Thousands 13576000 122951000 136527000 32799000 788000 32011000 700000 83000 1112000 1895000 11482000 181915000 1823000 33995000 5487000 41261000 4782000 87348000 43197000 44151000 8753000 2965000 11356000 122463000 133819000 29935000 411000 29524000 399000 53000 1611000 2063000 10146000 175552000 1540000 26288000 5316000 33823000 4840000 71807000 35330000 36477000 7379000 2649000 11946000 121822000 133768000 26858000 377000 26481000 655000 54000 1953000 2662000 6751000 169662000 1254000 20604000 4735000 27633000 4457000 58683000 29223000 29460000 6686000 7663000 125318000 132981000 20197000 405000 19792000 797000 145000 1239000 2181000 4897000 159851000 1107000 16284000 5064000 21414000 4044000 47913000 24179000 23734000 6510000 106730000 113240000 18703000 426000 18277000 612000 158000 1481000 2251000 5892000 139660000 824000 12393000 3659000 17391000 3889000 38156000 19800000 18356000 Cash & oash equivalents Short-term investments Total cash, cash equivalents, & short-term investments Accounts receivable, gross Allowance for doubtful accounts Accounts receivable, net Raw materials Work in process Finished goods Inventories Other Ourrent assets Total current assets Land Buildings & improvements Leasehold improvments Computer equipment & software Furniture & equipment Total property & equipment, at cost Accumulated depreciation property & equipment Property & equipment, net Operating lease right-of-use assets Equity investments Equity & other investments Goodwill Intangible assets, net Other long-term assets Total assets Accounts payable Short-term debt Current portion of long-term debt Accrued compensation Short term income taxes Securities lending payable Short-term unearned revenue Other current liabilities Total current liabilities Long-term debt Long-term debt Long-term income taxes Long-term unearned revenue Deferred income taxes Operating lease liabilities Other long-term liabilities Total liabilities Common stock & paid-in capital Retained earnings (accumulated deficit) Derivatives Investments Translation adjustments & other accumulated other comprehensive income Cumulative effect of accounting change Accumulated other comprehensive income Total stockholders' equity 43351000 7038000 13138000 301311000 12530000 42026000 7750000 14723000 286556000 9382000 1862000 35683000 8053000 7442000 258848000 8617000 0 3998000 6103000 2121000 6023000 35122000 10106000 6250000 241086000 7390000 9072000 1049000 5819000 718000 97000 34102000 6280000 64527000 10431000 17872000 3733000 3642000 193694000 6898000 12904000 0 5264000 580000 294000 27468000 5949000 59357000 3749000 7874000 2130000 5516000 6830000 5665000 36000000 10027000 72310000 59578000 32676000 9351000 69420000 66662000 28905000 8744000 58488000 72242000 76073000 40783000 10377000 531000 6441000 1476000 29432000 3180000 204000 7671000 10632000 183007000 80552000 34566000 -38000 5478000 -2254000 29612000 4530000 233000 6188000 7581000 184226000 78520000 24150000 30265000 3815000 541000 5568000 5211000 176130000 71223000 13682000 173000 -892000 -1510000 42000 -2187000 82718000 17184000 168692000 69315000 2648000 134000 1825000 -1528000 13640000 121697000 68178000 2282000 352000 2941000 -1756000 1555000 -1828000 -67000 -340000 102330000 3186000 118304000 431000 72394000 1537000 71997000 Microsoft Corporation (NMS: MSFT) Exchange rate used is that of the Year End reported date As Reported Annual Income Statement Report Date Currency Audit Status 06/30/2020 USD Not Available Yes Thousands 68041000 74974000 143015000 16017000 30061000 46078000 96937000 19269000 19598000 5111000 06/30/2019 USD Not Qualified Yes Thousands 66069000 59774000 125843000 16273000 26637000 42910000 82933000 16876000 18213000 4885000 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 & local Current taxes provision (benefit) - foreign Current taxes provision (benefit) Deferred taxes provision (benefit) - United States federal Deferred taxes provision (benefit) - United States state & loce 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 34261000 55689000 13037000 15539000 4481000 306000 22326000 1387000 2222000 2583000 -510000 -164000 -251000 823000 453000 22696000 23149000 2739000 30000 2472000 5241000 06/30/2018 USD Not Qualified Yes Thousands 64497000 45863000 110360000 15420000 22933000 38353000 72007000 14726000 17469000 4754000 0 35058000 2214000 2733000 2399000 -187000 -218000 -59000 1416000 11527000 24947000 36474000 19764000 934000 4348000 25046000 -4292000 -458000 -393000 -5143000 19903000 16571000 7700000 7794000 7677000 2.15 2.13 1.68 97535 131000 06/30/2016 USD Not Qualified Yes Thousands 61502000 23818000 85320000 17880000 14900000 32780000 52540000 11988000 14697000 4563000 1110000 20182000 903000 1243000 668000 -443000 -121000 -195000 -431000 -325000 20076000 19751000 545000 136000 1940000 2621000 52959000 2680000 2591000 32000 187000 -191000 -40000 77000 24116000 28920000 53036000 3537000 763000 4444000 8744000 58000 -6000 -41000 11000 8755000 44281000 7610000 7683000 7571000 5.82 5.76 2.04 163000 91674 -426000 42959000 2762000 2686000 648000 144000 -82000 -57000 729000 15799000 27889000 43688000 4718000 662000 5531000 10911000 -5647000 -1010000 194000 -6463000 4448000 39240000 7673000 7753000 7643000 5.11 5.06 1.84 144000 94069 -318000 -3296000 1945000 21204000 7746000 7832000 7708000 2.74 2.71 1.56 124000 101825 228000 332000 2953000 16798000 7925000 8013000 7808000 2.12 2.1 1.44 114000 106534 -519000 As Reported Annual Balance Sheet Report Date 06/30/2020 06/30/2019 06/30/2018 06/30/2017 06/30/2016 Currency Audit Status USD Not Available USD Not Qualified USD Not Qualified USD Not Qualified USD Not Qualified Consolidated Scale Yes Thousands Yes Thousands Yes Thousands Yes Thousands Yes Thousands 13576000 122951000 136527000 32799000 788000 32011000 700000 83000 1112000 1895000 11482000 181915000 1823000 33995000 5487000 41261000 4782000 87348000 43197000 44151000 8753000 2965000 11356000 122463000 133819000 29935000 411000 29524000 399000 53000 1611000 2063000 10146000 175552000 1540000 26288000 5316000 33823000 4840000 71807000 35330000 36477000 7379000 2649000 11946000 121822000 133768000 26858000 377000 26481000 655000 54000 1953000 2662000 6751000 169662000 1254000 20604000 4735000 27633000 4457000 58683000 29223000 29460000 6686000 7663000 125318000 132981000 20197000 405000 19792000 797000 145000 1239000 2181000 4897000 159851000 1107000 16284000 5064000 21414000 4044000 47913000 24179000 23734000 6510000 106730000 113240000 18703000 426000 18277000 612000 158000 1481000 2251000 5892000 139660000 824000 12393000 3659000 17391000 3889000 38156000 19800000 18356000 Cash & oash equivalents Short-term investments Total cash, cash equivalents, & short-term investments Accounts receivable, gross Allowance for doubtful accounts Accounts receivable, net Raw materials Work in process Finished goods Inventories Other Ourrent assets Total current assets Land Buildings & improvements Leasehold improvments Computer equipment & software Furniture & equipment Total property & equipment, at cost Accumulated depreciation property & equipment Property & equipment, net Operating lease right-of-use assets Equity investments Equity & other investments Goodwill Intangible assets, net Other long-term assets Total assets Accounts payable Short-term debt Current portion of long-term debt Accrued compensation Short term income taxes Securities lending payable Short-term unearned revenue Other current liabilities Total current liabilities Long-term debt Long-term debt Long-term income taxes Long-term unearned revenue Deferred income taxes Operating lease liabilities Other long-term liabilities Total liabilities Common stock & paid-in capital Retained earnings (accumulated deficit) Derivatives Investments Translation adjustments & other accumulated other comprehensive income Cumulative effect of accounting change Accumulated other comprehensive income Total stockholders' equity 43351000 7038000 13138000 301311000 12530000 42026000 7750000 14723000 286556000 9382000 1862000 35683000 8053000 7442000 258848000 8617000 0 3998000 6103000 2121000 6023000 35122000 10106000 6250000 241086000 7390000 9072000 1049000 5819000 718000 97000 34102000 6280000 64527000 10431000 17872000 3733000 3642000 193694000 6898000 12904000 0 5264000 580000 294000 27468000 5949000 59357000 3749000 7874000 2130000 5516000 6830000 5665000 36000000 10027000 72310000 59578000 32676000 9351000 69420000 66662000 28905000 8744000 58488000 72242000 76073000 40783000 10377000 531000 6441000 1476000 29432000 3180000 204000 7671000 10632000 183007000 80552000 34566000 -38000 5478000 -2254000 29612000 4530000 233000 6188000 7581000 184226000 78520000 24150000 30265000 3815000 541000 5568000 5211000 176130000 71223000 13682000 173000 -892000 -1510000 42000 -2187000 82718000 17184000 168692000 69315000 2648000 134000 1825000 -1528000 13640000 121697000 68178000 2282000 352000 2941000 -1756000 1555000 -1828000 -67000 -340000 102330000 3186000 118304000 431000 72394000 1537000 71997000
