Balance Sheet Microsoft Corporation

Equities

MSFT

US5949181045

Software

Market Closed - Nasdaq Other stock markets 21:00:00 10/09/2024 BST			5-day change	1st Jan Change
414.20 ^USD	+2.09%		+1.16%	+10.15%

12:08am	Tech firms halve business travel in 2023 but Alphabet, Apple lag, study shows	RE
09-10	Tech firm executives to testify before US Senate about election threats, Axios reports	RE

f4929b665232060e9dbf8df67606349.XiYB24WIziY5EdQMZ8HNghWpoc0A60LAO5F-x0n5K6Q.F2dnmdLXr0JhUq1fBYaeunTejJ43hjOLdKUdhn-7RpY2SDi4z8-oQ208ow

Published financial data: MICROSOFT CORPORATION

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: June	2020	2021	2022	2023	2024
Revenues	143B	168B	198B	212B	245B
Total Revenues	143B	168B	198B	212B	245B
Cost of Goods Sold, Total	46.08B	52.23B	62.65B	65.71B	74.11B
Gross Profit	96.94B	116B	136B	146B	171B
Selling General & Admin Expenses, Total	24.71B	25.22B	27.72B	29.53B	32.06B
R&D Expenses	19.27B	20.72B	24.51B	27.2B	29.51B
Other Operating Expenses, Total	43.98B	45.94B	52.24B	56.73B	61.58B
Operating Income	52.96B	69.92B	83.38B	89.48B	109B
Interest Expense, Total	-2.59B	-2.33B	-2.05B	-2B	-2.98B
Interest And Investment Income	2.68B	2.13B	2.09B	2.99B	3.16B
Net Interest Expenses	89M	-199M	47M	999M	174M
Income (Loss) On Equity Invest.	-	-	-	-	-1.32B
Currency Exchange Gains (Loss)	-171M	133M	232M	169M	75M
Other Non Operating Income (Expenses)	127M	20M	-407M	-640M	-281M
EBT, Excl. Unusual Items	53B	69.87B	83.26B	90B	108B
Restructuring Charges	-	-	-	-952M	-
Merger & Related Restructuring Charges	-	-	-	-	-
Impairment of Goodwill	-	-	-	-	-
Gain (Loss) On Sale Of Investments	32M	1.23B	461M	260M	-295M
Asset Writedown	-	-	-	-	-
EBT, Incl. Unusual Items	53.04B	71.1B	83.72B	89.31B	108B
Income Tax Expense	8.76B	9.83B	10.98B	16.95B	19.65B
Earnings From Continuing Operations	44.28B	61.27B	72.74B	72.36B	88.14B
Net Income to Company	44.28B	61.27B	72.74B	72.36B	88.14B
Net Income - (IS)	44.28B	61.27B	72.74B	72.36B	88.14B
Net Income to Common Incl Extra Items	44.28B	61.27B	72.74B	72.36B	88.14B
Net Income to Common Excl. Extra Items	44.28B	61.27B	72.74B	72.36B	88.14B
Per Share Items
Net EPS - Basic	5.82	8.12	9.7	9.72	11.86
Basic EPS - Continuing Operations	5.82	8.12	9.7	9.72	11.86
Basic Weighted Average Shares Outstanding	7.61B	7.55B	7.5B	7.45B	7.43B
Net EPS - Diluted	5.76	8.05	9.65	9.68	11.8
Diluted EPS - Continuing Operations	5.76	8.05	9.65	9.68	11.8
Diluted Weighted Average Shares Outstanding	7.68B	7.61B	7.54B	7.47B	7.47B
Normalized Basic EPS	4.35	5.79	6.94	7.55	9.09
Normalized Diluted EPS	4.31	5.74	6.9	7.53	9.04
Dividend Per Share	2.04	2.24	2.48	2.72	3
Payout Ratio	34.18	26.96	24.93	27.36	24.7
American Depositary Receipts Ratio (ADR)	0.04	0.04	0.04	0.04	0.04
Supplemental Items
EBITDA	65.26B	80.82B	97.98B	103B	129B
EBITA	54.56B	71.52B	85.38B	91.98B	114B
EBIT	52.96B	69.92B	83.38B	89.48B	109B
EBITDAR	67.3B	82.94B	100B	106B	133B
Total Revenues (As Reported)	143B	168B	198B	212B	245B
Effective Tax Rate - (Ratio)	16.51	13.83	13.11	18.98	18.23
Current Domestic Taxes	4.3B	4.51B	10.01B	16.33B	14.53B
Current Foreign Taxes	4.44B	5.47B	6.67B	6.68B	9.86B
Total Current Taxes	8.74B	9.98B	16.68B	23.01B	24.39B
Deferred Domestic Taxes	52M	-179M	-5.88B	-6.62B	-5.17B
Deferred Foreign Taxes	-41M	29M	175M	564M	432M
Total Deferred Taxes	11M	-150M	-5.7B	-6.06B	-4.74B
Normalized Net Income	33.13B	43.67B	52.03B	56.25B	67.55B
Interest Capitalized	-	-	-	-	-
Interest on Long-Term Debt	336M	386M	429M	501M	734M
Supplemental Operating Expense Items
Advertising Expense	1.6B	1.5B	1.5B	904M	1.7B
Selling and Marketing Expenses	19.6B	20.12B	21.82B	22.76B	24.46B
General and Administrative Expenses	5.11B	5.11B	5.9B	6.78B	7.61B
Research And Development Expense From Footnotes	19.27B	20.72B	24.51B	27.2B	29.51B
Net Rental Expense, Total	2.04B	2.13B	2.46B	2.88B	3.56B
Imputed Operating Lease Interest Expense	502M	482M	502M	581M	957M
Imputed Operating Lease Depreciation	1.54B	1.64B	1.96B	2.29B	2.6B
Stock-Based Comp., Other (Total)	5.29B	6.12B	7.5B	9.61B	10.73B
Total Stock-Based Compensation	5.29B	6.12B	7.5B	9.61B	10.73B

Fiscal Period: June	2020	2021	2022	2023	2024
Assets
Cash And Equivalents	13.58B	14.22B	13.93B	34.7B	18.32B
Short Term Investments	123B	116B	90.82B	76.55B	57.22B
Total Cash And Short Term Investments	136B	130B	105B	111B	75.53B
Accounts Receivable, Total	32.01B	38.04B	44.26B	48.69B	56.92B
Other Receivables	-	-	-	9.2B	10.5B
Total Receivables	32.01B	38.04B	44.26B	57.89B	67.42B
Inventory	1.9B	2.64B	3.74B	2.5B	1.25B
Deferred Tax Assets Current	-	-	-	-	-
Other Current Assets, Total	11.52B	13.47B	16.93B	12.61B	15.53B
Total Current Assets	182B	184B	170B	184B	160B
Gross Property Plant And Equipment	96.1B	122B	147B	178B	231B
Accumulated Depreciation	-43.2B	-51.35B	-59.66B	-68.25B	-76.42B
Net Property Plant And Equipment	52.9B	70.8B	87.55B	110B	155B
Long-term Investments	2.96B	5.98B	6.89B	9.88B	14.6B
Goodwill	43.35B	49.71B	67.52B	67.89B	119B
Other Intangibles, Total	7.04B	7.8B	11.3B	9.37B	27.6B
Accounts Receivable Long-Term	2.7B	3.4B	3.8B	4.5B	4.9B
Deferred Tax Assets Long-Term	6.4B	7.18B	13.52B	20.16B	22.27B
Other Long-Term Assets, Total	4.03B	4.49B	4.58B	5.94B	9.29B
Total Assets	301B	334B	365B	412B	512B
Liabilities
Accounts Payable, Total	12.53B	15.16B	19B	18.1B	22B
Accrued Expenses, Total	7.87B	10.06B	10.66B	11.01B	12.56B
Short-term Borrowings	-	-	-	-	6.69B
Current Portion of Long-Term Debt	3.75B	8.07B	2.75B	5.25B	2.25B
Current Portion of Leases	2.16B	2.75B	3.29B	3.61B	5.93B
Current Income Taxes Payable	2.13B	2.17B	4.07B	4.15B	5.02B
Unearned Revenue Current, Total	36B	41.52B	45.54B	50.9B	57.58B
Deferred Tax Liability Current	-	-	-	-	-
Other Current Liabilities	7.87B	8.91B	9.78B	11.14B	13.26B
Total Current Liabilities	72.31B	88.66B	95.08B	104B	125B
Long-Term Debt	59.58B	50.07B	47.03B	41.99B	42.69B
Long-Term Leases	16.63B	21.38B	25.33B	28.6B	40.29B
Unearned Revenue Non Current	3.18B	2.62B	2.87B	2.91B	2.6B
Deferred Tax Liability Non Current	204M	198M	230M	433M	2.62B
Other Non Current Liabilities	31.11B	28.87B	27.75B	27.67B	30.2B
Total Liabilities	183B	192B	198B	206B	244B
Common Stock, Total	80.55B	83.11B	86.94B	93.72B	101B
Retained Earnings	34.57B	57.06B	84.28B	119B	173B
Comprehensive Income and Other	3.19B	1.82B	-4.68B	-6.34B	-5.59B
Total Common Equity	118B	142B	167B	206B	268B
Total Equity	118B	142B	167B	206B	268B
Total Liabilities And Equity	301B	334B	365B	412B	512B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	7.57B	7.51B	7.46B	7.43B	7.43B
ECS Total Common Shares Outstanding	7.57B	7.52B	7.46B	7.43B	7.43B
Book Value / Share	15.63	18.88	22.31	27.75	36.11
Tangible Book Value	67.92B	84.48B	87.72B	129B	122B
Tangible Book Value Per Share	8.97	11.24	11.75	17.35	16.37
Total Debt	82.11B	82.28B	78.4B	79.44B	97.85B
Net Debt	-54.38B	-47.98B	-26.35B	-31.82B	22.32B
Debt Equivalent Oper. Leases	16.34B	17.02B	19.69B	23B	28.44B
Account Code - Inventory Valuation	6	6	6	6	6
Inventories - Raw Materials, Total	700M	1.19B	1.14B	709M	394M
Inventories - Work In Process, Total	83M	79M	82M	23M	7M
Inventories - Finished Goods, Total	1.11B	1.37B	2.52B	1.77B	845M
Land - (BS)	1.82B	3.66B	4.73B	5.68B	8.16B
Buildings, Total	34B	43.93B	55.01B	68.46B	93.94B
Machinery, Total	46.04B	56.59B	66.49B	81.21B	100B
Full Time Employees	163K	181K	221K	221K	228K
Accumulated Allowance for Doubtful Accounts (Supple)	788M	751M	633M	650M	830M

Fiscal Period: June	2020	2021	2022	2023	2024
Net Income	44.28B	61.27B	72.74B	72.36B	88.14B
Depreciation & Amortization - CF	10.7B	9.3B	12.6B	11B	15.2B
Amortization of Goodwill and Intangible Assets - (CF)	1.6B	1.6B	2B	2.5B	4.8B
Depreciation & Amortization, Total	12.3B	10.9B	14.6B	13.5B	20B
Amortization of Deferred Charges, Total - (CF)	-	-	-	-	-
(Gain) Loss on Sale of Investments - (CF)	-219M	-1.25B	-409M	196M	305M
Asset Writedown & Restructuring Costs	-	-	-	-	-
Stock-Based Compensation (CF)	5.29B	6.12B	7.5B	9.61B	10.73B
Tax Benefit from Stock Options	-	-	-	-	-
Other Operating Activities, Total	507M	636M	-5.84B	-5.7B	-2.45B
Change In Accounts Receivable	-2.58B	-6.48B	-6.83B	-4.09B	-7.19B
Change In Inventories	168M	-737M	-1.12B	1.24B	1.28B
Change In Accounts Payable	3.02B	2.8B	2.94B	-2.72B	3.54B
Change in Unearned Revenues	2.21B	4.63B	5.11B	5.54B	5.35B
Change In Income Taxes	-3.63B	-2.31B	696M	-358M	1.69B
Change in Other Net Operating Assets	-673M	1.16B	-345M	-2B	-2.85B
Cash from Operations	60.68B	76.74B	89.04B	87.58B	119B
Capital Expenditure	-15.44B	-20.62B	-23.89B	-28.11B	-44.48B
Cash Acquisitions	-2.52B	-8.91B	-22.04B	-1.67B	-69.13B
Investment in Marketable and Equity Securities, Total	6.98B	2.88B	18.44B	10.21B	17.94B
Other Investing Activities, Total	-1.24B	-922M	-2.82B	-3.12B	-1.3B
Cash from Investing	-12.22B	-27.58B	-30.31B	-22.68B	-96.97B
Short Term Debt Issued, Total	-	-	-	-	5.25B
Long-Term Debt Issued, Total	-	-	-	-	24.4B
Total Debt Issued	-	-	-	-	29.64B
Short Term Debt Repaid, Total	-	-	-	-	-
Long-Term Debt Repaid, Total	-5.52B	-3.75B	-9.02B	-2.75B	-29.07B
Total Debt Repaid	-5.52B	-3.75B	-9.02B	-2.75B	-29.07B
Issuance of Common Stock	1.34B	1.69B	1.84B	1.87B	2B
Repurchase of Common Stock	-22.97B	-27.38B	-32.7B	-22.24B	-17.25B
Common Dividends Paid	-15.14B	-16.52B	-18.14B	-19.8B	-21.77B
Common & Preferred Stock Dividends Paid	-15.14B	-16.52B	-18.14B	-19.8B	-21.77B
Other Financing Activities, Total	-3.75B	-2.52B	-863M	-1.01B	-1.31B
Cash from Financing	-46.03B	-48.49B	-58.88B	-43.94B	-37.76B
Foreign Exchange Rate Adjustments	-201M	-29M	-141M	-194M	-210M
Net Change in Cash	2.22B	648M	-293M	20.77B	-16.39B
Supplemental Items
Cash Interest Paid	-	2B	1.9B	1.7B	1.7B
Cash Income Tax Paid (Refund)	12.5B	13.4B	16B	23.1B	23.4B
Levered Free Cash Flow	34.26B	41.34B	49.48B	47.86B	56.71B
Unlevered Free Cash Flow	35.88B	42.79B	50.76B	49.11B	58.57B
Change In Net Working Capital	-630M	-2.7B	-428M	1.82B	-3.92B
Net Debt Issued / Repaid	-5.52B	-3.75B	-9.02B	-2.75B	575M

Fiscal Period: June	2020	2021	2022	2023	2024
Profitability
Return on Assets	11.26	13.76	14.92	14.4	14.8
Return on Total Capital	17.01	20.58	22.21	21.08	20.98
Return On Equity %	40.14	47.08	47.15	38.82	37.13
Return on Common Equity	40.14	47.08	47.15	38.82	37.13
Margin Analysis
Gross Profit Margin %	67.78	68.93	68.4	68.99	69.76
SG&A Margin	17.28	15.01	13.98	13.94	13.08
EBITDA Margin %	45.63	48.08	49.42	48.59	52.8
EBITA Margin %	38.15	42.55	43.06	43.4	46.6
EBIT Margin %	37.03	41.59	42.06	42.22	44.64
Income From Continuing Operations Margin %	30.96	36.45	36.69	34.15	35.96
Net Income Margin %	30.96	36.45	36.69	34.15	35.96
Net Avail. For Common Margin %	30.96	36.45	36.69	34.15	35.96
Normalized Net Income Margin	23.16	25.98	26.24	26.54	27.56
Levered Free Cash Flow Margin	23.95	24.59	24.96	22.59	23.13
Unlevered Free Cash Flow Margin	25.09	25.46	25.6	23.17	23.89
Asset Turnover
Asset Turnover	0.49	0.53	0.57	0.55	0.53