Loading...

Financial Summary


Microsoft Corporation

Microsoft Corporation (MSFT)

Technology
Strong Buy
S
Market Info
Financial Info
Financial Modelling
Symbol MSFT
Price 137.95$
Beta 1.22
Volume Avrg. 31.78M
Market Cap 1,069.53B
Shares (2019) 7,753,000.00K
Last Div 1.84
Dividend Yield 1.30%
DCF Unlevered 85.52 Strong Sell
DCF Levered 84.96 Strong Sell
ROE 38.35% Strong Buy
ROA 26.16% Buy
Operating Margin 34.14% Strong Buy
Debt / Equity 76.58% Buy
P/E 26.55 Strong Buy
P/B 10.15 Strong Buy

Income Statement

Download MSFT income statement Download MSFT income statement
Year 20092010201120122013201420152016201720182019
Revenue 58,437.0062,484.0069,943.0073,723.0077,849.0086,833.0093,580.0091,154.0096,571.00110,360.00125,843.00
Cost of Revenue 12,155.0012,395.0015,577.0017,530.0020,385.0027,078.0033,038.0032,780.0034,261.0038,353.0042,910.00
Gross Profit 46,282.0050,089.0054,366.0056,193.0057,464.0059,755.0060,542.0058,374.0062,310.0072,007.0082,933.00
R&D Expenses 9,010.008,714.009,043.009,811.0010,411.0011,381.0012,046.0011,988.0013,037.0014,726.0016,876.00
Sales, General and Administrative Expense 16,909.0017,277.0018,162.0018,426.0020,289.0020,488.0020,324.0019,198.0019,942.0022,223.0023,098.00
Operating Expenses 25,919.0025,991.0027,205.0034,430.0030,700.0031,996.0042,381.0032,296.0033,285.0036,949.0039,974.00
Operating Income 20,363.0024,098.0027,161.0021,763.0026,764.0027,759.0018,161.0026,078.0029,025.0035,058.0042,959.00
Interest Expense -----------
Earnings before Tax 19,821.0025,013.0028,071.0022,267.0027,052.0027,820.0018,507.0025,639.0029,901.0036,474.0043,688.00
Income Tax Expense 5,252.006,253.004,921.005,289.005,189.005,746.006,314.005,100.004,412.0019,903.004,448.00
Net Income 14,569.0018,760.0023,150.0016,978.0021,863.0022,074.0012,193.0020,539.0025,489.0016,571.0039,240.00
Net Income - Non-Controlling int -----------
Net Income - Discounted ops -----------
Net Income Com 14,569.0018,760.0023,150.0016,978.0021,863.0022,074.0012,193.0020,539.0025,489.0016,571.0039,240.00
Preferred Dividends -----------
Earnings Per Share Basic 1.632.132.732.022.612.661.492.593.292.155.11
Earnings Per Share Diluted 1.622.102.692.002.582.631.482.563.252.135.06
Weighted Average Shares Outstanding 8,945.008,813.008,490.008,396.008,375.008,299.008,177.007,925.007,746.007,700.007,673.00
Weighted Average Shares Outstanding (Diluted) 8,996.008,927.008,593.008,506.008,470.008,399.008,254.008,013.007,832.007,794.007,753.00
Dividend per Share 0.000.000.000.000.000.000.000.000.000.000.00
Gross Margin 0.790.800.780.760.740.690.650.640.650.650.66
EBITDA Margin 0.380.440.440.340.400.380.260.350.400.420.44
EBIT Margin 0.340.400.400.300.350.320.200.280.310.330.35
Profit Margin 0.250.300.330.230.280.250.130.230.260.150.31
Free Cash Flow margin 0.000.000.000.000.000.000.000.000.000.000.00
EBITDA 22,383.0027,686.0030,837.0025,234.0030,807.0033,032.0024,464.0032,261.0038,679.0046,735.0055,370.00
EBIT 19,821.0025,013.0028,071.0022,267.0027,052.0027,820.0018,507.0025,639.0029,901.0036,474.0043,688.00
Consolidated Income 14,569.0018,760.0023,150.0016,978.0021,863.0022,074.0012,193.0020,539.0025,489.0016,571.0039,240.00
Earnings Before Tax Margin 0.340.400.400.300.350.320.200.280.310.330.35
Net Profit Margin 0.250.300.330.230.280.250.130.230.260.150.31

Balance Sheet Statement

Download MSFT income statement Download MSFT income statement
Year 20092010201120122013201420152016201720182019
Cash and cash equivalents 31,447.0036,788.0052,772.0063,040.0077,022.0085,709.0096,526.00113,240.00132,981.00133,768.00133,819.00
Short-term investments -----------
Cash and short-term investments 31,447.0036,788.0052,772.0063,040.0077,022.0085,709.0096,526.00113,240.00132,981.00133,768.00133,819.00
Receivables 11,192.0013,014.0014,987.0015,780.0017,486.0019,544.0017,908.0018,277.0022,431.0026,481.0029,524.00
Inventories 717.00740.001,372.001,137.001,938.002,660.002,902.002,251.002,181.002,662.002,063.00
Property, Plant & Equipment Net 7,535.007,630.008,162.008,269.009,991.0013,011.0014,731.0018,356.0030,289.0036,146.0043,856.00
Goodwill and Intangible Assets 14,262.0013,552.0013,325.0016,622.0017,738.0027,108.0021,774.0021,605.0045,228.0043,736.0049,776.00
Long-term investments 4,933.007,754.0010,865.009,776.0010,844.0014,597.0012,053.0010,431.006,023.001,862.002,649.00
Tax assets 2,492.002,184.002,467.002,035.001,632.001,941.00-----
Total non-current assets 11,296.0013,791.0022,847.0022,220.0026,070.0036,975.0044,742.0062,114.00106,856.00117,642.00114,806.00
Total current assets 28,608.0030,437.0033,786.0036,187.0040,965.0058,138.0051,675.0053,808.0087,616.0089,186.00111,004.00
Total assets 77,888.0086,113.00108,704.00121,271.00142,431.00172,384.00174,472.00193,468.00250,312.00258,848.00286,556.00
Payables 5,008.004,207.005,405.004,989.005,473.007,990.006,683.007,192.007,390.008,617.009,382.00
Short-term debt 2,000.001,000.00-1,231.002,999.002,000.007,484.0012,904.0010,121.003,998.005,516.00
Total current liabilities 27,034.0026,147.0028,774.0032,688.0037,417.0045,625.0049,647.0059,357.0055,745.0058,488.0069,420.00
Long-term debt 3,746.004,939.0011,921.0010,713.0012,601.0020,645.0027,808.0040,557.0081,445.0077,810.0072,850.00
Total debt 5,746.005,939.0011,921.0011,944.0015,600.0022,645.0035,292.0053,461.0091,566.0081,808.0078,366.00
Deferred revenue 14,284.0014,830.0017,120.0020,059.0022,399.0025,158.0025,318.0033,909.0026,656.0032,720.0037,206.00
Tax Liabilities 725.001,303.002,036.002,682.002,301.003,510.001,901.002,056.0019,937.0032,927.0035,510.00
Deposit Liabilities -----------
Total non-current liabilities 11,296.0013,791.0022,847.0022,220.0026,070.0036,975.0044,742.0062,114.00106,856.00117,642.00114,806.00
Total liabilities 38,330.0039,938.0051,621.0054,908.0063,487.0082,600.0094,389.00121,471.00162,601.00176,130.00184,226.00
Other comprehensive income ---1,422.001,743.003,708.002,522.001,537.00627.00-2,187.00-340.00
Retained earnings (deficit) -22,824.00-16,681.00-6,332.00-856.009,895.0017,710.009,096.002,282.0017,769.0013,682.0024,150.00
Total shareholders equity 39,558.0046,175.0057,083.0066,363.0078,944.0089,784.0080,083.0071,997.0087,711.0082,718.00102,330.00
Investments 4,933.007,754.0010,865.009,776.0010,844.0014,597.0012,053.0010,431.006,023.001,862.002,649.00
Net Debt -25,701.00-30,849.00-40,851.00-51,096.00-61,422.00-63,064.00-61,234.00-59,779.00-41,415.00-51,960.00-55,453.00
Other Assets 5,924.00-5,134.005,787.005,127.005,020.006,333.005,461.005,892.005,103.006,751.00
Other Liabilities 20,026.0020,940.0023,369.0026,468.0028,945.0035,635.0035,480.0039,261.0038,234.0045,873.0054,522.00

Cash Flow Statement

Download MSFT income statement Download MSFT income statement
Year 20092010201120122013201420152016201720182019
Depreciation & Amortization 2,562.002,673.002,766.002,967.003,755.005,212.005,957.006,622.008,778.0010,261.0011,682.00
Stock-based compensation 1,656.001,846.002,149.002,151.002,197.002,446.002,574.002,668.003,266.003,940.004,652.00
Operating Cash Flow 19,037.0024,073.0026,994.0031,626.0028,833.0032,502.0029,668.0033,325.0039,507.0043,884.0052,185.00
Capital Expenditure -3,119.00-1,977.00-2,355.00-2,305.00-4,257.00-5,485.00-5,944.00-8,343.00-8,129.00-11,632.00-13,925.00
Acquisitions and disposals -868.00-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
Investment purchases and sales -10,853.00-7,590.00-13,216.00-11,975.00-17,802.00-7,324.00-12,868.00-14,417.00-12,511.006,557.00540.00
Investing Cash Flow -----------
Insurance (repayment) of debt -----------
Insurance (buybacks) of shares -----------
Dividend payments -4,468.00-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
Financing Cash Flow -7,463.00-13,291.00-8,376.00-9,408.00-8,148.00-8,665.00-9,668.00-8,393.008,408.00-33,590.00-36,887.00
Effect of forex changes on cash -67.00-39.00103.00-104.00-8.00-139.00-73.00-67.0019.0050.00-115.00
Net cash flow / Change in cash -4,263.00-571.004,105.00-2,672.00-3,134.004,865.00-3,074.00915.001,153.004,283.00-590.00
Free Cash Flow 15,918.0022,096.0024,639.0029,321.0024,576.0027,017.0023,724.0024,982.0031,378.0032,252.0038,260.00
Net Cash/Marketcap 0.000.000.000.000.000.000.000.000.000.000.00

Retained Earning Schedule

Year 20092010201120122013201420152016201720182019
Retained Earnings (Previous Year) --22,824-16,681-6,332-8569,89517,7109,0962,28217,76913,682
Net Income 14,56918,76023,15016,97821,86322,07412,19320,53925,48916,57139,240
Stock Dividends -32,925-8,039-7,621-5,117-3,657-5,380-10,925-16,3471,843-7,959-14,961
Divident Paid -4,468-4,578-5,180-6,385-7,455-8,879-9,882-11,006-11,845-12,699-13,811
Retained Earnings -22,824-16,681-6,332-8569,89517,7109,0962,28217,76913,68224,150
Year 20092010201120122013201420152016201720182019
Gross PPE -7,5357,6308,1628,2699,99113,01114,73118,35630,28936,146
Annual Depreciation 10,6542,0722,8872,4125,9798,5057,66411,96820,06217,48921,635
Capital Expenditure -3,119-1,977-2,355-2,305-4,257-5,485-5,944-8,343-8,129-11,632-13,925
Net PPE 7,5357,6308,1628,2699,99113,01114,73118,35630,28936,14643,856

Intangible and Goodwill Schedule

Year 20092010201120122013201420152016201720182019
Intangible and Goodwill (Previous Year) -14,26213,55213,32516,62217,73827,10821,77421,60545,22843,736
New Purchases -10,853-7,590-13,216-11,975-17,802-7,324-12,868-14,417-12,5116,557540
Intangible and Goodwill 14,26213,55213,32516,62217,73827,10821,77421,60545,22843,73649,776
Microsoft Corporation

Microsoft Corporation (MSFT)

137.95
0.24 (+0.17%)

About


Satya Nadella
Technology
Application Software
Nasdaq Global Select

Microsoft Corp is a technology company. It develop, license, and support a wide range of software products and services. Its business is organized into three segments: Productivity and Business Processes, Intelligent Cloud, and More Personal Computing.