Loading...

Financial Summary


Microsoft Corporation

Microsoft Corporation (MSFT)

$216.54
11.53 (+5.62%)
Strong Buy
S
Market Info
Financial Info
Financial Modelling
Symbol MSFT
Price 216.54$
Beta 1.23
Volume Avrg. 35.37M
Market Cap 1,638.70B
Shares (2020) 7,683,000.00K
Last Div 1.99
Dividend Yield 0.91%
DCF Unlevered 108.88 Strong Sell
DCF Levered 135.98 Strong Sell
ROE 37.43% Strong Buy
ROA 14.70% Buy
Operating Margin 37.03% Strong Buy
Debt / Equity 154.69% Buy
P/E 35.04 Strong Buy
P/B 13.12 Strong Buy

Income Statement

Quarter data
Year 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010
Earnings Per Share Diluted 2.102.692.002.582.631.482.102.712.135.065.76
Net Profit Margin 0.300.330.230.280.250.130.200.240.150.310.31
Weighted Average Shares Outstanding 8,813.008,490.008,396.008,375.008,299.008,177.007,925.007,746.007,700.007,673.007,610.00
Revenue 62,484.0069,943.0073,723.0077,849.0086,833.0093,580.0085,320.0089,950.00110,360.00125,843.00143,015.00
Weighted Average Shares Outstanding (Diluted) 8,927.008,593.008,506.008,470.008,399.008,254.008,013.007,832.007,794.007,753.007,683.00
Gross Profit 50,089.0054,366.0056,193.0057,600.0059,899.0060,542.0052,540.0055,689.0072,007.0082,933.0096,937.00
Dividend per Share -----------
Operating Income 24,098.0027,161.0021,763.0026,764.0027,759.0018,161.0020,182.0022,326.0035,058.0042,959.0052,959.00
Gross Margin 0.800.780.760.740.690.650.620.620.650.660.68
Income Tax Expense 6,253.004,921.005,289.005,189.005,746.006,314.002,953.001,945.0019,903.004,448.008,755.00
EBIT Margin 0.430.430.340.390.380.260.310.350.410.430.46
Net Income 18,760.0023,150.0016,978.0021,863.0022,074.0012,193.0016,798.0021,204.0016,571.0039,240.0044,281.00
Cost of Revenue 12,395.0015,577.0017,530.0020,249.0026,934.0033,038.0032,780.0034,261.0038,353.0042,910.0046,078.00
Earnings Before Tax Margin 0.400.400.020.090.080.08-0.000.010.100.130.37
EBIT 24,098.0027,161.0021,763.0026,764.0027,759.0018,161.0020,182.0022,326.0035,058.0042,959.0052,959.00
EBITDA 26,771.0029,927.0024,730.0030,519.0032,971.0024,118.0026,804.0031,104.0045,319.0054,641.0065,755.00
Profit Margin 0.300.330.230.280.250.130.200.240.150.310.31
Operating Expenses 25,932.0027,205.0028,237.0030,836.0032,140.0042,381.0031,248.0033,057.0036,949.0039,974.0043,978.00
Earnings Per Share Basic 2.132.732.022.612.661.492.122.742.155.115.82
Earnings before Tax 25,013.0028,071.001,600.006,674.007,127.007,363.00-325.00453.0011,527.0015,799.0053,036.00
Interest Expense 151.00295.00380.00429.00597.00781.001,243.002,222.002,733.002,686.002,591.00

Balance Sheet Statement

Quarter data
Year 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010
Short-term debt 1,000.00-1,231.002,999.00-2,499.0012,904.001,049.003,998.005,516.003,749.00
Other Assets 9,255.0012,299.0011,296.0013,236.0038,146.0015,006.0014,073.0012,273.0015,990.0024,751.0024,856.00
Total current liabilities 26,147.0028,774.0032,688.0037,417.0045,625.0049,858.0059,357.0064,527.0058,488.0069,420.0072,310.00
Cash and cash equivalents 5,505.009,610.006,938.003,804.008,669.005,595.006,510.007,663.0011,946.0011,356.0013,576.00
Long-term debt 4,939.0011,921.0010,713.0012,601.0020,645.0027,808.0040,783.0076,073.0072,242.0066,662.0059,578.00
Cash and short-term investments 36,788.0052,772.0063,040.0077,022.0085,709.0096,526.00113,240.00132,981.00133,768.0011,356.00136,527.00
Total debt 5,939.0011,921.0011,944.0015,600.0020,645.0030,307.0040,783.0077,122.0076,240.0072,178.0063,327.00
Inventories 740.001,372.001,137.001,938.002,660.002,902.002,251.002,181.002,662.002,063.001,895.00
Deferred revenue 13,652.0015,722.0018,653.0020,639.0023,150.0023,223.0027,468.0034,102.0028,905.0032,676.0036,000.00
Goodwill and Intangible Assets 13,552.0013,325.0016,622.0017,738.0027,108.0021,774.0021,605.0045,228.0043,736.0049,776.0050,389.00
Total non-current liabilities 13,791.0022,847.0022,220.0026,070.0036,975.0046,282.0062,340.00104,165.0081,809.0079,006.0073,594.00
Total non-current assets 30,437.0033,786.0036,187.0040,965.0058,138.0051,511.0054,034.0081,235.0089,186.00111,004.00119,396.00
Total liabilities 39,938.0051,621.0054,908.0063,487.0082,600.0096,140.00121,697.00168,692.00176,130.00184,226.00183,007.00
Total assets 86,113.00108,704.00121,271.00142,431.00172,384.00176,223.00193,694.00241,086.00258,848.00286,556.00301,311.00
Other comprehensive income 53,133.0044,981.0055,138.0058,978.0060,127.0060,438.0060,370.0061,607.0063,546.0070,877.0072,981.00
Short-term investments 31,283.0043,162.0056,102.0073,218.0077,040.0090,931.00106,730.00125,318.00121,822.00122,463.00122,951.00
Property, Plant & Equipment Net 7,630.008,162.008,269.009,991.0013,011.0014,731.0018,356.0023,734.0029,460.0036,477.0044,151.00
Net Debt 434.002,311.005,006.0011,796.0011,976.0024,712.0034,273.0069,459.0064,294.0060,822.0049,751.00
Investments 39,037.0054,027.0056,102.0073,218.0077,040.0090,931.00106,730.00125,318.00121,822.00122,463.00125,916.00
Total shareholders equity 46,175.0057,083.0066,363.0078,944.0089,784.0080,083.0071,997.0072,394.0082,718.00102,330.00118,304.00
Retained earnings (deficit) -16,681.001,863.001,422.009,895.0017,710.009,096.002,282.002,648.0013,682.0024,150.0034,566.00
Long-term investments 7,754.0010,865.00--------2,965.00
Receivables 13,014.0014,987.0015,780.0017,486.0019,544.0017,908.0018,277.0019,792.0026,481.0029,524.0032,011.00
Payables 4,025.004,197.004,175.004,828.007,432.006,591.006,898.007,390.008,617.009,382.0012,530.00
Total current assets 55,676.0074,918.0085,084.00101,466.00114,246.00124,712.00139,660.00159,851.00169,662.00175,552.00181,915.00

Cash Flow Statement

Quarter data
Year 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010
Investing Cash Flow -11,314.00-14,616.00-24,890.00-23,819.00-18,972.00-23,074.00-24,017.00-46,762.00-6,011.00-15,888.00-12,223.00
Free Cash Flow 22,096.0024,639.0029,321.0024,576.0026,746.0023,136.0024,982.0031,378.0032,252.0038,260.0045,234.00
Depreciation & Amortization 2,673.002,766.002,967.003,755.005,212.005,957.006,622.008,778.0010,261.0011,682.0012,796.00
Net cash flow / Change in cash -571.004,105.00-2,672.00-3,134.004,865.00-3,074.00915.001,153.004,283.00-590.002,220.00
Effect of forex changes on cash -39.00103.00-104.00-8.00-139.00-73.00-67.0019.0050.00-115.00-201.00
Financing Cash Flow -13,291.00-8,376.00-9,408.00-8,148.00-8,394.00-9,080.00-8,393.008,408.00-33,590.00-36,887.00-46,031.00
Dividend payments -4,578.00-5,180.00-6,385.00-7,455.00-8,879.00-9,882.00-11,006.00-11,845.00-12,699.00-13,811.00-15,137.00
Stock-based compensation 1,891.002,166.002,244.002,406.002,446.002,574.002,668.003,266.003,940.004,652.005,289.00
Investment purchases -41,437.00-47,548.00-5,029.00-5,360.00-7,316.00-14,443.00-15,969.00-11,788.00-10,721.00-19,543.00-100,158.00
Acquisitions and disposals -245.00-71.00-10,112.00-1,584.00-5,937.00-3,723.00-1,393.00-25,944.00-888.00-2,388.00-2,521.00
Capital Expenditure 1,977.002,355.002,305.004,257.005,485.005,944.008,343.008,129.0011,632.0013,925.0015,441.00
Operating Cash Flow 24,073.0026,994.0031,626.0028,833.0032,231.0029,080.0033,325.0039,507.0043,884.0052,185.0060,675.00

Retained Earning Schedule

Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
Retained Earnings (Previous Year) --16,6811,8631,4229,89517,7109,0962,2822,64813,68224,150
Net Income 18,76023,15016,97821,86322,07412,19316,79821,20416,57139,24044,281
Stock Dividends -30,863574-11,034-5,935-5,380-10,925-12,606-8,9937,162-14,961-18,728
Dividend Paid -4,578-5,180-6,385-7,455-8,879-9,882-11,006-11,845-12,699-13,811-15,137
Retained Earnings -16,6811,8631,4229,89517,7109,0962,2822,64813,68224,15034,566

PPE Schedule

Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
Gross PPE 7,5357,6308,1628,2699,99113,01114,73118,35623,73429,46036,477
Annual Depreciation -1,882-1,823-2,198-2,535-2,465-4,224-4,718-2,751-5,906-6,908-7,767
Capital Expenditure 1,9772,3552,3054,2575,4855,9448,3438,12911,63213,92515,441
Net PPE 7,6308,1628,2699,99113,01114,73118,35623,73429,46036,47744,151

Intangible and Goodwill Schedule

Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
Intangible and Goodwill (Previous Year) 14,26213,55213,32516,62217,73827,10821,77421,60545,22843,73649,776
New Purchases -41,437-47,548-5,029-5,360-7,316-14,443-15,969-11,788-10,721-19,543-100,158
Intangible and Goodwill 13,55213,32516,62217,73827,10821,77421,60545,22843,73649,77650,389

About


Mr. Satya Nadella
Technology
SoftwareInfrastructure
Nasdaq Global Select

Microsoft Corporation develops, licenses, and supports software, services, devices, and solutions worldwide. Its Productivity and Business Processes segment offers Office, Exchange, SharePoint, Microsoft Teams, Office 365 Security and Compliance, and Skype for Business, as well as related Client Access Licenses (CAL); Skype, Outlook.com, and OneDrive; LinkedIn that includes Talent and marketing solutions, and subscriptions; and Dynamics 365, a set of cloud-based and on-premises business solutions for small and medium businesses, large organizations, and divisions of enterprises. Its Intelligent Cloud segment licenses SQL and Windows Servers, Visual Studio, System Center, and related CALs; GitHub that provides a collaboration platform and code hosting service for developers; and Azure, a cloud platform. It also provides support services and Microsoft consulting services to assist customers in developing, deploying, and managing Microsoft server and desktop solutions; and training and ce