Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the following charts for Microsoft Corp analyze and answer the following. What was the EPS and DPS for each year for the last 5

Using the following charts for Microsoft Corp analyze and answer the following. What was the EPS and DPS for each year for the last 5 years? What can be a brief analysis of what these numbers mean for the company?

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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 As Reported Annual Cash Flow Report Date Currency Audit Status 06/30/2020 USD Not Available Yes Thousands 44281000 06/30/2019 USD Not Qualified Yes Thousands 39240000 06/30/2018 USD Not Qualified Yes Thousands 16571000 06/30/2017 USD Not Qualified Yes Thousands 21204000 0 06/30/2016 USD Not Qualified Yes Thousands 16798000 630000 12796000 5289000 -219000 11000 11682000 4652000 -792000 -6463000 0 10261000 3940000 -2212000 -5143000 8778000 3266000 -2073000 -3296000 67711000 -57735000 -925000 50000 1066000 -539000 81000 6622000 2668000 -223000 332000 57072000 -48498000 -530000 600000 -1167000 -41000 88000 -2577000 168000 -2330000 -1037000 3018000 2212000 -3631000 1346000 1348000 60675000 -2812000 597000 -1718000 -1834000 232000 4462000 2929000 1419000 591000 52185000 Consolidated Scale Net income (loss) Goodwill & asset impairments Asset impairments Depreciation, amortization & other adjustments Stock-based compensation expense Net recognized losses (gains) on investments & derivatives Deferred income taxes Deferral of unearned revenue Recognition of unearned revenue Accounts receivable Inventories Other current assets Other long-term assets Accounts payable Unearned revenue Income taxes Other current liabilities Other long-term liabilities Net cash flows from operating activities Proceeds from (repayment of) issuance of short-term debt, m Proceeds from issuance of debt Cash premium on debt exchange Repayments of debt Common stock issued Common stock repurchased Common stock cash dividends paid Other financing activities, net Net cash flows from financing activities Additions to property & equipment Acquisition of companies, net of cash acquired, & purchases Purchases of investments Other investing activities Maturities of investments Sales of investments Securities lending payable Net cash flows from investing activities Effect of exchange rates on cash & cash equivalents Net change in cash & cash equivalents Cash & cash equivalents, beginning of period Cash & cash equivalents, end of period Cash paid for interest Income taxes paid -3862000 -465000 -952000 -285000 1148000 5922000 18183000 798000 -20000 43884000 -7324000 7183000 386000 1533000 39507000 -4963000 44344000 -260000 -766000 33325000 7195000 13884000 -3417000 -5518000 1343000 -22968000 -15137000 -334000 -46031000 -15441000 -2521000 -77190000 -1241000 66449000 17721000 -4000000 1142000 -19543000 -13811000 -675000 -36887000 -13925000 -2388000 -57697000 -10060000 1002000 -10721000 -12699000 -971000 -33590000 -11632000 -888000 -137380000 -7922000 772000 -11788000 -11845000 - 190000 8408000 -8129000 -25944000 -176905000 -2796000 668000 -15969000 -11006000 -369000 -8393000 -8343000 -1393000 -129758000 20043000 38194000 -12223000 -201000 2220000 11356000 13576000 -15773000 -115000 -590000 11946000 11356000 2400000 8400000 26360000 117577000 -98000 -6061000 50000 4283000 7663000 11946000 2400000 5500000 28044000 136350000 -197000 -46781000 19000 1153000 6510000 7663000 1600000 2400000 22054000 93287000 203000 -23950000 -67000 915000 5595000 6510000 1100000 3900000 12500000 As Reported Annual Retained Earnings Report Date Currency Audit Status Consolidated Scale Previous retained earnings (accumulated deficit) Common stock cash dividends Common stock repurchased Cumulative effect of accounting changes Retained earnings (accumulated deficit) 06/30/2020 USD Not Available Yes Thousands 24150000 15483000 18382000 06/30/2019 USD Not Qualified Yes Thousands 13682000 14103000 15346000 677000 24150000 06/30/2018 USD Not Qualified Yes Thousands 17769000 12917000 7699000 -42000 13682000 06/30/2017 USD Not Qualified Yes Thousands 2282000 12040000 8798000 06/30/2016 USD Not Qualified Yes Thousands 9096000 11329000 12283000 34566000 2648000 2282000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Focus On Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert Hughes, Melissa Hart

6th Edition

125991965X, 978-1259919657

More Books

Students also viewed these Finance questions